SQL 101 Course NYC

About the course:
You might be wondering why is it that in the age of Artificial Intelligence and Machine Learning, there is so much hype about SQL. That is because all those cool sounding careers still use SQL on a day to day basis. Here at BAINYC, we start with an entirely hands-on course and assuming no prior knowledge on your part to introducing pretty much all the complex problems that you can solve using SQL.

Takeaways:
* A Basic understanding of SQL.
* Run simple group by, joins functions, and filtering on SQL tables.
* Learn MYSQL using online platforms and explain querying and creating charts.
* Introduces with querying logic and illustrates group by and joins in SQL.
* Learn about SQL Analytics and SQL Server.
* Top 10 frequently asked SQL interview questions along with solutions and example is provided.
* 15 SQL queries that we run in the class for future reference.
* All the resources for future references.

Prerequisite and Prep:
* Basic Excel.
* Bring your laptop.

Resources:
Class PPT: https://docs.google.com/presentation/d/1iXpK0tiPiPWS2KiRfT7BgShtQwK-ppAzY7nY23NmV9Y/edit?usp=sharing

Quiz: https://docs.google.com/document/d/12q8sc4KAsMZEZdl4GqBAcaCaxMFeJsNU3CNcQia5p7A/edit?usp=sharing

Free Udemy Course created by Instructor: https://www.udemy.com/sql-analytics-coding-101-bootcamp-begineers-course-hand-on/

Instructor:
Shivgan Joshi
Masum Rumi

P.S. Please reserve your place beforehand by emailing at info@bainyc.com.

 

More details:

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.

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.  Also learn about SQL Analytics and SQL Server.

Top 10 frequently asked SQL interview questions along with solutions and example is provided.

You will be also provided the 15 SQL queries that we run in the class for future reference.

The user also gets the code and slides for future references.

Intro to different versions of SQL

Part A: Create your tables and input values
Part B: Select based on different filtering
Part C: Group by, Union and Joins
Part D: String functions

Expert instructor with courses on Udemy and extensive teaching experience.

Note: You should come on time. Please bring a laptop and notebook for writing down notes.

 

SQL 101 Begineers Class Course Bootcamp New York

Please do my SQL Udemy free course before coming and bring your questions: https://www.udemy.com/sql-analytics-coding-101-bootcamp-begineers-course-hand-on/