Radical Technologies

MS SQL SERVER DBA

A database administrator (DBA) directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use. DBA is also responsible for DBA Activities.

google
0 +

Google Reviews

0 +

JustDial Reviews

The Syllabus

Curriculum Designed by Experts

SQL Server & T-SQL installation, Architecture, DB Job Roles, Installation

Introduction to Databases, DBMS
Microsoft SQL Server : Advantages, Use
Versions and Editions of SQL Server
SQL DBA Job Roles, Responsibilities
Routine Maintenance DBA Activities
Emergency SQL DBA Activities
SQL Server Prerequisites : S/W, H/W
SQL Server 2019/2017/2016 Installation
Default Instance, Named Instances
Port Numbers, Instance Differences
Service and Service Account Use
Authentication Modes and Logins
Firewall Configuration in Real-time
SQLServr.exe and SQLBrowser.exe

SSMS Tool, SQL Basics

SSMS Tool Installation, Connections
SQL Server Management Studio
Single Server, Multi Server Connections
System Databases: Master and Model
MSDB, TempDB, Resource Databases
SQL and T-SQL : Basic Differences
DDL, DML, SELECT Statements
Using GUI and SQL Scripts in SSMS
Creating Databases : Files [MDF, LDF]
Creating Tables in SQL Server
Data Storage in Tables : Inserts
SELECT : Data Retrieval Statement
Table Scans. LIVE QUERY STATISTICS
Limitations with SSMS GUI Options

SQL for DBAs

Creating Databases in SQL Server
Database Connections and Usage
Creating Tables and Data Storage
Data Inserts and SELECT Statement
WHERE Conditions and Keywords
IN Operator and NOT IN Operator
Between, Not Between Operators
LIKE and NOT LIKE Operators
UPDATE Statement & Conditions
DELETE & TRUNCATE Statements
Logged and Non-Logged Operations
Table Structure Modifications
ADD, ALTER and DROP Columns
Aliases and Batch Statements

Schemas, Temporary Tables

Schemas : Group Tables in Database
Schemas : Security Management Object
Creating Schemas & Batch Concept
Using Schemas for Table Creation
Data Storage in Tables with Schemas
Data Retrieval and Usage with Schemas
Table Migrations across Schemas
Import and Export Wizard in SSMS
Data Imports with Excel File Data
Performing Bulk Operations in SSMS
Temporary Tables : Real-time Use
Local and Global Temporary Tables
# and ## Prefix, Scope of Usage
Session Level, Connection Level Use

Constraints, Indexes

Constraints and Keys – Data Integrity
NULL, NOT NULL Property on Tables
UNIQUE KEY Constraints: Importance
PRIMARY KEY Constraint: Importance
FOREIGN KEY Constraint: Importance
REFERENCES, CHECK and DEFAULT
Candidate Keys and Identity Property
Database Diagrams and ER Models
Relationships Verification and Links
Indexes : Basic Types and Creation
Index Sort Options, Search Advantages
Clustered and Non Clustered Indexes
Primary Key and Unique Key Indexes
Need for Indexes – working with Keys

Joins & Audits

JOINS – Table Comparisons Queries
INNER JOINS For Matching Data
OUTER JOINS For (non) Match Data
Left Outer Joins with Example Queries
Right Outer Joins with Example Queries
FULL Outer Joins – Real Time Scenarios
Join Queries with “ON” Conditions
Join Unrelated Tables in SQL Server
NULL, IS NULL Operators in Joins
CROSS JOIN and CROSS APPLY
CROSS JOIN Versus CROSS APPLY
One-way & Two Way Data Comparisons
Important Join Queries in T-SQL
Join Options: Merge, Loop, Hash

View, Procedures, UDF Basics

Views : Types, Usage in Real-time
System Predefined Views and Audits
Listing Databases, Tables, Schemas
Functions : Types, Usage in Real-time
Scalar, Inline and Multi-Line Functions
System Predefined Functions, Audits
DBId, DBName, ObjectID, ObjectName
Date and Time Functions : Getdate()
Variables & Parameters in SQL Server
Procedures : Types, Usage in Real-time
User & System Predefined Procedures
Parameters and Dynamic SQL Queries
Sp_help, Sp_helpdb and sp_helptext
sp_pkeys, sp_rename and sp_help
sp_recompile, Performance Benefits
System Objects for Metadata Access

Transactions, Linked Servers

Linked Servers and Real-time Usage
Creating Linked Servers in SQL Server
Security Options and Access Options
Data Access, RPC and RPC Out Settings
Automations with Triggers: DML,DDL
INSERTED, DELETED Memory Tables
Table Data Replication using Triggers
Transactions : Types, ACID Properties
Transaction Types and AutoCommit
EXPLICIT & IMPLICIT Transactions
COMMIT and ROLLBACK Statements
SQL Server Configuration Manager Tool
Services : Start and Stop Options
Network Configurations and Protocols
SQL Server Instance: Ports, Aliases

 

Server, DB Architecture

Server Architecture and Protocols
Database Engine and Query Processor
Parser, Optimizer, SQL & DB Manager
Storage Engine Components, SQL OS
File Manager and Database Files
Transaction Services, Buffer Manager
Lock Manager, IO Manager, MDAC
CLR, WAL, Lazy Writer, Checkpoint
Database Architecture – Data Files
Database Architecture – Log Files
Primary (mdf), Secondary Files (ndf)
Filegroups Usage, ReadOnly Filegroups
Database Files : Size and Location
Pages, Extents. Uniform, Mixed Extents
Transaction Log File [LDF], LSN, VLF

SQL DBA – Backup-Restores, Jobs, Performance Tuning, Security : Backups – DB, Filegroup, File

Database Backups, Filegroup Backups
Log File Backups and Log Truncations
COPY_ONLY Backups and Real-time Use
Mirror Backups and Split Backups
Partial Backups – ReadOnly Filegroups
Format, Compression and Checksum
Backup Verification, RetainDays, Stats
ContinueOnError and Backup Scripts
GUI and Script Backups: Differences
Backup History Tables in MSDB – Joins
Backup Audits. HOT and COLD Backups
Backup Devices – Creation and Usage
Using Backup Devices – Advantages
Common Errors and Solutions

Restores & DB Recovery

Restore Phases – COPY, REDO, UNDO
RECOVERY, NORECOVERY Options
STANDBY and REPLACE in Restores
File, File Group & Metadata Restores
Backup Verifications using GUI, Scripts
VERIFYONLY : Backup Verification
STATS, UNLOAD, STOPAT and INIT
PARTIAL / PIECEMEAL Restores – Use
Tail Log Backup Usage in Real-time
Restores using GUI and T-SQL Scripts
MOVE Options for File Level Restores
Point-In-Time Restore, Checkpoint LSN
Standby Restores and Read-Only State
Common Errors and Solutions

Jobs, Maintenance Plans

SQL Server Agent Service & Agent XPs
SQL Agent Jobs – GUI, Script Creations
Job Steps – Creation, Edits and Parse
Job Executions, Disable/Enable Options
Job History Purge. Job Activity Monitor
Database Maintenance – Backup Jobs
Scheduling Database Maintenance Plans
Automated Job Creations using DMPs
Backup Cleanup & History Cleanup Jobs
Backup Strategies For Minimal Data Loss
Backup Options: Block Size, Transfer Size
DB Mail Configurations and Alert System
DB Mail Profiles, SMTP Email Accounts
Operators : Creation, Job Notifications

Security Management

Authentication Types & Modifications
Windows Logins & SQL Server Logins
Logins – Users Mapping, DB Access
Server Roles & Database Roles – Usage
Object, Column and Schema Security
GRANT, WITH GRANT, DENY, REVOKE
CONTROL, OWNERSHIP, Authorization
Data Encryption: Keys and Certificates
Data Encryption with Stored Procedures
Job Security : Credentials and Proxies
Using Proxies for SSIS Jobs, Repl Jobs
Security Scripts and Documentation
DMVs for Security Audits, Orphan Users
Login, User, Server Principal Audits

