Search, explore and find the perfect course for you

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.

  • SQL & SQL Server

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

Course info

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

Course schedule

Malmö
16th Oct. 2017 Book now
18th Dec. 2017 Book now

Teachers

Share

Related courses

Contact us for details

+46 40 61 70 720
info@edument.se


All prices excluding VAT