The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration
.svg)
.svg)
€ 1.390,-
plus VAT.
€ 1.654,10
incl. VAT.
Booking number
36173
Venue
Online
.svg)
6 dates
€ 1.390,-
plus VAT.
€ 1.654,10
incl. VAT.
Booking number
36173
Venue
Online
6 dates
€ 1.860,–
plus VAT.
€ 2.213,40
incl. VAT.
Booking number
Venue
0 Dates
Become a certified
Machine Learning Engineer
Machine Learning Engineer
This course is part of the certified Master Class "Machine Learning Engineer". If you book the entire Master Class, you save over 15 percent compared to booking this individual module.
To the Master Class
In-house training
In-house training just for your employees - exclusive and effective.
Inquiries
In cooperation with
In this course you will get to know the standard version of SQL. You will deepen and consolidate your knowledge in many practical exercises, focusing on the generally applicable concepts.
Contents
1. repetition of the basic concepts of relational databases
- Database
- Table (entities, attributes)
- Data types (value ranges)
- Primary, foreign key
- Relations
- Data consistency, referential integrity
- View
- Index
- ERM
2. basics of SQL
- History
- Use (basic concept)
- SQL properties
- SQL syntax diagrams
- Naming conventions for objects
3. data retrieval, data evaluation and manipulation (DML)
- SELECT
- Simple queries
- Constant columns, calculated columns, aliases
- DISTINCT
- ORDER BY
- TOP
- WHERE
- Aggregate functions
- GROUP BY / HAVING
- JOIN (INNER, OUTER, FULL, Self, Cross)
- Subqueries
- UNION
- SELECT INTO
4. add data
- INSERT (VALUES, SELECT)
- UPDATE
- DELETE
5. optional topics (if there is enough time):
Data definition language (DDL)
- CREATE DATABASE
- CREATE TABLE
- Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE )
- DROP TABLE
- CREATE VIEW
- ALTER VIEW
- DROP VIEW
- CREATE PROCEDURE
Data control language (DCL)
- Transaction management
- COMMIT & ROLLBACK
- GRANT & REVOKE
Requirements:
- Sound experience in dealing with EDP
- Basic knowledge of relational databases
- Enjoy analytical thinking and the ability to abstract and imagine
Additional info:
This course is designed to be vendor-independent. So it doesn't matter whether you work with Access, Oracle, DB/2, SQL Server, mySQL, SQL Server Express or other database management systems - the basics are the same everywhere.
Your benefit
- Acquisition of basic SQL knowledge and everything that is important for the secure mastery of standard SQL
- Completion of numerous practical exercises for immediate added value in everyday working life
- Receive helpful practical tips from the specially developed course materials
trainer
Peter Jacobs
Methods
This course consists of training training and is led by a trainer who supervises the participants live. Theory and practice are taught with live demonstrations and practical exercises. The video conferencing software Zoom is used.
Final examination
Recommended for
- Programmers, PC administrators and other people who work with an SQL-capable database or want to create applications using the SQL possibilities of the database system.
- People who want to find out systematically about SQL, its possibilities, limitations and significance.
.svg)
