Professional MySQL

SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database. Also, they are using different dialects, such as −MS SQL Server using T-SQL,Oracle using PL/SQL,MS Access version of SQL is called JET SQL (native format) etc.

Course Content:

• SQL – Home
• SQL – Overview
• SQL – RDBMS Concepts
• SQL – Databases
• SQL – Syntax
• SQL – Data Types
• SQL – Operators
• SQL – Expressions
• SQL – Create Database
• SQL – Drop Database
• SQL – Select Database
• SQL – Create Table
• SQL – Drop Table
• SQL – Insert Query
• SQL – Select Query
• SQL – Where Clause
• SQL – AND & OR Clauses
• SQL – Update Query
• SQL – Delete Query
• SQL – Like Clause
• SQL – Top Clause
• SQL – Order By
• SQL – Group By
• SQL – Distinct Keyword
• SQL – Sorting Results
• Advanced SQL
• SQL – Constraints
• SQL – Using Joins
• SQL – Unions Clause
• SQL – NULL Values
• SQL – Alias Syntax
• SQL – Indexes
• SQL – Alter Command
• SQL – Truncate Table
• SQL – Using Views
• SQL – Having Clause
• SQL – Transactions
• SQL – Wildcards
• SQL – Date Functions
• SQL – Temporary Tables
• SQL – Clone Tables
• SQL – Sub Queries
• SQL – Using Sequences
• SQL – Handling Duplicates
• SQL – Injection