Courses

Course Description

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