Najlepsze kursy internetowe w kategorii IT i oprogramowanie

[100% OFF] The Complete MySQL For Beginners | Worth 99,99$

[100% Free] The Complete MySQL For Beginners

The practical guide to become a MySQL master | MySQL From Scratch (Downloadable SQL Scripts Included).

What you'll learn?

  • Install MySQL Database Engine and MySQL Workbench.
  • Understand basics of cloud databases (DBAAS and Virtual Machines)
  • Create SQL Server instances on Microsoft Azure.
  • Create SQL Server instances on AWS (Amazon Web Services).
  • Connect MySQL Workbench to your cloud databases.
  • Create MySQL schema.
  • Create and manage users in database.
  • Work with Sakila database.
  • Create tables using MySQL Workbench.
  • Create tables using SQL script.
  • Learn different data types available in MySQL.
  • Learn how to apply different constraints.
  • Create primary keys, foreign keys and composite keys.
  • Design relational databases and create relationships between tables.
  • Understand and general ERD (Entity Relationship Diagram).
  • Import and Export data using MySQL Workbench.
  • Work with select statement.
  • Filter data using where clause.
  • Work with and, or, not operators.
  • Use like operator and wildcards.
  • Enhance your data selection using (In and between)
  • How to select distinct data only.
  • How to work with union and intersect, except operators.
  • Work with case statement.
  • Enhancing your data selection with sql subqueries.
  • Working with aggregate functions (Min, Max, Avg, Sum, Count)
  • Group table records using group by keyword.
  • Understand difference between where and having.
  • Filter grouped records using having keyword.
  • Integrating aggregate functions with group by and having keywords.
  • Understand what is DML and DDL.
  • Adding database new records using insert statement.
  • Deleting database records using delete statement.
  • Updating database records using update statement.
  • Build complex SQL queries with confident.
  • How to clone tables.

Aucun commentaire