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

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.

Source: www.Udemy.com