Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Other Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications AutoCAD Microsoft QuickBooks Windows Other Computer Programming Computer Programming Programming Classes Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Other Test Prep Test Prep Exam Prep Writing Writing Writing and Editing How It Works How It Works About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
Courses
Arts and Design
Animation
Graphic Arts
Photography
Web Design
Other
Business
Accounting
Administrative
Communication
Finance
Marketing and Sales
Operations
Project Management
Small Business
Soft Skills
Career Online High School
Online High School Diploma
Computer Applications
AutoCAD
Microsoft
QuickBooks
Windows
Other
Computer Programming
Programming Classes
Construction and Trades
Construction
Environmental and Energy
Trades
Health and Fitness
Alternative Medicine
Dental
Fitness
Medical
Veterinary
Wellness
Hospitality
Hospitality Service
Information Technology
Cloud Computing
Networking
Other
Security
Language
Languages
Legal
Legal Studies
Math and Science
Mathematics and Science
Teacher Professional Development
Child Development
Classroom Technology
Math and Science
Reading and Writing
Other
Test Prep
Exam Prep
Writing
Writing and Editing
How It Works
About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
ed2go Computer Programming Programming Classes Learn SQL + Java Programming
Return to Programming Classes
pl-sql-developer

Learn SQL + Java Programming

In our data-driven world, businesses of all sizes desire expert database use and management—and you can be one of the people to fulfill this growing need. As a database developer, software programmer, or data analyst, you’ll need a robust knowledge of Structured Query Language (SQL). In our course, you’ll learn SQL, as well as the common Java programming language. To get ahead in your career, enroll in ed2go’s Oracle SQL and PL/SQL Developer + Java Programmer Course today.

Oracle SQL is a powerful database programming language that is the standard in the industry. Our SQL course provides even more value, because we combine Oracle training with sections on PL/SQL Developer and Java Programming, so you learn multiple programs in one. Our online course is the best way to learn SQL and is ideal for those looking to get started in each of these coding languages. By the end of the program, you’ll be prepared to join the job market as an entry-level Oracle SQL and/or Java Developer, or take on more responsibility within your current role.

12 Months / 220 Course Hrs
Open Enrollment

Offered in Partnership with your Preferred School

Association of Executive and Administrative Professionals Why this school? It's been chosen based on your location or if you've visited this school's website.

Financial Assistance Available*

Change School

Learning Method

Instructor-led Self-Paced: Study at your own schedule

Contact Us

Learn SQL + Java Programming

Learning Method

Instructor-led Self-Paced: Study at your own schedule

Contact Us

Oracle SQL and PL/SQL Developer + Java Programmer Details + Objective

Course Code: GES339

You Will Learn
  • How to use Oracle SQL to communicate with relational databases, including updating and retrieving data.
  • The various uses of the PL/SQL procedural language extension and the basics of using blocks, subprograms, and triggers.
  • All about the Java environment and syntax, from arrays, inheritance, and interfaces to exceptions and collections.
How the course is taught
  • This open-enrollment program is taught entirely online, and is completed at your own pace.
  • When you register, you receive twelve months to complete this course.
  • You’ll be paired with a facilitator for one-on-one interaction and feedback on your performance.
How you will benefit
  • Gain skills and knowledge that are highly in demand in the programming, software development, and database management industries.
  • Prepare yourself to enter an exciting new field—or excel even more in your current position.
  • Earn a certificate of completion and add your new expertise to your resume.
Oracle SQL and PL/SQL Developer + Java Programmer Outline
Expand All
The course outline includes the following lessons:

Lesson 1: Introduction to SQL: Relational Database Basics

Our first lesson is an SQL tutorial for beginners. We’ll go over a brief history of SQL, as well as relational databases, popular databases, and SQL statements.

Lesson 2: Simple SELECTs

Lesson 2 will introduce you to the Northwind database, including SELECTing all columns in all rows, exploring the tables, SELECTing specific columns, and sorting records. We’ll learn about the WHERE clause and operator symbols and words, checking for NULL, and writing SELECTs with multiple conditions.

