Databases and SQL – Basic Course

Databases and SQL – Basic Course

Course overview

The course provides you with a practical introduction to relational databases and SQL, the standardized language for storing, retrieving, and processing data.

The course focuses on general principles and practices that work regardless of database managers, such as SQL Server, MySQL, PostgreSQL, and Oracle.

Theory is combined with practical exercises where you write SQL queries, create tables, and learn how databases are structured. After the course, you can independently work with basic database management and basic data analyses.

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
  • Works with data, reporting, system management, development, or analysis
  • Need to understand how information is stored and retrieved from databases

Prerequisites

No prior knowledge of databases or SQL is required. General computer proficiency is recommended.

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

Course content

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.

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

Expression of interest