Lifelong learning for working professionals
Databases and SQL – Basic Course

Databases and SQL – Basic Course

Course overview

This course provides you with a practical and solid introduction to relational databases and SQL – the standardized language for storing, retrieving, and processing data in databases. The course focuses on general principles and working methods that work regardless of database manager and are therefore equally suitable for SQL Server, MySQL, PostgreSQL and Oracle, for example.

During the course, theory is interspersed with practical exercises where you work on writing SQL queries, creating tables and understanding how databases are structured. The goal is that after the course you will be able to work independently with basic database management and simple data analysis.

Course Objective

After the course, you can:

  • Understand how relational databases work
  • Working with tables, relationships, and keys
  • Writing SQL queries to search, filter, and sort data
  • Combine information from multiple tables
  • Create and modify databases and table structures
  • Add, update, and delete data
  • Using summing and grouping functions
  • Understand the basics of database modeling and normalization

Target Group

The course is aimed at those who want to learn the basics of databases and SQL. It is suitable for those who work with data, reporting, system administration, development or analysis and need to understand how information is stored and retrieved from databases.
No prior knowledge of databases or SQL is required, but general computer skills are recommended.

Prerequisites

No special prior knowledge is required.

Certification

This course does not have any associated certification. Each participant who completes the course receives a course certificate.

Trainer

Informator has several trainers for this course.

More about the course

The course includes both briefings and practical exercises. The participants work continuously with examples and assignments to put the theory into practice.

Introduction to databases

  • What is a database?
  • Relational databases and tables
  • Basic database concepts
  • How databases are used in operations and systems

    Database Modeling

  • Relationships between tables
  • Primary and foreign keys
  • Normalization
  • Structuring data

    SQL Basic Questions

  • SELECT
  • WHERE
  • ORDER BY
  • DISTINCT
  • Alias

    Working with multiple tables

  • JOIN
  • INNER JOIN and OUTER JOIN
  • Relationships between tables

    Process and analyze data

  • COUNT, SUM, AVG, MIN and MAX
  • GROUP BY
  • HAVING

    Changing data

  • INSERT
  • UPDATE
  • DELETE

    Create and modify databases

  • CREATE TABLE
  • ALTER TABLE
  • DROP TABLE
  • Data types and constraints

Course overview

16900 kr

2 days

Basic

Can’t find a (suitable) date, but are interested in the course? Send in an expression of interest and we will do what we can to get an opportunity that suits.

Expression of interest

För samtliga utbildningar gäller våra
 Allmänna Villkor.

Company-adapted course

The course can be adapted from several perspectives:
  • Content and focus area
  • Scope of application
  • Structure

In collaboration with the course leader, we make sure that the course meets your wishes
Contact us for more information

Send an expression of interest for the training

Send an expression of interest for the training