Introducción
- 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
SQL
- 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
