Oracle SQL and PL/SQL + Python Developer + Java Developer

By mastering Oracle, Java, and Python, you will gain a diverse skill set that is highly sought after in the job market. These technologies complement each other: Oracle enables effective data management, Java powers robust application development, and Python excels in data analysis and automation. Together, they prepare you for a wide range of careers in technology, from database administration and software engineering to data science and beyond. Having expertise in all three technologies not...

SHARE
12 Months / 415 Course Hrs
Open Enrollment
Offered in partnership with your preferred school

Butler Community College

Change School
Learning method

for additional information

Oracle SQL and PL/SQL + Python Developer + Java Developer

Enroll Now

Course code: GES3125

What 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 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
  • Develop in-demand skills in Java, one of the most widely used programming languages for application development
  • Fully prepare to pass the Oracle Certified Professional: Java SE 17 Developer (1Z0-829) exam and Java SE 21 Developer 1Z0-830 exam

How the course is taught

  • Self-paced, online course
  • 12 Months to complete
  • Open enrollment, begin anytime
  • 415 course hours
  1. Oracle SQL and PL/SQL Developer
    1. Oracle SQL
    2. Oracle PL/SQL
    3. Oracle SQL Developer Final Project
  2. Java Developer
    1. Java Introduction
    2. Java Basics
    3. Java Objects
    4. Comparisons and Flow Control Structures
    5. Arrays
    6. Inheritance
    7. Interfaces
    8. Exceptions
    9. Collections
    10. Inner Classes
    11. Streams
    12. Advanced Topics
  3. Python Developer
    1. Introduction to Python
    2. Advanced Python
    3. Python Data Analysis with NumPy and pandas

Stephen Withrow

Stephen Withrow brings over four decades of experience in training, development, and consulting across a broad spectrum of technologies, including Python, Java, Web Development, Oracle, C, and C++. His extensive background includes the design and implementation of business-critical solutions on client/server, web, and enterprise platforms. He holds a degree in Computer Science and Physics from Florida State University.

Stephen has provided training for a wide array of organizations, including the Department of Defense, Home Depot, CVS, Bank of New York, Merrill Lynch, IBM, and UPS, delivering high-impact instruction to professionals at every level of technical proficiency.

As a trainer, Stephen is widely recognized for his deep subject matter expertise, engaging teaching style, and ability to translate complex technical topics into clear, practical instruction. Students consistently describe him as patient, approachable, and incredibly knowledgeable, often calling him the best technical instructor they've ever had. He is praised for his real-world examples, kindness, and attentiveness to students’ needs.

Stephen creates a positive, encouraging learning environment where participation is welcomed and questions are thoroughly addressed. His ability to adapt to varying experience levels while maintaining a structured and effective course flow sets him apart. Whether teaching beginning HTML or advanced Oracle development, Stephen equips students with the skills, confidence, and insights to apply their knowledge immediately in the workplace.

Prerequisites:

There are no prerequisites to take this course, however some prior programming language knowledge is helpful.

Certification Requirements:

A combination of Java training and hands-on experience (attained via labs and/or field experience) in the learning subscription provides the best preparation for passing the exam.

Requirements:

Hardware Requirements:

  • This course must be taken on a PC.
  • Dual monitors are helpful but not required.

Software Requirements:

  • PC: Windows 10 or later (not the Home Edition).
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS (download and installation instructions are provided in course). Please view the required specs ahead of time to make sure that your system is compatible.
  • Oracle SQL Developer - The client interface for connecting to Oracle (download and installation instructions are provided in course).
  • Anaconda (download and installation instructions are provided in course).
  • Java (download and installation instructions are provided in course).
  • Visual Studio Code (download and installation instructions are provided in course).

Other:

  • Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Yes. This course prepares you for the Java SE 17 Developer (1Z0-829) exam and Java SE 21 Developer (1Z0-830) exam. This course prepares you to enter the job market as an entry-level Java Developer and/or Python Developer. (exam not included)

After you register, you will receive 12 months to complete the course. The time allotted for completion has been calculated based on the number of course hours.

This course is open enrollment, so you can register and start the course whenever you are ready. Access to your course can take 24-48 business hours.

The time allotted for course completion has been calculated based on the number of course hours. However, if you are unable to complete the course, contact the student advising team to see what options you may have available to work out a suitable completion date. Please note that an extension fee may be charged.

Our courses are designed to accommodate various learning preferences. Depending on the course structure, you may get different forms of support. Self-paced courses are designed to be user-friendly and independent, minimizing the need for external support. In courses with instructors, our direct platform support feature includes opportunities for questions, discussions, and remediation, with email and phone support available for select courses. Our student advising team is available to guide you on program requirements and administrative requests, but they do not provide assistance with course content. Our goal is to provide you with the necessary support for success, whether it's through self-paced exploration, direct communication, or guidance from our advising team.

Upon successfully passing the final exam, you will be awarded a certificate of completion from the school or organization that you registered through.

ed2go courses will help you gain the skills you need to obtain an entry-level position in most cases. However, you should always research the job market in your area before enrolling.

ed2go courses are non-credit, so they do not qualify for federal aid, FAFSA, and Pell Grant. In some states, vocational rehab or workforce development boards may provide funding to take our courses. Additionally, you may qualify for financial assistance if you meet certain requirements. Learn more about financial assistance.

If you have questions that are not answered on our website, representatives are available via LIVE chat. You can also call us at 1-877-221-5151 during regular business hours to have your questions promptly answered. If you are visiting us during non-business hours, please send us a question using the "Contact Us."

Certified Java Developer (Voucher Included)Advanced Career TrainingJava Developer + Python DeveloperAdvanced Career TrainingPython DeveloperAdvanced Career Training
Advanced Career Training
Certified Java Developer (Voucher Included)
Advanced Career Training
Java Developer + Python Developer
Advanced Career Training
Python Developer