The Ultimate SQL & Tableau Course: From Zero to Hero

Aperçu

The Ultimate SQL & Tableau Course:

From Zero to Hero

Acquire essential SQL skills and master one of the most sought-after abilities by employers in 2023. Enhancing your career prospects has never been faster than by learning SQL.

This is the most comprehensive and straightforward course for learning the SQL language on Skillshare.

Drawing from over a decade of experience in Big Data projects, this course is designed to elevate your SQL proficiency from beginner to expert. No prior experience is required, as the course explains everything step by step.

SQL is simple to learn, regardless of age.

Topics are structured in three phases:

• The Concept:

  Theoretical understanding

• SQL Syntax:

  Hands-on tasks

• Query Processing:

  In-depth insight into SQL query execution

SQL is highly in-demand for business analysts and data scientists working with data. Enhance your resume and skill set by joining today!

This course includes exercises for practical learning, with tasks solved collectively, and ample resources:

• SQL Course Curriculum:

  Detailed roadmap

• SQL Cheat Sheet:

  Quick syntax reference

• SQL Database and Data:

  Training materials

• SQL Presentations:

  Comprehensive reference materials

Course Topics Include:

• SQL Basics:

  Introduction, Database and Table Concepts, Commands, Elements

• MySQL Installation
• SQL Coding Guidelines
• Key SQL Statements:

  SELECT, DISTINCT, ORDER BY

• Data Filtering:

  WHERE, Comparison and Logical Operators

• SQL Operations:

  BETWEEN, IN, LIKE, JOINS, UNION

• Aggregate Functions:

  MAX, MIN, AVG, COUNT, SUM

• String Functions and Advanced Topics:

  CONCAT, UPPER, SUBSTRING, GROUP BY, HAVING

• Subqueries:

  EXISTS, IN

• Data Modification:

  INSERT, UPDATE, DELETE

• Data Definition:

  CREATE, ALTER, DROP

For further reference, visit:

SQL Introduction

Tableau Course:

Zero to Hero

Embrace one of the most sought-after skills for 2024 by mastering Tableau, a top-notch data visualization and BI tool.

Enhance your career by learning to transform data into insights and build interactive dashboards.

This course stands out for its comprehensive and straightforward approach, breaking down Tableau's complexity into over 250 animated visuals. Led by an experienced BI professional with real-world skills, this course ensures you gain expertise in choosing and applying the correct charts and functions.

Course Benefits:

1. Unique animated visuals for clearer understanding
2. Instructor with direct experience in leading Big Data projects
3. Master over 63 different Tableau charts
4. Explore 60 advanced Tableau functions with simple examples

Course Materials Provided:

• Three different training data sets
• Three comprehensive cheat sheets on concepts, calculations, and charts
• Access to all Tableau files developed during the course
• Course sketchnotes for reference

Key Sections Covered:

• Tableau Basics and Product Suite
• Tableau Architecture
• Data Preparation and Modeling
• Metadata Management, Renaming, and Aliases
• Data Organization, Filtering, and Sorting
• Creating Dynamic Views with Parameters
• Tableau Actions and Calculations
• Developing Charts and Dashboards
• Comprehensive Tableau Project

Matières