Featured

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



Published
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-Tutorials-/tree/main/SQL%20Tutorial%20for%20Data%20Scientist%202022

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:
https://twitter.com/pitsillides91
https://www.instagram.com/ypexists/?hl=en
https://www.pinterest.co.uk/pitsillides91/boards/
https://www.facebook.com/groups/1500092413449073/
Category
Management
Be the first to comment