Menu
  • All Courses
    • Accounting
    • Aged Care
    • Agile
    • Agriculture
    • Alcohol & Other Drugs
    • Allied Health
    • Animal Care
    • Animal Science
    • Arts
    • Automotive
    • Beauty
    • Bookkeeping
    • Building & Construction
    • Business
    • Business Administration
    • Business Development
    • Business Operations
    • Carpentry
    • Celebrancy
    • Change Management
    • Child Care
    • Cisco
    • Cloud Computing
    • Coding
    • Community Services
    • Compliance & Risk
    • Conservation & Land Management
    • Counselling
    • Criminal Justice & Psychology
    • Culinary Arts
    • Customer Engagement
    • Cyber Security
    • Dance
    • Data Science & Analytics
    • Dental Assisting
    • Design
    • Digital Marketing
    • Digital Media
    • Disability
    • Dog Training
    • Education
    • Education Support
    • Engineering
    • Entrepreneurship
    • Event Management
    • Eyebrow Specialist
    • Eyelash Extension
    • Finance
    • Financial Planning
    • Government
    • Graphic Design
    • Hairdressing
    • Health
    • Health Admin
    • Health Science
    • Health Services Assistance
    • Herbal Medicines
    • Horse Breeding & Equine Studies
    • Horticulture
    • Hospitality
    • Human Resources
    • Interior Design
    • IT
    • Language
    • Leadership & Management
    • Legal
    • Life Coaching
    • Logistics
    • Makeup
    • Management
    • Manufacturing
    • Marketing
    • Massage
    • MBA
    • Mental Health
    • Microsoft
    • MYOB
    • Nail Technology
    • Natural Therapies
    • Naturopathy
    • Networking
    • Nursing
    • Nutrition
    • Nutritional Medicine
    • Organisational Development
    • Payroll
    • Pet Grooming
    • Pharmacy
    • Photography
    • Plumbing
    • PMBOK
    • Practice Management
    • PRINCE2®
    • Professional Development
    • Programming
    • Project Management
    • Psychology
    • Real Estate
    • Retail
    • Sales
    • Science
    • Security
    • Small Business
    • Social Media Marketing
    • Social Science
    • Software
    • Sports & Fitness
    • Supply Chain Operations
    • Sustainability
    • Systems Administration
    • Tourism
    • Training & Assessment
    • Travel
    • User Experience Design
    • UX/UI
    • Veterinary Nursing
    • Web Design
    • Web Development
    • Wedding Planning
    • Work Health & Safety
    • Xero
    • Youth Work
    • View All Courses
  • Search Courses
  • Online Courses
  • Education Providers
  • Workforce Training
  • TAFE Directory
  • Student Hub
  • Contact Us
  • About Us
  1. Home
  2. IT
  3. Certified Ethical Hacker
  4. Querying Data with Transact-SQL
Get A Free Course Guide

Querying Data with Transact-SQL Microsoft 20761

Study Method
Virtual
Provider
DDLS
Start Date
Enrol anytime
DDLS Courses

Course Overview

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.

Read Less

Who's It For?

The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

What You'll Learn

After completing this course, students will be able to:

  • Describe key capabilities and components of SQL Server 2016
  • Describe T-SQL, sets, and predicate logic
  • Write a single table SELECT statement
  • Write a multi-table SELECT statement
  • Write SELECT statements with filtering and sorting
  • Describe how SQL Server uses data types
  • Write DML statements
  • Write queries that use built-in functions
  • Write queries that aggregate data
  • Write subqueries
  • Create and implement views and table-valued functions
  • Use set operators to combine query results
  • Write queries that use window ranking, offset, and aggregate functions
  • Transform data by implementing pivot, unpivot, rollup and cube
  • Create and implement stored procedures
  • Add programming constructs such as variables, conditions, and loops to T-SQL code

Study Method

  • Virtual
    Virtual Delivery - Live and interactive classroom-style learning conducted completely online
  • Blended
    Blended delivery - both online course content and partial face to face requirements
  • In-class
    In class delivery - predominately face to face course content conducted at a specific location
  • Online
    Online delivery - online course content with the exception of assessments and work placement

Duration and Study Load

  • 5 days

Entry Requirements

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of relational databases
Find out more about the entry requirements for this course
Get the Course Guide

Subjects

Core Modules
Introduction to Microsoft SQL Server 2016

This module introduces SQL Server, the versions of SQL Server, including cloud versions, and how to connect to SQL Server using SQL Server Management Studio.

Lessons

  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
Introduction to T-SQL Querying

This module describes the elements of T-SQL and their role in writing queries. Describe the use of sets in SQL Server. Describe the use of predicate logic in SQL Server. Describe the logical order of operations in SELECT statements.

Lessons

  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
Writing SELECT Queries

