SQL Query Language Intro

Enquire About This Course

We are currently delivering Online SQL Query Language training via our Virtual Classroom:

• Visit our new website for more info on Course Content & Dates
• mullanittraining.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 SSMS (SQL Server Management Studio)

 

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