SQL Basics

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

Jakub Zemanek

Technical Consultant & DBA
Jakub's main interests in the OpenSource world are advanced PostgreSQL configuration and database troubleshooting, followed by automation using Ansible, and last but not least the ELK Stack (LOG Management) and the security product Wazuh (SIEM). As Jakub likes to say about himself: "I'd rather do it best than somehow." This is also why he is constantly educating himself and pushing the boundaries of his capabilities.

Additional information

Each participant will be provided with a PDF of the presentations

Certificate

  • After successfully passing the exam, you will obtain official Cybertec certification
initMAX - certificate
Other courses

Course certificates and gifts

For all attendees

Dárek ke kurzu
Course attendance certificate
Dárek ke kurzu
Mastering PostgreSQL book

For passing the exam

Dárek ke kurzu
Cybertec SQL Basics certificate

Registration

"(Vyžadováno)" indicates required fields

GDPR(Vyžadováno)
This field is for validation purposes and should be left unchanged.

×Shopping Cart

Your cart is empty.