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
- Install MySQL Server
- Install MySQL Workbench
- Connect to an Instance
- Create a database
- Reverse Engineer Database into Data Models
- Forward Engineer Data Models into Databases
- Create Tables
- Run Queries against Tables
- General use of the MySQL Workbench
- Create Relationships
- Use Aggregate functions to do quick mathematical operations
- Export data to Excel using MySQL Workbench
- Practical use of SQL
Are there any course requirements or prerequisites?
- A Windows PC (or Windows running on a Virtual Machine if using Linux/Mac)
Who this course is for:
- This course is for beginners with absolutely no experience is database.
- This course is for you if you are already comfortable with basic database operations.
- This course is for you if you feel a bit ‘rusty’ and need to refresh your knowledge.
- This course is for you if you want to understand design principles in database development.
- This course is for you if you are looking to learn a new Database Management System
