SQL Basics
This training has been designed for people who want to get familiar with SQL. You will learn how SQL works and how to write proper SQL statements using practical examples that will be useful for your daily work.
Information about the course
Designed for the product: | PostgreSQL |
---|---|
Group size: | Group of up to 15 students |
Type of exam: | 30 min, theoretical |
Requirements: | None |
Course language: | English |
Available online: | Yes |
Course length: | 4 DAYS |
Course price: | € 2,000 excluding VAT |
Course content
Day 1
- History of SQL and PostgreSQL
- Connecting to the server using different tools
- SQL syntax elements: keywords, identifiers, constants
- Data types
- The NULL value
- Basic CREATE TABLE
- Schemas
Day 2
- Basic INSERT
- Basic DELETE
- Temporary tables
- Constraints
- ALTER TABLE
- Sequences, serial, identity columns
Day 3
- Basic SELECT: the SELECT list
- SELECT: the FROM clause
- SELECT: the WHERE clause
- SELECT: the GROUP BY clause, HAVING
- SELECT: the ORDER BY clause
- SELECT: LIMIT and OFFSET
- UNION, EXCEPT, INTERSECT
- UPDATE, UPDATE … FROM
- DELETE … USING
- INSERT … SELECT
- INSERT … ON CONFLICT
- Views
Day 4
- COPY
- Database Design and Normalization
- Transactions
- SQL Injection and Security
- Advanced SELECT
Jakub Zemanek
Technical Consultant & DBAAdditional information
Certificate
- After successfully passing the exam, you will obtain official Cybertec certification