MCSA/MCSE - Querying Microsoft SQL Server 2012/2014

Here's what you will get

Lessons
Lessons
8+
Quizzes
50+
Flashcards
50+
Glossary of terms
50+
Test prep
Pre-assessment Questions
50+
Full Length Tests
2+
Post-Assessment Questions
50+
Lab
Performance lab
Learn the real world skills using Live Labs.
43+

Here's what you will learn

  • About SQL Server 2012/2014
  • About Transact-SQL (T-SQL)
  • Creating Tables
  • Modifying Existing Tables
  • Understanding Indexes
  • Understanding Views
  • Summary
  • Creating and Modifying Constraints
  • Understanding Triggers
  • Modifying Triggers
  • Summary
  • Using SELECT Statements
  • Implementing Subqueries
  • Implementing Data Types
  • Implementing Aggregate Queries
  • Managing XML Data
  • Summary
  • Understanding Stored Procedures
  • Using DML Statements
  • Combining Datasets
  • Working with Functions
  • Summary
  • Tuning and Optimizing Queries
  • Managing Transactions
  • Evaluating Operations
  • Implementing Error Handling
  • Summary
  • Installing Microsoft SQL Server 2014 Management Studio
  • 70-461 Exam Objectives

Hands on Activities (Labs)

  • Creating a Table
  • Adding a New Column in a Table
  • Deleting a Column from a Table
  • Deleting a table 
  • Modifying a column in a table
  • Creating a Clustered Index
  • Creating a Non-Clustered Index
  • Deleting an Index
  • Creating a Filtered Index
  • Creating an Indexed View
  • Creating a View
  • Creating Primary Key Constraints
  • Creating Foreign Key Constraints
  • Creating a Unique Constraint
  • Dropping a Constraint
  • Create a DML Trigger
  • Creating a DDL Trigger
  • Using INSTEAD OF Trigger
  • Using Logical Operators
  • Using the SELECT statement
  • Retrieving Specific Columns
  • Using Calculated Columns
  • Limiting Rows
  • Using the LIKE Operator
  • Using the BETWEEN Clause
  • Using PIVOT Operator
  • Use Appropriate Data Types
  • Using Subqueries
  • Using Analytic Functions
  • Work with Ranking Functions
  • Using XML Data Type
  • Creating a Stored Procedure
  • Adding New Data
  • Updating a Record in a Table
  • Removing a Record from the Table
  • Combining Data Sets
  • Using User-Defined Functions
  • Displaying Estimated Execution Plan
  • Using SET STATISTICS IO
  • Using DECLARE and SET statement
  • Using BEGIN, COMMIT, and ROLLBACK TRANSACTION statements
  • Evaluating Operations
  • Implementing Error Handling
70-461-v2_pro 70-461-v2_pro
70-461-v2
MCSA/MCSE - Querying Microsoft SQL Server 2012/2014
ISBN : 9781644590348
Rating :
(16)