FileMood

Download [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


Copyright © 2025 FileMood.com