My sql is a database management course. Use of MySQL “front-ends”, desktop software and web applications that create and manage MySQL databases, build database structures, back up data, inspect status, and work with data records. The official set of MySQL front-end tools, MySQL Workbench is actively developed by Oracle, and is freely available for use.


Experience in basic computer literacy with previous experience with command-line programs and some knowledge of database concepts is required. Some knowledge of data retrieval and reporting would be beneficial.

My SQL Course content

Relational Database Basics

» Brief History of SQL
» Relational Databases
» Tables
» Rows
» Columns
» Relationships
» Datatypes
» Primary Keys
» Foreign Keys
» Relational Database Management System
» Popular Databases
» Commercial Databases
» Popular Open Source Databases
» Valid Object References
» SQL Statements
» Database Manipulation Language (DML)
» Database Definition Language (DDL)
» Database Control Language (DCL)


» Introduction to the Northwind Database
» Some Basics
» Comments
» Whitespace and Semi-colons
» Case Sensitivity
» SELECTing All Columns in All Rows
» Exploring the Tables
» SELECTing Specific Columns
» Sorting Records
» Sorting By a Single Column
» Sorting By Multiple Columns
» Sorting By Column Position
» Ascending and Descending Sorts
» Sorting Results
» The WHERE Clause and Operator Symbols
» Checking for Equality
» Checking for Inequality
» Checking for Greater or Less Than
» Checking for NULL
» Using the WHERE clause to check for equality or inequality
» Using the WHERE clause to check for greater or less than
» Checking for NULL
» Using WHERE and ORDER BY Together
» The WHERE Clause and Operator Words
» The BETWEEN Operator
» The IN Operator
» The LIKE Operator
» The NOT Operator
» More SELECTs with WHERE
» Checking Multiple Conditions
» OR
» Order of Evaluation
» Writing SELECTs with Multiple Conditions

Advanced SELECTs

» Calculated Fields
» Concatenation
» Mathematical Calculations
» Aliases
» Calculating Fields
» Aggregate Functions and Grouping
» Aggregate Functions
» Grouping Data
» Selecting Distinct Records
» Working with Aggregate Functions
» Built-in Data Manipulation Functions
» Common Math Functions
» Common String Functions
» Common Date Functions
» Data Manipulation Functions

Subqueries, Joins and Unions

» Subqueries
» Joins
» Table Aliases
» Multi-table Joins
» Using Joins
» Outer Joins
» Unions
» UNION Rule
» Working with Unions

Conditional Processing with CASE

» Using CASE
» Working with CASE

Inserting, Updating and Deleting Records

» Inserting Records
» Updating and Deleting Records

Creating and Modifying Tables

» Data Types
» Creating Tables
» NULL Values
» Primary Keys
» Foreign Keys
» Creating Tables
» Adding and Dropping Columns
» Renaming Tables
» SQL Server
» Oracle and MySQL
» Dropping Tables


» Creating Views
» Dropping Views
» Benefits of Views
» Creating a View

Stored Procedures

» Creating Stored Procedures
» Dropping Stored Procedures
» Creating a Stored Procedure
» Benefits of Stored Procedures

Below you can find city wise My SQLInstitutes

My SQLtraining institutes in India
My SQLtraining institutes in Chennai
My SQLtraining institutes in Bangalore
My SQLtraining institutes in Mumbai
My SQLtraining institutes in Pune
My SQLtraining institutes in Delhi-NCR