Oracle Database 11g Certified Associate (OCA) Fundamentals 1Z0-051 and Admin 1z0-052
Oracle 12c OCP 1Z0-062: Installation and Administration
Oracle 12c OCP 1Z0-061: SQL Fundamentals
Oracle Database 11g Certified Associate (OCA) Fundamentals 1Z0-051 and Admin 1z0-052
Oracle Database 11g Certified Associate (OCA) Fundamentals 1Z0-051 and Admin 1z0-052
- Module 1: Database Administration
- Module 2: Oracle Architecture
- Module 3: Database Schema
- Module 4: Recovery Manager
- Module 5: Introduction to SQL
- Module 6: Filtering and Sorting Data
- Module 7: Functions
- Module 8: SET Operators and Subqueries
- Module 9: Regular Expressions and SQL Loader
Course Information:
- Total Course Video Hours: 7 Hrs 24 Min
- Total Videos: 43
Oracle 12c OCP 1Z0-062: Installation and Administration
Oracle 12c OCP 1Z0-062: Installation and Administration
- Module 1: Database Concepts And Tools
- Module 2: Memory Structure
- Module 3: Tables
- Module 4: Indexes
- Module 5: Constraints And Triggers
- Module 6: Users
- Module 7: Internal Structures
- Module 8: Starting Up and Shutting Down Database
- Module 9: Critical Storage Files
- Module 10: Data Manipulation Language
- Module 11: Data Concurrency
- Module 12: BackUp And Recovery
- Module 13: Installation
- Module 14: Course Review
Course Information:
- Total Course Video Hours: 19 Hrs 22 Min
- Total Videos: 51
Oracle 12c OCP 1Z0-061: SQL Fundamentals
Oracle 12c OCP 1Z0-061: SQL Fundamentals
- Module 1: Introduction To Oracle 12c SQL Fundamentals
- Module 2: Retrieving Data
- Module 3: SQL Functions
- Module 4: Subqueries
- Module 5: Data Manipulation Language
- Module 6: Data Control Language
- Module 7: Data Definition Language
- Module 8: Combining Queries
- Module 9: Oracle 12C SQL Fundamentals Review
Course Information:
- Total Course Video Hours: 16 Hrs 21 Min
- Total Videos: 45
- Introduction
- Intro To Oracle 12c-SQL Fundamentals
- Structure Of SQL
- Basic Select Statements
- Basic Select Statements Demo
- Modifying Reported Output
- The Where Clause
- The Order By Clause
- Left And Right Outer Joins
- The Where Clause Demo
- Multi-Table Selection Demo
- Single Row Functions
- Aggregate Functions
- Single Row Functions Demo
- Muiltrow Functions Demo
- Group By
- Grouping Demo
- Conversion Functions
- Conversion Functions Demo
- Datetime Functions
- Datetime Functions Demo
- Single-Row Subqueries
- Single-Row Subqueries Demo
- Multi-Row Subqueries
- Multi-Row Subqueries Demo
- Other Subquery Types
- Other Subquery Types Demo
- Adding Data
- Changing Data
- Deleting Data
- DML Demo
- Security
- Object Privileges
- DCL Demo
- Creating Objects In The Database
- Creating Objects In The Database Demo
- Sequences
- Sequenced Demo
- Indexes
- Views
- Combining Queries
- Oracle 12c SQL Fundamentals Review – Part 1
- Oracle 12c SQL Fundamentals Review – Part 2
- Oracle 12c SQL Fundamentals Review – Part 3
- Conclusion
- Total Course Video Hours: 16 Hrs 21 Min
- Total Videos: 45
- Instructor And Course Introduction
- Database Concepts And Tools – Part 1
- Database Concepts And Tools – Part 2
- Memory Structure – Part 1
- Memory Structure – Part 2
- Tables – Part 1
- Tables – Part 2
- Indexes – Part 1
- Indexes – Part 2
- Constraints And Triggers – Part 1
- Constraints And Triggers – Part 2
- Users
- Profiles
- Privileges
- Roles
- Storage Structures – Part 1
- Storage Structures – Part 2
- Internal Memory Structures – Part 1
- Internal Memory Structures – Part 2
- Background Processes – Part 1
- Background Processes – Part 2
- Starting And Stopping DataBase – Part 1
- Starting And Stopping DataBase – Part 2
- Critical Storage Files – Part 1
- Critical Storage Files – Part 2
- DML Atomicity – Part 1
- DML Atomicity – Part 2
- DML Insert
- DML Update – Part 1
- DML Update – Part 2
- DML Delete And Review Of DML Statements – Part 1
- DML Delete And Review Of DML Statements – Part 2
- Data Concurrency – Part 1
- Data Concurrency – Part 2
- Back Up – Part 1
- Back Up – Part 2
- Back Up – Part 3
- RMAN Catalog
- RMAN BackUps – Part 1
- RMAN BackUps – Part 2
- Disaster Preparedness
- Recovery
- Flashback Recovery
- Installation – Part 1
- Installation – Part 2
- Course Review – Part 1
- Course Review – Part 2
- Course Review – Part 3
- Course Review – Part 4
- Course Review – Part 5
- Course Outro
- Total Course Video Hours: 19 Hrs 22 Min
- Total Videos: 51
- Intro to Oracle
- Database Administration
- Installing Oracle – Part 1
- Installing Oracle – Part 2
- Post Setup Overview – Part 1
- Post Setup Overview – Part 2
- SQLplus – Part 1
- SQLplus – Part 2
- SQLplus Demo – Part 1
- SQLplus Demo – Part 2
- SQLplus Demo – Part 3
- Startup and Shutdown – Part 1
- Startup and Shutdown – Part 2
- Oracle Architecture
- Schema Objects
- Data Access
- Architecture
- Database Schema
- Create Table & Tablespace – Part 1
- Create Table & Tablespace – Part 2
- Create View
- Create Index
- Create Sequence
- Recovery Manager
- What is RMAN
- RMAN Demo
- Restore – Part 1
- Restore – Part 2
- SQL – Part 1
- SQL – Part 2
- Parts of SQL Statement
- Select Statement
- Build ERD – Part 1
- Build ERD – Part 2
- Build ERD – Part 3
- Functions
- More Functions
- Group Functions
- Custom Functions
- SET Operations
- Subqueries
- Regular Expressions
- SQL Loader
- Total Course Video Hours: 7 Hrs 24 Min
- Total Videos: 43