SQL

Instructor

assurance

Course Overview

SQL (Structured Query Language) is a programming language which is used to manage data stored in relational databases like MySQL, MS Access, SQL Server, Oracle, Sybase, Informix, Postgres etc.

Our SQL tutorial helps you learn SQL (Structured Query Language) in simple and easy steps so that you can start your database programming quickly. It covers most of the important concepts related to SQL for a basic to advanced understanding of SQL and to get a feel of how SQL works.

Course Content

Introduction
- SQL Basic
- SQL - Overview
- SQL - RDBMS Concepts
- SQL - Databases
- SQL - Syntax
- SQL - Data Types
- SQL - Operators
- SQL - Expressions
SQL Database
- SQL - CREATE Database
- SQL - DROP Database
- SQL - SELECT Database, USE Statement
- SQL - Rename Database
- SQL - Show Databases
- SQL - Backup Database
SQL Table
- SQL - CREATE Table
- SQL - Show Tables (Listing Tables)
- SQL - Rename Table
- SQL - TRUNCATE TABLE
- SQL - Clone Tables
- SQL - Temporary Tables
- SQL - ALTER TABLE
- SQL - DROP Table
- SQL - Delete Table
- SQL - Constraints
SQL Queries
- SQL - INSERT Query
- SQL - SELECT Query
- SQL - Select Into Statement
- SQL - Insert Into... Select Statement
- SQL - UPDATE Query
- SQL - DELETE Query
- SQL - SORTING Results
SQL Views
- SQL - CREATE View
- SQL - UPDATE View
- SQL - DROP or DELETE View
- SQL - Rename View
- SQL - WHERE Clause
- SQL - TOP Clause
- SQL - DISTINCT Keyword
- SQL - ORDER BY Clause
- SQL - Group By Clause
- SQL - Having Clause
- SQL - AND and OR Conjunctive Operators
- SQL - BOOLEAN
- SQL - Like Operator
- SQL - IN Operator
- SQL - ANY, ALL Operators
- SQL - EXISTS Operator
- SQL - CASE
- SQL - NOT Operator
- SQL - NOT EQUAL
- SQL - IS NULL
- SQL - IS NOT NULL
- SQL - NOT NULL Constraint
- SQL - BETWEEN Operator
- SQL - UNION Operator
- SQL - UNION vs UNION ALL
- SQL - INTERSECT
- SQL - EXCEPT
- SQL - Alias Syntax
SQL Joins
- SQL - Using Joins
- SQL - Inner Join
- SQL - Left Join
- SQL - Right Join
- SQL - Cross Join
- SQL - Full Join
- SQL - Self Join
- SQL - DELETE JOIN
- SQL - UPDATE JOIN
- SQL - Left Join vs Right Join toggle
- SQL- UNION vs JOIN
SQL Keys
- SQL - Unique Key
- SQL - Primary Key
- SQL - Foreign Key
- SQL - Composite Key
- SQL - Alternate Key
SQL Indexes
- SQL - Indexes
- SQL - Create Index
- SQL - Drop Index
- SQL - Show Indexes
- SQL - Unique Indexes
- SQL - Clustered Index
- SQL - Non-Clustered Index
Advanced SQL
- SQL - Wildcards
- SQL - Comments
- SQL - Injection
- SQL - Hosting
- SQL - MIN() - MAX() function
- SQL - Null Functions
- SQL - Check Constraint
- SQL - Default Constraint
- SQL - Stored Procedures
- SQL - NULL Values
- SQL - Transactions toggle
- SQL - Sub Queries
- SQL - Handling Duplicates
- SQL - Using Sequences
- SQL - Auto Increment
- SQL - Date & Time
- SQL - Cursors
- SQL - Common Table Expression (CTE)
- SQL - Group By vs Order By
- SQL - IN vs EXISTS
- SQL - Database Tuning
SQL Function
- Date Functions
- SQL - String Functions
- SQL - Aggregate Functions
- SQL - Numeric Functions
- SQL - Text & Image functions
- SQL - Statistical Functions
- SQL - Logical Functions
- SQL - Cursor Functions
- SQL - JSON Functions
- SQL - Conversion Functions
- SQL - Datatype Functions

SQL

assurance

Course Overview

Course Content

SQL Basic

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, USE Statement

SQL - Rename Database

SQL - Show Databases

SQL - Backup Database

SQL - CREATE Table

SQL - Show Tables (Listing Tables)

SQL - Rename Table

SQL - TRUNCATE TABLE

SQL - Clone Tables

SQL - Temporary Tables

SQL - ALTER TABLE

SQL - DROP Table

SQL - Delete Table

SQL - Constraints

SQL - INSERT Query

SQL - SELECT Query

SQL - Select Into Statement

SQL - Insert Into... Select Statement

SQL - UPDATE Query

SQL - DELETE Query

SQL - SORTING Results

SQL - CREATE View

SQL - UPDATE View

SQL - DROP or DELETE View

SQL - Rename View

SQL - WHERE Clause

SQL - TOP Clause

SQL - DISTINCT Keyword

SQL - ORDER BY Clause

SQL - Group By Clause

SQL - Having Clause

SQL - AND and OR Conjunctive Operators

SQL - BOOLEAN

SQL - Like Operator

SQL - IN Operator

SQL - ANY, ALL Operators

SQL - EXISTS Operator

SQL - CASE

SQL - NOT Operator

SQL - NOT EQUAL

SQL - IS NULL

SQL - IS NOT NULL

SQL - NOT NULL Constraint

SQL - BETWEEN Operator

SQL - UNION Operator

SQL - UNION vs UNION ALL

SQL - INTERSECT

SQL - EXCEPT

SQL - Alias Syntax

SQL - Using Joins

SQL - Inner Join

SQL - Left Join

SQL - Right Join

SQL - Cross Join

SQL - Full Join

SQL - Self Join

SQL - DELETE JOIN

SQL - UPDATE JOIN

SQL - Left Join vs Right Join toggle

SQL- UNION vs JOIN

SQL - Unique Key

SQL - Primary Key

SQL - Foreign Key

SQL - Composite Key

SQL - Alternate Key

SQL - Indexes