Introduction to SQL and Data Analytics (Online) is unfortunately unavailable

Thankfully we have 147 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 Analytics (Online)

at Practical Programming - Online

(378)
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.

Purchase Options
Save to WishList

301 people saved this class

Book Private Class
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 15

Flexible Reschedule Policy: This provider has flexible, free rescheduling for any-in person workshop. Please see the cancellation policy for more details

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.


Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

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.
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 Oliver B.
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 (378)

(378 Reviews)
Introduction to SQL and Data Analytics (Online)
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 Analytics (Online)
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 Analytics (Online)
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 Analytics (Online)
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 Analytics (Online)
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

147 Top Choices

Intermediate SQL Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

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...

Saturday Oct 3rd, 11am - 5pm Eastern Time

SQL Bootcamp Remote (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online, Online, California 00000

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy. SQL provides...

Tuesday Oct 6th, 8am - 2pm Pacific Time

SQL Bootcamp Remote

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Houston, Texas 00000

Imagine that you have a spreadsheet containing every data point about your customers -- their preferences, their web browsing behavior, the products they've bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy. SQL provides...

Tuesday Oct 6th, 10am - 4pm Central Time

Writing SQL Queries

This class is temporarily being offered remotely.

at Out of Bounds Technology - Virtual Classroom

SQL is the cornerstone of all relational database operations. In this hands-on course, you’ll learn how to employ the full potential of the SELECT statement to write robust queries using the best query method for your application. Course Overview SQL is the cornerstone of all relational database operations. In this hands-on course, you’ll learn...

Monday Sep 28th, 10am - 6pm Eastern Time

  (3 sessions)
$1,595

3 sessions

Querying Data with Transact-SQL

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

The main purpose of this 5-day, instructor-led course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database...

Monday Sep 28th, 10am - 4:45pm Eastern Time

  (5 sessions)
$2,795

5 sessions

Querying with Transact-SQL Essentials

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

The main purpose of this 3 day instructor led course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers...

Monday Sep 28th, 10am - 4:45pm Eastern Time

  (3 sessions)
$1,975

3 sessions

Database Management with Microsoft SQL Server

This class is temporarily being offered remotely.

at Baruch College - CAPS - Online 00000

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 Sep 26th, 9am - 1:30pm Eastern Time

  (5 sessions)
$625

5 sessions

Next Level SQL Programming

This class is temporarily being offered remotely.

at Out of Bounds Technology - Virtual Learning

This course explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work is ANSI SQL compliant and should work with SQL databases such as Oracle, SQL Server, mySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Course Overview A company’s success hinges on responsible...

Thursday Oct 1st, 7am - 3pm Pacific Time

  (2 sessions)
$1,495

2 sessions

Querying Data with Transact-SQL

This class is temporarily being offered remotely.

at Corporate Training Group - Virtual Classroom

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761. Audience profile: The main purpose of the course...

Monday Oct 5th, 8:30am - 4:30pm Eastern Time

  (5 sessions)
$3,095

5 sessions

Intermediate SQL Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, San Francisco, California 00000

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...

Saturday Oct 3rd, 8am - 2pm Pacific Time

SQL Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online GA Washington D.C. (Remote Online), Washington, District of Columbia 00000

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy. SQL provides...

Tuesday Oct 6th, 11am - 5pm Eastern Time

SQL Querying Fundamentals: Part 1

This class is temporarily being offered remotely.

at New Horizons Learning Group LA - Online Virtual Class, Online, California 00000

This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases. Who should attend This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Course Objectives...

Thursday Oct 1st, 6am - 2pm Pacific Time

Querying Data with Transact SQL

This class is temporarily being offered remotely.

at New Horizons Learning Group LA - Online Virtual Class, Online, California 00000

Are you ready to learn how to navigate relational databases like a pro? Transact SQL training from New Horizons will prepare you to take the next step in your data career. In this course, you will gain a comprehensive understanding of the Transact SQL language, which is used by all SQL Server-related disciplines including database administration, database...

Monday Oct 12th, 6am - 2pm Pacific Time

  (5 sessions)
$2,975

5 sessions

Python and SQL for Data Analysis

This class is temporarily being offered remotely.

at Jigsaw Labs - Zoom

This is a coding bootcamp quality class without quitting your job.  Designed by a long-time Flatiron School lead instructor and curriculum writer, you'll learn Python and SQL and HTML.  And in doing so we'll learn how to collect data wherever it exists online, whether scraping a webpage or getting data from APIs.  Classes are...

Saturday Oct 17th, 10:30am - 6:30pm Eastern Time

  (15 sessions)
$650

15 sessions

Python and SQL for Data Analysis

This class is temporarily being offered remotely.

at Jigsaw Labs - Zoom

This is a coding bootcamp quality class without quitting your job.  Designed by a long-time Flatiron School lead instructor and curriculum writer, you'll learn Python and SQL and HTML.  And in doing so we'll learn how to collect data wherever it exists online, whether scraping a webpage or getting data from APIs.   Classes...

Saturday Oct 17th, 10:30am - 6:30pm Eastern Time

  (15 sessions)
$650

15 sessions

Python and SQL for Data Analysis

This class is temporarily being offered remotely.

at Jigsaw Labs - Zoom

This is a coding bootcamp quality class without quitting your job.  Designed by a long-time Flatiron School lead instructor and curriculum writer, you'll learn Python and SQL and HTML.  And in doing so we'll learn how to collect data wherever it exists online, whether scraping a webpage or getting data from APIs.   Classes are...

Saturday Oct 17th, 10:30am - 6:30pm Eastern Time

  (15 sessions)
$650

15 sessions

Intermediate SQL Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

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...

Saturday Oct 3rd, 11am - 5pm Eastern Time

Introduction to SQL for Data Analytics

This class is temporarily being offered remotely.

at Borough of Manhattan Community College - Online BMCC Virtual Learning, New York, New York 00000

Dear prospective student, as you are aware New York State has been dealing with a declared state of emergency due to the novel coronavirus-19 outbreak. Please be aware that our future course dates may be delivered in either a traditional classroom face-to-face format or an on-line format or a hybrid model that mixes both live and online course delivery....

Saturday Nov 14th, 9:30am - 4:30pm Eastern Time

  (5 sessions)
$714

5 sessions

Intermediate SQL Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

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...

Saturday Oct 3rd, 8am - 2pm Pacific Time

Intermediate SQL Bootcamp Remote (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Seattle, Washington 00000

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...

Saturday Oct 3rd, 8am - 2pm Pacific Time