K Labs mette a tua disposizione i propri Trainers Certificati, i Laboratori Didattici, i Simulatori di Esame, il proprio Test Center e un Tutor a te dedicato per la preparazione all'esame.
Grazie al nostro supporto la percentuale di candidati che ottengono la certificazione al primo tentativo è prossima al 100%.
.jpeg "fabio-oyxis2kalvg-unsplash (1).jpeg")
Rimani aggiornato sulle novità formative.
Lasciaci la tua e-mail!
Rimani aggiornato sulle novità formative.
Lasciaci la tua e-mail!
DATA ENGINEERING
Seguendo uno dei corsi di questa categoria e superando il relativo test di valutazione delle competenze, otterrai il CERTIFIED ENGINEER Digital Badge "Data Engineering" che potrai condividere sui tuoi Social Networks preferiti.
©2024 K LABS Srl - TUTTI I DIRITTI RISERVATI
©2024 K LABS Srl - TUTTI I DIRITTI RISERVATI
FOLLOW US
FOLLOW US
Mastering Databases with SQL (SQL)
DATA ENGINEERING DIGITAL TRANSFORMATION
NewCondition € 1600.00
Pre-Order
Pre-Order
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.
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.
