Course Schedule
| March 21, 2023 | Tue and Thu (14 Weeks ) | 7:00 P.M - 10:00 P.M EST | - |
Course Curriculum
Course Curriculum
Module 1 Introduction to Cloud
Cloud Architecture
Introduction to Cloud Computing
Introduction to Microsoft Azure
Introduction to AWS
Cloud Security
Kubernetes on AWS and Microsoft Azure
Module 2 Explore core data concepts
Explore core data concepts
Explore roles and responsibilities in the world of data
Describe concepts of relational data
Explore concepts of non-relational data
Explore concepts of data analytics
Module 3: Explore relational data in Azure
Explore relational data services in Azure
Explore provisioning and deploying relational database services in Azure
Query relational data in Azure
Module 4: Explore non-relational data in Azure
Explore non-relational data services in Azure
Explore provisioning and deploying non-relational data services on Azure
Manage non-relational data stores in Azure
Module 4: Explore modern data warehouse analytics in Azure
Examine components of a modern data warehouse
Explore data ingestion in Azure
Explore data storage and processing in Azure
Get started building with Power BI
Module 5: The Role of the Azure Database Administrator
Azure Data Platform Roles
Azure Database Platforms and Options
SQL Server Compatibility Levels
Azure Preview Features
Module 6: Plan and Implement Data Platform Resources
Deploying SQL Server using IaaS
Deploying SQL Server using PaaS
Deploying Open Source Database Solutions on Azure
Module 7: Implement a Secure Environment
Configure Database Authentication
Configure Database Authorization
Implement Security for Data at Rest
Implement Security for Data in Transit
Implement Compliance Controls for Sensitive Data
Module 8: Monitor and Optimize Operational Resources
Baselines and Performance Monitoring
Major Causes of Performance Issues
Configuring Resources for Optimal Performance
User Database Configuration
Performance-related Maintenance Tasks
Module 9: Optimize Query Performance
Understanding SQL Server Query Plans
Explore Performance-based Database Design
Evaluate Performance Improvements
Module 10: Automation of Tasks
Setting up Automatic Deployment
Defining Scheduled Tasks
Configuring Extended Events
Managing Azure PaaS resources Using Automated Methods
Module 11: Plan and Implement a High Availability and Disaster Recovery Environment
High Availability and Disaster Recovery Strategies
IaaS Platform and Database Tools for HADR
PaaS Platform and Database Tools for HADR
Database Backup and Recovery
Module 12: SQL Data Warehousing
Introduction to Data Warehousing
Overview of Data Warehousing
Considerations for a Data Warehouse Solution
Planning Data Warehouse Infrastructure
Considerations for Building a Data Warehouse
Planning data warehouse hardware
Designing and Implementing a Data Warehouse
Data warehouse design overview
Designing dimension tables
Designing fact tables
Physical Design for a Data Warehouse
ColumnStore Indexes
Introduction to ColumnStore Indexes
Creating ColumnStore Indexes
Working with ColumnStore Indexes
Implementing an Azure SQL Data Warehouse
Advantages of Azure SQL Data Warehouse
Implementing an Azure SQL Data Warehouse
Developing an Azure SQL Data Warehouse
Migrating to an Azure SQ Data Warehouse
Copying data with AZURE data factory
Creating an ETL Solution
Introduction ETL with SSIS
Exploring Source Data
Implementing Data Flow
Implementing Control Flow in an SSIS Package
Introduction to Control Flow
Creating Dynamic Packages
Using Containers
Managing consistency
Debugging and Troubleshooting SSIS Packages
Debugging an SSIS Package
Logging SSIS Package Events
Handling Errors in Data Flow
Implementing a Data Extraction Solution
Introduction to Incremental ETL
Extracting Modified Data
Loading Modified Data
Temporal Tables
Enforcing Data Quality
Introduction to Data Quality
Using Data Quality Services to Cleanse Data
Using Data Quality Services to Match Data
Using Master Data Services
Introduction to Master Data Services Concepts
Implementing a Master Data Services Model
Hierarchies and Collections
Creating a Master Data Hub
Extending SQL Server Integration Services (SSIS)
Using Custom Components in SSIS
Using Scripting in SSIS
Deploying and Configuring SSIS Packages
Overview of SSIS Deployment
Deploying SSIS Projects
Planning SSIS Package Execution
Consuming Data in a Data Warehouse
Introduction to Business Intelligence
An Introduction to Data Analysis
Introduction to Reporting
Analyzing Data with Azure SQL Data Warehouse
Description
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises, and hybrid relational databases. Database Administrators (DBAs) are responsible for the design, implementation, support, and maintenance of computerized databases in today's organizations. The role also includes architecting, building, and scaling databases for future data growth and capacity. DBAs are also responsible for security, performance, and availability of data to users and customers.
Azure Database Administrator is responsible for managing database, availability, and security, and they need to monitor the performance and optimization of modern relational database solutions. They should have knowledge of using T-SQL. They are computer system administrators who can maintain a successful database environment. Their main role is to keep data protected from loss and corruption and even easily accessible whenever needed.
Database Administrator Market Scope:
The US Department of Labor estimates that by 2019 there will be more than 1.4 million total new computing-related job openings in the US.
Database Administrator Employment Projections 2021 – 2031
10-yr Growth Pct: 9% (much faster than avg)
Number of jobs in 2021 : 144,500
Median Pay: $101,000/year
Prerequisites: Students who completed at least one computer training program or have some work experience in IT field with some knowledge of computer hardware & Networking
Certification:
Exam DP-900: Microsoft Azure Data Fundamentals
Exam DP-300: Administering Relational Databases on Microsoft Azure
Training Methodology:
Digital point is a global classroom. All classes are featured online (No recorded version).
Students around world can join online live class
Each live class will be recorded, and students will get access to watch video for practice
Real-world scenario labs
Class Notes and Labs for each class
Benefit of Database Administrator Course:
Better Job Opportunities: If you are looking for a new job, completion of this course, you can apply as a QA automation/DevOps Engineer
Improved Skills & Knowledge: If you are already a QA/IT professional, completion of this course will improve your skills to latest technologies.
Increased Salary: DevOps professionals are the highest paid in the IT industry.
Increased Productivity & Effectiveness: Benefit Your Organization through Visibility to Build, Run and Secure Modern Applications
Who Should Enroll in this Program?
This program caters to those who are hoping to enter the world of Database Administrator or want to update their skills, as it is designed and structured to accommodate various professional backgrounds.
Individuals in the following roles and disciplines are ideal for this course:
Fresh graduates who intend to take the plunge into the DBA job market
Professionals with less than two years of experience who are working in either technical or non-technical job roles and wish to build successful careers in the DBA world
People working in the following roles will benefit the most from the Database Administrator program:
IT team leaders
Software developers
Software Tester
Systems administrators and IT managers
Cloud engineers
Why choose us?
Digital point is a global classroom. All classes are featured online (No recorded version). Students around world can join this online live class.
The course is very interactive and has lots of lab practice with it. A remote server will be provided to each student for lab practice.
We help you with Resume preparation, Interview preparation, before and after job support
Course Catalog
Please Click to View The Catalog : Download
