Search, explore and find the perfect course for you

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.

  • SQL & SQL Server

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

Course info

Course code: S100
Duration: 3 days
Price: 24 500 SEK

Course schedule

Malmö
9th Oct. 2017 Book now
13th Dec. 2017 Book now

Teachers

Share

Related courses

Contact us for details

+46 40 61 70 720
info@edument.se


All prices excluding VAT