Discover Classes. Earn Rewards.

Querying Microsoft SQL Server 2014 is unfortunately unavailable

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

SQL Level I

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Learn the fundamentals of SQL and relational databases in this introductory course, where you'll gain the skills to write SQL queries, filter results, and combine data from multiple tables. Explore the basics of database architecture and develop your skills in writing real SQL code with practical, hands-on exercises.

(680) Beginner 18 and older

SQL Level II

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Take your SQL skills to the next level by mastering advanced functions and techniques, including grouping data, filtering groups, working with dates and times, and performing advanced JOINs. Unlock the power of SQL to extract and analyze data with precision and turn it into actionable insights.

(680) Intermediate 18 and older

SQL Server Bootcamp

Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online

Gain actionable insights and turn raw data into useful information with the SQL Server Bootcamp. Learn Microsoft SQL Server and how to write SQL queries to extract, join, aggregate, and filter data in databases. Take your data analysis skills to the next level at Noble Desktop.

(372) All levels 18 and older
$975

3 sessions

Gift it!

SQL Level III

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Take your SQL skills to the next level with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.

(680) Advanced 18 and older

SQL Bootcamp

NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online

Master the art of extracting actionable insights from databases with the SQL Bootcamp at NYC Career Centers. Learn Microsoft SQL Server, join tables, aggregate data, and filter results in this hands-on course. Gain the skills needed to turn raw data into valuable insights for decision-making in any industry.

(680) All levels 18 and older
$975

3 sessions

Gift it!
See all SQL Server classes NYC

Querying Microsoft SQL Server 2014

  • Beginner
  • 16 and older
  • $2,699
  • 519 8th Ave, New York, NY
  • over 5 sessions

Start Dates (0)

  • $2,699
  • NetCom New York (old) @ 519 8th Ave, New York, NY 10018
  • over 5 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this sql server training:

This 5-day instructor led course provides students with the technical skills required 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.

This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Querying Microsoft SQL Server 2014 Course Objectives:
  • 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
Course Outline:
Querying Microsoft SQL Server 2014 Course Outline:
Introduction to Microsoft SQL Server 2014

The Basic Architecture of SQL Server
SQL Server Editions and Versions
Getting Started with SQL Server Management Studio
Lab : Working with SQL Server 2014 Tools
Introduction to T-SQL Querying
Introducing T-SQL
Understanding Sets
Understanding Predicate Logic
Understanding the Logical Order of Operations in SELECT statements
Lab : Introduction to Transact-SQL Querying

Writing SELECT Queries
Writing Simple SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions
Lab : Writing Basic SELECT Statements

Querying Multiple Tables
Understanding Joins
Querying with Inner Joins
Querying with Outer Joins
Querying with Cross Joins and Self Joins
Lab : Querying Multiple Tables

Sorting and Filtering Data
Sorting Data
Filtering Data with a WHERE Clause
Filtering with the TOP and OFFSET-FETCH Options
Working with Unknown and Missing Values
Lab : Sorting and Filtering Data
Working with SQL Server 2014 Data Types
Introducing SQL Server 2014 Data Types
Working with Character Data
Working with Date and Time Data
Lab : Working with SQL Server 2014 Data Types

Using DML to Modify Data
Inserting Data
Modifying and Deleting Data
Lab : Using DML to Modify Data

Using Built-In Functions
Writing Queries with Built-In Functions
Using Conversion Functions
Using Logical Functions
Using Functions to Work with NULL
Lab : Using Built-In Functions

Grouping and Aggregating Data
Using Aggregate Functions
Using the GROUP BY Clause
Filtering Groups with HAVING
Lab : Grouping and Aggregating Data

Using Subqueries
Writing Self-Contained Subqueries
Writing Correlated Subqueries
Using the EXISTS Predicate with Subqueries
Lab : Using Subqueries
Using Table Expressions
Using Derived Tables
Using Common Table Expressions
Using Views
Using Inline Table-Valued Functions
Lab : Using Table Expressions

Using Set Operators
Writing Queries with the UNION Operator
Using EXCEPT and INTERSECT
Using APPLY
Lab : Using Set Operators 

Using Window Ranking, Offset, and Aggregate Functions
Creating Windows with OVER
Exploring Window Functions
Lab : Using Window Ranking, Offset and Aggregate Functions

Pivoting and Grouping Sets
Writing Queries with PIVOT and UNPIVOT
Working with Grouping Sets
Lab : Pivoting and Grouping Sets
Executing Stored Procedures
Querying Data with Stored Procedures
Passing Parameters to Stored Procedures
Creating Simple Stored Procedures
Working with Dynamic SQL
Lab : Executing Stored Procedures

Programming with T-SQL
T-SQL Programming Elements
Controlling Program Flow
Lab : Programming

Implementing Error Handling
Using TRY / CATCH Blocks
Working with Error Information
Lab : Implementing Error Handling with T-SQL 

Implementing Transactions
Transactions and the Database Engine
Controlling Transactions
Isolation LevelsLab : Implementing Transactions

Refund Policy

A student who cancels within 7 days of signing the enrollment agreement but before instruction begins receives all monies returned with the exception of the non-refundable registration fee.

Thereafter, a student will be liable for:

  • The non-refundable registration fee of $100 plus
  • The cost of any textbooks or supplies accepted plus
  • Tuition liability as of the student's last date of physical attendance
If Termination Occurs

  • Prior to or during the first week - 0% Penalty
  • During the second week - 25% Penalty
  • During the third week - 50% Penalty
  • During the fourth week - 75% Penalty
  • After the fourth week - 100% Penalty

The failure of a student to notify CourseHorse in writing of withdrawal may delay a refund of tuition.

Reviews of Classes at NetCom Learning (16)

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

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

NetCom Learning

NetCom Learning delivers top-quality training and certification solutions to businesses, individuals and government agencies.

Experience

Since its inception in 1998, NetCom has trained over 95 percent of the Fortune 500, serviced over 23,000 business customers, and advanced the skills and careers of over...

Read more about NetCom Learning

CourseHorse Approved

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

NetCom Learning

NetCom Learning

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