Join us as Matt teaches a comprehensive overview of creating a model-driven app using Dataverse. The session will start with an introduction to the reasons for choosing a model-driven app over a canvas app, and it will emphasize the necessity of Dataverse. We will learn to build our application together and go through the ins and outs of Dataverse. Some of the hands-on topics that will be covered are modifying tables, adding custom columns, and adjusting views and forms to meet specific requirements. Additionally, we will focus on enhancing the user experience by incorporating components like subgrids, quick view forms, business rules, sharing your app, and data security.
Overview
COURSE DIFFICULTY
COURSE DURATION
1h
Skills Learned
After completing this online training course, students will be able to:
Write efficient T-SQL queries for data retrieval and manipulation
Develop stored procedures for reusable data logic
Navigate the platform interface and core features
Database Administrators, SQL Developers
None
01. Getting Started
02. Introduction to SQL Server Databases
03. SQL Server Management Studio (SSMS)
04. The SELECT Statement
05. Expressions (Concatenating Columns)
06. Expressions (Mathematical Expressions)
07. Expressions (Other Functions)
08. Expressions (Working with NULLs, DISTINCT and TOP)
09. Indexes
10. The WHERE Clause
11. Complex WHERE Clauses
12. Using a Sub-Query to Filter Data
13. Joining Tables
14. Outer Joins
15. Other Query Patterns
16. Aggregate Queries
17. Modifying Data (Create Tables)
18. Modifying Data (INSERT and SELECT INTO)
19. Modifying Data (UPDATE Statement)
20. Modifying Data (DELETE Statement)
21. T-SQL Programming (Variables)
22. T-SQL Programming (Conditional Logic)
23. T-SQL Programming (Looping)
24. T-SQL Programming (Stored Procedures)
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Write efficient T-SQL queries for data retrieval and manipulation
Develop stored procedures for reusable data logic
Navigate the platform interface and core features
WHO SHOULD ATTEND
Database Administrators, SQL Developers
PREREQUISITES
None
COURSE OUTLINE
01. Getting Started
02. Introduction to SQL Server Databases
03. SQL Server Management Studio (SSMS)
04. The SELECT Statement
05. Expressions (Concatenating Columns)
06. Expressions (Mathematical Expressions)
07. Expressions (Other Functions)
08. Expressions (Working with NULLs, DISTINCT and TOP)
09. Indexes
10. The WHERE Clause
11. Complex WHERE Clauses
12. Using a Sub-Query to Filter Data
13. Joining Tables
14. Outer Joins
15. Other Query Patterns
16. Aggregate Queries
17. Modifying Data (Create Tables)
18. Modifying Data (INSERT and SELECT INTO)
19. Modifying Data (UPDATE Statement)
20. Modifying Data (DELETE Statement)
21. T-SQL Programming (Variables)
22. T-SQL Programming (Conditional Logic)
23. T-SQL Programming (Looping)
24. T-SQL Programming (Stored Procedures)
