- Tutor is available to students
Querying Data with Transact-SQL
Official Microsoft On-Demand Course featuring Live Labs and Exams
Training Deals
Summary
Overview
Microsoft on-demand uses high-quality video, hands-on labs and knowledge-checking assessments to improve your Microsoft technical skills.
Created and presented by Microsoft experts, Microsoft On-Demand provides accurate content to help you develop – no matter your schedule.
Benefits include:
- Official Microsoft content
- 90 days access to suit your schedule
- Learn anytime, anywhere at your own pace
- Save on travel costs
- Participate in virtual lab environments
- Reinforce learning with assessments
- Access content around the clock
It's Simple:
- Purchase your Microsoft On-Demand product
- Receive an access code
- Login and start learning
- Finish your course and save or print your certificate
Description
This course was designed to give students a thorough understanding of the Transact-SQL language which is used by all SQL Server-related disciplines. These include Database Administration, Database Development and Business Intelligence. The course is aimed at Database Administrators, Database Developers and BI professionals.
Course Content
- Module 1: Introduction to Microsoft SQL Server 2016
- Module 2: Introduction to T-SQL Querying
- Module 3: Writing SELECT Queries
- Module 4: Querying Multiple Tables
- Module 5: Sorting and Filtering Data
- Module 6: Working with SQL Server 2016 Data Types
- Module 7: Using DML to Modify Data
- Module 8: Using Built-In Functions
- Module 9: Grouping and Aggregating Data
- Module 10: Using Subqueries
- Module 11: Using Set Operators
Who is this course for?
This course is designed for anyone who wants to advance their knowledge of SQL
Requirements
Students should have a working knowledge of relational databases and basic knowledge of the Windows operating system and its core functionality.
Career path
Candidates can complete a number of roles after completion such as SQL Database Admins.
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.