Microsoft Transact-SQL Programming
- Beginner
- 18 and older
- $2,798
- Earn 27,980 reward points
- Price Lock Guarantee
- ILT, remote-live, on-demand or on-site
- 40 hours over 5 sessions
Thankfully we have 19 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.
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.
Apr 30th
10am–5pm EDT
Meets 3 Times
May 20th
10am–5pm EDT
Meets 3 Times
Jun 10th
10am–5pm EDT
Meets 3 Times
This class has 3 more dates.
Tap here to see more
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
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
May 14th
6–9pm EDT
Meets 16 Times
Jun 21st
10am–5pm EDT
Meets 8 Times
NYIM Training - Virtually Online
Discover how to transform raw data into actionable insights using SQL queries in this hands-on PostgreSQL course. Learn to filter, aggregate, and join data to extract the specific information you need. Gain a valuable skill that will give you a larger role in decision-making in any industry.
Apr 30th
10am–5pm EDT
Meets 2 Times
May 20th
10am–5pm EDT
Meets 3 Times
Jun 10th
10am–5pm EDT
Meets 3 Times
This class has 3 more dates.
Tap here to see more
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
May 28th
10am–5pm EDT
Jun 24th
10am–5pm EDT
This class has 3 more dates.
Tap here to see more
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.
This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft SQL Server environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course also covers Microsoft-specific T-SQL programming constructs, creation and use of stored procedures and user-defined functions, use of cursors and updateable views.
This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful stored procedures and views as well as complex queries and updates. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.
Students Will Learn:
Course Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.
Course Overview
Relational Database Fundamentals
Writing Basic SQL Queries
Creating a Database
Manipulating Query Results
Advanced Query Techniques
Manipulating Table Data Using SQL's Data Manipulation Language (DML)
User-Defined Functions
Stored Procedures
Triggers
Complex Queries
T-SQL Code Constructs
Working with Data Types and Functions
Using T-SQL Cursors
Working with Table Expressions
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.
People who viewed this class also viewed the following classes
Get quick answers from CourseHorse and past students.
HOTT delivers instructor-led technical training across the United States, Canada and the United Kingdom. Whether you attend in person, remote-live or on-demand, our classroom-based training philosophy zeroes in on your ability to work more productively and with higher quality results after training....
Read more about Hands On Technology Transfer, Inc.
This school has been carefully vetted by CourseHorse and is a verified Online educator.
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 Database
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.