Certificate of Achievement
has completed the following course:
Data Query with Transact-SQL with Python
CloudSwyft Global Systems, Inc.
Work through multiple modules, each of which explore a key area of the Transact-SQL language, with a focus on querying and modifying data in Microsoft SQL Server or Azure SQL Database.
4 weeks, 5 hours per week
Dann Angelo De Guzman
Founder and CEO
CloudSwyft Global Systems, Inc.
Transcript
Learning outcomes
- Developed Transact-SQL SELECT queries
- Engaged with data types and NULL
- Query multiple tables with JOIN
- Explored set operators
- Engaged in functions and aggregate data
- Engaged with subqueries and APPLY
- Applied table expressions
- Collaborated with group sets and pivot data
Syllabus
- Introduction to Transact-SQL
- Querying Tables with SELECT
- Querying Multiple Tables with JOIN
- Using Set Operators
- Using Functions and Aggregating Data
- Using Subqueries and APPLY
- Using Table Expressions
- Grouping Sets and Pivoting Data
- Modifying Data
- Programming with Transact-SQL
- Error Handling and Transactions.
Issued on 6th January 2025
The person named on this certificate has completed the activities in the transcript above. For more information about Certificates of Achievement and the effort required to become eligible, visit futurelearn.com/proof-of-learning/certificate-of-achievement.
This certificate represents proof of learning. It is not a formal qualification, degree, or part of a degree.