Oracle SQL Become a Certified SQL Developer From Scratch!

Start Download


Files Included :

1 What is a Database.mp4 (80.33 MB)
MP4
2 Why Oracle Database.mp4 (61.76 MB)
MP4
3 What is a Table.mp4 (43.86 MB)
MP4
4 UDEMY 101 How to Use Udemy +Some Useful Tips.mp4 (50.62 MB)
MP4
6 What is a Relational Database.mp4 (89.59 MB)
MP4
7 Entity Relationship Logic in Databases.mp4 (37.09 MB)
MP4
8 The Sample (HR) Schema Used in This Course.mp4 (76.08 MB)
MP4
9 What is SQL.mp4 (45.32 MB)
MP4
1 GROUP BY Clause.mp4 (34.53 MB)
MP4
2 HAVING Clause.mp4 (15.3 MB)
MP4
3 Nesting Group Functions.mp4 (7.45 MB)
MP4
1 Joining Multiple Tables & Types of Joins.mp4 (7.07 MB)
MP4
10 OUTER JOINS.mp4 (9.26 MB)
MP4
11 LEFT OUTER JOIN.mp4 (9.88 MB)
MP4
12 RIGHT OUTER JOIN.mp4 (17.4 MB)
MP4
13 FULL OUTER JOIN.mp4 (5.99 MB)
MP4
14 CROSS JOIN (Cartesian Product).mp4 (13.32 MB)
MP4
2 Natural Joins.mp4 (19.1 MB)
MP4
3 Join with USING Clause.mp4 (12.29 MB)
MP4
4 Handling Ambiguous Column Names.mp4 (14.14 MB)
MP4
5 Join with ON Clause.mp4 (11.26 MB)
MP4
6 Multiple Join Operations.mp4 (12.16 MB)
MP4
7 Restricting Joins.mp4 (5.27 MB)
MP4
8 Joining Unequal Tables.mp4 (7.17 MB)
MP4
9 SELF JOIN.mp4 (10.53 MB)
MP4
1 Using Subqueries.mp4 (13.3 MB)
MP4
2 Single Row Subqueries.mp4 (20.53 MB)
MP4
3 Multiple Row Subqueries.mp4 (22.55 MB)
MP4
4 Multiple Column Subqueries.mp4 (15.03 MB)
MP4
1 SET Operators.mp4 (24.33 MB)
MP4
2 UNION and UNION ALL Operators.mp4 (21.78 MB)
MP4
3 INTERSECT Operator.mp4 (4 MB)
MP4
4 MINUS Operator.mp4 (4.98 MB)
MP4
5 Matching Unmatched Queries in SET Operations.mp4 (5.63 MB)
MP4
6 Order By with SET Operators.mp4 (11.18 MB)
MP4
1 Data Manipulation Language (DML).mp4 (5.36 MB)
MP4
2 INSERT Statement (Part 1).mp4 (16.96 MB)
MP4
3 INSERT Statement (Part 2).mp4 (23.94 MB)
MP4
4 UPDATE Statement.mp4 (19.38 MB)
MP4
5 DELETE Statement.mp4 (11.68 MB)
MP4
6 Transaction Control Statements.mp4 (8.37 MB)
MP4
7 COMMIT and ROLLBACK Statements.mp4 (17 MB)
MP4
8 SAVEPOINT Statement.mp4 (20.99 MB)
MP4
9 FOR UPDATE Statement.mp4 (17.18 MB)
MP4
1 Data Definition Language (DDL).mp4 (5.08 MB)
MP4
2 Naming Rules.mp4 (5.56 MB)
MP4
3 CREATE TABLE Statement.mp4 (33.71 MB)
MP4
4 ALTER TABLE Statement.mp4 (36.93 MB)
MP4
5 DROP TABLE Statement.mp4 (7.96 MB)
MP4
6 TRUNCATE TABLE Statement.mp4 (9.25 MB)
MP4
7 COMMENT Statement.mp4 (14.2 MB)
MP4
8 RENAME Statement.mp4 (11.26 MB)
MP4
1 Creating Constraints.mp4 (9.11 MB)
MP4
2 NOT NULL Constraint.mp4 (11.31 MB)
MP4
3 UNIQUE Constraint.mp4 (20.18 MB)
MP4
4 PRIMARY KEY Constraint.mp4 (13.45 MB)
MP4
5 FOREIGN KEY Constraint.mp4 (31.55 MB)
MP4
6 CHECK Constraint.mp4 (8.43 MB)
MP4
1 Conclusion.mp4 (1006.93 KB)
MP4
1 About the Installation.mp4 (50.14 MB)
MP4
2 Which Option to Have a Database.mp4 (86.47 MB)
MP4
3 Option 1 Having The Database with Oracle VirtualBox.mp4 (37.21 MB)
MP4
5 Option 2 Downloading And Installing Oracle Database.mp4 (18.84 MB)
MP4
6 Option 3 Using Oracle Live SQL.mp4 (42.79 MB)
MP4
7 Configuring and Using SQL Developer.mp4 (26.92 MB)
MP4
9 SQL Statement used in this course.mp4 (2.63 MB)
MP4
1 Oracle Data Types.mp4 (6.76 MB)
MP4
2 DESCRIBE Command.mp4 (6.25 MB)
MP4
3 SQL Statement Basics.mp4 (21.01 MB)
MP4
4 Using SELECT Statement.mp4 (8.9 MB)
MP4
5 Using Column Aliases.mp4 (14.39 MB)
MP4
6 Quote (Q) Operator.mp4 (11.96 MB)
MP4
7 DISTINCT Operator.mp4 (10.34 MB)
MP4
8 Concatenation Operators.mp4 (14.32 MB)
MP4
9 Arithmetic Expressions and NULL Values.mp4 (18.82 MB)
MP4
1 Using WHERE Clause.mp4 (5.83 MB)
MP4
2 Comparison Operators.mp4 (12.87 MB)
MP4
3 BETWEEN . AND Operator.mp4 (10.1 MB)
MP4
4 IN Operator.mp4 (12.02 MB)
MP4
5 LIKE Operator.mp4 (15.68 MB)
MP4
6 IS NULL Operator.mp4 (5.2 MB)
MP4
7 Logical Operators (AND, OR, NOT).mp4 (23.92 MB)
MP4
8 Rules of Precedence.mp4 (10.32 MB)
MP4
1 ORDER BY Clause.mp4 (9.78 MB)
MP4
2 ASC and DESC Operators.mp4 (17.2 MB)
MP4
3 NULLS FIRST and NULLS LAST Operators.mp4 (11.29 MB)
MP4
1 Single Row Functions.mp4 (15.33 MB)
MP4
2 Character Functions (Part 1).mp4 (21.78 MB)
MP4
3 Character Functions (Part 2).mp4 (28.98 MB)
MP4
4 Number Functions.mp4 (15.73 MB)
MP4
5 Nesting Functions.mp4 (13.57 MB)
MP4
6 Date Functions.mp4 (14.38 MB)
MP4
7 Date Operations.mp4 (36.8 MB)
MP4
1 Conversion Functions.mp4 (13.47 MB)
MP4
2 TO CHAR, TO DATE, TO NUMBER Functions (Part 1).mp4 (18.09 MB)
MP4
3 TO CHAR, TO DATE, TO NUMBER Functions (Part 2).mp4 (23.5 MB)
MP4
4 NVL, NVL2, NULLIF, COALESCE Functions.mp4 (24.42 MB)
MP4
1 Conditional Expressions (CASE-DECODE).mp4 (36.22 MB)
MP4
1 Group Functions.mp4 (7.78 MB)
MP4
2 AVG Function.mp4 (8.39 MB)
MP4
3 COUNT Function.mp4 (8.83 MB)
MP4
4 MAX Function.mp4 (7.42 MB)
MP4
5 MIN Function.mp4 (9.33 MB)
MP4
6 SUM Function.mp4 (5.84 MB)
MP4
7 Overview Of Group Functions.mp4 (5.17 MB)
MP4