This course will teach the basics of Microsoft's dialect of the standard SQL language, Transact-SQL.
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. Audience Profile This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries.
Skills Gained
After completing this course, students will be able to:
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
Who Can Benefit?
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.
Outline for Querying Data with Microsoft Transact-SQL Training
Outline
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
Since 1999, Web Age Solutions has been committed to helping our clients thrive. Whether that’s through off-the-shelf-courses or fully customized programs, we tailor our offerings to meet client needs. As a result, we’ve had the privilege of working with some of the biggest names in business in a range of industries, including TELUS, Nokia, UPS, and Comcast.
Serving clients throughout North America, Africa, Australia, Europe, and the Middle East, we offer flexibility, ease, and peace of mind.
At Web Age Solutions, it’s vital to make sure our clients are in good hands. That’s why we’re always on the lookout for exceptional instructors and information technology sales professionals.
If our core values resonate with you, be sure to get in touch with us today through our Careers page.
Onsite, instructor-led live Data Management training courses demonstrate through interactive hands-on practice the fundamentals and advanced topics of Data Management.
The Primavera P6 Training Course will prepare you to efficiently track your project teams, schedules, tasks, and finances, manage your entire project, and accurately report your progress to date.
Students explore the differences between relational and non-relational databases to maintain and manage data in the cloud. Students design database with table relationships, build tables with different data types, and create queries and reports using Structured Query Language (SQL) & NoSQL database...
The SETC Montreal-Ottawa Training Oracle courses teach you how to install, configure, and manage an Oracle database server under Windows or Linux. Our training covers the installation and administration of Oracle, Oracle Forms & Reports, and the Oracle GRID infrastructure.
In this course, you apply guidelines and considerations for securing data using encryption and certificates. You describe various data encryption policies. Finally, you determine a key storage method.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy