MCSA SQL Server Querying Exam Objective

Module 01: Create database Objects

Module 02: Work with data

Module 03: Modify data

Module 04: Troubleshoot and Optimize

Detailed Syllabus:

Module 01: Create database Objects

Create and alter tables using T-SQL syntax
Create and alter views
Design views
Create and modify constraints
Create and alter DML triggers

Module 02: Work with data

Query data by using SELECT statements
Implement sub-queries
Implement data types
Implement aggregate queries
Query and manage XML data

Module 03: Modify data

Create and alter stored procedures
Modify data by using INSERT, UPDATE, and DELETE statements
Combine datasets
Work with functions

Module 04: Troubleshoot and Optimize

Optimize queries
Manage transactions
Evaluate the use of row-based operations vs. set-based operations
Implement error handling

If You Like What We Do Here On DatabaseConcept, You Should Consider:

Stay Connected to: Twitter | Facebook

Subscribe to our email updates: Sign Up Now

 

We are thankful for your support.