Delivery Options: Attend face-to-face in the classroom, remote-live or via on-demand training.
Face-to-face or remote-live: $1695
On-demand: $1495
Discounts: We offer multiple discount options. Click here for more information.
Face-to-face or remote-live: 3 Days
On-demand: Approximately 21 hours of coursework with personal facilitation, to be completed in a four week span.
Course Description
This SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This SQL developer training class is intended for analysts, developers, designers, administrators, and managers who need to exploit the power of the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write advanced SELECT, INSERT, UPDATE and DELETE statements. Comprehensive hands on exercises are integrated throughout this SQL programming class to reinforce learning and develop real competency.
Students who require coverage of Microsoft-specific features including T-SQL data types, stored procedure enhancements, intrinsic functions, T-SQL cursors and table-valued functions should attend the Microsoft Transact-SQL Programming course rather than this course.
Course Prerequisites
General computer knowledge is required to learn SQL.
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
|
Working with Table Expressions
|
Reviews
We went with remote attendance and I believe it was the best class I have ever taken! Everything from receiving the equipment to attending the Fairfax, VA in class room class remotely was easy, non-stressful, and enjoyable. I was new to the course material as I had little experience in SQL. The course was easy to follow and learn the concepts then apply them in the lab work. The lab work had the most value for me because you were able to actually apply the concepts you were reading about. Lastly the remote course felt like we were there in the classroom. I will definitely keep HOTT in mind for any future training needed.
— S.K., NJM Insurance Group
I thought the class was very well done. I especially appreciated the hands on labs using computers. It was beneficial to see the code actually execute. Hands on training is the only way to learn SQL.
— S.B., FYI Solutions
This was the best SQL class I have been to. The instructor did an excellent job. He presented the material in a way that ensured everyone in the class was following along. I thought the learning material was well designed. I would recommend this class to my peers.
— G.G., Kaplan University
I want to first thank you for the training last week on SQL Programming. This was the most beneficial training I have ever received. I learned so much and have already been able to put a majority of it into use at my job. You did a great job explaining everything and answering all of my questions. I cannot thank you enough and express my gratitude on how valuable it was for me. I have already had experience in doing a self-join on a table, sub-queries, altering procedures, scalar and aggregate functions, and today I was able to use some of these to write a query that I put into a command in Crystal where I was able to create a report. Thanks!
— C.W., HTRI
Was surprised how much the class covered in 3 days! Very helpful.
— D.K., Hitachi Vantara
Course Schedule
Choose a city below to view a schedule and registration options. If you have any questions, please call us at 978-250-4299 between 9:00 am - 5:00 pm EST.
Northeast/New England
Southeast
Midwest
West/Southwest
Copyright© Hands On Technology Transfer