SQL Server Administration Part 3 from Udemy

What's inside

Learning objective

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.

Syllabus

This final SQL Administration Part 3 course is designed so that the student can learn high availability solutions such as log shipping, database mirroring, replication and always on group technologies

Getting A SQL DBA Job

1. VMware Workstation 12 and Domain Controller Part 1

POST ADDENDUM

APPS NEEDED

CREATE VM

INSTALL SQL SERVER 2017

ADVENTUREWORKS 2017 DB

COMPARISON SQL 2014 VS 2017

2. VMware Workstation 12 and Domain Controller Part 2

3. Server1 installation part 1

4. Server1 installation part 2

5. Server 2 installation part 1

6. Server 2 installation part 2

7. Server 2 installation part 3

8. Server 2 installation part 4

9. Log Shipping Part 1

10. Log Shipping Part 2

11. Log Shipping Part 3

12. Log shipping Manual Failover part 1

13. Log shipping Manual Failover part 2

14. Orphans

15. Monitoring Log Shipping

16. Database Mirroring

17. Database Mirroring using GUI part 1

18. Database Mirroring using GUI part 2

19. Database Mirroring Monitoring part 1

20. Database Mirroring Monitoring part 2

21. Replication

22. Transactional Replication part 1

23. Transactional Replication part 2

24. Peer to Peer Replication part 1

25. Peer to Peer Replication part 2

26. Always On

27. Always On Requisite part 1

28. Always On Requisite part 2

29. Always On Setup Cluster

30. Always On Demo part 1

31. Always On Demo part 2

32. Backup Replicas

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches various high availability (HA) solutions such as log shipping, database mirroring, replication, and always on availability group technologies

Develops professional skills or deep expertise in SQL Server Administration

Provides scaffolding through prerequisite courses

Requires students to come in with extensive background knowledge

Uses VMware Workstation 12 and requires learners to create virtual machines

Reviews summary

Adequately presented sql course

According to students, core principles of SQL are well presented in this course. They say examples are plentiful and help reinforce learning. The workload is said to be manageable although the exams are challenging.

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SQL Server Administration Part 3 with these activities:

Review T-SQL for Database Management

Show steps

Refresh T-SQL skills to confidently manage and query databases.

Browse courses on T-SQL

Show steps

Review T-SQL syntax and commands
Practice writing queries
Complete online exercises or tutorials

Review Database Administration Fundamentals

Show steps

Review the core concepts and principles of database administration to strengthen foundational understanding.

View Database Systems: The Complete Book on Amazon

Show steps

Read chapters 1-4
Take notes on key concepts
Complete end-of-chapter exercises

Participate in SQL Server Administration Study Group

Show steps

Engage with peers to discuss concepts, share experiences, and reinforce understanding of SQL Server administration.

Show steps

Join a study group or forum
Participate in discussions and share insights
Collaborate on projects or case studies

Four other activities

Expand to see all activities and additional details

Show all seven activities

Follow SQL Server Administration Tutorial Series

Show steps

Enhance practical skills by following a comprehensive tutorial series on SQL Server administration and high availability solutions.

Show steps

Identify relevant tutorials on YouTube or online platforms
Follow the tutorials step-by-step
Take notes and practice configurations

Configure and Manage Log Shipping

Show steps

Strengthen understanding of log shipping by configuring and managing it in a test environment.

Browse courses on Log Shipping

Show steps

Set up two SQL Server instances
Configure log shipping
Test failover and recovery scenarios

Create a Whitepaper on High Availability in SQL Server

Show steps

Deepen understanding by researching, writing, and sharing a whitepaper on high availability in SQL Server.

Browse courses on High Availability

Show steps

Research and gather information
Outline the whitepaper structure
Write and edit the content

Participate in SQL Server Administration Hackathon

Show steps

Test skills and knowledge by participating in a hackathon focused on SQL Server administration and high availability solutions.

Show steps

Register for the hackathon
Form a team or work independently
Develop a solution to a specific challenge

Career center

