Close
Contact Us info@learnquest.com

??WelcomeName??
??WelcomeName??
« Important Announcement » Contact Us 877-206-0106 | USA Flag
Close
Close
Close
photo

Thank you for your interest in LearnQuest.

Your request is being processed and LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

photo

Thank you for your interest in Private Training.

We look forward to helping you develop the perfect training solution to help you meet your company's goals.

For immediate assistance, speak with one of our representatives using the chat module below. Otherwise, LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

Close
photo

Thank you for your interest in LearnQuest!

Now, you will be able to stay up-to-date on our latest course offerings, promotions, and training discounts. Watch your inbox for upcoming special offers.

title

Date: xxx

Location: xxx

Time: xxx

Price: xxx

Please take a moment to fill out this form. We will get back to you as soon as possible.

All fields marked with an asterisk (*) are mandatory.

Querying Data with Microsoft Transact-SQL

Price
1,190 USD
2 Days
MOC-DP-080T00
Classroom Training, Online Training
Microsoft

AWS Training Pass

Take advantage of flexible training options with the AWS Training Pass and get Authorized AWS Training for a full year.

Learn More

Prices reflect a 22.5% discount for IBM employees (wherever applicable).
Prices reflect a 24% discount for Kyndryl employees (wherever applicable).
Prices reflect the Accenture employee discount.
Prices shown are the special AWS Partner Prices.
Prices reflect the Capgemini employee discount.
Prices reflect the UPS employee discount.
Prices reflect the ??democompanyname?? employee discount.
GSA Private/Onsite Price: ??gsa-private-price??
For GSA pricing, please go to GSA Advantage.
 

Class Schedule

Delivery Formats

Sort results

Filter Classes

Guaranteed to Run

Modality

Location

Language

Date

  • Date: 28-Oct-2024 to 29-Oct-2024
    Time: 9AM - 5PM US Eastern
    Location: Virtual
    Language: English
    Delivered by: LearnQuest
    Price: 1,190 USD
  • Guaranteed to Run
    Date: 25-Nov-2024 to 26-Nov-2024
    Time: 9AM - 5PM US Eastern
    Location: Virtual
    Language: English
    Delivered by: united
    Price: 1,190 USD
  • Date: 9-Dec-2024 to 10-Dec-2024
    Time: 9AM - 5PM US Eastern
    Location: Virtual
    Language: English
    Delivered by: LearnQuest
    Price: 1,190 USD
  • Date: 20-Jan-2025 to 21-Jan-2025
    Time: 9AM - 5PM US Eastern
    Location: Virtual
    Language: English
    Delivered by: LearnQuest
    Price: 1,190 USD
  • Date: 3-Mar-2025 to 4-Mar-2025
    Time: 9AM - 5PM US Eastern
    Location: Virtual
    Language: English
    Delivered by: LearnQuest
    Price: 1,190 USD
  • Date: 14-Apr-2025 to 15-Apr-2025
    Time: 9AM - 5PM US Eastern
    Location: Virtual
    Language: English
    Delivered by: LearnQuest
    Price: 1,190 USD
View Global Schedule

Course Description

Overview

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

Objectives

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.
 

Audience


 

Prerequisites

    After completing this course, students will be able to:
    • Use SQL Server query tools
    • Write SELECT statements to retrieve columns from one or more tables
    • Sort and filter selected data
    • Use built-in functions to returned data values
    • Create groups of data and aggregate the results
    • Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE

Topics

Module 1: Getting Started with Transact-SQL In this module you will learn about the basics of the Transact-SQL (T-SQL) language, as well as general properties and terminology of relational databases. This module will also introduce the basic SELECT statement for retrieving data from a table.
  • Introduction to Transact-SQL
  • Using the SELECT statement
  • Lab : Get started with SQL Server query tools and writing queries in T-SQL
After completing this module, students will be able to:
  • Using a query tool to write and execute queries in Transact-SQL
  • Understand the basic concepts of relational database and the T-SQL language
  • Write SELECT statements to retrieve data from a relational database table
  • Understand basic datatypes and how they are used
  • Understand the basics of NULL values
Module 2: Sorting and Filtering Query Results In the module you will learn how to control what data is returned, the order in which it is returned. You will use the ORDER BY clause, with and without paging. You will learn about various kinds of filters that can be used in the WHERE clause to control which data rows are returned. You will also learn how to manage the results by removing duplicates with DISTINCT.
  • Sorting query results
  • Filtering the data
  • Lab : Sort and filter data returned by SELECT queries
After completing this module, students will be able to:
  • Use ORDER BY to sort results from a T-SQL SELECT statement
  • Add a TOP clause to limit the ordered rows returned
  • Page the sorted data with OFFSET-FET
  • Write WHERE clauses to filter the rows returned
  • Use DISTINCT to eliminate duplicate rows in the results
