Skip to content

TeamTreehouse - Beginning SQL (Track)

Sign up to create lists
Report TeamTreehouse - Beginning SQL (Track)
Unverified source. This magnet is from an unverified source. The content may be unsafe or mislabeled. Proceed with caution.
Title: TeamTreehouseGroup: NOGRPSource: TeamTreehouse
Info Hash
91CB722CC55EF319DE149B183272D4C882A3F8D3
Source
Unverified
Total Size
880.86 MB
Total Files
100
Seeders
2
Leechers
0
Health
2.00
Score
4
Type
Bookware

File List

FileSize
Beginning SQL.md2.8 KB
01. SQL Basics/SQL Basics.md6.42 KB
01. SQL Basics/01. Data, Databases and SQL/01. Why This Course.webm5.88 MB
01. SQL Basics/01. Data, Databases and SQL/02. Data is Everywhere.webm16.07 MB
01. SQL Basics/01. Data, Databases and SQL/03. Talking to Databases with SQL.webm8.04 MB
01. SQL Basics/01. Data, Databases and SQL/04. Organizing Data with Databases.webm8.63 MB
01. SQL Basics/01. Data, Databases and SQL/05. Types of Data.webm7.65 MB
01. SQL Basics/02. Getting Data from a Database/01. Tools Well be Using.webm9.82 MB
01. SQL Basics/02. Getting Data from a Database/02. Your First SQL Statement.webm13.95 MB
01. SQL Basics/02. Getting Data from a Database/03. Retrieving Specific Columns of Information.webm6.64 MB
01. SQL Basics/02. Getting Data from a Database/04. Categorizing Your Output with AS.webm8.65 MB
01. SQL Basics/02. Getting Data from a Database/05. Review & Practice with SQL Playgrounds.webm4.72 MB
01. SQL Basics/03. Finding the Data You Want/01. Searching Tables with WHERE.webm15.33 MB
01. SQL Basics/03. Finding the Data You Want/02. Filtering by Comparing Values.webm8.72 MB
01. SQL Basics/03. Finding the Data You Want/03. Filtering on More than One Condition.webm6.97 MB
01. SQL Basics/03. Finding the Data You Want/04. Filtering by Dates.webm5.28 MB
01. SQL Basics/03. Finding the Data You Want/05. Searching Within a Set of Values.webm6.02 MB
01. SQL Basics/03. Finding the Data You Want/06. Searching Within a Range of Values.webm6.5 MB
01. SQL Basics/03. Finding the Data You Want/07. Finding Data that Matches a Pattern.webm5.67 MB
01. SQL Basics/03. Finding the Data You Want/08. Filtering Out or Finding Missing Information.webm4.19 MB
01. SQL Basics/03. Finding the Data You Want/09. Review & Practice with SQL Playgrounds.webm9.55 MB
01. SQL Basics/03. Finding the Data You Want/10. Need SQL Practice.md933 B
02. Turn Documents Into Apps with Coda/Turn Documents Into Apps with Coda.md1.39 KB
03. Modifying Data with SQL/Modifying Data with SQL.md5 KB
03. Modifying Data with SQL/01. Adding Data to a Database/01. Introduction to CRUD.webm8.66 MB
03. Modifying Data with SQL/01. Adding Data to a Database/02. Adding a Row to a Table.webm13.7 MB
03. Modifying Data with SQL/01. Adding Data to a Database/03. Adding Multiple Rows to a Table.webm4.1 MB
03. Modifying Data with SQL/01. Adding Data to a Database/04. Review and Practice.webm3.18 MB
03. Modifying Data with SQL/02. Updating Data in a Database/01. Update All Rows or Columns in a Table.webm5.36 MB
03. Modifying Data with SQL/02. Updating Data in a Database/02. Updating Specific Rows.webm9.64 MB
03. Modifying Data with SQL/02. Updating Data in a Database/03. Review and Practice.webm2.76 MB
03. Modifying Data with SQL/03. Deleting Data From a Database/01. Removing Data from All Rows in a Table.webm3.5 MB
03. Modifying Data with SQL/03. Deleting Data From a Database/02. Removing Specific Rows.webm7.16 MB
03. Modifying Data with SQL/03. Deleting Data From a Database/03. Review and Practice.webm2.62 MB
03. Modifying Data with SQL/04. Handling Errors When Manipulating Data/01. Introduction to Transactions.webm11.8 MB
03. Modifying Data with SQL/04. Handling Errors When Manipulating Data/02. Rolling Back from Transactions.webm3.94 MB
03. Modifying Data with SQL/04. Handling Errors When Manipulating Data/03. Databases with Frameworks.webm5.11 MB
04. Reporting with SQL/Reporting with SQL.md8.24 KB
04. Reporting with SQL/01. Ordering, Limiting and Paging Results/01. Overview.webm11.78 MB
04. Reporting with SQL/01. Ordering, Limiting and Paging Results/02. Retrieving Results in a Particular Order.webm11.2 MB
04. Reporting with SQL/01. Ordering, Limiting and Paging Results/03. Limiting the Number of Results.webm11.56 MB
04. Reporting with SQL/01. Ordering, Limiting and Paging Results/04. Paging Through Results.webm7.28 MB
04. Reporting with SQL/01. Ordering, Limiting and Paging Results/05. Practice Session.webm2.77 MB
04. Reporting with SQL/02. Working with Text/01. What Are Functions.webm10.58 MB
04. Reporting with SQL/02. Working with Text/02. Adding Text Columns Together.webm9.09 MB
04. Reporting with SQL/02. Working with Text/03. Single vs Double Quotes.md705 B
04. Reporting with SQL/02. Working with Text/04. Finding the Length of Text.webm7.57 MB
04. Reporting with SQL/02. Working with Text/05. Changing the Case of Text Columns.webm5.52 MB
04. Reporting with SQL/02. Working with Text/06. Creating Excerpts From Text.webm5.23 MB
04. Reporting with SQL/02. Working with Text/07. Replacing Portions of Text.webm6.19 MB
04. Reporting with SQL/02. Working with Text/08. Practice Session.webm6.8 MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/01. Counting Results.webm9.8 MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/02. Counting Groups of Rows.webm5.65 MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/03. Getting the Grand Total.webm13.74 MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/04. Calculating Averages.webm3.86 MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/05. Getting Minimum and Maximum Values.webm4.5 MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/06. Performing Math on Numeric Types.webm6.37 MB
04. Reporting with SQL/03. Aggregate and Numeric Functions/07. Practice Session.webm6.53 MB
04. Reporting with SQL/04. Date and Time Functions/01. Differences Between Databases.webm7.5 MB
04. Reporting with SQL/04. Date and Time Functions/02. Creating Up-to-the-Minute Reports.webm8.66 MB
04. Reporting with SQL/04. Date and Time Functions/03. Calculating Dates.webm7.63 MB
04. Reporting with SQL/04. Date and Time Functions/04. Formatting Dates For Reporting.webm7.37 MB
04. Reporting with SQL/04. Date and Time Functions/05. Practice Session.webm5 MB
05. Querying Relational Databases/Querying Relational Databases.md7.55 KB
05. Querying Relational Databases/01. Database Normalization/01. Why We Make Databases Relational.webm17.02 MB
05. Querying Relational Databases/01. Database Normalization/02. Database Normalization.webm7.38 MB
05. Querying Relational Databases/01. Database Normalization/03. How Normalization Helps Us.webm17.46 MB
05. Querying Relational Databases/01. Database Normalization/04. Set Theory and Relational Databases.webm23.9 MB
05. Querying Relational Databases/01. Database Normalization/05. Theoretical Groundwork.webm3.74 MB
05. Querying Relational Databases/02. Database Keys/01. Unique Keys.webm9.35 MB
05. Querying Relational Databases/02. Database Keys/02. Primary Keys.webm5.23 MB
05. Querying Relational Databases/02. Database Keys/03. Foreign Keys.webm16.57 MB
05. Querying Relational Databases/03. Table Relationships/01. One to Many Relationships.webm8.8 MB
05. Querying Relational Databases/03. Table Relationships/02. Many to Many Relationships.webm10.97 MB
05. Querying Relational Databases/03. Table Relationships/03. One to One Relationships.webm6.31 MB
05. Querying Relational Databases/03. Table Relationships/04. Modeling Table Relationships.webm10.72 MB
05. Querying Relational Databases/04. Joining Table Data with SQL/01. Join Queries.webm9.37 MB
05. Querying Relational Databases/04. Joining Table Data with SQL/02. Inner Joins.webm12.25 MB
05. Querying Relational Databases/04. Joining Table Data with SQL/03. Outer Joins.webm10.02 MB
05. Querying Relational Databases/04. Joining Table Data with SQL/04. Review and Practice.webm4.93 MB
05. Querying Relational Databases/05. Set Operations/01. What are Set Operations.webm3.54 MB
05. Querying Relational Databases/05. Set Operations/02. Union Operations.webm9.5 MB
05. Querying Relational Databases/05. Set Operations/03. Union All Operations.webm5.02 MB
05. Querying Relational Databases/05. Set Operations/04. Intersect Operations.webm6.32 MB
05. Querying Relational Databases/05. Set Operations/05. Except Operations.webm6.79 MB
05. Querying Relational Databases/05. Set Operations/06. Review and Practice.webm6.54 MB
05. Querying Relational Databases/06. Subqueries/01. What are Subqueries.webm6.81 MB
05. Querying Relational Databases/06. Subqueries/02. Using IN with Subqueries to Filter Data.webm4.79 MB
05. Querying Relational Databases/06. Subqueries/03. Using a Subquery to Create a Temporary Table (Part 1).webm9.84 MB
05. Querying Relational Databases/06. Subqueries/04. Using a Subquery to Create a Temporary Table (Part 2).webm14.08 MB
05. Querying Relational Databases/06. Subqueries/05. Review and Practice.webm8.59 MB
06. Common Table Expressions Using WITH/01. What is a Common Table Expression.webm19.39 MB
06. Common Table Expressions Using WITH/02. Convert a Subquery to a CTE.webm9.56 MB
06. Common Table Expressions Using WITH/03. Using Multiple CTEs in a Query.webm16.39 MB
06. Common Table Expressions Using WITH/Common Table Expressions Using WITH.md1018 B
07. SQL Reporting by Example/SQL Reporting by Example.md3.99 KB
07. SQL Reporting by Example/01. Orientation Selecting Data/01. Introduction.webm14.12 MB
07. SQL Reporting by Example/01. Orientation Selecting Data/02. Learning the Database.webm7.88 MB
07. SQL Reporting by Example/01. Orientation Selecting Data/03. Listing Subjects.webm3.86 MB
07. SQL Reporting by Example/01. Orientation Selecting Data/04. Counting Students.webm2.4 MB

Trackers

No trackers found.