Aug 2nd
9am–4:30pm EDT
Meets 3 Times
Unfortunately, no classes in-person in San Francisco have spots left, but 15 classes live online are available.
Learning Tree International - Virtually Online
Structured Query Language (SQL) is the cornerstone of all relational database operations. In this hands-on Advanced SQL course, you will learn how to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation....
Wednesday Aug 2nd, 9am–4:30pm Eastern Time
(3 sessions)
NYIM Training - Virtually Online
Learn the fundamentals of SQL (Structured Query Language) and relational databases, so you can start writing SQL queries to extract and understand the information stored in databases. This SQL starter course will provide you with strong foundational skills to explore the tables, columns, and rows stored in a database and write/code SQL queries to extract and start analyzing that data. Using practical, hands-on exercises, our expert instructor will...
Wednesday Jul 5th, 10am–5pm Eastern Time
NYIM Training - Virtually Online
Take your SQL skills to the next level in this advanced course. You’ll learn about subqueries, views, functions, stored procedures, and more. In this advanced SQL course, you will learn how to complete complex tasks in Microsoft SQL Server through hands-on projects. Learn how to employ If-Else logic to queries through CASE statements, use string functions to extract specific text, and retrieve data from anywhere in a database via subqueries....
Wednesday Jun 7th, 10am–5pm Eastern Time
NYIM Training - Virtually Online
Expand your SQL skills by learning how to use Outer Joins, find NULL data, group data with aggregate functions, filter groups with HAVING, work with dates/time, and more. In this intermediate SQL course, you’ll build on your knowledge of SQL fundamentals, enhancing your skills to join, filter, group, and analyze data. You’ll learn how to use Outer Joins and find NULL data. Group data and perform common statistical calculations using aggregate...
Thursday Jul 6th, 10am–5pm Eastern Time
NYC Career Centers - Virtually Online
Learn the fundamentals of SQL (Structured Query Language) and relational databases, so you can start writing SQL queries to extract and understand the information stored in databases. This SQL starter course will provide you with strong foundational skills to explore the tables, columns, and rows stored in a database and write/code SQL queries to extract and start analyzing that data. Using practical, hands-on exercises, our expert instructor will...
Wednesday Jul 5th, 10am–5pm Eastern Time
Thousands of classes. No expiration. You choose the $ amount. Select a category or let the recipient pick.
NYC Career Centers - Virtually Online
Expand your SQL skills by learning how to group data with aggregate functions, filter groups with HAVING, work with dates/time, perform advanced JOINS such as Self Join and Union, and more. In this intermediate SQL course, you’ll build on your knowledge of SQL fundamentals, enhancing your skills to filter, group, and analyze data. You’ll learn how to group data and perform common statistical calculations using aggregate functions. Working...
Thursday Jul 6th, 10am–5pm Eastern Time
Noble Desktop - Virtually Online
Learn the fundamentals of SQL (Structured Query Language) and relational databases, so you can start writing SQL queries to extract and understand the information stored in databases. This SQL starter course will provide you with strong foundational skills to explore the tables, columns, and rows stored in a database and write/code SQL queries to extract and start analyzing that data. Using practical, hands-on exercises, our expert instructor will...
Wednesday Jul 5th, 10am–5pm Eastern Time
Noble Desktop - Virtually Online
Expand your SQL skills by learning how to use Outer Joins, find NULL data, group data with aggregate functions, filter groups with HAVING, work with dates/time, and more. In this intermediate SQL course, you’ll build on your knowledge of SQL fundamentals, enhancing your skills to join, filter, group, and analyze data. You’ll learn how to use Outer Joins and find NULL data. Group data and perform common statistical calculations using aggregate...
Tuesday Jun 6th, 10am–5pm Eastern Time
NYC Career Centers - Virtually Online
Take your SQL skills to the next level in this advanced course. You’ll learn about subqueries, views, functions, stored procedures, and more. In this advanced SQL course, you’ll learn how to add If-Else logic to queries using CASE statements, and how to use string functions to get just the part of text you need. Subqueries enable you to dynamically grab data from anywhere in a database and use that result in another query. You (or someone...
Friday Jul 7th, 10am–5pm Eastern Time
Noble Desktop - Virtually Online
Take your SQL skills to the next level in this advanced course. You’ll learn about subqueries, views, functions, stored procedures, and more. In this advanced SQL course, you’ll learn how to add If-Else logic to queries using CASE statements, and how to use string functions to get just the part of text you need. Subqueries enable you to dynamically grab data from anywhere in a database and use that result in another query. You (or someone...
Wednesday Jun 7th, 10am–5pm Eastern Time
Noble Desktop - Virtually Online
Turn the information in databases into useful insights by writing SQL queries. Once you understand the basics of viewing tables, columns, and rows, you’ll learn how to code queries to extract the specific information you want. Learn how to filter the data, group it, and turn raw data into insights. Combine information from multiple tables using join statements. You’ll also learn more advanced techniques like aggregate functions, subqueries,...
Jun 20th
10am–5pm EDT
Meets 3 Times
Aug 1st
10am–5pm EDT
Meets 3 Times
Aug 9th
6–9pm EDT
Meets 6 Times
Sep 27th
10am–5pm EDT
Meets 3 Times
Oct 28th
10am–5pm EDT
Meets 3 Times
This class has 2 more dates.
Tap here to see more
Tuesday Jun 20th, 10am–5pm Eastern Time
(3 sessions)
Borough of Manhattan Community College @ Live Online
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 Certified Professional (MCP) Exam 98-364. It will show employers that you understand and have...
Monday Jul 10th, 6–9pm Eastern Time
(10 sessions)
NYIM Training - Virtually Online
Learn Microsoft SQL Server to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering the results. Extract actionable insights from data sets in this hands-on training. Turn the information in databases into useful insights by writing SQL queries. Once you understand the basics of viewing tables, columns, and rows, you’ll learn how to code queries to extract the specific information you want....
Wednesday Jul 5th, 10am–5pm Eastern Time
(3 sessions)
Computer Training Source, Inc. @ Online Classroom
SQL statements are used to perform tasks such as updating data on a database, or retrieving data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, and others. Some of these database systems will have extensions specific only to their system. However, the standard SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create”,...
Tuesday Jul 25th, 6:30–9:30pm Central Time
(4 sessions)
Practical Programming - Virtually Online
Learn SQL fundamentals including data types and queries. Why SQL? Upwards of 90% of time on data wrangling is spent cleaning and manipulating data. With SQL you can easily address these challenges with English-like queries to a database. The gap between the supply and demand of people skilled in SQL is huge. As nearly every industry is moving toward being more data-driven, having this skill will give you a larger role in decision-making wherever...
Jun 20th
10am–5pm EDT
Meets 3 Times
Aug 1st
10am–5pm EDT
Meets 3 Times
Aug 7th
6–9pm EDT
Meets 6 Times
Sep 26th
10am–5pm EDT
Meets 3 Times
Oct 28th
10am–5pm EDT
Meets 3 Times
Tuesday Jun 20th, 10am–5pm Eastern Time
(3 sessions)
General Assembly @ Online Class Livestream, San Francisco, CA 00000
The wellbeing of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19 situation very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including this one. Registered students will be notified 24 hours in advance of this program...
Prompt Yes! @ 601 Montgomery St, San Francisco, CA 94111
Increase your marketability as a web developer, programmer, or database administrator with our SQL training. In this SQL training class, you'll master the skill of writing correct and effective SQL (Structured Query Language) statements that manipulate and retrieve data from your database. Once you know SQL, you can use it to interact with most major databases, such as MS Access, Oracle, Microsoft SQL Server, and MySQL. This SQL...
General Assembly @ 225 Bush St, San Francisco, CA 94104
This workshop will build upon the skills developed in the SQL Bootcamp. The program uses a combination of lecture and in-class exercises to ensure that students leave with a working grasp of the SQL skills covered in class. Students will immediately be able to apply their skills at work. Takeaways The workshop will include the following topics: Build SQL Database in the Cloud (using Amazon Web Services) Import and Export of Data Create and...
General Assembly @ Online Class Livestream, San Francisco, CA 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 powerful but reasonably simple tools for data analysis and handling. This Bootcamp will take absolute...
General Assembly @ Online Class Livestream, San Francisco, CA 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 GROUP BY combined with HAVING CASE and COALESCE Preparation This course will occur completely...
General Assembly @ 225 Bush St, San Francisco, CA 94104
The wellbeing of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the Coronavirus situation very carefully and will be adjusting delivery of our programs. Due to the current health concerns in the greater San Francisco area, all GA short-form (one day) classes, workshops and bootcamps will temporarily be held online - including this one. Registered students will be...
General Assembly @ Online Class Livestream, San Francisco, CA 00000
The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring COVID-19 very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including this one. SQL provides powerful but reasonably simple tools for data analysis and handling. This...
General Assembly @ Online Class Livestream, San Francisco, CA 00000
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 the full analytical powers of SQL and relational databases. Takeaways Understand SQL vocabulary...
Data Weekends @ 450 Townsend St, San Francisco, CA 94107
This workshop will introduce you to essential concepts and practices for building compelling analyses and dashboards on datasets of any size. You will learn how to: Use Python and Pandas to select, group and summarize your data Decide what data to keep and what to ignore Create compelling visualizations using Seaborn and Matplotlib Connect and retrieve data from a database using Python Extend your analyses to relational databases using...
Sunset Learning Institute @ 33 New Montgomery St, San Francisco, CA 94105
This course is designed for developers who need to create applications to analyze Big Data stored in Apache Hadoop using Pig and Hive. Topics include: Hadoop, YARN, HDFS, MapReduce, data ingestion, workflow definition, using Pig and Hive to perform data analytics on Big Data and an introduction to Spark Core and Spark SQL. Target Audience Software developers who need to understand and develop applications for Hadoop. Prerequisites: Students...
General Assembly @ Online Class Livestream, San Francisco, CA 00000
This is a part time course. This course will teach you how to use large datasets to make critical decisions. Unit 1: Exploring Data with Excel Understanding the Value of Data Explore the value of data. Work your way through the data analytics workflow. Unlock the power of Microsoft Excel to utilize its analytical tools — no matter your experience level. Preparing Data in Excel Learn best practices for collecting and cleaning data in Excel...
Sunset Learning Institute @ 33 New Montgomery St, San Francisco, CA 94105
This course is designed as an entry point for developers who need to create applications to analyze Big Data stored in Apache Hadoop using Spark. Topics include: An overview of the Hortonworks Data Platform (HDP), including HDFS and YARN Using Spark Core APIs for interactive data exploration Spark SQL and DataFrame operations Spark Streaming and DStream operations Data visualization, reporting, and collaboration Performance...
Prompt Yes! @ 601 Montgomery St, San Francisco, CA 94111
First released in 1995, Java has become one of the most widely-distributed programming languages present on nearly three billion personal computers, mobile phones, and other handheld devices worldwide. This offers those with some programming experience an intensive, hands-on experience with Java. Over the course of this Java training class, you will gain proficiency with the various technologies and environments in which Java applications...
General Assembly @ Online Class Livestream, San Francisco, CA 00000
This is a full time course. What You'll Learn In this program, you’ll take on real world problems by analyzing data sets for insights and presenting findings using statistics, programming, data modeling, and business knowledge. Git, UNIX, & Relational Databases Gather, store, and organize your data using your basic data science toolkit: SQL, Git, and UNIX. Data Analysis & Python Perform visual and statistical analysis on data using...
Sunset Learning Institute @ 33 New Montgomery St, San Francisco, CA 94105
This course is intended for systems administrators who will be responsible for the design, installation, configuration, and management of the Hortonworks Data Platform (HDP). The course provides in-depth knowledge and experience in using Apache Ambari as the operational management platform for HDP. This course presumes no prior knowledge or experience with Hadoop. Target Audience Linux administrators and system operators responsible for installing,...
Try removing some filters.
Give the perfect gift
Buy a gift card
Want some assistance finding a class?
Get in touch
Explore Our Team Building Experiences
Learn more
More in Database
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.