Create Tool:
Create Time:1970-01-01 08:00:00
File Size:1196.59 MB
File Count:111
File Hash:75436bd1c4ddaed2d451fee6d0f7d939ad777942
| 01. Introduction/03. Understanding SQL.flv |
| 01. Introduction/05. SQL Server History.flv |
| 01. Introduction/04. Understanding TSQL.flv |
| 01. Introduction/06. Microsoft SQL Server Certifications.flv |
| 01. Introduction/02. Course Overview.flv |
| 01. Introduction/01. Welcome.flv |
| 02. Getting Set Up/02. Installing SQL Server 2012.flv |
| 02. Getting Set Up/04. Getting SQL Books Online Locally.flv |
| 02. Getting Set Up/03. Attaching the Sample Database.flv |
| 02. Getting Set Up/01. Getting SQL Server 2012.flv |
| 02. Getting Set Up/05. Code Examples.flv |
| 03. SQL Server 2012 Management Studio/04. Query Results Options.flv |
| 03. SQL Server 2012 Management Studio/03. SSMS Options.flv |
| 03. SQL Server 2012 Management Studio/05. Database Diagrams.flv |
| 03. SQL Server 2012 Management Studio/02. Graphical Queries.flv |
| 03. SQL Server 2012 Management Studio/01. SSMS Tour.flv |
| 04. Creating Database Objects/02. Creating a Table.flv |
| 04. Creating Database Objects/07. Creating Views pt. 2.flv |
| 04. Creating Database Objects/06. Creating Views pt. 1.flv |
| 04. Creating Database Objects/14. Creating Triggers.flv |
| 04. Creating Database Objects/03. Altering Tables.flv |
| 04. Creating Database Objects/10. Creating Constraints.flv |
| 04. Creating Database Objects/09. Understanding Constraints.flv |
| 04. Creating Database Objects/11. Understanding Triggers.flv |
| 04. Creating Database Objects/04. Dropping Tables.flv |
| 04. Creating Database Objects/05. Understanding Views.flv |
| 04. Creating Database Objects/12. Trigger Options.flv |
| 04. Creating Database Objects/01. Table Design Basics.flv |
| 04. Creating Database Objects/08. Dropping Views.flv |
| 04. Creating Database Objects/13. Inserted and Deleted Tables.flv |
| 05. Basic Select Queries/07. ORDER BY Example.flv |
| 05. Basic Select Queries/01. The Basic Select Statement.flv |
| 05. Basic Select Queries/09. The GROUP BY Clause pt. 2.flv |
| 05. Basic Select Queries/10. The HAVING Clause.flv |
| 05. Basic Select Queries/08. The GROUP BY Clause pt. 1.flv |
| 05. Basic Select Queries/02. Select Statement Structure.flv |
| 05. Basic Select Queries/05. WHERE Clause Example.flv |
| 05. Basic Select Queries/11. The Power of LIKE.flv |
| 05. Basic Select Queries/04. The WHERE Clause.flv |
| 05. Basic Select Queries/06. The ORDER BY Clause.flv |
| 05. Basic Select Queries/03. The FROM Clause.flv |
| 06. More Advanced Select Statements/10. The UNION Statement.flv |
| 06. More Advanced Select Statements/12. Using EXCEPT.flv |
| 06. More Advanced Select Statements/02. Column Aliasing.flv |
| 06. More Advanced Select Statements/08. Using the Case Statement.flv |
| 06. More Advanced Select Statements/11. Using INTERSECT.flv |
| 06. More Advanced Select Statements/05. Using the OFFSET-FETCH Option.flv |
| 06. More Advanced Select Statements/17. Dynamic Queries pt. 2.flv |
| 06. More Advanced Select Statements/04. Top Option Example.flv |
| 06. More Advanced Select Statements/01. Using Distinct.flv |
| 06. More Advanced Select Statements/07. Working with NULLs.flv |
| 06. More Advanced Select Statements/16. Dynamic Queries pt. 1.flv |
| 06. More Advanced Select Statements/09. SELECT INTO.flv |
| 06. More Advanced Select Statements/15. Using Concatenation.flv |
| 06. More Advanced Select Statements/18. INSERT Into.flv |
| 06. More Advanced Select Statements/06. Understanding NULLs.flv |
| 06. More Advanced Select Statements/03. Using the Top Option.flv |
| 06. More Advanced Select Statements/14. Creating and Using Synonyms.flv |
| 06. More Advanced Select Statements/13. Understanding Synonyms.flv |
| 07. SQL Server 2012 Data Types/04. Data Type Basics.flv |
| 07. SQL Server 2012 Data Types/03. Using GUIDs.flv |
| 07. SQL Server 2012 Data Types/01. Understanding GUIDs.flv |
| 07. SQL Server 2012 Data Types/02. NEWID() vs. NEWSEQUENTTIALID().flv |
| 07. SQL Server 2012 Data Types/05. Numerical Data Types.flv |
| 07. SQL Server 2012 Data Types/06. Character Data Types.flv |
| 07. SQL Server 2012 Data Types/07. Date and Time Data Types.flv |
| 07. SQL Server 2012 Data Types/08. Binary Data Types.flv |
| 08. Using Joins/06. The Merge Statement pt. 1.flv |
| 08. Using Joins/03. Inner Joins.flv |
| 08. Using Joins/07. The Merge Statement pt. 2.flv |
| 08. Using Joins/04. Outer Joins.flv |
| 08. Using Joins/05. Cross Joins.flv |
| 08. Using Joins/01. Understanding Joins.flv |
| 08. Using Joins/02. Table Aliasing.flv |
| 09. Querying Metadata/01. Catalog Views.flv |
| 09. Querying Metadata/03. System Stored Procedures.flv |
| 09. Querying Metadata/02. Information Schema Views.flv |
| 10. Inserts Updates Deletes/01. The Basic INSERT Statement.flv |
| 10. Inserts Updates Deletes/07. Using ROWCOUNT.flv |
| 10. Inserts Updates Deletes/02. INSERT Examples.flv |
| 10. Inserts Updates Deletes/04. UPDATE Examples.flv |
| 10. Inserts Updates Deletes/06. DELETE Examples.flv |
| 10. Inserts Updates Deletes/05. The Basic DELETE Statement.flv |
| 10. Inserts Updates Deletes/03. The Basic UPDATE Statement.flv |
| 11. Subqueries/03. Correlated Subqueries.flv |
| 11. Subqueries/02. Multi-Valued Subqueries.flv |
| 11. Subqueries/01. Scalar Subqueries.flv |
| 12. Table Expressions/06. Table Variables.flv |
| 12. Table Expressions/04. Using CTEs.flv |
| 12. Table Expressions/05. Understanding Temporary Tables.flv |
| 12. Table Expressions/02. Understanding Derived Tables.flv |
| 12. Table Expressions/01. Understanding Temporary Results Sets.flv |
| 12. Table Expressions/07. Temporary Table or Table Variable.flv |
| 12. Table Expressions/03. Understanding Common Table Expressions.flv |
| 13. Stored Procedures/03. Using Input Parameters.flv |
| 13. Stored Procedures/02. Creating a Stored Procedure.flv |
| 13. Stored Procedures/04. Stored Procedure Return Codes.flv |
| 13. Stored Procedures/01. Understanding Stored Procedures.flv |
| 13. Stored Procedures/05. Stored Procedure Permissions.flv |
| 14. Functions/05. Table Valued Functions Example pt. 2.flv |
| 14. Functions/03. Scalar Functions Example.flv |
| 14. Functions/04. Table Valued Functions Example pt. 1.flv |
| 14. Functions/02. Built-in Functions.flv |
| 14. Functions/01. Understanding Functions.flv |
| 15. Transactions/03. Coding Explicit Transactions.flv |
| 15. Transactions/04. Transactions and Locking.flv |
| 15. Transactions/02. Understanding Transactions.flv |
| 15. Transactions/01. Understanding Concurrency.flv |
| 16. Conclusion/01. Course Wrap Up.flv |
| 17. Credits/01. About the Author.flv |
| Workfiles/sqlserverquery70461.zip |
| dht://75436BD1 C4DDAED2 D451FEE6 D0F7D939 AD777942 |
TorrentBank
Copyright © 2024