70-461 Session 3: Querying Microsoft SQL Server 2012
MP4 | Video: 1280x720 | 59 kbps | 44 KHz | Duration: 4 Hours | 574 MB
Genre: eLearning | Language: English
Building on Sessions 1 and 2, we'll add constraints to data, store SELECT statements in views, and add triggers. Download
This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012".
In Session 1, we learned all about dates, strings and number data types, and in Session 2 we constructed SELECT queries using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and JOINing multiple tables together.
We'll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data.
http://www.nitroflare.com/view/EE91FF33C5C4AEF/70-461_Session_3_Querying_Microsoft_SQL_Server_2012.part2.rar
http://www.nitroflare.com/view/354EE7EB04FA062/70-461_Session_3_Querying_Microsoft_SQL_Server_2012.part3.rar
http://www.nitroflare.com/view/7708A169F87D8B9/70-461_Session_3_Querying_Microsoft_SQL_Server_2012.part4.rar
http://www.nitroflare.com/view/655D476BF51CA3E/70-461_Session_3_Querying_Microsoft_SQL_Server_2012.part5.rar
http://www.nitroflare.com/view/A5831284FC68426/70-461_Session_3_Querying_Microsoft_SQL_Server_2012.part6.rar
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.