The Ultimate SQL & Tableau Course: From Zero to Hero

Having SQL Skills and learn one of employer's most requested skills of 2023! Learning SQL is one of the fastest ways to improve your career prospects.

This is the most comprehensive, yet straight-forward, course for the SQL language on Skillshare!

In this course, I transferred my experience from over a decade of real-world Big Data projects to one Skillshare course.

I designed this course to take you from Zero to Hero of SQL, so if you are a beginner, don't worry, I will explain everything from scratch step by step. You are not too old or too young, and SQL is super easy to learn.

Each SQL Topic in this course will be explained in 3 steps:

• The concept (Theory)

• Learn SQL Syntax using simple Tasks.

• Learn How SQL Processes the Query behind the scene.

SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today!

You will have exercises during the videos where I present a task and we solve it together. By the end of each section, you will have as well tons of exercises and solutions.

I will provide you with numerous materials:

• SQL Course Curriculum (Roadmap) and we will progress it in each lecture.

• SQL Cheat Sheet, so you don't have to memorize all SQL syntaxes and you can use it later during development to have quick access.

• SQL Database and Data for Training, so you can practice with me.

• SQL Presentations and Concepts, all collected in one place to have it as a reference for you.

Topics covered in this course :

• SQL Basics: Intro, Why SQL, Database Concepts, Table concepts, SQL Commands, SQL Elements

• Download & Install MySQL

• Install Database

• SQL Coding Style

• SELECT statement

• DISTINCT

• ORDER BY

• Filtering Data: Where

• Comparison Operators: =, >, <, >=, <=, !=

• Logical Operators: AND, OR, NOT

• BETWEEN, IN, LIKE

• JOINS: Inner, Left, Right, Full

• UNION & UNION ALL

• Aggregate Functions: MAX, MIN, AVG, COUNT, SUM

• String Functions: CONCAT, LOWER, UPPER, TRIM, LENGTH, SUBSTRING

• Advanced SQL Topics

• GROUP BY

• HAVING

• Subquery: EXISTS & IN

• Modifying Data: INSERT, UPDATE, DELETE

• Defining Data: CREATE, ALTER, DROP

For your reference:

https://www.datawithbaraa.com/sql-introduction/

-----Update----

For downloading MySQL they only removed "developer" option. You need to select "Full" option and everything should be fine.

----------------------------------------------------------- TABLEAU COURSE ------------------------------------------------------

Welcome to Tableau Ultimate Course: Zero to Hero!

Having Tableau Skills and learn one of employer's most requested skills of 2024! Learning Tableau is one of the fastest ways to improve your career prospects.

Tableau is a powerful data visualization and business intelligence (BI) software tool used for analyzing and presenting data in a visually engaging and interactive way. It allows you to connect to various data sources, transform raw data into meaningful insights, and create interactive dashboards, reports, and charts that help you make data-driven decisions.

This is the most comprehensive, yet straight-forward, course for Tableau on Skillshare!

In this course, I transferred my experience from over a decade of real-world Data Visualization projects to 21 Hour-High Quality Udemy course.

I designed this course to take you from Zero to Hero of Tableau, so if you are a beginner, don't worry, I will explain everything from scratch step by step. You are not too old or too young, and Tableau is super easy to learn.

What Makes This Course Stand Out?

1. This is the only course on Udemy that breaks down the complex concepts of Tableau into animated visuals. In this course you will be presented with over 250x animated visuals.

2. What special about this course it is taught by me, I'm not just another online instructor, i am working in big companies in Germany like Mercedes Benz where I'm leading BI & Big Data projects. That means you are getting real life skills out of this course.

3. You will master over 63 Tableau Charts, equipping you to visualize any data and meet various requirements. You'll gain the expertise to choose the right chart for specific requirements and understand when to utilize each type of chart effectively.

4. We'll deep dive into 60x Tableau Functions that will help you to manipulate your data for visualization. You will first understand the concept and how tableau works then we will learn the functions using very simple examples.

I will provide you with materials:

• 3x Different Training Data Sets

• 3x Cheat Sheets: Concepts, Calculations and Charts. So you quick access to all what you need about Tableau.

• Access to All Tableau Files that is created during the course.

• All Course Sketchnotes are available to be used as reference later.

15 Sections that are Covered in this course :

• Tableau Basics

• Tableau Products Suite

• Tableau Architecture

• Prepare Your Training Environment

• Data Modeling | Combining Data

• Tableau Metadata

• Renaming & Aliases

• Organizing data

• Filtering & Sorting Data

• Parameters | Dynamic Views

• Tableau Actions

• Tableau Calculations

• Tableau Charts

• Tableau Dashboard

• Tableau Project

-------------------------------------------