Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SQL Server DBA 2017 - Advance Level - A Guide

Name: SQL Server DBA 2017 - Advance Level - A Guide
Rating: 4.0 (27 reviews)

SQL Server DBA - Advance Level

Created byRakesh Jain

Last updated 1/2019

English

English [Auto],

What you'll learn

He/She would be professional SQL DBA with level 3 and above - Advance Concept and learning of SQL Server.
He/She Would be able to learn and resolve advance level of SQL Server issues facing with their production System.
Complete course to enter in an organisation as level 2 and above ( SQL DBA L2 and Above )
Session: Named Instance, Log Shipping , Mirroring , Replication - Snapshot,Transaction,Merge & Peer to Peer, Windows Clustering ,
Session: Always on Availability Group, Sql Server Clustering, Active-Passive Clustering, Active-Active Clustering,
Session: Contained Database , Resource Governor concept and lot more+
Upon request free additional recommendation by instructor for enroled students.

Course content

10 sections • 37 lectures • 10h 22m total length

Introduction, Prerequisite & Advantage10:43
Author Introduction and prerequisite (knowledge expectation) before going with this Advance course.

Log Shipping - Part 1 - Purpose,Components & Terms5:45
•Log Shipping – About Log shipping – A overview
•Advantage of Log Shipping
•Configuration of log shipping – Adding / Removing Database
•Monitor Log Shipping
•Managing Log Shipping
•Failover to Secondary – Log shipping
•Changing roles of log shipping between servers / Instances
•Log Shipping Tables and stored procedure
•Removing of Log Shipping
•Industry Perspective – When & Why to use Log shipping
Log Shipping - Part2 - Configuration, Managing & Monitoring20:46
1.Enable Log shipping configuration
2.Configure Backup Setting on Primary
3.Add Secondary Server for Log Shipping
4.Configuring log shipping monitoring Server
5.Configuring log shipping copy/Restore Operation
6.Log shipping Transaction records with an example
7.Remove database from log shipping
8.Bring Database online
Log Shipping - Part 3 - Validating, Managing & Cleanup7:18
Validation & Cleanup - Log shipping

Replication - Types, Terms & Component12:05
•Definition , Benefits ( Advantage ) of Replication – Publisher , Subscriber , Replication Agent
•Types of Replication
•Snapshot replication
•Transaction Replication
•Merge Replication
•Configuration of Replication
•Subscribe to Replication
•Managing replication configuration
•Validation replication
•Monitor Replication Agent
•Replication snapshot agent
•Log Reader Agent
•Replication associate Jobs
•Push Subscription
•Pull Subscription
•Delete/Remove Subscription
SnapShot Replication - Part 1 - Configuration19:58
Configuration of Snapshot Replication
SnapShot Replication - Part 2 - Managing, Monitoring & Validation19:56
Configure and validate snapshot replication with push subscription between publisher and subscriber, monitor distribution agents, and initialize or test changes to ensure data consistency.
Transaction Replication - Part 1 - Configuration16:47
Configuration of Transaction Replication
Transaction Replication - Part 2 - Managing , Monitoring & Validation18:14
Configure, monitor, and validate transactional replication in SQL Server, manage publisher and subscriber setups, test almost real-time data synchronization, and use application monitor to verify integrity.
Merge Replication - Part 1 - Configuration19:59
Explore bidirectional merge replication between publisher and subscriber. Configure distributor, publication, and articles, and manage conflict detection and resolution in synchronization.
Merge Replication - Part 2 - Managing , Monitoring & Validation9:37
Peer to Peer Replication - Part 1 - Concept & Configuration17:30
Learn how to implement peer to peer replication in SQL Server with a distributor, publisher, and multiple subscribers for near real-time, scale-out redundancy, and notoriety-based conflict resolution.
Peer to Peer Replication - Part 2 - Managing & Monitoring & Validation19:06
Configure and monitor a peer to peer replication across multiple servers. Observe how changes propagate, conflicts are resolved, and publishing properties, distributor properties, and subscription properties are managed.
Peer to Peer Replication - Part 3 - Validation & Cleanup10:29

DataBase Mirroring - Part 1 - Concept,Terms & Components13:06
DataBase Mirroring - Part 2 - Configuration & Management19:44
Learn how to configure SQL Server database mirroring with a principal, mirror, and witness, including backup and restore steps, security, endpoints, and failover validation.
DataBase Mirroring - Part 3 - Validation , Monitor & Cleanup13:25
Master database mirroring in sql server, including principal and mirror roles, automatic and manual failover with witness, synchronization, validation, and pause, resume, and cleanup procedures.

