Become an Oracle SQL and PL/SQL Developer

The rapid expansion of business, government and social data has created a demand for professionals who can turn a massive amount of information into useful reports and tools. Called business intelligence (BI), this emerging discipline needs experts who use database and reporting tools to provide their audiences with meaningful knowledge. This 100% online course bundle will prepare you to be a BI developer or analyst using the Oracle database management system and the reporting tools from Crystal Reports. Upon successful completion, you will be qualified to enter the market as an entry-level BI analyst or developer.

Job Outlook for Business Intelligence Using Oracle and Crystal Reports

• The US Bureau of Labor Statistics (BLS) expects demand for Management Analysts, including BI professionals, will grow by 11% between now and 2029. This is much faster than the forecast growth rate for all jobs. The BLS expects strong growth in the demand for experts who use information technology to help organizations use their resources efficiently.
• According to PayScale.com, Business Intelligence Analysts earn $69,208 per year, on average. Salaries for early-career analysts range between $50-80,000 per year in the first four years of their careers.

Business Intelligence Analyst and Developer FAQs

WHAT SKILLS DOES A BI ANALYST OR DEVELOPER NEED?

BI Analysts and Developers take an organization’s data, organize it and turn it into reports or tools that their colleagues and the organization’s leaders can use to make decisions. They use tools like the Structured Query Language (SQL) and Oracle’s robust procedural SQL (PL/SQL) to sift and sort data. Then they use presentation tools like Crystal Reports to configure the data into reports that can lead to management action. BI Analysts also have a role in interpreting the data for decision-makers.

WHAT JOB TITLES ARE ASSOCIATED WITH BI ANALYSTS AND DEVELOPERS?

BI specialist jobs usually have titles that reflect their dual role in information technology and business operations. Some common job titles include:

• Database Administrator
• Business Intelligence Engineer
• Business Intelligence Manager
• Data Analyst
• Data Analytics Manager
• Intelligence Analyst
• Intelligence Specialist
• Data Integration Specialist
• Data Manager
• Data Quality Specialist

CAN BI ANALYSTS AND DEVELOPERS WORK REMOTELY?

Because BI Analysts and Developers use digital tools that can be run securely online, BI professionals can work remotely. Especially following the Coronavirus public health crisis, many organizations engage employees, contractors and consultants who work at home or in remote offices. ZipRecruiter.com reports that BI specialists commonly earn between $68-125,000 working remotely.

Course Objectives

This two-course bundle features one course dedicated to Oracle SQL and PL/SQL and one for Crystal Reports.

Course 1: Oracle SQL and PL/SQL Developer

• 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
• 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 from competitors by taking a challenging course in PL/SQL development

Course 2: Crystal Reports

• 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
• You will work with SQL and Crystal Reports to learn the basics through advanced concepts of Crystal Reports.

Prerequisites and Requirements

Course 1: Oracle SQL and PL/SQL Developer

There are no prerequisites for this course; however, some prior programming language knowledge is helpful.

Course 2: Crystal Reports

Hardware Requirements:

• This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
• Crystal Reports (not included in enrollment). A free 30-day trial is available.
• Software is not included in the cost of enrollment. All software must be installed and fully operational before the course begins.

Curriculum

Course 1: Oracle SQL and PL/SQL Developer

1. Oracle SQL and PL/SQL Developer
2. Oracle PL/SQL
3. Oracle SQL Developer Final Project

Course 2: Crystal Reports

1. Introduction to Crystal Reports
2. Intermediate Crystal Reports
3. Introduction to SQL
4. Advanced Crystal Reports

Instructors

Course 1: Oracle SQL and PL/SQL Developer

Nat Dunn

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.

Course 2: Crystal Reports

Tracy Berry

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.

Registration and Enrollment

This course is open enrollment. You can enroll and begin anytime.