Other
TeamTreehouse - Beginning SQL (Track) [Thomas]
Torrent info
Torrent Files List
05. Querying Relational Databases (Size: 881.50 MB) (Files: 124)
05. Querying Relational Databases
01. Database Normalization
04. Set Theory and Relational Databases.webm
01. Why We Make Databases Relational.webm
02. Database Normalization.webm
03. How Normalization Helps Us.webm
05. Theoretical Groundwork.webm
Querying Relational Databases.md
02. Database Keys
01. Unique Keys.webm
02. Primary Keys.webm
03. Foreign Keys.webm
03. Table Relationships
01. One to Many Relationships.webm
02. Many to Many Relationships.webm
03. One to One Relationships.webm
04. Modeling Table Relationships.webm
04. Joining Table Data with SQL
01. Join Queries.webm
02. Inner Joins.webm
03. Outer Joins.webm
04. Review and Practice.webm
05. Set Operations
01. What are Set Operations.webm
02. Union Operations.webm
03. Union All Operations.webm
04. Intersect Operations.webm
05. Except Operations.webm
06. Review and Practice.webm
06. Subqueries
01. What are Subqueries.webm
02. Using IN with Subqueries to Filter Data.webm
03. Using a Subquery to Create a Temporary Table (Part 1).webm
04. Using a Subquery to Create a Temporary Table (Part 2).webm
05. Review and Practice.webm
README.txt
TeamTreehouse - Beginning SQL (Track) [Thomas].jpg
TeamTreehouse - Beginning SQL (Track) [Thomas].png
01. SQL Basics
SQL Basics.md
01. Data, Databases and SQL
01. Why This Course.webm
02. Data is Everywhere.webm
03. Talking to Databases with SQL.webm
04. Organizing Data with Databases.webm
05. Types of Data.webm
02. Getting Data from a Database
01. Tools Well be Using.webm
02. Your First SQL Statement.webm
03. Retrieving Specific Columns of Information.webm
04. Categorizing Your Output with AS.webm
05. Review & Practice with SQL Playgrounds.webm
03. Finding the Data You Want
01. Searching Tables with WHERE.webm
02. Filtering by Comparing Values.webm
03. Filtering on More than One Condition.webm
04. Filtering by Dates.webm
05. Searching Within a Set of Values.webm
06. Searching Within a Range of Values.webm
07. Finding Data that Matches a Pattern.webm
08. Filtering Out or Finding Missing Information.webm
09. Review & Practice with SQL Playgrounds.webm
10. Need SQL Practice.md
02. Turn Documents Into Apps with Coda
Turn Documents Into Apps with Coda.md
03. Modifying Data with SQL
Modifying Data with SQL.md
01. Adding Data to a Database
01. Introduction to CRUD.webm
02. Adding a Row to a Table.webm
03. Adding Multiple Rows to a Table.webm
04. Review and Practice.webm
02. Updating Data in a Database
01. Update All Rows or Columns in a Table.webm
02. Updating Specific Rows.webm
03. Review and Practice.webm
03. Deleting Data From a Database
01. Removing Data from All Rows in a Table.webm
02. Removing Specific Rows.webm
03. Review and Practice.webm
04. Handling Errors When Manipulating Data
01. Introduction to Transactions.webm
02. Rolling Back from Transactions.webm
03. Databases with Frameworks.webm
04. Reporting with SQL
Reporting with SQL.md
01. Ordering, Limiting and Paging Results
01. Overview.webm
02. Retrieving Results in a Particular Order.webm
03. Limiting the Number of Results.webm
04. Paging Through Results.webm
05. Practice Session.webm
02. Working with Text
01. What Are Functions.webm
02. Adding Text Columns Together.webm
03. Single vs Double Quotes.md
04. Finding the Length of Text.webm
05. Changing the Case of Text Columns.webm
06. Creating Excerpts From Text.webm
07. Replacing Portions of Text.webm
08. Practice Session.webm
03. Aggregate and Numeric Functions
01. Counting Results.webm
02. Counting Groups of Rows.webm
03. Getting the Grand Total.webm
04. Calculating Averages.webm
05. Getting Minimum and Maximum Values.webm
06. Performing Math on Numeric Types.webm
07. Practice Session.webm
04. Date and Time Functions
01. Differences Between Databases.webm
02. Creating Up-to-the-Minute Reports.webm
03. Calculating Dates.webm
04. Formatting Dates For Reporting.webm
05. Practice Session.webm
Beginning SQL.md
06. Common Table Expressions Using WITH
01. What is a Common Table Expression.webm
02. Convert a Subquery to a CTE.webm
03. Using Multiple CTEs in a Query.webm
Common Table Expressions Using WITH.md
07. SQL Reporting by Example
SQL Reporting by Example.md
01. Orientation Selecting Data
01. Introduction.webm
02. Learning the Database.webm
03. Listing Subjects.webm
04. Counting Students.webm
05. Finding the ID.webm
06. Listing Teachers.webm
07. A Students.webm
02. Day 1 Joining Tables
01. Calculating School Capacity.webm
02. The Biggest Room.webm
03. Subjects in the Big Room.webm
04. 8th Grade Teachers.webm
05. 7th Grade Science.webm
06. Elective Teachers.webm
03. Day 2 Advanced Selecting
01. Student Schedule.webm
02. A Smelly Issue.webm
03. Students A to M.webm
04. Students by Grade.webm
05. Predicting the Future.webm
04. Day 3 Getting Good at Grouping
01. Busiest Teachers.webm
02. Multi-Subject Teachers.webm
03. Janis Schedule.webm
04. Least Popular Subject.webm
05. Finding the Troublemaker.webm
06. Most Popular Teacher.webm
07. Bus Troubles.webm
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch TeamTreehouse - Beginning SQL (Track) [Thomas] Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
