MODULE 2

MySQL Database

1. INTRODUCTION TO SQL:

+ Introduction to Database and Database management System
+ Overview of MYSQL, Installing and Getting started with MYSQL work Bench

2. SQL DATABASE

+ Creating Database Introduction to tables, Data Types in MYSQL

3. DATA DEFINITION LANGUAGE

+ Introduction DDL Commands, Database, Data Types, Tables, Constraints and Indexes, View

4. DATA MANIPULATION LANGUAGE:

Overview of MySQL SELECT statement, retrieving data, filtering, searching and sorting, joining and combining data, updating, adding and deleting data, inserting data, expressions, grouping and aggregate functions.

5. MYSQL FUNCTIONS AND JOINS:

MySQL built-in functions, inner, outer, and self joins, and combining data from multiple tables.

6. MYSQL SUBQUERIES:

Subqueries and nested queries, normalization and denormalization.

7. MYSQL STORED PROCEDURES AND TRIGGERS:

Creating and using stored procedures and triggers, introduction to stored procedures changing the delimiter, editing a stored procedure, variable scope, a data generating procedure, triggers, and transactions