SQL basic (conducted in English)

Kursusmål SQL is a universal language used on several platforms designed to manipulate data in relational databases.
On this course, we focus on functionality of importance for data consumers, like controllers and analysts retrieving data from databases to Excel or other reporting applications.
This course is intended for you who wants to extract data from databases like Microsoft SQL servers, Oracle Servers, Access databases. This course is also the base platform you need if you want to work with the more advanced functions like creating Views, Stored procedures and more, on a Microsoft SQL server.
The course will be conducted in English.

On the course, you will learn to

  • Select and manipulate data
  • Sort data
  • Filter data
  • Use a list of default functions in the SQL language
  • Create groupings of data
  • Create Sub Query´s
  • Select data from multiple tables using Joins

Deltagere You do not need to have previous experience with SQL but we recommend that you show up in time on the day of the course, willing to learn, and we ...

Vis mere

... can promise you the best possible course experience.

Feel free to contact us on 33 14 71 44, undervisning@4d.dk or via our chat. We are looking forward to seeing you!
Kursusmateriale A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses. You will get a course material you can use as an encyclopedia after the course and downloads of course exercises.
Kursus indhold 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
  • =
  • IN
  • NOT
  • BETWEEN
Module-4: Filtering with Joker Characters
In this module, you will be introduced to filtering using patterns.
  • Like
  • %
  • ?
  • _
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
  • Calculations
  • 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.
  • Agregatefunctions
  • SUM, MAX, MIN, AVG
  • Using agregatefunctions
  • Grouping data
  • Filtering on Groups
Module-7: Sub-Query´s
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.
  • Join
  • 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
  • UPDATE
  • DELETE
Du kan finde alle informationer om dette kursus ved at gå ind på http://www.4d.dk/Kurser/Backoffice/SQL_Server/Ikke_angivet/696848

Har du spørgsmål?

Hvis du har yderligere spørgsmål til dette produkt eller ønsker at få fremsendt materiale i forbindelse med produktet, er du velkommen til at benytte kontaktformularen herunder.

SQL basic (conducted in English)

Forhandler
4D konsulenterne
Normalpris
7.600,00 kr
Udsalgspris
7.600,00 kr
Normalpris
Udsolgt
Pris pr. stk.
pr. 
Eksklusiv moms.

Efter aftale / Kontakt for pris

Hvis du har valgt Efter aftale, kan du udfylde formularen nedenfor og så vender vi tilbage til dig og aftaler nærmere.

Har du spørgsmål?

Hvis du har yderligere spørgsmål til dette produkt eller ønsker at få fremsendt materiale i forbindelse med produktet, er du velkommen til at benytte kontaktformularen herunder.