589689.xyz

TeamTreehouse - Beginning SQL (Track) [Thomas]

  • 收录时间:2022-08-03 00:10:43
  • 文件大小:882MB
  • 下载次数:1
  • 最近下载:2022-08-03 00:10:43
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 05. Querying Relational Databases/01. Database Normalization/04. Set Theory and Relational Databases.webm 24MB
  2. 06. Common Table Expressions Using WITH/01. What is a Common Table Expression.webm 19MB
  3. 05. Querying Relational Databases/01. Database Normalization/03. How Normalization Helps Us.webm 17MB
  4. 05. Querying Relational Databases/01. Database Normalization/01. Why We Make Databases Relational.webm 17MB
  5. 05. Querying Relational Databases/02. Database Keys/03. Foreign Keys.webm 17MB
  6. 06. Common Table Expressions Using WITH/03. Using Multiple CTEs in a Query.webm 16MB
  7. 01. SQL Basics/01. Data, Databases and SQL/02. Data is Everywhere.webm 16MB
  8. 01. SQL Basics/03. Finding the Data You Want/01. Searching Tables with WHERE.webm 15MB
  9. 07. SQL Reporting by Example/01. Orientation Selecting Data/01. Introduction.webm 14MB
  10. 05. Querying Relational Databases/06. Subqueries/04. Using a Subquery to Create a Temporary Table (Part 2).webm 14MB
  11. 01. SQL Basics/02. Getting Data from a Database/02. Your First SQL Statement.webm 14MB
  12. 04. Reporting with SQL/03. Aggregate and Numeric Functions/03. Getting the Grand Total.webm 14MB
  13. 03. Modifying Data with SQL/01. Adding Data to a Database/02. Adding a Row to a Table.webm 14MB
  14. 05. Querying Relational Databases/04. Joining Table Data with SQL/02. Inner Joins.webm 12MB
  15. 03. Modifying Data with SQL/04. Handling Errors When Manipulating Data/01. Introduction to Transactions.webm 12MB
  16. 04. Reporting with SQL/01. Ordering, Limiting and Paging Results/01. Overview.webm 12MB
  17. 04. Reporting with SQL/01. Ordering, Limiting and Paging Results/03. Limiting the Number of Results.webm 12MB
  18. 04. Reporting with SQL/01. Ordering, Limiting and Paging Results/02. Retrieving Results in a Particular Order.webm 11MB
  19. 05. Querying Relational Databases/03. Table Relationships/02. Many to Many Relationships.webm 11MB
  20. 05. Querying Relational Databases/03. Table Relationships/04. Modeling Table Relationships.webm 11MB
  21. 04. Reporting with SQL/02. Working with Text/01. What Are Functions.webm 11MB
  22. 05. Querying Relational Databases/04. Joining Table Data with SQL/03. Outer Joins.webm 10MB
  23. 05. Querying Relational Databases/06. Subqueries/03. Using a Subquery to Create a Temporary Table (Part 1).webm 10MB
  24. 01. SQL Basics/02. Getting Data from a Database/01. Tools Well be Using.webm 10MB
  25. 04. Reporting with SQL/03. Aggregate and Numeric Functions/01. Counting Results.webm 10MB
  26. 03. Modifying Data with SQL/02. Updating Data in a Database/02. Updating Specific Rows.webm 10MB
  27. 06. Common Table Expressions Using WITH/02. Convert a Subquery to a CTE.webm 10MB
  28. 07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/05. Finding the Troublemaker.webm 10MB
  29. 01. SQL Basics/03. Finding the Data You Want/09. Review & Practice with SQL Playgrounds.webm 10MB
  30. 07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/03. Janis Schedule.webm 10MB
  31. 05. Querying Relational Databases/05. Set Operations/02. Union Operations.webm 9MB
  32. 05. Querying Relational Databases/04. Joining Table Data with SQL/01. Join Queries.webm 9MB
  33. 05. Querying Relational Databases/02. Database Keys/01. Unique Keys.webm 9MB
  34. 04. Reporting with SQL/02. Working with Text/02. Adding Text Columns Together.webm 9MB
  35. 07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/06. Most Popular Teacher.webm 9MB
  36. 05. Querying Relational Databases/03. Table Relationships/01. One to Many Relationships.webm 9MB
  37. 01. SQL Basics/03. Finding the Data You Want/02. Filtering by Comparing Values.webm 9MB
  38. 04. Reporting with SQL/04. Date and Time Functions/02. Creating Up-to-the-Minute Reports.webm 9MB
  39. 03. Modifying Data with SQL/01. Adding Data to a Database/01. Introduction to CRUD.webm 9MB
  40. 01. SQL Basics/02. Getting Data from a Database/04. Categorizing Your Output with AS.webm 9MB
  41. 01. SQL Basics/01. Data, Databases and SQL/04. Organizing Data with Databases.webm 9MB
  42. 05. Querying Relational Databases/06. Subqueries/05. Review and Practice.webm 9MB
  43. 07. SQL Reporting by Example/03. Day 2 Advanced Selecting/01. Student Schedule.webm 8MB
  44. 01. SQL Basics/01. Data, Databases and SQL/03. Talking to Databases with SQL.webm 8MB
  45. 07. SQL Reporting by Example/03. Day 2 Advanced Selecting/02. A Smelly Issue.webm 8MB
  46. 07. SQL Reporting by Example/01. Orientation Selecting Data/02. Learning the Database.webm 8MB
  47. 07. SQL Reporting by Example/02. Day 1 Joining Tables/04. 8th Grade Teachers.webm 8MB
  48. 01. SQL Basics/01. Data, Databases and SQL/05. Types of Data.webm 8MB
  49. 04. Reporting with SQL/04. Date and Time Functions/03. Calculating Dates.webm 8MB
  50. 07. SQL Reporting by Example/03. Day 2 Advanced Selecting/05. Predicting the Future.webm 8MB
  51. 04. Reporting with SQL/02. Working with Text/04. Finding the Length of Text.webm 8MB
  52. 04. Reporting with SQL/04. Date and Time Functions/01. Differences Between Databases.webm 7MB
  53. 05. Querying Relational Databases/01. Database Normalization/02. Database Normalization.webm 7MB
  54. 04. Reporting with SQL/04. Date and Time Functions/04. Formatting Dates For Reporting.webm 7MB
  55. 04. Reporting with SQL/01. Ordering, Limiting and Paging Results/04. Paging Through Results.webm 7MB
  56. 03. Modifying Data with SQL/03. Deleting Data From a Database/02. Removing Specific Rows.webm 7MB
  57. 07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/07. Bus Troubles.webm 7MB
  58. 01. SQL Basics/03. Finding the Data You Want/03. Filtering on More than One Condition.webm 7MB
  59. 07. SQL Reporting by Example/02. Day 1 Joining Tables/06. Elective Teachers.webm 7MB
  60. 05. Querying Relational Databases/06. Subqueries/01. What are Subqueries.webm 7MB
  61. 04. Reporting with SQL/02. Working with Text/08. Practice Session.webm 7MB
  62. 05. Querying Relational Databases/05. Set Operations/05. Except Operations.webm 7MB
  63. 07. SQL Reporting by Example/01. Orientation Selecting Data/07. A Students.webm 7MB
  64. 01. SQL Basics/02. Getting Data from a Database/03. Retrieving Specific Columns of Information.webm 7MB
  65. 05. Querying Relational Databases/05. Set Operations/06. Review and Practice.webm 7MB
  66. 04. Reporting with SQL/03. Aggregate and Numeric Functions/07. Practice Session.webm 7MB
  67. 01. SQL Basics/03. Finding the Data You Want/06. Searching Within a Range of Values.webm 6MB
  68. 07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/01. Busiest Teachers.webm 6MB
  69. 04. Reporting with SQL/03. Aggregate and Numeric Functions/06. Performing Math on Numeric Types.webm 6MB
  70. 05. Querying Relational Databases/05. Set Operations/04. Intersect Operations.webm 6MB
  71. 05. Querying Relational Databases/03. Table Relationships/03. One to One Relationships.webm 6MB
  72. 04. Reporting with SQL/02. Working with Text/07. Replacing Portions of Text.webm 6MB
  73. 01. SQL Basics/03. Finding the Data You Want/05. Searching Within a Set of Values.webm 6MB
  74. 01. SQL Basics/01. Data, Databases and SQL/01. Why This Course.webm 6MB
  75. 07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/04. Least Popular Subject.webm 6MB
  76. 07. SQL Reporting by Example/03. Day 2 Advanced Selecting/04. Students by Grade.webm 6MB
  77. 01. SQL Basics/03. Finding the Data You Want/07. Finding Data that Matches a Pattern.webm 6MB
  78. 04. Reporting with SQL/03. Aggregate and Numeric Functions/02. Counting Groups of Rows.webm 6MB
  79. 04. Reporting with SQL/02. Working with Text/05. Changing the Case of Text Columns.webm 6MB
  80. 03. Modifying Data with SQL/02. Updating Data in a Database/01. Update All Rows or Columns in a Table.webm 5MB
  81. 01. SQL Basics/03. Finding the Data You Want/04. Filtering by Dates.webm 5MB
  82. 05. Querying Relational Databases/02. Database Keys/02. Primary Keys.webm 5MB
  83. 04. Reporting with SQL/02. Working with Text/06. Creating Excerpts From Text.webm 5MB
  84. 03. Modifying Data with SQL/04. Handling Errors When Manipulating Data/03. Databases with Frameworks.webm 5MB
  85. 07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/02. Multi-Subject Teachers.webm 5MB
  86. 05. Querying Relational Databases/05. Set Operations/03. Union All Operations.webm 5MB
  87. 04. Reporting with SQL/04. Date and Time Functions/05. Practice Session.webm 5MB
  88. 05. Querying Relational Databases/04. Joining Table Data with SQL/04. Review and Practice.webm 5MB
  89. 07. SQL Reporting by Example/02. Day 1 Joining Tables/05. 7th Grade Science.webm 5MB
  90. 07. SQL Reporting by Example/03. Day 2 Advanced Selecting/03. Students A to M.webm 5MB
  91. 05. Querying Relational Databases/06. Subqueries/02. Using IN with Subqueries to Filter Data.webm 5MB
  92. 01. SQL Basics/02. Getting Data from a Database/05. Review & Practice with SQL Playgrounds.webm 5MB
  93. 04. Reporting with SQL/03. Aggregate and Numeric Functions/05. Getting Minimum and Maximum Values.webm 5MB
  94. 01. SQL Basics/03. Finding the Data You Want/08. Filtering Out or Finding Missing Information.webm 4MB
  95. 03. Modifying Data with SQL/01. Adding Data to a Database/03. Adding Multiple Rows to a Table.webm 4MB
  96. 07. SQL Reporting by Example/02. Day 1 Joining Tables/03. Subjects in the Big Room.webm 4MB
  97. 07. SQL Reporting by Example/02. Day 1 Joining Tables/01. Calculating School Capacity.webm 4MB
  98. 03. Modifying Data with SQL/04. Handling Errors When Manipulating Data/02. Rolling Back from Transactions.webm 4MB
  99. 07. SQL Reporting by Example/01. Orientation Selecting Data/03. Listing Subjects.webm 4MB
  100. 04. Reporting with SQL/03. Aggregate and Numeric Functions/04. Calculating Averages.webm 4MB
  101. 05. Querying Relational Databases/01. Database Normalization/05. Theoretical Groundwork.webm 4MB
  102. 05. Querying Relational Databases/05. Set Operations/01. What are Set Operations.webm 4MB
  103. 03. Modifying Data with SQL/03. Deleting Data From a Database/01. Removing Data from All Rows in a Table.webm 3MB
  104. 07. SQL Reporting by Example/01. Orientation Selecting Data/06. Listing Teachers.webm 3MB
  105. 03. Modifying Data with SQL/01. Adding Data to a Database/04. Review and Practice.webm 3MB
  106. 07. SQL Reporting by Example/02. Day 1 Joining Tables/02. The Biggest Room.webm 3MB
  107. 04. Reporting with SQL/01. Ordering, Limiting and Paging Results/05. Practice Session.webm 3MB
  108. 03. Modifying Data with SQL/02. Updating Data in a Database/03. Review and Practice.webm 3MB
  109. 03. Modifying Data with SQL/03. Deleting Data From a Database/03. Review and Practice.webm 3MB
  110. 07. SQL Reporting by Example/01. Orientation Selecting Data/04. Counting Students.webm 2MB
  111. 07. SQL Reporting by Example/01. Orientation Selecting Data/05. Finding the ID.webm 2MB
  112. TeamTreehouse - Beginning SQL (Track) [Thomas].png 525KB
  113. TeamTreehouse - Beginning SQL (Track) [Thomas].jpg 133KB
  114. 04. Reporting with SQL/Reporting with SQL.md 8KB
  115. 05. Querying Relational Databases/Querying Relational Databases.md 8KB
  116. 01. SQL Basics/SQL Basics.md 6KB
  117. 03. Modifying Data with SQL/Modifying Data with SQL.md 5KB
  118. 07. SQL Reporting by Example/SQL Reporting by Example.md 4KB
  119. Beginning SQL.md 3KB
  120. README.txt 2KB
  121. 02. Turn Documents Into Apps with Coda/Turn Documents Into Apps with Coda.md 1KB
  122. 06. Common Table Expressions Using WITH/Common Table Expressions Using WITH.md 1018B
  123. 01. SQL Basics/03. Finding the Data You Want/10. Need SQL Practice.md 933B
  124. 04. Reporting with SQL/02. Working with Text/03. Single vs Double Quotes.md 705B