Launch Your Global Career with Maersk – Placement Drive 2025 @ ZebLearn | Applications Close In 0d 0h 00h 00s

ZebLearn Certification Partners – Globally Recognized Credentials!

ZebLearn partners with leading industry experts to offer genuine, career-focused certifications in SAP training, foreign languages, and professional development courses. Earn internationally recognized credentials, enhance your career prospects, and distinguish yourself with certifications valued by the industry.

cisco
apple
esb
abode
Partner
meta
pmi
ic3
Partner
Partner
Partner
Partner
communication

Course content

About SQL Server DBA program

  • Introduction
  • Course overview
  • Introduction to Database
  • What is RDBMS?
  • What is SQL?
  • Top 5 RDBMS using SQL
  • Introduction to Microsoft SQL Server
  • Different Editions of Microsoft SQL
  • Welcome to Download, Install, and Configure Windows
  • MS SQL Server Pre-requisite
  • Lab Setup
  • What is Virtualization?
  • Download and Install VMWare Workstation Player
  • Optional: Download and Install Oracle Virtualbox
  • Create a Virtual Machine
  • Download and Install Windows Server (2016)
  • Fix EFI Network Time Out Error for VM Player
  • Download and Install Windows Server (2019)
  • Virtual Machine Management
  • Welcome to Database Fundamentals and Design
  • What is Data?
  • What is Database?
  • How Data is Stored?
  • What is a Table, COLUMN, and ROW?
  • What is a Key?
  • What is Primary Key, Foreign Key, Unique Key, etc.?
  • What is Relational Database and Relational Database Management System (RDBMS)?
  • What is a Transaction and ACID Properties?
  • Database Normalization and Different Forms of Database Normalization
  • Create Your First Database, Table, and Populate Table with Data
  • Welcome to Basic SQL Commands
  • What is a SQL Statement and Types of SQL Statements
  • DML Statements with Examples
  • DDL Statements with Examples
  • DCL Statements with Examples
  • TCL Statements with Examples
  • Welcome to Query and Manipulation of Data using SQL Commands
  • Create TABLE(s) and Temp Table(s)
  • What Is a View?
  • SELECT Statement in Detail
  • Operators, Expressions, and Conditions
  • WHERE Clause, ORDER BY Clause, HAVING Clause, GROUP BY Clause
  • Select from Two Tables - JOINS
  • Different Types of JOINS
  • What is a Sub Query?
  • INSERT Statement in Detail
  • UPDATE Statement in Detail
  • DELETE Statement in Detail
  • Difference between DELETE and TRUNCATE Statement
  • What is a Stored Procedure?
  • What is a Function?
  • What is a Trigger?
  • What is an INDEX?
  • Clustered, NonClustered Indexes and Index Design Considerations
  • Index Fragmentation and Lab for Index
  • Welcome to Microsoft SQL Database Administration and System Databases
  • Overview of MSSQL Management Tools
  • Exploring SQL Server Management Studio (SSMS) (Part 1)
  • Exploring SQL Server Management Studio (SSMS) (Part 2)
  • Exploring SQL Server Configuration Manager
  • MSSQL System Databases, DO's and DONT's of System Databases
  • What is master Database?
  • What is tempdb Database?
  • What is msdb Database?
  • Other System Databases (model, distribution)
  • Welcome to Deep Dive into MSSQL Working
  • What are Pages, Extents, Page Architecture, and PFS?
  • MSSQL Architecture
  • MSSQL Database Architecture
  • Operation and Working of Transaction Log
  • Welcome to MSSQL Backup and Restore
  • Backup of a Database, Importance for DBA and Different Media’s Used for Backups
  • Recovery Models in MSSQL and How They Impact Backups and Restore
  • Full Backups
  • Differential Backups
  • Transaction Log Backups, Log Backup Chain, and Tail-log Backup
  • Lab for Full, Differential, and Transaction Log Backups
  • Restore and Recovery Overview
  • Full, Differential, and Transaction Log Database Restore
  • Point in Time Restore of a Database
  • Complete Backup, Restore, and Restore in Time Lab
  • MS SQL Server DBCC CHECKDB Command
  • Page Level Restore/Recovery Using Full Backups
  • Restore Master Database
  • Creating Maintenance Plan Backups / Reindexing, etc.
  • MSSQL Backup and Restore
  • Welcome to MS SQL User Management
  • MSSQL Security Model
  • MSSQL Server Authentication Modes
  • Principals (Part-1): Server Logins, Server Roles
  • Principals (Part-2): Database Users, Database Roles
  • Permissions (GRANT, DENY, REVOKE)
  • MSSQL User Management
  • Welcome to Overview of MSSQL Server Agent
  • SQL Server Agent Introduction
  • SQL Server Agent Jobs and Schedules
  • Agent Alerts, Operators, Database Mail, and Activity Monitor
  • MSSQL Server Agent Management
  • Introduction to Advanced Topics in MSSQL Server Administration
  • High Availability and its Types
  • What Is Replication and Transactional Replication Setup
  • Transactional Replication Setup (LAB)
  • Log Shipping and Configuring Log Shipping
  • SQL Server Query Tuning
  • Query Optimization Lab
  • SQL Server Encryption and Encryption Types
  • Transparent Data Encryption (TDE), Configuration and Restore of TDE Databases
  • Why Should You Learn SQL Server DBA Training?

    The annual salary of an SQL Server DBA is $125k.

    Request more information

    What you will get at Zeblearnindia Learning?

    Zeblearnindia Learning is a premier institute offering training in SAP Online Courses, Web Designing, Data Science, Full-Stack Development, Salesforce, Workday, Machine Learning, Software Testing, and Video Editing. With the option to choose between online and offline (classroom) learning, our well-structured courses cater to students, working professionals, business owners, and entrepreneurs. Here’s what you can expect at Zeblearnindia Learning:

    •   Expert-Led Training
    •   Globally Recognized Certifications
    •   100% Job Placement Support
    •   Hands-On Learning
    •   Flexible Learning Options
    •   Affordable Course Fees
    •   Career Growth Opportunities
    best-seller-min

    () 60 Minutes WEBINAR with CERTIFICATE

    Date Time IST (GMT +5:30) Event Free Sign Up

    Explore Our Courses Across India - Flexible batches

    We are proud to offer our SQL Server DBA program services across numerous states nationwide.

    Call Us
    WhatsApp
    Questions? WhatsApp us.
    Placements query?

    We use cookies to improve your experience and personalize our site. cookie policy