New

MySQL Database Development Mastery

MySQL Database Development Mastery

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
Deal Score0
External links may contain affiliate links, meaning we get a commission if you decide to make a purchase