SQL Essential Training 2023

Files Included :

001 The data-driven world.mp4 (7.15 MB)
MP4
002 What you should know.mp4 (21.48 MB)
MP4
003 Relational database theory.mp4 (25.11 MB)
MP4
004 The SQLite database engine.mp4 (26.45 MB)
MP4
005 WSDA Music (sample database).mp4 (20.26 MB)
MP4
006 The DB Browser software.mp4 (11.12 MB)
MP4
007 How to install DB Browser.mp4 (16.68 MB)
MP4
008 Learning tips.mp4 (14.47 MB)
MP4
009 How to access the DB Browser for SQLite software.mp4 (10.13 MB)
MP4
010 Load the sample database file.mp4 (21.82 MB)
MP4
011 Getting familiar with a database.mp4 (26.07 MB)
MP4
012 The browse data area.mp4 (19.09 MB)
MP4
013 The query writing area.mp4 (21.97 MB)
MP4
014 Query commenting.mp4 (16.93 MB)
MP4
015 The Query Concept.mp4 (35.61 MB)
MP4
016 Query composition.mp4 (68.51 MB)
MP4
017 Query composition best practices.mp4 (28.02 MB)
MP4
018 Column custom names.mp4 (38.19 MB)
MP4
019 Sorting query results.mp4 (36.75 MB)
MP4
020 Limiting query results.mp4 (27.95 MB)
MP4
021 Types of SQL operators.mp4 (22.85 MB)
MP4
022 Filter and analyze numeric data.mp4 (40.72 MB)
MP4
023 BETWEEN and IN operators.mp4 (39.51 MB)
MP4
024 Filter and analyze text data.mp4 (47.54 MB)
MP4
025 Search records without an exact match.mp4 (61.11 MB)
MP4
026 Filter and analyze using dates.mp4 (56.55 MB)
MP4
027 Filter records based on more than one condition.mp4 (32.96 MB)
MP4
028 Logical operator OR.mp4 (24.96 MB)
MP4
029 Brackets and order.mp4 (54.57 MB)
MP4
030 IF THEN logic with CASE.mp4 (96.63 MB)
MP4
031 Joins explained.mp4 (16.24 MB)
MP4
032 How tables share a relationship Part 1.mp4 (54.72 MB)
MP4
033 How tables share a relationship Part 2.mp4 (41.67 MB)
MP4
034 Simplifying JOINs.mp4 (50.85 MB)
MP4
035 Types of JOINs.mp4 (25.17 MB)
MP4
036 The INNER JOIN.mp4 (21.73 MB)
MP4
037 The LEFT JOIN.mp4 (27.7 MB)
MP4
038 The RIGHT JOIN.mp4 (32.69 MB)
MP4
039 Tables and Entity Relationship diagrams.mp4 (40.74 MB)
MP4
040 Joining many tables.mp4 (51.01 MB)
MP4
041 Calculating with functions.mp4 (15.45 MB)
MP4
042 String, date, and aggregate function types.mp4 (6.29 MB)
MP4
043 Connecting strings.mp4 (45.47 MB)
MP4
044 Separating text.mp4 (40.1 MB)
MP4
045 UPPER and LOWER string functions.mp4 (19.24 MB)
MP4
046 Date functions.mp4 (50.89 MB)
MP4
047 Aggregate functions.mp4 (40.98 MB)
MP4
048 Nesting functions.mp4 (27.38 MB)
MP4
049 Grouping your query results.mp4 (8.93 MB)
MP4
050 Filtering with a grouped condition.mp4 (51.9 MB)
MP4
051 Grouping with the WHERE clause.mp4 (19.44 MB)
MP4
052 Grouping with the HAVING clause.mp4 (40.56 MB)
MP4
053 Grouping with the WHERE and HAVING clause.mp4 (28.22 MB)
MP4
054 Grouping by many fields.mp4 (27.95 MB)
MP4
055 Subqueries and aggregate functions.mp4 (12.41 MB)
MP4
056 SELECT clause subquery.mp4 (52.06 MB)
MP4
057 WHERE clause subquery.mp4 (49.63 MB)
MP4
058 Non-aggregate subqueries.mp4 (31.18 MB)
MP4
059 IN clause subquery.mp4 (35.09 MB)
MP4
060 DISTINCT clause subquery.mp4 (60.08 MB)
MP4
061 View introduction.mp4 (13.61 MB)
MP4
062 Creating a view.mp4 (42.68 MB)
MP4
063 Editing a view.mp4 (36.74 MB)
MP4
064 Joining views.mp4 (28.88 MB)
MP4
065 Deleting views.mp4 (19.33 MB)
MP4
066 Analysis and administration.mp4 (14.75 MB)
MP4
067 Inserting data.mp4 (50.99 MB)
MP4
068 Updating data.mp4 (34.2 MB)
MP4
069 Deleting data.mp4 (28.58 MB)
MP4
070 Project challenges.mp4 (19.25 MB)
MP4
071 Project solution Part 1.mp4 (29.12 MB)
MP4
072 Project solution Part 2.mp4 (76.4 MB)
MP4
073 Project solution Part 3.mp4 (63.1 MB)
MP4
074 Next steps and tips.mp4 (17.71 MB)
MP4