SQL for Newcomers – The Full Mastery Course

Download Now


Files Included :

1 Introduction.mp4 (8.79 MB)
MP4
2 Tools Used in This Course.mp4 (3.92 MB)
MP4
1 Character Functions - UPPER, LOWER & INITCAP.mp4 (27.46 MB)
MP4
2 Character Functions - CONCAT & LENGTH.mp4 (43.23 MB)
MP4
3 Character Functions - LPAD & RPAD.mp4 (62.67 MB)
MP4
4 Character Functions - TRIM.mp4 (11.95 MB)
MP4
5 Character Functions - REPLACE.mp4 (39.24 MB)
MP4
6 Character Functions - SUBSTR.mp4 (21.88 MB)
MP4
7 Number Functions - MOD & ROUND.mp4 (27.39 MB)
MP4
8 Number Functions - TRUNC.mp4 (20.51 MB)
MP4
1 Selectception A Select Query Inside Another Select Query!.mp4 (24.51 MB)
MP4
1 Auto Data Conversion in SQL.mp4 (46.41 MB)
MP4
2 Cast Date to Character.mp4 (36.78 MB)
MP4
3 Cast Number to Character.mp4 (29.15 MB)
MP4
4 Cast Timestamp to Character.mp4 (22.56 MB)
MP4
5 Cast Character to Number.mp4 (23.83 MB)
MP4
6 Cast Character to Date & Timestamp.mp4 (23.99 MB)
MP4
1 UNION.mp4 (18.53 MB)
MP4
2 UNION ALL.mp4 (12.66 MB)
MP4
3 Important Note about Combining Queries.mp4 (11.18 MB)
MP4
4 INTERSECT.mp4 (5.22 MB)
MP4
5 EXCEPT.mp4 (13.09 MB)
MP4
1 Employees & Departments Tables Revised.mp4 (18.86 MB)
MP4
2 Entity Relationship Diagram (ERD).mp4 (22.25 MB)
MP4
3 Cartesian Join.mp4 (44.49 MB)
MP4
4 Table Aliases with Joins.mp4 (35.4 MB)
MP4
5 Why I Don't Recommend Cartesian Joins.mp4 (40.59 MB)
MP4
6 Inner Join.mp4 (34.18 MB)
MP4
7 In-Depth Look into Join Types in SQL.mp4 (11.09 MB)
MP4
8 Outer Join - Right, Left & Full.mp4 (55.68 MB)
MP4
1 INSERT a New Record to a Table.mp4 (34.24 MB)
MP4
10 Insert Records with Nested Select Queries.mp4 (24.68 MB)
MP4
2 Insert Without Specifying Column Names.mp4 (38.06 MB)
MP4
3 UPDATE a Record's Field Values.mp4 (31.45 MB)
MP4
4 CAUTION! How an UPDATE Query Can Go Wrong.mp4 (31.43 MB)
MP4
5 Update a Record Using Single-Row Functions.mp4 (15.41 MB)
MP4
6 A Good Exercise Extract Employee's Email Address.mp4 (7.81 MB)
MP4
8 Solution Extract Employee's Email Address.mp4 (65.5 MB)
MP4
9 DELETE a Table's Record.mp4 (23.41 MB)
MP4
1 SQL Data Types Revised.mp4 (102.89 MB)
MP4
10 NOT NULL Constraint.mp4 (21.71 MB)
MP4
11 UNIQUE Constraint.mp4 (21.69 MB)
MP4
12 DEFAULT Constraint.mp4 (23.01 MB)
MP4
13 Foreign Keys.mp4 (38.32 MB)
MP4
14 Use Foreign Keys with Joins - Books & Publishers.mp4 (29.53 MB)
MP4
15 Foreign Keys - Properties.mp4 (29.11 MB)
MP4
16 Drop Column.mp4 (3.91 MB)
MP4
17 DROP Table.mp4 (4.93 MB)
MP4
18 Create a New Table with Select Statement.mp4 (24.94 MB)
MP4
19 A Trick to Create an Empty Table with Select Statement.mp4 (9.44 MB)
MP4
2 Bookstore Data Set Let's Move It to Database.mp4 (22.34 MB)
MP4
20 Insert New Records Using Select Statement.mp4 (25.18 MB)
MP4
21 Views.mp4 (15.09 MB)
MP4
22 Schemas.mp4 (12.49 MB)
MP4
23 Create & Use Schemas.mp4 (20.19 MB)
MP4
3 Create Your First Table!.mp4 (27.62 MB)
MP4
4 Insert Data to Your New Table.mp4 (36.94 MB)
MP4
5 Change Column Data Type.mp4 (25.31 MB)
MP4
6 Rename Column.mp4 (16.16 MB)
MP4
7 Add a New Column to Table.mp4 (21.89 MB)
MP4
8 Constraints in SQL.mp4 (7.23 MB)
MP4
9 Primary Keys.mp4 (74.73 MB)
MP4
1 Introduction to Access Control.mp4 (3.81 MB)
MP4
2 Create User.mp4 (12.71 MB)
MP4
3 Grant SELECT to User.mp4 (16.27 MB)
MP4
4 Grant Insert & Update to User.mp4 (23.04 MB)
MP4
5 Revoke Privilege from User.mp4 (12.48 MB)
MP4
6 User Groups.mp4 (27.36 MB)
MP4
1 Download PostgreSQL.mp4 (19.8 MB)
MP4
2 Install PostgreSQL.mp4 (26.63 MB)
MP4
3 Download SQLectron.mp4 (10.6 MB)
MP4
4 Install SQLectron.mp4 (5.75 MB)
MP4
5 Connect to PostgreSQL - Credentials.mp4 (6.43 MB)
MP4
6 Connect to PostgreSQL Using SQLectron.mp4 (10.91 MB)
MP4
7 Import Course Data Using SQLectron.mp4 (23.68 MB)
MP4
9 FOR WINDOWS 32-BIT USERS Download, Install, Configure & Import Data.mp4 (87.15 MB)
MP4
1 Check Imported Data.mp4 (34.69 MB)
MP4
10 Another Query Filtering by Date.mp4 (7.54 MB)
MP4
11 Filter Data by Strings (Names, Addresses, ).mp4 (29.15 MB)
MP4
12 More Filtering by Strings.mp4 (29.3 MB)
MP4
13 More Filtering by Strings 2.mp4 (51.8 MB)
MP4
14 More Filtering by Strings 3.mp4 (7.57 MB)
MP4
15 How to Ignore Caps when Filtering by String.mp4 (17.86 MB)
MP4
2 So What is a Database.mp4 (7.47 MB)
MP4
3 SQL Data Types.mp4 (4.44 MB)
MP4
4 Finally Some Fun! Extracting Data Based on Requirements.mp4 (4.6 MB)
MP4
5 Filtering Data using WHERE Keyword.mp4 (64.2 MB)
MP4
6 Filter Data by Range Using BETWEEN.mp4 (17 MB)
MP4
7 Filter Data by Set of Values Using IN.mp4 (19.29 MB)
MP4
8 Filter Data by Date.mp4 (41.14 MB)
MP4
9 More Filtering by Date.mp4 (28.2 MB)
MP4
1 AND Operator.mp4 (58.87 MB)
MP4
2 OR Operator.mp4 (65.09 MB)
MP4
3 NOT Operator.mp4 (41.44 MB)
MP4
4 AND, OR & NOT Operators Which Has The Highest Priority.mp4 (34.1 MB)
MP4
1 Basic Math Operations.mp4 (13.53 MB)
MP4
2 Modulo Operator.mp4 (12.12 MB)
MP4
3 It's Payday! Calculate The Net Salary for Employees.mp4 (28.21 MB)
MP4
4 Filter Data with Math Equations.mp4 (14.2 MB)
MP4
1 Concatenate Strings with '' Operator.mp4 (18.85 MB)
MP4
2 Concatenate Strings with Numbers.mp4 (6.02 MB)
MP4
1 Give Your Report Fields A Cool Name.mp4 (21.24 MB)
MP4
2 A Report for Payroll.mp4 (44.92 MB)
MP4
3 Order Records by Column.mp4 (55.27 MB)
MP4
4 Order Records by Multiple Columns.mp4 (102.22 MB)
MP4
5 How Alias Names Cannot Be Used with WHERE.mp4 (11.17 MB)
MP4
6 LIMIT Record Count Fetched by Your Query.mp4 (56.26 MB)
MP4
1 Fetch A Field's Unique Values Using DISTINCT.mp4 (12.59 MB)
MP4
2 Using DISTINCT Keyword with Multiple Columns.mp4 (32.58 MB)
MP4
3 What is a NULL Value Anyway.mp4 (25.76 MB)
MP4
4 Build More Sophisticated Queries with CASE Statements.mp4 (46.22 MB)
MP4
5 Your Knowledge So Far Under A Great Test.mp4 (63.68 MB)
MP4
1 Let Me Introduce You to Functions.mp4 (10.29 MB)
MP4
10 Filter By Aggregate Functions with HAVING Clause.mp4 (51.36 MB)
MP4
2 SUM Function.mp4 (16.83 MB)
MP4
3 AVG (Average) Function.mp4 (11.43 MB)
MP4
4 COUNT Function.mp4 (22.15 MB)
MP4
5 MIN & MAX Functions.mp4 (10.78 MB)
MP4
6 How To Count Your Field's Unique Values.mp4 (10.83 MB)
MP4
7 GROUP BY Clause Use Functions with Dimensions.mp4 (21.36 MB)
MP4
8 GROUP BY More Than One Dimension.mp4 (28.47 MB)
MP4
9 Now For Some Tough Workout.mp4 (47.99 MB)
MP4