| 01. Introduction | |||
| 01 01. Introduction.mov | 20.41 MB | ||
| 01 02. What is SQL.mov | 1.36 MB | ||
| 01 03. Understanding the terminology.mov | 3.58 MB | ||
| 01 04. About the examples.mov | 2.66 MB | ||
| 01 05. Setting up the test environment on a PC.mov | 15.76 MB | ||
| 01 06. Setting up the example data on a PC.mov | 5.47 MB | ||
| 01 07. Setting up the test environment on a Mac.mov | 16.29 MB | ||
| 01 08. Setting up the example data on a Mac.mov | 4.09 MB | ||
| 02. SQL Quick Start | |||
| 02 01. Quick-start introduction.mov | 478.19 KB | ||
| 02 02. Using the basic SELECT statement.mov | 1.5 MB | ||
| 02 03. Selecting columns.mov | 4.81 MB | ||
| 02 04. Selecting rows.mov | 2.37 MB | ||
| 02 05. Counting things.mov | 2.82 MB | ||
| 03. SQL Essentials | |||
| 03 01. Organization Databases and tables.mov | 1.7 MB | ||
| 03 02. SQL syntax overview.mov | 1.67 MB | ||
| 03 03. Formatting SQL.mov | 3 MB | ||
| 03 04. Creating a database and tables.mov | 3.75 MB | ||
| 03 05. Inserting data.mov | 1.83 MB | ||
| 03 06. Reading tables with JOIN.mov | 4.35 MB | ||
| 03 07. Filtering data with WHERE LIKE and IN.mov | 5.79 MB | ||
| 03 08. Removing duplicates with DISTINCT.mov | 1.54 MB | ||
| 03 09. Sorting with ORDER BY.mov | 3.65 MB | ||
| 03 10. Updating data.mov | 1.42 MB | ||
| 03 11. Deleting data.mov | 1.68 MB | ||
| 04. IDs and Indexes | |||
| 04 01. Creating relationships between tables.mov | 860 KB | ||
| 04 02. Accessing related tables with JOIN.mov | 2.97 MB | ||
| 04 03. About indexes.mov | 1.05 MB | ||
| 05. Strings | |||
| 05 01. About the string functions.mov | 2.21 MB | ||
| 05 02. Finding the length of a string.mov | 1 MB | ||
| 05 03. Finding part of a string.mov | 1.29 MB | ||
| 05 04. Removing spaces with TRIM.mov | 1.61 MB | ||
| 05 05. Making strings UPPERCASE and lowercase.mov | 783.13 KB | ||
| 06. Numbers | |||
| 06 01. When to use numeric functions.mov | 1.23 MB | ||
| 06 02. Finding the absolute value.mov | 1.21 MB | ||
| 06 03. Rounding numbers.mov | 1.67 MB | ||
| 06 04. Integer division and remainders.mov | 3.8 MB | ||
| 07. Dates | |||
| 07 01. Dates and times.mov | 1.16 MB | ||
| 07 02. Date and time-related functions.mov | 1.79 MB | ||
| 08. Aggregates | |||
| 08 01. How aggregates work.mov | 3.04 MB | ||
| 08 02. Removing duplicates with DISTINCT.mov | 784.17 KB | ||
| 08 03. Using aggregate functions.mov | 2.21 MB | ||
| 09. The CRUD Application | |||
| 09 01. About the CRUD application.mov | 7.51 MB | ||
| 09 02. The SELECT functions.mov | 6.76 MB | ||
| 09 03. The INSERT functions.mov | 3.48 MB | ||
| 09 04. The UPDATE functions.mov | 3.56 MB | ||
| 09 05. The DELETE functions.mov | 3.8 MB | ||
| 10. Conclusion | |||
| 10 01. Goodbye.mov | 437.46 KB | ||
| Exercise Files | |||
| Ex_Files_SQL_EssT.7z | 86.03 KB | ||
| Ex_Files_SQL_EssT.sitx | 73.26 KB |
This is a video tutorial for SQL from lynda.com in Quick-Time(.mov)
format
Contents:
01. Introduction
02. SQL Quick Start
03. SQL Essentials
04. IDs and Indexes
05. Strings
06. Numbers
07. Dates
08. Aggregates
09. The CRUD Application
10. Conclusion
And in last it has some exercises
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
The.Kidnap.And.Murder.Of.Lynda.Spence.2023.1080p.WEB.H264-CBFM Posted by
TvTeam in Movies
> Other Movies
|
2.95 GB | TvTeam | 1 year | 0 | 2 |
| 8 GB | HeVK | 1 year | 5 | 0 | |
|
Ensemble.Pour.Les.Fetes.Avec.Lynda.Lemay.2023.FRENCH.720p.WEB.DD5.1.x264-TFA Posted by
Paramore2k in Movies
> Other Movies
|
1.9 GB | Paramore2k | 2 years | 2 | 0 |
| 1.2 GB | KAT | 3 years | 0 | 1 | |
| 6.5 GB | HeVK | 4 years | 0 | 0 |
All Comments