Microsoft 70-461: Querying SQL Server 2012

Select currency

Microsoft 70-461: Querying SQL Server 2012
Test scorm
Enquire Now

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The ability to work with Transact-SQL and understand the specifics of querying Microsoft SQL server is a fundamental skill. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.

Skills Learned

  • Work with Data
  • Query data by using SELECT statements.
  • Create Database Objects
  • Create and alter tables using T-SQL syntax (simple statements).
  • Create and...read more

Lesson 1: Getting Started with SQL Server 2012

Lesson 2: Working with T-SQL

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

Lesson 8: Working with SQL Server Built-in Functions

Lesson 9: Programming in T-SQL

Lesson 10: Implementing Stored Procedures

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

Lesson 16: Optimizing Query Performance

  • otlxlfvp (not verified)
    user_default
    1
    1
  • karinedeva
    user_default
    Microsoft 70-461: Querying SQL Server 2012 | iCollege
    Everything is very open with a precise description of the challenges. It was really informative. Your site is very helpful. Thank you for sharing! Look at my web site - Maglie Da Calcio
  • karinedeva
    user_default
    Add New Discussion | iCollege
    Everything is very open with a precise description of the challenges. It was really informative. Your site is very helpful. Thank you for sharing! My page ... Maglie Da Calcio
  • Marcia (not verified)
    user_default
    Microsoft 70-461: Querying SQL Server 2012 | iCollege
    I needed to thank you for this excellent read!! I absolutely loved every little bit of it. I've got you bookmarked to check out new things you post… Feel free to surf to my web blog; Jacqueline
  • Marcia (not verified)
    user_default
    Add New Discussion | iCollege
    I needed to thank you for this excellent read!! I absolutely loved every little bit of it. I've got you bookmarked to check out new things you post… Also visit my blog post ... Jacqueline