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.
Completion Time
220 hours
Access Time
365 Days
Outcome
Certificate Program
Language
English
Training Level
Beginner
Delivery Information:
Online
Asynchronous
Self-paced
Description
Learning Outcomes
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
- 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
Requirements
Technology Requirements
Hardware Requirements: This course can be taken on either a PC, Mac, or Chromebook.
Software Requirements: Software must be installed and fully operational before the course begins.
- PC: Windows 8 or later.
- Mac: macOS 10.6 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible. Cookies and JavaScript must be enabled
- The latest Adobe Reader/Acrobat Reader ( free download available at https://get.adobe.com/reader/ )
- Any modern Office suite: Microsoft Office, Apple iWork, OpenOffice, or LibreOffice
- Reliable internet connection. Broadband cable or highspeed DSL is recommended for optimal experience.
- E-mail account (to be able to register and to receive e-mail from the course system regarding registration, course status, etc.)
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.
Enroll My Team
Are you looking to enroll your team in this training Course? You Can: