LinkedIn Learning - SQL Essential Training

Files:

• 01- Understanding SQL.mp4 (22.7 MB)
• 01- Understanding SQL.en.srt (1.9 KB)
• 02- How to use the exercise files.en.srt (1.8 KB)
• 02- How to use the exercise files.mp4 (2.5 MB)
• 03- Course overview.en.srt (2.5 KB)
• 03- Course overview.mp4 (2.6 MB)
• 04- Installing on Windows.en.srt (9.7 KB)
• 04- Installing on Windows.mp4 (16.3 MB)
• 05- Installing on a Mac.en.srt (12.5 KB)
• 05- Installing on a Mac.mp4 (17.9 MB)
• 06- About SQL.en.srt (6.1 KB)
• 06- About SQL.mp4 (6.2 MB)
• 07- Database organization.en.srt (4.5 KB)
• 07- Database organization.mp4 (5.5 MB)
• 08- The SELECT statement.en.srt (8.6 KB)
• 08- The SELECT statement.mp4 (12.8 MB)
• 09- Selecting rows.en.srt (3.7 KB)
• 09- Selecting rows.mp4 (7.7 MB)
• 10- Selecting columns.en.srt (2.2 KB)
• 10- Selecting columns.mp4 (4.7 MB)
• 11- Counting rows.en.srt (2.9 KB)
• 11- Counting rows.mp4 (4.3 MB)
• 12- Inserting data.en.srt (2.8 KB)
• 12- Inserting data.mp4 (4.3 MB)
• 13- Updating data.en.srt (3.0 KB)
• 13- Updating data.mp4 (5.2 MB)
• 14- Deleting data.en.srt (1.6 KB)
• 14- Deleting data.mp4 (2.7 MB)
• 15- Creating a table.en.srt (4.5 KB)
• 15- Creating a table.mp4 (6.3 MB)
• 16- Deleting a table.en.srt (3.4 KB)
• 16- Deleting a table.mp4 (5.0 MB)
• 17- Inserting rows.en.srt (4.6 KB)
• 17- Inserting rows.mp4 (7.9 MB)
• 18- Deleting rows.en.srt (3.0 KB)
• 18- Deleting rows.mp4 (4.9 MB)
• 19- The NULL value.en.srt (7.7 KB)
• 19- The NULL value.mp4 (14.2 MB)
• 20- Constraining columns.en.srt (7.0 KB)
• 20- Constraining columns.mp4 (11.1 MB)
• 21- Changing a schema.en.srt (3.8 KB)
• 21- Changing a schema.mp4 (5.8 MB)
• 22- ID columns.en.srt (5.4 KB)
• 22- ID columns.mp4 (7.3 MB)
• 23- Filtering data.en.srt (10.1 KB)
• 23- Filtering data.mp4 (19.5 MB)
• 24- Removing duplicates.en.srt (4.6 KB)
• 24- Removing duplicates.mp4 (7.8 MB)
• 25- Ordering output.en.srt (5.2 KB)
• 25- Ordering output.mp4 (8.6 MB)
• 26- Conditional expressions.en.srt (4.1 KB)
• 26- Conditional expressions.mp4 (6.1 MB)
• 27- Understanding JOIN.en.srt (3.7 KB)
• 27- Understanding JOIN.mp4 (4.2 MB)
• 28- Accessing related tables.en.srt (10.2 KB)
• 28- Accessing related tables.mp4 (15.9 MB)
• 29- Relating multiple tables.en.srt (7.6 KB)
• 29- Relating multiple tables.mp4 (13.8 MB)
• 30- About SQL strings.en.srt (2.5 KB)
• 30- About SQL strings.mp4 (3.0 MB)
• 31- Finding the length of a string.en.srt (2.8 KB)
• 31- Finding the length of a string.mp4 (4.6 MB)
• 32- Selecting part of a string.en.srt (5.2 KB)
• 32- Selecting part of a string.mp4 (8.3 MB)
• 33- Removing spaces.en.srt (2.5 KB)
• 33- Removing spaces.mp4 (3.3 MB)
• 34- Folding case.en.srt (3.6 KB)
• 34- Folding case.mp4 (5.4 MB)
• 35- Numeric types.en.srt (5.0 KB)
• 35- Numeric types.mp4 (4.9 MB)
• 36- What type is that value.en.srt (3.4 KB)
• 36- What type is that value.mp4 (4.9 MB)
• 37- Integer division.en.srt (2.9 KB)
• 37- Integer division.mp4 (4.3 MB)
• 38- Rounding numbers.en.srt (1.7 KB)
• 38- Rounding numbers.mp4 (2.6 MB)
• 39- Dates and times.en.srt (3.5 KB)
• 39- Dates and times.mp4 (3.5 MB)
• 40- Date- and time-related functions.en.srt (3.2 KB)
• 40- Date- and time-related functions.mp4 (5.2 MB)
• 41- What are aggregates.en.srt (7.6 KB)
• 41- What are aggregates.mp4 (11.9 MB)
• 42- Using aggregate functions.en.srt (2.0 KB)
• 42- Using aggregate functions.mp4 (3.6 MB)
• 43- Aggregating DISTINCT values.en.srt (2.8 KB)
• 43- Aggregating DISTINCT values.mp4 (4.0 MB)
• 44- What are transactions.en.srt (3.5 KB)
• 44- What are transactions.mp4 (3.5 MB)
• 45- Data integrity.en.srt (6.3 KB)
• 45- Data integrity.mp4 (10.6 MB)
• 46- Performance.en.srt (4.3 KB)
• 46- Performance.mp4 (7.3 MB)
• 47- Automating data with triggers.en.srt (6.8 KB)
• 47- Automating data with triggers.mp4 (10.7 MB)
• 48- Preventing updates.en.srt (6.5 KB)
• 48- Preventing updates.mp4 (9.7 MB)
• 49- Example - Timestamps.en.srt (5.3 KB)
• 49- Example - Timestamps.mp4 (9.4 MB)
• 50- Creating a subselect.en.srt (4.4 KB)
• 50- Creating a subselect.mp4 (8.2 MB)
• 51- Searching within a result set.en.srt (4.7 KB)
• 51- Searching within a result set.mp4 (8.3 MB)
• 52- Creating a view.en.srt (3.2 KB)
• 52- Creating a view.mp4 (6.3 MB)
• 53- Creating a joined view.en.srt (4.0 KB)
• 53- Creating a joined view.mp4 (8.0 MB)
• 54- Embedding SQL.en.srt (8.6 KB)
• 54- Embedding SQL.mp4 (13.4 MB)
• 55- The SELECT functions.en.srt (9.8 KB)
• 55- The SELECT functions.mp4 (17.8 MB)
• 56- The INSERT, UPDATE, and DELETE functions.en.srt (5.8 KB)
• 56- The INSERT, UPDATE, and DELETE functions.mp4 (9.8 MB)
• 57- Goodbye.en.srt (1.8 KB)
• 57- Goodbye.mp4 (3.5 MB)
• Ex_Files_SQL_EssT.zip (259.7 KB)