Course description
The Advanced Querying Microsoft SQL Server with Transact-SQL course is designed to give delegates practical experience in using more complex Transact-SQL techniques.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Who will the Course Benefit?IT Professionals and non-technical 'power users' who are required to implement more complex Transact-SQL queries.
Course ObjectivesTo provide more advanced coding skills for those already familiar with using basic Transact-SQL or as a follow-on course for those who have previously attended the Querying Microsoft SQL Server with Transact-SQL course.
Upcoming start dates
Suitability - Who should attend?
A working knowledge of SQL is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite Querying Microsoft SQL Server with Transact-SQL course.
Experience to the level as demonstrated in this course is recommended:
- Querying Microsoft SQL Server with Transact-SQL
Training Course Content
Advanced Querying Microsoft SQL Server with Transact-SQL Training Course
Course Contents - DAY 1
Course Introduction- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Creating and using Views
- Using Inline Table-Valued Functions
- Using Derived Tables
- Using Common Table Expressions
- Using PIVOT and UNPIVOT in Queries
- Working with GROUPING SETS
- Using ROLLUP, CUBE,GROUPING and GROUPING_ID
- Using Window AGGREGATE functions in Queries
- Using Window RANK functions in Queries
- Using Window OFFSET functions in Queries
Course Contents - DAY 2
Session 4: CREATE AND MANAGE TABLES- Creating tables
- Datatypes and Constraints
- Altering and Dropping tables
- Creating temporary tables
- Copying tables
- Creating and using Sequences and Synonyms
- Obtaining metadata
- Index types
- Creating indexes
- Performance considerations
- Filtered indexes
- Indexes on View
- Indexes with INCLUDE
- Dropping indexes
- Obtaining metadata
- INFORMATION_SCHEMA views
- Sys views
- Comparison between INFORMATION_SCHEMA and sys views
- Obtaining metadata in SSMS
- Factors in Query Performance
- Displaying Query Performance Data
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Reviews
Average rating 4.9
Good course and help from Kevin. Would have been better if there was time for practical work.
Great course delivery by quality tutor but high pace course because the course is just for one day. It would be better to deliver the course over 2 days.
Continuing Studies
Further Learning
- Programming Microsoft SQL Server with Transact-SQL
Request info
Why StayAhead. From a single person on a scheduled course to large scale training projects StayAhead Training have the expertise and experience to help. Established since 1992, StayAhead Training is recognised as one of the leading independent IT Training specialists...
Fantastic course, clearly delivered by John - I just need to practice now!