Microsoft SQL Server Database Administration (DBA)
Introduction to SQL Server and Foundational Knowledge
Introduction to SQL Server and Foundational Knowledge as it’s practiced in the production real world situations.
This part of the course is for beginners but at the same time introduced elements that are practiced in the real world, so the student gains a faster understanding of the requirements in the production server.
All software, SQL Scripts and documentation is provided for you. All you need is a desire to learn and pursue your goals. This course will give you that direction.
What you’ll learn
- Manage SQL Server Administration
- Install SQL Server in a Production environment following Microsoft best
practice - Review storage, data, and log files necessities
- Understand the importance of backups and restores
- Configure security and more
Who this course is for:
- This course has been designed for beginners that want to learn how to manage MSSQL Server
Introduction to SQL Server performance
SQL Administration Part 2 will benefit the student by providing the necessary guidelines for enhancing SQL Server performance by utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics. handful of utilities to gather information about SQL Server internals, such as SQL Profiler, Database Tuning Advisor (DTA), Extended Events, SQL performance monitor, Activity monitor, and teach about partitions, creating contained database for recovery, reviewing SQL server logs and by installing SQL Server 2019 as the newer SQL version.
What you’ll learn: At the end of SQL Administration Part 2
- Student will be able to create
- indexes for to gain performance
- Use the SQL Extended event to find and trouble shoot expensive queries
- Use the activity monitor for analysis
- Deploy the performance monitor to find specific about SQL Server internals
- Use DTA utility Create and investigate issues with DMVs and extended events
- Look at SQL logs
- Monitor the health of the SQL Server more efficiently and much more.
High Availability Solutions
The Part 3 of the course will cover High Availability solutions such as log shipping, database mirroring, replication, peer to peer replication and always on availability group technologies. Upon completing this course, the student will be well versed in configuring, managing, and monitoring virtually all tasks that a SQL DBA does in their daily, weekly, and monthly duties.
The materials that the student will need such as documents and SQL scripts will be provided. Upon completion of this course, the student will have the training, education, and knowledge that a college provides in their courses about SQL Server Administration.
What you’ll learn: At the end of the course,
- The student will be able to understand, configure and monitor various high availability (HA) solutions such as log shipping, database mirroring, replication, peer to peer replication, and the great always on availability group technology.
This experience will help the student gain a better understanding of how and when to utilize each technology depending on the needs of the company. This knowledge will enhance the opportunity for each student to progress faster within a company and promote his skill set to a higher level.
T-SQL Querying concepts.
Go from a beginner SQL programmer to writing complex SQL Queries, the course expects that students are already aware of basic database concepts.
If you looking for your next database job or trying to improving your existing database knowledge and apply in your projects, this is the course for you.
What you’ll learn
- Write basic to complex TSQL queries.
- Know the different TSQL functionalities that exist
- Write more efficient TSQL code
- Database Administrators
- Database Engineer
- Microsoft Azure Administrator
- Database Solution Architect
- Sr. Microsoft Developer
- Sr. Database Administrators
- Required Materials
Good laptop of 32GB of total physical memory running on Windows PRO version
- Project 1 – SQL installation.
- Project 2 – Windows Patching.
- Project 3 – SQL Server Patching and Service packs upgrade (e.g SP for SQL 2016).
- Project 4 -In-place and Side-by-side upgrade from SQL 2017 or 2019.
- Project 5 – Creating an Availability Group (AG) in SQL Server.
- Project 6 – SQL Server Decommissioning.
- Project 7 – Configuring Log shipping in a 2-node cluster.
- Project 8 – Configuring Database Mirroring in a 2-node cluster.
- Project 9 – Configuring Replication.
- Project 10 – Managing Logins and Permission for a multi-user environment.
- Project 11 – SQL Server Monitoring using External Tools.
- Project 12 – Using external Tools for Backup and restore.
- Project 13 – Working with Data Domain Replication Technology.
- Project 14 - Configuring Disaster Recovery Technologies in SQL.
- Project 15 – Database References.
- Project 16 – Application Deployment in Production Servers.
- Project 17 – SQL Server Performance Tuning and Monitoring.
- Project 18 – Introduction to SSIS/SSRS/SSAS.
- Project 19 – Introduction to Microsoft Azure.
- 400+ Hours of intensive hands-on training
- Duration: 6 months
- Facilitated by top Sr. Databases administrators
- Group Projects/ Capstone Project
- Direct path to becoming certified
Instructor
Enam Matthew | Enam.matthew@beltwaytechacademy.com
Share This :
$3,000
This Course Include
- Language - English
- Access on desktop, tablet and mobile
- Full lifetime access
- Certificate of Completion
Newsletter
Our newsletter is your beacon for staying informed about the latest educational trends, ensuring you're always at the forefront of knowledge.
Opening Hours
- 9am - 4pm EST, Monday - Saturday
Our Support and Help desk is available 24 /7 to answer your queries
© 2024 Beltway Academy. All Right Reserved