Microsoft Transact-SQL Programming
- Beginner
- 18 and older
- $2,595
- (Exact location to be announced), New York, NY
- over 5 sessions
Thankfully we have 11 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.
Noble Desktop @ 185 Madison Ave, New York, NY & 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.
Apr 1st
10am–5pm EDT
May 14th
6–9pm EDT
Meets 2 Times
This class has 3 more dates.
Tap here to see more
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Enhance your SQL skills by mastering Outer Joins, NULL data, grouping, aggregate functions, filtering, and working with dates/times. Extract and analyze specific data from databases, turning raw information into valuable insights. Prerequisite: SQL proficiency equivalent to Noble Desktop's SQL Level 1 course.
Apr 2nd
10am–5pm EDT
May 21st
6–9pm EDT
Meets 2 Times
This class has 3 more dates.
Tap here to see more
Noble Desktop @ 185 Madison Ave, New York, NY & 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.
Noble Desktop @ 185 Madison Ave, New York, NY & 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.
Apr 1st
10am–5pm EDT
Meets 8 Times
May 13th
10am–5pm EDT
Meets 8 Times
May 14th
6–9pm EDT
Meets 16 Times
Noble Desktop @ 185 Madison Ave, New York, NY & 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
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
Note: Classes do not have fixed location. Prior to each class they examine the geographical location of the enrolled students and then select a venue that will provide most convenient overall access for the students. Classes are held in hotel conference rooms and exact location is determined 2 weeks prior to the course date.
Students who have taken classes at Microsoft Transact-SQL Programming have had positive experiences and feel that the courses provided them with valuable skills. They praise the well-organized and thorough curriculum, as well as the engaging and helpful instructors. Many students express a desire to take additional courses and recommend the program to their peers. Some students appreciate the option of remote attendance, as it saves them time and expenses. Overall, students feel that the combination of knowledgeable instructors and high-quality course materials contributes to their success in learning Transact-SQL programming. Direct quotes: - "The instructor and course curriculum were well organized and extremely thorough." - "The instructor was very attentive to questions I had." - "I think that you have nailed the recipe for success with your combination of instructor and course materials."
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 NYC educator.
Hands On Technology Transfer, Inc.
Chelsea, Manhattan
(Exact location to be announced)
New York, New York Chelsea, Manhattan
(Exact location to be announced)
New York, New York
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.
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.