Filename Size 01- Understanding SQL.en.srt 1.9 KB 01- Understanding SQL.mp4 22.7 MB 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 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 MB 17- Inserting rows.en.srt 4.6 KB 17- Inserting rows.mp4 7.9 MB 18- Deleting rows.en.srt 3 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 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 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 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 KB 42- Using aggregate functions.mp4 3.6 MB 43- Aggregating DISTINCT values.en.srt 2.8 KB 43- Aggregating DISTINCT values.mp4 4 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