Subjects
Structured Learning Path

SQL Syllabus

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

1

SQL Introduction

1.1 About SQL Tutorial
1.2 SQL Basic Overview
1.3 Query Language
1.4 Microsoft SQL Server
1.5 MySQL
1.6 Oracle Database
2

SQL Database User

2.1 SQL*Plus
2.2 Connect with System User
2.3 Create a new Database User
2.4 Log into new User
3

SQL Database

3.1 Create Database
3.2 Delete or Drop Database
3.3 Use Database
3.4 Create Database in SQL Server
3.5 Rename Database
4

SQL Table

4.1 Create Table in SQL Server
4.2 Delete or Drop table
4.3 Insert Data into table
4.4 Select Distinct
4.5 Select Top
4.6 Where Clause
4.7 Aliases
4.8 Update Table
4.9 AND, OR, NOT
4.10 IN
4.11 Between
4.12 Order By
4.13 Group By
4.14 Having
4.15 Exists
4.16 ANY and ALL
4.17 CASE Statement
4.18 Select Into
4.19 Alter Table
4.20 Order of execution of a Query
4.21 Create table
5

SQL Constraints

5.1 Constraints Introduction
5.2 Not Null
5.3 Unique
5.4 Primary Key
5.5 Foreign Key
5.6 Check
5.7 Default
5.8 Index
5.9 Auto Increment Field
5.10 Cascading referential integrity constraint
5.11 Identity Column in SQL Server
6

SQL Keywords

6.1 Keywords Introduction
7

SQL Data Types

7.1 Data Types Introduction
8

SQL Operators

8.1 Operators Introduction
9

SQL Wildcard Characters

9.1 Wildcard Introduction
9.2 Like
10

SQL Joins

10.1 Joins Introduction
10.2 Inner Join
10.3 Left Join
10.4 Right Join
10.5 Full Join
10.6 Self Join
10.7 Union
10.8 Cross Join
10.9 Advanced Join
11

SQL Aggregate Function

11.1 Introduction
11.2 Min
11.3 Max
11.4 Count
11.5 Avg
11.6 Sum
12

SQL Views

12.1 Views Introduction
12.2 Advantages of View
12.3 Updateable Views
12.4 Limitations of views
13

SQL Dates

13.1 Dates Introduction
14

SQL Stored Procedures

14.1 Stored Procedures Introduction
14.2 Advantages of Stored Procedures
14.3 Simple Store Procedure
14.4 Stored procedure with input parameters
14.5 Stored Procedure with OUTPUT Parameters
14.6 Alter Procedure
15

SQL Functions

15.1 Functions Introduction
15.2 Table Valued Functions
15.3 Scalar Valued Functions
15.4 Stored Procedure VS Function
15.5 Multi-Statement Table Valued Functions
15.6 Function WITH ENCRYPTION
15.7 Function WITH SCHEMABINDING
16

String Functions in SQL Server

16.1 Ascii()
16.2 Char()
16.3 Ltrim()
16.4 Rtrim()
16.5 Lower()
16.6 Upper()
16.7 Reverse()
16.8 Len()
16.9 Left()
16.10 Right()
16.11 CharIndex()
16.12 SubString()
16.13 Function Real time Example
16.14 Replicate()
16.15 Space()
16.16 Patindex()
16.17 Replace()
16.18 Stuff()
17

SQL Server Date Functions

17.1 ISDATE()
17.2 DAY()
17.3 MONTH()
17.4 YEAR()
17.5 DATENAME()
17.6 DATEPART()
17.7 DATEADD ()
17.8 DATEDIFF()
17.9 Real time Example
18

Other Functions in SQL Server

18.1 Cast()
18.2 Convert()
19

Mathematical Functions in SQL Server

19.1 Mathematical Functions in SQL
20

Temporary tables

20.1 Local Temporary tables
20.2 Global Temporary tables
21

Indexes

21.1 Clustered Index
21.2 Non Clustered Index
21.3 Unique Index
21.4 Advantages and disadvantages of indexes
22

SQL Server Trigger

22.1 Triggers in SQL Server
22.2 After update trigger
22.3 Instead of insert trigger
22.4 Instead of update triggers
22.5 Instead of delete trigger
22.6 Common table expression (CTE)
23

Backup and Restore

23.1 Backup in SQL Server
23.2 Database Restore

SQL

Total Chapters
23
Total Subjects
126

Share This Question

Share this MCQ with your friends or study group.