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