Show findcourses.com as: Mobile

Microsoft Transact-SQL Programming

Hands On Technology Transfer, Inc.
Training overview
Professional Course
Webinar, Self-paced Online, Virtual Classroom
35 hours (live)/30 days (on-demand)
From 1,495 USD
Start dates
Online
1,495 USD
Inquire for more information

Online
1,495 USD
Start anytime

Online
1,495 USD
Start anytime

Course description

Microsoft Transact-SQL Programming

This 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 who need to construct queries using 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.

Who should attend?

General computer knowledge is required when learning T-SQL.

Training content

  • Relational Database Fundamentals
  • Creating a Database
  • Advanced Query Techniques
  • User-Defined Functions
  • Triggers
  • T-SQL Code Constructs
  • Using T-SQL Cursors
  • Writing Basic SQL Queries
  • Manipulating Query Results
  • Manipulating Table Data Using SQL's Data Manipulation Language (DML)
  • Stored Procedures
  • Complex Queries
  • Working with Data Types and Functions
  • Working with Table Expressions

Course delivery details

Delivery Options: Attend face-to-face in the classroom,remote-live or via on-demand training.

Certification / Credits

  • Designing normalized table structures for relational databases
  • Creating databases and tables
  • Using primary and foreign keys
  • Writing SQL queries
  • Using inner and outer joins
  • Using set operators (UNION, INTERSECT, EXCEPT)
  • Using DML for SELECT, INSERT, UPDATE, DELETE
  • Using subqueries
  • Using triggers and stored procedures
  • Using aggregate functions to return totals and subtotals
  • Programming features of T-SQL
  • Table expressions
  • T-SQL specific data types and functions
  • T-SQL cursors

About HOTT

Hands On Technology Transfer, Inc.

Hands On Technology Transfer (HOTT) was established in 1995 and has always had the same mission: to provide the best possible IT training and always assure that students attain competence and confidence in the skills being taught. HOTT’s innovative approach...


Read more and show all training delivered by this supplier

Contact this provider

Fill out your details to find out more about Microsoft Transact-SQL Programming.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

Hands On Technology Transfer, Inc.


 Show phone number
www.traininghott.com


Contact provider

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

Training reviews

No reviews available

Need help with your search?

findcourses.com offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote