Module-1: what is SQL
In this module, you will be introduced to basic theories about designing relational databases some history about RMDB and SQL language.
- Basic database design
- Primary key, Foreign key
- What is SQL
Module-2: Retrieving data and sorting data
In this module, you will be introduced to the SELECT statement, and learn how to perform simple query´s against a relational database.
- Use the SELECT statement
- Retrieve all columns
- Retrieve individual columns
- Sort data
- Sort data by multiple keys
Module-3: Filtering data
In this module, you will be introduced to do basic filtering of selected data.
- The WHERE clause
Module-4: Filtering with Joker Characters
In this module, you will be introduced to filtering using patterns.
Module-5: Calculated Columns and functions
In this module, you will be introduced to how to create calculated columns. You will also meet some of the most commonly used Functions() in SQL. You will also be introduced to some more specific T-SQL functions() and a list of all the available T-SQL functions.
You will be introduced to working with Alias for Tables and Columns.
- What is a Field
- Concatenation of fields
- Using Alias
- What is a function
- Using functions
Module-6: Calculating Totals and grouping of data
In this module, we will introduce a special group of functions. Agregate- functions. Agregate functions are used to calculate pr. Column in a group of data.
- SUM, MAX, MIN, AVG
- Using agregatefunctions
- Grouping data
- Filtering on Groups
In this module, you will be introduced to subqueries which on one hand can be very complex but on the other hand can be extremely useful. You will after this module be able to use subqueries as a filter and to use subqueries as embedded in calculations.
- What is a subquery
- Filtering using subqueries
- Correlated embedded subqueries
Module-8: Join´s and combined queries
In this module, you will work with the concept of Normalized data and relational data, and be introduced to joins. The different types of joint will be covered and tested.
- What is combined queries
- Inner join, Outer join
- Joins and aggregations
Module-9: Editing data
In this module, you will get a short introduction to inserting and updating data in a database, using SQL statements.
- INSERT INTO