Kurs za DP-080: Querying Data with Microsoft Transact-SQL

Opis
Sadržaj
Kome je namenjeno

This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL.

Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

LEARNING PATH 1
Get Started Querying with Transact-SQL

Introduction to Transact-SQL
Sort and filter results in T-SQL
Combine multiple tables with JOINs in T-SQL
Write Subqueries in T-SQL
Use built-in functions and GROUP BY in Transact-SQL
Modify data with T-SQL

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries.

This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer.

It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.

Опис

This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL.

Содржина

LEARNING PATH 1
Get Started Querying with Transact-SQL

Introduction to Transact-SQL
Sort and filter results in T-SQL
Combine multiple tables with JOINs in T-SQL
Write Subqueries in T-SQL
Use built-in functions and GROUP BY in Transact-SQL
Modify data with T-SQL

За кого е наменет

This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries.

This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer.

It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.

Dosadašnja iskustva

Šta su rekli naši polaznici o nama

- Marko Krstevski Student za Microsoft .NET

Želeći da proširim svoje znanje, odlučio sam da se upišem u Semos Education gde dobijam potrebno znanje i iskustvo.
- Teodor Markovski Student

Želja da postanem Cloud arhitekta dovela me do Semos Education-a. Oduševljen sam pozitivnim iskustvima bivših studenata i načinom na koji predavači i Karijerni centar brinu o studentima.
- Viktorija Georgieva Mentorka letnjeg programa za Python Developer-a

Reputacija Semos Education-a za kvalitetnu obuku i mogućnost učenja od iskusnih instruktora odigrala je značajnu ulogu u mojoj odluci.
- Borče Peltekovski Akreditirana Akademija za grafički dizajn

Po završetku kurseva u Semos Education-u, vidim sebe u nekoj kompaniji koja radi sa tehnologijom, kao što su na primer Samsung, Apple ili kompanija sličnog kalibra.

Upoznajte instruktore

Dejan Vakanski
Microsoft Certified Trainer

Data Consultant,

Data Scientist @Semos Education

22+ godine iskustva
Zoran Kimov
Microsoft Certified Trainer

Data Analyst @Semos Education

12+ godina iskustva
mr Elena Dimovska
Microsoft Certified Trainer

Msc in finance, economy, and banking,

Specialist for Data Analysis @Semos education

15+ godina iskustva
Ljupčo Tasevski
Microsoft Certified Trainer

Senior Database Administrator @Netcetera

10+ godina iskustva
Ivan Tanevski
Microsoft Certified Trainer

Data coordinator @EOS Matrix Macedonia

3+ godine iskustva
Verica Manevska
Microsoft Certified Trainer

Data analyst/Power BI Developer @iborn.net

12+ godina iskustva
Simka Janevska
Microsoft Certified Trainer

Data and Analytics Engineer @Qinshift

1+ godina iskustva