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

Course SQL Fundamentals

27-06 till 28-06-2019
25-07 till 26-07-2019
29-08 till 30-08-2019
26-09 till 27-09-2019
24-10 till 25-10-2019
Your starting date
Region:

Audience Course SQL Fundamentals

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

Prerequisites Course SQL Fundamentals

To be able to participate in this course some familiarity with database systems is beneficial for the understanding.

Realization Training SQL Fundamentals

The theory is treated on the basis of presentations. Demos are used to clarify the theory. There is ample opportunity to practice. The course times are from 9.30 to 16.30.

Certification course 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 that is applicable in all database systems. SQL or Structured Query Language is an ANSI/ISO standard language for relational database management systems (DBMS). SQL is used for querying and modifying data in relational databases such as Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL and more. Almost every DBMS has added its own extra functions to standard SQL. In the course SQL Fundamentals participants learn to extract data from a database, to analyze it and to make reports with this data. The participants learn the structure of relational databases with tables and their relationships. Attention is paid to practical skills to write SELECT queries and UPDATE Queries. You will also learn about foreign key relationships between tables and how JOIN queries can be used to retrieve data from related tables.

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