Sign In   |   View Cart   |     |   Help
 
Print Course information
E-mail to a friend
Return to Course Catalog

Course Catalog > Career Certifications > Computer Science > - Database Management

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.

What you will learn

  • To build applications or generate business reports using Structured Query Language (SQL)
  • To master SQL using an Oracle database
  • To use PL/SQL extension language to write sophisticated queries against an Oracle database
  • How Python works and what it's good for
  • To understand Python's place in the world of programming languages

How you will benefit

  • Prepare for an entry-level job as a Python programmer and/or Oracle SQL developer
  • Enhance your programming ability and add a new skill to your resume
  • Become more confident in your ability to use the Python programming language
  • Set yourself apart from competitors by taking a challenging course in PL/SQL development

Requirements:

Hardware Requirements:

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

Software Requirements:

  • PC: Windows 8 or newer.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
  • Software must be installed and fully operational before the course begins.

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.


Whether you're new to programming or just want to learn a new language, this in-depth online course will teach you the ins and outs of Oracle SQL and programming in Python. You will start coding quickly while learning from readings, presentations, exercises, and a final project. By course completion, you will have the skills you need to enter the job market as an entry-level Oracle programmer or Python programmer.


Oracle SQL
I. Relational Database Basics
II. Creating Tables
III. Basic Selects
IV. Oracle SQL Functions
V. Aggregate Functions
VI. Joins
VII. Subqueries
VIII. Set Operators
IX. Conditional Processing with CASE
X. Data Manipulation Language
XI. Creating Views
Oracle PL/SQL
I. PL/SQL Basics
II. Subprograms
III. Conditional Processing
IV. Cursors
V. Packages
VI. Triggers
Introduction to Python
I. Python Basics
II. Functions and Modules
III. Math
IV. Python Strings
V. Iterables: Sequences, Dictionaries, and Sets
VI. Virtual Environments, Packages, and pip
VII. Flow Control
VIII. Exception Handling
IX. Python Dates and Times
X. File Processing
XI. PEP8 and Pylint
Advanced Python
I. Advanced Python Concepts
II. Regular Expressions
III. Working with Data
IV. Testing and Debugging
V. Classes and Objects
Python Data Analysis with NumPy and pandas
I. JupyterLab
II. NumPy
III. pandas



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.

 

Oracle SQL and PL/SQL + Python Developer
Item: 202003CTP22930  
Class Dates: 7/1/2020 - 9/30/2020                                              Fee: $1,795.00
This is an on-demand Career Training Program Course offered by Ed2Go.  Class begins upon registration and completion of Student Enrollment Agreement in Ed2Go. Click on Course Title for complete course description.
 

UCM is smoke and tobacco free. Thank you for your cooperation.