TorBT - Torrents and Magnet Links Search Engine

lynda.com - SQL Essential Training 2014

File Name
Size
01. Introduction/01_01-Welcome.mp4
8.6 MB
01. Introduction/01_02-Using the exercise files.mp4
2.9 MB
01. Introduction/01_03-Course overview.mp4
7.8 MB
01. Introduction/01_04-Installing the test environment on a Mac.mp4
31 MB
01. Introduction/01_05-Installing the test environment on a PC.mp4
53 MB
01. Introduction/01_06-What is SQL.mp4
7.5 MB
02. SQL Quick Start/02_01-Quick-start introduction.mp4
1.8 MB
02. SQL Quick Start/02_02-Using the basic SELECT statement.mp4
17 MB
02. SQL Quick Start/02_03-Selecting rows.mp4
6.3 MB
02. SQL Quick Start/02_04-Selecting columns.mp4
5.0 MB
02. SQL Quick Start/02_05-Counting rows.mp4
2.5 MB
02. SQL Quick Start/02_06-Inserting data.mp4
6.6 MB
02. SQL Quick Start/02_07-Updating data.mp4
4.1 MB
02. SQL Quick Start/02_08-Deleting data.mp4
3.1 MB
03. Fundamentals/03_01-Databases and tables.mp4
2.4 MB
03. Fundamentals/03_02-SQL syntax overview.mp4
5.8 MB
03. Fundamentals/03_03-Formatting SQL.mp4
2.4 MB
03. Fundamentals/03_04-Creating tables.mp4
3.6 MB
03. Fundamentals/03_05-Deleting a table with DROP TABLE.mp4
3.5 MB
03. Fundamentals/03_06-Inserting rows into a table.mp4
5.5 MB
03. Fundamentals/03_07-Deleting rows from a table.mp4
3.2 MB
03. Fundamentals/03_08-Understanding NULL.mp4
6.6 MB
03. Fundamentals/03_09-Controlling column behaviors with constraints.mp4
5.8 MB
03. Fundamentals/03_10-Changing a schema with ALTER.mp4
4.1 MB
03. Fundamentals/03_11-Creating an ID column.mp4
4.3 MB
03. Fundamentals/03_12-Filtering data with WHERE, LIKE, and IN.mp4
24 MB
03. Fundamentals/03_13-Removing duplicates with SELECT DISTINCT.mp4
11 MB
03. Fundamentals/03_14-Sorting with ORDER BY.mp4
11 MB
03. Fundamentals/03_15-Conditional expressions with CASE.mp4
6.3 MB
04. Relationships/04_01-Understanding joins.mp4
3.1 MB
04. Relationships/04_02-Accessing related tables with JOIN.mp4
8.6 MB
04. Relationships/04_03-Using multiple related tables.mp4
8.7 MB
05. Strings/05_01-About SQL strings.mp4
2.0 MB
05. Strings/05_02-Finding the length of a string.mp4
2.7 MB
05. Strings/05_03-Selecting part of a string.mp4
4.5 MB
05. Strings/05_04-Removing spaces with TRIM.mp4
8.4 MB
05. Strings/05_05-Making strings uppercase and lowercase.mp4
4.0 MB
06. Numbers/06_01-About numeric types.mp4
3.1 MB
06. Numbers/06_02-Finding the type of a value.mp4
3.7 MB
06. Numbers/06_03-Integer division and remainders.mp4
3.4 MB
06. Numbers/06_04-Rounding numbers.mp4
1.8 MB
07. Dates/07_01-Dates and times.mp4
2.4 MB
07. Dates/07_02-Date- and time-related functions.mp4
4.0 MB
08. Aggregates/08_01-How aggregates work.mp4
8.7 MB
08. Aggregates/08_02-Using aggregate functions.mp4
6.5 MB
08. Aggregates/08_03-Aggregating DISTINCT values.mp4
5.7 MB
09. Transactions/09_01-Why use transactions.mp4
2.6 MB
09. Transactions/09_02-Using transactions.mp4
12 MB
10. Triggers/10_01-Updating a table with a trigger.mp4
8.8 MB
10. Triggers/10_02-Preventing automatic updates with a trigger.mp4
8.8 MB
10. Triggers/10_03-Automating timestamps with a trigger.mp4
7.7 MB
11. Subselects and Views/11_01-Creating a simple subselect.mp4
6.8 MB
11. Subselects and Views/11_02-Searching within a result set.mp4
8.1 MB
11. Subselects and Views/11_03-Creating a view.mp4
7.7 MB
11. Subselects and Views/11_04-Creating a joined view.mp4
7.4 MB
12. A Simple CRUD Application/12_01-Touring the CRUD application.mp4
16 MB
12. A Simple CRUD Application/12_02-The SELECT functions.mp4
16 MB
12. A Simple CRUD Application/12_03-The INSERT, UPDATE, and DELETE functions.mp4
7.7 MB
13. Conclusion/13_01-Goodbye.mp4
1.6 MB
Ex_Files_SQL_EssT.zip
245 kB