Advanced SQL Database Course – Institute of Software Technologies

Advanced SQL Database Course

Advanced SQL Database Course

Oracle Database Administration: Advanced Fundamentals of SQL training helps you to create materialized views to replicate data across servers, improve performance by using simple SQL syntax, use Analytic SQL to aggregate, analyze, report, and model data using the SQL Analytic capabilities. 

  • Use the data dictionary views to research data on your objects. 
  • Query various data dictionary views. 
  • How to create and maintain database objects. 
  • Managing Schema objects 
  • Manipulating data using subqueries 
  • Anyone who has undergone basic knowledge of SQL Beginner course 
  • SQL Beginner.  
  • Basic SQL skills. 

 COURSE OUTLINE 

 

 Backup and Recovery: Concepts 

  • DBA Responsibilities 
  • Categories of failure 
  • Flashback technology 
  • Phases of Instance Recovery 
  • Complete and Incomplete Recovery 

 

Backup and Recovery: Configuration 

 

  • Configuring for Recoverability 
  • Configuring and Monitoring Fast Recovery Area 
  • Multiplexing Control files and Redo log files 

 

 

 

Performing Database Backups 

 

  • Backup solutions 
  • Oracle Secure Backup 
  • Backup Terminology 
  • Types of Backups 
  • RMAN Backup types 

 

 

Perfoming Database Recovery 

 

  • Opening a Database 
  • Keeping a database open 
  • Data Recovery Advisor 
  • Loss of Control file, Redo Log files, Data files. 

Moving Data 

 

  • Moving Data 
  • Oracle Data pump  
  • Directory Objects for Data Pump 
  • Creating Directory Objects 
  • Performing a Data Pump Import 

 

Database Maintenance 

 

Database Maintenance 

Terminology 

Automatic Workload Repository(AWR) 

AWR Infrastructure 

Managing Performance 

 

  • Performance Monitoring 
  • Performance Planning 
  • Memory Management 
  • Automatic Memory Management(AMM) 
  • Automatic Shared Memory Management(ASMM) 

Managing Performance: SQL Tuning 

 

  • SQL Tuning 
  • Oracle Optimizer 
  • SQL Tuning Advisor 

 

Using Database Resource Manager 

 

  • Database Resource Manager overview and concepts 

 

 

. 

 

Apply Now
Advanced SQL Database Course ​