Lynda com Tutorial SQL | 1D5E6A941D63E727D1D0789265CDE9EC9BAE8101

Lynda com Tutorial SQL

Name	Lynda.com Tutorial (SQL)	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	174.3 MB
Total Files	49
Hash	1D5E6A941D63E727D1D0789265CDE9EC9BAE8101

/01. Introduction/
01 01. Introduction.mov	21.4 MB
01 02. What is SQL.mov	1.4 MB
01 03. Understanding the terminology.mov	3.8 MB
01 04. About the examples.mov	2.8 MB
01 05. Setting up the test environment on a PC.mov	16.5 MB
01 06. Setting up the example data on a PC.mov	5.7 MB
01 07. Setting up the test environment on a Mac.mov	17.1 MB
01 08. Setting up the example data on a Mac.mov	4.3 MB
/02. SQL Quick Start/
02 01. Quick-start introduction.mov	489.7 KB
02 02. Using the basic SELECT statement.mov	1.6 MB
02 03. Selecting columns.mov	5.0 MB
02 04. Selecting rows.mov	2.5 MB
02 05. Counting things.mov	3.0 MB
/03. SQL Essentials/
03 01. Organization Databases and tables.mov	1.8 MB
03 02. SQL syntax overview.mov	1.8 MB
03 03. Formatting SQL.mov	3.1 MB
03 04. Creating a database and tables.mov	3.9 MB
03 05. Inserting data.mov	1.9 MB
03 06. Reading tables with JOIN.mov	4.6 MB
03 07. Filtering data with WHERE LIKE and IN.mov	6.1 MB
03 08. Removing duplicates with DISTINCT.mov	1.6 MB
03 09. Sorting with ORDER BY.mov	3.8 MB
03 10. Updating data.mov	1.5 MB
03 11. Deleting data.mov	1.8 MB
/04. IDs and Indexes/
04 01. Creating relationships between tables.mov	880.6 KB
04 02. Accessing related tables with JOIN.mov	3.1 MB
04 03. About indexes.mov	1.1 MB
/05. Strings/
05 01. About the string functions.mov	2.3 MB
05 02. Finding the length of a string.mov	1.1 MB
05 03. Finding part of a string.mov	1.4 MB
05 04. Removing spaces with TRIM.mov	1.7 MB
05 05. Making strings UPPERCASE and lowercase.mov	801.9 KB
/06. Numbers/
06 01. When to use numeric functions.mov	1.3 MB
06 02. Finding the absolute value.mov	1.3 MB
06 03. Rounding numbers.mov	1.8 MB
06 04. Integer division and remainders.mov	4.0 MB
/07. Dates/
07 01. Dates and times.mov	1.2 MB
07 02. Date and time-related functions.mov	1.9 MB
/08. Aggregates/
08 01. How aggregates work.mov	3.2 MB
08 02. Removing duplicates with DISTINCT.mov	803.0 KB
08 03. Using aggregate functions.mov	2.3 MB
/09. The CRUD Application/
09 01. About the CRUD application.mov	7.9 MB
09 02. The SELECT functions.mov	7.1 MB
09 03. The INSERT functions.mov	3.6 MB
09 04. The UPDATE functions.mov	3.7 MB
09 05. The DELETE functions.mov	4.0 MB
/10. Conclusion/
10 01. Goodbye.mov	448.0 KB
/Exercise Files/
Ex_Files_SQL_EssT.7z	88.1 KB
Ex_Files_SQL_EssT.sitx	75.0 KB
Total files 49