Learners who complete SQL Server Administration Part 3 will develop knowledge and skills that may be useful to these careers:

SQL Server Database Administrator

A SQL Server Database Administrator ensures that a company's SQL databases are running smoothly and efficiently. This course provides hands-on training in configuring, managing, and monitoring a variety of SQL Server high availability solutions. By learning how to prevent data loss and improve performance, you will become a more effective SQL Server Database Administrator.

See salaries and explore the career path for SQL Server Database Administrator

Database Architect

A Database Architect designs and implements database solutions that meet the needs of an organization. This course helps build a foundation in high availability solutions for SQL Server, which is a valuable skill for a Database Architect to have. By understanding how to prevent data loss and improve performance, you will be able to design and implement more effective database solutions.

See salaries and explore the career path for Database Architect

Data Engineer

A Data Engineer designs, builds, and maintains data pipelines that move data between different systems. This course provides training in high availability solutions for SQL Server, which is a valuable skill for a Data Engineer to have. By understanding how to prevent data loss and improve performance, you will be able to design and implement more effective data pipelines.

See salaries and explore the career path for Data Engineer

Business Intelligence Analyst

A Business Intelligence Analyst helps businesses to make better decisions by providing them with data and insights. This course provides training in high availability solutions for SQL Server, which is a valuable skill for a Business Intelligence Analyst to have. By understanding how to prevent data loss and improve performance, you will be able to provide more accurate and timely insights to your organization.

See salaries and explore the career path for Business Intelligence Analyst

Data Scientist

A Data Scientist develops and implements machine learning and artificial intelligence models to solve business problems. This course may be useful for a Data Scientist who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to develop and implement more effective machine learning and artificial intelligence models.

See salaries and explore the career path for Data Scientist

Systems Administrator

A Systems Administrator maintains and supports computer systems and networks. This course provides training in high availability solutions for SQL Server, which is a valuable skill for a Systems Administrator to have. By understanding how to prevent data loss and improve performance, you will be able to keep your organization's computer systems and networks running smoothly and efficiently.

See salaries and explore the career path for Systems Administrator

Software Developer

A Software Developer designs, develops, and maintains software applications. This course may be useful for a Software Developer who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to develop and implement more reliable and efficient software applications.

See salaries and explore the career path for Software Developer

Network Administrator

A Network Administrator maintains and supports computer networks. This course may be useful for a Network Administrator who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to keep your organization's computer networks running smoothly and efficiently.

See salaries and explore the career path for Network Administrator

IT Manager

An IT Manager is responsible for the overall management of an organization's information technology systems and resources. This course provides training in high availability solutions for SQL Server, which is a valuable skill for an IT Manager to have. By understanding how to prevent data loss and improve performance, you will be able to make better decisions about how to allocate your organization's IT resources.

See salaries and explore the career path for IT Manager

Project Manager

A Project Manager plans, executes, and closes projects. This course may be useful for a Project Manager who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to manage IT projects more effectively.

See salaries and explore the career path for Project Manager

Business Analyst

A Business Analyst helps businesses to identify and solve problems. This course may be useful for a Business Analyst who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to provide more valuable insights to your organization.

See salaries and explore the career path for Business Analyst

Sales Engineer

A Sales Engineer helps customers to evaluate and purchase software and hardware solutions. This course may be useful for a Sales Engineer who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to better understand the needs of your customers and how SQL Server can help them.

See salaries and explore the career path for Sales Engineer

Quality Assurance Analyst

A Quality Assurance Analyst tests software applications to ensure that they meet quality standards. This course may be useful for a Quality Assurance Analyst who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to test software applications more effectively.

See salaries and explore the career path for Quality Assurance Analyst

Customer Support Engineer

A Customer Support Engineer provides technical support to customers. This course may be useful for a Customer Support Engineer who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to provide better support to your customers.

See salaries and explore the career path for Customer Support Engineer

Technical Writer

A Technical Writer creates and maintains technical documentation. This course may be useful for a Technical Writer who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to create and maintain more accurate and helpful technical documentation.

See salaries and explore the career path for Technical Writer