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

Check out more SQL Server courses in Australia

NDA Tasmania Logo

SQL (Intro)

On completion of this course, attendees will be able to use SQL to develop complete computer reporting systems without writing a line of programming code. You should come to this course if your work involves the storage and retrieval of lists of information capable of being queried.

by NDA Tasmania [Claim Listing ]
Prog360 Logo

MySQL DBA

MySQL Training and Certification focuses on the Core Concepts & Advanced Tools and techniques to manage data and administer the MySQL Database.

by Prog360
Skill Finder Logo

Advanced Database Administration

Develop queries in SQL to create databases, tables and indexesDevelop queries in SQL that create views.Develop queries in SQL that create stored proceduresUnderstand concurrent database processing through the use of transactions and locking.Develop queries in SQL that create functions

by Skill Finder [Claim Listing ]
IFA Australia - Institute for Financial Analysts Australia Logo

T-SQL Create Select Queries

T-SQL Create Select Queries course is offered by IFA Australia - Institute for Financial Analysts Australia. Our program structure and content has been researched by consultation with industry CFO’s. The courses are written and delivered by experts in their field.

by IFA Australia - Institute for Financial Analysts Australia [Claim Listing ]
NextTech Learning Logo

Updating Your Skills To SQL Server 2017

This two-day instructor-led course is aimed at database professionals looking to update their skills to cover SQL Server 2017.

by NextTech Learning [Claim Listing ]

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