Transact-SQL Querying
- All levels
- 18 and older
- $1,195
- Earn 11,950 reward points
- Price Lock Guarantee
- 1320 Tower Rd, Chicago, IL
- 13 hours & 30 minutes over 2 sessions
Thankfully we have 1 other SQL Server Class for you to choose from. Check our top choice below or see all classes for more options.
ONLC Training Centers @ 1320 Tower Rd, Chicago, IL
Unlock the power of SQL to access and analyze data in large databases with this course from ONLC Training Centers. Learn how to execute queries, perform searches, use functions, organize data, and retrieve information from multiple tables. Perfect for individuals with basic computer skills and a desire to enhance their data analysis abilities.
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
Job role
Skills gained
Course outline
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.
Lessons
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.
Lessons
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.
Lessons
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.
Lessons
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.
Lessons
Cancellation / Reschedule by Student
Because we must schedule rooms, ship course materials, assign instructors and provision computer resources well in advance, it is important students alert us ASAP with any cancel/reschedule requests.
Please note the following policies:
Substitutions
Make-up Policy
Students are permitted one (1) Make-Up opportunity to attend an instructor-led class that was paid for but not previously attended for no additional charge.
Additionally, ONLC reserves the right to retire courses due to lack of demand. Retired classes are not available for Make-Up.
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.
In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.
People who viewed this class also viewed the following classes
Get quick answers from CourseHorse and past students.
ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.
Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...
Read more about ONLC Training Centers
This school has been carefully vetted by CourseHorse and is a verified Chicago educator.
ONLC Training Centers
Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173 Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173
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.
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!
Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!
Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!
Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!
More in Microsoft Servers
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.