SQL (Structured Query Language) provides a standard syntax that is used to communicate with virtually any modern relational database. SQL is not used to solve algorithmic programming tasks; rather, it is normally used within an application to retrieve data from and store data to a database. Even when using database access frameworks that shield programmers from coding SQL syntax directly, knowledge of SQL is useful in architecting and understanding any database application.
Hands On Technology Transfer's SQL Programming course teaches students relational database fundamentals and SQL programming skills. Upon completion, participants will understand SQL 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.
The Microsoft Transact-SQL Programming course covers T-SQL programming constructs, predefined data types including XML, deployment of stored procedures and triggers, CLR integration, use of the Service Broker, use of Views, and transaction locking. Additional topics covered include relational database architecture, database design techniques, and simple and complex query skills.
HOTT offers competency-based SQL programming courses in more than 100 cities across North America. HOTT 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. Call our registrars at 800-413-0939 for detailed information or assistance.
SQL Programming Courses
SQL Server 2014 Courses
SQL Server 2016
SQL Server 2017 Courses
Copyright© Hands On Technology Transfer, Inc.