This course teaches people with little or no programming experience how to program with the PL/SQL to automate and extend the capabilities or Oracle Database.
Our introductory classes emphasize;
- Achieving program clarity through proven software-development techniques
- Learning skills that underlie good programming through dozens of complete, working programs.
This hands-on approach rapidly builds the confidence of new programmers, because all programming concepts are presented in the context in which they will be used.
View Course Details
This course begins by enabling you to master the Oracle database concepts you need to know to handle Oracle databases effectively. You will learn how to use using Oracle SQL Developer and how to install and configure Oracle client and server software. You will learn SQL in-depth so that you will be able to write the SQL statements that retrieve and update the data in an Oracle database. It also teaches you how to work with complex inner and outer joins, summary queries, sub queries, data types, and functions…all features that allow you to retrieve and update data more efficiently. You will learn how to design an Oracle database and you how to code SQL DDL (Data Definition Language) statements to implement the design, to create views, and to manage security. In today's increasingly global and digital world, you may need to handle time zones from around the world, and you may need to handle large amounts of text and binary data such as graphics, sound, and video you will learn how to manage these tasks easily and professionally.
Once you have mastered the course proceeds to PL/SQL. You learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions.
Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students learn the basic functionality of how to debug functions and procedures using the SQL Developer Debugger. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages. Additionally students learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies.
As you progress through the course you will learn to master the issues database administrators and developers deal with every day enabling you to become a highly proficient Oracle Developer
This course cover the objectives for the current and prior version of the following Oracle exams:
- PL/SQL Developer OCA
- Oracle Database SQL Expert exam.
View Course Details
This course gives you the skills you need to develop and manage high performance Oracle Databases to a professional standard using SQL
You’ll quickly master the concepts you need to develop and manage Oracle databases effectively. You will learn how to install and configure the Oracle Server and Client software You will use Oracle SQL Developer, this graphical tool makes it easy to work with Oracle databases making you productive right from the start. You will master the SQL statements that Oracle professionals use every day to retrieve and update the data in an Oracle databases. But it doesn't stop with simple SQL statements. Instead, it also teaches you how to work with complex inner and outer joins, summary queries, sub-queries, data types, and functions all features that allow you to retrieve and update data more efficiently. You will learn to design and create databases and database objects such as tables, views, constraints, synonyms and indexes. You will learn to manage the database security by controlling user access; you will learn how to manage data across multiple time zones. Along the way, you'll gain insight into the issues database administrators and developers deal with every day...a plus if you decide you want to move in those career direction.
The course covers the objectives for the Oracle Database SQL Expert exam
View Course Details
Existing students can login here.
IT Programming Courses, 175-185 Gray’s Inn Road, London, WC1X 8UE, Phone: 020 7193 3962, Fax: 020 7812 0650
