|
|
0
|
|
63.8 KB
|
|
|
01. Busiest Teachers.webm
|
WEBM
|
6.4 MB
|
|
|
01. Calculating School Capacity.webm
|
WEBM
|
4 MB
|
|
|
01. Counting Results.webm
|
WEBM
|
9.8 MB
|
|
|
01. Differences Between Databases.webm
|
WEBM
|
7.5 MB
|
|
|
01. Introduction to CRUD.webm
|
WEBM
|
8.7 MB
|
|
|
01. Introduction to Transactions.webm
|
WEBM
|
11.8 MB
|
|
|
01. Introduction.webm
|
WEBM
|
14.1 MB
|
|
|
01. Join Queries.webm
|
WEBM
|
9.4 MB
|
|
|
01. One to Many Relationships.webm
|
WEBM
|
8.8 MB
|
|
|
01. Overview.webm
|
WEBM
|
11.8 MB
|
|
|
01. Removing Data from All Rows in a Table.webm
|
WEBM
|
3.5 MB
|
|
|
01. Searching Tables with WHERE.webm
|
WEBM
|
15.3 MB
|
|
|
01. Student Schedule.webm
|
WEBM
|
8.1 MB
|
|
|
01. Tools Well be Using.webm
|
WEBM
|
9.8 MB
|
|
|
01. Unique Keys.webm
|
WEBM
|
9.3 MB
|
|
|
01. Update All Rows or Columns in a Table.webm
|
WEBM
|
5.4 MB
|
|
|
01. What Are Functions.webm
|
WEBM
|
10.6 MB
|
|
|
01. What are Set Operations.webm
|
WEBM
|
3.5 MB
|
|
|
01. What are Subqueries.webm
|
WEBM
|
6.8 MB
|
|
|
1
|
|
108.5 KB
|
|
|
01. What is a Common Table Expression.webm
|
WEBM
|
19.4 MB
|
|
|
01. Why This Course.webm
|
WEBM
|
5.9 MB
|
|
|
01. Why We Make Databases Relational.webm
|
WEBM
|
17 MB
|
|
|
02. A Smelly Issue.webm
|
WEBM
|
8 MB
|
|
|
02. Adding Text Columns Together.webm
|
WEBM
|
9.1 MB
|
|
|
02. Adding a Row to a Table.webm
|
WEBM
|
13.7 MB
|
|
|
02. Convert a Subquery to a CTE.webm
|
WEBM
|
9.6 MB
|
|
|
02. Counting Groups of Rows.webm
|
WEBM
|
5.7 MB
|
|
|
02. Creating Up-to-the-Minute Reports.webm
|
WEBM
|
8.7 MB
|
|
|
02. Data is Everywhere.webm
|
WEBM
|
16.1 MB
|
|
|
2
|
|
38.8 KB
|
|
|
02. Database Normalization.webm
|
WEBM
|
7.4 MB
|
|
|
02. Filtering by Comparing Values.webm
|
WEBM
|
8.7 MB
|
|
|
02. Inner Joins.webm
|
WEBM
|
12.3 MB
|
|
|
02. Learning the Database.webm
|
WEBM
|
7.9 MB
|
|
|
02. Many to Many Relationships.webm
|
WEBM
|
11 MB
|
|
|
02. Multi-Subject Teachers.webm
|
WEBM
|
5 MB
|
|
|
02. Primary Keys.webm
|
WEBM
|
5.2 MB
|
|
|
02. Removing Specific Rows.webm
|
WEBM
|
7.2 MB
|
|
|
02. Retrieving Results in a Particular Order.webm
|
WEBM
|
11.2 MB
|
|
|
02. Rolling Back from Transactions.webm
|
WEBM
|
3.9 MB
|
|
|
02. The Biggest Room.webm
|
WEBM
|
2.9 MB
|
|
|
02. Union Operations.webm
|
WEBM
|
9.5 MB
|
|
|
02. Updating Specific Rows.webm
|
WEBM
|
9.6 MB
|
|
|
02. Using IN with Subqueries to Filter Data.webm
|
WEBM
|
4.8 MB
|
|
|
02. Your First SQL Statement.webm
|
WEBM
|
13.9 MB
|
|
|
03. Calculating Dates.webm
|
WEBM
|
7.6 MB
|
|
|
03. Databases with Frameworks.webm
|
WEBM
|
5.1 MB
|
|
|
03. Foreign Keys.webm
|
WEBM
|
16.6 MB
|
|
|
03. Listing Subjects.webm
|
WEBM
|
3.9 MB
|
|
|
03. Outer Joins.webm
|
WEBM
|
10 MB
|
|
|
03. Retrieving Specific Columns of Information.webm
|
WEBM
|
6.6 MB
|
|
|
3
|
|
492 KB
|
|
|
03. Adding Multiple Rows to a Table.webm
|
WEBM
|
4.1 MB
|
|
|
03. Filtering on More than One Condition.webm
|
WEBM
|
7 MB
|
|
|
03. Getting the Grand Total.webm
|
WEBM
|
13.7 MB
|
|
|
03. How Normalization Helps Us.webm
|
WEBM
|
17.5 MB
|
|
|
03. Janis Schedule.webm
|
WEBM
|
9.5 MB
|
|
|
03. Limiting the Number of Results.webm
|
WEBM
|
11.6 MB
|
|
|
03. One to One Relationships.webm
|
WEBM
|
6.3 MB
|
|
|
03. Review and Practice.webm
|
WEBM
|
2.6 MB
|
|
|
03. Single vs Double Quotes.md
|
MD
|
716.8 B
|
|
|
03. Students A to M.webm
|
WEBM
|
4.8 MB
|
|
|
03. Subjects in the Big Room.webm
|
WEBM
|
4.1 MB
|
|
|
03. Talking to Databases with SQL.webm
|
WEBM
|
8 MB
|
|
|
03. Union All Operations.webm
|
WEBM
|
5 MB
|
|
|
03. Using Multiple CTEs in a Query.webm
|
WEBM
|
16.4 MB
|
|
|
03. Using a Subquery to Create a Temporary Table (Part 1).webm
|
WEBM
|
9.8 MB
|
|
|
04. 8th Grade Teachers.webm
|
WEBM
|
7.7 MB
|
|
|
04. Calculating Averages.webm
|
WEBM
|
3.9 MB
|
|
|
04. Categorizing Your Output with AS.webm
|
WEBM
|
8.7 MB
|
|
|
04. Counting Students.webm
|
WEBM
|
2.4 MB
|
|
|
04. Filtering by Dates.webm
|
WEBM
|
5.3 MB
|
|
|
04. Finding the Length of Text.webm
|
WEBM
|
7.6 MB
|
|
|
04. Formatting Dates For Reporting.webm
|
WEBM
|
7.4 MB
|
|
|
04. Intersect Operations.webm
|
WEBM
|
6.3 MB
|
|
|
4
|
|
441.5 KB
|
|
|
04. Least Popular Subject.webm
|
WEBM
|
5.8 MB
|
|
|
04. Modeling Table Relationships.webm
|
WEBM
|
10.7 MB
|
|
|
04. Organizing Data with Databases.webm
|
WEBM
|
8.6 MB
|
|
|
04. Paging Through Results.webm
|
WEBM
|
7.3 MB
|
|
|
04. Review and Practice.webm
|
WEBM
|
3.2 MB
|
|
|
04. Set Theory and Relational Databases.webm
|
WEBM
|
23.9 MB
|
|
|
04. Students by Grade.webm
|
WEBM
|
5.7 MB
|
|
|
04. Using a Subquery to Create a Temporary Table (Part 2).webm
|
WEBM
|
14.1 MB
|
|
|
05. 7th Grade Science.webm
|
WEBM
|
4.8 MB
|
|
|
05. Changing the Case of Text Columns.webm
|
WEBM
|
5.5 MB
|
|
|
05. Except Operations.webm
|
WEBM
|
6.8 MB
|
|
|
05. Finding the ID.webm
|
WEBM
|
2 MB
|
|
|
05. Finding the Troublemaker.webm
|
WEBM
|
9.6 MB
|
|
|
05. Getting Minimum and Maximum Values.webm
|
WEBM
|
4.5 MB
|
|
|
05. Practice Session.webm
|
WEBM
|
5 MB
|
|
|
05. Predicting the Future.webm
|
WEBM
|
7.6 MB
|
|
|
05. Review & Practice with SQL Playgrounds.webm
|
WEBM
|
4.7 MB
|
|
|
05. Review and Practice.webm
|
WEBM
|
8.6 MB
|
|
|
05. Searching Within a Set of Values.webm
|
WEBM
|
6 MB
|
|
|
05. Theoretical Groundwork.webm
|
WEBM
|
3.7 MB
|
|
|
05. Types of Data.webm
|
WEBM
|
7.6 MB
|
|
|
06. Creating Excerpts From Text.webm
|
WEBM
|
5.2 MB
|
|
|
06. Elective Teachers.webm
|
WEBM
|
6.9 MB
|
|
|
06. Listing Teachers.webm
|
WEBM
|
3.3 MB
|
|
|
06. Most Popular Teacher.webm
|
WEBM
|
9 MB
|
|
|
06. Performing Math on Numeric Types.webm
|
WEBM
|
6.4 MB
|
|
|
06. Review and Practice.webm
|
WEBM
|
6.5 MB
|
|
|
06. Searching Within a Range of Values.webm
|
WEBM
|
6.5 MB
|
|
|
07. A Students.webm
|
WEBM
|
6.8 MB
|
|
|
07. Bus Troubles.webm
|
WEBM
|
7.1 MB
|
|
|
07. Finding Data that Matches a Pattern.webm
|
WEBM
|
5.7 MB
|
|
|
07. Practice Session.webm
|
WEBM
|
6.5 MB
|
|
|
07. Replacing Portions of Text.webm
|
WEBM
|
6.2 MB
|
|
|
08. Filtering Out or Finding Missing Information.webm
|
WEBM
|
4.2 MB
|
|
|
08. Practice Session.webm
|
WEBM
|
6.8 MB
|
|
|
09. Review & Practice with SQL Playgrounds.webm
|
WEBM
|
9.5 MB
|
|
|
10. Need SQL Practice.md
|
MD
|
921.6 B
|
|
|
Beginning SQL.md
|
MD
|
2.8 KB
|
|
|
Common Table Expressions Using WITH.md
|
MD
|
1 KB
|
|
|
Modifying Data with SQL.md
|
MD
|
5 KB
|
|
|
Querying Relational Databases.md
|
MD
|
7.6 KB
|
|
|
Reporting with SQL.md
|
MD
|
8.2 KB
|
|
|
SQL Basics.md
|
MD
|
6.4 KB
|
|
|
SQL Reporting by Example.md
|
MD
|
4 KB
|
|
|
Turn Documents Into Apps with Coda.md
|
MD
|
1.4 KB
|
|
|
TutsNode.com.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
|
|
5
|
|
117.4 KB
|
|
|
6
|
|
439.1 KB
|
|
|
7
|
|
179 KB
|
|
|
8
|
|
391.4 KB
|
|
|
9
|
|
428.6 KB
|
|
|
10
|
|
55.3 KB
|
|
|
11
|
|
266.5 KB
|
|
|
12
|
|
307.2 KB
|
|
|
13
|
|
252.8 KB
|
|
|
14
|
|
208.1 KB
|
|
|
15
|
|
226.2 KB
|
|
|
16
|
|
455.5 KB
|
|
|
17
|
|
305.1 KB
|
|
|
18
|
|
31.8 KB
|
|
|
19
|
|
282.1 KB
|
|
|
20
|
|
428.8 KB
|
|
|
21
|
|
487.2 KB
|
|
|
22
|
|
159.8 KB
|
|
|
23
|
|
187.1 KB
|
|
|
24
|
|
203.9 KB
|
|
|
25
|
|
365.2 KB
|
|
|
26
|
|
448.4 KB
|
|
|
27
|
|
460.8 KB
|
|
|
28
|
|
463.3 KB
|
|
|
29
|
|
478.8 KB
|
|
|
30
|
|
1.5 KB
|
|
|
31
|
|
138.2 KB
|
|
|
32
|
|
154.1 KB
|
|
|
33
|
|
415.3 KB
|
|
|
34
|
|
7.1 KB
|
|
|
35
|
|
200.5 KB
|
|
|
36
|
|
288.6 KB
|
|
|
37
|
|
346.3 KB
|
|
|
38
|
|
347.8 KB
|
|
|
39
|
|
357.5 KB
|
|
|
40
|
|
375.3 KB
|
|
|
41
|
|
420.2 KB
|
|
|
42
|
|
380.6 KB
|
|
|
43
|
|
468.2 KB
|
|
|
44
|
|
506.3 KB
|
|
|
45
|
|
118.9 KB
|
|
|
46
|
|
297.9 KB
|
|
|
47
|
|
360.9 KB
|
|
|
48
|
|
377.1 KB
|
|
|
49
|
|
385.1 KB
|
|
|
50
|
|
443 KB
|
|
|
51
|
|
1.7 KB
|
|
|
52
|
|
123.1 KB
|
|
|
53
|
|
133.5 KB
|
|
|
54
|
|
220.6 KB
|
|
|
55
|
|
352.1 KB
|
|
|
56
|
|
420.7 KB
|
|
|
57
|
|
29.7 KB
|
|
|
58
|
|
144.8 KB
|
|
|
59
|
|
199.4 KB
|
|
|
60
|
|
201.4 KB
|
|
|
61
|
|
215.6 KB
|
|
|
62
|
|
236.7 KB
|
|
|
63
|
|
372.6 KB
|
|
|
64
|
|
475.7 KB
|
|
|
65
|
|
484.1 KB
|
|
|
66
|
|
3.8 KB
|
|
|
67
|
|
79.7 KB
|
|
|
68
|
|
131.7 KB
|
|
|
69
|
|
185.2 KB
|
|
|
70
|
|
193.8 KB
|
|
|
71
|
|
319.1 KB
|
|
|
72
|
|
491.8 KB
|
|
|
73
|
|
124.9 KB
|
|
|
74
|
|
156.3 KB
|
|
|
75
|
|
279.2 KB
|
|
|
76
|
|
340.4 KB
|
|
|
77
|
|
354.5 KB
|
|
|
78
|
|
491.1 KB
|
|
|
79
|
|
145 KB
|
|
|
80
|
|
228 KB
|
|
|
81
|
|
271.4 KB
|
|
|
82
|
|
271.6 KB
|
|
|
83
|
|
396.1 KB
|
|
|
84
|
|
461 KB
|
|
|
85
|
|
493.1 KB
|
|
|
86
|
|
2.3 KB
|
|
|
87
|
|
72.7 KB
|
|
|
88
|
|
171.7 KB
|
|
|
89
|
|
180 KB
|
|
|
90
|
|
212 KB
|
|
|
91
|
|
285.9 KB
|
|
|
92
|
|
507.5 KB
|
|
|
93
|
|
319.5 KB
|
|
|
94
|
|
407.4 KB
|
|
|
95
|
|
457 KB
|
|
|
96
|
|
467.7 KB
|
|
|
97
|
|
59.9 KB
|
|
|
98
|
|
141 KB
|
|
|
99
|
|
145.3 KB
|
|
|
100
|
|
268 KB
|
|
|
101
|
|
468.4 KB
|
|
|
102
|
|
1.3 KB
|
|
|
103
|
|
164.2 KB
|
|
|
104
|
|
325.4 KB
|
|
|
105
|
|
59 KB
|
|
|
106
|
|
235.5 KB
|
|
|
107
|
|
250.5 KB
|
|
|
108
|
|
384.5 KB
|
|
|
109
|
|
98.1 KB
|
