Learning Outcomes: Data helps us make decisions in everyday life and in business. In this first part of the course, you’ll learn how data analysts use data analytics and the tools of their trade to inform those decisions.
Learning Outcomes: In this part of the course, you’ll learn to Create Joins, Use Primary and Foreign Keys, Integrate Aliases, Evaluate Various Join Types, and Integrate Filters with Joins.
Learning Outcomes: The combination of JOINs and Aggregations is one of the reasons SQL is such a powerful tool. In this lesson, we will deal with NULL values, and also create aggregations in our SQL queries including COUNT, SUM, MIN & MAX etc.
Learning Outcomes: In this part of the course, we will cover subqueries, a fundamental advanced SQL topic. The lesson will focus on Creating subqueries to solve real-world problems, differentiating between Subqueries and Joins, considering the tradeoffs to using subqueries, and implementing the best subquery Strategy.
Learning Outcomes: In this part of the course, you’ll learn how to clean and re-structure messy data, convert columns to different data types, manipulate NULLs with some handy tricks.
Browse our popular courses.
Students will be introduced to UI/UX design, design workspace setup, Typography and color theory and create a rapid UI/UX prototype using Figma software tool.
Students will learn Python programming using Visual Studio Code or Pycharm. Operators and Expressions, Selection control structure in python, List, Tuple, Dictionary, Number and string etc.
Students will be able to design a functional website after learning web design concepts including HTML and CSS coding for front end and back end web development and test hosting server will be provided.
Equip your child with 100% Hands-On CODING & STEM skills. Over 5,000 parents are happy with us.
Supercharge your TECH CAREER. Learn from the Professionals. Click the button below to register for a tech course.