Post Description

0101 - What To Expect From This Course.mp4
0102 - Course Overview.mp4
0103 - Understanding Databases.mp4
0104 - Transact-SQL Basics.mp4
0105 - Microsoft SQL Certification.mp4
0106 - How To Access Your Working Files.mp4
0201 - SQL Server 2012 Evaluation.mp4
0202 - SQL Server 2012 Installation.mp4
0203 - Windows 8 Server 2012 Interface.mp4
0204 - Windows 7 Interface.mp4
0205 - SQL Server Sample Database.mp4
0206 - Attaching The Sample Database.mp4
0207 - Getting Help.mp4
0208 - Installing SQL Books Online.mp4
0301 - Management Studio Basics.mp4
0302 - Connecting To SQL Server.mp4
0303 - Customizing SSMS.mp4
0304 - Utilizing Diagrams.mp4
0305 - Saving Diagrams.mp4
0306 - Text And Graphical Tools.mp4
0307 - Using Sample Code Files.mp4
0308 - About The Semicolon.mp4
0401 - What Are Objects.mp4
0402 - Understanding Tables.mp4
0403 - Understanding Data Integrity.mp4
0404 - Understanding Data Types.mp4
0405 - Understanding Primary Keys.mp4
0406 - Understanding Constraints.mp4
0407 - Understanding NULL.mp4
0408 - Understanding Views.mp4
0409 - Understanding Stored Procedures.mp4
0410 - Understanding Triggers.mp4
0411 - Understanding Synonyms.mp4
0501 - Creating A Table.mp4
0502 - Graphical Table Creation.mp4
0503 - Changing A Table.mp4
0504 - Graphical Table Alterations.mp4
0505 - Deleting A Table.mp4
0506 - Graphical Table Deletion.mp4
0507 - Creating A Primary Key.mp4
0601 - Four Basic Queries.mp4
0602 - Thinking In SQL.mp4
0603 - Options And More Options.mp4
0604 - Good Query Structure.mp4
0605 - Comments.mp4
0606 - The USE Command.mp4
0607 - The GO Command.mp4
0701 - SELECT Basics.mp4
0702 - SELECT Structure.mp4
0703 - Using WHERE.mp4
0704 - Using TOP To Limit Rows.mp4
0705 - Ordering Results.mp4
0706 - Working With NULLs.mp4
0707 - T-SQL Concatenation.mp4
0801 - Column Aliasing.mp4
0802 - Using DISTINCT.mp4
0803 - Using SUM.mp4
0804 - Using AVG.mp4
0805 - Using COUNT.mp4
0806 - Using Group By.mp4
0808 - SELECT INTO.mp4
0809 - Using LIKE And IN.mp4
0810 - Understanding UNION.mp4
0811 - INTERSECT And EXCEPT.mp4
0812 - Using Synonyms - Part 1.mp4
0813 - Using Synonyms - Part 2.mp4
0814 - Offset-Fetch.mp4
0815 - What Is Ranking.mp4
0816 - Using Ranking.mp4
0817 - More Ranking Examples.mp4
0901 - Understanding Joins.mp4
0902 - Join Query Structure.mp4
0903 - Creating Inner Joins - Part 1.mp4
0904 - Creating Inner Joins - Part 2.mp4
0905 - Join Creation Through GUI.mp4
0906 - Creating Outer Joins.mp4
0907 - Creating Cross Joins.mp4
1001 - The INSERT Statement.mp4
1002 - Using INSERT - Part 1.mp4
1003 - Using INSERT - Part 2.mp4
1004 - The UPDATE Statement.mp4
1005 - Using UPDATE.mp4
1006 - The DELETE Statement.mp4
1101 - Understanding Subqueries.mp4
1102 - Subquery Versus Join.mp4
1103 - Creating A Scalar Subquery.mp4
1104 - Creating A Multi-Valued Subquery.mp4
1105 - Creating A Correlated Subquery.mp4
1201 - Utilizing Memory.mp4
1202 - What Is A Derived Table.mp4
1203 - Creating A Derived Table.mp4
1204 - Table Variables - Part 1.mp4
1205 - Table Variables - Part 2.mp4
1206 - Common Table Expressions.mp4
1207 - Temporary Tables.mp4
1301 - Programmability In T-SQL.mp4
1302 - What Is A Stored Procedure.mp4
1303 - Why Use Stored Procedures.mp4
1304 - A Simple Stored Procedure.mp4
1305 - Input Parameters.mp4
1306 - Multiple Input Parameters.mp4
1307 - Output Parameters - Part 1.mp4
1308 - Output Parameters - Part 2.mp4
1309 - Using Case Logic - Part 1.mp4
1310 - Using Case Logic - Part 2.mp4
1311 - Handling Errors.mp4
1312 - Stored Procedure Security.mp4
1313 - Working With Functions.mp4
1314 - Using Built-In Functions.mp4
1315 - Creating A Scalar Function.mp4
1316 - Creating A Table Valued Function.mp4
1317 - What Is Dynamic SQL.mp4
1318 - Dynamic SQL Example.mp4
1319 - Understanding GUIDs.mp4
1320 - GUID Examples - Part 1.mp4
1321 - GUID Examples - Part 2.mp4
1401 - Using Triggers.mp4
1402 - Inserted And Deleted Tables.mp4
1403 - Trigger Examples - Part 1.mp4
1404 - Trigger Examples - Part 2.mp4
1501 - What Are Transactions.mp4
1502 - Understanding Concurrency.mp4
1503 - Explicit And Implicit Transactions.mp4
1504 - Cross Platform Concerns.mp4
1505 - Transaction And Locking Example.mp4
1601 - Using Metadata.mp4
1602 - Using Catalog Views.mp4
1603 - Using Information Schema Views.mp4
1604 - Using System Stored Procedures.mp4
1701 - XML Basics.mp4
1702 - Outputting XML From Queries.mp4
1703 - Using FOR XML RAW.mp4
1704 - Using FOR XML AUTO.mp4
1705 - Using FOR XML PATH.mp4
1801 - Optimization Basics.mp4
1802 - Query Execution Plans - Part 1.mp4
1803 - Query Execution Plans - Part 2.mp4
1804 - SQL Server Extended Events - Part 1.mp4
1805 - SQL Server Extended Events - Part 2.mp4
1806 - SQL Server Profiler.mp4
1901 - Exam Basics.mp4
1902 - Taking Your Exam.mp4
1903 - When It Is Over.mp4
2001 - Wrap-Up.mp4
2002 - About The Author.mp4