Introduction to Oracle

Introduction to Oracle / get ed2go course code

1 Introduction to Oracle Database. This chapter provides an overview of Oracle Database. This chapter contains the following sections: About Relational ...

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 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.

Course Code: ioc

What You Will Learn

• Learn to plan, organize and manage data with Oracle
• Learn how to create an Oracle database
• Discover how to build various database objects for the database
• Understand how to write simple SQL statements that access the data from the database
• Learn how to write Data Definition Language statements to create, update, and delete database objects
• Learn how to execute Data Control Language statements to give or delete access rights to database objects
• Discover how to query the data and create finished reports