Migrations & SLA-OLA

CDW : Copy Database Wizard @ SSMS
Database Detach and Attach Options
SMO Method and Database Scripting
CDW SSIS Packages, SSIS Proxies Use
Scheduling Database Migration Jobs
Detecting and Resolving Orphan Users
Containment Databases Authentication
SLA and OLA Process, Ticketing Tools
Immediate, High, Normal Priorities
Impact, Urgency and SLA Metrics
Licensing and Pricing Options
Core Based Licenses. Device CALs
User CALs and Multiplexing Concept
Versions, Editions Comparisons

Tuning 1 – Audits, Indexes

Audit Long Running Queries : DMV, DMF
Activity Monitor Tool, Server Dashboards
Logical I/O, Physical I/O, Database I/O
Recent Expensive Queries, Wait Time
Active Expensive Queries, Statistics
Plan Handle, Execution Time – Audits
CPU, IO, Memory Consumption Reports
Indexes: Architecture and Index Types
B Tree Structure, IAM Page [Root]
Clustered & NonClustered Indexes
Included, Columnstore, Online
Filtered, Covering, Indexed Views
Fill Factor and Pad Index Options
Query Store – Settings and Advantages

Tuning 2 – Index Management

PARTITIONS : Advantages, Performance
Partition Functions & Partition Schemes
Partitioning Un-partitioned Tables: GUI
Partition Compression : ROW and PAGE
Auditing Table Partitioned Structures
Statistics : Purpose, Auto Creation
Statistics : Audits and Updates
Working with Indexes and Partitions
Internal and External Fragmentation
Index Rebuilding Process and Audits
Database Maintenance Plans Jobs
Last Used, Page Count, Fragmentation
Index Page Count and Index Condition
Degree Of Parallelism [DOP] Settings
Resumable Indexes: ONLINE, RESUME
PAUSE & RESUME in Index Rebuilds

Tuning 3 – Tuning Tools, Locks

Tuning Tools : Workload Files, Trace Files
Profiler Tuning Template, SP Events
DTA, Profiler Trace : Recommendations
Perfmon Tool Counters, Real-time Tracking
Execution Plan Analysis and Internals
Query Costs : IO Cost and CPU Cost
Query Costs: SubTree & Operator Cost
NUMA Nodes, Processor, IO Affinity
Thread Count, Degree of Parallelism
LOCKS : Types and Isolation Levels
S, X, IX,U, MD, Sch-M and Sch-S
Lock Audits : SP_WHO2 and SP_LOCK
sysprocesses and Lock Waits : Audits
Deadlock Audits and Deadlock Graphs
XDL Files and Deadlocks Prevention

Health Checks, Issues, Solutions

Alerts : Creation and Notifications
DB Suspect Event Alerts (023)
Important Perfmon Counters, Alerts
Log Space, Memory, Tempdb Alerts
Scheduling Alerts & Notifications
DBCC CHECKDB : DB Health Checks
Allocation Errors, Consistency Errors
DBCC ShowContig, Extent Fragmentation
Trace Flags and EstimateOnly
DBCC Page: GAM, SGAM and PFS
Consistency Errors : Cause & Solutions
Allocation Errors : Cause and Solutions
Log Space Issues and Log Rebuilds
Memory & TempDB Issues, Solutions
DBCC ShrinkDB and Page Restores

SQL DBA PROJECT – Level 1

Audit Login Failures : Server Logs
Monitoring Connectivity Issues
Database Refresh and MSDTC
Adhoc Memory Dump Files
PLE (Page Life Expectancy) Issues
Object Refresh and Recompilations
Server Registrations and Operations
Lock Monitoring Operations
Index Management Options
Open Transactions, Blocking
Metadata Sync-up Issues
Stored Procedure Recompilations
Backup and HA-DR Strategies
Db Restores and DB Repairs
Health Checks, Issues, Solutions

Enquire Now

    Why Radical Technologies

    Live Online Training

    Highly practical oriented training
    Installation of Software On your System
    24/7 Email and Phone Support
    100% Placement Assistance until you get placed
    Global Certification Preparation
    Trainer Student Interactive Portal
    Assignments and Projects Guided by Mentors
    And Many More Features
    Course completion certificate and Global Certifications are part of our all Master Program

    Live Classroom Training

    Weekend / Weekdays / Morning / Evening Batches
    80:20 Practical and Theory Ratio
    Real-life Case Studies
    Easy Coverup if you missed any sessions
    PSI | Kryterion | Redhat Test Centers
    Life Time Video Classroom Access ( coming soon )
    Resume Preparations and Mock Interviews
    And Many More Features
    Course completion certificate and Global Certifications are part of our all Master Program

    Self Paced Training

    Self Paced Learning
    Learn 300+ Courses at Your Own Time
    50000+ Satisfied Learners
    Course Completion Certificate
    Practical Labs Available
    Mentor Support Available
    Doubt Clearing Session Available
    Attend Our Virtual Job Fair
    10% Discounted Global Certification
    Course completion certificate and Global Certifications are part of our all Master Program

    Skills Covered

    • SA1 , SA2 ,SA3

    • RHEL 6/7/8/9

    • Virtualization

    • Type1 & Type2

    • CCNA Foundation

    • Networking

    • Servers-SSH/DHCP/DNS/
      Apache/Nginx/Apache Tomcat/MySQL/NTP/FTP/
      NFS/Samba/SMTP/Proxy

    • SAN/NAS/All RAID/LVM Storage

    • Backup Solutions

    • Security - all types of firewall

    • Scripting..  Bash scripting

    • Automation Tool - Complete Ansible

    • 250 hrs Hands on training

    • Resume preparation

    • Mock test interview preparation

    • Migration strategy

    • Server Hardening

    • Docker & Kubernetes

    • Basics AWS comparison with Linux

    • 150+ live on scenarios

    tool covered

    Why Enroll for Red Hat Linux

    Covers each topics with Real Time Examples . Covers More than 250+ Real Time Scenarios which is divided into L1 ( Basic ) + L2 ( Intermediate) and L3 ( Advanced ) . Trainer from Real Time Industry .This is completely hands-on training , which covers 90% Practical And 10% Theory

    We give Combo Pack of RHEL 6 with RHEL 7 , to make sure all the candidate will get at least 5+ Year experience knowledge in Redhat Linux after attending this course.Covers SA1 + SA2 + SA3 topics in Details from the very basic to advanced level .

    Complete RHCSA and RHCE Exam Preparations.Appear for Redhat Global Certification Exam At any time After the course – No need to wait to get schedule from Redhat .At your convenient time , you can book and appear for exam using our Individual Exam Delivery System called KOALA

    Course benefits

    • Agentless Architecture

    • Simplicity and Ease of Use

    • Idempotent Execution

    • Infrastructure as Code (laC)

    • Broad Platform Support:

    • Scalability and Performance

    • Community and Support

    Who Can Apply for Red Hat Linux

    Why Red Hat Linux

    Industry Recognition

    Red Hat certifications are widely recognized in the IT industry. Holding a Red Hat certification demonstrates to employers that you have the skills and knowledge needed to effectively work with Red Hat Linux systems.

    High Demand for Linux Skills

    Linux is a dominant operating system in the server market, particularly in enterprise environments. Many organizations, including tech giants, financial institutions, and government agencies, rely on Linux for their infrastructure. As a result, there is a high demand for professionals with Linux skills, including Red Hat Linux expertise.

    Specialized Knowledge

    Red Hat Linux is a popular distribution used in enterprise environments due to its stability, security, and support offerings. By gaining expertise in Red Hat Linux through a certification course, you position yourself as a specialist in this specific distribution, which can make you more attractive to employers who use or plan to use Red Hat Linux.

    Job Opportunities

    Holding a Red Hat certification opens up various job opportunities in roles such as Linux system administrator, DevOps engineer, cloud engineer, network engineer, and more. Many job postings in these fields specifically mention Red Hat certifications as desired or required qualifications.

    Salary Potential

    Professionals with Red Hat certifications often command higher salaries compared to their non-certified counterparts. Employers value certified individuals for their proven skills and expertise, leading to potentially higher earning potential.

    Career Advancement

    Red Hat certifications can help you advance your career by providing a clear path for skill development and progression. As you gain more advanced certifications, you become eligible for more senior roles and responsibilities within organizations.

    Like the Curriculum ? Let's Get Started

    Global Certification

    Radical Technologies is the leading IT certification institute in Bangalore, offering a wide range of globally recognized certifications across various domains. With expert trainers and comprehensive course materials, it ensures that students gain in-depth knowledge and hands-on experience to excel in their careers. The institute’s certification programs are tailored to meet industry standards, helping professionals enhance their skillsets and boost their career prospects. From cloud technologies to data science, Radical Technologies covers it all, empowering individuals to stay ahead in the ever-evolving tech landscape. Achieve your professional goals with certifications that matter.

    course certificate

    Red Hat Linux Fees in Bangalore

    Online Classroom PREFERRED

    16 jul

    TUE - FRI
    07.00AM TO 09.00
    AM LST (GMT +5:30)
    Radical

    20 jul

    SAT - SUN
    10.00AM TO 01.00
    PM LST (GMT +5:30)
    Radical

    20 jul

    SAT - SUN
    08.00PM TO 11.00
    PM LST (GMT +5:30)
    Radical

    ₹ 85,044

    Online Classroom PREFERRED

    Online

    05 Feb

    Weekday

    06:00 PM TO 07:00 PM IST (GMT +5:30)

    Ms Sql Server Dba Training & Certification In Bangalore
    Highly Experienced Certified Trainer with 10+ yrs Exp. in Industry
    ENROLL NOW

    Discount Voucher

    "Register Now to Secure Your Spot in Our Featured Course !"

    BOOK HERE

    career services

    About Us

    At Radical Technologies, we are committed to your success beyond the classroom. Our 100% Job Assistance program ensures that you are not only equipped with industry-relevant skills but also guided through the job placement process. With personalized resume building, interview preparation, and access to our extensive network of hiring partners, we help you take the next step confidently into your IT career. Join us and let your journey to a successful future begin with the right support.

    At Radical Technologies, we ensure you’re ready to shine in any interview. Our comprehensive Interview Preparation program includes mock interviews, expert feedback, and tailored coaching sessions to build your confidence. Learn how to effectively communicate your skills, handle technical questions, and make a lasting impression on potential employers. With our guidance, you’ll walk into your interviews prepared and poised for success.

    At Radical Technologies, we believe that a strong professional profile is key to standing out in the competitive IT industry. Our Profile Building services are designed to highlight your unique skills and experiences, crafting a resume and LinkedIn profile that resonate with employers. From tailored advice on showcasing your strengths to tips on optimizing your online presence, we provide the tools you need to make a lasting impression. Let us help you build a profile that opens doors to your dream career.

    Red Hat Linux Course Projects

    Infrastructure Provisioning

    And Configuration Management

    Implementing automated infrastructure provisioning and configuration management using Ansible. This may include setting up servers, networking devices, and other infrastructure components using playbooks and roles. 

    software-developer

    Applications Deployment

    And Orchestration

    Automating the deployment and orchestration of applications across development, testing, and production environments. This could involve deploying web servers, databases. middleware, and other application components using Ansible

    Continuous Integration

    And Continuous Deployment

    Integrating Ansible into CI/CD pipelines to automate software. build, test, and deployment processes. This may include automating the creation of build artifacts, running tests, and deploying applications to various environments.