SQL experienced (conducted in English)

Kursusmål On this course, you will be introduced to techniques and subjects relevant for the experienced and more advanced user of T-SQL, on a Microsoft SQL server.

Since you are going to work with UPDATE, DELETE, CREATE, DROP statements you must have more extended rights on your database. The course will also be relevant for you, if you just want to get some knowledge about the possibilities on the platform. If you work on other platforms than Microsoft, the course may still be of interest for you since the same possibilities exists on other platforms.

On the course, you will learn to

  • Work with variables and programming structures
  • Create and work with temporary tables
  • Work with Common Table Expressions (CTE) and ranking functions
  • Create and alter views, functions, and stores procedures
  • Create and alter tables and constraints
  • Use transactions
The Course will run un a Microsoft SQL Server Database using T-SQL.

The course will be conducted in English.
Deltagere We strongly recommend that you participate in our course SQL-basic before entering this course, or in other ways have ...

Vis mere

... achieved the expected basic knowledge about T-SQL and relational databases.
Apart from that, we recommend that you show up in time on the day of the course, willing to learn, and we 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: Datatypes and related problems in SQL
The aim and purpose of this module is to get focus on the different datatypes that T-SQL supports. The focus is mostly on date and string type.

  • Date / Time
  • String
Module-2: Advanced SQL
In this module, you will be introduced to some advanced concepts in T-SQL.
  • Common table expression
  • Pivot and unpivot
  • Ranking functions
Module-3: Variables and programming
In this module, we will introduce the different possibilities for programming in T-SQL.
  • Declaration of variables
  • Scope and lifetime
  • IF, ELSE
  • BEGIN, END
  • Errorhandling
Module-4: Temporary tables and Table variables
In this module, we will introduce tables to store selected data temporary. We will also start using table variables and discus the pro´s and con´s of these objects.
  • Creating temporary tables
  • Creating Table variables
Module-5: Cursors
In this module, you will be introduced to different types of cursors. When and where to use them.
  • Types of cursors
  • Settings of cursors
Module-6: Dynamic SQL
In this module, we will introduce you to the use of Dynamic SQL, which is often used in Storedprocedures.
  • Using EXEC
  • Using sp_excutesql
Module-7: Introduction to Views
In this module, you will learn about Views. What is a view and why would you use a View. Creating Views to select, Insert, Update data and views to validate data.
  • Create / Edit / Drop View
  • Update with a view
  • View options
Module-8: Introduction to functions
In this module, we will introduce the concept of user defined functions. How do you create your own function and how do you use it afterwards.
  • Create / alter / drop function
  • Scalar functions
  • Table functions
Module-9: Introduction to stored procedures
In this module, you will be introduced to stored procedures. Stored procedures is a very important object on a Microsoft SQL Server. You will be working with stored procedures taking input parameters and having output.
  • Create / alter / drop stored procedure
  • Stored procedures with parameters
  • Output
Module-10: Transactions
The purpose of this module is to introduce you to the concept of transactions. Transactions is one of the important tools to make sure that data in your database are valid. If errors occur in parts of a process you will be able to roll back all the actions you tried to perform.
  • Transactions
  • Savepoints
  • Commit / rollback
Du kan finde alle informationer om dette kursus ved at gå ind på http://www.4d.dk/Kurser/Backoffice/SQL_Server/Ikke_angivet/696855

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 experienced (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.