SQL Server DBA in Telugu

This SQL Server DBA course is based on SQL Server 19 version and also suitable

for previous versions 14,17 also latest versions. This course will cover from the

basics of SQL Server DBA, Installation of SQL Server, How to work with SSMS

to apply Basic SQL commands like Create, Alter, Drop, insert, update, select, commit, rollback etc., Backup & Restoration ,System databases, Security sessions like logins, users, roles & encryption. Also covers different types of databases and High availability and Disaster Recovery.

Topics Covered in this course

1. Introduction to SQL Server DBA
2. SQL Server Uses
3. SQL Server Components and SQL server Services and Tools
4. Instances of SQL Server
5. SQL Server Editions
6. SQL Server Installation and SSMS Setup
7. SQL Server how to start and SQL Server Management Studio IDE
8. Create database and table in SQL Server
9. Difference between SQL, SQL Server , MySQL, ORACLE
10. Data Types in SQL Server
11. SQL Commands Or SQL Statements in SQL Server
12. Create Table, Alter Table, Drop Table statements in SQL Server
13. Insert into statement in SQL Server
14. Select Statement in SQL Server with Clauses
15. Update, Delete, Truncate, sp rename in SQL Server
16. Commit Rollback SavePoint Statements in SQL Server
17. Adventureworks database restore.
18. Backup in SQL Server DBA Part 1.
19. Backup in SQL Server DBA Part 2.
20. Database Recovery Models and Restoring Databases in SQL Server DBA.
21. Backup Maintenance Plans in SQL Server DBA.
22. Login and User Creation in SQL Server DBA security.
23. Roles and Permissions in SQL Server DBA security.
24. Encryption in SQL Server DBA security.
25. System Databases in SQL Server DBA.
26. Snapshot databases in SQL Server DBA.
27. Contained databases in SQL Server DBA.
28. High availability & DR with Log Shipping in SQL Server DBA.
29. Snapshot and Transactional Replications in SQL Server DBA.
30. Merge and Peer to Peer Replication in SQL Server DBA.
31. Windows server installation in Virtual Box SQL Server DBA.
32. Active Directory Domain and Nodes Creation in windows server – SQL Server DBA.
33. SQL Server setup in windows server – SQL Server DBA.
34. Windows Failover Cluster Creation – SQL Server DBA.