Follow Us on Social!
Course Offering
- Guaranteed to Run Schedule
- New Courses
- Fast Lane LIVE E-Learning
- Digital Learning Solutions
- Fast Lane Academy»
- Hack Academy
- Fast Lane IT Workshops»
- Featured Vendors
- Amazon Web Services»
- Aruba»
- Cisco»
- Citrix»
- EC-Council»
- Google Cloud»
- (ISC)²»
- Microsoft»
- NetApp»
- Palo Alto Networks»
- Red Hat»
- VMware»
-
Additional Vendors»
- Arista
- Automation Anywhere
- Barracuda
- Brocade
- CertNexus
- Check Point
- Cloudera
- Commvault
- CompTIA
- CWNP
- Cydrill Software Security
- Dell EMC
- F5
- Fortinet
- Gigamon
- Huawei
- IBM
- Juniper
- Kaspersky Lab
- KnowBe4 Security Awareness
- Oracle
- Pivotal / Spring
- Ruckus
- Salesforce
- ServiceNow
- SonicWall
- Splunk
- SUSE
- Symantec
- Veritas
- IT & Project Management»
- Atlassian»
- DevOps Institute»
- ITIL®»
- PRINCE2®»
- Scaled Agile»
- Scrum»
- Featured Technologies
- Artificial Intelligence (AI)»
- Cloud Computing»
- Cyber Security»
- Data Center»
- Network Analysis / Wireshark»
- Software Development»
- Wireless & Mobility»
Transact SQL – SQL Extensions for SQL Server and Azure SQL (TSQL)
Course Overview
Sie lernen in diesem Workshop die Grundlagen und die Anwendung der Transact SQL (T-SQL) Erweiterungen kennen. Diese Ergänzungen zum Standard (SQL02) bringen enorm viel Produktivität, Performance und Sicherheit in ihre Anwendungen. Die erworbenen Kenntnisse können sie dann in lokalen (On Prem) ebenso wie in der Azure Cloud anwenden.
Prerequisites
Gute Kenntnisse in Standard SQL (wie SQL Standard Intensive Training (SQL02))
Course Objectives
Sie können die sehr produktiven T-SQL Erweiterungen anwenden. Stored Procedures und Functions entwickeln und diese lokal und/oder in der Cloud erfolgreich einsetzen.
Course Content
- Vorstellung der wichtigsten Funktionen und Komponenten von SQL Server und Azure SQL.
- Repetition Select
- SQL Server Datentypen
- Komplexere DML-Anweisungen
- Abfragen schreiben, die eingebaute Funktionen verwenden.
- Daten aggregieren.
- Unterabfragen schreiben.
- Erstellen und Implementieren von Views und Table Valued Function.
- Set-Operatoren verwenden, um Abfrageergebnisse zu kombinieren.
- Schreiben von Abfragen, die ein Windowing der Daten ermöglichen.
- Daten durch Anwendung von Pivot, Unpivot, Rollup und Cube transformieren.
- Programmierkonstrukten wie Variablen, Bedingungen und Schleifen zu T-SQL-Code.
- Stored Procedures entwickeln
- Python Code integrieren
Online Training
Duration 2 days
Price (excl. tax)
- 1,690.— €
Courseware language: English
Currently no online training dates
Classroom Training
Duration 2 days
Price (excl. tax)
- Germany: 1,690.— €
- Switzerland: CHF 1,940.—
Catering includes:
- Coffee, Tea, Juice, Water, Soft drinks
- Pastry and Sweets
- Fresh fruits
- Lunch in a nearby restaurant
* Catering information only valid for courses delivered by Fast Lane.
Courseware language: English
Currently no classroom training dates
Schedule
FLEX Classroom Training (hybrid course):
Course participation either on-site in the classroom or online from the workplace or from home.
German
Time zone: Central European Summer Time (CEST) ±1 hour
FLEX Classroom Training (hybrid course):
Course participation either on-site in the classroom or online from the workplace or from home.
Switzerland
Zurich
This is a FLEX course in German language.
Time zone: Central European Summer Time (CEST) Course language: German
Time zone: Central European Summer Time (CEST) Course language: German
Zurich
This is a FLEX course in German language.
Time zone: Central European Time (CET) Course language: German
Time zone: Central European Time (CET) Course language: German
Bern
This is a FLEX course in German language.
Time zone: Central European Time (CET) Course language: German
Time zone: Central European Time (CET) Course language: German
Zurich
This is a FLEX course in German language.
Time zone: Central European Time (CET) Course language: German
Time zone: Central European Time (CET) Course language: German
Zurich
This is a FLEX course in German language.
Time zone: Central European Summer Time (CEST) Course language: German
Time zone: Central European Summer Time (CEST) Course language: German
Zurich
This is a FLEX course in German language.
Time zone: Central European Time (CET) Course language: German
Time zone: Central European Time (CET) Course language: German
Zurich
This is a FLEX course in German language.
Time zone: Central European Time (CET) Course language: German
Time zone: Central European Time (CET) Course language: German
Basel
This is a FLEX course in German language.
Time zone: Central European Time (CET) Course language: German
Time zone: Central European Time (CET) Course language: German
Bern
This is a FLEX course in German language.
Time zone: Central European Time (CET) Course language: German
Time zone: Central European Time (CET) Course language: German
Zurich
This is a FLEX course in German language.
Time zone: Central European Time (CET) Course language: German
Time zone: Central European Time (CET) Course language: German
Basel
This is a FLEX course in German language.
Time zone: Central European Summer Time (CEST) Course language: German
Time zone: Central European Summer Time (CEST) Course language: German
Bern
This is a FLEX course in German language.
Time zone: Central European Summer Time (CEST) Course language: German
Time zone: Central European Summer Time (CEST) Course language: German
Zurich
This is a FLEX course in German language.
Time zone: Central European Summer Time (CEST) Course language: German
Time zone: Central European Summer Time (CEST) Course language: German
Zurich
This is a FLEX course in German language.
Time zone: Central European Summer Time (CEST) Course language: German
Time zone: Central European Summer Time (CEST) Course language: German
Basel
This is a FLEX course in German language.
Time zone: Central European Summer Time (CEST) Course language: German
Time zone: Central European Summer Time (CEST) Course language: German
Bern
This is a FLEX course in German language.
Time zone: Central European Summer Time (CEST) Course language: German
Time zone: Central European Summer Time (CEST) Course language: German
Zurich
This is a FLEX course in German language.
Time zone: Central European Summer Time (CEST) Course language: German
Time zone: Central European Summer Time (CEST) Course language: German
Basel
This is a FLEX course in German language.
Time zone: Central European Summer Time (CEST) Course language: German
Time zone: Central European Summer Time (CEST) Course language: German
Bern
This is a FLEX course in German language.
Time zone: Central European Summer Time (CEST) Course language: German
Time zone: Central European Summer Time (CEST) Course language: German
Zurich
This is a FLEX course in German language.
Time zone: Central European Summer Time (CEST) Course language: German
Time zone: Central European Summer Time (CEST) Course language: German
Basel
This is a FLEX course in German language.
Time zone: Central European Time (CET) Course language: German
Time zone: Central European Time (CET) Course language: German
If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.
