course overview

Module 1

• An introduction to Database management systems

• An Introduction to RDBMS

• An Introduction to MySQL

• Installing MySQL

Module 2

• An Introduction to Database Designs

• An Introduction to Tables

• An Introduction to SQL Statements

• An Introduction to DDL Statements

Module 3

• Using MYSQL Workbench

• Data Server

• MYSQL/RDBMS Concepts

• An introduction to TCL Statements

• An Introduction to DML statements

• An Introduction to DQL

Module 4

• MySQL Users

• Selecting Users

• User Privileges

• Changing User Passwords

Module 5

• Creating Databases

• Creating Tables

• MySQL Data Types

• MySQL Clauses

• WHERE AND ORDER By Clause

• Retrieve Data from Single Tables

Module 6

• Constraints

• Indexes

• Select Statements

Module 7

• Group by Statements

• Joins

• Creating Views with Aggregate Functions

Module 8

• Subqueries

• An Introduction to Extraction Transformation and Loading (ETL) Processes

• NOSQL Databases