Pluralsight training net SQL Server Transact SQL Basic Data Retrieval

Pluralsight training net SQL Server Transact SQL Basic Data Retrieval

Name	[pluralsight-training.net] SQL Server - Transact-SQL Basic Data Retrieval	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	476.2 MB
Total Files	127
Hash	221212C00F221D97CB11C10C00C16E80D43CF27C

/1. Introduction/
1. Introduction.wmv	3.1 MB
2. Course Structure.wmv	2.4 MB
/2. Setting Up a Transact-SQL Learning Environment/
1. Introduction.wmv	1.5 MB
10. Demo - Installing SSDT.wmv	6.1 MB
11. AdventureWorks Sample Database.wmv	946.1 KB
12. Demo - Attaching the AdventureWorks Sample Database.wmv	10.8 MB
13. Basic Data Retrieval.wmv	1.1 MB
14. Demo - Execute a Data Retrieval Query in SSMS.wmv	6.6 MB
15. Demo - Execute a Data Retrieval Query in SSDT.wmv	6.3 MB
2. SQL Server 2012 Express with Tools.wmv	1.5 MB
3. SQL Server 2012 Express Abridged Requirements.wmv	2.8 MB
4. Demo - Checking Hardware and OS Specifications.wmv	4.6 MB
5. Demo - Checking .NET 3.5 SP1 Prerequisites.wmv	3.7 MB
6. Demo - Installing SQL Server 2012 Express with Tools.wmv	12.5 MB
7. SQL Server Management Studio (SSMS).wmv	1.3 MB
8. Demo - Using SSMS.wmv	6.7 MB
9. SQL Server Data Tools (SSDT).wmv	2.1 MB
/3. Writing a Basic SELECT Statement/
1. Introduction.wmv	1.8 MB
10. Semicolon Statement Terminator.wmv	807.9 KB
11. FROM Clause.wmv	1.1 MB
12. Demo - FROM Clause.wmv	8.0 MB
13. Table Aliases.wmv	1.3 MB
14. Demo - Table Aliases.wmv	3.4 MB
15. Expressions, Operators, Predicates.wmv	1.1 MB
16. WHERE Clause.wmv	1.1 MB
17. Demo - WHERE Clause.wmv	10.0 MB
18. DISTINCT.wmv	834.9 KB
19. Demo - DISTINCT.wmv	6.9 MB
2. Thinking in 'Sets'.wmv	1.7 MB
20. TOP.wmv	1.8 MB
21. Demo - TOP.wmv	4.9 MB
22. GROUP BY Clause.wmv	892.0 KB
23. Demo - GROUP BY Clause.wmv	8.1 MB
24. HAVING Clause.wmv	822.9 KB
25. Demo - HAVING Clause.wmv	7.3 MB
26. ORDER BY Clause.wmv	1.4 MB
27. Demo - ORDER BY Clause.wmv	4.9 MB
28. Query Paging.wmv	1.3 MB
29. Demo - Query Paging.wmv	3.9 MB
3. Where to Begin.wmv	813.9 KB
30. Binding Order.wmv	750.8 KB
31. Demo - Binding Order.wmv	3.4 MB
32. Best Practice - Commenting Your Code.wmv	1.6 MB
33. Demo - Commenting Your Code.wmv	2.3 MB
4. SELECT Clause.wmv	1.7 MB
5. Demo - SELECT Clause.wmv	6.2 MB
6. Column Aliases.wmv	1.1 MB
7. Demo - Column Aliases.wmv	3.3 MB
8. Identifiers.wmv	1.3 MB
9. Demo - Regular versus Delimited Identifiers.wmv	5.3 MB
/4. Querying Multiple Data Sources/
1. Introduction.wmv	1.3 MB
10. Demo - Self Joins.wmv	4.1 MB
11. Equi vs. Non-Equi Joins.wmv	931.1 KB
12. Demo - Equi vs. Non-Equi Joins.wmv	3.8 MB
13. Multi-Attribute Joins.wmv	456.3 KB
14. Demo - Multi-Attribute Joins.wmv	9.0 MB
15. Joining More than Two Tables.wmv	925.0 KB
16. Demo - Joining More than Two Tables.wmv	10.8 MB
17. CROSS APPLY Operator.wmv	1.0 MB
18. Demo - CROSS APPLY and OUTER APPLY Operator.wmv	9.4 MB
19. Joining Sub-Queries.wmv	363.2 KB
2. Inner Joins.wmv	1.3 MB
20. Defining the Sub-Query.wmv	1.1 MB
21. Demo - Using Sub-Queries.wmv	7.1 MB
22. UNION Operator.wmv	1.8 MB
23. Demo - UNION Operator.wmv	10.0 MB
24. INTERSECT and EXCEPT.wmv	1.2 MB
25. Demo - INTERSECT and EXCEPT Operators.wmv	10.9 MB
26. Data Types and Joining Tables.wmv	1.7 MB
27. Introduction to Common Table Expressions.wmv	840.9 KB
28. Demo - Introduction to Common Table Expressions.wmv	9.4 MB
3. Demo - Inner Joins.wmv	7.3 MB
4. Outer Joins.wmv	1.6 MB
5. Outer Joins (2).wmv	862.0 KB
6. Demo - Outer Joins.wmv	12.8 MB
7. Cross Joins.wmv	868.0 KB
8. Demo - Cross Joins.wmv	5.0 MB
9. Self Joins.wmv	711.7 KB
/5. Using Functions/
1. Introduction.wmv	1.0 MB
10. Demo - Ranking Functions.wmv	13.8 MB
11. Conversion Functions.wmv	1.7 MB
12. Demo - Conversion Functions.wmv	9.0 MB
13. Validating Data Types.wmv	477.3 KB
14. Demo - Validating Data Types.wmv	3.3 MB
15. System Time Functions.wmv	1.4 MB
16. Demo - System Time Functions.wmv	2.7 MB
17. Returning Date and Time Parts.wmv	1.2 MB
18. Demo - Returning Date and Time Parts.wmv	5.2 MB
19. Constructing Date and Time Values.wmv	895.0 KB
2. Aggregate Functions.wmv	1.6 MB
20. Demo - Constructing Date and Time Values.wmv	2.6 MB
21. Constructing Date and Time Values (2).wmv	663.6 KB
22. Demo - Constructing Date and Time Values (2).wmv	3.1 MB
23. Calculating Time Differences.wmv	618.6 KB
24. Demo - Calculating Time Differences.wmv	3.5 MB
25. Modifying Dates.wmv	1.1 MB
26. Demo - Modifying Dates.wmv	8.8 MB
27. Logical Functions.wmv	1.0 MB
28. Demo - Logical Functions.wmv	3.3 MB
29. Logical Functions (2).wmv	690.7 KB
3. Demo - Aggregate Functions.wmv	16.2 MB
30. Demo - Logical Functions (2).wmv	5.6 MB
31. Working with NULL.wmv	1.1 MB
32. Demo - Working with NULL.wmv	5.1 MB
33. String Functions.wmv	886.0 KB
34. Demo - String Functions.wmv	2.8 MB
35. String Functions (2).wmv	1.0 MB
36. Demo - String Functions (2).wmv	4.1 MB
37. String Functions (3).wmv	708.7 KB
38. Demo - String Functions (3).wmv	1.6 MB
39. String Functions (4).wmv	516.4 KB
4. Aggregate Functions (2).wmv	1.3 MB
40. Demo - String Functions (4).wmv	1.8 MB
41. String Functions (5).wmv	1.3 MB
42. Demo - String Functions (5).wmv	13.0 MB
43. String Functions (6).wmv	1.3 MB
44. Demo - String Functions (6).wmv	7.4 MB
45. Analytic Functions.wmv	973.1 KB
46. Demo - Analytic Functions.wmv	16.3 MB
47. Analytic Functions (2).wmv	1.7 MB
48. Demo - Analytic Functions (2).wmv	14.2 MB
49. Course Summary.wmv	988.2 KB
5. Demo - Aggregate Functions (2).wmv	4.8 MB
6. Mathematical Functions.wmv	1.7 MB
7. Demo - Mathematical Functions.wmv	8.2 MB
8. OVER Clause.wmv	898.0 KB
9. Ranking Functions.wmv	1.3 MB
Total files 127