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

  • user_default

    Very great post. I just stumbled upon your weblog and wanted to mention that I have really enjoyed browsing your weblog posts. After all I'll be subscribing on your feed and I hope you write again soon! Here is my site - gamefly free trial
  • user_default

    Very great post. I just stumbled upon your weblog and wanted to mention that I have really enjoyed browsing your weblog posts. After all I'll be subscribing on your feed and I hope you write again soon! my site gamefly free trial
  • user_default

    I think this is one of the most significant information for me. And i am glad reading your article. But want to remark on few general things, The web site style is ideal, the articles is really nice : D. Good job, cheers Also visit my webpage; gamefly free trial
  • user_default

    I think this is one of the most significant information for me. And i am glad reading your article. But want to remark on few general things, The web site style is ideal, the articles is really nice : D. Good job, cheers Review my page; gamefly free trial
  • user_default

    I think what you published made a great deal of sense. However, what about this? what if you added a little content? I ain't saying your content isn't solid., however suppose you added something that makes people want more? I mean Microsoft 70-461: Querying SQL Server 2012 | XpertSkills is a little vanilla. You might look at Yahoo's home page and watch how they create post titles to grab viewers to open the links. You might add a related video or a picture or two to get people interested about what you've got to say. In my opinion, it would bring your website a little bit more interesting. Here is my page :: gamefly free trial