SQL Tutorial for Data Scientist and Data Analyst - Download the data and START CODING!!!

Опубликовано: 20 Февраль 2025
на канале: Yiannis Pitsillides

4,277

159

Skip all the nonsense. Download SQL and start practicing. It’s the only way to learn. Step by step tutorial for beginners in SQL. Set your SQL Environment up, learn how to create a database, how to import data in the database, how to interact with the database, how to run queries in the database, how to manipulate the data and many more!!!!

Data Analytics Course Link:
http://ipidata.teachable.com/

Download the raw data:
https://github.com/Pitsillides91/SQL-...

Part 1:
   • SQL Tutorial for Data Scientist and D...
Part 2:
   • How to Learn SQL as a Beginner – Spec...
Part 3:
   • SQL JOINS with Examples - LEFT, INNER...

Table of contents:
• Download and Install SQL Server for free
• Download and Install SQL Server Management Studio for Free
• Create a new database
• Learn the shortcut keys
• Learn the data types
• Insert Data into the new database – Data is provided in Github
• Master the SELECT Query
• Master the WHERE CLAUSE query
• Learn (=, more / less, IN, NOT IN, LIKE, AND, OR, More, Less, BETWEEN)
• Learn how to have multiple conditions
• Learn Subqueries using 2 or more tables

Yiannis Pitsillides on Social Media:
  / pitsillides91
https://www.instagram.com/ypexists/?h...
https://www.pinterest.co.uk/pitsillid...
  / 1500092413449073

EXCEL:
Excel top 5 Interview Questions:    • Top 5  Excel Interview Questions for ...
Excel top 7 Most Used Formulas:    • Top 7 Most-Used Excel Formulas for Da...
Excel Interview Test – Junior:    • Excel Test for Job Interview 2025  - ...
Excel Interview Test – Intermediate:    • Data Analyst Excel Test Example for I...
Excel Interview Test – Difficult:    • EXCEL Interview Test Questions and An...
Excel Interview Test – Average Part 1:    • Data Analyst EXCEL Interview Test Exa...
Excel Interview Test – Average Part 2:    • Excel Test for Job Interview - Downlo...

SQL:
SQL Tutorial from scratch part 1:    • SQL Tutorial for Data Scientist and D...
SQL Tutorial from scratch part 2:    • How to Learn SQL as a Beginner – Spec...
SQL Tutorial JOINs:    • SQL JOINS with Examples - LEFT, INNER...
SQL Top 5 Interview Questions:    • Top 5 SQL Interview Questions & Answe...
SQL Interview Test – Beginner:    • Data Analyst SQL Test Example for Int...
SQL Interview Test – Junior:    • Easy SQL Test example for Data Analys...
SQL Interview Test – Intermediate:    • SQL Test for Data Analyst Job Intervi...
SQL Interview Test – Difficult:    • SQL Test Example for Interviews | Que...

PYTHON:
Python Tutorial from Scratch Part 1 –    • How to learn Python? – Specific for D...
Python Tutorial from Scratch Part 2 -    • Complete PYTHON Tutorial for Data Sci...
Python Tutorial from Scratch Part 3 JOINS -    • How to Merge DataFrames in Python? Th...
Python Tutorial from Scratch Part 4 Visuals -    • How to create Data Visualizations in ...
Python Tutorial from Scratch Part 5 Visuals -    • Complete Seaborn Tutorial on Python –...
Python top 5 Interview Questions:    • Python Interview Test Questions and A...
Python Interview Test – Beginner:    • Python Interview Test for Data Analys...
Python Interview Test – Junior:    • Junior Data Analyst Python Coding Tes...
Python Interview Test – Intermediate:    • Python Interview Test Example for Dat...
Python Interview Test – Difficult:    • Python Interview Test Example for Dat...