Diploma in SQL Server

0 STUDENTS ENROLLED

    Mode Of Examination

    Online Examination

    Number Of Question: 100 (1 Marks Each)

    Total Time: 120 Min

    Syllabus

    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.

    Security:

    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

    N.A

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

    No Reviews found for this course.

    X