Querying Microsoft SQL Server 2012 Exam 70 461 Course | 63F5FCBBC2EC0B5168A5DBDA72D8F60B4254E738

Querying Microsoft SQL Server 2012 Exam 70 461 Course

Name	Querying Microsoft SQL Server 2012 (Exam 70-461) Course	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.3 GB
Total Files	112
Hash	63F5FCBBC2EC0B5168A5DBDA72D8F60B4254E738

/01. Introduction/
01. Welcome.flv	1.9 MB
02. Course Overview.flv	5.4 MB
03. Understanding SQL.flv	7.7 MB
04. Understanding TSQL.flv	5.9 MB
05. SQL Server History.flv	7.1 MB
06. Microsoft SQL Server Certifications.flv	5.7 MB
/02. Getting Set Up/
01. Getting SQL Server 2012.flv	7.4 MB
02. Installing SQL Server 2012.flv	15.9 MB
03. Attaching the Sample Database.flv	8.6 MB
04. Getting SQL Books Online Locally.flv	9.5 MB
05. Code Examples.flv	2.7 MB
/03. SQL Server 2012 Management Studio/
01. SSMS Tour.flv	12.5 MB
02. Graphical Queries.flv	14.0 MB
03. SSMS Options.flv	15.3 MB
04. Query Results Options.flv	17.8 MB
05. Database Diagrams.flv	14.8 MB
/04. Creating Database Objects/
01. Table Design Basics.flv	7.2 MB
02. Creating a Table.flv	30.2 MB
03. Altering Tables.flv	13.8 MB
04. Dropping Tables.flv	8.1 MB
05. Understanding Views.flv	7.7 MB
06. Creating Views pt. 1.flv	15.1 MB
07. Creating Views pt. 2.flv	16.9 MB
08. Dropping Views.flv	6.1 MB
09. Understanding Constraints.flv	9.1 MB
10. Creating Constraints.flv	13.0 MB
11. Understanding Triggers.flv	8.9 MB
12. Trigger Options.flv	7.3 MB
13. Inserted and Deleted Tables.flv	5.2 MB
14. Creating Triggers.flv	14.1 MB
/05. Basic Select Queries/
01. The Basic Select Statement.flv	17.5 MB
02. Select Statement Structure.flv	13.7 MB
03. The FROM Clause.flv	5.9 MB
04. The WHERE Clause.flv	7.7 MB
05. WHERE Clause Example.flv	13.0 MB
06. The ORDER BY Clause.flv	6.8 MB
07. ORDER BY Example.flv	19.9 MB
08. The GROUP BY Clause pt. 1.flv	15.1 MB
09. The GROUP BY Clause pt. 2.flv	16.1 MB
10. The HAVING Clause.flv	15.6 MB
11. The Power of LIKE.flv	11.6 MB
/06. More Advanced Select Statements/
01. Using Distinct.flv	12.7 MB
02. Column Aliasing.flv	17.3 MB
03. Using the Top Option.flv	7.2 MB
04. Top Option Example.flv	12.8 MB
05. Using the OFFSET-FETCH Option.flv	15.9 MB
06. Understanding NULLs.flv	9.1 MB
07. Working with NULLs.flv	12.6 MB
08. Using the Case Statement.flv	16.9 MB
09. SELECT INTO.flv	11.2 MB
10. The UNION Statement.flv	18.4 MB
11. Using INTERSECT.flv	16.5 MB
12. Using EXCEPT.flv	17.6 MB
13. Understanding Synonyms.flv	5.9 MB
14. Creating and Using Synonyms.flv	7.1 MB
15. Using Concatenation.flv	11.1 MB
16. Dynamic Queries pt. 1.flv	11.6 MB
17. Dynamic Queries pt. 2.flv	15.2 MB
18. INSERT Into.flv	11.0 MB
/07. SQL Server 2012 Data Types/
01. Understanding GUIDs.flv	10.0 MB
02. NEWID() vs. NEWSEQUENTTIALID().flv	9.4 MB
03. Using GUIDs.flv	13.0 MB
04. Data Type Basics.flv	15.9 MB
05. Numerical Data Types.flv	8.0 MB
06. Character Data Types.flv	7.6 MB
07. Date and Time Data Types.flv	7.1 MB
08. Binary Data Types.flv	4.7 MB
/08. Using Joins/
01. Understanding Joins.flv	7.2 MB
02. Table Aliasing.flv	7.1 MB
03. Inner Joins.flv	23.1 MB
04. Outer Joins.flv	15.2 MB
05. Cross Joins.flv	12.6 MB
06. The Merge Statement pt. 1.flv	25.0 MB
07. The Merge Statement pt. 2.flv	16.5 MB
/09. Querying Metadata/
01. Catalog Views.flv	21.4 MB
02. Information Schema Views.flv	10.4 MB
03. System Stored Procedures.flv	18.5 MB
/10. Inserts Updates Deletes/
01. The Basic INSERT Statement.flv	18.0 MB
02. INSERT Examples.flv	12.0 MB
03. The Basic UPDATE Statement.flv	4.4 MB
04. UPDATE Examples.flv	10.7 MB
05. The Basic DELETE Statement.flv	5.1 MB
06. DELETE Examples.flv	8.8 MB
07. Using ROWCOUNT.flv	13.7 MB
/11. Subqueries/
01. Scalar Subqueries.flv	9.0 MB
02. Multi-Valued Subqueries.flv	13.1 MB
03. Correlated Subqueries.flv	13.9 MB
/12. Table Expressions/
01. Understanding Temporary Results Sets.flv	6.3 MB
02. Understanding Derived Tables.flv	9.1 MB
03. Understanding Common Table Expressions.flv	5.2 MB
04. Using CTEs.flv	12.7 MB
05. Understanding Temporary Tables.flv	9.4 MB
06. Table Variables.flv	12.8 MB
07. Temporary Table or Table Variable.flv	5.5 MB
/13. Stored Procedures/
01. Understanding Stored Procedures.flv	7.9 MB
02. Creating a Stored Procedure.flv	11.9 MB
03. Using Input Parameters.flv	16.2 MB
04. Stored Procedure Return Codes.flv	10.3 MB
05. Stored Procedure Permissions.flv	5.2 MB
/14. Functions/
01. Understanding Functions.flv	6.2 MB
02. Built-in Functions.flv	12.2 MB
03. Scalar Functions Example.flv	15.8 MB
04. Table Valued Functions Example pt. 1.flv	13.4 MB
05. Table Valued Functions Example pt. 2.flv	16.1 MB
/15. Transactions/
01. Understanding Concurrency.flv	6.7 MB
02. Understanding Transactions.flv	8.0 MB
03. Coding Explicit Transactions.flv	12.3 MB
04. Transactions and Locking.flv	11.7 MB
/16. Conclusion/
01. Course Wrap Up.flv	5.2 MB
/17. Credits/
01. About the Author.flv	3.9 MB
/
Torrent downloaded from demonoid.ph.txt	0.0 KB
/Workfiles/
sqlserverquery70461.zip	1.2 MB
Total files 112