Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Life Purpose Meditation Personal Transformation Neuroscience Emotional Intelligence
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
IT & Software IT Certification SQL Server

SQL Server DBA 2017 - Advance Level - A Guide

SQL Server DBA - Advance Level
Rating: 3.6 out of 53.6 (18 ratings)
160 students
Created by Rakesh Jain
Last updated 1/2019
English
English [Auto]
30-Day Money-Back Guarantee

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.

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

Course content

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

  • Preview10:43

  • HADR Solution - A Overview
    14:55
  • Named Instance - Installation
    18:49

  • Log Shipping - Part 1 - Purpose,Components & Terms
    05:45
  • Log Shipping - Part2 - Configuration, Managing & Monitoring
    20:46
  • Log Shipping - Part 3 - Validating, Managing & Cleanup
    07:18

  • Replication - Types, Terms & Component
    12:05
  • SnapShot Replication - Part 1 - Configuration
    19:58
  • SnapShot Replication - Part 2 - Managing, Monitoring & Validation
    19:56
  • Transaction Replication - Part 1 - Configuration
    16:47
  • Transaction Replication - Part 2 - Managing , Monitoring & Validation
    18:14
  • Merge Replication - Part 1 - Configuration
    19:59
  • Merge Replication - Part 2 - Managing , Monitoring & Validation
    09:37
  • Peer to Peer Replication - Part 1 - Concept & Configuration
    17:30
  • Peer to Peer Replication - Part 2 - Managing & Monitoring & Validation
    19:06
  • Peer to Peer Replication - Part 3 - Validation & Cleanup
    10:29

  • DataBase Mirroring - Part 1 - Concept,Terms & Components
    13:06
  • DataBase Mirroring - Part 2 - Configuration & Management
    19:44
  • DataBase Mirroring - Part 3 - Validation , Monitor & Cleanup
    13:25

  • Always On - Part 1 - Concept ,Component, & Advantage with Implementation
    17:01
  • Always On - Part 2 - Windows Clustering - Configuration as Platform
    15:29
  • Always On - Part 3 - Windows Clustering - Validation & Monitoring
    19:12
  • Always on - Part 4 - Configuration with error handling
    28:06
  • Always On - Part 5 - Error Handling With Validation
    30:00
  • Always On - Part 6 - Monitoring & Validation
    32:06
  • Always On - Part 7 - 2017 Features - Deep Dive - Configuration
    17:48
  • Always On - 2017 - Part 8 - Features - Deep Dive - Configuration & Validation
    16:03
  • Always On - 2017 - Part 9 - Features - Deep Dive - Monitoring & Validation
    15:46

  • SQL Server Clustering - Part 1 - Overview
    13:43
  • SQL Server Clustering - Part 12.2 - Creating of Shared Storage
    22:34
  • SQL Server Clustering - Part 12.3 - Active-Passive Configuration
    28:06
  • SQL Server Clustering - Validation - Active-Passive Configuration
    13:41
  • SQL Server Clustering - Part 12.5 - Active-Active Configuration
    13:27
  • SQL Server Clustering - Part 12.6 - Active-Active Validation & Monitoring
    10:17

  • Resource Governor - A Overview
    08:13

  • Contained Database - Configuration & Validation
    16:45

  • Revision & Coming up Courses
    16:10

Instructor

Rakesh Jain
SQL DBA Architect
Rakesh Jain
  • 3.6 Instructor Rating
  • 48 Reviews
  • 286 Students
  • 3 Courses

Having 20+ years of Industry experience in IT and IT enabled services, Started career as faculty and now would like to share my Industry knowledge again being a faculty. Worked on multi platform during my career span and maximum time consumed in SQL Server platform as database and Architect DBA. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.