DP-080T00: Querying Data with Microsoft Transact-SQL
Duration: 2 Days (16 Hours)
DP-080T00: Querying Data with Microsoft Transact-SQL Course Overview:
The DP 080 course provides a comprehensive introduction to T-SQL, Microsoft’s dialect of the standard SQL language. Participants will learn how to effectively query and modify data in relational databases hosted on Microsoft SQL Server-based systems, including Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics.
Key topics covered in this course include:
- Fundamentals of T-SQL and its syntax.
- Writing queries to retrieve data from databases.
- Modifying and manipulating data using T-SQL.
- Working with database objects such as tables, views, and stored procedures.
- Understanding the data types, functions, and operators available in T-SQL.
- Introduction to advanced concepts like indexing, transactions, and error handling.
By completing the DP 080 course, participants will gain the necessary skills to effectively work with T-SQL and perform various tasks related to querying and modifying data in Microsoft SQL Server-based database systems.
Audience Profile
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.
Job role: Database Administrator
Introduction to Transact-SQL
- Understand what SQL is for
- Identify database objects in schemas
- Identify SQL statement types
- Use the SELECT statement
- Work with data types
- Handle NULLs
Sort and filter results in T SQL
- Sort your results
- Limit the sorted results
- Return paged results
- Remove duplicates
- Filter data with predicates
Combine multiple tables with JOINs in T SQL
- Describe join concepts and syntax
- Write queries that use inner and outer joins
- Write queries that use cross joins
- Write queries that use self joins
Write Subqueries in T-SQL
- Understand what subqueries are
- Use scalar or multi-valued subqueries
- Use self-contained or correlated subqueries
Use built-in functions and GROUP BY in Transact-SQL
- Categorize built-in functions
- Use scalar functions
- Use ranking and rowset functions
- Use aggregate functions
- Summarize data with GROUP BY
- Filter groups with HAVING
Modify data with T-SQL
- Insert data into a table
- Generate automatic values
- Update data in a table
- Delete data from a table
- Merge data based on multiple tables
- An understanding of the fundamentals of data protection, including data classification, risk assessment, and compliance requirements.
- Experience with Microsoft Azure, including Azure Blob Storage, Azure SQL Database, and Azure Active Directory.
- Familiarity with the Microsoft Azure Security Center and Azure Information Protection.
What are the prerequisites for taking the DP-080 exam?
The prerequisites for taking the DP-080 exam are:
- An understanding of the fundamentals of data protection, including data classification, risk assessment, and compliance requirements.
- Experience with Microsoft Azure, including Azure Blob Storage, Azure SQL Database, and Azure Active Directory.
- Familiarity with the Microsoft Azure Security Center and Azure Information Protection.
What are the best resources for preparing for the DP-080 exam?
The best resources for preparing for the DP 080 exam are:
- The official Microsoft DP 080 study guide
- Microsoft Learn modules on data protection in Azure
- Practice exams from Microsoft and other third-party vendors
How long does it take to prepare for the DP 080 exam?
The amount of time it takes to prepare for the DP080 exam will vary depending on your experience and knowledge of the topics covered on the exam. However, most people find that it takes 2-4 weeks of focused study to pass the exam.
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Microsoft Certified Trainers (MCT).
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!