Remote Course for DP-080: Querying Data with Microsoft Transact-SQL

reserve a seat

Description
Content
Target Audience

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.

Description

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

Content

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

Target Audience

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.

Our students for us:

- Marko Krstevski Microsoft .NET Academy

Seeking to expand my knowledge, I decided to enroll in Semos Education, where I am gaining the necessary knowledge and experience.
- Teodor Markovski Student

The desire to become a Cloud architect led me to Semos Education. I am thrilled by the positive experiences of former students and the way in which the instructors and Career Center take care of the students.
- Viktorija Georgieva Summer Mentorship Program for Python Develope

The reputation of Semos Education for quality training and the opportunity to learn from experienced instructors played an additional significant role in my decision.
- Borche Peltekovski Accredited Academy for Graphic Design

After completing my studies at Semos Education, I envision myself working in a technology company, such as Samsung, Apple, or a company of similar caliber.

Meet the instructors

Dejan Vakanski
Microsoft Certified Trainer

Data Consultant,

Data Scientist @Semos Education

22+ years of experience
Zoran Kimov
Microsoft Certified Trainer

Data Analyst @Semos Education

12+ years of experience
MSc Elena Dimovska
Microsoft Certified Trainer

Msc in finance, economy, and banking,

Specialist for Data Analysis @Semos education

15+ years of experience
Ljupcho Tasevski
Microsoft Certified Trainer

Senior Database Administrator @Netcetera

10+ years of experience
Ivan Tanevski
Microsoft Certified Trainer

Data coordinator @EOS Matrix Macedonia

3+ years of experience
Verica Manevska
Microsoft Certified Trainer

Data analyst/Power BI Developer @iborn.net

12+ years of experience
Simka Janevska
Microsoft Certified Trainer

Data and Analytics Engineer @Qinshift

1+ years of experience