Magnetz

Title: Lynda ComGroup: NOGRPSource: Lynda.Com

Info Hash

E027F1EFAC87A1EF2A3112C1C234E16FC39038FE

Source

Unverified

Total Size

450.88 MB

Total Files

60

Seeders

1

Leechers

0

Health

1.00

Score

2

Type

Bookware

File List

File	Size
01. Introduction/01_01-Welcome.mp4	8.61 MB
01. Introduction/01_02-Using the exercise files.mp4	2.95 MB
01. Introduction/01_03-Course overview.mp4	7.76 MB
01. Introduction/01_04-Installing the test environment on a Mac.mp4	31.02 MB
01. Introduction/01_05-Installing the test environment on a PC.mp4	53.05 MB
01. Introduction/01_06-What is SQL.mp4	7.49 MB
02. SQL Quick Start/02_01-Quick-start introduction.mp4	1.76 MB
02. SQL Quick Start/02_02-Using the basic SELECT statement.mp4	16.94 MB
02. SQL Quick Start/02_03-Selecting rows.mp4	6.33 MB
02. SQL Quick Start/02_04-Selecting columns.mp4	5.03 MB
02. SQL Quick Start/02_05-Counting rows.mp4	2.54 MB
02. SQL Quick Start/02_06-Inserting data.mp4	6.58 MB
02. SQL Quick Start/02_07-Updating data.mp4	4.06 MB
02. SQL Quick Start/02_08-Deleting data.mp4	3.07 MB
03. Fundamentals/03_01-Databases and tables.mp4	2.37 MB
03. Fundamentals/03_02-SQL syntax overview.mp4	5.84 MB
03. Fundamentals/03_03-Formatting SQL.mp4	2.44 MB
03. Fundamentals/03_04-Creating tables.mp4	3.63 MB
03. Fundamentals/03_05-Deleting a table with DROP TABLE.mp4	3.49 MB
03. Fundamentals/03_06-Inserting rows into a table.mp4	5.55 MB
03. Fundamentals/03_07-Deleting rows from a table.mp4	3.24 MB
03. Fundamentals/03_08-Understanding NULL.mp4	6.63 MB
03. Fundamentals/03_09-Controlling column behaviors with constraints.mp4	5.78 MB
03. Fundamentals/03_10-Changing a schema with ALTER.mp4	4.14 MB
03. Fundamentals/03_11-Creating an ID column.mp4	4.28 MB
03. Fundamentals/03_12-Filtering data with WHERE, LIKE, and IN.mp4	24.41 MB
03. Fundamentals/03_13-Removing duplicates with SELECT DISTINCT.mp4	11.43 MB
03. Fundamentals/03_14-Sorting with ORDER BY.mp4	11.25 MB
03. Fundamentals/03_15-Conditional expressions with CASE.mp4	6.27 MB
04. Relationships/04_01-Understanding joins.mp4	3.11 MB
04. Relationships/04_02-Accessing related tables with JOIN.mp4	8.59 MB
04. Relationships/04_03-Using multiple related tables.mp4	8.65 MB
05. Strings/05_01-About SQL strings.mp4	1.99 MB
05. Strings/05_02-Finding the length of a string.mp4	2.66 MB
05. Strings/05_03-Selecting part of a string.mp4	4.49 MB
05. Strings/05_04-Removing spaces with TRIM.mp4	8.38 MB
05. Strings/05_05-Making strings uppercase and lowercase.mp4	3.99 MB
06. Numbers/06_01-About numeric types.mp4	3.12 MB
06. Numbers/06_02-Finding the type of a value.mp4	3.71 MB
06. Numbers/06_03-Integer division and remainders.mp4	3.42 MB
06. Numbers/06_04-Rounding numbers.mp4	1.8 MB
07. Dates/07_01-Dates and times.mp4	2.39 MB
07. Dates/07_02-Date- and time-related functions.mp4	3.95 MB
08. Aggregates/08_01-How aggregates work.mp4	8.66 MB
08. Aggregates/08_02-Using aggregate functions.mp4	6.49 MB
08. Aggregates/08_03-Aggregating DISTINCT values.mp4	5.67 MB
09. Transactions/09_01-Why use transactions.mp4	2.58 MB
09. Transactions/09_02-Using transactions.mp4	12.55 MB
10. Triggers/10_01-Updating a table with a trigger.mp4	8.76 MB
10. Triggers/10_02-Preventing automatic updates with a trigger.mp4	8.83 MB
10. Triggers/10_03-Automating timestamps with a trigger.mp4	7.74 MB
11. Subselects and Views/11_01-Creating a simple subselect.mp4	6.81 MB
11. Subselects and Views/11_02-Searching within a result set.mp4	8.12 MB
11. Subselects and Views/11_03-Creating a view.mp4	7.69 MB
11. Subselects and Views/11_04-Creating a joined view.mp4	7.39 MB
12. A Simple CRUD Application/12_01-Touring the CRUD application.mp4	15.69 MB
12. A Simple CRUD Application/12_02-The SELECT functions.mp4	16.17 MB
12. A Simple CRUD Application/12_03-The INSERT, UPDATE, and DELETE functions.mp4	7.72 MB
13. Conclusion/13_01-Goodbye.mp4	1.6 MB
Ex_Files_SQL_EssT.zip	245.3 KB

Trackers

No trackers found.