|
|
01. Busiest Teachers.webm
|
WEBM
|
6.4 MB
|
|
|
01. Calculating School Capacity.webm
|
WEBM
|
4 MB
|
|
|
01. Counting Results.webm
|
WEBM
|
9.8 MB
|
|
|
01. Differences Between Databases.webm
|
WEBM
|
7.5 MB
|
|
|
01. Introduction to CRUD.webm
|
WEBM
|
8.7 MB
|
|
|
01. Introduction to Transactions.webm
|
WEBM
|
11.8 MB
|
|
|
01. Introduction.webm
|
WEBM
|
14.1 MB
|
|
|
01. Join Queries.webm
|
WEBM
|
9.4 MB
|
|
|
01. One to Many Relationships.webm
|
WEBM
|
8.8 MB
|
|
|
01. Overview.webm
|
WEBM
|
11.8 MB
|
|
|
01. Removing Data from All Rows in a Table.webm
|
WEBM
|
3.5 MB
|
|
|
01. Searching Tables with WHERE.webm
|
WEBM
|
15.3 MB
|
|
|
01. Student Schedule.webm
|
WEBM
|
8.1 MB
|
|
|
01. Tools Well be Using.webm
|
WEBM
|
9.8 MB
|
|
|
01. Unique Keys.webm
|
WEBM
|
9.3 MB
|
|
|
01. Update All Rows or Columns in a Table.webm
|
WEBM
|
5.4 MB
|
|
|
01. What Are Functions.webm
|
WEBM
|
10.6 MB
|
|
|
01. What are Set Operations.webm
|
WEBM
|
3.5 MB
|
|
|
01. What are Subqueries.webm
|
WEBM
|
6.8 MB
|
|
|
01. What is a Common Table Expression.webm
|
WEBM
|
19.4 MB
|
|
|
01. Why This Course.webm
|
WEBM
|
5.9 MB
|
|
|
01. Why We Make Databases Relational.webm
|
WEBM
|
17 MB
|
|
|
02. A Smelly Issue.webm
|
WEBM
|
8 MB
|
|
|
02. Adding Text Columns Together.webm
|
WEBM
|
9.1 MB
|
|
|
02. Adding a Row to a Table.webm
|
WEBM
|
13.7 MB
|
|
|
02. Convert a Subquery to a CTE.webm
|
WEBM
|
9.6 MB
|
|
|
02. Counting Groups of Rows.webm
|
WEBM
|
5.7 MB
|
|
|
02. Creating Up-to-the-Minute Reports.webm
|
WEBM
|
8.7 MB
|
|
|
02. Data is Everywhere.webm
|
WEBM
|
16.1 MB
|
|
|
02. Database Normalization.webm
|
WEBM
|
7.4 MB
|
|
|
02. Filtering by Comparing Values.webm
|
WEBM
|
8.7 MB
|
|
|
02. Inner Joins.webm
|
WEBM
|
12.3 MB
|
|
|
02. Learning the Database.webm
|
WEBM
|
7.9 MB
|
|
|
02. Many to Many Relationships.webm
|
WEBM
|
11 MB
|
|
|
02. Multi-Subject Teachers.webm
|
WEBM
|
5 MB
|
|
|
02. Primary Keys.webm
|
WEBM
|
5.2 MB
|
|
|
02. Removing Specific Rows.webm
|
WEBM
|
7.2 MB
|
|
|
02. Retrieving Results in a Particular Order.webm
|
WEBM
|
11.2 MB
|
|
|
02. Rolling Back from Transactions.webm
|
WEBM
|
3.9 MB
|
|
|
02. The Biggest Room.webm
|
WEBM
|
2.9 MB
|
|
|
02. Union Operations.webm
|
WEBM
|
9.5 MB
|
|
|
02. Updating Specific Rows.webm
|
WEBM
|
9.6 MB
|
|
|
02. Using IN with Subqueries to Filter Data.webm
|
WEBM
|
4.8 MB
|
|
|
02. Your First SQL Statement.webm
|
WEBM
|
13.9 MB
|
|
|
03. Adding Multiple Rows to a Table.webm
|
WEBM
|
4.1 MB
|
|
|
03. Calculating Dates.webm
|
WEBM
|
7.6 MB
|
|
|
03. Databases with Frameworks.webm
|
WEBM
|
5.1 MB
|
|
|
03. Filtering on More than One Condition.webm
|
WEBM
|
7 MB
|
|
|
03. Foreign Keys.webm
|
WEBM
|
16.6 MB
|
|
|
03. Getting the Grand Total.webm
|
WEBM
|
13.7 MB
|
|
|
03. How Normalization Helps Us.webm
|
WEBM
|
17.5 MB
|
|
|
03. Janis Schedule.webm
|
WEBM
|
9.5 MB
|
|
|
03. Limiting the Number of Results.webm
|
WEBM
|
11.6 MB
|
|
|
03. Listing Subjects.webm
|
WEBM
|
3.9 MB
|
|
|
03. One to One Relationships.webm
|
WEBM
|
6.3 MB
|
|
|
03. Outer Joins.webm
|
WEBM
|
10 MB
|
|
|
03. Retrieving Specific Columns of Information.webm
|
WEBM
|
6.6 MB
|
|
|
03. Review and Practice.webm
|
WEBM
|
2.6 MB
|
|
|
03. Single vs Double Quotes.md
|
MD
|
716.8 B
|
|
|
03. Students A to M.webm
|
WEBM
|
4.8 MB
|
|
|
03. Subjects in the Big Room.webm
|
WEBM
|
4.1 MB
|
|
|
03. Talking to Databases with SQL.webm
|
WEBM
|
8 MB
|
|
|
03. Union All Operations.webm
|
WEBM
|
5 MB
|
|
|
03. Using Multiple CTEs in a Query.webm
|
WEBM
|
16.4 MB
|
|
|
03. Using a Subquery to Create a Temporary Table (Part 1).webm
|
WEBM
|
9.8 MB
|
|
|
04. 8th Grade Teachers.webm
|
WEBM
|
7.7 MB
|
|
|
04. Calculating Averages.webm
|
WEBM
|
3.9 MB
|
|
|
04. Categorizing Your Output with AS.webm
|
WEBM
|
8.7 MB
|
|
|
04. Counting Students.webm
|
WEBM
|
2.4 MB
|
|
|
04. Filtering by Dates.webm
|
WEBM
|
5.3 MB
|
|
|
04. Finding the Length of Text.webm
|
WEBM
|
7.6 MB
|
|
|
04. Formatting Dates For Reporting.webm
|
WEBM
|
7.4 MB
|
|
|
04. Intersect Operations.webm
|
WEBM
|
6.3 MB
|
|
|
04. Least Popular Subject.webm
|
WEBM
|
5.8 MB
|
|
|
04. Modeling Table Relationships.webm
|
WEBM
|
10.7 MB
|
|
|
04. Organizing Data with Databases.webm
|
WEBM
|
8.6 MB
|
|
|
04. Paging Through Results.webm
|
WEBM
|
7.3 MB
|
|
|
04. Review and Practice.webm
|
WEBM
|
3.2 MB
|
|
|
04. Set Theory and Relational Databases.webm
|
WEBM
|
23.9 MB
|
|
|
04. Students by Grade.webm
|
WEBM
|
5.7 MB
|
|
|
04. Using a Subquery to Create a Temporary Table (Part 2).webm
|
WEBM
|
14.1 MB
|
|
|
05. 7th Grade Science.webm
|
WEBM
|
4.8 MB
|
|
|
05. Changing the Case of Text Columns.webm
|
WEBM
|
5.5 MB
|
|
|
05. Except Operations.webm
|
WEBM
|
6.8 MB
|
|
|
05. Finding the ID.webm
|
WEBM
|
2 MB
|
|
|
05. Finding the Troublemaker.webm
|
WEBM
|
9.6 MB
|
|
|
05. Getting Minimum and Maximum Values.webm
|
WEBM
|
4.5 MB
|
|
|
05. Practice Session.webm
|
WEBM
|
5 MB
|
|
|
05. Predicting the Future.webm
|
WEBM
|
7.6 MB
|
|
|
05. Review & Practice with SQL Playgrounds.webm
|
WEBM
|
4.7 MB
|
|
|
05. Review and Practice.webm
|
WEBM
|
8.6 MB
|
|
|
05. Searching Within a Set of Values.webm
|
WEBM
|
6 MB
|
|
|
05. Theoretical Groundwork.webm
|
WEBM
|
3.7 MB
|
|
|
05. Types of Data.webm
|
WEBM
|
7.6 MB
|
|
|
06. Creating Excerpts From Text.webm
|
WEBM
|
5.2 MB
|
|
|
06. Elective Teachers.webm
|
WEBM
|
6.9 MB
|
|
|
06. Listing Teachers.webm
|
WEBM
|
3.3 MB
|
|
|
06. Most Popular Teacher.webm
|
WEBM
|
9 MB
|
|
|
06. Performing Math on Numeric Types.webm
|
WEBM
|
6.4 MB
|
|
|
06. Review and Practice.webm
|
WEBM
|
6.5 MB
|
|
|
06. Searching Within a Range of Values.webm
|
WEBM
|
6.5 MB
|
|
|
07. A Students.webm
|
WEBM
|
6.8 MB
|
|
|
07. Bus Troubles.webm
|
WEBM
|
7.1 MB
|
|
|
07. Finding Data that Matches a Pattern.webm
|
WEBM
|
5.7 MB
|
|
|
07. Practice Session.webm
|
WEBM
|
6.5 MB
|
|
|
07. Replacing Portions of Text.webm
|
WEBM
|
6.2 MB
|
|
|
08. Filtering Out or Finding Missing Information.webm
|
WEBM
|
4.2 MB
|
|
|
08. Practice Session.webm
|
WEBM
|
6.8 MB
|
|
|
09. Review & Practice with SQL Playgrounds.webm
|
WEBM
|
9.5 MB
|
|
|
10. Need SQL Practice.md
|
MD
|
921.6 B
|
|
|
Beginning SQL.md
|
MD
|
2.8 KB
|
|
|
Common Table Expressions Using WITH.md
|
MD
|
1 KB
|
|
|
Modifying Data with SQL.md
|
MD
|
5 KB
|
|
|
Querying Relational Databases.md
|
MD
|
7.6 KB
|
|
|
README.txt
|
TXT
|
2.2 KB
|
|
|
Reporting with SQL.md
|
MD
|
8.2 KB
|
|
|
SQL Basics.md
|
MD
|
6.4 KB
|
|
|
SQL Reporting by Example.md
|
MD
|
4 KB
|
|
|
TeamTreehouse - Beginning SQL (Track) [Thomas].jpg
|
JPG
|
133.4 KB
|
|
|
TeamTreehouse - Beginning SQL (Track) [Thomas].png
|
PNG
|
524.5 KB
|
|
|
Turn Documents Into Apps with Coda.md
|
MD
|
1.4 KB
|
![TeamTreehouse - Beginning SQL (Track) [Thomas]](/static/img/no-torrent-image.png "TeamTreehouse - Beginning SQL (Track) [Thomas]")
