Description
This course teaches the basics of Microsoft’s Transact-SQL for querying and modifying data in relational databases hosted on SQL Server-based systems, including SQL Server, Azure SQL Database, and Azure Synapse Analytics. It covers essential skills for data professionals to efficiently manage and analyze data in various roles.
Learning Outcomes
- Use SQL Server query tools
- Write SELECT statements to retrieve columns from one or more tables
- Sort and filter selected data
- Use built-in functions to return data values
- Create groups of data and aggregate the results
- Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE
Prerequisites
Working knowledge of relational databases is required.
Target Audiences
- This course is designed for data analysts, data engineers, data scientists, database administrators, database developers, solution architects, students, and technology managers who need to write basic SQL or Transact-SQL queries or are involved with data.
Featured Review
"This course equipped me with practical Transact-SQL skills that streamlined data querying and modification tasks, boosting my productivity as a data professional. - Rajesh Kumar, Data Analyst at a multinational corporation in Singapore"
You might be interested in
This one-day instructor-led course prepares senior leaders to lead AI initiatives with confidence and clarity. The course focuses on translating generative AI capabilities into measurable business value while addressing governance,...
This one-day instructor-led course equips business professionals with practical skills to apply generative AI using Microsoft 365 Copilot. Participants learn how to streamline everyday business workflows, enhance decision-making, and improve...
This course equips learners with the skills to discern and articulate business problems, fostering a critical eye for continuous improvement. Learners will discover a logical and systematic framework to explore...
This intensive two-day programme equips participants with the expertise to transform their daily productivity and strategic insights using Microsoft 365 Copilot. Delve into the core mechanisms behind conversational AI, master...