KLA-SQL - Mastering Databases with SQL (SQL)

DURATION
4 days

OBJECTIVES
The aim of this course is to provide rock solid knowledge about databases world, about their working principles, about their logical structure and about SQL programming language.
By the end of this course attendees will be able to manage a relational database in all respects: database creation, tables populating, complex queries writing for data extraction.

PREREQUISITES
There aren’t any special needed skills, except for a familiarity with required software installing, in order to take part to practical section of the course.

WHO SHOULD ATTEND
The course is addressed to anyone who’s interested in understanding databases working principles and especially in SQL syntax. Deep knowledge of this language is fundamental for anybody is going to develop an application capable of interacting with a database

TOPICS
Day 1:
Introduction to databases
-What’s a hierarchical DB
-What’s a relational DB
-What’s DBMS
-RDBMS: relational DBs
-Structured Query Language (SQL)
-Today database scenarios and applications
Main commercial & open source SQL database solutions overview
-MySQL (Oracle MySQL)
-MariaDB
-Firebird SQL
-PostgreSQL
-Oracle database
-IBM DB2
-Microsoft SQL Server and SQL Server Management Studio console
-Environment set up for practising
Day 2:
Database architecture
-Tables
-Fields
-Data types
-Records
-Primary key
Tables management
-Table creation by GUI
-Table creation by command line
-Data insertion by GUI (INSERT command)
-Data insertion by BCP
-Data updating
-Data deleting
-Views and indexes
Day 3:
Querying tables
-Basic QUERY: SELECT - FROM
-Conditional QUERY: SELECT – FROM – WHERE
-Conditional operators
-Arithmetic operators
-Comparison operators
-Relational operators
-Chars operators
-Concatenation operators
-Logical operators
-Set operators
-Special operators
Day 4:
Functions, sorting, security risks
-Time function
-Arithmetic function
-Trigonometric function
-Results sorting
-SQL injection

Multiple tables managements
-Multiple tables combination (JOIN command)
-SUBQUERY and nested SUBQUERY

Lab Exercises:
Every illustrated functionality will be tested on expressly created tables during this course.