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...
Contact this provider
Contact info
Hands On Technology Transfer, Inc.
Have a question about this course? Fill out this form and the provider will get in touch with you shortly
No reviews available
Need help with your search?
findcourses.com offers a free consultancy service to help compare training for you and your team
