• About this course
Database Concepts
  • What is a Database ?
  • What about Database Engines ?
  • TABLE Concepts
  • FIELD Concepts
  • INDEXES Concepts
MySQL Database
  • What is MySQL
  • Installing MySQL on my PC
  • Error while installing MySQL - Install XAMPP
  • Installing HeidiSQL on my PC
  • Connecting to the database server with HeidiSQL
  • Creating our first database
  • Creating tables and fields
  • Data types in MySQL and indexes
  • Download Trained Database
  • Importing data from an SQL file
  • Additional tools in HeidiSQL
  • Exporting data in HeidiSQL
  • Query Builder
Database normalization
  • The first normal form
  • The second normal form
  • The third normal form
  • Best practice: More tables, less columns
  • Best practice: More records, less columns
  • Best practices: Using default values
  • Best practices: Using status fields
  • Best practices: Use indexes for each meaningful field
  • Best practices: Summary tables
  • Introduction to the database language
  • Making queries (SELECT statement)
  • WHERE operator
  • Combining tables with WHERE
  • ORDER BY clause
  • Functions: SUM(), COUNT(), MAX(), AVG(), MIN()
  • GROUP BY clause
  • IN & NOT IN clause
  • BETWEEN clause
  • LIKE clause
  • INNER JOIN clause (combining tables)
  • LEFT, RIGHT, and FULL JOIN (combining tables)
  • Basic functions in MySQL
  • INSERT Statement
  • UPDATE Statement
  • DELETE Statement
SELECT exercises
  • Only one table exercises
  • Joining 2 or more tables
  • Looking for strings
  • Grouping, and addition joining many tables
Advanced HeidiSQL and MySQL Managed
  • Exporting queries
  • Saving SQL queries
  • Foreign keys and table relationships
  • Users management
MySQL Stored Procedures
  • Basic concepts about stored procedures in MySQL
  • Error managing
  • Cursors and conditionals
MySQL Triggers
  • Triggers in MySQL
MySQL Views
  • Views in MySQL
MySQL Transactions
  • Transactions in MySQL
MySQL Events
  • Events in MySQL
Good bye
  • Good bye