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
Requirements
- A Reliable Computer
- A desire to learn database development