You are here

Microsoft 70-461: Querying SQL Server 2012

Primary tabs

Resell This Course

Request A Demo

About Our Platform

About Our Courses

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

  • Hi would you mind sharing which blog platform you're working with? I'm planning to start my own blog soon but I'm having a tough time selecting between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I'm looking for something completely unique. P.S Apologies for getting off-topic but I had to ask! Feel free to visit my homepage :: ps4 games
  • Hi would you mind sharing which blog platform you're working with? I'm planning to start my own blog soon but I'm having a tough time selecting between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I'm looking for something completely unique. P.S Apologies for getting off-topic but I had to ask! Feel free to surf to my web blog - ps4 games
  • It's an awesome piece of writing for all the internet users; they will take advantage from it I am sure. Review my web site :: ps4 games
  • It's an awesome piece of writing for all the internet users; they will take advantage from it I am sure. Stop by my site; ps4 games
  • Hey just wanted to give you a quick heads up. The words in your post seem to be running off the screen in Chrome. I'm not sure if this is a format issue or something to do with internet browser compatibility but I thought I'd post to let you know. The design and style look great though! Hope you get the issue solved soon. Kudos Also visit my homepage :: ps4 games

Add New Discussion