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.
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.
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.
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.
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.
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.
Cost of the Program
(Non-Refundable)- Classes are offered online only
- Attend class anywhere, anyplace
- Class recordings will be provided
- Small cohort size for one-on-one attention
- TA support
- Certificate of completion
Career Path
This course
This course will get you introduced to basic querying and visualization against database data.
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.
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.
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.
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.
Ready to get started?
Get in touch, or apply now!