Gentle Introduction to Non Programmers on SQL for Analytics. 1 day Bootcamp Course Begineers Hands-on. Project: New York
Free tutorial
4.4
Created by Shivgan Joshi
English
English [Auto]
What you’ll 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)
Requirements
- The bootcamp is for begineers and non-programmers
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:
- Create a DB design for your day to day work data that you use in Excel
- 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.
- Understand Data Wrangling using Group, Joins and UNION to get data in the format you need
- For any data that comes to you new tools get new insights
- Get Excel equivalent functions for SQL commands
- 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:
- Understand why SQL is needed as a solution to limitation of excel
- Connect to the SQL Server database and execute a simple query.
- Include a search condition in a simple query.
- Use various functions to perform calculations on data.
- Organize data obtained from a query before it is displayed on-screen.
- Use New York City data for running on SQL
Who this course is for:
- The courses teaches MYSQL using online platforms and explains querying and creating tables. Introduces with querying logic and explains group by and joins in SQL. The class is completely hands on and assumes no prior knowledge.
Show less
Course content
4 sections • 17 lectures • 1h 17m total lengthCollapse all sections
Introduction3 lectures • 10min
- Introduction to the Outcomes of the Course02:02
- Versions and Flavours of SQL Available05:01
- SQL Roles and Job Available03:05
Database Fundamentals and Hands-on5 lectures • 29min
- Run SQL Online at Fiddle and other Epheremeral Websites04:43
- Creating your First Table12:24
- Create Table00:30
- Creating Table, adding columns, inputting values and null04:49
- Language Basics, Color Coding and Table Structure06:30
Data Analytics in SQL6 lectures • 36min
- Video: Filtering & Selection17:48
- Filtering and Selection00:24
- Video: Group by10:20
- Group By00:20
- Video: Joins07:01
- Joins & Union00:17
Takeaways3 lectures • 2min
- SQL vs Excel vs Flat Files00:30
- Video: About 10 Practice Commands and Interview Questions01:47
- Final Project, Takeaways & Future Work00:11
