20761 Querying Data with Transact-SQL

Loading Dogodki
DATUM: 12. 11. 2018 - 16. 11. 2018

20761 Querying Data with Transact-SQL

  • This dogodek has passed.

12. 11. 2018 - 16. 11. 2018

O izobraževanju
The main purpose of this 3 day instructor led course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.

Komu je izobraževanje namenjeno
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.

Katera znanja boste na izobraževanju pridobili
• Describe the basic architecture and concepts of Microsoft SQL Server 2016.
• Understand the similarities and differences between Transact-SQL and other computer languages.
• Write SELECT queries
• Query multiple tables
• Sort and filter data
• Describe the use of data types in SQL Server
• Modify data using Transact-SQL
• Use built-in functions
• Group and aggregate data
• Use subqueries
• Use table expressions
• Use set operators
• Use window ranking, offset and aggregate functions
• Implement pivoting and grouping sets
• Execute stored procedures
• Program with T-SQL
• Implement error handling
• Implement transactions

Vsebina izobraževanja

  • Module 1: Introduction to Microsoft SQL Server 2016
  • Module 2: Introduction to T-SQL Querying
  • Module 3: Writing SELECT Queries
  • Module 4: Querying Multiple Tables
  • Module 5: Sorting and Filtering Data
  • Module 6: Working with SQL Server 2016 Data Types
  • Module 7: Using DML to Modify Data
  • Module 8: Using Built-In Functions
  • Module 9: Grouping and Aggregating Data
  • Module 10: Using Subqueries
  • Module 11: Using Set Operators

Potrebno predznanje
• Working knowledge of relational databases.
• Basic knowledge of the Microsoft Windows operating system and its core functionality.

Predavatelj
Danijel Novak, MCT

PROMO PONUDBA!
Ne spreglejte! Dva udeleženca istega tečaja za ceno enega! Doplačate le uradno gradivo za drugega udeleženca. Velja tudi za plačila s SA Training voucherji.

Cena
1.250,00 € + DDV = 1.525,00 €
ali 5 SA Training voucherji

Cena z vključenim 22% DDV vključuje
• organizacijo in strokovno izvedbo izobraževanja,
• uradno Microsoft gradivo,
• uradno Microsoftovo potrdilo o udeležbi,
• blok in pisalo,
• kosilo, osvežilne napitke in prigrizke.

Lokacija
SRC sistemske integracije d.o.o.
Tržaška cesta 116,
1001 Ljubljana

Podatki o udeležencu

Ime in priimek *

E-poštni naslov*

Telefon*

Del. mesto*

Ime in priimek

E-poštni naslov

Telefon

Del. mesto

Ime in priimek

E-poštni naslov

Telefon

Del. mesto



Podatki o plačniku

Naziv organizacije *

Ime *

Priimek*

Kontaktna oseba

Ime *

Priimek*

Kontaktni podatki

E-poštni naslov *

Telefon *

Naslov *

Poštna številka in kraj *

ID številka za DDV *

Način plačila *

Podrobnosti

Začetek:
12. 11. 2018
Konec:
16. 11. 2018
Dogodek Category: