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

This combined online course is the perfect way to master Oracle programming. You'll work with SQL, PL/SQL, Java, and Python programming as you learn to write advanced queries and generate business reports.

Requirements:

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.
• 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).
• Python (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).
• Adobe Acrobat Reader.

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.

This course will teach you how to use SQL to build applications and generate business reports, master SQL using an Oracle database, and learn PL/SQL extension language to write sophisticated queries against an Oracle database. You will also learn to write useful Java classes, applying Object-Oriented concepts such as inheritance, and create Java programs that work with these classes. The introductory section will show you how Python works and what it's good for. You will also gain an understanding of Python's place in the wider programming world.

You will begin coding quickly after starting the course. Afterwards, you'll move on to advanced methods in which you'll learn how to work with iPhone Notebook, the Collections Module, regular expressions, databases, CSV files, JSON, and XML. You will also learn advanced sorting, how to write object-oriented code in Python, and how to test and debug their Python code. In the last section, you get a rapid introduction to NumPy, pandas, and matplotlib, which are Python libraries. This course will prepare you for entry into the job market as a Java or Python programmer or an entry-level Oracle SQL Developer or allow you to take on more responsibility using new skills gained in a current job.

1. Oracle SQL
   1. Relational Database Basics
   2. Creating Tables
   3. Basic Selects
   4. Oracle SQL Functions
   5. Aggregate Functions
   6. Joins
   7. Subqueries
   8. Set Operators
   9. Conditional Processing with CASE
   10. Data Manipulation Language
   11. Creating Views
2. Oracle PL/SQL
   1. PL/SQL Basics
   2. Subprograms
   3. Conditional Processing
   4. Cursors
   5. Packages
   6. Triggers
3. Introduction to Python
   1. Python Basics
   2. Functions and Modules
   3. Math
   4. Python Strings
   5. Iterables: Sequences, Dictionaries, and Sets
   6. Virtual Environments, Packages, and pip
   7. Flow Control
   8. Exception Handling
   9. Python Dates and Times
   10. File Processing
   11. PEP8 and Pylint
4. Advanced Python
   1. Advanced Python Concepts
   2. Regular Expressions
   3. Working with Data
   4. Testing and Debugging
   5. Classes and Objects
5. Python Data Analysis with JupyterLab
   1. JupyterLab
   2. NumPy
   3. pandas
6. Java Programmer
   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

What you will learn

• Learn SQL to build applications or generate business reports
• Master SQL using an Oracle database
• Learn PL/SQL extension language to write sophisticated queries against an Oracle database
• Understand most Java syntax elements, concentrating on fundamental and universally useful elements, while providing an overview of many more advanced elements

How you will benefit

• Prepare yourself for entry into the job market as a Java or Python programmer, or an entry-level Oracle SQL Developer
• Become a master of Oracle SQL development with Java and Python programming and list your skills on your resume
• Advance your programming skills regardless if you're new to the industry or a seasoned programmer

Nat Dunn

Nat Dunn founded Webucator in 2003 to combine his passion for technical training with his business expertise and to help companies benefit from both. His previous experience was in sales, business and technical training, and management. Nat has an MBA from Harvard Business School and a BA in International Relations from Pomona College.