Course Schedule

March 01, 2021 MON and WED 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. DBA’s are also responsible for security, performance, and availability of data to users and customers.


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 2019 – 2029

 10-yr Growth Pct: 10% (much faster than avg)

 Number of jobs in 2019 : 132,500

  Median Pay: $93750

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

 VPN access to digital Point’s Lab that is accessible from anywhere 24/7

 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