MySQL - Basic

Prerequisite: Basic Computer  Knowledge

Total No. of Hours: 10 

This course includes:

1. DATABASE CONCEPT- Introduction, File Based System, Introduction to Database Systems, Relational Database Model, The Relational Model Terminology, Brief History of MySQL, MySQL Database System, Starting MySQL, MySQL & SQL

2. STRUCTURED QUERY LANGUAGE- Introduction, SQL Command Syntax, Databases in MySQL, Creating Tables, Inserting data in Tables, Making Simple Select Queries (The SELECT Command Columns in a Query Result, Eliminating Redundant Data, ALL Keyword, Simple Calculations, Using Column Aliases, Handling Nulls, WHERE Clause, Reordering Relational Operators, Logical Operators, Condition based on a Range, Condition Based on a List, Conditions based on a Pattern Matching, Searching for NULL, Operator Precedence, ORDER BY Clause

3. MORE DML COMMANDS- Modifying Data with UPDATE Command, Deleting Data with DELETE Command

4. MORE DDL COMMANDS- ALTER TABLE Command, The DROP TABLE Command