TeamTreehouse Beginning SQL Track | 91CB722CC55EF319DE149B183272D4C882A3F8D3

TeamTreehouse Beginning SQL Track

Name	TeamTreehouse - Beginning SQL (Track)	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	923.6 MB
Total Files	121
Last Seen
Hash	91CB722CC55EF319DE149B183272D4C882A3F8D3

/
Beginning SQL.md	2.9 KB
01. SQL Basics/
SQL Basics.md	6.6 KB
/.../01. Data, Databases and SQL/
01. Why This Course.webm	6.2 MB
02. Data is Everywhere.webm	16.9 MB
03. Talking to Databases with SQL.webm	8.4 MB
04. Organizing Data with Databases.webm	9.1 MB
05. Types of Data.webm	8.0 MB
/.../02. Getting Data from a Database/
01. Tools Well be Using.webm	10.3 MB
02. Your First SQL Statement.webm	14.6 MB
03. Retrieving Specific Columns of Information.webm	7.0 MB
04. Categorizing Your Output with AS.webm	9.1 MB
05. Review & Practice with SQL Playgrounds.webm	5.0 MB
/.../03. Finding the Data You Want/
01. Searching Tables with WHERE.webm	16.1 MB
02. Filtering by Comparing Values.webm	9.1 MB
03. Filtering on More than One Condition.webm	7.3 MB
04. Filtering by Dates.webm	5.5 MB
05. Searching Within a Set of Values.webm	6.3 MB
06. Searching Within a Range of Values.webm	6.8 MB
07. Finding Data that Matches a Pattern.webm	5.9 MB
08. Filtering Out or Finding Missing Information.webm	4.4 MB
09. Review & Practice with SQL Playgrounds.webm	10.0 MB
10. Need SQL Practice.md	0.9 KB
02. Turn Documents Into Apps with Coda/
Turn Documents Into Apps with Coda.md	1.4 KB
03. Modifying Data with SQL/
Modifying Data with SQL.md	5.1 KB
/.../01. Adding Data to a Database/
01. Introduction to CRUD.webm	9.1 MB
02. Adding a Row to a Table.webm	14.4 MB
03. Adding Multiple Rows to a Table.webm	4.3 MB
04. Review and Practice.webm	3.3 MB
/.../02. Updating Data in a Database/
01. Update All Rows or Columns in a Table.webm	5.6 MB
02. Updating Specific Rows.webm	10.1 MB
03. Review and Practice.webm	2.9 MB
/.../03. Deleting Data From a Database/
01. Removing Data from All Rows in a Table.webm	3.7 MB
02. Removing Specific Rows.webm	7.5 MB
03. Review and Practice.webm	2.8 MB
/.../04. Handling Errors When Manipulating Data/
01. Introduction to Transactions.webm	12.4 MB
02. Rolling Back from Transactions.webm	4.1 MB
03. Databases with Frameworks.webm	5.4 MB
04. Reporting with SQL/
Reporting with SQL.md	8.4 KB
/.../01. Ordering, Limiting and Paging Results/
01. Overview.webm	12.4 MB
02. Retrieving Results in a Particular Order.webm	11.7 MB
03. Limiting the Number of Results.webm	12.1 MB
04. Paging Through Results.webm	7.6 MB
05. Practice Session.webm	2.9 MB
/.../02. Working with Text/
01. What Are Functions.webm	11.1 MB
02. Adding Text Columns Together.webm	9.5 MB
03. Single vs Double Quotes.md	0.7 KB
04. Finding the Length of Text.webm	7.9 MB
05. Changing the Case of Text Columns.webm	5.8 MB
06. Creating Excerpts From Text.webm	5.5 MB
07. Replacing Portions of Text.webm	6.5 MB
08. Practice Session.webm	7.1 MB
/.../03. Aggregate and Numeric Functions/
01. Counting Results.webm	10.3 MB
02. Counting Groups of Rows.webm	5.9 MB
03. Getting the Grand Total.webm	14.4 MB
04. Calculating Averages.webm	4.0 MB
05. Getting Minimum and Maximum Values.webm	4.7 MB
06. Performing Math on Numeric Types.webm	6.7 MB
07. Practice Session.webm	6.8 MB
/.../04. Date and Time Functions/
01. Differences Between Databases.webm	7.9 MB
02. Creating Up-to-the-Minute Reports.webm	9.1 MB
03. Calculating Dates.webm	8.0 MB
04. Formatting Dates For Reporting.webm	7.7 MB
05. Practice Session.webm	5.2 MB
05. Querying Relational Databases/
Querying Relational Databases.md	7.7 KB
/.../01. Database Normalization/
01. Why We Make Databases Relational.webm	17.8 MB
02. Database Normalization.webm	7.7 MB
03. How Normalization Helps Us.webm	18.3 MB
04. Set Theory and Relational Databases.webm	25.1 MB
05. Theoretical Groundwork.webm	3.9 MB
/.../02. Database Keys/
01. Unique Keys.webm	9.8 MB
02. Primary Keys.webm	5.5 MB
03. Foreign Keys.webm	17.4 MB
/.../03. Table Relationships/
01. One to Many Relationships.webm	9.2 MB
02. Many to Many Relationships.webm	11.5 MB
03. One to One Relationships.webm	6.6 MB
04. Modeling Table Relationships.webm	11.2 MB
/.../04. Joining Table Data with SQL/
01. Join Queries.webm	9.8 MB
02. Inner Joins.webm	12.8 MB
03. Outer Joins.webm	10.5 MB
04. Review and Practice.webm	5.2 MB
/.../05. Set Operations/
01. What are Set Operations.webm	3.7 MB
02. Union Operations.webm	10.0 MB
03. Union All Operations.webm	5.3 MB
04. Intersect Operations.webm	6.6 MB
05. Except Operations.webm	7.1 MB
06. Review and Practice.webm	6.9 MB
/06. Subqueries/
01. What are Subqueries.webm	7.1 MB
02. Using IN with Subqueries to Filter Data.webm	5.0 MB
03. Using a Subquery to Create a Temporary Table (Part 1).webm	10.3 MB
04. Using a Subquery to Create a Temporary Table (Part 2).webm	14.8 MB
05. Review and Practice.webm	9.0 MB
06. Common Table Expressions Using WITH/
01. What is a Common Table Expression.webm	20.3 MB
02. Convert a Subquery to a CTE.webm	10.0 MB
03. Using Multiple CTEs in a Query.webm	17.2 MB
Common Table Expressions Using WITH.md	1.0 KB
07. SQL Reporting by Example/
SQL Reporting by Example.md	4.1 KB
/.../01. Orientation Selecting Data/
01. Introduction.webm	14.8 MB
02. Learning the Database.webm	8.3 MB
03. Listing Subjects.webm	4.0 MB
04. Counting Students.webm	2.5 MB
05. Finding the ID.webm	2.1 MB
06. Listing Teachers.webm	3.5 MB
07. A Students.webm	7.1 MB
/.../02. Day 1 Joining Tables/
01. Calculating School Capacity.webm	4.2 MB
02. The Biggest Room.webm	3.1 MB
03. Subjects in the Big Room.webm	4.3 MB
04. 8th Grade Teachers.webm	8.1 MB
05. 7th Grade Science.webm	5.1 MB
06. Elective Teachers.webm	7.2 MB
/.../03. Day 2 Advanced Selecting/
01. Student Schedule.webm	8.5 MB
02. A Smelly Issue.webm	8.4 MB
03. Students A to M.webm	5.1 MB
04. Students by Grade.webm	6.0 MB
05. Predicting the Future.webm	8.0 MB
/.../04. Day 3 Getting Good at Grouping/
01. Busiest Teachers.webm	6.7 MB
02. Multi-Subject Teachers.webm	5.3 MB
03. Janis Schedule.webm	10.0 MB
04. Least Popular Subject.webm	6.1 MB
05. Finding the Troublemaker.webm	10.0 MB
06. Most Popular Teacher.webm	9.4 MB
07. Bus Troubles.webm	7.4 MB
Total files 121