Module 3: Using Joins and Subqueries In this module, you will explore T-SQL queries which access data from multiple tables with various kinds of JOIN operations and simple subqueries.
  • Using JOIN operations
  • Using subqueries
  • Lab : Write queries with JOIN operations
  • Lab : Write SELECT statements using subqueries
After completing this module, students will be able to:
  • Write queries accessing data from multiple tables using JOIN operations
  • Understand the differences between type of JOIN operations: INNER JOIN, OUTER JOIN, CROSS JOIN
  • Understand how to join a table to itself with a self-join
  • Write subqueries within a SELECT statement
  • Understand the difference between scalar and multi-valued subqueries
  • Understand the difference between correlated and self-contained subqueries
Module 4: Using Built-in Functions In the module you will explore the use of built-in functions for returning computed or special values in the SELECT list or in the WHERE clause. Functions include math functions, string functions and system functions. There are other types of functions that will be mentioned, but not discussed in detail. You will also learn how to combine rows of data into a single group, providing summary information for the group such as SUM, MIN or MAX.
  • Getting started with scalar functions
  • Grouping aggregated results
  • Lab : Built-in functions
After completing this module, students will be able to:
  • Write queries using scalar functions
  • Write queries using aggregate functions
  • Use GROUP BY to combine data into groups based on a common column value
  • Understand how HAVING is used to filter groups of rows
Module 5: Modifying Data In this module, you will learn the T-SQL statements for modifying table data including UPDATE, DELETE and MERGE as well as various options for INSERT including creating a new table with data from an existing table. You will also look at how to have the system automatically supply values for columns as the data is inserted.
  • Inserting data into tables
  • Modifying and deleting data
  • Lab : Modify data
After completing this module, students will be able to:
  • Insert data into an existing table
  • Specify that a column should be automatically populating with an IDENTITY or a SEQUENCE value
  • Modify data using the UPDATE statement
  • Delete data using the DELETE statement
  • Modify data using MERGE to synchronize two tables
2023 Top 20 Training Industry Company - IT Training

Need Help?

Call us at 877-206-0106 or e-mail us at info@learnquest.com

Personalized Solutions

Need a personalized solution for your Training? Contact us, and one of our training advisors will help you find the best solution.

Contact Us

Need Help?

Do you have a question about the courses, instruction, or materials covered? Do you need help finding which course is best for you? We are here to help!

Talk to us

Cybersecurity Awareness Month 2024

Get Ahead of Online Threats with 20% Off Security Training.

Use SECURITY20 at checkout. Valid through October 31, 2024.

Browse Training Courses

IBM TechXchange Conference 2024

October 21-24 | Mandalay Bay, Las Vegas

Join us for four action-packed days to immerse yourself in innovation and learning. Gain practical skills in Generative AI, harness IBM technology, and engage with tech industry experts.

Self-Paced Training Info

Learn at your own pace with anytime, anywhere training

  • Same in-demand topics as instructor-led public and private classes.
  • Standalone learning or supplemental reinforcement.
  • e-Learning content varies by course and technology.
  • View the Self-Paced version of this outline and what is included in the SPVC course.
  • Learn more about e-Learning

Course Added To Shopping Cart

bla

bla

bla

bla

bla

bla

Self-Paced Training Terms & Conditions

??spvc-wbt-warning??

Exam Terms & Conditions

??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??

Sorry, there are no classes that meet your criteria.

Please contact us to schedule a class.
Close

self-paced
STOP! Before You Leave

Save 0% on this course!

Take advantage of our online-only offer & save 0% on any course !

Promo Code skip0 will be applied to your registration

Close
Nothing yet
here's the message from the cart

To view the cart, you can click "View Cart" on the right side of the heading on each page
Add to cart clicker.

Purchase Information

??elearning-coursenumber?? ??coursename??
View Cart

title

Date: xxx

Location: xxx

Time: xxx

Price: xxx

Please take a moment to fill out this form. We will get back to you as soon as possible.

All fields marked with an asterisk (*) are mandatory.

If you would like to request a quote for 5 or more students, please contact CustomerService@learnquest.com to be assigned an account representative.

Need more Information?

Speak with our training specialists to continue your learning journey.

 

Delivery Formats

Close

By submitting this form, I agree to LearnQuest's Terms and Conditions

heres the new schedule
This website uses third-party profiling cookies to provide services in line with the preferences you reveal while browsing the Website. By continuing to browse this Website, you consent to the use of these cookies. If you wish to object such processing, please read the instructions described in our Privacy Policy.
Your use of this LearnQuest site affirms your consent to our use of session and persistent cookies to track how you use our website.