SQL and Power BI for Beginners

12 hours of lecture, 5 hours of course work per week

Demand for data analysts have grown tremendously in the last year. This course will get you equipped with the knowledge you need to analyze and visualize data from a database. This course starts with SQL concepts, where you will gain an in-depth understanding of the core functions in SQL. You will learn creating databases, to the most frequently used queries, to advanced filtering, functions and stored procedures. You will also learn Power BI, a powerful cloud-based tool where you will learn to visualize and bring insights to your data.

Kal Academy Module

Module 1 : Introduction to Core SQL Concepts

In the first module, we will get you started with the basic understanding of SQL and databases in the cloud.

1 hour.

Kal Academy Module

Module 2-3 : Understanding DDL and DML Statements

In the next 3 modules, you will learn to explore and create data in the database using DDL and DML statements.

2 hours. 

Kal Academy Module

Module 4-6 : Table Joins

In the next 2 modules, you will learn to retrieve, filter and aggregate data across multiple tables using different types of join statements.

3 hours.

Kal Academy Module

Module 7-9 : Functions and procedures

In the next 3 modules, you will learn to write window functions, views, and stored procedures to explore data.

3 hours. 

Kal Academy Module

Module 10-12 : Visualization with Power BI

In the last 3 modules you will learn to build visualizations for in-depth data insights with Power BI. You will also learn to write DAX queries for Power BI.

3 hours. 

Career Path

Kal Academy PowerBI

This course

This course will get you introduced to basic querying and visualization against database data.

Kal Academy AI

Data Science

At this point you can take the next step to data analysis through our Data Science for Beginners course and see what Machine Learning is all about.

Kal Academy AI

Bootcamp

You can then take your data science career ahead by taking our Artificial Intelligence Bootcamp which will get you ready for an entry level data engineer role in 4 months.

Kal Academy Apply

Apply for jobs

Get your resume out the door by applying for jobs on recruiting sites, LinkedIn and others. We will also share your resume with our partners to find the best match.

I am an experienced engineering professisonal and Kal Academy helped me get back to the tech world after a break. I took the big data class and it is a big picture overview type class for anyone curious about data engineering and big data technologies. She totally understands that different students have different goals in the class room ranging from curiosity to immediate job needs and helps accordingly. While I landed a job in backend which was always my specialty, I am thankful for the resume and career consulting help Kal Academy provides that helps network  with companies. I highly recommend Kal Academy to anyone who needs help at any level breaking into or furthering their interests in the tech world.To me personally, the biggest takeaway was getting in touch and getting updated with tech and broadening my exposure. I found Kal easy to engage with in class and very proficient in what she does.

Jay S.

Software Engineer

Great experience at Kal Academy. When I first started taking classes at Kal, I came with the intention to learn about Big Data. Big Data seemed to be a trending topic at tech companies & I was curious to learn about this area. Right after taking a Data Science class, I soon realized that I could do so much more so I decided to pursue the AI/Software Engineering full deep stack program. I am incredibly thankful to Kal for the education I gained. While the programs are fast paced, I learned more than I could imagine, and after several months of searching for a role in the tech industry, I was finally able to get hired by a top tech company. Whether you are interested in any of the programs solely for the purpose of learning or transitioning into the current tech market for a job, I highly recommend considering the opportunities Kal has to offer. As someone that worked full time, this was a tremendous opportunity I could not miss. 

Rosemary D.

Software Engineer

Ready to get started?

Get in touch, or apply now!