DATABASE SYSTEM DESIGNS TOOLS AND TECHNIQUES: MySQL

Content

 Core Database Concepts

• Database Concepts
• Data Manipulation Language (DML)
• Data definition Language (DDL)

Creating Database Objects

• Data Types
• Creating and Using Tables
• Creating Views
• Creating Stored Procedures

Manipulating Data

• Using Queries to Select Data
• Using Queries to Insert Data
• Updating data and Databases
• Deleting and Sorting Data

Data Storage

• Normalizing a Database
• Primary, Foreign and Composite Keys
• Clustered and Non-Clustered Indexes

SQL Query

• Fundamentals of SQL queries
• Accessing the Database with SQL queries

Administering a Database

• Ensuring Data Integrity
• Securing Databases
• Backup and Restoring Databases

FOR WHOM: Chief Information Officers, Database Administrators, IT Professionals, Systems Administrators, IT Managers and others who work in environments where databases play a key role in their primary job responsibilities or develop applications that deliver content from databases.

DATE:            7th – 9th May, 2025

                          5th – 7th November, 2025