Enrolment options
Udemy - Oracle Database SQL Certified Associate 1Z0-071 2024-5
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
27
•
Activities:
1
•
Resources:
169
- Announcements
- 1 Course Agenda
- 2 System Development Life Cycle Database Definition
- 3 What is a Table
- 4 Data Models ERM
- 5 About Primary key foreign key
- 6 SQL and Types of SQL Statements
- 7 Oracle Database 12c Architecture
- 8 HR Schema in this Course
- 1 Oracle Live SQL No Installation for anything
- 4 Downloading Oracle DB 12c
- 5 Installing Oracle DB 12c
- 1 Connecting SYS using SQL plus SQL Developer
- 3 Unlock HR Account Part 1
- 4 Unlock HR Account Part 2
- 5 ORA 01033 oracle initialization or shutdown in progress 12c
- 1 Navigate HR schema
- 2 Capabilities of SQL SELECT Statements
- 3 Arithmetic expressions and NULL values
- 4 Column Alias Concatenation Distinct and DESCRIBE
- 5 Important Notes in Select Statement
- 1 The WHERE Clause Comparison Operators
- 2 Using Between and IN Like Operators
- 3 Using IS NULL NOT Not equal Operators
- 4 Logical Operators AND OR NOT
- 5 Order by Clause
- 6 The FETCH Clause
- 1 What is a Substitution Variables
- 2 DEFINE UNDEFINE
- 3 ACCEPT PROMPT
- 4 Double Ampersand SET VERIFY SET DEFINE
- 1 Single Row Function Introduction
- 2 Character functions Upper Lower Initcap
- 3 Character functions concat substr length
- 4 Character functions instr
- 5 Character functions lpad rpad replace trim
- 6 Number functions Round Trunc MOD
- 7 Date Functions Sysdate
- 8 Date Functions months_between add_months next_day last_day
- 9 Date Functions round trunc
- 10 Nesting Functions
- 1 Implicit Data Conversion VS Explicit
- 2 TO_CHAR with dates
- 3 TO_CHAR with numbers
- 4 TO_NUMBER TO_DATE Functions
- 5 nvl nvl2 nullif and coalesce Functions
- 6 The CASE Function
- 7 The DECODE Function
- 1 Group functions Introduction
- 2 Group functions sum count max min avg more
- 3 Group by Clause Having Clause
- 1 Before You Start important notes
- 2 HR Tables Diagram Joins Clarification
- 3 What is Cartesian product
- 4 Old Joins Equijoin
- 5 Old Joins nonEquijoins
- 6 Old Joins outer join
- 7 Old Joins Self Join and More Practices
- 8 1999 Syntax Cross Join Cartesian product
- 9 1999 Syntax Natural Join
- 10 1999 Syntax USING Clause
- 11 1999 Syntax ON Clause
- 12 1999 Syntax LeftRightfull Outer Join
- 1 Single row Subqueries
- 2 Multiple rows Subqueries
- 3 NULL values and Subqueries
- 4 Exists and not Exists
- 1 Overview Union union all intersect minus
- 2 Practice Union union all intersect minus
- 1 Introduction to DML
- 2 Insert Statement
- 3 Inserting common errors
- 4 Update Statement
- 5 Delete Statement
- 6 What is Database Transactions
- 7 About Commit Rollback
- 8 Practice Commit and rollback
- 9 SAVEPOINT
- 10 ROW Lock
- 11 FOR UPDATE Clause
- 1 DDL Naming Rules
- 2 Data Types Part 1
- 3 Data Types Part 2
- 4 Creating Tables without constraints
- 5 Types of constraints and why we use it
- 6 Creating Tables Column Level Constraints
- 7 Creating Tables Table Level Constraints
- 8 Constraints Guidelines
- 9 ON DELETE cascade ON DELETE set null
- 10 Create Table AS subquery
- 11 Alter Table Add Columns
- 12 Alter Table Modify Columns
- 13 Alter Table Drop Columns
- 14 Alter Table Set Unused
- 15 ALTER TABLE READ ONLY READ write
- 16 Drop Table
- 17 Rename Column Rename Table
- 1 Tips you Should know Part 1
- 2 Tips you Should know Part 2
- 3 Tips you Should know Part 3
- 4 Tips you Should know Part 4
- 5 Tips you Should know Part 5
- 6 Tips you Should know Part 6
- 1 About Exam 1Z0 061 Visiting Oracle Website
- 2 My recommendations
- 1 What is Data Dictionary Views
- 2 What is DICTIONARY
- 3 USER_OBJECTS ALL_OBJECTS
- 4 USER_TABLES ALL_TABLES USER_TAB_COLUMNS
- 5 USER_CONSTRAINTS USER_CONS_COLUMNS Part 1
- 6 USER_CONSTRAINTS USER_CONS_COLUMNS Part 2
- 7 COMMENT ON TABLE COLUMN
- 1 Sequences Part 1
- 2 Sequences Part 2
- 3 Sequences Part 3
- 4 Sequences Part 4
- 5 Creating Synonyms
- 6 Creating Indexes Part 1
- 7 Creating Indexes Part 2
- 1 What is a View What is the benefits of Views
- 2 Creating Simple Views
- 3 Creating Complex Views
- 4 With READ ONLY With check option Force view
- 1 Adding constraints dropping constraints
- 2 Rename Column Rename Constraint
- 3 Enable Disable Constraints
- 4 Understanding DEFERRABLE Constraints
- 5 DEFERRABLE Constraints Exercises
- 6 GLOBAL TEMPORARY TABLE
- 7 About SQLLoader
- 8 External Tables Part 1
- 9 External Tables Part 2
- 1 Using the subquery as a source table
- 2 Pairwise Non Pairwise Subqueries
- 3 Scalar Subquery Correlated Subquery
- 4 Reminder of Exists Not Exists
- 5 WITH Clause
- 1 Inserting Updating Deleting Using a subquery as a target
- 2 Correlated Update Correlated Delete
- 1 Database Security System Privileges Roles
- 2 Database Security Object Privileges
- 3 System Privileges Privileges Practice 1
- 4 System Privileges Privileges Practice 2
- 5 Creating ROLE Practice
- 6 With Grant Option
- 7 Drop user Statement
- 1 What is Data Warehouse
- 2 Explicit default value in insert update statement
- 3 Copy rows from another table
- 4 INSERT ALL statement INSERT FIRST
- 5 Another INSERT ALL Example Notes
- 6 Creating Matrix Report Using PIVOT
- 7 The Merge Statement
- 8 FLASHBACK Table System change Number SCN
- 1 THE INTERVAL YEAR TO MONTH day TO second
- 2 to_yminterval to_dsinterval
- 3 Extract function
- 4 timestamp timestamp with time zone
- 5 VTIMEZONE_NAMES and some functions
- 6 timestamp with local time zone
- 7 TZ_OFFSET FROM_TZ TO_TIMESTAMP
- 1 About the Exam 1Z0 071
- 1 Using SELECT statement to create dynamic scripts
- 2 Installing oracle 11g express edition
- 3 Rownum and rowid
- 4 About PLSQL
- 7 DML logs using package dbms_errlog
- 8 oracle 18c express edition part 1 download and install
- 9 oracle 18c express edition part 2 unlock hr
- 10 oracle 18c express edition part 3 sql developer