SAVE – Special Offers – Click Here...
Latest News
SAVE – Special Offers – Click Here...

SQL Query Language Intro

Enquire About This Course

We are currently delivering Online SQL Query Language training via our Virtual Classroom - see our websites for more info:

https://www.mullanvirtualtraining.co.uk

https://powerbi-trainingbelfast.co.uk

Course Synopsis

The goal of this SQL training course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™.

Mullan Training delivers courses in SQL Query Language Intro using

  • SQL Server 2005
  • SQL Server 2008
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2018

Course Objectives

On completion of this SQL Server training course, delegates should be able to:

  • Describe the uses of and ways to execute the Transact-SQL language.
  • Use querying tools.
  • Write queries to retrieve data.
  • Group and summarize data by using Transact-SQL.
  • Join data from multiple tables.
  • Modify data in tables.
  • Query text fields with full-text search.
  • Describe how to create programming objects.

Intended Audience

This SQL training course is intended for:

  • SQL Server database administrators
  • SQL Server implementers
  • SQL Server system engineers
  • SQL Server developers
  • IT professionals who are responsible for writing Transact SQL queries for SQL Server.

Course Prerequisites

Before attending this course, delegates are expected to have:

  • Experience using a Microsoft Windows operating system.

An understanding of basic relational database concepts, including:

  • Logical and physical database design
  • Data integrity concepts
  • Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many)
  • How data is stored in tables (rows and columns).
  • Familiarity with the role of the database administrator.

Click here to download:

SQL-Query Language-Introduction

Enquire About This Course
Latest News
SAVE – Special Offers – Click Here...