Training Programs Programming Oracle SQL and PL/SQL + Python Developer + Java Programmer
cart-icn

You already have a course in your cart

You can only add one course to your cart at a time! By adding this course, you will replace the existing course from your cart. How would you like to proceed?

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.

sql-developer
$2,595.00 (USD)

Have a question?We're here to help

Overview

Objective

Outline

  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

Requirements

Prerequisites

You've got questions.
We're here to help.

Our highly knowledgeable Enrollment Specialists will answer any questions you might have about the course and payment options.

REQUEST INFO

Instructor

FAQs

Reviews

You've got questions.
We're here to help.

Our highly knowledgeable Enrollment Specialists will answer any questions you might have about the course and payment options.

REQUEST INFO
Purchase College, SUNY

735 Anderson Hill Road
Purchase, NY 10577 US
MAIN CONTENT

Copyright © 1997 - 2024 All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from Cengage Learning. Privacy Policy