Opleiding: English Delivery Only: Introduction to SQL [STA_ISQL]

OVERVIEW

*** Course delivered in English (UK - (GMT)) ***

Introduction to SQL Course Overview

The Introduction to SQL course is designed to give delegates practical experience in using ANSI standard SQL. As it is a generic course,some of t

OBJECTIVES

Course Objectives

To provide the knowledge and skills needed to retrieve data held in a relational database.

AUDIENCE

Who will the Course Benefit?

Anyone who needs to understand and use SQL to manipulate a database.

There are no formal pre-requisites for this Introduction to SQL course,although an understanding of databases and exposure to information technology in general would be useful.

NEXT STEP

Further Learning

  • Oracle SQL
  • SQL for PostgreSQL
  • Querying Microsoft SQL Server with Transact-SQL
  • Introduction to MySQL
  • Introduction to MariaDB

CONTENT

Introduction to SQL Training Course

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: RELATIONAL DATABASE CONCEPTS

  • What is a Relational Database?
  • Relational Database Structures
  • Tables,Rows and Columns
  • Indexes,Primary Keys and Foreign Keys
  • Data Types
  • The Data Dictionary

Session 2: RETRIEVING DATA WITH THE SELECT STATEMENT

  • The SELECT Statement
  • The SELECT and FROM Clauses
  • Conditions and the WHERE Clause
  • Other Conditional Operators
  • Logical Operators
  • The ORDER BY Clause
  • Column Aliases
  • Arithmetic Operations
  • Precedence of Operators

Session 3: AGGREGATE FUNCTIONS

  • Overview of Built in Aggregate Functions
  • The GROUP BY Clause
  • The HAVING Clause

Session 4: JOINING TABLES

  • Overview of Table Joins
  • Inner Joins
  • Table Aliases
  • Outer Joins
  • Self Joins
  • ANSI Standard Joins

Session 5: BASIC SUBQUERIES AND SET OPERATORS

  • Overview of Subqueries
  • Basic Subqueries
  • Set Operators
Meer...
€738
ex. BTW
Aangeboden door
Global Knowledge Network Netherlands B.V.
Onderwerp
SQL
Engels
Niveau
Looptijd
1 dag
Taal
nl
Type product
cursus
Lesvorm
Klassikaal
Aantal deelnemers
Max: 16
Tijdstip
Overdag
Keurmerken aanbieder
Cedeo
CRKBO en BTW-vrijstelling
VOI
EXIN
ISO register
Microsoft Learning Partner
VMWare Partner
Oracle Education Partner
AgilePM - Agile Project Management (APMG)
ASL