EN / Courses / Beginning SQL / Course Detail

Beginning SQL

This basic course gives you an introduction to databases and SQL. During the course you get to learn what databses are, how they work and how to write SQL queries against databases.

During the course we will be using Microsoft SQL Server 2016 Express, and the course contains many exercises that help you get started with and understand SQL. What you learn in this course you will also be able to apply to other SQL databases, since SQL is a common standard implemented in different environments.

The course lays the foundation for Intermediate SQL, where you will be learning more about creating and designing your own databases.

The instructor is also actively working as a consultant, and shares his practical experiences of databases.

Target audience

Those who haven't worked with databases and SQL previously, and who want to get started learning the syntax and make queries against a database.

Pre-requisites

Programming experience helps, but isn't a formal requirement.

What you will learn

Topics covered in the course

  • SQL Server Management Studio
  • SQL and Transact-SQL (TSQL)
  • Database theory
  • Making queries
  • Sorting and filtering data
  • Summing and aggregating data
  • Modifying data
  • Data types
  • JOIN
  • NULL
  • Grouping data
  • Stored procedures
  • Built-in functions
BOOK

Course info

  • Course code: S100
  • Course duration: 3 days
  • Price: 24500 SEK

Course schedule

Malmö

Teachers

Vincent Andersson
Vincent Andersson

Share

  • Please share on LinkedIn
  • Please share on Facebook
  • Please share on Twitter

Contact us for details

040-6170720

info@edument.se

All prices excluding VAT

Copyright © Edument AB. All rights reserved.