Discover Classes. Earn Rewards.
Introduction to SQL and Data Analysis is unfortunately unavailable

Thankfully we have 53 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.

Introduction to SQL and Data Analysis

at Practical Programming - Chelsea

(362)
Course Details
Price:
$399
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Chelsea, Manhattan
115 W 30th St 5th Fl Ste 501
Btwn 6th & 7th Avenues
New York, New York 10001
(Map)
Share:
Purchase Options
Save to WishList

283 people saved this class

Book a private group event
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!

What to expect from this course

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

What you will learn

  • What databases are and why they are important
  • The different “flavors” of databases.
  • Statistical functions in SQL
  • The four operations you can perform on data
  • The fundamental parts of a SQL query
  • Analytical queries: GROUP BY
  • Subqueries and Joins

Things To Remember

  • Please bring your own laptop to class.
  • We will help you to install all the programs you need in class.
  • If you withdraw one day before the course start date, any deposit paid will be refunded in full.
  • If you cannot attend classes for which you were charged, you could join next cohort and make up the missed classes.

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 (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

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 3990 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 (362)

(362 Reviews)
Introduction to SQL and Data Analysis
Reviewed by Anonymous on 11/21/2019
Matt’s material was thorough and he took the time to make sure everyone was fully grasping the material
Introduction to SQL and Data Analysis
Reviewed by Ping Feng on 11/21/2019
Awesome class! The instructor is very patient and helping you debug all kinds of problems and answering all kinds of questions.
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.
loading...
loading...

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.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

53 Top Choices

Beginner SQL

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Beginner SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. Learn to use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database in our beginner SQL training class. Our SQL courses are taught in our state-of-the-art...

Monday Dec 16th, 5:50pm - 9:20pm

  (2 sessions)
$325

2 sessions

Intermediate SQL

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Intermediate SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep,...

Thursday Dec 19th, 9am - 5pm

Advanced SQL

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Advanced SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep, and...

Sunday Dec 15th, 9:30am - 5:30pm

SQL Bootcamp: Learning the Language

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. Takeaways Understand...

Friday Dec 13th, 10am - 5pm

SQL Programming

at Hands On Technical Training - Chelsea (Exact location to be announced), New York, New York 00000

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  This SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended...

Monday Jan 6th, 9am - 5pm

  (3 sessions)
$1,795

3 sessions

SQL Training For Beginners

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

Do you keep hearing the word ‘SQL’ buzzing around and want to find out more about it? This 3 hour workshop will provide an introduction to fundamental concepts in relational databases and using the query language SQL.  Participants will learn to how to work with data that is stored in a relational database. By the end of the workshop, you...

Tuesday Dec 17th, 6:30pm - 9:30pm

Analyzing Data with Power BI

at Learning Tree International - Midtown 1601 Broadway 9th Fl, New York, New York 10019

This  course provides a comprehensive understanding of how to analyze data with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. Plus, this course will prepare you for Microsoft exam 70-778, a core requirement for the MCSA: BI Reporting certification. You Will Learn How To: Perform...

Wednesday Dec 11th, 9am - 4:30pm

  (3 sessions)
$2,650

3 sessions

SQL Bootcamp Series

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence and begin to unleash...

Monday Dec 16th, 10am - 5pm

  (2 sessions)
$479

2 sessions

Developing SQL Databases

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database. Audience Profile The primary audience for this course is IT Professionals who want to...

Monday Dec 16th, 10am - 6pm

  (5 sessions)
$2,975

5 sessions

Introduction to SQL Programming Training

at Learning Tree International - Midtown 1601 Broadway 9th Fl, New York, New York 10019

The ability to write the SQL language — the cornerstone of all relational database operations — is essential for anyone who develops database applications. The SQL Language is an ANSI/ISO standard language used by all relational database products. In this training course, you learn how to optimize the accessibility and maintenance of data with...

Wednesday Dec 18th, 9am - 4:30pm

  (3 sessions)
$1,950

3 sessions

Microsoft Transact-SQL Programming

at Hands On Technical Training - Chelsea (Exact location to be announced), New York, New York 00000

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft SQL Server environment. Topics covered include relational database architecture, database design techniques, and simple...

Monday Jan 6th, 9am - 5pm

  (5 sessions)
$2,795

5 sessions

SQL Querying: Basic

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses. This course is taught using Microsoft SQL Server, but...

Thursday Jan 2nd, 10am - 5pm

  (2 sessions)
$990

2 sessions

Intermediate SQL Bootcamp

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

Enabling analysts to broaden their SQL skills to retrieve and manipulate data from multiple sources into timely, cohesive, informative analysis. Takeaways We will be going over the following: JOIN and UNION with Aliasing Primary and Foreign Keys Aggregation and Functions Complex JOINs with multiple tables NULL values and related SQL functions...

Sunday Dec 22nd, 10am - 4pm

SQL Querying: Advanced

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries. This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle...

Monday Jan 6th, 10am - 5pm

Databases and SQL Queries with Oracle

at Baruch College - CAPS - Murray Hill 10010

Learn the Structured Query Language, the industry-standard syntax for interacting with relational databases, using Oracle, the industry-leading database software.  This course will cover database diagramming, design, and creation, entity relationship (ER) modeling, querying, data warehousing, reporting, and more. This one course introduces you...

Tuesday Jan 28th, 6:15pm - 8:45pm

  (10 sessions)
$675

10 sessions

Database Management with Microsoft SQL Server

at Baruch College - CAPS - Murray Hill 10010

Learn Transact-SQL, database design, diagramming, and creation, and backup and recovery, all on enterprise quality software within the Windows environment. As the most fully featured Relational Database Management System offered by Microsoft, SQL Server provides an excellent platform on which to learn querying and basic administration. Note: Classroom...

Saturday Feb 1st, 9:30am - 2pm

  (6 sessions)
$625

6 sessions

Microsoft SQL Server 2017 Administration

at Hands On Technical Training - Chelsea (Exact location to be announced), New York, New York 00000

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure. You will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2017. You will also...

Monday Jan 6th, 9am - 5pm

  (5 sessions)
$2,795

5 sessions

Intermediate SQL for Data Analysis

at Borough of Manhattan Community College - Financial District 25 Broadway, 8th Floor, New York, New York 10004

Expand your database knowledge to learn more advance techniques to manage and query data. A greater understanding of the SQL language will enable you to read or create more than the most basic queries. This series discusses the concept of SQL Queries from Basics to Advanced techniques. By taking this course students will also be prepared for the Microsoft...

Wednesday Jan 22nd, 6pm - 9pm

  (10 sessions)
$814

10 sessions

Microsoft SQL Server 2016 Administration

at Hands On Technical Training - Chelsea (Exact location to be announced), New York, New York 00000

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  This five-day instructor-led course provides students who administer and maintain SQL Server 2016 databases with the knowledge and skills to administer a SQL Server database infrastructure. The primary audience for this course is individuals who...

Monday Jan 6th, 9am - 5pm

  (5 sessions)
$2,795

5 sessions

Microsoft SQL Server 2014 Administration

at Hands On Technical Training - Chelsea (Exact location to be announced), New York, New York 00000

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2014 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server...

Monday Jan 6th, 9am - 5pm

  (5 sessions)
$2,795

5 sessions

Loading...