1 Course Agenda.mp4 (19.46 MB)
2 System Development Life Cycle & Database Definition.mp4 (7.76 MB)
3 What is a Table.mp4 (5.85 MB)
4 Data Models & ERM.mp4 (53.55 MB)
5 About Primary key & foreign key.mp4 (17.7 MB)
6 SQL and Types of SQL Statements.mp4 (21.68 MB)
7 Oracle Database 12c Architecture.mp4 (15.28 MB)
8 HR Schema in this Course.mp4 (20.96 MB)
1 Oracle Live SQL No Installation for anything.mp4 (63.98 MB)
4 Downloading Oracle DB 12c.mp4 (29.81 MB)
5 Installing Oracle DB 12c.mp4 (50.54 MB)
1 Connecting SYS using SQL plus & SQL Developer.mp4 (38.81 MB)
3 Unlock HR Account Part 1.mp4 (15.98 MB)
4 Unlock HR Account Part 2.mp4 (47.34 MB)
5 ORA-01033 oracle initialization or shutdown in progress 12c.mp4 (29.1 MB)
1 Navigate HR schema.mp4 (78.61 MB)
2 Capabilities of SQL SELECT Statements.mp4 (41 MB)
3 Arithmetic expressions and NULL values.mp4 (34.61 MB)
4 Column Alias, Concatenation , Distinct and DESCRIBE.mp4 (61.85 MB)
5 Important Notes in Select Statement.mp4 (44.61 MB)
1 The WHERE Clause & Comparison Operators.mp4 (102.51 MB)
2 Using Between and IN Like Operators.mp4 (41.57 MB)
3 Using IS NULL NOT Not equal Operators.mp4 (17.77 MB)
4 Logical Operators (AND OR NOT).mp4 (54.34 MB)
5 Order by Clause.mp4 (55.44 MB)
6 The FETCH Clause.mp4 (65.5 MB)
1 What is a Substitution Variables (&).mp4 (29.14 MB)
2 DEFINE UNDEFINE.mp4 (15.44 MB)
3 ACCEPT PROMPT.mp4 (18.25 MB)
4 Double-Ampersand SET VERIFY SET DEFINE.mp4 (17.71 MB)
1 Single Row Function Introduction.mp4 (32.38 MB)
2 Character functions (Upper, Lower, Initcap ).mp4 (17.08 MB)
3 Character functions (concat, substr, length ).mp4 (43.37 MB)
4 Character functions ( instr ).mp4 (13.04 MB)
5 Character functions ( lpad, rpad , replace, trim).mp4 (25.36 MB)
6 Number functions ( Round, Trunc, MOD ).mp4 (35.45 MB)
7 Date Functions ( Sysdate).mp4 (53.7 MB)
8 Date Functions ( months between, add months, next day, last day).mp4 (33.16 MB)
9 Date Functions ( round , trunc ).mp4 (29.63 MB)
10 Nesting Functions.mp4 (19.38 MB)
1 Implicit Data Conversion VS Explicit.mp4 (22.84 MB)
2 TO CHAR with dates.mp4 (57.97 MB)
3 TO CHAR with numbers.mp4 (64.79 MB)
4 TO NUMBER , TO DATE Functions.mp4 (40.39 MB)
5 nvl , nvl2 , nullif and coalesce Functions.mp4 (39.39 MB)
6 The CASE Function.mp4 (45.95 MB)
7 The DECODE Function.mp4 (26.42 MB)
1 Group functions Introduction.mp4 (15.6 MB)
2 Group functions (sum, count, max, min, avg & more).mp4 (20.64 MB)
3 Group by Clause, Having Clause.mp4 (27.56 MB)
1 Before You Start, important notes.mp4 (22.78 MB)
2 HR Tables Diagram, Joins Clarification.mp4 (26.09 MB)
3 What is Cartesian product.mp4 (33.47 MB)
4 Old Joins Equijoin.mp4 (25.28 MB)
5 Old Joins nonEquijoins.mp4 (29.49 MB)
6 Old Joins outer join.mp4 (20.86 MB)
7 Old Joins Self Join and More Practices.mp4 (49.53 MB)
8 1999 Syntax Cross Join (Cartesian product ).mp4 (16.92 MB)
9 1999 Syntax Natural Join.mp4 (54.75 MB)
10 1999 Syntax USING Clause.mp4 (22.91 MB)
11 1999 Syntax ON Clause.mp4 (53.82 MB)
12 1999 Syntax LeftRightfull Outer Join.mp4 (21.65 MB)
1 Single row Subqueries.mp4 (21.26 MB)
2 Multiple rows Subqueries.mp4 (27.42 MB)
3 NULL values and Subqueries.mp4 (31.03 MB)
4 Exists and not Exists.mp4 (17.86 MB)
1 Overview (Union, union all, intersect, minus ).mp4 (15.7 MB)
2 Practice (Union, union all, intersect, minus ).mp4 (53.77 MB)
1 Introduction to DML.mp4 (17.14 MB)
2 Insert Statement.mp4 (74.54 MB)
3 Inserting common errors.mp4 (16.93 MB)
4 Update Statement.mp4 (72.47 MB)
5 Delete Statement.mp4 (36.99 MB)
6 What is Database Transactions.mp4 (21.19 MB)
7 About Commit & Rollback.mp4 (42.03 MB)
8 Practice ( Commit and rollback ).mp4 (35.36 MB)
9 SAVEPOINT.mp4 (21.05 MB)
10 ROW Lock.mp4 (10.56 MB)
11 FOR UPDATE Clause.mp4 (35.25 MB)
1 DDL & Naming Rules.mp4 (25.79 MB)
2 Data Types Part 1.mp4 (37.37 MB)
3 Data Types Part 2.mp4 (34.85 MB)
4 Creating Tables (without constraints).mp4 (45.33 MB)
5 Types of constraints and why we use it.mp4 (24.77 MB)
6 Creating Tables ( Column Level Constraints ).mp4 (72.39 MB)
7 Creating Tables ( Table Level Constraints ).mp4 (23.48 MB)
8 Constraints Guidelines.mp4 (36.58 MB)
9 ON DELETE cascade ON DELETE set null.mp4 (18.48 MB)
10 Create Table AS subquery.mp4 (26.81 MB)
11 Alter Table Add Columns.mp4 (47.63 MB)
12 Alter Table Modify Columns.mp4 (27.46 MB)
13 Alter Table Drop Columns.mp4 (38.22 MB)
14 Alter Table Set Unused.mp4 (16.98 MB)
15 ALTER TABLE READ ONLY READ write.mp4 (30.7 MB)
16 Drop Table.mp4 (20.64 MB)
17 Rename Column Rename Table.mp4 (8.49 MB)
1 Tips you Should know Part 1.mp4 (21.71 MB)
2 Tips you Should know Part 2.mp4 (5.82 MB)
3 Tips you Should know Part 3.mp4 (18.69 MB)
4 Tips you Should know Part 4.mp4 (16.8 MB)
5 Tips you Should know Part 5.mp4 (16.47 MB)
6 Tips you Should know Part 6.mp4 (22.25 MB)
1 About Exam 1Z0-061 Visiting Oracle Website.mp4 (25.2 MB)
2 My recommendations.mp4 (10.54 MB)
1 What is Data Dictionary Views.mp4 (27.35 MB)
2 What is DICTIONARY.mp4 (12.61 MB)
3 USER OBJECTS ALL OBJECTS.mp4 (26.99 MB)
4 USER TABLES ALL TABLES USER TAB COLUMNS.mp4 (51.68 MB)
5 USER CONSTRAINTS & USER CONS COLUMNS Part 1.mp4 (21.38 MB)
6 USER CONSTRAINTS & USER CONS COLUMNS Part 2.mp4 (66.04 MB)
7 COMMENT ON TABLE COLUMN.mp4 (11.41 MB)
1 Sequences Part 1.mp4 (47.86 MB)
2 Sequences Part 2.mp4 (17.35 MB)
3 Sequences Part 3.mp4 (19.53 MB)
4 Sequences Part 4.mp4 (95.61 MB)
5 Creating Synonyms.mp4 (32.58 MB)
6 Creating Indexes Part 1.mp4 (106.89 MB)
7 Creating Indexes Part 2.mp4 (60.1 MB)
1 What is a View What is the benefits of Views.mp4 (31.25 MB)
2 Creating Simple Views.mp4 (48.72 MB)
3 Creating Complex Views.mp4 (29.07 MB)
4 With READ ONLY With check option Force view.mp4 (28.19 MB)
1 Adding constraints dropping constraints.mp4 (79.04 MB)
2 Rename Column Rename Constraint.mp4 (10.78 MB)
3 Enable Disable Constraints.mp4 (29.38 MB)
4 Understanding DEFERRABLE Constraints.mp4 (49.58 MB)
5 DEFERRABLE Constraints Exercises.mp4 (25.57 MB)
6 GLOBAL TEMPORARY TABLE.mp4 (18.48 MB)
7 About SQLLoader.mp4 (75.61 MB)
8 External Tables Part 1.mp4 (62.24 MB)
9 External Tables Part 2.mp4 (20.69 MB)
1 Using the subquery as a source table.mp4 (31.22 MB)
2 Pairwise Non Pairwise Subqueries.mp4 (43.14 MB)
3 Scalar Subquery Correlated Subquery.mp4 (38.43 MB)
4 Reminder of Exists Not Exists.mp4 (19.89 MB)
5 WITH Clause.mp4 (32.95 MB)
1 Inserting Updating Deleting Using a subquery as a target.mp4 (18.31 MB)
2 Correlated Update Correlated Delete.mp4 (56.72 MB)
1 Database Security System Privileges & Roles.mp4 (60.3 MB)
2 Database Security Object Privileges.mp4 (31.71 MB)
3 System Privileges & Privileges Practice 1.mp4 (27.58 MB)
4 System Privileges & Privileges Practice 2.mp4 (42.05 MB)
5 Creating ROLE Practice.mp4 (46.03 MB)
6 With Grant Option.mp4 (19.11 MB)
7 Drop user Statement.mp4 (8.49 MB)
1 What is Data Warehouse.mp4 (11.67 MB)
2 Explicit default value in insert & update statement.mp4 (15.3 MB)
3 Copy rows from another table.mp4 (9.31 MB)
4 INSERT ALL statement INSERT FIRST.mp4 (57.51 MB)
5 Another INSERT ALL Example & Notes.mp4 (37.19 MB)
6 Creating Matrix Report Using PIVOT.mp4 (29.74 MB)
7 The Merge Statement.mp4 (14.22 MB)
8 FLASHBACK Table & System change Number ( SCN).mp4 (65.47 MB)
1 THE INTERVAL ( YEAR TO MONTH day TO second).mp4 (20.67 MB)
2 to yminterval to dsinterval.mp4 (12.8 MB)
3 Extract function.mp4 (6.14 MB)
4 timestamp timestamp with time zone.mp4 (25.42 MB)
5 V$TIMEZONE NAMES and some functions.mp4 (50.09 MB)
6 timestamp with local time zone.mp4 (13.64 MB)
7 TZ OFFSET FROM TZ TO TIMESTAMP.mp4 (20.26 MB)
1 About the Exam 1Z0-071.mp4 (25.55 MB)
1 Using SELECT statement to create dynamic scripts.mp4 (18.73 MB)
2 Installing oracle 11g express edition.mp4 (40.15 MB)
3 Rownum and rowid.mp4 (21.67 MB)
4 About PLSQL.mp4 (91.36 MB)
7 DML logs using package dbms errlog.mp4 (35.09 MB)
8 oracle 18c express edition part 1 (download and install ).mp4 (42.35 MB)
9 oracle 18c express edition part 2 (unlock hr ).mp4 (31.85 MB)
10 oracle 18c express edition part 3 ( sql developer ).mp4 (20.4 MB)
Oracle Database SQL Certified Associate 1Z0-071
Citar
