The Complete MySQL For Beginners
The practical guide to become a MySQL master | MySQL From Scratch (Downloadable SQL Scripts Included).
4.47 (202 reviews)
11,278
students
5.5 hours
content
Mar 2020
last update
$19.99
regular price
What you will 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.
Screenshots
Related Topics
1514234
udemy ID
1/17/2018
course created date
11/21/2019
course indexed date
Bot
course submited by