Code: DAT100
Duration in days: 2
Download: Infosheet
€ 999

Course SQL Fundamentals

25-10 till 26-10-2018
29-11 till 30-11-2018
20-12 till 21-12-2018
20-12 till 21-12-2018
24-01 till 25-01-2019
Your starting date
Region:

Audience SQL Fundamentals Course

Course SQL FundamentalsThe course SQL Fundamentals is aimed at a wide audience of system administrators, end users of Office applications and novice programmers without knowledge of databases who wish to learn to access relational databases efficiently using queries in Structured Query Language (SQL).

Prerequisites Course SQL Fundamentals

To participate in this course has some familiarity with database systems is desirable.

Realization Training SQL Fundamentals

The theory will treated using presentation slides. Demos are used to illustrate the theory. There is ample opportunity to practice. The course times are from 9.30 up and to 16.30.

Certification SQL Fundamentals

Participants receive an official certificate SQL Fundamentals after successful completion of the course.

Contents Course SQL Fundamentals

In the course SQL Fundamentals participants learn the generic ANSI SQL standard. This standard can be used in a variety of databases, such as Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL and other relational databases. This course is designed for people who wish to acquire the skills necessary to retrieve data from a database to analyze and create reports with these data. Participants learn what relational databases are and how we can use them. In particular you will learn the practical skills to write queries like SELECT queries and UPDATE queries. You will also learn what relationships are and how they can be used to capture the structure of the data.

Module 1 : SQL Intro

Module 2 : Select Queries

Module 3 : SQL Data Definition

What is SQL?
History of SQL
SQL Standard
SQL Parts
Environment
Relational Databases
Normalisation
Data Types
Database Creation
DDL Create Table
Data Types
Language Elements
DML Insert Into
SQL Errors
Select Query
Query Structure
SELECT .. FROM
Options SELECT .. FROM
SELECT DISTINCT
WHERE Clause
Comparison Operators
Logical AND and OR
Aggregate Functions
LIKE Condition
BETWEEN .. AND Condition
IN Condition
IS NULL Condition
ORDER BY Clause
GROUP BY Clause
HAVING Clause
CREATE Statements
Schema and Table Creation
Data Types
Numeric Types
Binary Data Types
String Data Types
Temporal Data Types
Integrity Constraints
Keys
Not Null
Foreign Keys
Update and Delete
Check Contraint
ALTER Table
DROP Table

Module 4 : Functions

Module 5 : Data Manipulation

Module 6 : Joins

Standard Functions
Mathematical Functions
String Functions
Conversion Functions
Single Row Functions
Case Manipulation Functions
Character Manipulation Characters
Numeric Functions
Date Functions
Converting Text Dates
General Functions
Multiple Row Functions
Aggregate Functions
Formatting Numbers
Insert Statement
Data Insertion
Update Statement
Updating Table Rows
Deleting Table Rows
Deleting and Foreign Keys
Transactions
Commit and Rollback
Implicit rollbacks
Implicit commits
Explicit rollbacks
Explicit commits
Savepoints
Subqueries
What are Joins?
ANSI Join Syntax
Cross Join
Inner Join
Table Aliases
Natural Join
Left Join
Right Join
Full Join
Full Outer Join
Left Excluding Join
Right Excluding Join
Outer Excluding Join

Kantooradres:
SpiralTrain BV

Gebouw "De Sijnsmeester"
Standerdmolen 8 – 1.11
3995 AA Houten

IP Computer Training Centrum
Diemerhof 32-36
1112 XN Diemen

020 7600027
http://www.ip-computer-training-centrum.nl

Compu Act Opleidingen
Slinge 303
3085 ER Rotterdam

023 - 551 3409
www.computertraining.nl

Trainspot
Kleine Singel 33
3572 CG Utrecht

030 - 737 05 81
http://www.trainspot.nl

IP Computer Training Centrum
Leenderweg 292
5644 AE Eindhoven

040 - 256 65 20
http://www.ip-computer-training-centrum.nl