Discover Classes. Earn Rewards.

SQL Querying Advanced is unfortunately unavailable

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

Transact-SQL Querying

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

This two-day course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. Audience Profile This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes...

(7) All levels 18 and older
$1,195

2 sessions

Gift it!

Querying MySQL

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Explore the fundamentals of MySQL, database querying techniques, and programming stored routines in this course tailored for application and web developers. Unlock the power of MySQL 8.0 and enhance your database management skills.

(7) Beginner 18 and older
$2,100

3 sessions

Gift it!

SQL Querying: Fundamentals

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Learn the essential skills of SQL querying to retrieve and manipulate data from databases with precision and efficiency.

(7) Intermediate 18 and older

Python Programming 2: Advanced Programming Techniques

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Enhance your expertise in Python with this course designed to equip you with the tools needed to tackle complex programming challenges.

(7) Advanced 18 and older
$995

2 sessions

Gift it!

Power BI Tools: Get and Transform Data

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Learn to use Power Query in this course offered by ONLC Training Centers. Designed for Excel power users, Power BI professionals, and SQL Server users, this course covers the essentials of Power Query and introduces the M language for advanced data manipulation. Upgrade your data analysis skills and save time on repetitive tasks with this training.

(7) Intermediate 18 and older
See all SQL classes Los Angeles

SQL Querying Advanced

  • Advanced
  • 18 and older
  • $395
  • 1900 S State College Blvd, Anaheim, CA
  • 8 hours

Start Dates (0)

  • $395
  • New Horizons - Anaheim @ 1900 S State College Blvd Ste 100, Anaheim, CA 92806
  • 8 hours
Showing 10 of 0

Class Description

Description

What you'll learn in this sql class:

In this course, students will learn how to identify and use advanced querying techniques. You may perform tasks such as modifying the structure of a table: inserting, updating, deleting data and indexing tables to optimize query performance.

Who should attend
Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology.

Upon successful completion of this course, students will be able to:
  • use subqueries to generate query output. 
  • manipulate table data by inserting, updating, and deleting records in a table. 
  • manipulate the table structure. 
  • create views, manipulate data through views, modify the view structure, and drop views. 
  • create indexes on table columns and drop inefficient indexes. 
  • mark the beginning of a transaction, roll back a transaction, and commit a transaction.
Pre-requisite:
SQL Querying: Level 1 Fundamentals of Querying

Refund Policy

For open enrollment classes, ten (10) business days' written notice is required to reschedule a class with no additional fees.

In case of a no-show or a cancellation with less than ten (10) business days before class date: 100% of the class price will be due according to the date of original invoice or date of Term Net 30.

Reviews of Classes at New Horizons Learning Group LA (1)

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 3950 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

New Horizons Learning Group LA

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

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Los Angeles educator.

New Horizons Learning Group LA

New Horizons Learning Group LA

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

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.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...