• 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-to-One, 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’ , ‘union’
• 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 behaviour
• Using memory- optimized tables

• Performance Tuning and Optimizing SQL Databases
• Querying Data with Transact-SQL