Discover Classes. Earn Rewards.

Querying Microsoft SQL Server® is unfortunately unavailable

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

Azure Administrator

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

Learn the essential skills needed to effectively manage and maintain cloud services with hands-on training and real-world scenarios. Stay ahead in the ever-evolving world of technology with this comprehensive course.

(7) All levels 18 and older
$2,395

4 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

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!

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!
See all Microsoft Servers classes Los Angeles

Querying Microsoft SQL Server®

  • All levels
  • 18 and older
  • $2,975
  • 1900 S State College Blvd, Anaheim, CA
  • 40 hours over 5 sessions

Start Dates (0)

  • $2,975
  • New Horizons - Anaheim @ 1900 S State College Blvd Ste 100, Anaheim, CA 92806
  • 40 hours over 5 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this microsoft servers class:

Students learn the technical skills to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Who Should Attend

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

After completing this course, students will be able to:
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions
Pre-requisites:
  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

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

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

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