Oracle DBA SQL & PL/SQL

• Writing a basic SQL Statement 

• Restricting and sorting data 

• Single row Functions 

• Displaying data from multiple tables 

• Producing readlable output with SQL + 

• Manipulating data 

• Creating and managing table 

• Including constraints 

• Creating views 

• Advanced subqueries 

• Hierarchical retrieval 

• Writing Scripts to Generate Scripts

Oracle DBA Fundamentals 1

• Defining the Optimal Flexible Architecture

• Creating a database during installation 

• Identifying database administrative users 

• Managing an Oracle Instance 

• Describing storage hierarchy 

• Storage Structures and Relationships 

• Managing Tables 

• Maintaining Data Integrity 

• Managing Password Security Resources

Oracle DBA Fundamentals 2

• Basic Oracle Net Services

• Back up and recovery Overview

• Media Recovery Structures 

• Database archiving Structures 

• Oracle Recovery Manager (RMAN) 

• User-Managed Back up 

• RAMAN Backups 

• User-Managed Incomplete Recovery 

• RAMAN incomplete Recovery 

• RAMAN Repository Maintenance 

• RAMN Catalog Creation and usage 

• Transporting data between Databases 

• Backup and recovery and Networking