Lesson 3: Advanced SELECTs

In this lesson we’ll learn about calculated fields and calculating fields, as well as working with aggregate functions. Lastly, we’ll move on to data manipulation functions, including built-in.

Lesson 4: Subqueries, Joins, and Unions

This lesson covers subqueries, joins, and unions, including outer joins and the specifics of working with unions.

Lesson 5: Advanced Oracle SQL Queries: Users and Schemas

This lesson provides an introduction to users and schemas, teaching you all about the HR schema and creating an application schema.

Lesson 6: Pseudo Columns & Functions

Here you’ll learn how to use the dual table, including its functions and an exercise on using the SYSCONTEXT function. Then you’ll discover how to use ROWID and ROWNUM.

Lesson 7: Using Subqueries

This lesson will cover simple subqueries, inline views, correlated subqueries, and scalar subqueries.

Lesson 8: Joining Tables

Next we’ll review joins, including equijoins and cross, reflexive, non-key, and natural joins. Then we’ll go over semijoins and antijoins and using named subqueries.

Lesson 9: Rollup & Cube

Lesson 9 will teach you all about group processing, including EMP_DETAILS_VIEW, simple GROUP BY, the ROLLUP function, the GROUPING function, and using CUBE.

Lesson 10: Using Set Operators

First we’ll define set operators, before learning about their relationship to mathematical set theory and the various restrictions placed on them.

Lesson 11: Conditional Processing

In our lesson on conditional processing, we’ll review the DECODE function and the case expression.

Lesson 12: SQL Functions (Character)

Lesson 12 will answer the question, “What are SQL functions?” Then we’ll review character functions and regular expressions.

Lesson 13: SQL Functions (Non-Character)

This lesson covers non-character SQL functions, such as numeric, date/time, date format, date arithmetic, and null value functions.

Lesson 14: SQL Data Manipulation Language

In this lesson, you’ll learn about INSERT, UPDATE, and DELETE statements, as well as transactions, complex table references, and the MERGE statement.

Lesson 15: Oracle PL/SQL Training: The Environment for PL/SQL Development

Now we’ll start learning about the PL/SQL extension to Oracle. This lesson reviews connecting to Oracle, executing PL/SQL code, SQL developer configuration, and the PL/SQL development cycle.

Lesson 16: PL/SQL Basics

In our second PL/SQL lesson, we’ll discuss two different block structures: anonymous and named blocks. Then we’ll review executing blocks, calling PL/SQL functions, and executing PL/SQL blocks and functions.

Lesson 17: Declaring Variables

This lesson reviews variable usage, data types, naming, and assignment. Then you’ll learn all about complex variable types, as well as variable declaration, initialization, and display.

Lesson 18: Within the Block

Next, you’ll discover conditional processing and iterative processing. We’ll go over salary classification using conditional statements and salary increases using loops.

Lesson 19: Handling Exceptions

In this lesson you’ll learn about exceptions, including causing, handling, and identifying them. Then we’ll learn about the OTHERS exception handler, user defined exceptions, and exception handling for invalid salary.

Lesson 20: Use of SQL in PL/SQL

In this lesson, we’ll review a variety of topics, including implicit cursors, %TYPE and %ROWTYPE attributes, the EXECUTE IMMEDIATE statement, attributes of implicit and explicit cursors, and the cursor FOR loop.

Lesson 21: Nested Blocks

This lesson will show you how to nest blocks, with topics like scope of variables, scope of exceptions, nested subprograms, and exception propagation in nested blocks. Lastly, you’ll learn about block variable visibility.

Lesson 22: Introducing Subprograms

This lesson will introduce you to subprograms, reviewing anonymous blocks, types of subprograms, and finding subprograms through SQL Developer and in the Oracle Data Dictionary. We’ll end with a lesson on object dependencies.

Lesson 23: Stored Procedures and Functions

Here you’ll learn how to create, modify, and remove subprograms. Then we’ll move on to application maintenance, parameters, and subprogram development techniques. The lesson addresses SQL errors in compilation, directives for debugging, issues with Booleans, integrated development environments, and PL/SQL subprograms with parameters.

Lesson 24: Packages

In this lesson, you’ll review the structure and purpose of packages, including wrap utility, positional versus named parameter notation, subprograms omitted from specifications, and using PL/SQL packages.

Lesson 25: Database Triggers

Next, you’ll learn about the purpose of triggers, and how to invoke, code, validate, modify, view, and enable/disable them. Then we’ll teach you about trigger errors, system and user event triggers, and the logon counter trigger.

Lesson 26: Data Retrieval Techniques

In our lesson on data retrieval techniques, we’ll go over cursor parameters, cursor variables, dynamic SQL, and employee reports by state/province.

Lesson 27: Using Oracle Supplied Packages

In this lesson you’ll learn how to identify available packages and package subprograms. Then we’ll review selected Oracle supplied package demos, packages related to input/output and networking, dynamic SQL, working with URLS, and DBMS_APPLICATION_INFO.

Lesson 28: Specialized Topics

The specialized topics in this lesson include application partitioning, subprograms in other languages, statistical analysis, data mining, and using Oracle object features.

Lesson 29: Java Introduction

In this lesson, we’ll review how to write a Java program, set up your Java environment, create a class that can run as a program, and use the Java documentation.

Lesson 30: Java Basics

Lesson 30 introduces you to basic Java syntax, data, and mathematics, and teaches you how to create and use methods.

Lesson 31: Java Objects

In our lesson on Java objects, we’ll review String, StringBuffer, and StringBuilder, plus creating documentation comments and using Javadoc.

Lesson 32: Comparisons & Flow Control Structures

Now we’ll learn about controlling program flow, including break and continue statements. Then we’ll review Classpath, code libraries, and JAR files.

Lesson 33: Arrays

Next up, you’ll discover all you need to know about arrays, including the for-each loop, multi-dimensional arrays, and typecasting with arrays of primitives.

Lesson 34: Inheritance

This lesson covers inheritance, polymorphism, and creating a derived class. Then we learn about typecasting with object references, other inheritance-related keywords, and methods inherited from objects.

Lesson 35: Interfaces

First, we’ll define interfaces, before learning how to create and implement one. Then we’ll go over reference variables and interfaces, interfaces and inheritance, and some uses for interfaces.

Lesson 36: Exceptions

In Lesson 36, we’ll attempt risky code with the try and catch blocks, and guarantee execution of code with the finally block. Then we’ll learn about throwing and re-throwing an exception, exceptions and inheritance, creating and using your own exception classes, and initializer blocks.

Lesson 37: Generics and Collections

This lesson first reviews the fundamental collections: sets, lists, and maps. Then you’ll learn about iterators, creating collectible classes, and generics.

Lesson 38: Inner Classes

In our last lesson before your final exam and project, you’ll discover inner classes, also called nested classes. These are useful for grouping classes to make your package more streamlined, and making code more readable and maintainable.

Oracle SQL and PL/SQL Developer + Java Programmer Instructors
Roger Sakowski

Roger Sakowski has over 35 years of experience in technical training, programming, data management, network administration, and technical writing for companies such as NASA, Sun Microsystems, Bell Labs, GTE, GE, and Lucent, among other Fortune 100 companies. Roger has been an instructor for Webucator for six years and previously trained for other prominent technical training companies.

Oracle SQL and PL/SQL Developer + Java Programmer Requirements / Prerequisites

None, though some prior programming language knowledge is helpful.

