office (678) 325-7317
fax (678) 325-7317
Oracle SQL and PL/SQL for Developers

Course Length: 5 days or two 3 day classes


Section 1: An introduction to SQL
In this section, you’ll learn the concepts and terms you need for working with any database. You’ll also learn how to use Oracle Database and Oracle SQL Developer to run SQL statements on your own computer.

Section 2: The essential SQL skills
In this section, you’ll learn all the SQL skills for retrieving data from a database and for adding, updating, and deleting that data. These skills move from the simple to the complex so you won’t have any trouble if you’re new to SQL. But these skills are also sure to raise your expertise even if you already have SQL experience.

Section 3: Database design and implementation
Here, you’ll learn how to design a database and how to implement that design by using the DDL (Data Definition Language) statements that are a part of SQL. When you’re done, you’ll be able to design and implement your own database. You’ll also gain valuable perspective that will make you a better SQL programmer, even if you never have to design a database.

Section 4: The essential PL/SQL skills
In this section, you’ll learn how to use Oracle’s procedure language, PL/SQL, to create stored procedures, functions, and triggers. You’ll also learn how to manage transactions and locking. That will give you a powerful set of PL/SQL skills.

Section 5: Advanced data types
Here, you’ll learn how to work with the timestamp, interval, and large object data types. These data types became available with releases 9i and 8, and they provide features that are critical for storing data in today’s global and digital world.

Who Should Attend?

Application developers
I think it’s fair to say that most developers don’t know enough about SQL and the database management system they’re using. As one customer put it, "I know just enough about SQL to be a little bit dangerous!" That’s why developers often code SQL statements that don’t perform as efficiently as they ought to. That’s why they aren’t able to code some of the queries that they need for their applications. And that’s why they don’t take advantage of all the features that Oracle has to offer. That’s also why our Oracle course should be required for every application programmer who uses Oracle. It shows you how to code the SQL statements that you need for your applications. It shows you how to code these statements so they run efficiently. And it shows you how to take advantage of the most useful advanced features that Oracle has to offer.

Anyone who wants to become a database administrator
This course is also the right first course for anyone who wants to become a database administrator. Although this course doesn’t present all of the advanced skills that are needed by a DBA, it will get you started. Once you’ve finished it, you’ll be prepared for more advanced courses on the subject.

Anyone who wants to learn standard SQL
This course is also a good choice for anyone who wants to learn standard SQL. Since SQL is a standard language for accessing database data, most of the SQL code in this course will work with any database management system. As a result, once you attend this course to learn how to use SQL to work with a Oracle database, you can transfer most of what you have learned to another DBMS such as MySQL, DB2, or Microsoft SQL Server.

What the prerequisites are
Although you will progress through this course more easily if you have some development experience, everything you need to know about databases and SQL is presented in this course. As a result, you don’t need to have any programming background to attend this course.

Course Outline

Section 1 An introduction to SQL

Module 1 An introduction to relational databases and SQL

Module 2 How to use Oracle SQL Developer and other tools

Section 2 The essential SQL skills

Module 3 How to retrieve data from a single table

Module 4 How to retrieve data from two or more tables

Module 5 How to code summary queries

Module 6 How to code subqueries

Module 7 How to insert, update, and delete data

Module 8 How to work with data types and functions

Section 3 Database design and implementation

Module 9 How to design a database

Module 10 How to create tables, indexes, and sequences

Module 11 How to create views

Module 12 How to manage database security

Section 4 The essential PL/SQL skills

Module 13 How to write PL/SQL code

Module 14 How to manage transactions and locking

Module 15 How to create stored procedures

Module 16 How to create triggers

Section 5 Advanced data types

Module 17 How to work with timestamps and intervals

Module 18 How to work with large objects

Home | AboutUs | Training | Mentoring | Contact Us

© 2008 Dunn Training Inc. All Rights Reserved.