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 course teaches learners how to get started with Microsoft 365 Copilot Chat, craft effective prompts, and use its AI-powered features to enhance productivity, streamline work, and collaborate securely in...
This Learning Path examines no-code agents in Microsoft 365 Copilot Chat and SharePoint. It explores how Microsoft 365 business users can create, manage, and use these AI-powered assistants to automate...
Power BI allows you to easily connect to and present your data in an interactive report, so you can make data-driven decisions. This course teaches you how to connect to...
Microsoft Copilot Studio empowers teams to create agents through a guided, no-code graphical interface, eliminating the need for data scientists or developers. This course covers building, managing, and enhancing agents...