05. Querying Relational Databases/01. Database Normalization/04. Set Theory and Relational Databases.webm
23.9MB
TeamTreehouse - Beginning SQL (Track) [Thomas].jpg
133.36KB
TeamTreehouse - Beginning SQL (Track) [Thomas].png
524.51KB
01. SQL Basics/SQL Basics.md
6.42KB
01. SQL Basics/01. Data, Databases and SQL/01. Why This Course.webm
5.88MB
01. SQL Basics/01. Data, Databases and SQL/02. Data is Everywhere.webm
16.07MB
01. SQL Basics/01. Data, Databases and SQL/03. Talking to Databases with SQL.webm
8.04MB
01. SQL Basics/01. Data, Databases and SQL/04. Organizing Data with Databases.webm
8.63MB
01. SQL Basics/01. Data, Databases and SQL/05. Types of Data.webm
7.65MB
01. SQL Basics/02. Getting Data from a Database/01. Tools Well be Using.webm
9.82MB
01. SQL Basics/02. Getting Data from a Database/02. Your First SQL Statement.webm
13.95MB
01. SQL Basics/02. Getting Data from a Database/03. Retrieving Specific Columns of Information.webm
6.64MB
01. SQL Basics/02. Getting Data from a Database/04. Categorizing Your Output with AS.webm
8.65MB
01. SQL Basics/02. Getting Data from a Database/05. Review & Practice with SQL Playgrounds.webm
4.72MB
01. SQL Basics/03. Finding the Data You Want/01. Searching Tables with WHERE.webm
15.33MB
01. SQL Basics/03. Finding the Data You Want/02. Filtering by Comparing Values.webm
8.72MB
01. SQL Basics/03. Finding the Data You Want/03. Filtering on More than One Condition.webm
6.97MB
01. SQL Basics/03. Finding the Data You Want/04. Filtering by Dates.webm
5.28MB
01. SQL Basics/03. Finding the Data You Want/05. Searching Within a Set of Values.webm
6.02MB
01. SQL Basics/03. Finding the Data You Want/06. Searching Within a Range of Values.webm
6.5MB
01. SQL Basics/03. Finding the Data You Want/07. Finding Data that Matches a Pattern.webm
5.67MB
01. SQL Basics/03. Finding the Data You Want/08. Filtering Out or Finding Missing Information.webm
4.19MB
01. SQL Basics/03. Finding the Data You Want/09. Review & Practice with SQL Playgrounds.webm
9.55MB
01. SQL Basics/03. Finding the Data You Want/10. Need SQL Practice.md
933B
02. Turn Documents Into Apps with Coda/Turn Documents Into Apps with Coda.md
1.39KB
03. Modifying Data with SQL/Modifying Data with SQL.md
5KB
03. Modifying Data with SQL/01. Adding Data to a Database/01. Introduction to CRUD.webm
8.66MB
03. Modifying Data with SQL/01. Adding Data to a Database/02. Adding a Row to a Table.webm
13.7MB
03. Modifying Data with SQL/01. Adding Data to a Database/03. Adding Multiple Rows to a Table.webm
4.1MB
03. Modifying Data with SQL/01. Adding Data to a Database/04. Review and Practice.webm
3.18MB
03. Modifying Data with SQL/02. Updating Data in a Database/01. Update All Rows or Columns in a Table.webm
5.36MB
03. Modifying Data with SQL/02. Updating Data in a Database/02. Updating Specific Rows.webm
9.64MB
03. Modifying Data with SQL/02. Updating Data in a Database/03. Review and Practice.webm
2.76MB
03. Modifying Data with SQL/03. Deleting Data From a Database/01. Removing Data from All Rows in a Table.webm
3.5MB
03. Modifying Data with SQL/03. Deleting Data From a Database/02. Removing Specific Rows.webm
7.16MB
03. Modifying Data with SQL/03. Deleting Data From a Database/03. Review and Practice.webm
2.62MB
03. Modifying Data with SQL/04. Handling Errors When Manipulating Data/01. Introduction to Transactions.webm
11.8MB
03. Modifying Data with SQL/04. Handling Errors When Manipulating Data/02. Rolling Back from Transactions.webm
3.94MB
03. Modifying Data with SQL/04. Handling Errors When Manipulating Data/03. Databases with Frameworks.webm
5.11MB
04. Reporting with SQL/Reporting with SQL.md
8.24KB
04. Reporting with SQL/01. Ordering, Limiting and Paging Results/01. Overview.webm
11.78MB
04. Reporting with SQL/01. Ordering, Limiting and Paging Results/02. Retrieving Results in a Particular Order.webm
11.2MB
04. Reporting with SQL/01. Ordering, Limiting and Paging Results/03. Limiting the Number of Results.webm
11.56MB
04. Reporting with SQL/01. Ordering, Limiting and Paging Results/04. Paging Through Results.webm
7.28MB
04. Reporting with SQL/01. Ordering, Limiting and Paging Results/05. Practice Session.webm
2.77MB
04. Reporting with SQL/02. Working with Text/01. What Are Functions.webm
10.58MB
04. Reporting with SQL/02. Working with Text/02. Adding Text Columns Together.webm
9.09MB
04. Reporting with SQL/02. Working with Text/03. Single vs Double Quotes.md
705B
04. Reporting with SQL/02. Working with Text/04. Finding the Length of Text.webm
7.57MB
04. Reporting with SQL/02. Working with Text/05. Changing the Case of Text Columns.webm
5.52MB
04. Reporting with SQL/02. Working with Text/06. Creating Excerpts From Text.webm
5.23MB
04. Reporting with SQL/02. Working with Text/07. Replacing Portions of Text.webm
6.19MB
04. Reporting with SQL/02. Working with Text/08. Practice Session.webm
6.8MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/01. Counting Results.webm
9.8MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/02. Counting Groups of Rows.webm
5.65MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/03. Getting the Grand Total.webm
13.74MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/04. Calculating Averages.webm
3.86MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/05. Getting Minimum and Maximum Values.webm
4.5MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/06. Performing Math on Numeric Types.webm
6.37MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/07. Practice Session.webm
6.53MB
04. Reporting with SQL/04. Date and Time Functions/01. Differences Between Databases.webm
7.5MB
04. Reporting with SQL/04. Date and Time Functions/02. Creating Up-to-the-Minute Reports.webm
8.66MB
04. Reporting with SQL/04. Date and Time Functions/03. Calculating Dates.webm
7.63MB
04. Reporting with SQL/04. Date and Time Functions/04. Formatting Dates For Reporting.webm
7.37MB
04. Reporting with SQL/04. Date and Time Functions/05. Practice Session.webm
5MB
05. Querying Relational Databases/Querying Relational Databases.md
7.55KB
05. Querying Relational Databases/01. Database Normalization/01. Why We Make Databases Relational.webm
17.02MB
05. Querying Relational Databases/01. Database Normalization/02. Database Normalization.webm
7.38MB
05. Querying Relational Databases/01. Database Normalization/03. How Normalization Helps Us.webm
17.46MB
05. Querying Relational Databases/01. Database Normalization/05. Theoretical Groundwork.webm
3.74MB
05. Querying Relational Databases/02. Database Keys/01. Unique Keys.webm
9.35MB
05. Querying Relational Databases/02. Database Keys/02. Primary Keys.webm
5.23MB
05. Querying Relational Databases/02. Database Keys/03. Foreign Keys.webm
16.57MB
05. Querying Relational Databases/03. Table Relationships/01. One to Many Relationships.webm
8.8MB
05. Querying Relational Databases/03. Table Relationships/02. Many to Many Relationships.webm
10.97MB
05. Querying Relational Databases/03. Table Relationships/03. One to One Relationships.webm
6.31MB
05. Querying Relational Databases/03. Table Relationships/04. Modeling Table Relationships.webm
10.72MB
05. Querying Relational Databases/04. Joining Table Data with SQL/01. Join Queries.webm
9.37MB
05. Querying Relational Databases/04. Joining Table Data with SQL/02. Inner Joins.webm
12.25MB
05. Querying Relational Databases/04. Joining Table Data with SQL/03. Outer Joins.webm
10.02MB
05. Querying Relational Databases/04. Joining Table Data with SQL/04. Review and Practice.webm
4.93MB
05. Querying Relational Databases/05. Set Operations/01. What are Set Operations.webm
3.54MB
05. Querying Relational Databases/05. Set Operations/02. Union Operations.webm
9.5MB
05. Querying Relational Databases/05. Set Operations/03. Union All Operations.webm
5.02MB
05. Querying Relational Databases/05. Set Operations/04. Intersect Operations.webm
6.32MB
05. Querying Relational Databases/05. Set Operations/05. Except Operations.webm
6.79MB
05. Querying Relational Databases/05. Set Operations/06. Review and Practice.webm
6.54MB
05. Querying Relational Databases/06. Subqueries/01. What are Subqueries.webm
6.81MB
05. Querying Relational Databases/06. Subqueries/02. Using IN with Subqueries to Filter Data.webm
4.79MB
05. Querying Relational Databases/06. Subqueries/03. Using a Subquery to Create a Temporary Table (Part 1).webm
9.84MB
05. Querying Relational Databases/06. Subqueries/04. Using a Subquery to Create a Temporary Table (Part 2).webm
14.08MB
05. Querying Relational Databases/06. Subqueries/05. Review and Practice.webm
8.59MB
06. Common Table Expressions Using WITH/01. What is a Common Table Expression.webm
19.39MB
06. Common Table Expressions Using WITH/02. Convert a Subquery to a CTE.webm
9.56MB
06. Common Table Expressions Using WITH/03. Using Multiple CTEs in a Query.webm
16.39MB
06. Common Table Expressions Using WITH/Common Table Expressions Using WITH.md
1018B
07. SQL Reporting by Example/SQL Reporting by Example.md
3.99KB
07. SQL Reporting by Example/01. Orientation Selecting Data/01. Introduction.webm
14.12MB
07. SQL Reporting by Example/01. Orientation Selecting Data/02. Learning the Database.webm
7.88MB
07. SQL Reporting by Example/01. Orientation Selecting Data/03. Listing Subjects.webm
3.86MB
07. SQL Reporting by Example/01. Orientation Selecting Data/04. Counting Students.webm
2.4MB
07. SQL Reporting by Example/01. Orientation Selecting Data/05. Finding the ID.webm
2.04MB
07. SQL Reporting by Example/01. Orientation Selecting Data/06. Listing Teachers.webm
3.34MB
07. SQL Reporting by Example/01. Orientation Selecting Data/07. A Students.webm
6.77MB
07. SQL Reporting by Example/02. Day 1 Joining Tables/01. Calculating School Capacity.webm
4.04MB
07. SQL Reporting by Example/02. Day 1 Joining Tables/02. The Biggest Room.webm
2.94MB
07. SQL Reporting by Example/02. Day 1 Joining Tables/03. Subjects in the Big Room.webm
4.05MB
07. SQL Reporting by Example/02. Day 1 Joining Tables/04. 8th Grade Teachers.webm
7.71MB
07. SQL Reporting by Example/02. Day 1 Joining Tables/05. 7th Grade Science.webm
4.83MB
07. SQL Reporting by Example/02. Day 1 Joining Tables/06. Elective Teachers.webm
6.86MB
07. SQL Reporting by Example/03. Day 2 Advanced Selecting/01. Student Schedule.webm
8.13MB
07. SQL Reporting by Example/03. Day 2 Advanced Selecting/02. A Smelly Issue.webm
8.01MB
07. SQL Reporting by Example/03. Day 2 Advanced Selecting/03. Students A to M.webm
4.82MB
07. SQL Reporting by Example/03. Day 2 Advanced Selecting/04. Students by Grade.webm
5.73MB
07. SQL Reporting by Example/03. Day 2 Advanced Selecting/05. Predicting the Future.webm
7.62MB
07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/01. Busiest Teachers.webm
6.42MB
07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/02. Multi-Subject Teachers.webm
5.05MB
07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/03. Janis Schedule.webm
9.53MB
07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/04. Least Popular Subject.webm
5.85MB
07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/05. Finding the Troublemaker.webm
9.55MB
07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/06. Most Popular Teacher.webm
8.99MB
07. SQL Reporting by Example/04. Day 3 Getting Good at Grouping/07. Bus Troubles.webm
7.09MB