Querying Microsoft SQL Server 2014 is unfortunately unavailable

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

SQL Server Bootcamp

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

Pick up 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. Push your data analysis skills to a new level.

(452) All levels 18 and older

Nov 2nd

10am–5pm ET

Meets 3 Times

$975

20 Seats Left

Dec 9th

10am–5pm ET

Meets 3 Times

$975

20 Seats Left

This class has 4 more dates.

Tap here to see more

Mon. Nov 2nd, 10am–5pm ET (21 hours over 3 sessions)

$975

3 sessions

Attend

Gift it!

Power BI Bootcamp

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

Develop expert-level data storytelling skills by learning to build dynamic visualizations and sophisticated dashboards in Power BI. Connect multiple data sources, leverage Power Query for efficient data shaping, and apply Power BI's time intelligence reports to uncover trends over time. A thorough, career-elevating course for business reporting professionals.

(452) All levels 18 and older

Dec 15th

10am–5pm ET

Meets 2 Times

$799

20 Seats Left

This class has 6 more dates.

Tap here to see more

Tue. Dec 15th, 10am–5pm ET (14 hours over 2 sessions)

$799

2 sessions

Attend

Gift it!

SQL Level I

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

Step into the fundamentals of SQL and relational databases in this introductory course, where you will pick up the skill to write SQL queries, filter results, and join data across multiple tables. Get into the basics of database architecture and build your SQL coding through practical hands-on exercises.

(686) Beginner 18 and older

Nov 2nd

10am–5pm ET

$350

20 Seats Left

Dec 9th

10am–5pm ET

$350

20 Seats Left

This class has 6 more dates.

Tap here to see more

Mon. Nov 2nd, 10am–5pm ET (7 hours)

$350

Attend

Gift it!

SQL Level III

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

Push your SQL skills further with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.

(686) Advanced 18 and older

Nov 4th

10am–5pm ET

$425

20 Seats Left

Dec 11th

10am–5pm ET

$425

20 Seats Left

This class has 6 more dates.

Tap here to see more

Wed. Nov 4th, 10am–5pm ET (7 hours)

$425

Attend

Gift it!

SQL Level II

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

Push your SQL skills further by mastering advanced functions and techniques, including grouping data, filtering groups, working with dates and times, and running advanced JOINs. Unlock the power of SQL to pull and analyze data with precision and turn it into actionable insight.

(686) Intermediate 18 and older

Nov 3rd

10am–5pm ET

$350

20 Seats Left

Dec 10th

10am–5pm ET

$350

20 Seats Left

This class has 6 more dates.

Tap here to see more

Tue. Nov 3rd, 10am–5pm ET (7 hours)

$350

Attend

Gift it!

See all Microsoft classes Brooklyn

Querying Microsoft SQL Server 2014

NetCom Learning

4.1 16 reviews

Beginner
16 and older
Earn 10% Rewards
Price Lock

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!
519 8th Ave, New York, NY
over 5 sessions

Sold Out

Start Dates (0) $2,699/person

No upcoming dates are currently available.

Book a Private 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.

Description

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)

(4.1-star rating across 16 reviews)

See reviews for other classes at NetCom Learning

Hide Reviews

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

NetCom Learning

NetCom Learning is a leading provider of training and certification solutions for businesses, individuals, and government agencies. With over 20 years of experience, NetCom has worked with Fortune 500 companies, serviced thousands of business customers, and advanced the careers of over 50,000 professionals through expert-led training.

View school profile

Vetted by CourseHorse

A verified Brooklyn educator.

SQL Server Bootcamp

Power BI Bootcamp

SQL Level I

SQL Level III

SQL Level II

Querying Microsoft SQL Server 2014

Description

Refund Policy

Questions about this class?

Cities