Querying Microsoft SQL Server 2012 (Exam 70-461)
by Mark Long
Start the free chapterThe 2012 Microsoft MCSA Certification track includes Exam 70-461 Querying Microsoft SQL Server 2012. The ability to work with Transact-SQL and understand the specifics of querying Microsoft SQL server is a fundamental skill. This VTC course is intended for SQL Server database administrators, implementers, system engineers, and developers who are preparing to take the 70-461 exam as well as those who are just beginning to learn Transact-SQL. Mark Long is the instructor and will take you through the various tools and concepts needed to help you get ready for the 70-461 exam. To begin learning today, simply click on the movie links.
Course content
Introduction6 lessons
Getting Set Up5 lessons
SQL Server 2012 Management Studio5 lessons
Creating Database Objects14 lessons
- Table Design Basics3:541 credit or ad
- Creating a Table5:411 credit or ad
- Altering Tables6:091 credit or ad
- Dropping Tables4:211 credit or ad
- Understanding Views4:241 credit or ad
- Creating Views pt. 14:441 credit or ad
- Creating Views pt. 26:121 credit or ad
- Dropping Views2:401 credit or ad
- Understanding Constraints5:171 credit or ad
- Creating Constraints5:071 credit or ad
- Understanding Triggers5:001 credit or ad
- Trigger Options4:041 credit or ad
- Inserted and Deleted Tables2:551 credit or ad
- Creating Triggers5:401 credit or ad
Basic Select Queries11 lessons
- The Basic Select Statement6:431 credit or ad
- Select Statement Structure3:561 credit or ad
- The FROM Clause3:271 credit or ad
- The WHERE Clause4:231 credit or ad
- WHERE Clause Example4:321 credit or ad
- The ORDER BY Clause3:551 credit or ad
- ORDER BY Example5:221 credit or ad
- The GROUP BY Clause pt. 15:561 credit or ad
- The GROUP BY Clause pt. 25:461 credit or ad
- The HAVING Clause5:421 credit or ad
- The Power of LIKE4:031 credit or ad
More Advanced Select Statements18 lessons
- Using Distinct4:441 credit or ad
- Column Aliasing5:341 credit or ad
- Using the Top Option4:021 credit or ad
- Top Option Example5:011 credit or ad
- Using the OFFSET-FETCH Option5:021 credit or ad
- Understanding NULLs5:241 credit or ad
- Working with NULLs3:421 credit or ad
- Using the Case Statement5:291 credit or ad
- SELECT INTO3:271 credit or ad
- The UNION Statement5:561 credit or ad
- Using INTERSECT5:231 credit or ad
- Using EXCEPT6:181 credit or ad
- Understanding Synonyms3:211 credit or ad
- Creating and Using Synonyms2:381 credit or ad
- Using Concatenation4:001 credit or ad
- Dynamic Queries pt. 14:491 credit or ad
- Dynamic Queries pt. 25:551 credit or ad
- INSERT Into4:091 credit or ad
SQL Server 2012 Data Types8 lessons
- Understanding GUIDs5:501 credit or ad
- NEWID() vs. NEWSEQUENTTIALID()5:091 credit or ad
- Using GUIDs5:131 credit or ad
- Data Type Basics5:441 credit or ad
- Numerical Data Types4:501 credit or ad
- Character Data Types4:491 credit or ad
- Date and Time Data Types4:061 credit or ad
- Binary Data Types3:021 credit or ad
Using Joins7 lessons
Querying Metadata3 lessons
Inserts / Updates / Deletes7 lessons
Subqueries3 lessons
Table Expressions7 lessons
- Understanding Temporary Results Sets3:211 credit or ad
- Understanding Derived Tables4:221 credit or ad
- Understanding Common Table Expressions2:431 credit or ad
- Using CTEs4:151 credit or ad
- Understanding Temporary Tables4:321 credit or ad
- Table Variables5:291 credit or ad
- Temporary Table or Table Variable?2:481 credit or ad