1Z0-051 Database 11g SQL Fundamentals
ORACLE-1Z0-062 Oracle Database 12c - Installation and Administration
1Z0-051 Database 11g SQL Fundamentals
1Z0-051 Database 11g SQL Fundamentals
- Retrieving Data Using the SQL SELECT Statement
- Using Single-Row Functions to Customize Output
- Displaying Data from Multiple Tables
- Using the Set Operators
- Restricting and Sorting Data
- Reporting Aggregated Data Using the Group Functions
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
- Manipulating Data
- Using Conversion Functions and Conditional Expressions
- Using Subqueries to Solve Queries
ORACLE-1Z0-062 Oracle Database 12c - Installation and Administration
ORACLE-1Z0-062 Oracle Database 12c – Installation and Administration
- Oracle Database Instances
- Configuring an Oracle Network Environment
- Managing Database Storage Structures
- Administering User Security
- Managing Space
- Managing Data Concurrency and Undo
- Implementing Oracle Database Auditing
- Using Backup and Recovery Concepts
- Performing Database Recovery
- Moving Data
- Managing Database Performance
- Managing Resource Using
- Database Resource Manager
- Automating Tasks Using Oracle Scheduler
- Installing Oracle Grid Infrastructure and Using Oracle Restart
- Installing Oracle 12c
- Creating an Oracle Database Using DBCA
- Upgrading to Oracle 12c
- Migrating Data Using Oracle Data Pump
- 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
- 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