• No products in the cart.

0

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.

4,001.00

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 Currilcum

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