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
SQL - The basic training
Understanding and confidently using standard SQL - the training for getting started
Online
2 days
German
€ 1.390,-
plus VAT.
€ 1.654,10
incl. VAT.
Booking number
36173
Venue
Online
.svg)
5 dates
€ 1.390,-
plus VAT.
€ 1.654,10
incl. VAT.
Booking number
36173
Venue
Online
5 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 cooperation with
In this course, you will learn how to use and work with SQL. You will deepen and consolidate your knowledge in many practical exercises, with a focus on general concepts.
Contents
1. Review 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
- Entity-Relationship Model (ERM)
2. basics of SQL
- History
- Use (basic concept)
- SQL properties
- SQL syntax diagrams
- Naming conventions for objects
3. Data Retrieval, Data Analysis
- SELECT
- Simple queries
- Constant columns, calculated columns, aliases
- DISTINCT
- ORDER BY
- TOP
- WHERE
- Aggregate functions
- GROUP BY / HAVING
- JOIN (INNER, OUTER, CROSS)
- Subqueries
- UNION Query
4. Adding, Modifying, and Deleting Records
- SELECT INFO
- INSERT (VALUES, SELECT)
- UPDATE
- DELETE
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-neutral. Therefore, it doesn't matter whether you work with Access, Oracle, DB/2, SQL Server, MySQL, SQL Server Express, or other database management systems—the fundamentals are the same across the board.
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
Thanam Pangri
Noutsa Tsemo
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)
