Mode Of 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.
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.
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, analysis and reporting services, mdx and excel data analysis.
SQL Server Specifications:
Sql server specifications.
System and Sample Databases:
- Diploma in SQL Server (Online Certification Courses) 02:00:00