589689.xyz

[] SQL Server - Transact-SQL Basic Data Retrieval

  • 收录时间:2018-03-18 03:51:33
  • 文件大小:454MB
  • 下载次数:85
  • 最近下载:2021-01-22 21:56:19
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 5. Using Functions/46. Demo - Analytic Functions.wmv 16MB
  2. 5. Using Functions/3. Demo - Aggregate Functions.wmv 15MB
  3. 5. Using Functions/48. Demo - Analytic Functions (2).wmv 14MB
  4. 5. Using Functions/10. Demo - Ranking Functions.wmv 13MB
  5. 5. Using Functions/42. Demo - String Functions (5).wmv 12MB
  6. 4. Querying Multiple Data Sources/6. Demo - Outer Joins.wmv 12MB
  7. 2. Setting Up a Transact-SQL Learning Environment/6. Demo - Installing SQL Server 2012 Express with Tools.wmv 12MB
  8. 4. Querying Multiple Data Sources/25. Demo - INTERSECT and EXCEPT Operators.wmv 10MB
  9. 2. Setting Up a Transact-SQL Learning Environment/12. Demo - Attaching the AdventureWorks Sample Database.wmv 10MB
  10. 4. Querying Multiple Data Sources/16. Demo - Joining More than Two Tables.wmv 10MB
  11. 3. Writing a Basic SELECT Statement/17. Demo - WHERE Clause.wmv 10MB
  12. 4. Querying Multiple Data Sources/23. Demo - UNION Operator.wmv 10MB
  13. 4. Querying Multiple Data Sources/28. Demo - Introduction to Common Table Expressions.wmv 9MB
  14. 4. Querying Multiple Data Sources/18. Demo - CROSS APPLY and OUTER APPLY Operator.wmv 9MB
  15. 4. Querying Multiple Data Sources/14. Demo - Multi-Attribute Joins.wmv 9MB
  16. 5. Using Functions/12. Demo - Conversion Functions.wmv 9MB
  17. 5. Using Functions/26. Demo - Modifying Dates.wmv 8MB
  18. 5. Using Functions/7. Demo - Mathematical Functions.wmv 8MB
  19. 3. Writing a Basic SELECT Statement/23. Demo - GROUP BY Clause.wmv 8MB
  20. 3. Writing a Basic SELECT Statement/12. Demo - FROM Clause.wmv 8MB
  21. 5. Using Functions/44. Demo - String Functions (6).wmv 7MB
  22. 3. Writing a Basic SELECT Statement/25. Demo - HAVING Clause.wmv 7MB
  23. 4. Querying Multiple Data Sources/3. Demo - Inner Joins.wmv 7MB
  24. 4. Querying Multiple Data Sources/21. Demo - Using Sub-Queries.wmv 7MB
  25. 3. Writing a Basic SELECT Statement/19. Demo - DISTINCT.wmv 7MB
  26. 2. Setting Up a Transact-SQL Learning Environment/8. Demo - Using SSMS.wmv 6MB
  27. 2. Setting Up a Transact-SQL Learning Environment/14. Demo - Execute a Data Retrieval Query in SSMS.wmv 6MB
  28. 2. Setting Up a Transact-SQL Learning Environment/15. Demo - Execute a Data Retrieval Query in SSDT.wmv 6MB
  29. 3. Writing a Basic SELECT Statement/5. Demo - SELECT Clause.wmv 6MB
  30. 2. Setting Up a Transact-SQL Learning Environment/10. Demo - Installing SSDT.wmv 6MB
  31. 5. Using Functions/30. Demo - Logical Functions (2).wmv 5MB
  32. 3. Writing a Basic SELECT Statement/9. Demo - Regular versus Delimited Identifiers.wmv 5MB
  33. 5. Using Functions/18. Demo - Returning Date and Time Parts.wmv 5MB
  34. 5. Using Functions/32. Demo - Working with NULL.wmv 5MB
  35. 4. Querying Multiple Data Sources/8. Demo - Cross Joins.wmv 5MB
  36. 3. Writing a Basic SELECT Statement/27. Demo - ORDER BY Clause.wmv 5MB
  37. 3. Writing a Basic SELECT Statement/21. Demo - TOP.wmv 5MB
  38. 5. Using Functions/5. Demo - Aggregate Functions (2).wmv 5MB
  39. 2. Setting Up a Transact-SQL Learning Environment/4. Demo - Checking Hardware and OS Specifications.wmv 4MB
  40. 4. Querying Multiple Data Sources/10. Demo - Self Joins.wmv 4MB
  41. 5. Using Functions/36. Demo - String Functions (2).wmv 4MB
  42. 3. Writing a Basic SELECT Statement/29. Demo - Query Paging.wmv 4MB
  43. 4. Querying Multiple Data Sources/12. Demo - Equi vs. Non-Equi Joins.wmv 4MB
  44. 2. Setting Up a Transact-SQL Learning Environment/5. Demo - Checking .NET 3.5 SP1 Prerequisites.wmv 3MB
  45. 5. Using Functions/24. Demo - Calculating Time Differences.wmv 3MB
  46. 3. Writing a Basic SELECT Statement/14. Demo - Table Aliases.wmv 3MB
  47. 3. Writing a Basic SELECT Statement/31. Demo - Binding Order.wmv 3MB
  48. 5. Using Functions/14. Demo - Validating Data Types.wmv 3MB
  49. 3. Writing a Basic SELECT Statement/7. Demo - Column Aliases.wmv 3MB
  50. 5. Using Functions/28. Demo - Logical Functions.wmv 3MB
  51. 1. Introduction/1. Introduction.wmv 3MB
  52. 5. Using Functions/22. Demo - Constructing Date and Time Values (2).wmv 3MB
  53. 5. Using Functions/34. Demo - String Functions.wmv 3MB
  54. 2. Setting Up a Transact-SQL Learning Environment/3. SQL Server 2012 Express Abridged Requirements.wmv 3MB
  55. 5. Using Functions/16. Demo - System Time Functions.wmv 3MB
  56. 5. Using Functions/20. Demo - Constructing Date and Time Values.wmv 2MB
  57. 1. Introduction/2. Course Structure.wmv 2MB
  58. 3. Writing a Basic SELECT Statement/33. Demo - Commenting Your Code.wmv 2MB
  59. 2. Setting Up a Transact-SQL Learning Environment/9. SQL Server Data Tools (SSDT).wmv 2MB
  60. 3. Writing a Basic SELECT Statement/1. Introduction.wmv 2MB
  61. 5. Using Functions/40. Demo - String Functions (4).wmv 2MB
  62. 3. Writing a Basic SELECT Statement/20. TOP.wmv 2MB
  63. 4. Querying Multiple Data Sources/22. UNION Operator.wmv 2MB
  64. 3. Writing a Basic SELECT Statement/2. Thinking in 'Sets'.wmv 2MB
  65. 5. Using Functions/6. Mathematical Functions.wmv 2MB
  66. 5. Using Functions/47. Analytic Functions (2).wmv 2MB
  67. 4. Querying Multiple Data Sources/26. Data Types and Joining Tables.wmv 2MB
  68. 5. Using Functions/11. Conversion Functions.wmv 2MB
  69. 3. Writing a Basic SELECT Statement/4. SELECT Clause.wmv 2MB
  70. 3. Writing a Basic SELECT Statement/32. Best Practice - Commenting Your Code.wmv 2MB
  71. 5. Using Functions/2. Aggregate Functions.wmv 2MB
  72. 5. Using Functions/38. Demo - String Functions (3).wmv 1MB
  73. 4. Querying Multiple Data Sources/4. Outer Joins.wmv 1MB
  74. 2. Setting Up a Transact-SQL Learning Environment/2. SQL Server 2012 Express with Tools.wmv 1MB
  75. 2. Setting Up a Transact-SQL Learning Environment/1. Introduction.wmv 1MB
  76. 3. Writing a Basic SELECT Statement/26. ORDER BY Clause.wmv 1MB
  77. 5. Using Functions/15. System Time Functions.wmv 1MB
  78. 3. Writing a Basic SELECT Statement/28. Query Paging.wmv 1MB
  79. 3. Writing a Basic SELECT Statement/13. Table Aliases.wmv 1MB
  80. 2. Setting Up a Transact-SQL Learning Environment/7. SQL Server Management Studio (SSMS).wmv 1MB
  81. 5. Using Functions/4. Aggregate Functions (2).wmv 1MB
  82. 4. Querying Multiple Data Sources/2. Inner Joins.wmv 1MB
  83. 3. Writing a Basic SELECT Statement/8. Identifiers.wmv 1MB
  84. 4. Querying Multiple Data Sources/1. Introduction.wmv 1MB
  85. 5. Using Functions/41. String Functions (5).wmv 1MB
  86. 5. Using Functions/9. Ranking Functions.wmv 1MB
  87. 5. Using Functions/43. String Functions (6).wmv 1MB
  88. 5. Using Functions/17. Returning Date and Time Parts.wmv 1MB
  89. 4. Querying Multiple Data Sources/24. INTERSECT and EXCEPT.wmv 1MB
  90. 4. Querying Multiple Data Sources/20. Defining the Sub-Query.wmv 1MB
  91. 3. Writing a Basic SELECT Statement/6. Column Aliases.wmv 1MB
  92. 5. Using Functions/25. Modifying Dates.wmv 1MB
  93. 3. Writing a Basic SELECT Statement/11. FROM Clause.wmv 1MB
  94. 5. Using Functions/31. Working with NULL.wmv 1MB
  95. 2. Setting Up a Transact-SQL Learning Environment/13. Basic Data Retrieval.wmv 1MB
  96. 3. Writing a Basic SELECT Statement/15. Expressions, Operators, Predicates.wmv 1MB
  97. 3. Writing a Basic SELECT Statement/16. WHERE Clause.wmv 1MB
  98. 5. Using Functions/1. Introduction.wmv 1024KB
  99. 5. Using Functions/27. Logical Functions.wmv 1009KB
  100. 4. Querying Multiple Data Sources/17. CROSS APPLY Operator.wmv 1006KB
  101. 5. Using Functions/35. String Functions (2).wmv 986KB
  102. 5. Using Functions/49. Course Summary.wmv 965KB
  103. 5. Using Functions/45. Analytic Functions.wmv 950KB
  104. 2. Setting Up a Transact-SQL Learning Environment/11. AdventureWorks Sample Database.wmv 924KB
  105. 4. Querying Multiple Data Sources/11. Equi vs. Non-Equi Joins.wmv 909KB
  106. 4. Querying Multiple Data Sources/15. Joining More than Two Tables.wmv 903KB
  107. 5. Using Functions/8. OVER Clause.wmv 877KB
  108. 5. Using Functions/19. Constructing Date and Time Values.wmv 874KB
  109. 3. Writing a Basic SELECT Statement/22. GROUP BY Clause.wmv 871KB
  110. 5. Using Functions/33. String Functions.wmv 865KB
  111. 4. Querying Multiple Data Sources/7. Cross Joins.wmv 848KB
  112. 4. Querying Multiple Data Sources/5. Outer Joins (2).wmv 842KB
  113. 4. Querying Multiple Data Sources/27. Introduction to Common Table Expressions.wmv 821KB
  114. 3. Writing a Basic SELECT Statement/18. DISTINCT.wmv 815KB
  115. 3. Writing a Basic SELECT Statement/24. HAVING Clause.wmv 804KB
  116. 3. Writing a Basic SELECT Statement/3. Where to Begin.wmv 795KB
  117. 3. Writing a Basic SELECT Statement/10. Semicolon Statement Terminator.wmv 789KB
  118. 3. Writing a Basic SELECT Statement/30. Binding Order.wmv 733KB
  119. 4. Querying Multiple Data Sources/9. Self Joins.wmv 695KB
  120. 5. Using Functions/37. String Functions (3).wmv 692KB
  121. 5. Using Functions/29. Logical Functions (2).wmv 674KB
  122. 5. Using Functions/21. Constructing Date and Time Values (2).wmv 648KB
  123. 5. Using Functions/23. Calculating Time Differences.wmv 604KB
  124. 5. Using Functions/39. String Functions (4).wmv 504KB
  125. 5. Using Functions/13. Validating Data Types.wmv 466KB
  126. 4. Querying Multiple Data Sources/13. Multi-Attribute Joins.wmv 446KB
  127. 4. Querying Multiple Data Sources/19. Joining Sub-Queries.wmv 355KB