Training Programs Computer Science Oracle SQL and PL/SQL + Python Developer

Oracle SQL and PL/SQL + Python Developer

This in-depth course will teach you how to use SQL to build applications and helps you master SQL using an Oracle database. You will also build a foundational understanding of programming in Python.

oracle-plus-python
$1,895.00 (USD)

Have a question?We're here to help
  • Overview
  • Objective
  • Syllabus
  • Requirements
  • Prerequisites
  • Instructor
  • FAQs
  • ENROLL NOW

    phone  Call Us:

    855.520.6806

Overview

Objective

Syllabus

  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 NumPy and pandas
    1. JupyterLab
    2. NumPy
    3. pandas

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

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
California State University - San Marcos

Extended Learning Department
333 S. Twin Oaks Valley Road
San Marcos, CA 92096 US
MAIN CONTENT

Copyright © 1997 - 2025 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