Discover Classes. Earn Rewards.

Introduction to SQL and Data Analysis

at Practical Programming - Chelsea

(342)
Course Details
Price:
$149 11 seats left
Start Date:

Wed, Sep 18, 6:00pm - 9:00pm

Location:
Chelsea, Manhattan
115 W 30th St 5th Fl Ste 501
Btwn 6th & 7th Avenues
New York, New York 10001
(Map)
Share:
Purchase Options
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 15

What you'll learn in this sql training:

This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work. 

We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples. 

Also, this workshop will teach you advanced concepts of databases as well as how to write effective SQL queries you can use in your everyday work.  Going over the major topics a data scientist should know when working with databases. As well as all parts of the CRUD functions of data. 

The course will be highly interactive and engaging - questions are encouraged!


Who this program is for:
This workshop is for beginners. We will start with basic examples and gradually move toward more complex SQL queries. By the end of this course, you’ll know how to write SQL and work with databases to solve business problems and produce management reports.


You will learn:
  • What databases are and why they are important
  • The different “flavors” of databases
  • Connecting to your work’s database
  • The four operations you can perform on data
  • The fundamental parts of a SQL query
  • Analytical queries: GROUP BY
  • Subqueries and Joins
  • Statistical functions in SQL
  • String and regular expressions
  • Working with dates and intervals
  • Window functions, and ranking

Prerequisites & Preparation,
Laptop (any laptop with a browser)

Still have questions? Ask the community.

Refund Policy
If you withdraw two days before the course start date, any deposit paid will be refunded in full. 

No refunds will be given for cancellations made after that date. If you cannot attend our class or workshop, for which you were charged, you will receive 25% discount for any other course.

Map

Google Map

Practical Programming

All classes at this location

Start Dates (1)
Start Date Time Teacher # Sessions Price
6:00pm - 9:00pm Matthew Sedaghatfar 1 $149

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 1490 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (7)

Get quick answers from CourseHorse and past students.

Question from O
Does anyone know how the topics are broken out over each of the three sessions?
Answer from Anonymous
Hi, The first session will cover an introduction to SQL, how to write basic queries. The second session has more advanced SQL, such as examples of window and string functions, and a portion on CRUD, to create and update a new table. The third session is putting what we learned in the first two sessions together for a capstone project on creating a Dashboard and putting together an exploratory analysis.
Answer
Cancel
Question from jinnatun j.
Do I need to download the MSSQL in my laptop before I come to the class?
Answer from Matthew S. Verified Student
You can download it before the class starts
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi Jinnatun! No, when you register for the class the school will email you instructions.
Show all 2 answers
Answer
Cancel
Question from dolores o.
Start Date states the course runs from 6 - 9 PM. Important Information section states class begins at 6:30 and ends 8:00 pm. which is it?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi Dolores! Sorry for the confusion. It should be 6pm - 9pm. We will update the class description as soon as possible. Thank you for catching that error.
Answer from dolores o.
Thank you.
Show all 2 answers
Answer
Cancel
Question from anonymous
Do you need to bring your own computer to this class or are computers provided at the location?
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi there! You can bring your own laptop. The school does not provide computers.
Answer
Cancel
Question from May S.
Hi, for this Intro to SQL class, I have ZERO knowledge of SQL or even what its about. Is that okay to take this class in my case?
Answer from Billy C. CourseHorse StaffCourseHorse Staff
Hello, Yes, it is all right to take this class despite having zero knowledge about the course. This class is specifically tailored for beginners such as yourself and it will start with basic examples and gradually move toward more complex SQL queries.
Answer
Cancel
Question from Anonymous
Hi! May I ask if there’s a certification after the session?
Answer from Jenn C. CourseHorse StaffCourseHorse Staff
Hi! Yes, the school issues certificates - electronic certificate is free and a paper certificate is $10 each upon completion of the course.
Answer
Cancel
Question from Irene
Hello, will you need to download any programs or plug ins during this class? (I ask bc I can’t install anything on my work laptop without a password only our IT person has). Thanks! :-)
Answer from Chermalyn P. CourseHorse StaffCourseHorse Staff
Hi, Irene! As long as you have Google Chrome, you'll be fine.
Answer
Cancel
View all 7 questions

Reviews of Classes at Practical Programming (342)

(342 Reviews)
Introduction to SQL and Data Analysis
Reviewed by Erline R. on 8/16/2019
These weren’t the days. It had gotten rescheduled a couple of times. I’ve taken only one session and I loved it . I instructor was very knowledgeable and he was good at teaching . I’m looking forward to the next two classes.
Introduction to SQL and Data Analysis
Reviewed by Anonymous on 6/6/2019
It got the job done but the instructor could have delivered the material better. Often times he started going very deep into a top without explaining it first so the whole class was confused. Then we would have to back track and go over what exactly he was talking about. It was almost like he forgot we were taking this class because we had never used SQL before.
Introduction to SQL and Data Analysis
Reviewed by Matthew S. on 9/24/2018
The class was very hands on and useful in real life scenarios. Gave the basic tool to implement SQL on your personal computer and the basics to use it in a work scenario. Tommy was great at keeping the class engaged and also made the class fun.
Introduction to SQL and Data Analysis
Reviewed by Anonymous on 9/7/2018
The projector didn't work. The teacher was a competent programmer, but not an expert in SQL, the teacher would google answers to our questions. He Most of the class could have been completed without the professor using an online class. We didn't get very far content wise. The class basically consisted of a short presentation and then the students doing practice problems using a free internet resource.
Introduction to SQL and Data Analysis
Reviewed by Vera C. on 6/26/2018
I liked the instructor of this class. He was very patient and helpful. The pace of the class was good too. Not too fast and not too slow. You needed to have had some experience with SQL prior to taking the class to get the most out of it.
loading...
loading...
Similar Classes

School: Practical Programming

Practical Programming

Practical programming classes and workshops for everyone who wants to learn how to code from scratch or practice Python. You will learn how to start using Python, problem solving with algorithms and make dynamic web applications.

No coding experience needed, anyone who would like to learn how to code...

Read more about Practical Programming

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Ready to take this class?
BOOK NOW
Booking this class for a group? Find great private group events here
Loading...