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

  • prescription meds without the prescriptions viagra without doctor prescription amazon http://onlinepharmacyero.com/# cat antibiotics without pet prescription real viagra without a doctor prescription ambien without a doctor's prescription buy prescription drugs
  • acyclovir medication
  • We're a gaggle of volunteers and starting a new scheme in our community. Your web site provided us with helpful information to work on. You've done an impressive process and our entire neighborhood will likely be thankful to you. Check out my web site g
  • We're a gaggle of volunteers and starting a new scheme in our community. Your web site provided us with helpful information to work on. You've done an impressive process and our entire neighborhood will likely be thankful to you. Look into my webpage: g
  • buy robaxin baclofen rx proscar cost glucophage 750 mg amoxil 500mg cost

Add New Discussion