MySQL Database Development Mastery

By thegiantreport March 13, 2021 FreeUdemycourse 0 Comments

Share this post:

MySQL Database Development Mastery

Learn fundamental Database Development techniques with MySQL Server and MySQL Workbench

What you’ll 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