This module introduces the fundamentals of the SELECT statement, focusing on queries against a single table.

Lessons

  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions
Querying Multiple Tables

This module describes how to write queries that combine data from multiple sources in Microsoft SQL Server 2016.

Lessons

  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
Sorting and Filtering Data

This module describes how to implement sorting and filtering.

Lessons

  • Sorting Data
  • Filtering Data with Predicates
  • Filtering Data with TOP and OFFSET-FETCH
  • Working with Unknown Values
And more!
Want more information about the subjects for this course?
Get the Course Guide

Payment Options

Please enquire for information about the price of the course and payment options available.

Why is the price not displayed here?

The price of the course may vary for a number of reasons, including but not limited to:

  • Whether you pay up front or via a payment plan
  • Whether Government funding is available
  • Your location
  • Study method and duration

Complete an enquiry to discuss the price of the course and payment options with a course advisor.

About DDLS

DDLS is Australia’s largest provider of corporate IT and process training, with the largest portfolio of strategic partners and courses in Australia. We partner with world-class companies to help organisations and individuals in the IT industry remain up-to-date with new processes, technology and platforms to reduce risk and enable efficient business practices. We have convenient locations in almost every capital in Australia as well as the Philippines, flexible delivery modalities, industry-accredited trainers, and state-of-the-art course material and labs to produce the highest quality learning outcomes for our clients.

DDLS promotes a balanced approach to training with a focus on the key areas of Technology, Process and People. We provide extensive training options tailored to your organisation’s needs – from vendor-certified courses to customised training, including bespoke in-house developed courses.

Study Method

  • Virtual
    Virtual Delivery - Live and interactive classroom-style learning conducted completely online
  • Blended
    Blended delivery - both online course content and partial face to face requirements
  • In-class
    In class delivery - predominately face to face course content conducted at a specific location
  • Online
    Online delivery - online course content with the exception of assessments and work placement

Want to Know More About This Course?
Complete the form and learn about:

  • Pricing and payment options
  • Start dates
  • Subjects
  • Study Method
  • How to get help and contact information
  • Everything you need to know before enrolling!

Who is this course for?

Individual Individual
I'm studying for personal growth or development
Business Business
I'm looking for courses for on-the-job training or on behalf of an organisation

Get more information on this course with:

  • Unbiased course advice
  • You'r seconds away from finding the perfect course
  • We've helped over 400,000 people apply

"All details and info was there and my query was answered quicly."

Soula M.

Get more information on this course with:

  • Unbiased course advice
  • You'r seconds away from finding the perfect course
  • We've helped over 400,000 people apply

Want to Know More About This Course?

Get your free course guide now! Complete this easy form and you'll also receive a course consultation with DDLS

By submitting this enquiry I accept the "Privacy Policy" and "Terms of Use"

"All details and info was there and my query was answered quicly."

Soula M.

Receive a consultation from a course expert

See student testimonials below

"I found the website easy to use and the contact I received after my enquiry was good. Not too pushy but there if I needed them." - Dimity G.
"All details and info was there and my query was answered quickly." - Soula M.
"Gave me everything I needed and someone called me, pretty much straight away." - Marlon T.
  • Popular Subjects
  • Qualification Levels
  • Government Funded Courses
  • Job Outcomes
  • Accounting
  • Aged Care
  • Agriculture
  • Animal Care
  • Beauty
  • Bookkeeping
  • Business Administration
  • Child Care
  • Community Services
  • Counselling
  • Disability
  • Education
  • Eyelash Extension
  • Health
  • IT
  • Mental Health
  • MYOB
  • Small Business
  • Veterinary Nursing
  • Xero Courses
  • View More
  • Certificate
  • Certificate II
  • Certificate III
  • Certificate IV
  • Diploma
  • Bachelor
  • University
  • Online Courses
  • Short Courses
  • View More
  • Adelaide
  • Brisbane
  • Canberra
  • Melbourne
  • Perth
  • Tasmania
  • Victoria
  • Western Australia
  • View More
  • Aged Care Worker
  • Allied Health Assistant
  • Bookkeeper
  • Business Analyst
  • Childcare Worker
  • Counsellor
  • Data Analyst
  • Dental Assistant
  • Disability Support Worker
  • Dog Groomer
  • Massage Therapist
  • Nail Technician
  • Naturopath
  • Pharmacy Assistant
  • Real Estate Agent
  • Social Worker
  • Support Worker
  • Teachers Aide
  • Youth Worker
  • View More

Newsletter sign up

We'll email you updates on job trends, career advice, study tips, news and more.
Copyright © 2022 Training.com.au Contact About Privacy Terms

Newsletter Sign Up

We’ll email you updates on job trends, career advice, study tips, news and more.

  • This field is for validation purposes and should be left unchanged.