Oracle This program can be taken only on a PC. It is compatible with the Windows XP (Service Pack 2) and later operating systems and with the latest versions of any of the following browsers: Mozilla Firefox, Internet Explorer, and Google Chrome. NOTE: Dual monitors are helpful but NOT required. I. Oracle Database 10g/11g You need to have full administrative access to Oracle 10g or 11g. If you do not, you can use Oracle 11g Express Edition: 1. Download Oracle Database Express Edition for either 32 or 64 bit OS: http://www.oracle.com/technetwork/database/database-technologies/express-edition/overview/index.html?ssSourceSiteId=ocomen. Note: you will need to register for a free account to gain access to the download. 2. Execute the file you downloaded by double-clicking on the folder and then double-clicking on Setup.exe. 3. Run through the Installer accepting all the defaults. Make your password system (all lowercase). Make sure to write down and keep your password. NOTE: For any IT Department personnel who are setting up a work computer for a student: o This class requires the use of the Oracle supplied HR demo schema, with the permissions and objects in the state in which Oracle created them. The HR schema is created by default during an install but is not always unlocked. Please unlock the schema, assigning a password. Please make sure the student has the password. If you will be using a work laptop at home, then install Oracle at home. If your IT department is installing it at work, make sure they disconnect from both the internet and the intranet before launching the install. The safest way to do this is to remove the ethernet connection from your laptop and turn off your wireless connection II. Oracle Client Options 1. Install Oracle SQL Developer 1. If you are on a Windows 32 bit platform click here. Download "Windows 32-bit - zip file includes the JDK1.6.0_35". 2. For Windows 64 bit and other platforms, click here. NOTE: For Windows 64 bit platforms download "Windows 64-bit - zip file includes the JDK 7". 2. Create a folder called sqldeveloper in the Oracle folder located on c: and then extract the sqldeveloper.zip to that sqldeveloper folder you just created. 3. Within that folder, open the sqldeveloper folder 4. Double-click sqldeveloper.exe to start SQL Developer III. Class Files 1. Download the class files. 2. After downloading the class files, create a directory on your hard drive named "Webucator" that can be found easily. 1. On Windows it is recommended the new folder have a path of C:\Webucator.* 2. Extract the files to the folder you just created. * If you are using XAMPP (e.g, for PHP classes), you must place the Webucator folder on the C:\xampp\htdocs folder. IV. Unlocking the HR Account 1. In SQL Developer, log in using this connection 1. Connection name: system 2. Username: system 3. Password: system (This should be the password you created when you installed Oracle) 2. Open the HR_Unlock_Account.sql file from your class files. 3. Click on the second green play button(F5) to execute the sql query. 4. To continue setup, click on the green + under the Connections tab, and add the criteria below: 1. Connection Name: hr 2. Username: hr 3. Password: hr 4. Click on Connect. A worksheet should open up on a tab that's labeled "hr". 5. Now that you're connected to HR, you're ready to test. 1. Enter the following in the worksheet: select * from regions; 2. Click on the "green arrow" to execute your code. 3. If you get back 2 columns and 4 rows then you are all Java This program can only be taken on a PC. It is compatible with the Windows XP (Service Pack 2) and later operating systems and with the latest versions of any of the following browsers: Mozilla Firefox, Internet Explorer, and Google Chrome. I. Java Development Kit (JDK) Java SE Development Kit (JDK) 8 - Download Note: You do not need to download the bundles that include JavaFC, Java EE, or Netbeans. You only need the JDK that includes the JRE and command-line development tools. After installation, the files will be located on the C drive, usually at C:\Program Files\Java\jdk1x II. Java SE 8..0 API Documentation Download III. Java Runtime Environment (JRE) Java SE Runtime Environment (JRE) 8 Update XX - Download IV. Java Editors / IDEs Windows Option 1: Crimson Editor Note: Crimson Editor is probably the best option unless you have a specific reason for using the Eclipse Integrated Development Environment (IDE) listed below. 1. Go to http://www.crimsoneditor.com. 2. Choose the option for Download from the left-hand navigation menu. 3. Choose the most recent release from one of the download mirrors. 4. Execute the file you just downloaded by double-clicking on it. 1. Read the License Agreement and click on the button labeled I Agree. 2. When asked what components to install, you can leave the default settings. 3. Install Location can be left as default. 4. When the install finishes, click the button labeled Close. Option 2: Eclipse Integrated Development Environment (IDE) Note: Use of the Eclipse integrated development environment is optional for this class at the discretion of the instructor. 1. Go to http://www.eclipse.org/downloads. 2. Choose the option Eclipse IDE for Java Developers. This downloads a zip file. 1. For basic Java classes, we use Eclipse IDE for Java Developers, which does not include Java EE capabilities such as Servlets and JSPs. 2. For Java EE classes, download Eclipse IDE for Java EE Developers. 3. Unzip/Extract the downloaded file to C:\. The installation is a simple unzip to C:\ (Eclipse does not "install" - you run it directly from eclipse.exe, which will be in C:\eclipse after the unzip).

