Online Course – Certified Professional Internship in BI Fundamentals with SQL, ETL, and Data Warehousing from Google, IBM

Prepare yourself for your first career in business intelligence (BI). Gain the skills you need to get started in business intelligence in just two months. No degree or prior experience required.

Suggested by: Coursera (What is Coursera?)

Start your Coursera.com free trial today

קורס אונליין - התמחות מקצועית מוסמכת ביסודות BI עם SQL

Professional Certificate

Beginners

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

Basic SQL with an emphasis on queries from relational databases.
Using basic Linux commands to create scripts.
Building and automating ETL, ELT, and data pipelines.
Working with data lakes and data warehouses.
Create interactive reports and dashboards.
Writing SQL queries and creating connections using PostgreSQL, MySQL, and DB2 databases.
Running commands and links in Linux, creating shell scripts.
Scheduling jobs using cron, building ETL and data pipelines.
Designing data warehouses using star and snowflake schemas.
Data quality verification, loading staging and production warehouses.
Development of cubes, rollups, and views/tables is implemented.
Analyze warehouse data using BI tools like Cognos Analytics.

What you will learn in the course

Courses for which the course is suitable

Business Intelligence (BI) Analyst
ETL key
Data Analyst
Interactive report developer
Data Warehouse Manager
SQL Expert
Linux script developer
BI Solutions Planner
Data Project Manager
Data Quality Analyst

Internship – 5-course course series

The job market for business intelligence (BI) analysts is expected to grow by 23 percent between 2021 and 2031 (US Bureau of Labor Statistics). IBM’s specialization provides you with the required skills that employers are looking for when hiring BI analysts.

BI analysts collect, filter, and analyze key business data to find patterns and insights to help make business decisions.

What you will learn during the internship:

Basic SQL with an emphasis on queries from relational databases.
Using basic Linux commands to create scripts.
Building and automating ETL, ELT, and data pipelines.
Working with data lakes and data warehouses.
Create interactive reports and dashboards.

Plus, you’ll gain hands-on experience working with real professional tools. Each course includes extensive labs and project work, which will give you something to talk about in interviews.

When you complete the full program, you will have a shareable portfolio of projects and any internship certifications for your resume and LinkedIn profile.

Hands-on Learning Project

Through hands-on labs and course projects conducted in cloud-based environments, you will gain work-ready experience with the following tools and tasks:

Writing SQL queries and creating connections using PostgreSQL, MySQL, and DB2 databases.
Running commands and links in Linux, creating shell scripts.
Scheduling jobs using cron, building ETL and data pipelines.
Designing data warehouses using star and snowflake schemas.
Data quality verification, loading staging and production warehouses.
Development of cubes, rollups, and views/tables is implemented.
Create interactive reports and dashboards.
Analyze warehouse data using BI tools like Cognos Analytics.

Start a sought-after role in business intelligence. Sign up today.

Details of the courses that make up the specialization

A practical introduction to Linux commands and shell scripting

Course 1

14 hours
4.6 (1,253 ratings)

What you’ll learn:
- Describe the architecture of Linux and common Linux distributions, update and install software on a Linux system.
- Execute information, file, content, navigation, compression, and network commands in the Bash shell.
- Open scripts in the shell language using Linux commands, environment variables, pipes, and filters.
- Schedule cron jobs in Linux with crontab and explain cron syntax.
Skills you will acquire:
- Shell script
- Bash (Unix Shell)
- Extraction, Transformation, and Loading (ETL)
- Linux
- Linux commands

Course 2

20 hours
4.7 (20,098 ratings)

What you’ll learn:
- Analyzing data within a database using SQL and Python.
- Creating a relational database and working with multiple tables using DDL commands.
- Building basic to intermediate level SQL queries using DML commands.
- Build more powerful queries with advanced SQL techniques like Views, Transactions, Stored Procedures, and Joins.
Skills you will acquire:
- Extraction, Transformation, and Loading (ETL)
- Data Engineer
- Apache Kafka
- Apache Airflow
- Data pipes

Course 3

17 hours
4.5 (335 ratings)

What you’ll learn:
- Describe and compare ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes.
- Explain the Batch vs. Concurrent execution modes.
- Implement the ETL workflow using Bash and Python functions.
- Describe the data pipeline components, processes, tools, and technologies.
Skills you will acquire:
- Python programming
- Cloud databases
- Relational Database Management System (RDBMS)
- SQL
- Jupyter notebooks

Course 4

15 hours
4.4 (173 ratings)

What you’ll learn:
- Job-ready data warehouse skills in 6 weeks, backed by hands-on experience and IBM certification.
- Design and populate a data warehouse, model and query data using CUBE, ROLLUP and Materialized Views.
- Identify popular tools and vendors for data analysis and business intelligence and create data visualizations using IBM Cognos Analytics.
- How to design and load data into a data warehouse, write aggregation queries, create hardware query tables, and create a dashboard for analysis.
Skills you will acquire:
- Business intelligence
- Data visualization
- IBM Cognos Analytics
- Google Looker Studio
- Dashboards

Course 5

11 hours