Microsoft Transact-SQL Programming
- Beginner
- 18 and older
- $2,595
- Earn 25,950 reward points
- Price Lock Guarantee
- (Exact location to be announced), New York, NY
- over 5 sessions
Thankfully we have 12 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
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 @ 185 Madison Ave, New York, NY & 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 @ 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.
May 13th
10am–5pm EDT
Meets 8 Times
May 14th
6–9pm EDT
Meets 16 Times
Jun 21st
10am–5pm EDT
Meets 8 Times
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.
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
NYIM Training @ 185 Madison Ave, New York, NY
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
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.
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.