More About Oracle SQL and PL/SQL Developer + Java Programmer

Our SQL class is designed with the beginner in mind. In the SQL portion, you’ll learn how to build applications or generate business reports, master SQL using an Oracle database, and learn PL/SQL extension language to write sophisticated queries against an Oracle database.

The Java programming portion covers most Java syntax elements, concentrating on fundamental and universally useful elements. Early in the course the concept of objects is introduced so that later concepts can be discussed from the perspective of object orientation. You will learn to write useful Java classes, apply object-oriented concepts such as inheritance, and create Java programs that work with these classes.

Oracle SQL and PL/SQL Developer + Java Programmer Frequently Asked Questions
Expand All
Can I register for programs if I am an international student?

Yes, because ed2go programs are online you never have to actually travel to the school. Most schools offer telephone or online registration.

How long does it take to complete a program?

All of our programs are self-paced and open enrollment, so you can start them when you want and finish them at your own pace. When you register, you’ll receive twelve (12) months to complete the program.

What if I don't have enough time to complete my program within the time frame provided?

The time allotted to complete your program has been calculated based on the number of hours for each program, so don't worry too much about not completing in time. If, after a concerted effort, you are still unable to complete, your Student Advisor will help you work out a suitable completion date. Please note that a fee may be charged for an extension.

Do I have to buy additional materials?

No

Can I get financial assistance?

ed2go courses are non-credit courses, so they do not qualify for federal aid. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses. Additionally, some students may qualify for financial assistance when they enroll, if they meet certain requirements.

What happens when I complete the program?

Upon successful completion of the program, you will be awarded a certificate of completion. 

Am I guaranteed a job?

ed2go programs will provide you with the skills you need to obtain an entry-level position in most cases. We don’t provide direct job placement services, but our facilitators and career counselors will help you build your resume and are available to give advice on finding your first job. Facilitators will also be available to use as a professional reference upon completion of the program. Potential students should always do research on the job market in their area before registering.

Who will be my instructor?

Each student is paired with a facilitator for one-on-one interaction. The facilitator will be available (via e-mail) to answer any questions you may have and to provide feedback on your performance. All of our facilitators are successful working professionals in the fields in which they teach.

What software or hardware do I need in order to take online programs and what are the system requirements?

In order to take our online programs, you must have access to a computer and the Internet. You can access the program contents from any Web-enabled computer. You don’t have to use the same computer to log-in to the program every time. We recommend that you have a word-processing program (Microsoft Word is the best) and the latest version of Internet Explorer.

Can I use a Mac?

No

How can I get more information about this program?

If you have questions that are not answered on our website, please feel free to contact us via LIVE chat (click the button above). If you are visiting us during non-business hours, please feel free to send us a question using the “Contact Us” form to the right. You may also call us at 1-877-221-51511-877-221-5151 FREE. We will answer your questions promptly.

When can I start the program?

Our programs are all open enrollment. You can register and start the program as soon as you are ready.

Please note: Once the program curriculum is accessed online or through submission of a material shipment confirmation, refunds cannot be issued.

