Learn how to use Microsoft Power Apps, a powerful tool that lets you create apps without coding. Join us on this hands-on journey to build an end-to-end solution in Power Apps.
Overview
COURSE DIFFICULTY
COURSE DURATION
2h 56m
Skills Learned
After completing this online training course, students will be able to:
Create paginated reports using SQL Server Reporting Services
Write T-SQL queries for data retrieval and manipulation
Database Administrators, Cloud Professionals, Data Analysts
None
01. Course Introduction - Managing and Configuring SQL Server with PowerShell
02. Modules for SQL (Overview)
03. Modules for SQL (Getting the Modules and Resources)
04. Modules for SQL (Connecting with PowerShell)
05. DML Tasks with PowerShell (Overview)
06. DML Tasks with PowerShell (Querying Tables)
07. DML Tasks with PowerShell (Inserting, Updating, Deleting)
08. DML Tasks with PowerShell (Review)
09. DDL Tasks with PowerShell (Overview)
10. DDL Tasks with PowerShell (Creating and Editing)
11. DDL Tasks with PowerShell (Dropping Database Objects)
12. DCL Tasks with PowerShell (Overview)
13. DCL Tasks with PowerShell (Creating Logins and Granting Access)
14. DCL Tasks with PowerShell (Login Lifecycles)
15. DCL Tasks with PowerShell (Auditing Systems)
16. DCL Tasks with PowerShell (Review)
17. Backups and Agent Jobs (Overview)
18. Backups and Agent Jobs (Backups)
19. Backups and Agent Jobs (Agent Jobs)
20. Backups and Agent Jobs (Review)
21. Managing SSRS With PowerShell (Overview)
22. Managing SSRS with PowerShell (Managing Report Services)
23. Testing Your Instances (Overview)
24. Testing your Instances Demo (Using DbaChecks)
25. PowerShell Desired State Configuration (Overview)
26. PowerShell Desired State Configuration (Setting LocalConfigurationManager)
27. Installing SQL Server via a Push Deployment (Overview)
28. Installing SQL Server via a Push Deployment (Installing SQL Server with a Push Config)
29. Maintaining Settings with a Pull Deployment (Overview)
30. Maintaining Settings with a Pull Deployment (Setting up a Pull Server)
31. Maintaining Settings with a Pull Deployment (Using Azure Automation)
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Create paginated reports using SQL Server Reporting Services
Write T-SQL queries for data retrieval and manipulation
WHO SHOULD ATTEND
Database Administrators, Cloud Professionals, Data Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Course Introduction - Managing and Configuring SQL Server with PowerShell
02. Modules for SQL (Overview)
03. Modules for SQL (Getting the Modules and Resources)
04. Modules for SQL (Connecting with PowerShell)
05. DML Tasks with PowerShell (Overview)
06. DML Tasks with PowerShell (Querying Tables)
07. DML Tasks with PowerShell (Inserting, Updating, Deleting)
08. DML Tasks with PowerShell (Review)
09. DDL Tasks with PowerShell (Overview)
10. DDL Tasks with PowerShell (Creating and Editing)
11. DDL Tasks with PowerShell (Dropping Database Objects)
12. DCL Tasks with PowerShell (Overview)
13. DCL Tasks with PowerShell (Creating Logins and Granting Access)
14. DCL Tasks with PowerShell (Login Lifecycles)
15. DCL Tasks with PowerShell (Auditing Systems)
16. DCL Tasks with PowerShell (Review)
17. Backups and Agent Jobs (Overview)
18. Backups and Agent Jobs (Backups)
19. Backups and Agent Jobs (Agent Jobs)
20. Backups and Agent Jobs (Review)
21. Managing SSRS With PowerShell (Overview)
22. Managing SSRS with PowerShell (Managing Report Services)
23. Testing Your Instances (Overview)
24. Testing your Instances Demo (Using DbaChecks)
25. PowerShell Desired State Configuration (Overview)
26. PowerShell Desired State Configuration (Setting LocalConfigurationManager)
27. Installing SQL Server via a Push Deployment (Overview)
28. Installing SQL Server via a Push Deployment (Installing SQL Server with a Push Config)
29. Maintaining Settings with a Pull Deployment (Overview)
30. Maintaining Settings with a Pull Deployment (Setting up a Pull Server)
31. Maintaining Settings with a Pull Deployment (Using Azure Automation)
