Oracle SQL and PL/SQL+ Python Developer+Java Programmer
Overview
Approved By LWIA: 7
Last Re-Certification Date: 6/27/2023
Program Description
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.
Requirements:
Hardware Requirements:
5 This course must be taken on a PC. Macs are not compatible.
5 Dual monitors are helpful but not required.
Software Requirements:
5 PC: Windows 7 or later.
5 Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
5 Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS (download and installation instructions are provided in course).
5 Oracle SQL Developer - The client interface for connecting to Oracle (download and installation instructions are provided in course).
5 Anaconda (download and installation instructions are provided in course).
5 Java (download and installation instructions are provided in course).
5 Visual Studio Code (download and installation instructions are provided in course).
5 Adobe Flash Player
5 Adobe Acrobat Reader.
Programs is self-paced. You can start and finish the program at your own pace. Upon registration for the program, you are given 12 months to complete the program.
Established in 2020
CIP: 11-0201 Computer Programming/Programmer, General.
Training Program Type
Vocational
Local Information
| converted from NIU | Y |
Provider Information
Chicago State University
Program Contact Info
9501 S. King Dr.
Chicago, IL 60628
Chicago, IL 60628
(773) 995-4466
Associated Job Families and Occupations
- Computer and Mathematical Occupations
- (151251 )
Certifying / Licensing / Registering Body
Quality Assurance
Education Information
Other
52 Weeks ( 375.00 Hours / 0.00 Credit Hours )
| Tuition | $2,595.00 |
| Total Cost | $2,595.00 |
Financial Aid
Application Procedure
Students that are interested in the course should contact continuinged@csu.edu, or at 773.995.4466 to express interest, and upon WIOA approval, students will be registered for the class. The maximum tuition and fees amount approved for this occupation is $8,000.
Entry Requirements:
- HS Diploma/GED
- Math - High School Level
- Reading - High School Level
- Prerequisites - There are no prerequisites but some prior programming language is helpful
Nondiscrimination, Equal Opportunity, and Disability Provisions Compliance Assurance
- EEO Compliant: Yes
- Disability Accomodation: Yes
Program Offerings
- Online/E-Learning Instruction
Performance Data
Program: Oracle SQL and PL/SQL+ Python Developer+Java Programmer
Overview
Approved By LWIA: 7
Last Re-Certification Date: 6/27/2023
Program Description
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.
Requirements:
Hardware Requirements:
5 This course must be taken on a PC. Macs are not compatible.
5 Dual monitors are helpful but not required.
Software Requirements:
5 PC: Windows 7 or later.
5 Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
5 Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS (download and installation instructions are provided in course).
5 Oracle SQL Developer - The client interface for connecting to Oracle (download and installation instructions are provided in course).
5 Anaconda (download and installation instructions are provided in course).
5 Java (download and installation instructions are provided in course).
5 Visual Studio Code (download and installation instructions are provided in course).
5 Adobe Flash Player
5 Adobe Acrobat Reader.
Programs is self-paced. You can start and finish the program at your own pace. Upon registration for the program, you are given 12 months to complete the program.
Established in 2020
CIP: 11-0201 Computer Programming/Programmer, General.
Local Information
| converted from NIU | Y |
Provider Information
Chicago State University
Program Contact Info
9501 S. King Dr.
Chicago, IL 60628
Chicago, IL 60628
(773) 995-4466
Associated Job Families and Occupations
- Computer and Mathematical Occupations
- (151251 )
Certifying / Licensing / Registering Body
Quality Assurance
Education Information
Other
52 Weeks ( 375.00 Hours / 0.00 Credit Hours )
| Tuition | $2,595.00 |
| Total Cost | $2,595.00 |
Financial Aid
Application Procedure
Students that are interested in the course should contact continuinged@csu.edu, or at 773.995.4466 to express interest, and upon WIOA approval, students will be registered for the class. The maximum tuition and fees amount approved for this occupation is $8,000.
Entry Requirements:
- HS Diploma/GED
- Math - High School Level
- Reading - High School Level
- Prerequisites - There are no prerequisites but some prior programming language is helpful
Nondiscrimination, Equal Opportunity, and Disability Provisions Compliance Assurance
- EEO Compliant: Yes
- Disability Accomodation: Yes
Program Offerings
- Online/E-Learning Instruction