Full Course Microsoft SQL Server DBA with Azure SQL DBA
Instructor
vsitacademy@gmail.com
- Description
- Curriculum
Microsoft SQL Server DBA
-
1
Day1- What is Microsoft SQL Server DBA?With the right training, you can open new doors and reach the highest salary you've always wanted! Microsoft SQL Server DBA with Azure SQL DBA Training and Job Support! ✅ Real-time projects & hands-on training ✅ For freshers, career gap individuals & job changers ✅ Guidance & job assistance Enroll now & take the first step towards a successful IT career! Please forward this to your friends if anyone is interested, follow channel
-
2
Day2-Microsoft SQL Server Versions
-
3
Day3-Microsoft SQL Server Version Part2
-
4
Day4-Microsoft SQL Server Editions
-
5
Day5-Microsoft SQL Server 2022 Installation
-
6
Day6-SSMS
-
7
Day7-Microsoft SQL Server Database files
-
8
Day8-Microsoft SQL Server System Databases
-
9
Day9-Microsoft SQL Server Compatibility Level GDR CU and SPs
-
10
Day10-Microsoft SQL Server Compatibility Level GDR CU and SP Part2
-
11
Day11-Microsoft SQL Server Login and Authentication Modes
-
12
Day12-Create MSSQL Database and Tables
-
13
Day13 SQL Server Security Part1
-
14
Day14 SQL Server Security Part2
-
15
Day15 SQL Server Security Part3
-
16
Day16 Pages and Extents
-
17
Day17 -Recovery Models
-
18
Day18 SQL Server- Buffer Pool, Dirty Pages, Checkpoint and WAL
-
19
Day19 SQL Server- Committed and Uncommitted , Active and Inactive TRANSACTIONS
-
20
Day19 SQL Server - Backups and Backup Types Part1
-
21
Day20 SQL Server - Backups and Backup Types Part2
-
22
Day21 SQL Server -Backups and Backup Types Part3
-
23
Day22 SQL Server -System DB Backup and Support
-
24
Day22 SQL Server-Installation On RDP Server
-
25
Day23 SQL Server-Database Restore
-
26
Day24 SQL Server-Database Refresh
-
27
Day25 SQL Server-Database Refresh part2
-
28
Day26 SQL Server-Point In Time Recovery and SQL Agent Jobs
-
29
Day27 SQL Server -Maintenance Plan
-
30
Day28 SQL Server-Database Attach and Detach
-
31
Day29 SQL Server-Copy Database Wizard
-
32
Day30 SQL Server -Table Level Backup
-
33
Day31 SQL Server -Shrinking User Databases and TEMPDB
-
34
Day32 SQL Server-Linked Server and DB Mail Configuration
-
35
Day33 SQL Server-Linked Server Part2
-
36
Day33 SQL Server-Linked Server Part3
-
37
Day34 SQL Server-High Availability(HA)
-
38
Day35 &36 SQL Server -Log Shipping
-
39
Day37 SQL SERVER-LOG SHIPPING Part2
-
40
Day38 SQL server -SQL Server Service account
-
41
Day39 SQL Server-Database Mirroring
-
42
Day40 SQL Server - AlwaysOn Availability Group(AOAG)
-
43
Day41 SQL Server - AlwaysON Group Part2
-
44
Day42 SQL Server - AlwaysOn Availability Group(AOAG) - Availability Group Listener
-
45
Day43 SQL Server - Replication
-
46
Day44 SQL Server - Replication Part2
-
47
Day45 SQL Server - Replication Part3
-
48
Day46 SQL Server - Replication adding article part4
-
49
Day47 SQL Server - SQL failover cluster
-
50
Day48 SQL Server-Failover cluster part2
-
51
Day49 SQL Server - Database File Movements
-
52
Day50 SQL Server- Database File Movements Part2
-
53
Day51 SQL Server - Blocking and Deadlock
-
54
Day52 SQL Server-Deadlock Graph and INDEXES
-
55
Day53 SQL Server - INDEX Fragmentation
-
56
Day54 Microsoft Azure - Introduction
-
57
Day55 Microsoft Azure - Basics
-
58
Day56 Microsoft Azure - Create Azure account and Create Azure VM
-
59
Day57 Microsoft Azure - Install SQL Server In Azure VM
-
60
Day58 Microsoft - Azure Storage
-
61
Day59 Microsoft Azure - Database backup from on-premises to Azure Storage Account
-
62
Day60 Microsoft Azure - Database Restore from on prem to Azure VM SQL
-
63
Day61 Microsoft Azure - Azure SQL Creating Database and Migrating DB using Bacpac and Dacpac
QUIZ
-
64
MSSQL QUIZ 01SQL Server Quiz part1 -
65
MSSQL QUIZ 02:SQL Server Installation and PatchingSQL Server Installation and Patching
-
66
MSSQL QUIZ -03: SecuritySQL Security
-
67
MSSQL QUIZ- 04SQL Server Backups
-
68
MSSQL QUIZ- 05: Restore
-
69
MSSQL QUIZ- 06(Random Topics)
-
70
Day43 SQL Server - Replication
