EN / Courses / Intermediate SQL / Course Detail

Intermediate SQL

This intermediate course builds on Beginning SQL and goes deeper into the language as well as how to design and implement your own databases from scratch.

During the course we will make use of SQL Server 2016 Express, but most things you learn here also work with previous versions of SQL Server.

The course also contains many exercises in both SQL and database design, where you learn to go from specification to database.

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

Target audience

For you who want to deppen your SQL knowledge, and learn to create your own databases.

Pre-requisites

You should have skills corresponding to *Beginning SQL*, and knowledge about how to construct queries in SQL, including `JOIN` and `GROUP BY`.

What you will learn

Things covered by the course

  • Creating database
  • Creating tables
  • Normalization
  • Views
  • Index (clustered and non-clustered)
  • Transactions
  • Database diagrams
  • Schemas
  • Stored procedures
  • Error handling
  • Subqueries
  • Data integrity and constraints
BOOK

Course info

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

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.