Gentle Introduction to Non Programmers on SQL for Analytics. 1 day Bootcamp Course Begineers Hands-on. Project: New York
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
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
3 Lectures
5 Lectures
6 Lectures
Executive Training / Workforce Development ServicesPython SQL 101 Class Bootcamp Big Data Sciene Data Analytics Tutor NYC, New York 929 356 5046 Learn Python in NYC!Shivgan Joshi is an expert tutor based out of NYC, New York NY. Developed various passive course for bootcamps in Data Analytics, took classes at USA (New York) and India. Training theme centered around projects,...
well explained
Good course for beginners.
I am new to SQL and beginning to use it in my new job. This course so far is helping in understanding the different versions of SQL and the different sites available to use open source.
It was a good choice for me, thank´s a lot to give me the chance to do it!!!
very nice, well explained and timed.
it's close. I am looking for plsql specific courses
i enjoy it and easy to understant
Could be more detailed with explanations of acronyms
Good structure, great quick start into SQL and relational databes.
Your email address will not be published. Required fields are marked *
Samson T. S.
So far so good.