Introduction to SQL
(What is SQL? Purpose of SQL, Who should learn SQL?, What are the subsets of SQL?, Data Definition Language, Data Manipulation Language, Data Control Language, and SQL vs. NoSQL)
Data Definition Language (DDL)
Data Manipulation Language (DML)
Introduction
(What is a Database?, Database Objects, Database Tables, Table Records, Types of Database Management Systems, Relational Database Management Systems, and SQL/Relational Databases vs. No SQL Databases)
SQL Server Management Studio
Create a new Database
Queries
SQL Syntax
(Focus on SQL Syntax, SQL keywords, SQL is not case sensitive, SQL Comments, SQL Commands, and writing SQL Statements.)
CREATE TABLE
Database Modelling
Create Tables using the Designer Tools
SQL Constraints
PRIMARY KEY
FOREIGN KEY
NOT NULL / Required Columns
UNIQUE
CHECK
DEFAULT
AUTO INCREMENT or IDENTITY
ALTER TABLE
ALTER TABLE
INSERT INTO
UPDATE
DELETE
SELECT
The ORDER BY Keyword
SELECT DISTINCT
The WHERE Clause
Operators
LIKE Operator
IN Operator
BETWEEN Operators
Wildcards
AND & OR Operators
SELECT TOP Clause
Alias
Joins
Different SQL JOINs
SQL Data Types
(SQL Numeric data types, Date and Time data types, Character and String data types, Unicode character string data types, Binary data types, and miscellaneous data types.)
SQL Operators
(SQL Arithmetic Operators, Comparison Operators, Logical Operators, and Bitwise Operators)
SQL Expressions
(SQL Boolean Expression, SQL Numeric Expression, and SQL Date Expression)
SQL Comments
(SQL Comments, Comments are used to explain sections of SQL statements, or to prevent the execution of SQL statements. Single-Line Comments, and Multi-line Comments)
Single-line comment
Multiple-line comment
Variables
Built-in Global Variables
@@IDENTITY
Flow Control
IF – ELSE
WHILE
CASE
SQL – Data Definition Language Commands and Operations.
(SQL Data Definition Language Commands, Create, Alter, Drop, Truncate, and Rename.
Data Definition Language Operations, Create a Database, Use Database, Rename a Database, Drop Database, Create a Table, Rename Table, Add a Column to exiting Table, Add multiple columns to existing Table, Modify an existing column, Rename a Column, Drop a Column, Truncate a Table, and Drop a Table.)
SQL – Data Manipulation Language Commands and Operations
(Data Manipulation Language Commands, SELECT, INSERT, UPDATE, and DELETE.
Data Manipulation Language Operations, Retrieving data from a table, inserting data into a table, updating existing data into a table, and deleting all records from a table.)
SQL – Data Control Language Commands
DCL Operations
(Providing the users the access or privileges to the database objects, and Taking back or cancelling the privileges or permissions previously allowed or denied to the users.)
SQL Functions
Built-in Functions
String Functions
Date and Time Functions
Mathematics and Statistics Functions
AVG ()
COUNT ()
The GROUP BY Statement
The HAVING Clause
User-defined Functions.
SQL Queries and Sub Queries
SQL Joins
Dropping Constraints
Integrity Constraints
SQL ─ Using Joins
SQL – INNER JOIN
SQL ─ LEFT JOIN
SQL – RIGHT JOIN
SQL ─ FULL JOIN
SQL ─ SELF JOIN
SQL ─ CARTESIAN or CROSS JOIN
SQL ─ UNIONS CLAUSE
The UNION ALL Clause
SQL ─ INTERSECT Clause
SQL ─ EXCEPT Clause
SQL iv
SQL ─ NULL Values
SQL ─ Alias Syntax
SQL Views
SQL Transactions
SQL – Handling Duplicates
Case study and project implementations
apply all that you learned on a real industry project and get more hands on experience with better application understanding.