Does this program prepare for a certification?

This program does not prepare you for a certification but prepares you to enter the job market as an entry-Oracle SQL and/or Java Developer.

What are the technical requirements for this course?

This program can be taken only on a PC. It is compatible with the Windows XP (Service Pack 2) and later operating systems and with the latest versions of any of the following browsers: Mozilla Firefox, Internet Explorer, and Google Chrome. Dual monitors are helpful but not required. You will also need a working email account and a word-processing program—we recommend Microsoft Word.

How do I get the Oracle software and files I need?

You need to have full administrative access to Oracle 10g or 11g. If you do not, you can download the Oracle Database Express Edition for either 32- or 64-bit OS here. You will need to register for a free account to gain access to the download.

You will also need to install Oracle SQL Developer for either Windows 32- or 64-bit platforms. Download "Windows 32-bit - zip file includes the JDK1.6.0_35" here, or download " Windows 64-bit with JDK 8 included" here.

Download the class files here. Create a directory on your hard drive named "Webucator" that can be found easily and extract the files to the folder you just created. If you are using XAMPP (e.g., for PHP classes), you must place the Webucator folder on the C:\xampp\htdocs folder.

Unlock the HR account using the following steps:

  1. In SQL Developer, log in using this connection:
    1. Connection name: system 
    2. Username: system 
    3. Password: system (this should be the password you created when you installed Oracle) 
  2. Open the HR_Unlock_Account.sql file from your class files. 
  3. Click on the second green play button (F5) to execute the SQL query. 
  4. To continue setup, click on the green + under the Connections tab, and add the criteria below: 
    1. Connection Name: hr 
    2. Username: hr 
    3. Password: hr 
    4. Click on Connect, and a worksheet should open up on a tab that's labeled "hr" 
  5. Now that you're connected to HR, you're ready to test. 
    1. Enter the following in the worksheet: select * from regions. 
    2. Click on the green arrow to execute your code. 
    3. If you get back 2 columns and 4 rows, then you are all set.
How do I get the Java software and files I need?

Download the Java SE Development Kit (JDK) 8, Java SE 8.0 API Documentation, and Java SE Runtime Environment (JRE) 8 Update XX here. You do not need to download the bundles that include JavaFC, Java EE, or Netbeans. You only need the JDK that includes the JRE and command-line development tools. After installation, the files will be located on the C drive, usually at C:\Program Files\Java\jdk1x.

Download your Java editors/IDEs for Windows:

Option 1: Crimson Editor is probably the best option unless you have a specific reason for using the Eclipse Integrated Development Environment (IDE) listed below.

  1. Go to http://www.crimsoneditor.com.
  2. Choose the option for Download from the left-hand navigation menu.
  3. Choose the most recent release from one of the download mirrors.
  4. Execute the file you just downloaded by double-clicking on it.
    1. Read the License Agreement and click on the button labeled I Agree.
    2. When asked what components to install, you can leave the default settings.
    3. Install Location can be left as default.
    4. When the install finishes, click the button labeled Close.

Option 2: Eclipse Integrated Development Environment (IDE), which is optional for this class at the discretion of the instructor.

  1. Go to http://www.eclipse.org/downloads.
  2. Choose the option Eclipse IDE for Java Developers. This downloads a zip file.
    1. For basic Java classes, we use Eclipse IDE for Java Developers, which does not include Java EE capabilities such as Servlets and JSPs.
    2. For Java EE classes, download Eclipse IDE for Java EE Developers.
  3. Unzip/Extract the downloaded file to C:\. The installation is a simple unzip to C:\ (Eclipse does not "install"—you run it directly from eclipse.exe, which will be in C:\eclipse after the unzip).
Browse All
Talk to an admissions counselor
Got other questions? Get in touch with our admissions counselors via . During non-business hours, please feel free to send us a question using the "Contact Us" button. You can also reach us by phone at (855) 520-6806.