Oracle SQL and PL/SQL Developer with Crystal Reports

As the business world becomes more reliant on technology, so has the need for business intelligence (BI) developers. Today's BI developer must know how to design and generate reports from large data sources. This online course will equip you with a complex skill set needed to work in business intelligence. You will learn how to create reports with Crystal Reports and how to use Oracle's procedural programming language PL/SQL to write sophisticated queries against an Oracle database. By course completion, you will be able to enter the job market as an entry-level BI developer or analyst.

SHARE
12 Months / 220 Course Hrs
Open Enrollment
Offered in partnership with your preferred school

Association of Executive and Administrative Professionals

Change School
Learning method
for additional information

Oracle SQL and PL/SQL Developer with Crystal Reports

Enroll Now

Course code: GES3015

What you will learn

  • To work with reports and custom SQL statements
  • To connect to a data source
  • To select subsets of data and perform analysis
  • To format reports and share with others
  • Build applications or generate business reports using Structured Query Language (SQL)
  • Master SQL using an Oracle database
  • Use PL/SQL extension language to write sophisticated queries against an Oracle database

How you will benefit

  • 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

How the course is taught

  • Self-paced, online course
  • 12 Months to complete
  • Open enrollment, begin anytime
  • 220 course hours
  1. Crystal Reports
    1. Introduction to Crystal Reports
      1. Getting Acquainted with Crystal Reports
      2. Formatting Reports
      3. Working with Objects
      4. Filtering Reports
      5. Sorting and Grouping Reports
      6. Using Basic Formulas
      7. Advanced Formatting
      8. Exporting and Distribution
    2. Intermediate Crystal Reports
      1. Crystal Reports Review
      2. Using Parameters
      3. Using Subreports
      4. Charts
      5. Cross-Tabulation Reports
      6. Advanced Techniques
      7. Report Alerts
    3. Introduction to SQL
      1. Relational Database Basics
      2. Simple SELECTs
      3. Advanced SELECTs
      4. Subqueries, Joins, and Unions
    4. Advanced Crystal Reports
      1. Crystal Reports Review
      2. Working with SQL
      3. Advanced Functions
      4. Geographic Mapping
    5. Oracle SQL and PL/SQL Developer
      1. Oracle SQL
      2. Relational Database Basics
      3. Creating Tables
      4. Basic Selects
      5. Oracle SQL Functions
      6. Aggregate Functions
      7. Joins
      8. Subqueries
      9. Set Operators
      10. Conditional Processing with CASE
      11. Data Manipulation Language
      12. Creating Views
    6. Oracle PL/SQL
      1. PL/SQL Basics
      2. Subprograms
      3. Conditional Processing
      4. Exceptions
      5. Cursors
      6. Packages
      7. Triggers
    7. Oracle SQL Developer Final Project

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

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.

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.

Requirements:

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.

Yes, ed2go courses are completely online. However, keep in mind that not all certifying bodies or industry-specific certifications are recognized internationally. Please review your country's regulations prior to enrolling in courses that prepare for certification.

No.

This course is open enrollment, so you can register and start the course whenever you are ready. Access to your course can take 24-48 business hours.

After you register, you will receive 12 months to complete the course. The time allotted for completion has been calculated based on the number of course hours.

If you are unable to complete the course, contact your Student Advisor to help you work out a suitable completion date. Please note that an extension fee will be charged. If you are funded through a third-party organization, approval may also be required.

The course instructor will be available by email to answer any questions you may have and to provide feedback on your performance. Occasionally, your course may be supported by a team of industry experts. You will also be assigned a Student Advisor for academic support.

Upon successfully passing the final exam, you will be awarded a certificate of completion from the school or organization that you registered through.

ed2go courses will help you gain the skills you need to obtain an entry-level position in most cases. However, you should always research the job market in your area before enrolling.

ed2go courses are non-credit, so they do not qualify for federal aid, FAFSA, and Pell Grant. In some states, vocational rehab or workforce development boards may provide funding to take our courses. Additionally, you may qualify for financial assistance if you meet certain requirements. To learn more about financial assistance..

If you have questions that are not answered on our website, representatives are available via LIVE chat. You can also call us at 1-877-221-5151 during regular business hours to have your questions promptly answered. If you are visiting us during non-business hours, please send us a question using the "Contact Us."