Excel- Dashboards & Business Presentations

Practical Applications of Pivot tables

Learn how people use Excel and Pivot tables in their actual jobs. By the end of all 3 videos in this series you will have a sense of how to apply your knowledge in a real professional setting. This series is a little long (~45 minutes)- so you should grab a snack and some drinks before diving in 😊

SQL- MySQL Introduction

MySQL Installation

After all those days of SQL practicing its finally time to get some real action. Today you will learn how to install a SQL DBMS on your local machine. We are using My SQL because its open source and free. Its the most popular open source DBMS in the world and hence, a great DBMS to learn. The videos will provide you a comprehensive introduction to MySQL along with installation instructions. In your upcoming mini project you will get a chance to work on what you learn today. So even if you find some of this confusing, don't worry at all. You will figure it out when you do it for yourself in the mini project. For now, sit back, relax and watch the videos.

MySQL Installation- Mac OS
MySQL Installation- Windows OS
MySQL- Learn the Basics

Data in Action