Filter

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. 

    Prerequisites

    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
    Date: 4 Dec
    Location: Malmö
    Duration: 3 days
    Price: 25 900 SEK
    Language: English

    Share

    Contact us for details

    +46 40 61 70 720
    info@edument.se


    All prices excluding VAT