Method
Live-Online
Term
FALL
Units
3.0 QUARTER UNITS
Cost
$740

Skills you will gain

  • SQL Mastery: Perform DDL and DML operations with advanced SQL commands for effective data manipulation.
  • Stored Procedure Development: Design and manage database stored procedures with best practices for optimized performance.
  • Automation with Triggers: Use database triggers to automate operations and streamline processes.
  • Database Performance Optimization: Apply strategies like indexing, explain plans, and partitioning to enhance database performance.
  • Error Handling Expertise: Implement exception and error handling techniques in both MySQL and Oracle databases for robust applications.

Course Description


Oracle and MySQL are both reliable database engines commonly used for storing and serving data as web content. They are popular among developers of open source platforms and projects on the Web. High volume major websites use them. They also have a significant user base in the enterprise database market. This course is intended for DB developers and designers who want to learn MySQL and Oracle technology in depth.

The course begins by reviewing the basic SQL queries, DDL and DML operations, data retrieval from multiple tables, and different types of storage engines in databases. It then introduces the aggregate, the index merge, data manipulation, and stored procedures in MySQL. You will learn to write complex queries and get hands-on experience with advanced features such as creating sub programs, data security, triggers, and dynamic SQL. You will also learn a performance tuning strategy, server configuration, loading techniques and the application architecture for efficient database design. This is a hands-on lab-based course designed to help students master MySQL features and tune for performance.


Topics

  • Review of MYSQL and Oracle database essentials
  • Understanding MYSQL storage engines, transactions and features of the database and how it differs from Oracle
  • Performing DDL and DML operations using SQL commands
  • Retrieving data from multiple tables using JOINS
  • Writing complex queries using JOINS, SUBQUERIES and nested SUB QURIES
  • MYSQL functions including single-row, multiple-row, group and aggregate functions
  • Understanding Oracle and MYSQL optimizer and index merge method
  • Developing and managing database stored procedures including best practices
  • Exception handling and error handling capabilities in both Oracle and MYSQL
  • Utilizing database triggers to automate database operations
  • Oracle and MYSQL performance enhancements with queries and indexes
  • Database loading techniques and their effects on performance

Prerequisites / Skills Needed

Skills Needed:

  • Students should have prior knowledge of the installation and basic operation of MySQL.
Syllabus Library

You may enroll in this offering at any time.
Jeffrey S Miller
Jeffrey Miller
Sep. 1 - Nov. 17, Tue, 6:00pm - 9:00pm
  • Live-Online Attend via Zoom at scheduled times.
DBDA.X409.(17)
Schedule
Date Start Time End Time Meeting Type Location
Tue, 09-01-2026 6:00pm 9:00pm Live-Online REMOTE
Tue, 09-08-2026 6:00pm 9:00pm Live-Online REMOTE
Tue, 09-15-2026 6:00pm 9:00pm Live-Online REMOTE
Tue, 09-22-2026 6:00pm 9:00pm Live-Online REMOTE
Tue, 09-29-2026 6:00pm 9:00pm Live-Online REMOTE
Tue, 10-06-2026 6:00pm 9:00pm Live-Online REMOTE
Tue, 10-13-2026 6:00pm 9:00pm Live-Online REMOTE
Tue, 10-20-2026 6:00pm 9:00pm Live-Online REMOTE
Tue, 10-27-2026 6:00pm 9:00pm Live-Online REMOTE
Tue, 11-03-2026 6:00pm 9:00pm Live-Online REMOTE
Tue, 11-10-2026 6:00pm 9:00pm Live-Online REMOTE
Tue, 11-17-2026 6:00pm 9:00pm Live-Online REMOTE
 

This class is offered in an online synchronous format. Students are expected to log into this course via Canvas at the start time of scheduled meetings and participate via Zoom, for the duration of each scheduled class meeting.

Two "no meetings" TBA. To see all meeting dates, click "Full Schedule" below.

You will be granted access in Canvas to your course site and course materials approximately 24 hours prior to the published start date of the course.

||

Prerequisites / Skills Needed

Skills Needed:

  • Students should have prior knowledge of the installation and basic operation of MySQL.

This course applies to these programs:

Demo