K Labs goes along with you providing you with its Certified Trainers, Training Laboratories, Exam Simulators, the Test Center and a dedicated Tutor that helps you to prepare for the exam.
Thanks to our support, the percentage of candidates who obtain the certification at the first attempt is very close to 100%.
.jpeg "fabio-oyxis2kalvg-unsplash (1).jpeg")
Keep yourself updated on latest courses.
Subscribe!
Keep yourself updated on latest courses.
Subscribe!
DATA ENGINEERING
Attending one of the courses of this category and passing the related skills assessment test, you will get the "Data Engineering" CERTIFIED ENGINEER Digital Badge to share on your preferred Social Networks.
K Labs S.R.L.
Tel. +39 059 8212 29 | info@klabs.it
VAT IT02034520367
©2024 K LABS Srl - RESERVED RiGHTS
©2024 K LABS Srl - RESERVED RiGHTS
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.
