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 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

Learn the SQL ALTER TABLE statement with syntax, practical examples, and step-by-step tutorials. Modify columns, add constraints, rename tables, and update database structures efficiently.

3.20 Order of execution of a Query
3.21 Create table

Learn how to create tables in SQL with a step-by-step guide. Understand the CREATE TABLE statement, syntax, data types, constraints, primary keys, and practical examples for beginners.

3.22 Practice Assignment: Working with Tables

Practice creating, modifying, and managing tables in MySQL with hands-on assignments covering CREATE, ALTER, RENAME, DROP, TRUNCATE, and table relationships.

3.23 Assignment Solution: Working with Tables

Explore step-by-step solutions for the Working with Tables in MySQL assignment, including CREATE, ALTER, RENAME, DROP, TRUNCATE, and table relationship exercises with explanations.

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 Structured Query Language (SQL)

Learn SQL Query Language and understand DDL, DML, DCL, and TCL commands with syntax, practical examples, real-world use cases, and key differences in MySQL.

23.4 Microsoft SQL Server
23.5 MySQL
23.6 Oracle Database

SQL

Total Chapters
23
Total Subjects
137

Share This Question

Share this MCQ with your friends or study group.