Introduction to Oracle
Learn how to use the Oracle database management system to plan, organize, and manage your data. Introduction to Oracle will provide you with a practical hands-on approach to relational databases concepts and Oracle's database management system. This course will introduce you to the Structured Query Language (SQL), Oracle's SQL*Plus, and other valuable tools used to develop, manage, and reference an Oracle database.
In this six-week online course, you will learn how to create an Oracle database, build various database objects for the database, and write simple SQL statements that access the data from the database. This course will teach you how to write Data Definition Language statements to create, update, and delete database objects. You will learn how to execute Data Control Language statements to give or delete access rights to database objects. You will write Data Manipulation Language statements to insert, update, and delete records from a database. Finally, you will learn how to query the data and create finished reports.
Gain hands-on experience with Oracle's PL/SQL programming language, with expert assistance from an IT veteran. PL/SQL is Oracle's procedural language extension to Structured Query Language (SQL). This course will give you the skills you need to write powerful and flexible programs using that language. You'll learn the building blocks and core features of PL/SQL, including expressions, various iterations, and built-in functions. Then, you'll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing. By the time you finish this course, you will be able to store PL/SQL programs in a database and execute them.
Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.
About The Instructor
Cindy Delia is a Systems Analyst and a certified instructor. She has
been working in information technology for more than 18 years and has
been a technical trainer for over 6 years. As a Systems Analyst, she
specializes in database management systems and develops PC applications.
She has taught computer courses at the community college level and also
performs corporate training. Cindy has also written technical manuals