Other

Oracle SQL and PL/SQL for Developers ISI-1527

  • 0 upcoming dates
  • $2,995 per seat

About this class

If you're developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you: This five day, instructor-led course shows you how. It teaches you how to create effective SQL queries to extract and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use PL/SQL to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to create the kind of efficient database applications that make you a more effective and valuable developer

What you'll be able to do

  • Learn the concepts and terms you need for working with any database.
  • Learn how to use Oracle Database and Oracle SQL Developer to run SQL
  • statements
  • programming background.
  • updating and deleting that data.
  • 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
  • Lear n how to use Oracle’s procedure language, PL/SQL, to created stored

Course outline

  1. Module 1An Introduction to SQL

    • and locking.
    • Learn how to work with the timestamp, interval, and large object data types;
    • features that ar e critical for storing data.
    • An introduction to client/server systems
    • The hardware components of a client/server system
    • The software components of a client/server system

Download the full outline (PDF)

Before you attend

Students should have some development experience. Everything you need to know about databases an d triggers. In short, it teaches you to create the kind of efficient database applications that make you a more effective and valuable developer

Run this for a team

Private cohorts run on your dates, at your site or online, with the labs pointed at your environment. Above about four people it usually costs less than buying seats.

Or call 916-920-1700, weekdays 8 to 5 Pacific.

More software development classes

See all