Structured Learning Path

SQL Syllabus

Explore all chapters and subchapters in a clear, organized format designed for better learning and faster navigation.

1

SQL Database User

1.1 SQL*Plus

1.2 Connect with System User

1.3 Create a new Database User

1.4 Log into new User

2

SQL Database

2.1 Create Database

2.2 Delete or Drop Database

2.3 Use Database

2.4 Create Database in SQL Server

2.5 Rename Database

3

SQL Table

3.1 Create Table in SQL Server

3.2 Delete or Drop table

3.3 Insert Data into table

3.4 Select Distinct

3.5 Select Top

3.6 Where Clause

3.7 Aliases

3.8 Update Table

3.9 AND, OR, NOT

3.10 IN

3.11 Between

3.12 Order By

3.13 Group By

3.14 Having

3.15 Exists

3.16 ANY and ALL

3.17 CASE Statement

3.18 Select Into

3.19 Alter Table

3.20 Order of execution of a Query

3.21 Create table

4

SQL Constraints

4.1 Constraints Introduction

4.2 Not Null

4.3 Unique

4.4 Primary Key

4.5 Foreign Key

4.6 Check

4.7 Default

4.8 Index

4.9 Auto Increment Field

4.10 Cascading referential integrity constraint

4.11 Identity Column in SQL Server

5

SQL Keywords

5.1 Keywords Introduction

6

SQL Data Types

6.1 Data Types Introduction

7

SQL Operators

7.1 Operators Introduction

8

SQL Wildcard Characters

8.1 Wildcard Introduction

8.2 Like

9

SQL Joins

9.1 Joins Introduction

9.2 Inner Join

9.3 Left Join

9.4 Right Join

9.5 Full Join

9.6 Self Join

9.7 Union

9.8 Cross Join

9.9 Advanced Join

10

SQL Aggregate Function

10.1 Introduction

10.2 Min

10.3 Max

10.4 Count

10.5 Avg

10.6 Sum

11

SQL Views

11.1 Views Introduction

11.2 Advantages of View

11.3 Updateable Views

11.4 Limitations of views

12

SQL Dates

12.1 Dates Introduction

13

SQL Stored Procedures

13.1 Stored Procedures Introduction

13.2 Advantages of Stored Procedures

13.3 Simple Store Procedure

13.4 Stored procedure with input parameters

13.5 Stored Procedure with OUTPUT Parameters

13.6 Alter Procedure

14

SQL Functions

14.1 Functions Introduction

14.2 Table Valued Functions

14.3 Scalar Valued Functions

14.4 Stored Procedure VS Function

14.5 Multi-Statement Table Valued Functions

14.6 Function WITH ENCRYPTION

14.7 Function WITH SCHEMABINDING

15

String Functions in SQL Server

15.1 Ascii()

15.2 Char()

15.3 Ltrim()

15.4 Rtrim()

15.5 Lower()

15.6 Upper()

15.7 Reverse()

15.8 Len()

15.9 Left()

15.10 Right()

15.11 CharIndex()

15.12 SubString()

15.13 Function Real time Example

15.14 Replicate()

15.15 Space()

15.16 Patindex()

15.17 Replace()

15.18 Stuff()

16

SQL Server Date Functions

16.1 ISDATE()

16.2 DAY()

16.3 MONTH()

16.4 YEAR()

16.5 DATENAME()

16.6 DATEPART()

16.7 DATEADD ()

16.8 DATEDIFF()

16.9 Real time Example

17

Other Functions in SQL Server

17.1 Cast()

17.2 Convert()

18

Mathematical Functions in SQL Server

18.1 Mathematical Functions in SQL

19

Temporary tables

19.1 Local Temporary tables

19.2 Global Temporary tables

20

Indexes

20.1 Clustered Index

20.2 Non Clustered Index

20.3 Unique Index

20.4 Advantages and disadvantages of indexes

21

SQL Server Trigger

21.1 Triggers in SQL Server

21.2 After update trigger

21.3 Instead of insert trigger

21.4 Instead of update triggers

21.5 Instead of delete trigger

21.6 Common table expression (CTE)

22

Backup and Restore

22.1 Backup in SQL Server

22.2 Database Restore

23

SQL Introduction

23.1 About SQL Tutorial

23.2 SQL Basic Overview

23.3 Query Language

23.4 Microsoft SQL Server

23.5 MySQL

23.6 Oracle Database

SQL

Total Chapters

23

Total Subjects

134