https://img100.pixhost.to/images/617/539499712_359020115_tuto.jpg
880.86 MB | 00:04:36 | webm | 1280X720 | 16:9
Genre: eLearning | Language : English
Files Included :
01 Why This Course (5.88 MB)
02 Data is Everywhere (16.07 MB)
03 Talking to Databases with SQL (8.04 MB)
04 Organizing Data with Databases (8.63 MB)
05 Types of Data (7.65 MB)
01 Tools Well be Using (9.82 MB)
02 Your First SQL Statement (13.95 MB)
03 Retrieving Specific Columns of Information (6.64 MB)
04 Categorizing Your Output with AS (8.65 MB)
05 Review & Practice with SQL Playgrounds (4.72 MB)
01 Searching Tables with WHERE (15.33 MB)
02 Filtering by Comparing Values (8.72 MB)
03 Filtering on More than One Condition (6.97 MB)
04 Filtering by Dates (5.28 MB)
05 Searching Within a Set of Values (6.02 MB)
06 Searching Within a Range of Values (6.5 MB)
07 Finding Data that Matches a Pattern (5.67 MB)
08 Filtering Out or Finding Missing Information (4.19 MB)
09 Review & Practice with SQL Playgrounds (9.55 MB)
01 Introduction to CRUD (8.66 MB)
02 Adding a Row to a Table (13.7 MB)
03 Adding Multiple Rows to a Table (4.1 MB)
04 Review and Practice (3.18 MB)
01 Update All Rows or Columns in a Table (5.36 MB)
02 Updating Specific Rows (9.64 MB)
03 Review and Practice (2.76 MB)
01 Removing Data from All Rows in a Table (3.5 MB)
02 Removing Specific Rows (7.16 MB)
03 Review and Practice (2.62 MB)
01 Introduction to Transactions (11.8 MB)
02 Rolling Back from Transactions (3.94 MB)
03 Databases with Frameworks (5.11 MB)
01 Overview (11.78 MB)
02 Retrieving Results in a Particular Order (11.2 MB)
03 Limiting the Number of Results (11.56 MB)
04 Paging Through Results (7.28 MB)
05 Practice Session (2.77 MB)
01 What Are Functions (10.58 MB)
02 Adding Text Columns Together (9.09 MB)
04 Finding the Length of Text (7.57 MB)
05 Changing the Case of Text Columns (5.52 MB)
06 Creating Excerpts From Text (5.23 MB)
07 Replacing Portions of Text (6.19 MB)
08 Practice Session (6.8 MB)
01 Counting Results (9.8 MB)
02 Counting Groups of Rows (5.65 MB)
03 Getting the Grand Total (13.74 MB)
04 Calculating Averages (3.86 MB)
05 Getting Minimum and Maximum Values (4.5 MB)
06 Performing Math on Numeric Types (6.37 MB)
07 Practice Session (6.53 MB)
01 Differences Between Databases (7.5 MB)
02 Creating Up-to-the-Minute Reports (8.66 MB)
03 Calculating Dates (7.63 MB)
04 Formatting Dates For Reporting (7.37 MB)
05 Practice Session (5 MB)
01 Why We Make Databases Relational (17.02 MB)
02 Database Normalization (7.38 MB)
03 How Normalization Helps Us (17.46 MB)
04 Set Theory and Relational Databases (23.9 MB)
05 Theoretical Groundwork (3.74 MB)
01 Unique Keys (9.35 MB)
02 Primary Keys (5.23 MB)
03 Foreign Keys (16.57 MB)
01 One to Many Relationships (8.8 MB)
02 Many to Many Relationships (10.97 MB)
03 One to One Relationships (6.31 MB)
04 Modeling Table Relationships (10.72 MB)
01 Join Queries (9.37 MB)
02 Inner Joins (12.25 MB)
03 Outer Joins (10.02 MB)
04 Review and Practice (4.93 MB)
01 What are Set Operations (3.54 MB)
02 Union Operations (9.5 MB)
03 Union All Operations (5.02 MB)
04 Intersect Operations (6.32 MB)
05 Except Operations (6.79 MB)
06 Review and Practice (6.54 MB)
01 What are Subqueries (6.81 MB)
02 Using IN with Subqueries to Filter Data (4.79 MB)
03 Using a Subquery to Create a Temporary Table (Part 1) (9.84 MB)
04 Using a Subquery to Create a Temporary Table (Part 2) (14.08 MB)
05 Review and Practice (8.59 MB)
01 What is a Common Table Expression (19.39 MB)
02 Convert a Subquery to a CTE (9.56 MB)
03 Using Multiple CTEs in a Query (16.39 MB)
01 Introduction (14.12 MB)
02 Learning the Database (7.88 MB)
03 Listing Subjects (3.86 MB)
04 Counting Students (2.4 MB)
05 Finding the ID (2.04 MB)
06 Listing Teachers (3.34 MB)
07 A Students (6.77 MB)
01 Calculating School Capacity (4.04 MB)
02 The Biggest Room (2.94 MB)
03 Subjects in the Big Room (4.05 MB)
04 8th Grade Teachers (7.71 MB)
05 7th Grade Science (4.83 MB)
06 Elective Teachers (6.86 MB)
01 Student Schedule (8.13 MB)
02 A Smelly Issue (8.01 MB)
03 Students A to M (4.82 MB)
04 Students by Grade (5.73 MB)
05 Predicting the Future (7.62 MB)
01 Busiest Teachers (6.42 MB)
02 Multi-Subject Teachers (5.05 MB)
03 Janis Schedule (9.53 MB)
04 Least Popular Subject (5.85 MB)
05 Finding the Troublemaker (9.55 MB)
06 Most Popular Teacher (8.99 MB)
07 Bus Troubles (7.09 MB)]
Screenshot
https://images2.imgbox.com/f6/ac/hKulE0yo_o.jpg
https://filecrypt.cc/Container/CD2DCEB766.html
https://fikper.com/9f3k0yxKlz/TeamTreehouse.-.Beginning.SQL.Track.rar.html
https://filecrypt.cc/Container/A01389714A.html
Видео
