Lesson 1: Getting Started with SQL Server 2012
Lesson 2: Working with T-SQL, Creating Queries and Constraints
Lesson 3: Writing SELECT Queries
Lesson 4: Working with SQL Data Types
Lesson 5: Sorting and Filtering Data
Lesson 6: Querying Data from Multiple Tables
Lesson 7: Modifying Data, Inserting Data
Lesson 8: Working with SQL Server Built-in Functions, Parse, Group By, Logical Functions
Lesson 9: Programming in T-SQL
Lesson 10: Implementing Stored Procedures, Dynamic SQL
Lesson 11: Working with Subqueries and Table Expressions
Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions
Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets
Lesson 14: Managing Error Handling and Transactions
Lesson 15: Querying SQL Server System, System Databases Part 1 to 4
Lesson 16: Optimizing Query Performance, Index Part 1 to 3
CBT Training Videos For Microsoft 70-461: Querying SQL Server 2012 and Test Preparation Quizzes
This course provides students with the technical skills required to be prepared for the 70-461 Querying SQL Server 2012 exam. Students will acquire the skills to write basic Transact-SQL queries for Microsoft SQL Server 2012, which is the foundation for all SQL Server-related disciplines; namely Database Administration, Database Development and Business Intelligence.
9 in stock
WorldITCenter expertise to optimize performance in every aspect of your organization. To succeed in today’s environment, businesses need to lead through increased complexity and volatility.
Address: 10 Burlington Mall Road #305, Burlington, MA 01803, USA.
+1 (781) 371-2346