Course Offerings

If you work with large amounts of business data and need to create reports, then you need to know how to use SQL. This comprehensive online course will use SQL to write queries against Crystal Reports and how to write queries with SQL/PL against an Oracle database.

Course Objectives

You will gain the skills to successfully and confidently work with Crystal Reports software.


You will work with SQL and Crystal Reports to learn the basics through advanced concepts of Crystal Reports.


Turn your passion for working with data into a profession by learning to write SQL queries.


Prepare to enter the job market as an entry-level Oracle SQL Developer or to take on more responsibility in your current role.


Set yourself apart in the job market by gaining a broad skill set that includes different BI specialties.

Outline of instruction

Introduction to Crystal Reports

Intermediate Crystal Reports

Introduction to SQL

Advanced Crystal Reports

Oracle SQL and PL/SQL Developer

Oracle PL/SQL

Oracle SQL Developer Final Project

Contact Hours

220

CEUs

No

Industry Standard, State or National Certification

None

CE or CU Articulation

No

Prerequisites

This course is designed for anyone with an interest in database concepts. Prior to enrolling, you should have basic computer skills, an understanding of data management, and a working knowledge of analysis programs such as Microsoft Access and Microsoft Excel.

Text and Supplies Needed

Hardware Requirements:
This course can be taken on either a PC or Mac.

Software Requirements:
Windows 10 or later (not the Home Edition). See required specs of the operating system.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Crystal Reports (not included in enrollment). To download and install the free 30 day trial.
Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS (download and installation instructions are provided in course).
Oracle SQL Developer - The client interface for connecting to Oracle (download and installation instructions are provided in course).
Adobe 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.

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance

Accreditation/Special Approval Requirements

N/A

Intended Audience

This course is designed for anyone with an interest in database concepts.

Specific Industry or Business Support Needs

N/A

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to training Outcomes for Employment

Related Courses

Course Contact Information

Courtney Boney
919-532-5581
[email protected]