MySQL Database Development Mastery

Learn fundamental Database Development techniques with MySQL Server and MySQL Workbench

What You Will Learn:

Basic Database Design (Tables, Columns, Data Types, Primary Keys, Foreign Keys, Normalization)
How to Use install and MySQL Workbench
SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping)
DELETE: How to remove data from a database
INSERT INTO: How to insert data into a table
UPDATE: How to update existing data
Overall Database Development Best Practices
Creating Relationships and Foreign Keys
How to craft SQL statements based on real scenarios
How to export Query Results to Excel
Using Aggregate Functions in SQL
How to query related data from multiple tables

Who this Course is for:

Beginner Database Administrators
Database Developers who want to go to the next level
Those who work in organizations where the company typically uses MySQL databases.