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

StreamTech Knowledge Logo

Administering Microsoft® SQL Server

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database

by StreamTech Knowledge [Claim Listing ]
Intersect Logo

Databases And SQL

In this introductory course you will learn the basics of databases and SQL using the researcher-focused training modules from the highly regarded Software Carpentry Foundation.

by Intersect [Claim Listing ]
NobleProg Australia Logo

HBase For Developers Training Course

This course introduces HBase – a NoSQL store on top of Hadoop.  The course is intended for developers who will be using HBase to develop applications,  and administrators who will manage HBase clusters.

by NobleProg Australia [Claim Listing ]
NobleProg Australia Logo

MySQL Developer Training Course

MySQL is an open-source relational database management system (RDBMS) that provides a platform for structured query language (SQL) for managing and manipulating databases.

by NobleProg Australia [Claim Listing ]
Nexacu Software Skill Training Logo

SQL Beginner Course

Use SQL to access and query your data. A crucial skill for anyone working with data is the ability to access and analyse that data. Structured Query Language (SQL) enables users to access data from databases, combine data from multiple

by Nexacu Software Skill Training [Claim Listing ]

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