• No products in the cart.


SQL Server is a relational database management system developed by Microsoft.
As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.


Mode Of Examination

Online Examination

Number Of Question: 100 (1 Marks Each)

Total Time: 120 Min


Laying the Foundation:

Sql server basics, management studio, data types, built in functions, joins, views, data aggregation and powershell.

Manipulating Data with Select:

Windowing, ranking, subqueries, data modification and constraints.

Beyond Relational:

Hierarchies, xml data working, xquery and full text search.

Physical Database Schema:

Data definition language.

Developing with SQL Server:

Transact sql, procedural flow, variables, cursor, error handling, stored procedures and builtin stored procedures, user defined functions, dml and ddl triggers, dynamic sql and sql injection.

Data Connectivity:

Bulk operations, distributed queries, ado.net, linq, service broker, replication, integration services and sql server access.

Enterprise Data Management:

Enterprise data management, policy based management, recovery, backup, database maintenance, sql server agent, transferring database, database snapshots, log shipping, database mirroring and clustering.


Authentication, securables, data cryptography and row level security.

Monitoring and Auditing:

Data and schema audit, performance monitoring, profiling, wait states, extended events, change tracking and data capture, sql audit and management data warehouse.

Performance Tuning and Optimization:

Query execution plan, indexing strategies, query plan reuse, transactions, locking and blocking, transaction log, data compression, partitioning and resource governor.

Business Intelligence:

Business intelligence, analysis and reporting services, mdx and excel data analysis.

SQL Server Specifications:

Sql server specifications.

System and Sample Databases:

System databases.

Course Currilcum

                • Diploma in SQL Server (Online Certification Courses) 02:00:00
              © All rights reserved
              Open chat