Transact SQL-Querying
- Beginner
- 16 and older
- $1,295
- Earn 12,950 reward points
- Live Online Training
- 16 hours over 2 sessions
Apr 30th
10am–5pm EDT
Meets 3 Times
Discover Classes. Earn 10% Rewards.
Transact SQL-Querying is unfortunately unavailable
Thankfully we have 18 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.
$975
20 Seats Left
May 20th
10am–5pm EDT
Meets 3 Times
$975
20 Seats Left
Jun 10th
10am–5pm EDT
Meets 3 Times
$975
20 Seats Left
This class has 4 more dates.
Tap here to see more
Tue, Apr 30th, 10am–5pm EDT
(21 hours over 3 sessions)
Other dates (8)
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
Wed, May 29th, 10am–1pm EDT
(3 hours)
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.
May 13th
10am–5pm EDT
Meets 8 Times
$1,949
20 Seats Left
May 14th
6–9pm EDT
Meets 16 Times
$1,949
20 Seats Left
Don't see any dates that work for you?
Add to Wishlist
Mon, May 13th, 10am–5pm EDT
(56 hours over 8 sessions)
Other dates (3)
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.
May 14th
6–9pm EDT
Meets 2 Times
$350
20 Seats Left
May 28th
10am–5pm EDT
$350
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, May 14th, 6–9pm EDT
(6 hours over 2 sessions)
Other dates (7)
SQL Level 3
Noble Desktop - Virtually Online
Take your SQL skills to the next level with this advanced course at Noble Desktop. Learn how to use subqueries, views, functions, stored procedures, and more to manipulate and analyze data in databases. Gain in-depth techniques that will prepare you for a job in data analysis or data science.
May 28th
6–9pm EDT
Meets 2 Times
$425
20 Seats Left
May 30th
10am–5pm EDT
$425
20 Seats Left
This class has 3 more dates.
Tap here to see more
Tue, May 28th, 6–9pm EDT
(6 hours over 2 sessions)
Other dates (7)
Sold Out
Start Dates (0)
- $1,295
- 16 hours over 2 sessions
Showing
1
–
0
of
0
Class Description
Description
What you'll learn in this sql class:
Transact SQL-Querying 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.
Training Exclusives
- Gain access to Microsoft Official Courseware (MOC) , Labs, and Practice Test, when available.
- Get Trained by Microsoft Certified Trainers (MCT).
- Access to the recordings of your class sessions for a year.
- Access to a dedicated NetCom 365 portal.
- Experience 24*7 learner support.
Learning Objectives
- 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.
Who Should Go For This Training?
- 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.
Course Outline
- Getting Started with Transact-SQL
- Introduction to Transact-SQL
- Using the SELECT statement
- Lab : Get started with SQL Server query tools and writing queries in T-SQL
- Sorting and Filtering Query Results
- Sorting query results
- Filtering the data
- Lab : Sort and filter data returned by SELECT queries
- Using Joins and Subqueries
- Using JOIN operations
- Using subqueries
- Lab : Write queries with JOIN operations
- Lab : Write SELECT statements using subqueries
- Using Built-in Functions
- Getting started with scalar functions
- Grouping aggregated results
- Lab : Built-in functions
- Modifying Data
- Inserting data into tables
- Modifying and deleting data
- Lab : Modify data
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
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
- 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
People who viewed this class also viewed the following classes
CourseHorse Gift Card
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 12950 points. Earn 10% back in reward points!
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
This school has been carefully vetted by CourseHorse and is a verified Online educator.
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™
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.
One last thing!
Add a name to your account.
What name do you want displayed with your post?
What name do you want displayed with your post?
Get it first. Sign up for up-to-the-minute offers, sales and news.
More in Database
Made in NYC
© CourseHorse, Inc. 2024 Loading...