Call us at 1-800-413-0939
Hands On Technology Transfer

Hands On SQL Query Training Across North America

Attend courses for training on SQL and Transact-SQL Querying

Looking for a complete Class Index instead? Click here.

SQL Query and Transact-SQL Querying Training Courses

The Hands On Technology Transfer SQL and T-SQL training curriculum offers a task-oriented, cost effective approach to learning universal Structured Query Language (SQL) or Microsoft's Transact-SQL (T-SQL) for working with databases. Comprehensive hands on exercises are integrated throughout to reinforce learning SQL queries and develop real competency with database querying. All SQL querying training courses consist of 50% hands-on lab exercises during class time. Courses may be attended in-person in the classroom, online from your home via live remote attendance, or through on demand training at your convenience.

SQL and T-SQL Querying Duration Price: Live DeliveryPrice: On-Demand
SQL Programming 3 days / 21 hours $1695$1495
Microsoft Transact-SQL Programming 5 days / 35 hours $2495$1495

Which Course Best Fits Your Needs?

SQL Query Training

The SQL Programming course provides training on universal Structured Query Language (SQL) that is used by many relational database management systems (RDBMS), such as MySQL, Oracle, DB2, and Microsoft SQL Server. Students will also learn fundamental relational database design concepts, so that they better understand the structure of a SQL database and can navigate them more effectively. Upon completion, participants will understand SQL syntax, functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Hands on exercises are performed throughout training each day to reinforce key concepts and develop student confidence in database querying. No prior database experience is necessary to attend this course.

Attendees who know that they will be working specifically with Microsoft SQL Server may instead be better served by taking the 5-day Microsoft Transact-SQL Programming course offered by HOTT. In addition to covering everything in the 3-day SQL Programming course, it contains an additional 2 days of coverage of T-SQL functionality that is specific to Microsoft SQL Server.

Transact-SQL Query Training

The Microsoft 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, SQL syntax, 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, and use of cursors and updateable views. Lab exercises during class utilize Microsoft SQL Server Management Studio (SSMS), and by the end of the course students will have developed both confidence and competence in their SQL database querying skills.

Attendees who are fairly certain that they will NOT be working with Microsoft SQL Server may instead be better served by taking the shorter 3-day SQL Programming course offered by HOTT. It covers SQL syntax, SQL programming skills, and database design concepts that are universal across RDBMSes (MySQL, Oracle, DB2, and Microsoft SQL Server), and forgoes coverage of T-SQL functionality that is specific to Microsoft SQL Server and therefore not applicable to other database systems.

Fantastic instructor – obviously well-versed and has a lot of real-world experience. Was able to help me apply the course material to needs at my job. Excellent instructor, excellent class.
– J.N., Mary T. Inc

HOTT provides competency-based SQL and T-SQL querying courses in more than 100 cities across North America. HOTT also offers additional SQL Server training including SQL Server Administration courses, SQL Business Intelligence training, and Power BI training. Our training emphasizes a hands on, task-oriented curriculum. When students train with HOTT they are guaranteed small class sizes, expert instructors, and comprehensive hands on exercises. HOTT offers a wide selection of discount programs to accommodate individuals as well as groups both small and large. Choose from face-to-face in the classroom, remote-live, on-demand or group training options.

If you need additional assistance in choosing a course, contact our helpful Customer Service staff at 800-413-0939, or fill out a Contact Form here. For a comprehensive list of all our course offerings, visit our full Course Index here.

Multiple Training Options - Convenience and Cost Control

Prefer training from home or the office?

Courses are available via scheduled live Remote Attendance or On Demand Training at your convenience

Looking for face-to-face training?

Attend Regularly Scheduled Courses in More than 100 Cities Across North America: