Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC – Free Udemy Courses
Gentle Introduction to Non-Programmers on SQL for Analytics. 1-day Bootcamp Course Beginners Hands-on. Project: New York
What you’ll learn
Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC – Free Udemy Courses
- This class is an ideal class for flearning groupspsp by, joins, and inbuilt functions. After taking this SQL 101 class you can take other intermediate classes or classes involving functions, procedures,s, and views.
- After attending the course, you can expect to run simple group by, join,s, 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 be correlated with my Data which is people attending my classes in New YorkCityy (Project for this Course)
Requirements
-
The Bootcamp is for beginners and non-programmers
Description
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 groups, Joins, and unions 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 the limitations 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 course teaches MYSQL using online platforms and explains querying and creating tables. Introduces querying logic and explains group by and joins in SQL. The class is completely hands-on and assumes no prior knowledge.
Add Comment