book a course

Our Training

Build the confidence and skills you need to succeed with our practical professional development and IT courses, led by expert trainers with ongoing support.
See all courses

Explore our courses

IT & Digital Skills

Professional Development

PD Training

Build confidence, leadership, and workplace skills with our practical professional development courses. Delivered in Perth or live online, with expert trainers and ongoing support included.

read more

Explore our programs

Communication

Leadership

Project Management

Qualifications

Advance your career with nationally recognised qualifications and practical training. Delivered in Perth or live online, with expert trainers and ongoing support.
Learn More

Explore our Qualificationss

Microsoft SQL Server – Introduction

Free Post-course Support
100% Quality
Guarantee
Interactive
Learning
eCertificate of Attendance

Microsoft SQL Server – Introduction

$540per person

In Person

Location: Level 1 Cloisters, 863 Hay Street, Perth WA 6000
Time: 9:00 am to 4:00 pm
Duration: 1 Day

Join in-person at our vibrant Perth CBD training centre. Lunch and refreshments are provided for all in-person attendees. Our training centre is centrally located and easily accessible by public transport.

Course Overview

Course Overview

This one day course introduces writing SQL Queries against Microsoft’s premier database product, SQL Server. Popular graphical query tools available from Microsoft are demonstrated, as well as coding the SQL directly.
This course is best for users who want to learn about querying relational database, for programmers who want to brush up on their SQL or Excel power users who want to learn better ways of storing critical data.

Dates

Book a course

Course Information

Course Content

SQL Server Overview

  • SQL Server Overview
  • Versions of SQL Server
  • SQL Server Management Studio

Microsoft Query Tools

  • Using Microsoft Excel (Query)
  • Using Microsoft Access
  • Using Power BI
  • Learning SQL Directly

SQL Overview

  • ANSI SQL and Transact-SQL
  •  Structured Query Language
  •  Data Definition Language
  •  Data Manipulation Language
  •  Data Control Language

The Basic SELECT Statement

  •  The SELECT Statement
  •  Selecting Fields and Expressions
  •  Restricting Duplicates
  •  Specifying Criteria
  •  Logical Operators
  •  Wild Cards
  •  Considering the Query Optimiser
  •  Combining Conditions
  •  Sorting

Joining Tables

  • Join Syntax
  • Outer Joins
  • Self Joins
  • Union Queries

Summary Queries

  • Grouping Data
  • The HAVING Clause
  • Sub-Queries
  • Correlated Sub

Inserting and Copying Records

  • Inserting Records
  • Copying Data to an Existing Table
  • Copying Data to a New Table
  • Using Temporary Tables

Changing and Deleting Records

  • Changing Records
  • Updating one table based on values in another
  • Deleting Records

Programmable Objects

  • Server-Side Coding
  • Stored Procedures
  • Triggers

At the end of the course the participants will be able to connect to and write queries against any Microsoft SQL Server database using both using a graphical query tool, or through coding SQL.

Knowledge of relational database is required.

“This course was super useful. Trainer was great and easy to understand. Having this knowledge and resources will help with the developing/processing of my department” – Lee from Department of Health

“This course would make a big difference at my current role. Instructor was well spoken and imparted a lot of valuable knowledge. Overall learning experience was awesome!” – Tope from Rio Tinto

“Great course, great delivery, great facilitator, very helpful and answered additional questions. Learnt a lot, looking forward to further training” – Stacey from Hope Community Services

FAQs

No FAQs found.