COURSE DETAILS

• Basics of Database
• What is Database
• What is RDBMS (Relational Database Management System)
  
• Introduction SQL
• What is SQL Query
• Usage of SQL
• What you can do with SQL
  
• Introduction to MySQL
• Installation of MySQL
• User interface and various options in MySQL 
• Starts working with MySQL
• CREATE, ALTER and DROP Database
• CREATE, RENAME and DROP Table
• Data Types and Constraints
• Foreign Key Constraint
• Unique & Check Constraint
• Data Manipulation
• Insert Data to Table
• Update Data in a Table
• Delete Data
  
• Basic Statements
• Select Statements and Alias
• Where Clause and Operators
  
• Sorting and Grouping Data
• SORT BY Statements
• GROUP BY Statements
  
• Wild Card Operations
• LIKE Clause and its application
  
• IF-THEN Statements
• CASE Clause
  
• Conversion Functions
• CONVERT and CAST Function
• Concept of JOINS
• Inner Join, Left Join, Right Join, Full Join and Self Join
• Retrieve data from Multiple Tables
  
• Other Important Functions
• DATETIME Function
• STRING Function
• MATH Function
  
• Concept of Subqueries
• Subquery with SELECT Statement
• Single Row, Multiple Row Subqueries
• Insert, Update and Delete Statements