MySQL/MariaDB – Introduction to SQL (MYSQL1)

Databases, MySQL/MariaDB

This course introduces participants to the MySQL database and the MariaDB branch, teaching core skills for writing SQL queries, creating and modifying tables, and understanding basic RDBMS concepts needed by developers and DBAs.

It covers MySQL installation, core SQL syntax and the gap between ANSI SQL and dialects, essential commands (SELECT, INSERT, UPDATE, DELETE), table design, joins, subqueries, referential integrity and storage engines.

Location, current course term

Contact us

Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • Introduction to MySQL
    1. RDBMS database systems
    2. The MySQL product, overview of other database servers
  • Installing MySQL
  • The SQL language
    1. Basic introduction and language structure
    2. ANSI SQL vs SQL dialects
  • Basic SQL commands
    1. SELECT
    2. INSERT
    3. UPDATE
    4. DELETE
  • Creating tables
    1. Data types
    2. NOT NULL constraint
  • Joining tables
    1. OUTER JOIN
    2. INNER JOIN, LEFT JOIN, RIGHT JOIN
  • Combining queries
    1. UNION, UNION ALL
    2. INTERSECT
    3. MINUS
  • Subqueries
    1. Advantages and disadvantages of subqueries
    2. Using EXISTS and NOT EXISTS subqueries
  • Referential integrity
  • MySQL-specific topics
    1. Storage engines, MyISAM, InnoDB
Assumed knowledge:
Basic user-level experience with any database.
Recommended subsequent course:
MySQL/MariaDB Administration (MYSQL2)
Schedule:
3 days (9:00 AM - 5:00 PM )
Language: