Enterprise database Systems

NOTE: Click on the Curriculum links below to go to the corresponding Courses.

Oracle 11g Oracle 10g Oracle Database Systems Systems and Database Design
Microsoft SQL Server 2008 Microsoft SQL Server 2005 Microsoft SQL Server 2000


Curriculum Course Bundle Course Title Course Description Estimated Duration
(in hours)
Oracle 11g   ↑Top
  Oracle Database 11g: New Features For Administrators  
  Oracle Database 11g: Installation and Upgrade Enhancements 255352_ENG 2.50
  Oracle Database 11g: Storage Enhancements 255364_ENG 1.50
  Oracle Database 11g: Change Management Overview and SQL Plan Management 255373_ENG 2.50
  Oracle Database 11g: Database Replay and Automatic SQL Tuning 255385_ENG 2.50
  Oracle Database 11g: Intelligent Infrastructure Enhancements 255397_ENG 2.00
  Oracle Database 11g: Performance Enhancements 255408_ENG 1.50
  Oracle Database 11g: Partitioning and Storage-Related Enhancements 255415_ENG 2.00
  Oracle Database 11g: Using RMAN Enhancements, Flashback and LogMiner 255423_ENG 2.00
  Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor 255433_ENG 2.00
  Oracle Database 11g: New Security Features 255444_ENG 1.50
  Oracle Database 11g: SecureFiles and Miscellaneous New Features 255451_ENG 2.50
  Oracle Database 11g: Administration Workshop I  
  Oracle Database 11g: Database Architecture and Installation 255701_ENG 2.00
  Oracle Database 11g: Database Creation, Instance Management, and Connectivity 255770_ENG 2.50
  Oracle Database 11g: Storage Structures and User Security 255814_ENG 2.50
  Oracle Database 11g: Managing the Schema, Data, and Concurrency 255825_ENG 2.00
  Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance 255834_ENG 2.50
  Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup 255845_ENG 2.00
  Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database 255854_ENG 2.25
  Oracle Database 11g: Administration Workshop II  
  Oracle Database 11g: Database Architecture and ASM 256882_ENG 1.75
  Oracle Database 11g: Configuring for Recovery 256975_ENG 1.75
  Oracle Database 11g: Configuring for Backups 257033_ENG 2.75
  Oracle Database 11g: Using RMAN for Recovery 257046_ENG 1.75
  Oracle Database 11g: Supporting RMAN and Using Flashback Technology 257060_ENG 2.25
  Oracle Database 11g: Diagnosing the Database and Managing Memory 257071_ENG 2.25
  Oracle Database 11g: Database Performance and Space Management 257081_ENG 2.50
  Oracle Database 11g: Managing Resources and Task Automation 257108_ENG 2.00
  Oracle Database 11g: Globalization 257117_ENG 1.25
  Oracle Database 11g: SQL and PL/SQL New Features  
  Oracle Database 11g: Getting Started with SQL and PL/SQL New Features 257179_ENG 1.75
  Oracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements 257188_ENG 1.25
  Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements 257195_ENG 1.25
  Oracle Database 11g: Using the PL/SQL Debugger, Collections and Data Warehousing 257202_ENG 1.25
  Oracle Database 11g: SQL Fundamentals I  
  Oracle Database 11g: Using SQL to Query Your Database 257492_ENG 2.25
  Oracle Database 11g: Conversion Functions, Group Functions, and Joins 257503_ENG 2.00
  Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation 257513_ENG 2.00
  Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms 257522_ENG 1.75
  Oracle Database 11g: SQL Fundamentals II  
  Oracle Database 11g: Controlling User Access and Managing Schema Objects 257867_ENG 1.75
  Oracle Database 11g: Data Dictionary Views and Large Data Sets 257876_ENG 1.50
  Oracle Database 11g: Managing Data in Different Time Zones 257884_ENG 1.50
  Oracle Database 11g: Using Subqueries and Regular Expressions 257896_ENG 1.75
  Oracle Database 11g: PL/SQL Fundamentals  
  Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements 257801_ENG 2.00
  Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops 257810_ENG 1.50
  Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL 257817_ENG 1.50
  Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors 257825_ENG 2.00
  Oracle Database 11g: Develop PL/SQL Program Units  
  Oracle Database 11g: Subprograms, Packages, and Exception Handling in PL/SQL 259958_ENG 2.25
  Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations in PL/SQL 259959_ENG 2.50
  Oracle Database 11g: Using Triggers, the PL/SQL Compiler, and Managing Code 259960_ENG 2.00
  Oracle Database 11g: Managing PL/SQL Code and Dependencies 259961_ENG 1.25
  Oracle Database 11g: Introduction to SQL  
  Oracle Database 11g: Querying a Database with SQL 260277_ENG 2.25
  Oracle Database 11g: Conversion Functions, Conditional Expressions, Group Functions, and Joins 260278_ENG 2.00
  Oracle Database 11g: Manipulating Queries and Data 260279_ENG 2.00
  Oracle Database 11g: Using DDL, Views, and Schema Objects 260280_ENG 1.75
  Oracle Database 11g: Controlling User Access and Managing Objects 260281_ENG 1.75
  Oracle Database 11g: Managing Data Dictionary Views and Large Data Sets 260282_ENG 1.75
  Oracle Database 11g: Managing Time Zones and Datetime Functions 260283_ENG 1.25
  Oracle Database 11g: Subqueries and Regular Expressions 260284_ENG
  Oracle Database 11g: Program with PL/SQL  
  Oracle Database 11g: Getting Started With PL/SQL 260269_ENG 2.00
  Oracle Database 11g: Using DML, DDL, Cursors, Loops, and Control Structures 260270_ENG 1.25
  Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors 260271_ENG 1.75
  Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper, and REF Cursors 260272_ENG 2.00
  Oracle Database 11g: Subprograms, Packages, and Exception Handling 260273_ENG 2.25
  Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations 260274_ENG 2.25
  Oracle Database 11g: Using Triggers and the PL/SQL Compiler 260275_ENG 2.00
  Oracle Database 11g: PL/SQL Code and Dependency Management 260276_ENG 1.25
  Oracle Database 11g: Performance Tuning  
  Oracle Database 11g: Performance Tuning Methodology and Tools od_odpt_a01_it_enus 1.50
  Oracle Database 11g: Using AWR and Defining Problems od_odpt_a02_it_enus 1.50
  Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools, and Services od_odpt_a03_it_enus 2.50
  Oracle Database 11g: Problem SQL Statements and Oracle Optimizer od_odpt_a04_it_enus 2.50
  Oracle Database 11g: SQL Performance Management and Database Replay od_odpt_a05_it_enus 2.00
  Oracle Database 11g: Shared Pool and Buffer Cache Tuning od_odpt_a06_it_enus 2.00
  Oracle Database 11g: Tuning PGA, Temporary Space, and AMM od_odpt_a07_it_enus 1.50
  Oracle Database 11g: Segment Space, I/O, and Performance Tuning od_odpt_a08_it_enus 2.50
  Oracle Database 11g: SQL Tuning  
  Oracle Database 11g: Architecture, SQL Tuning, and Optimization od_ortw_a01_dt_enus 2.00
  Oracle Database 11g: Indexes, Access Paths, and Join Operations od_ortw_a02_dt_enus 2.50
  Oracle Database 11g: Execution Plans and Star Transformations od_ortw_a03_dt_enus 2.00
  Oracle Database 11g: Optimizer Statistics, Hints, and Cursor Sharing od_ortw_a04_dt_enus 3.00
  Oracle Database 11g: Application Tracing and Automatic SQL Tuning od_ortw_a05_dt_enus 2.50
  Oracle Database 11g: Secure Backup  
  Oracle Database 11g: Configuring OSB and Security od_odsb_a01_it_enus 1.00
  Oracle Database 11g: Securing Domain and Data in Oracle Secure Backup od_odsb_a02_it_enus 1.00
  Oracle Database 11g: RMAN and Oracle Secure Backup od_odsb_a03_it_enus 2.00
  Oracle Database 11g: Managing Backups and Infrastructure od_odsb_a04_it_enus 1.00
  Oracle Database 11g: Tape Vaulting, Duplication, and Tuning od_odsb_a05_it_enus 1.50
  Oracle Database 11g: RAC Administration  
  Oracle Database 11g: Installation of Clusterware and RAC od_orac_a01_it_enus 3.00
  Oracle Database 11g: RAC Database and Oracle Clusterware Administration od_orac_a02_it_enus 3.00
  Oracle Database 11g: RAC Performance Tuning od_orac_a03_it_enus 1.50
  Oracle Database 11g: Configure, Manage, and Use Services in RAC od_orac_a04_it_enus 1.50
  Oracle Database 11g: Diagnosing Oracle Clusterware and Node Management od_orac_a05_it_enus 1.50
  Oracle Database 11g: High Availability in RAC od_orac_a06_it_enus 2.00
  Oracle DB 11g: Security  
  Oracle Database 11g: Introduction to Database Security and Solutions od_odsc_a01_it_enus 1.50
  Oracle Database 11g: Database Security od_odsc_a02_it_enus 1.00
  Oracle Database 11g: Database Auditing od_odsc_a03_it_enus 1.50
  Oracle Database 11g: Basic User and Strong Authentication od_odsc_a04_it_enus 1.50
  Oracle Database 11g: Enterprise User Security and Proxy Authentication od_odsc_a05_it_enus 1.50
  Oracle Database 11g: Privileges, Roles, and Application Contexts od_odsc_a06_it_enus 1.50
  Oracle Database 11g: Virtual Private Database od_odsc_a07_it_enus 1.50
  Oracle Database 11g: Oracle Label Security and the Data Masking Pack od_odsc_a08_it_enus 2.00
  Oracle Database 11g: Encryption Concepts od_odsc_a09_it_enus 1.00
  Oracle Database 11g: Transparent Data Encryption od_odsc_a10_it_enus 1.50
  Oracle Database 11g: Oracle Net Services and Listener Security od_odsc_a11_it_enus 1.50
  Oracle Database 11g: Firewalls, Oracle Connection Manager, and SQL*Plus od_odsc_a12_it_enus 1.50
Oracle 10g   ↑Top
  Oracle Database 10g: Administration Workshop II  
  Using Flashback Technology in Oracle 10g 212481_ENG 2.75
  Performing and Managing Backups in Oracle 10g 212479_ENG 2.00
  Advanced Database Recovery and Repair in Oracle 10g 212480_ENG 2.25
  Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle 10g 212478_ENG 2.25
  Using Globalization Support in Oracle 10g 212477_ENG 2.25
  Optimizing Database Performance in Oracle 10g 221273_ENG 2.25
  Managing Storage and System Resources in Oracle 10g 221274_ENG 2.25
  Using the Scheduler to Automate Tasks in Oracle 10g 221275_ENG 2.25
  Using Advanced Features in Oracle 10g 221276_ENG 1.25
  Oracle Database 10g: SQL Fundamentals I and II  
  Introduction to Oracle and SQL in Oracle Database 10g 216104_ENG 3.25
  SQL Functions in Oracle Database 10g 216206_ENG 3.00
  Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g 216164_ENG 2.25
  Group and Datetime Functions in Oracle Database 10g 216205_ENG 3.25
  Subqueries and Hierarchical Queries in Oracle Database 10g 223292_ENG 2.25
  Regular Expressions and User Access in Oracle Database 10g 223293_ENG 2.00
  Creating and Managing Tables and Constraints in Oracle Database 10g 223294_ENG 2.00
  Database Objects in Oracle Database 10g 223295_ENG 2.00
  Managing Database Objects in Oracle Database 10g 223296_ENG 2.00
  Manipulating Data in Oracle Database 10g 223297_ENG 2.75
  Oracle Database 10g: Programming with PL/SQL I  
  Introduction to PL/SQL 216518_ENG 2.25
  Using PL/SQL with an Oracle Server 216530_ENG 2.00
  Using Control Structures 217616_ENG 2.00
  Using Composite Data Types 216540_ENG 2.00
  Explicit Cursors and Exception Errors 216554_ENG 3.00
  Creating Stored Procedures and Functions 216563_ENG 2.75
  Oracle Database 10g: Developing PL/SQL Program Units  
  PL/SQL Packages 216687_ENG 2.75
  Oracle-Supplied Packages and DBMS_SCHEDULER 216700_ENG 2.75
  Managing Dependencies 216717_ENG 1.50
  Manipulating Large Objects in PL/SQL 216725_ENG 2.00
  PL/SQL Triggers 216739_ENG 4.00
  Dynamic SQL and Metadata 218842_ENG 2.25
  Oracle Database 10g: New Features  
  Oracle Database 10g: New Installation and Configuration Features 210040_ENG 2.25
  Oracle Database 10g: New Data Loading Features 210050_ENG 2.00
  Oracle Database 10g: New Automatic Management Features 210057_ENG 3.25
  Oracle Database 10g: New Resource, Scheduling, and Task-Management Features 210074_ENG 3.25
  Oracle Database 10g: New Space Management Features 210086_ENG 2.25
  Oracle Database 10g: New Storage Features 210095_ENG 3.00
  Oracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features 220637_ENG 3.00
  Oracle Database 10g: New Backup and Recovery Features 220638_ENG 2.25
  Oracle Database 10g: Using Flashback 220639_ENG 2.25
  Oracle Database 10g: New Features in Security and Software Maintenance 220640_ENG 2.75
  Oracle Database 10g: New Features in VLDB Support 220641_ENG 2.00
  Oracle Database 10g: Miscellaneous New Features 220642_ENG 2.25
  Oracle Database 10g: Administration Workshop I Release 2  
  Oracle Database 10g: Installing Oracle Database 10g Release 2 249293_ENG 2.50
  Oracle Database 10g: Creating Databases Release 2 249294_ENG 2.50
  Oracle Database 10g: Database Interfaces Release 2 249295_ENG 3.00
  Oracle Database 10g: Database Control and Storage Structures Release 2 249296_ENG 2.50
  Oracle Database 10g: Users and Security Release 2 249297_ENG 3.50
  Oracle Database 10g: Managing Schema Objects and Data Release 2 249298_ENG 3.00
  Oracle Database 10g: The SQL*Loader and PL/SQL Release 2 249299_ENG 2.00
  Oracle Database 10g: Oracle Net Services and Shared Servers Release 2 249300_ENG 2.50
  Oracle Database 10g: Monitoring and Maintenance Release 2 249301_ENG 2.75
  Oracle Database 10g: Managing Undo Data and Lock Conflicts Release 2 249302_ENG 2.00
  Oracle Database 10g: Managing Backup and Recovery Release 2 249303_ENG 4.00
Oracle Database Systems   ↑Top
  Oracle Application Server 10g: Administration II  
  OracleAS 10g: Managing Customized Topologies and Distributing Infrastructure Components 222590_ENG 3.00
  OracleAS 10g: High Availability 222604_ENG 2.50
  OracleAS 10g: Managing and Configuring Clusters 222605_ENG 3.25
  OracleAS 10g: Business Intelligence Component Management 222606_ENG 4.00
  OracleAS 10g: XML Applications, Web Services, and Monitoring 222607_ENG 2.75
  OracleAS 10g: Tuning and Reconfiguring the Middle Tier 222608_ENG 4.25
  OracleAS 10g: Backup and Recovery 222609_ENG 1.75
Systems and Database Design   ↑Top
  Database Design  
  An Overview of Database Design 78565_ENG 1.00
  The Database Design Methodology 78580_ENG 4.00
  Database Fundamentals  
  An Introduction to Database Systems 80740_ENG 3.00
  Relational Databases 80751_ENG 3.00
  Database Data Management 80761_ENG 2.00
Microsoft SQL Server 2008   ↑Top
  Microsoft SQL Server 2008: Implementation and Maintenance  
  SQL Server 2008 Installation md_mcim_a01_it_enus 1.50
  SQL Server 2008 Instance and Database Configuration md_mcim_a02_it_enus 1.50
  SQL Server 2008 Security Management md_mcim_a03_it_enus 2.00
  SQL Server 2008 Database Management md_mcim_a04_it_enus 2.00
  SQL Server 2008 Data Management md_mcim_a05_it_enus 2.50
  SQL Server 2008 Database Monitoring and Performance md_mcim_a06_it_enus 2.50
  SQL Server 2008 Backups, Restores, and Database Snapshots md_mcim_a07_it_enus 1.50
  SQL Server 2008 High Availability and Disaster Recovery md_mcim_a08_it_enus 2.00
  Microsoft SQL Server 2008: Database Development  
  Creating and Implementing Database Objects in SQL Server 2008 md_msdd_a01_it_enus 2.50
  Creating and Modifying Table and Index Partitions in SQL Server 2008 md_msdd_a02_it_enus 1.00
  Running Queries and Manipulating Data in SQL Server 2008 md_msdd_a03_it_enus 1.50
  Performing Advanced Query Techniques in SQL Server 2008 md_msdd_a04_it_enus 1.00
  Creating and Implementing Programming Objects in SQL Server 2008 md_msdd_a05_it_enus 2.00
  Querying and Managing XML Data in SQL Server 2008 md_msdd_a06_it_enus 2.00
  Using SQL Server 2008 Messaging, Full-Text Search, Scripts, and Track Changes md_msdd_a07_it_enus 2.50
  Gathering Performance Data in SQL Server 2008 md_msdd_a08_it_enus 1.50
Microsoft SQL Server 2005   ↑Top
  Microsoft SQL Server 2005: Implementation and Maintenance  
  Installing SQL Server 2005 234620_ENG 3.00
  Configuring SQL Server 2005 234633_ENG 3.00
  Creating and Implementing Database Objects in SQL Server 2005 234647_ENG 3.00
  Retrieving Data and Running Queries in SQL Server 2005 234661_ENG 3.00
  SQL Server 2005 Messaging and Querying Tools 234686_ENG 2.00
  Managing and Maintaining SQL Server 2005 Databases 234704_ENG 3.00
  SQL Server 2005 Database Performance and Optimization 234718_ENG 2.75
  Monitoring and Diagnosing Database Problems in SQL Server 2005 234730_ENG 1.25
  SQL Server 2005 High Availability and Disaster Recovery 234771_ENG 3.00
  SQL Server 2005 Backup and Restores 234927_ENG 1.75
  Microsoft SQL Server 2005: Infrastructure Design  
  Designing a Database Server Infrastructure for SQL Server 2005 236740_ENG 2.25
  Designing Security for a Database Server Infrastructure for SQL Server 2005 236752_ENG 3.00
  Designing the Physical Database for SQL Server 2005 236765_ENG 2.75
  Designing a Database Server High Availability Solution for SQL Server 2005 236779_ENG 2.00
  Designing a Database Failover Solution for SQL Server 2005 236789_ENG 2.25
  Designing a Database Server Data Recovery Solution for SQL Server 2005 236970_ENG 2.50
  Microsoft SQL Server 2005: Database Maintenance  
  Optimizing SQL Server 2005 Performance 237852_ENG 3.00
  Optimizing a Database Data Recovery Plan for SQL Server 2005 237864_ENG 2.00
  Monitoring and Maintaining a Database in SQL Server 2005 237874_ENG 3.00
  Managing Data Between Servers and Databases 238143_ENG 2.50
  Managing and Maintaining Database Security in SQL Server 2005 238510_ENG 2.50
  Managing Database Data in a SQL Server 2005 Environment 237888_ENG 3.25
  Microsoft SQL Server 2005: Designing Database Solutions  
  Designing an Application Solution for SQL Server 2005 256066_ENG 3.00
  Designing Database Objects 256067_ENG 2.50
  Programming with SQL Server 2005 256068_ENG 2.25
  Using XML 256069_ENG 2.25
  CLR Integration 256162_ENG 3.00
  Database Testing and Code Management 256268_ENG 2.25
  Developing Applications that Use SQL Server Support Services 256270_ENG 2.25
  Developing Applications that Use SQL Server Business Intelligence Services 256269_ENG 2.25
  Database Deployment and Data Distribution 256271_ENG 2.25
  Microsoft SQL Server 2005: Designing and Optimizing Data Access  
  Designing Access to SQL Server Data 256868_ENG 2.25
  Designing Efficient Application Access 256869_ENG 2.00
  Designing Queries in SQL 2005 256870_ENG 2.25
  Designing a SQL Server 2005 Cursor Strategy 256871_ENG 1.00
  Designing a SQL Server 2005 Transaction Strategy 256872_ENG 2.00
  SQL Server 2005 Error Handling Techniques 256873_ENG 1.25
  Optimizing Query Performance and Index Strategies 256874_ENG 2.25
  Optimizing Storage in SQL Server 2005 256875_ENG 1.25
  Scaling Applications and Resolving Performance Issues 256999_ENG 2.00
Microsoft SQL Server 2000   ↑Top
  Microsoft SQL Server 2000 Database Administration I  
  Overview of SQL Server 2000 31478_ENG 2.00
  Installing, Configuring, and Upgrading SQL Server 2000 31489_ENG 2.00
  Microsoft SQL Server 2000 Database Administration II  
  SQL Server 2000 Databases 31493_ENG 2.00
  Transferring and Transforming Data in SQL Server 2000 31496_ENG 1.00
  Security in a Microsoft SQL Server 2000 Environment 31499_ENG 2.00
  Managing SQL Server 2000 Databases 31552_ENG 2.00
  Microsoft SQL Server 2000 Database Administration III  
  Backing Up SQL Server 2000 Databases 31556_ENG 2.00
  Restoring SQL Server 2000 Databases 31560_ENG 2.00
  SQL Server 2000 Replication 31563_ENG 2.00
  Monitoring SQL Server 2000 Performance 31566_ENG 2.00
  SQL Server 2000 High Availability 31569_ENG 1.00
  SQL Server 2000, XML, and the Web 31571_ENG 2.00
  Microsoft SQL Server 2000 Database Implementation  
  Overview of SQL Server 2000 31478_ENG 2.00
  SQL Server 2000 Databases 31493_ENG 2.00
  Transferring and Transforming Data in SQL Server 2000 31496_ENG 1.00
  SQL Server 2000, XML, and the Web 31571_ENG 2.00
  Designing and Implementing Security in SQL Server 2000 31898_ENG 1.00
  The SQL Server 2000 Logical Data Model 31901_ENG 2.00
  Using T-SQL in SQL Server 2000 31905_ENG 3.00
  SQL Server 2000 Indexes 31910_ENG 2.00
  SQL Server 2000 Programming Business Logic 31913_ENG 3.00
  SQL Server 2000 Transactions and Distributed Data 31917_ENG 2.00
  Analyzing and Optimizing SQL Server 2000 Queries 31920_ENG 2.00