Class Level:
Beginner
SQL Bootcamp is unfortunately unavailable
Thankfully we have 4 other Data Science Classes for you to choose from. Check our top choices below or see all classes for more options.
Class Tags:
Other Categories in Tech
Course Details
Price:
$975
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.
Booking for 6+?
Location:
Live Online Webinar
Other Booking Options:
Purchase Options
Description
Age Requirements:
18 and older
Average Class Size:
30
System Requirements:
You will need a reliable Internet connection as well as a computer or device with which you can access your virtual class. We recommend you arrive to class 5-10 minutes early to ensure you're able to set up your device and connection.
Class Delivery:
This class will be held via Zoom unless otherwise specified
What you'll learn in this data science course:
Learn SQL fundamentals including data types and queries.
Why SQL?
With SQL you can answer questions using a database, the ultimate system of record for most organizations. As nearly every industry is moving toward being more data-driven, having this skill will give you a larger role in decision-making wherever you work.
You’ll be introduced to foundational concepts like tables, data types, and queries. Once you understand the basics of viewing tables, you’ll be introduced to more advanced querying techniques like filtering and aggregating. You will be able to drill down into specific cases or step back and see larger patterns. You’ll also learn how to combine information from different tables using join statements and views. The final day of the course will cover advanced techniques like creating subqueries and using timestamp functions.
This course will use Postgres, an advanced open-source database. Concepts from this course will apply equally to other databases such as MySQL and SQL Server, with the minor syntax differences noted during class.
What You’ll Learn
- Explore and alter data using a graphical user interface
- Write queries to search through tables programmatically
- Understand different data types and converting between them
- Combine information across tables with join statements
- Advanced techniques like subqueries and timestamp functions
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.
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
Ch Gift Card
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.
Reviews of Classes at Practical Programming (378)
School: 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
This school has been carefully vetted by CourseHorse and is a verified Online educator.
Want to take this class?
Save to Wish List
Booking this class for a group?
Find great private group events here
4 Top Choices
Data Science with Python: Data Analysis & Visualization
This class is a comprehensive introduction to data science with Python programming language. This class targets people who have some basic knowledge of programming and want to take it to the next level. It introduces how to work with different data structures in Python and covers the most popular data analytics and visualization modules, including...
This class is a comprehensive introduction to data...
Read moreSunday Mar 5th, 1pm - 5pm Eastern Time
(5 sessions)
Data Science with Python: Machine Learning
This 20-hour Machine Learning with Python course covers all the basic machine learning methods and Python modules (especially Scikit-Learn) for implementing them. The five sessions cover: simple and multiple Linear regressions; classification methods including logistic regression, discriminant analysis and naive bayes, support vector...
This 20-hour Machine Learning with Python course covers...
Read moreSunday Mar 5th, 1pm - 5pm Eastern Time
(5 sessions)
Machine Learning
at Borough of Manhattan Community College -
Machine learning uses interdisciplinary techniques such as statistics, linear algebra, optimization, and computer science to create automated systems that can sift through large volumes of data at high speed to make predictions or decisions without human intervention. This class will familiarize students with a broad cross-section of models and algorithms...
Machine learning uses interdisciplinary techniques...
Read moreTuesday Feb 7th, 6pm - 9pm Eastern Time
(26 sessions)
Data Science with R: Data Analysis and Visualization
This course is a 35-hour program designed to provide a comprehensive introduction to R for Data Analysis and Visualization. You’ll learn how to load, save, and transform data as well as how to write functions, generate graphs, and fit basic statistical models with data. In addition to a theoretical framework in which to understand the process of...
This course is a 35-hour program designed to provide...
Read moreSaturday Mar 4th, 10am - 5pm Eastern Time
(5 sessions)
Choose a Gift Giving Option
Know someone who would like this class but not sure of their schedule? (We recommend this!)
Know their schedule better than your own? Book a date and time directly.
One last thing!
Add a name to your account.
What name do you want displayed with your post?
What name do you want displayed with your post?