Information processing with SQL

Lifelong learning for working professionals

Course Summary

This is the most comprehensive course for those who need to gain a basic understanding of creating and maintaining database structures using SQL (Structured Query Language).
You will learn the syntax, capabilities, limitations and functionality of the SQL language.

Course Objective

The SQL language: syntax, possibilities, limitations and functionality.
How to create and maintain database structures

Target Audience

This course is primarily aimed at system developers and programmers who need to be able to develop and maintain applications against a database and advanced users who need to be able to formulate and query their own queries against a database.

Prerequisites

Familiarity with working in Windows environment: window management etc. Experience in programming and in relational databases is an advantage, but absolutely not a requirement.

Certification

This course has no certification.

Trainer

Info to come…

Course Details

The training is designed to be platform independent. Labs are conducted in the Microsoft SQL Server environment, but you also get examples of functionality in, for example, Oracle and MySql. The course is very exercise-intensive and more than half the time is spent on practical exercises performed against a SQL Server database.

1. overview

Basics of SQL
Basic DBMS and relational databases

2. Start with SQL

Arithmetic operations
Union, Union All, Intersect and Minus
Select rates and Where conditions
Logical operators

3. features

Numerical, string and conversion functions
Functions in SQL: SUM, COUNT, AVG, MAX, MIN, etc.

4 CLAUSES

Sorting (ORDER BY)
Grouping (GROUP BY) with conditions (HAVING)

5. JOINS, Subqueries

Subqueries in select statements
Equi-join, Outer-join, Self-join, etc.

6. manipulation of data

Insert and Update with subqueries
Insert, Update and Delete

7. data modeling

Independent objects, dependent objects
Simple overview of a commonly used data modeling tool

Course Overview

25 900 kr

3 days

Classroom, Remote

Basic

English, Swedish

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 find a suitable opportunity.

Customized Courses

The course can be adapted from several perspectives:

Content and focus area
Extent and scope
Delivery approach

In interaction with the course leader, we ensure that the course meets your needs.