Advanced SQL Development for MySQL/MariaDB (MYSQL3)

Databases, MySQL/MariaDB

This course covers advanced SQL development for MySQL/MariaDB, focusing on practical transactions, indexes and efficient query design. You will learn stored procedures, triggers and techniques to build reliable, scalable database applications.

Through hands-on labs and examples you will master ACID compliance, referential integrity and index tuning for better performance. The course also teaches writing reusable stored routines, debugging and deployment best practices.

Location, current course term

Contact us

Custom

Customized Training (date, location, content, duration)

The course:

Hide detail

• Transactions
1. Importance of transactions
2. ACID principles and how MySQL ensures them

• Referential integrity and cardinality
1. Importance of referential integrity
2. Ensuring referential integrity in MySQL
3. Relationships: 1:N, 1:1 and M:N

• Indexes and their effectiveness
1. Role and benefits of indexes
2. Creating indexes and choosing indexed columns
3. Index maintenance and considerations

• Programming in MySQL
1. Variables and expressions
2. Standard MySQL functions
3. String functions
4. Date and time functions

• Creating procedures
1. Overview and common uses
2. Procedure syntax and examples

• Creating triggers
1. Overview and typical use cases
2. Trigger syntax and practical examples

Assumed knowledge:

Basic knowledge equivalent to the MySQL1 course.

Recommended previous course:

MySQL/MariaDB - Introduction to SQL (MYSQL1)

Schedule:

2 days (9:00 AM - 5:00 PM )

Language: