Databases Curriculum

(164.53 KB) View, Download, or Print Curriculum as a PDF.

| Oracle | MySQL |

Introduction to OracleSQL: This course is designed to give users an understanding of Oracle using Oracle's SQL *Plus and iSQL*Plus tools. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations. The course topics are applicable to all versions of Oracle through Oracle 10g.
Introduction to SQL: This course is designed to give users an understanding of SQL Language: The course covers SQL commands for DML, DDL, Query, and Transaction Control operations.
Introduction to Oracle SQL and PL/SQL: This course is designed to give users an understanding of Oracle SQL and Oracle PL/SQL languages using Oracle’s SQL*Plus and iSQL*Plus tools. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations. Students are also introduced to procedural programming using PL/SQL. The course topics are applicable to all versions of Oracle through Oracle 10g.
Oracle Database 10g: Administration Workshop I Release 2 (ekit): This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.
Oracle Database 10g: Administration Workshop II (ekit): In this class, you'll learn how to configure an Oracle database for multilingual applications. Students will practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Tools to monitor database performance and what steps to take to improve database performance are also covered in this course. Students will also learn how to use various database technologies, such as Resource Manager, the Scheduler, and Automatic Storage Management (ASM). The lesson topics are reinforced with structured hands-on practices and a workshop. This course is designed to prepare you for the corresponding Oracle Certified Professional exam.
Oracle Database 10g: New Features for Administrators Release 2 (ekit): This course introduces students to the new features in Oracle Database 10g Release 2. Students learn how to use new features to increase database availability, simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and offer simplified database manageability. The course also covers security changes.
Oracle Database 10g: Backup and Recovery (ekit): In this course participants learn how to use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are described as an additional way to recover from human error. This Course includes Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN and also provides general file system backup to tape capabilities. Students install Oracle Secure Backup and use it to back up Oracle Database files and file system files.
Oracle Database 10g: Performance Tuning (ekit): Get the most out of your 10g Database by learning performance tuning methods that maximize the utility of the database. Students learn how to benefit from Oracle Database 10g automatic tuning features, as well as practicing the manual tuning methods using the statspack tool. After clearly defining the various methodologies one can use to tune an Oracle Database, the course covers the various tunable components of an Oracle Database. Throughout the course, students experience hands-on the tuning of an Oracle Database by practicing through a series of workshops.
OracleAS Discoverer 10g: Create Queries and Reports (ekit): This course introduces students to the querying and analytical capabilities of OracleAS Discoverer. Students will learn how to view data stored in a relational database, and analyze and create reports based upon that data using OracleAS Discoverer Plus. In particular, students will learn how to create, modify, and refine ad hoc queries using Discoverer's intuitive and easy-to-use Workbook Wizard. They will learn how to present data graphically and how to format query results to create customized reports. Students will learn how to create simple and advanced calculations to perform data analysis and create reports that answer a variety of business questions, such as year-to-year comparisons and ranking. In addition, students will learn how to schedule reports in batch mode, share workbooks with other users, and export reports to other applications, including MS Excel, HTML, and Oracle Reports. Finally, students will learn how to view and customize Discoverer portlets using OracleAS Portal. This course also provides students with the prerequisite skills necessary for the "Oracle Discoverer 10g: Develop an EUL" course.
Oracle Database 10g: Program with PL/SQL (ekit): This class is applicable to Oracle8i, Oracle9i and Oracle Database 10g users. This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks, stored procedures, and functions. They learn about declaring variables and trapping exceptions. Students will also learn to develop stored procedures, functions, packages and database triggers. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. Students use iSQL*Plus to develop these program units. Demonstrations and hands-on practice reinforce the fundamental concepts.
Oracle Database 10g: SQL Tuning Workshop (ekit): This course is designed to give the experienced SQL Developer or DBA a firm foundation in SQL tuning techniques. The participant learns the necessary knowledge and skills to effectively tune SQL in the Oracle Database 10g. They learn about tuning methodology as well proactive tuning and reactive tuning methods. Students are introduced to the benefits of the new automatic tuning mechanisms available in Oracle Database 10g. On completion of the course they are able to compare and contrast the steps involved to tune manually as in prior releases as well as use the automatic SQL tuning features provided in the current release. Students gain a thorough conceptual understanding of the Oracle Optimizer, and reinforce instructor-led learning with structured hands-on practices. The course uses a series of challenge-level workshops, allowing students to "play, discover, and learn" at their own level and pace. The students learn to use the Oracle diagnostic tools and facilities: Automatic SQL Tuning components, EXPLAIN, SQL Trace and TKPROF, SQL*Plus AUTOTRACE. Students also learn to influence the behavior of the Optimizer by changing the physical schema and modifying SQL statement syntax.
Oracle Database 10g: Advanced PL/SQL (ekit): n this course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, and collections, students learn how to write powerful PL/SQL programs. Programming efficiency, use of external C and Java routines, PL/SQL server pages, and fine-grained access are covered.
Oracle Reports Developer 10g: Build Reports (ekit): Students learn how to design reports and how to retrieve, display, and format data in numerous reporting styles and publish the output. Students also learn how to add dynamic content to a static Web page, publish reports to the Web, customize complex reports, embed charts, and use OracleAS Reports Services to deploy reports.
Oracle Forms Developer 10g: Build Internet Applications (ekit): In this course, you will build, test and deploy Internet applications with Oracle Forms. Working in a graphical user interface (GUI) environment, you learn how to build forms with user input items such as check boxes, list items, and radio groups. You will also display Form elements in multiple windows and customize data access by creating event-related triggers.
Oracle Database 11g: Introduction to SQL (ekit): In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course discusses how to use the regular expression support in SQL. In this course, students use Oracle SQL Developer as the main development tool. SQL*Plus is introduced as an optional development tool.
Oracle Database 11g: Administration Workshop I (ekit): This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.
Oracle Database 11g: Administration Workshop II (ekit): In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios. Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.
Oracle Database 11g: New Features for Administrators (ekit): This course gives students the opportunity to learn about-and practice with the new change management features and other key enhancements in Oracle Database 11g Release 1. Students examine the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas that concern database administrators. In addition, the hands-on practice sessions help reinforce students understanding of these new capabilities in Oracle Database 11g Release 1.
Oracle Database 11g: Performance Tuning (ekit): Students learn how to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components. Throughout the course, students practice the art of tuning an Oracle Instance through a series of workshops. The methodology is practiced in the workshops rather than taught.
Oracle Database 11g: Backup & Recovery (ekit): Oracle Database 11g: Backup and Recovery training teaches students how to backup and recover a portion or all of an Oracle 11g database.

Introduction to SQL Training using MySQL: This MySQL training course is designed for students new to writing SQL queries using MySQL.
Introduction to MySQL/PHP: This five day class is broken down into three sections: Part I - learning PHP syntax which weds well with HTML/XHTML; Part II - learning how to create MySQL databases and querying them with SQL; and Part III - applying this knowledge in the development of an application. The student will be able to run three tier applications by the end of the class. The core of the curriculum is focused on the Middle tier using the PHP scripting language to develop the application logic.
Building and Securing Web Applications Using MySQL and PHP: This course examines the issues associated with the development of a dynamic web page. Emphasis is placed on using the power of PHP to link to server side databases (MySQL), files, and directories for creating pages that mine data about past user interactions. Taking data from a user can be a security issue if your code is insecure. This course will examine functions and techniques essential for securing your system while providing a rich user experience. Best practices for development of the page are covered to provide guidelines while creating a dynamic web page. A web application is developed as the student progresses through each chapter.