What you’ll learn

  • Get a job as a junior Data Analytics developer
  • Use Azure Data Studio to perform data analysis
  • Learn to perform GROUP BY statements
  • Complete Visualization Charts with SandDance extension
  • Filter data using the WHERE clause to identify required data
  • Using JOINS, return data from multiple tables in the same query
  • learn what is Generative AI for future learning
  • Learn how to boost productivity and save time using AI-driven platforms
  • Advanced SQL statements with Aggregate functions
  • Be comfortable putting SQL and Microsoft SQL on their resume
  • Replicate real-world situations and query reports
  • Complete basic SELECT statements querying against a single table
  • Apply SQL for DataScience and Business intelligence
  • Complete Analysis statements that use aggregate functions
  • Performing Secure Backup and Restore Full SQL Database
  • Participate in Coding Exercise to test your learning skills

Course Content

Getting Started

Introduction ▶ Preview
How to get course requirements ▶ Preview
Getting started on Windows, Linux or Docker ▶ Preview
How to ask great questions ▶ Preview
FAQ’s ▶ Preview

SQL Server setting up

Section Introduction 🔒
Microsoft SQL Server Installation 🔒
SQL Server Management Studio (SSMS) Installation ▶ Preview
How to connect MS SQL (Windows Authentication) ▶ Preview
How to connect MS SQL (SQL Server Authentication) 🔒
How to connect MS SQL (SQL Server Authentication) 🔒
Download and Restore Sample Database 🔒

SQL Azure Data Studio

What is Azure Data Studio 🔒
Azure Data Studio Installation steps ▶ Preview
Azure Data Studio to Connect SQL Server 🔒
Create a Database ▶ Preview
Create a Table 🔒
Insert Data rows 🔒
View the Data returned by Query 🔒

SQL Database basic SSMS

Section Introduction 🔒
Overview of Databases 🔒
Creating Database 🔒
SQL Data Types 🔒
Column Data Types on SSMS 🔒
Creating Table 🔒
Overview of Primary Key and Foreign Key 🔒
Primary Key 🔒
Foreign Key 🔒
Creating Temporary tables 🔒

SQL Statements for DATA

Section Introduction 🔒
Insert statement 🔒
Update statement 🔒
Delete statement 🔒

SQL Data Structure statements

Section Introduction 🔒
CREATE table statement 🔒
DROP statement 🔒
ALTER statement 🔒
TRUNCATE statement 🔒
COMMENT in query 🔒
RENAME 🔒

SQL User Management

Create Database user 🔒
GRANT permissions 🔒
GRANT permissions 🔒
REVOKE permissions 🔒

SQL Statement Basic

Section Introduction 🔒
SQL Statement basic 🔒
SELECT Statement 🔒
SELECT DISTINCT 🔒
SELECT with column headings 🔒
Column AS statement 🔒

Filtering Data rows

SELECT WHERE Clause – theory 🔒
SELECT WHERE Clause – practical 🔒

Aggregate functions

Sum() 🔒
Min()-Max() 🔒

SQL Query statements

Order By statement 🔒
SELECT TOP clause in SQL 🔒
BETWEEN command 🔒
IN operator 🔒
Wildcard Characters and LIKE 🔒

SQL Group by statement

Section Introduction 🔒
Group by – theory 🔒
Group by – practical 🔒
HAVING statement 🔒

JOINS for Multiple table Data Analysis

Overview of Joins 🔒
What are Joins 🔒
Inner join 🔒
Left outer join 🔒
Right outer join 🔒
Full outer join 🔒
Union 🔒
Cross join 🔒
Query Exercise 🔒
Solution for Query Exercise 🔒

SQL Constraints

Section introduction 🔒
Check constraint 🔒
NOT NULL constraint 🔒
UNIQUE constraint 🔒

Views

Creating Views 🔒
Reporting with multiple tables 🔒

Advanced SQL commands

Section Introduction 🔒
Timestamp 🔒
Extract from timestamp 🔒
Mathematical scalar functions 🔒
String functions 🔒
Sub Query 🔒
SELECT with calculations 🔒

SQL Stored procedures

Create stored procedure 🔒
Stored procedure with parameter 🔒

Azure Data Studio Visualization

Installing SandDance Extension 🔒
Visualization Charts 🔒
Multiple Table Data Charts 🔒

Azure Studio SQL for Data Analysis

Type Decision for Data Analysis 🔒
Data Analysis with Case Statement and String Text 🔒

Import & Export data

Section Introduction 🔒
Import Flat File 🔒
Import .csv or excel file 🔒
Export Data to Excel or any format 🔒

Backup and Restore Database

Section Introduction 🔒
Creating Database backup 🔒
Restoring Database backup 🔒

Requirements

  • No prior technical experience is required! All you need a computer!
  • No SQL experience needed. You will learn everything you need to know
  • No software is required in advance of the course (all software used in the course is free)

Description

The "SQL for Data Science + Data Analytics + Data Visualization" course is designed to equip you with the skills needed to excel in data-driven decision-making. This comprehensive course takes you from the basics of SQL to advanced techniques for data analytics and data visualization, making it perfect for anyone looking to build a career in data science or data analytics.


You’ll start with the foundational concepts of SQL, learning how to create and manipulate databases, tables, and relationships. Master the core SQL commands such as SELECT, INSERT, UPDATE, and DELETE, and learn to perform complex queries using JOINs, GROUP BY, and HAVING for effective data analysis.


As you advance, you’ll explore how to perform detailed data analysis using SQL, including filtering, sorting, and aggregating data to derive meaningful insights. Learn how to work with large datasets, identify trends, and extract valuable business intelligence.

update: Learn the top AI tools every professional needs to boost productivity


The course also covers data visualization, showing you how to present your findings in clear, visually compelling ways. with the help of this course you’ll easily learn how to use popular visualization tools like Power BI and Tableau, and integrate them with SQL queries to create interactive, insightful dashboards.


By the end of this course, you’ll have the skills to work with real-world data, analyze it using SQL, and present your findings through stunning visualizations. Whether you're pursuing a career in data science, business intelligence, or data analytics, this course will provide you with the expertise needed to succeed in the industry.


Enroll today to master SQL, data analysis, and visualization techniques!

Who this course is for

  • Beginner SQL, Data Analytics, Data Science and Visualization - developers curious about SQL Career
  • Anyone who wants to start Career in Data Engineering
  • Anyone who works with data analytics, charts, or databases!
  • Anyone who wants to become financially independent
  • Anyone who wants to start their own business or become freelance
  • Anyone who wants to become a Data Science developer
  • If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information Someone who wants to learn skills that give them the potential to earn near SIX figures!

Recommended Courses

Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint
₹799
Master in Python Language Quickly Using the ChatGPT Open AI
₹499
Mastering Python Object-Oriented Programming: Generative AI
₹519
Mastering C++ Fundamentals with Generative AI: A Hands-On
₹596
₹999
₹10,000 90% off

This course includes:

  • 🎥 5+ hours on-demand video
  • 📱 Access on mobile and desktop
  • ♾ Full lifetime access
  • 🧠 Practical sessions
  • 📜 Certificate of completion