Express-SkillsTM:SQL

Rezound

Short course

In Sheffield

£ 199 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Short course

  • Location

    Sheffield

  • Duration

    1 Day

•Introduction to RDBMS Concepts. Relational Database Design Overview. Understanding SQL Concepts including DML, DDL and DCL. Retrieving and Sorting Data. Filtering Data. Utilising Calculated Fields. Data Manipulation Functions. Grouping and Summarising Data. Introduction to Subqueries. Joining Tables Concepts. Combining Multiple Queries. Inserting, Deleting and Modifying Data. Advanced Topics Introduction. Suitable for: This course is pertinent to IT professionals including IT managers, database administrators, infrastructure technicians and application developers who require the skills to query and manipulate relational databases.

Facilities

Location

Start date

Sheffield (South Yorkshire)
113 Arundel Street, S1 2NT

Start date

On request

About this course

The learner should be IT literate, have attained a reasonable level of numeracy, have a logical approach and have utilised at least one operating system at an intermediate level.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course Outline

Introduction to RDBMS Concepts

  • Relational Database Management System Concepts
  • Examples of Commercial RDBMS including SQL Server, Oracle and MySQL

Relational Database Design Overview

  • Entity Modelling
  • Datatypes

Understanding SQL

  • Overview of DML, DDL and DCL

Retrieving and Sorting Data

  • Using Wildcard Filtering
  • SELECT Statement
  • ORDER BY Statement

Filtering Data

  • WHERE Clause Operators
  • Wildcard Filtering

Utilising Calculated Fields

  • Concatenating Fields
  • Using Aliases

Data Manipulation Functions

  • Numeric
  • Text
  • Datetime

Grouping and Summarising Data

  • GROUP BY Clause
  • Aggregate Functions

Introduction to Subqueries

  • Purpose of Subqueries
  • Writing Subqueries
  • Filtering using Subqueries

Joining Tables

  • Concepts of Joining
  • JOIN Statement

Combining Multiple Queries

  • UNION Statement

Inserting, Deleting and Modifying Data

  • INSERT Statement
  • UPDATE Statement
  • DELETE Statement

Advanced Topics Introduction

  • Views
  • Stored Procedures
  • Transactions
  • Permissions

See related categories

Express-SkillsTM:SQL

£ 199 + VAT

The best SQL Server courses

See all

See all