Courses Offered :

Introduction

1. History Of Data Bases.
2. About My - SQL
3. Creating a Data Base
4. Modifying a Data Base
5. Basic My - SQL Queries
   
   Introduction to Data types in My-SQL
   
   
   • Creating a Table
   • Inserting data
   • Deleting rows
   • Modifying rows
   • Retrieving data using where Clause & group by having clauses
   • Sorting the date
   • Adding new columns using Alter
   • Commit & Rollback

6. Built-in- Function

• Types of Built-in Functions
• Numeric Functions
• String Functions
• Date and Time Functions
  

7. Sub Queries

• What is a Sub-Query
• Simple Sub- queries
• Sub- Queries using any & all
• Nested Sub- queries
• Sub-queries using group by clau

8. Joins

• Define a Join
• Types of Joins
• Queries using Joins
  

9.Views & Indexes

• What is a view
• Creating views
• What is an Index
• Creating Indexes
  

10.Advanced My-SQL

• Normalization
• Different Data Base in My-SQL
• E-R Diagrams
• Stored Procedure