MS SQL SERVER 2023

Syllabus covered 

Chapter 1 – Overview of SQL Server

Introduction to SQL Server

            Role of a Database Server

            SQL Server Elements and Components

            SQL Server Integration with .NET Framework

  Types of SQL Statements 

Chapter 2 – Querying data

Retrieving data

            Select all records from a table

            Selecting specific columns from a table

            Retrieving selected rows from a table

            User defined column headings

Use Functions to customize the Result Set

            Using String functions

            Using Conversion functions

            Using Date functions

            Using Mathematical functions

  Using Ranking functions

  Using Aggregate functions

Grouping the Result Set

Chapter 3 – Querying data by using Joins and Subqueries

Retrieving data by using Joins

            Using Inner join

            Using Outer join

            Using Cross join

Using Equi join

Using Self join

Querying Data by using Subqueries   

            Using IN and Exists keywords

            Using Aggregate functions

            Using Nested Subqueries

            Using Correlated Subqueries

            Using Apply operator

Managing result sets

Chapter 4 – Managing Database and Tables

Managing Databases

            Identifying system databases in SQL Server

            Database files

            Create a user defined database

Renaming a user defined database

Dropping a user defined database

Managing Tables        

            Create a table

            Implementing data integrity

            Creating synonyms

            Modifying a table

            Renaming a table

Dropping a table

Chapter 5 – Manipulating Data in Tables

Manipulating Data using DML statements

            Store data in a table

            Updating data in a table

            Deleting data from table

Comparing and Updating data

Dropping a user defined database

Chapter 6 – Implementing Indexes, Views

Creating and Managing Indexes

            Identifying types of indexes

            Creating indexes

            Dropping indexes

Creating and Managing Views

            Creating views

            Managing views

            Dropping views

Chapter 7 – Implementing Stored Procedures and Functions

Implementing Batches

            Creating batches

            Handling errors and exceptions

Implementing Stored Procedures

            Creating stored procedures

            Create parameterized stored procedures

            Returning values from stored procedures

            Calling a procedure from another stored procedures

Implementing User Defined Functions

            Creating functions

            Implementing cursors

Chapter 8 – Working with Triggers and Transactions

Implementing Triggers

            Creating triggers

            Managing triggers

Implementing Transactions

            Creating transaction

            Reverting transactions

            Resolving deadlocks