Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC

  • 4.2
  • (1,652+ reviews)

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

Course Info

Created by Shivgan Joshi
1 hour on-demand video
18 lectures
33,859+ students enrolled
4.2 rating from 1,652+ reviews
English language
Created on September 15, 2018
Category: Development

Ad

Frequently Asked Questions

  • How long is a coupon valid?

    Coupons are issued by instructors to promote their courses, gain traction and reach momentum. The instructor can choose to emit discounted (ex: $11.99 coupon) or 100% off coupon (you pay nothing). Each coupon becomes expired when emitted quota is over (1000 enrollments) OR expiration date has been reach (5 days).

  • What is this "1000 enrollments" from Udemy?
  • Could you please help me to find a coupon for this course?
  • What is exactly your relationship with Udemy?

© INFOGNU - 2024