Microsoft Introduction to SQL Databases

by CM Training Claim Listing

This course draws content from both Microsoft 10985 – Introduction to SQL Databases and Microsoft 20761 – Querying Data with Transact-SQL 2016

$2391

Contact the Institutes

Fill this form

Advertisement

CM Training Logo

img Duration

3 Days

Course Details

This course draws content from both Microsoft 10985 – Introduction to SQL Databases and Microsoft 20761 – Querying Data with Transact-SQL 2016.

 

 

After completing this course, students will be able to:

  • Describe key database concepts in the context of SQL Server 2016.
  • Describe the effects of database design on performance.
  • Describe commonly used database objects.
  • Describe key capabilities and components of SQL Server.
  • Describe T-SQL, sets, and predicate logic.
  • Write a single table Select statement.
  • Write a multi-table Select statement.
  • Write elect statements with filtering and sorting.
  • Describe how SQL Server uses data types.
  • 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.
  • Melbourne CBD Branch

    Level 14/380 St Kilda Rd, Melbourne CBD, Melbourne
  • Melbourne CBD Branch

    440 Collins Street, Melbourne CBD, Melbourne
  • Brisbane CBD Branch

    Level 3 & 24, 288 Edward Street, Brisbane CBD, Brisbane
  • Sydney CBD Branch

    Level 11,12,13 & 15, 60 Margaret Street, Sydney CBD, Sydney
  • Canberra Central Branch

    Level 2, 10 Moore Street, Canberra Central, Canberra
  • Adelaide City Centre Branch

    Level 1, 80 King William Street, Adelaide City Centre, Adelaide
  • Perth CBD Branch

    Parmelia House, Ground Floor & Level 4, 191 St Georges Terrace, Perth CBD, Perth

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy