SQL and PostgreSQL for Beginners - Become a SQL Expert

4.39 GB | 11min 54s | mp4 | 1920X1080 | 16:9
Genre:eLearning |Language:English

Files Included :
1 - Course Introduction.mp4 (12.55 MB)
2 - Course Curriculum.mp4 (21.75 MB)
111 - Section Introduction.mp4 (4.04 MB)
112 - Cloning a Database.mp4 (18.16 MB)
113 - Upper and Lower String Functions.mp4 (32.15 MB)
114 - Initcap Function.mp4 (20.85 MB)
115 - Left and Right String Functions.mp4 (44.11 MB)
116 - Reverse Function.mp4 (11.54 MB)
117 - Challenge 1 - String Functions.mp4 (2.92 MB)
118 - Solution 1 - String Functions.mp4 (196.38 MB)
119 - Substring Function.mp4 (33.94 MB)
120 - Replace Function.mp4 (77.01 MB)
121 - Split Part Function.mp4 (58.91 MB)
122 - Using the Cast Operator to Apply String Functions to Non-String Data Types.mp4 (29.35 MB)
123 - Challenge 2 - String Functions.mp4 (2.24 MB)
124 - Solution 2 - String Functions.mp4 (48.46 MB)
125 - Summary.mp4 (2.25 MB)
126 - Section Introduction.mp4 (1.84 MB)
127 - Conditional Statements in SQL.mp4 (18.74 MB)
128 - Basic CASE Expressions.mp4 (23.89 MB)
129 - Order of WHEN Clauses in CASE Expressions.mp4 (23.89 MB)
130 - Challenge 1 - Conditional Statements and Functions.mp4 (1.87 MB)
131 - Solution 1 - Conditional Statements and Functions.mp4 (42.54 MB)
132 - Case Expressions with Aggregate Functions.mp4 (39.13 MB)
133 - Further Case Expressions with Aggregate Functions.mp4 (19.89 MB)
134 - Challenge 2 - Conditional Statements and Functions.mp4 (2.76 MB)
135 - Solution 2 - Conditional Statements and Functions.mp4 (27.26 MB)
136 - COALESCE Function.mp4 (21.06 MB)
137 - NULLIF Function.mp4 (15.62 MB)
138 - Challenge 3 - Conditional Statements and Functions.mp4 (2.34 MB)
139 - Solution 3 - Conditional Statements and Functions.mp4 (25.69 MB)
140 - GREATEST and LEAST Functions.mp4 (23.62 MB)
141 - Summary.mp4 (2.1 MB)
142 - Section Introduction.mp4 (1.66 MB)
143 - Window Functions Explained.mp4 (7.22 MB)
144 - Basic Window Functions.mp4 (79.49 MB)
145 - Multiple Window Functions.mp4 (41.54 MB)
146 - Running Totals Using Window Functions.mp4 (19.4 MB)
147 - Challenge 1 - Window Functions.mp4 (2.09 MB)
148 - Solution 1 - Window Functions.mp4 (58.45 MB)
149 - ROW NUMBER Function.mp4 (27.61 MB)
150 - RANK and DENSE RANK Functions.mp4 (31.68 MB)
151 - FIRST VALUE and LAST VALUE Functions.mp4 (46.51 MB)
152 - Challenge 2 - Window Functions.mp4 (1.42 MB)
153 - Solution 2 - Window Functions.mp4 (22.22 MB)
154 - LAG Function.mp4 (71.46 MB)
155 - LEAD Function.mp4 (32.59 MB)
156 - NTH VALUE Function.mp4 (35.38 MB)
157 - Challenge 3 - Window Functions.mp4 (2.22 MB)
158 - Solution 3 - Window Functions.mp4 (29.95 MB)
159 - CUME DIST Function.mp4 (28.64 MB)
160 - PERCENT RANK Function.mp4 (21.45 MB)
161 - NTILE Function.mp4 (24.63 MB)
162 - Challenge 4 - Window Functions.mp4 (1.97 MB)
163 - Solution 4 - Window Functions.mp4 (20.99 MB)
164 - Summary.mp4 (3.69 MB)
4 - What is a Database.mp4 (5.62 MB)
5 - Relational Databases and SQL.mp4 (10 MB)
6 - Installing PostgreSQL for Mac.mp4 (68.08 MB)
7 - Installing PostgreSQL for Windows.mp4 (64.44 MB)
10 - Data Types Explained.mp4 (25.63 MB)
11 - Primary Keys and Foreign Keys.mp4 (10.39 MB)
12 - Unique, Not Null and Check Constraints.mp4 (12.91 MB)
13 - Creating Our First Table.mp4 (48.47 MB)
14 - Creating the Actors Table.mp4 (24.17 MB)
15 - Creating a Table with a Foreign Key.mp4 (28.05 MB)
16 - Creating the Movie Revenues Table.mp4 (26.78 MB)
17 - Creating a Junction Table.mp4 (22.01 MB)
18 - Modifying Tables Part 1 - Adding Columns.mp4 (37.59 MB)
19 - Modifying Tables Part 2 - Changing a Columns Data Type.mp4 (21.37 MB)
20 - Deleting Tables from a Database.mp4 (13.74 MB)
21 - Challenge - Data Definition Language.mp4 (3.26 MB)
22 - Solution - Data Definition Language.mp4 (42.2 MB)
23 - Section Summary.mp4 (2.47 MB)
8 - Section Introduction.mp4 (3.66 MB)
9 - Database Tables.mp4 (14.57 MB)
24 - Section Introduction.mp4 (1.48 MB)
25 - Inserting Data into a Table.mp4 (139.47 MB)
26 - Updating Data in a Table.mp4 (38.99 MB)
27 - Deleting Data from a Table.mp4 (19.67 MB)
28 - Inserting Data into Our Movie Data Database.mp4 (64.25 MB)
29 - Challenge - Data Manipulation Language.mp4 (2.81 MB)
30 - Solution - Data Manipulation Language.mp4 (64.12 MB)
31 - Section Summary.mp4 (1.27 MB)
32 - Section Introduction.mp4 (4.66 MB)
33 - Select Queries.mp4 (15.68 MB)
34 - Where Clauses.mp4 (52 MB)
35 - Logical Operators.mp4 (63.46 MB)
36 - Challenge 1 - Select Queries.mp4 (2.62 MB)
37 - Solution 1 - Select Queries.mp4 (30.03 MB)
38 - In, Not In.mp4 (29.59 MB)
39 - Like.mp4 (49.44 MB)
40 - Between.mp4 (61.81 MB)
41 - Challenge 2 - Select Queries.mp4 (3.61 MB)
42 - Solution 2 - Select Queries.mp4 (41.86 MB)
43 - Order By.mp4 (57.92 MB)
44 - Limiting the Number of Results.mp4 (63.41 MB)
45 - Fetch.mp4 (20.21 MB)
46 - Distinct Values.mp4 (49.29 MB)
47 - Challenge 3 - Select Queries.mp4 (1.71 MB)
48 - Solution 3 - Select Queries.mp4 (28.07 MB)
49 - Null Values.mp4 (34.51 MB)
50 - Setting a Column Name Alias.mp4 (65.11 MB)
51 - Concatenation.mp4 (35.29 MB)
52 - Challenge 4 - Select Queries.mp4 (1.84 MB)
53 - Solution 4 - Select Queries.mp4 (33.79 MB)
54 - Section Summary.mp4 (5.51 MB)
55 - Section Introduction.mp4 (2.63 MB)
56 - Aggregate Functions Explained.mp4 (4.98 MB)
57 - Count Aggregate Functions.mp4 (26.73 MB)
58 - Sum Aggregate Function.mp4 (20.18 MB)
59 - Min and Max Aggregate Functions.mp4 (36.06 MB)
60 - Average Aggregate Functions.mp4 (13.66 MB)
61 - Challenge 1 - Aggregate Functions.mp4 (3.1 MB)
62 - Solution 1 - Aggregate Functions.mp4 (29.73 MB)
63 - Grouping Data.mp4 (93.55 MB)
64 - Having Clauses.mp4 (32.54 MB)
65 - Challenge 2 - Aggregate Functions.mp4 (1.84 MB)
66 - Solution 2 - Aggregate Functions.mp4 (32.41 MB)
67 - Mathematical Operators.mp4 (40.27 MB)
68 - Section Summary.mp4 (2 MB)
69 - Section Introduction.mp4 (2.28 MB)
70 - What Are Database Relationships.mp4 (4.08 MB)
71 - One to One Relationships.mp4 (9.04 MB)
72 - One to Many Relationships.mp4 (10.07 MB)
73 - Many to Many Relationships.mp4 (13.63 MB)
74 - (Optional) Challenge - Database Relationships.mp4 (5.53 MB)
75 - Solution - Database Relationships.mp4 (14.46 MB)
76 - Section Summary.mp4 (1.45 MB)
100 - Section Summary.mp4 (2.12 MB)
77 - Section Introduction.mp4 (3.26 MB)
78 - SQL Joins Explained.mp4 (25.58 MB)
79 - Inner Joins Part 1.mp4 (80.68 MB)
80 - Inner Joins Part 2.mp4 (39.7 MB)
81 - Inner Joins Part 3.mp4 (30.76 MB)
82 - Challenge 1 - Joins.mp4 (2.66 MB)
83 - Solution 1 - Joins.mp4 (39.27 MB)
84 - Left Joins.mp4 (40.49 MB)
85 - Right Joins.mp4 (23.59 MB)
86 - Full Joins.mp4 (24.68 MB)
87 - Challenge 2 - Joins.mp4 (1.42 MB)
88 - Solutions 2 - Joins.mp4 (46.15 MB)
89 - Joining More Than Two Tables.mp4 (97.9 MB)
90 - Challenge 3 - Joins.mp4 (2.19 MB)
91 - Solution 3 - Joins.mp4 (70.4 MB)
92 - Union.mp4 (84.11 MB)
93 - Union All.mp4 (19.11 MB)
94 - Challenge 4 - Joins.mp4 (1.63 MB)
95 - Solution 4 - Joins.mp4 (25.31 MB)
96 - Intersect.mp4 (19.07 MB)
97 - Except.mp4 (20.74 MB)
98 - Challenge 5 - Joins.mp4 (1.54 MB)
99 - Solution 5 - Joins.mp4 (26.88 MB)
101 - Section Introduction.mp4 (2 MB)
102 - Subqueries Explained.mp4 (18.89 MB)
103 - Uncorrelated Subqueries Part 1.mp4 (54.5 MB)
104 - Uncorrelated Subqueries Part 2.mp4 (47.17 MB)
105 - Challenge 1 - Subqueries.mp4 (3.78 MB)
106 - Solution 1 - Subqueries.mp4 (45.6 MB)
107 - Correlated Subqueries.mp4 (48.92 MB)
108 - Challenge 2 - Subqueries.mp4 (2.77 MB)
109 - Solution 2 - Subqueries.mp4 (54.55 MB)
110 - Summary.mp4 (1.88 MB)]
Screenshot