Diploma in SQL Server


    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 Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.