Various types of databases

Introduction to Structured Query Language

Distinction between client server and file server databases

Understanding SQL Server Management Studio

SQL Table basics

Data types and functions

Transaction-SQL

Authentication for Windows

Data control language

The identification of the keywords in T-SQL, such as Drop Table

Entity-Relationship Model

Entity and Entity Set

Attributes and types of Attributes

Entity Sets

Relationship Sets

Degree of Relationship

Mapping Cardinalities, One-to-One, One-to-Many, Many-toone, Many-to-many

Symbols used in E-R Notation

Introduction to relational databases

Fundamental concepts of relational rows, tables, and columns

Several operators (such as logical and relational), constraints, domains, indexes, stored procedures, primary and foreign keys

Understanding group functions

The unique key

Advanced concepts of SQL tables

SQL functions

Operators & queries

Table creation

Data retrieval from tables

Combining rows from tables using inner, outer, cross, and self joins

Deploying operators such as ‘intersect,’‘except,

Temporary table creation

Set operator rules

Table variables

Understanding SQL functions what do they do?

Scalar functions

Aggregate functions

Functions that can be used on different datasets, such as numbers, characters, strings, and dates

Inline SQL functions

General functions

Duplicate functions

Understanding SQL subqueries, their rules

Statements and operators with which subqueries can be used

Using the set clause to modify subqueries

Understanding different types of subqueries, such as where, select, insert, update, delete, etc.

Methods to create and view subqueries

Learning SQL views

Methods of creating, using, altering, renaming, dropping, and modifying views

Understanding stored procedures and their key benefits

Working with stored procedures

Studying user-defined functions

Error handling

User-defined functions

Types of UDFs, such as scalar

Inline table value

Multi-statement table

Stored procedures and when to deploy them

What is rank function?

Triggers, and when to execute triggers?

Records grouping, advantages, searching, sorting, modifying data

Clustered indexes creation

Use of indexes to cover queries

Common table expressions

Index guidelines

Correlated Subquery, Grouping Sets, Rollup, Cube, Rank, CTE, Indexes And Triggers Correlated Subquery, Rollup, Grouping set And Cubes

Applying transactions

Using the transaction behavior to identify DML statements

Learning about implicit and explicit transactions

Isolation levels management

Understanding concurrency and locking behavior

Using memory-optimized tables

Creating Transact-SQL queries

Querying multiple tables using joins

Implementing functions and aggregating data

Modifying data

Determining the results of DDL statements on supplied tables and data

Constructing DML statements using the output statement

Querying data using subqueries and APPLY

Querying data using table expressions

Grouping and pivoting data using queries

Querying temporal data and non-relational data

Constructing recursive table expressions to meet business requirements

Using windowing functions to group

Rank the results of a query

Creating database programmability objects by using T-SQL

Implementing error handling and transactions

Implementing transaction control in conjunction with error handling in stored procedures

Implementing data types and NULL

Designing and implementing relational database schema

Designing and implementing indexes

Learning to compare between indexed and included columns

Implementing clustered index

Designing and deploying views

Column store views

Explaining foreign key constraints

Using T-SQL statements

Usage of Data Manipulation Language (DML)

Designing the components of stored procedures

Implementing input and output parameters

Applying error handling

Executing control logic in stored procedures

Designing trigger logic, DDL triggers, etc.

Accuracy of statistics

Formulating statistics maintenance tasks

Dynamic management objects management

Identifying missing indexes

Examining and troubleshooting query plan

Consolidating the overlapping indexes

The performance management of database instances

SQL server performance monitoring

Performance Tuning and Optimizing SQL Databases

Querying Data with Transact-SQL