PROFESSIONAL MYSQL

  • Home
  • PROFESSIONAL MYSQL

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 Overview

  • 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