Fundamentals Of Data Engineering
Introduction to SQL Server and Foundational Knowledge
This introductory course provides foundational knowledge and practical skills essential for real-world SQL Server administration. Tailored for beginners, it incorporates elements practiced in production environments, ensuring a rapid understanding of requirements.
All necessary software, SQL scripts, and documentation are included, requiring only the student’s desire to learn.
What You’ll Learn:
- Manage SQL Server Administration
- Install SQL Server in a Production environment following Microsoft’s best practices.
- Review storage, data, and log files necessities
- Understand the importance of backups and restores.
- Configure security and more.
Target Audience:
This course is designed for beginners aspiring to learn how to manage MSSQL Server.
Introduction to SQL Server Performance
SQL Administration Part 2 focuses on enhancing SQL Server performance through practical guidelines. Students will delve into the use of indexes, analyze Dynamic Management Views (DMVs), and set up performance counters.
Various utilities such as SQL Profiler, Database Tuning Advisor (DTA), Extended Events, and more will be explored. This section also covers the installation of SQL Server 2019.
What You’ll Learn:
By the end of SQL Administration Part 2, students will:
- Create indexes for performance optimization.
- Use SQL Extended events to troubleshoot queries.
- Analyse with the activity monitor.
- Deploy performance monitoring tools.
- Use DTA utility for investigating DMVs and extended events.
- Review SQL logs
- Efficiently monitor the health of SQL Server and more
High Availability Solutions
Part 3 delves into high-availability solutions, covering log shipping, database mirroring, replication, peer-to-peer replication, and always-on-availability group technologies.
Students will gain expertise in configuring, managing, and monitoring tasks typically performed by SQL Database Administrators in their daily, weekly, and monthly duties.
What You’ll Learn:
By the end of this course, students will:
- Understand, configure, and monitor various High Availability (HA) solutions.
- Gain insights into choosing the right technology based on company needs.
T-SQL Querying Concepts
This section caters to aspiring SQL programmers, guiding them from beginners to proficient developers. Assumes basic knowledge of database concepts.
What You’ll Learn:
- Write basic to complex T-SQL queries.
- Understand different T-SQL functionalities.
- Write more efficient T-SQL code.
- Database Administrators
- Database Engineer
- Microsoft Azure Administrator
- Database Solution Architect
- Sr. Microsoft Developer
- Sr. Database Administrators
- Required Materials:
- Good laptop with 32GB of total physical memory running on Windows PRO version.
- Required Materials:
- 300+ Hours of intensive hands-on training
- Duration: 4-6 months depending on your previous background
- Facilitated by top Sr. Database administrators.
- Group Projects/Capstone Project
- Direct path to becoming certified (Certification: Microsoft Certified Associate - MSCA)
- Exams: 70-764 and 70-765
Share This :
$3,000
This program is suitable for individuals looking to enter the field of Front-End Development or enhance their existing skills for career advancement
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