Semos Education Semos Education
  • Monday - Friday 9:00AM - 10:00PM
  • Call us now +44 7487633466
  • Keep in touch info@semosedu.com
EN / МК / RS
Кошничка
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.

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.

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.

Past experiences

What people say about 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