Lynda SQL Essential Training | 85F60E6C42AC88318CEE2E8A14A5A97165589041

Lynda SQL Essential Training

Name	Lynda - SQL Essential Training	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	432.9 MB
Total Files	109
Hash	85F60E6C42AC88318CEE2E8A14A5A97165589041

/2.1. Installation/
07.Installing on a Mac - Part II.mp4	31.6 MB
04.Installing on Windows - Part I.en.srt	14.2 KB
04.Installing on Windows - Part I.mp4	20.8 MB
05.Installing on Windows - Part II.en.srt	17.3 KB
05.Installing on Windows - Part II.mp4	27.7 MB
06.Installing on a Mac - Part I.en.srt	12.9 KB
06.Installing on a Mac - Part I.mp4	16.9 MB
07.Installing on a Mac - Part II.en.srt	21.0 KB
/1.Introduction/
01.Welcome.mp4	6.2 MB
02.Exercise files.mp4	6.3 MB
03.Course overview.en.srt	2.6 KB
03.Course overview.mp4	3.5 MB
01.Welcome.en.srt	1.9 KB
/3.2. SQL Overview/
08.About the overview.en.srt	6.2 KB
08.About the overview.mp4	6.9 MB
09.Database organization.en.srt	4.7 KB
09.Database organization.mp4	6.2 MB
10.The SELECT statement.en.srt	9.9 KB
10.The SELECT statement.mp4	13.0 MB
11.Selecting rows.en.srt	2.8 KB
11.Selecting rows.mp4	4.3 MB
12.Selecting columns.mp4	3.1 MB
13.Counting rows.en.srt	3.8 KB
13.Counting rows.mp4	4.9 MB
14.Inserting data.mp4	6.0 MB
15.Updating data.mp4	4.7 MB
16.Deleting data.en.srt	2.7 KB
16.Deleting data.mp4	2.9 MB
/4.3. Fundamental Concepts/
17.Creating a table.en.srt	6.9 KB
17.Creating a table.mp4	6.0 MB
18.Deleting a table.en.srt	4.1 KB
18.Deleting a table.mp4	3.8 MB
19.Inserting rows.en.srt	5.0 KB
19.Inserting rows.mp4	5.8 MB
20.Deleting rows.en.srt	2.7 KB
20.Deleting rows.mp4	3.3 MB
21.The NULL value.mp4	8.9 MB
22.Constraining columns.en.srt	5.4 KB
22.Constraining columns.mp4	5.7 MB
23.Changing a schema.en.srt	3.1 KB
23.Changing a schema.mp4	3.4 MB
24.ID columns.en.srt	4.1 KB
24.ID columns.mp4	3.9 MB
25.Filtering data.mp4	12.0 MB
26.Removing duplicates.en.srt	3.7 KB
26.Removing duplicates.mp4	5.2 MB
27.Ordering output.mp4	6.6 MB
28.Conditional expressions.en.srt	4.6 KB
28.Conditional expressions.mp4	4.6 MB
/5.4. Relationships/
29.Understanding JOIN.mp4	4.8 MB
30.Accessing related tables.mp4	8.5 MB
31.Relating multiple tables.en.srt	5.7 KB
31.Relating multiple tables.mp4	8.4 MB
/6.5. Strings/
32.About SQL strings.en.srt	2.6 KB
32.About SQL strings.mp4	3.3 MB
33.Finding the length of a string.mp4	4.5 MB
34.Selecting part of a string.en.srt	3.4 KB
34.Selecting part of a string.mp4	3.4 MB
35.Removing spaces.mp4	6.5 MB
36.Folding case.en.srt	2.8 KB
36.Folding case.mp4	4.0 MB
/7.6. Numbers/
37.Numeric types.en.srt	6.5 KB
37.Numeric types.mp4	6.8 MB
38.What type is that value.en.srt	3.5 KB
38.What type is that value.mp4	3.5 MB
39.Integer division.en.srt	2.9 KB
39.Integer division.mp4	3.0 MB
40.Rounding numbers.en.srt	1.5 KB
40.Rounding numbers.mp4	1.7 MB
/8.7. Dates and Times/
41.Dates and times.en.srt	3.3 KB
41.Dates and times.mp4	4.0 MB
42.Date- and time-related functions.en.srt	3.5 KB
42.Date- and time-related functions.mp4	4.1 MB
/9.8. Aggregates/
43.What are aggregates.en.srt	6.6 KB
43.What are aggregates.mp4	8.7 MB
44.Using aggregate functions.en.srt	2.7 KB
44.Using aggregate functions.mp4	4.1 MB
45.Aggregating DISTINCT values.en.srt	3.1 KB
45.Aggregating DISTINCT values.mp4	4.0 MB
/10.9. Transactions/
46.What are transactions.en.srt	3.6 KB
46.What are transactions.mp4	4.6 MB
47.Data integrity.en.srt	5.5 KB
47.Data integrity.mp4	5.9 MB
48.Performance.en.srt	6.0 KB
48.Performance.mp4	6.2 MB
/11.10. Triggers/
49.Automating data with triggers.en.srt	5.1 KB
49.Automating data with triggers.mp4	6.8 MB
50.Preventing updates.en.srt	4.2 KB
50.Preventing updates.mp4	5.2 MB
51.Example - Timestamps.en.srt	3.8 KB
51.Example - Timestamps.mp4	5.6 MB
/12.11. Views and Subselects/
52.Creating a subselect.en.srt	6.0 KB
52.Creating a subselect.mp4	6.6 MB
53.Searching within a result set.en.srt	4.6 KB
53.Searching within a result set.mp4	6.2 MB
54.Creating a view.mp4	8.1 MB
55.Creating a joined view.en.srt	3.6 KB
55.Creating a joined view.mp4	6.1 MB
/13.12. Defined Functions/
56.Overview.en.srt	1.7 KB
56.Overview.mp4	2.6 MB
57.Defining functions in PHP.mp4	13.7 MB
/14.13. A Simple CRUD Application/
58.Embedding SQL.en.srt	7.3 KB
58.Embedding SQL.mp4	11.8 MB
59.The SELECT functions.en.srt	5.2 KB
59.The SELECT functions.mp4	10.5 MB
60.The INSERT, UPDATE, and DELETE functions.mp4	11.9 MB
/15.Conclusion/
61.Goodbye.en.srt	1.8 KB
61.Goodbye.mp4	3.2 MB
/Exercise Files/
Ex_Files_SQL_EssT.zip	256.6 KB
Total files 109