Discover Classes. Earn 10% Rewards.

Writing Queries Using Microsoft SQL 2008 Transact-SQL is unfortunately unavailable

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

SQL Bootcamp

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.

(373) All levels 18 and older
$975

3 sessions

Gift it!

SQL Private Training

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

(373) All levels 13 and older

Data Analytics Technologies Bootcamp

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.

(373) All levels 18 and older
$1,949

8 sessions

Gift it!

SQL Bootcamp (PostgreSQL)

NYIM Training - Virtually Online

Discover how to transform raw data into actionable insights using SQL queries in this hands-on PostgreSQL course. Learn to filter, aggregate, and join data to extract the specific information you need. Gain a valuable skill that will give you a larger role in decision-making in any industry.

(742) All levels 18 and older
$975

3 sessions

Gift it!

SQL Level 1

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.

(373) Beginner 18 and older
$350

2 sessions

Gift it!
See all SQL classes Online

Writing Queries Using Microsoft SQL 2008 Transact-SQL

  • Advanced
  • 18 and older
  • $1,785
  • Earn 17,850 reward points
  • Price Lock Guarantee
  • Live, Interactive online classroom
  • over 3 sessions

Start Dates (0)

  • $1,785
  • over 3 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this sql class:

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Who Should Attend
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Course Objectives
After completing this course, students will be able to:
  • Describe the uses of and ways to execute the Transact-SQL language.
  • Use querying tool.
  • Write SELECT queries to retrieve data.
  • Group and summarize data by using Transact-SQL.
  • Join data from multiple tables.
  • Write queries that retrieve and modify data by using subqueries.
  • Modify data in tables.
  • Query text fields with full-text search.
  • Describe how to create programming objects.
  • Use various techniques when working with complex queries.

Course Outline
  1. Getting Started with Databases and Transact-SQL in SQL Server 2008
  2. Querying and Filtering Data
  3. Grouping and Summarizing Data
  4. Joining Data from Multiple Tables
  5. Working with Subqueries
  6. Modifying Data in Tables
  7. Querying Metadata, XML, and Full-Text Indexes
  8. Using Programming Objects for Data Retrieval
  9. Using Advanced Querying Techniques

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.

Refund Policy

Please notify us at [email protected]

  • 7 or more business days in advance of your scheduled class if you need to cancel your reservation for applications classes.
  • 12 or more business days for technical classes.
You will receive a 95% refund if you cancel according to the terms above for applications and technical classes.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

Reviews of Classes at New Horizons Computer Learning (8)

Similar Classes

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 17850 points. Earn 10% back in reward points!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

New Horizons Computer Learning

As part of the largest independent IT Training Provider, New Horizons Computer Learning Center delivers more courses than any other IT training company.

Innovative and Flexible Learning Methods

New Horizons New York City understands that not everyone is the same, and we have developed a variety of innovative...

Read more about New Horizons Computer Learning

CourseHorse Approved

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

New Horizons Computer Learning

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.

  • Price Lock Guarantee

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • Earn 10% Reward Points

    Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!

  • No Added Fees

    Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!

  • Curated Courses

    Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!

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