Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC

Gentle Introduction to Non Programmers on SQL for Analytics. 1 day Bootcamp Course Begineers Hands-on. Project: New York

4.45 (1716 reviews)
Udemy
platform
English
language
Databases
category
instructor
Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC
37,169
students
1.5 hours
content
Sep 2018
last update
FREE
regular price

What you will learn

This class is an ideal class for learning group by, joins, in built functions. After taking this SQL 101 class you can take other intermediate classes or classes involving functions, procedures and views.

After attending the course, you can expect to run simple group by, joins and filtering on SQL tables.

Since everything is Hands-on the learner can do things right away after learning 312 285 6886

If you are from New York City then you can correlated with my Data which is people attending my classes in New York city (Project for this Course)

Description

SQL 101 Bootcamp is build up based on the SQL classes for Analytics taken in NYC, New York by Shivgan Joshi. Having taught at various bootcamps in NYC and gathering feedback from students this course addresses all the major topics you need to get started for Analytics in SQL  if you have never programmed.


This course will help you answer and critically think and implement:

  1. Create a DB design for your day to day work data that you use in Excel

  2. Understand what you can do and what you cannot do. Or rather how hard or simple it is to do some analytical steps in SQL.

  3. Understand Data Wrangling using Group, Joins and UNION to get data in the format you need

  4. For any data that comes to you new tools get new insights

  5. Get Excel equivalent functions for SQL commands

  6. Understand the data wrangling terms often used in Data Analytics that remain common to all languages (Python / R / SQL)


Other areas that will be introduced to are:

  1. Understand why SQL is needed as a solution to limitation of excel

  2. Connect to the SQL Server database and execute a simple query.

  3. Include a search condition in a simple query.

  4. Use various functions to perform calculations on data.

  5. Organize data obtained from a query before it is displayed on-screen.

  6. Use New York City data for running on SQL

Content

Introduction

Introduction to the Outcomes of the Course
Versions and Flavours of SQL Available
SQL Roles and Job Available

Database Fundamentals and Hands-on

Run SQL Online at Fiddle and other Epheremeral Websites
Creating your First Table
Create Table
Creating Table, adding columns, inputting values and null
Language Basics, Color Coding and Table Structure

Data Analytics in SQL

Video: Filtering & Selection
Filtering and Selection
Video: Group by
Group By
Video: Joins
Joins & Union

Takeaways

SQL vs Excel vs Flat Files
Video: About 10 Practice Commands and Interview Questions
Final Project, Takeaways & Future Work

Reviews

Nametsegang
October 22, 2021
It is a great course for beginners indeed. I got the basics of SQL which then need to be put into practice for full understanding and performance. Is there any other free course which deals with geological or mining data?
Luisa
July 27, 2021
It was fast and with a step by step process. Had to repeat chapters but still a great start! Thank you!
Amrin
April 17, 2021
Course does not explain how to write commands. Copy pasting from pre written commands is of no use to beginners.
Iqbal
March 22, 2021
I wanted even basic information. This course uses of a lot of technicalities before explaining what they are
BlackFaceBaby
January 23, 2021
I'm french and I'm in highscool but I want to learn how to do this even if my english level is not really high
Dennis
January 4, 2021
Sehr gut für jemanden der keine Vorkenntnisse hat. Ich persönliche bevorzuge immer schnell learning by doing, da empfehle nach Möglichkeit mit zweiten Bildschirm alles selber nebenbei zu bearbeiten und ggf. selbst einfach wenig zu kreieren
Richard
October 16, 2020
OK for getting a first glimpse of SQL database, but not great for learning much as a beginner. Very few explanations of coding terminology used.
Miranda
June 16, 2020
For someone who has never used my SQL, the connection from how he goes from one step to the next could be clearer.
Benjamin
June 16, 2020
This was a fantastic course; I wish that I lived in New York so that I could attend the classroom tuition! The interview style questions which are at the end of the course were amazing, I feel that this has put me in a strong position for when I attend future interviews. I also like the useful websites that Shivgan has provided which you are able to use for further research. Thank you kindly for helping me to further my skills in SQL.
Gatram
June 6, 2020
yes definitely i am learned so many new things in mysql and this course is very use full for me to know more about mysql.
Paulo
May 1, 2020
some queries are not familiar to me, it adds additional learning to me. speaker have knowledge in explaining the course
Kevin
April 26, 2020
Great class for a beginner with minimal exposure to SQL. Highly recommend for understanding the fundamentals.
Omar
April 16, 2020
It was very good at the starting but when it comes to joins and group by it seems complicated. Though I have completed those things from youtube videos. Thanks. It was nice learning. I have enjoyed.
Ryan
March 27, 2020
The instructor took his time explaining each section while sharing his screen. This bootcamp was worth my time.
Ibrahima
March 17, 2020
It was a great experience for me. The course is in line with the topic and can help for starters in SQL.

Charts

Price

Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC - Price chart

Rating

Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC - Ratings chart

Enrollment distribution

Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC - Distribution chart

Related Topics

1913512
udemy ID
9/15/2018
course created date
5/16/2019
course indexed date
Bot
course submited by