SQL Fundamentals

SpiralTrain BV

In the course SQL Fundamentals the widely used and generic query language SQL is discussed.

Price

from €1,399

Level

Not specified

Kind

Training

Subject

Automation and IT, Training and education

More information and registration at SpiralTrain BV

Description

SQL Intro The course SQL Fundamentals starts with a treatment of the SQL Standard. The structure of relational databases with tables and their relationships is covered. SQL can be used in many database systems such as Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL and more. Almost every DBMS has also added its own extra functions to standard SQL. Select Queries Next attention is paid to practical skills to write SELECT queries. This also includes clauses such as WHERE, ORDER BY, GROUP BY, HAVING, LIKE and BETWEEN .. AND. Data Types Then it is time for the different data types used in the SQL language such as numeric, binary and string types. The data types related to dates and time are treated. And the SQL CREATE TABLE statement with which tables are created is discussed as well. Functions Part of the program of the course is also the treatment of various functions that are part of the SQL Standard. Among others mathematical, conversion and aggregation functions for calculating sum and average are covered. Data Manipulation Adding and adjusting data by means of INSERT and UPDATE statements is discussed next.