Always On - Part 1 - Concept ,Component, & Advantage with Implementation17:01
Explore how always on extends mirroring with high availability using availability groups, primary and secondary replicas, and synchronous or asynchronous commit across Windows clustering.
Always On - Part 2 - Windows Clustering - Configuration as Platform15:29
Always On - Part 3 - Windows Clustering - Validation & Monitoring19:12
Explore Windows clustering validation and monitoring for Always On availability groups, configure quorum with a file share witness, and enable high availability across three SQL Server nodes.
Always on - Part 4 - Configuration with error handling28:06
Always On - Part 5 - Error Handling With Validation30:00
Explore how Always On availability groups manage primary and secondary replicas, failover scenarios, synchronization modes, and data validation to ensure consistent, available SQL Server databases.
Always On - Part 6 - Monitoring & Validation32:06
Explore how to monitor and validate SQL Server Always On availability groups, including role switch, automatic failover, listener connectivity, and synchronization modes.
Always On - Part 7 - 2017 Features - Deep Dive - Configuration17:48
Always On - 2017 - Part 8 - Features - Deep Dive - Configuration & Validation16:03
Learn how to configure and validate Always On availability groups, including read-only intent, primary and secondary replicas, synchronization status, quorum behavior, and read-only routing.
Always On - 2017 - Part 9 - Features - Deep Dive - Monitoring & Validation15:46
Learn Always On 2017 deep dive features for monitoring and validation, including primary and secondary replicas, synchronizing states, and use of read-only and application intent for load-balanced reads.

SQL Server Clustering - Part 1 - Overview13:43
Explore SQL Server clustering fundamentals, including Always On and failover cluster concepts, shared storage, IP planning, active/passive versus active/active setups, and preparing storage with iSCSI.
SQL Server Clustering - Part 12.2 - Creating of Shared Storage22:34
SQL Server Clustering - Part 12.3 - Active-Passive Configuration28:06
Explore building and validating a SQL Server failover cluster in an active-passive configuration, including node roles, shared storage, network name, IP configuration, and cluster resource setup.
SQL Server Clustering - Validation - Active-Passive Configuration13:41
Validate a SQL Server failover cluster and demonstrate automatic failover in an active-passive configuration, verifying service status, preferred owners, and cluster resource behavior.
SQL Server Clustering - Part 12.5 - Active-Active Configuration13:27
Explore active-active configuration in a SQL Server cluster by adding a second instance on a two-node setup, with shared resources, DNS, and IP considerations.
SQL Server Clustering - Part 12.6 - Active-Active Validation & Monitoring10:17
Demonstrates configuring SQL Server cluster resources, validating active-active and active-passive setups, managing node ownership, and verifying services and shared storage for balanced failover and load balancing.

Requirements

Should have knowledge of SQL Server as Beginners or please go through with my existing published course at udemy - Link provided
A Laptop or Desktop

Description

Hello aspiring Learner,

Greetings and Thank you for reading this course landing page !

Here I am industry veteran having experience of 18+ years having expertise in SQL server as Architect DBA , Introducing one more new job oriented course which will help you to introduce yourself as SQL Server DBA in industry as level 2 or Level 3+ level. Microsoft SQL DBA is traditional database technology which are very popular in IT space.

Industry are using this technology since year 1997 when Microsoft came out with release of their first version of SQL server.

I would encourage and recommended to aspiring learners to go ahead with this Advance Level course who would like to learn more about Sql server and would like to deep dive in Sql server technology and want to build career as Advance level SQL DBA .

I would also recommend for those who are working as SQL DBA and having more than 2+ years of experience.

Who should take this course -

1. Those who would like to build their career as SQL Server DBA OR Students /IT Graduates/MBA/MCA with basic computer knowledge and Basic SQL Server Skill. Please go with my other course for Beginners to Moderate level professional.

2. Existing DBA/IT professional who would like to learn advance level of SQL server as Database professional

3. Any other professional with Beginners level SQL server skills.

What aspiring learner will achieve after completion of this course -

1. He/She Will be professional Advance Level DBA or 2+ Level and 3+ Level DBA

2. Complete course to enter in an organisation as Sr. SQL Server DBA Professional ( L2 & L3+)

3. Free additional recommendation by instructor those who will enrol for this course upon request

Please visit to my course page to know more

Advantage : Upon your request enrolled professional or students can get free career guidance for limited period as a promotional activity and will guide them with most frequently asked questions and best answers with data bank.

Many Thanks.

Course Design, developed & Instruct by

Rakesh Jain | Leenetics

Who this course is for:

Those who want to build their career as SQL DBA/Student/IT Graduates
Existing DBA/IT professional who would like to know more about Advance level in SQL server as Database professional
Any other professional with basic SQL Server and IT skills .
IT Professionals who is facing production issue in SQL Server HADR area

SQL Server DBA 2017 - Advance Level - A Guide

What you'll learn

Explore related topics

Course content

SQL DBA 2017 - Advance Level - Introduction and Prerequisite1 lecture • 11min

SQL Server HA & DR Solution & Named Instance2 lectures • 34min

Transaction Log Shipping3 lectures • 34min

Replication10 lectures • 2hr 44min

DataBase Mirroring3 lectures • 46min

Always on Availability Group9 lectures • 3hr 12min

SQL Server Clustering - Components & Advantage with Implementation6 lectures • 1hr 42min

Resource Governor - A Overview1 lecture • 8min

Contained Database1 lecture • 17min

A Recap - Revision & Comping up Courses1 lecture • 16min

Requirements

Description

Who this course is for: