SQL Querying Fundamentals: Part 2
- Intermediate
- 18 and older
- $495
- Virtual Class, Online, CA
- 8 hours
Thankfully we have 18 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.
Noble Desktop - Virtually Online
Master the art of turning raw data into actionable insights with SQL queries. This hands-on course will teach you how to filter, group, and join data, as well as use advanced techniques like subqueries and aggregate functions. Gain the skills to excel in any data-driven industry and make more informed decisions.
Apr 30th
10am–5pm EDT
Meets 3 Times
May 20th
10am–5pm EDT
Meets 3 Times
Jun 10th
10am–5pm EDT
Meets 3 Times
This class has 4 more dates.
Tap here to see more
Noble Desktop - Virtually Online
Unlock the power of databases with personalized SQL training. Master the art of querying, filtering, and aggregating data using PostgreSQL, gaining essential skills applicable across various database platforms. Transform
Noble Desktop - Virtually Online
In this course, students will master Excel, SQL, and Tableau, some of the top data analytics tools. Here, students will gain the skills to organize, analyze, summarize, and visualize data, presenting actionable insights for effective decision-making. Comprehensive classroom training in Midtown Manhattan.
May 13th
10am–5pm EDT
Meets 8 Times
May 14th
6–9pm EDT
Meets 16 Times
Noble Desktop - Virtually Online
Unlock the power of SQL and relational databases with this comprehensive course. Learn how to write SQL queries, filter results, and combine data from multiple tables, all while gaining a strong foundation in database architecture. Master the fundamentals of SQL at Noble Desktop.
May 14th
6–9pm EDT
Meets 2 Times
May 28th
10am–5pm EDT
This class has 3 more dates.
Tap here to see more
Noble Desktop - Virtually Online
Enhance your SQL skills by mastering Outer Joins, NULL data, grouping, aggregate functions, filtering, and working with dates/times. Extract and analyze specific data from databases, turning raw information into valuable insights. Prerequisite: SQL proficiency equivalent to Noble Desktop's SQL Level 1 course.
May 21st
6–9pm EDT
Meets 2 Times
May 29th
10am–5pm EDT
This class has 3 more dates.
Tap here to see more
In this course you will learn how to identify and use advanced querying techniques. You might find that you need to modifying the structure of a table; inserting, updating, deleting data and indexing tables to optimize query performance.
COURSE OUTLINE
1 - USING SUBQUERIES TO PERFORM ADVANCED QUERYING
2 - MANIPULATING TABLE DATA
3 - MANIPULATING THE TABLE STRUCTURE
4 - WORKING WITH VIEWS
5 - INDEXING DATA
6 - MANAGING TRANSACTIONS
COURSE OBJECTIVES
In this course, you will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel the data entry process.
You will:
TARGET AUDIENCE
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.
Get quick answers from CourseHorse and past students.
People who viewed this class also viewed the following classes
New Horizons Learning Group has been serving businesses and individuals in the Arizona, California and Nevada communities for over 35 years. With ten convenient locations we offer a wide range of technical, application and business skills courses. As the world of computer technology continues to evolve...
Read more about New Horizons Learning Group LA
This school has been carefully vetted by CourseHorse and is a verified Online educator.
Booking this class for a group? Find great private group events
Or see all Professional Group Events
Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and 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.