DBA SQL Server + Always on (HADR)

Description

Management of an execution plan, installation according to best practices, execution of monitoring tasks, management and basic tasks from day to day to one of the most requested tasks, always on availability groups configuration.

The profession of Da (Administrator / Data Analyst) and DBA (Database Administrator) have a fundamental and strategic palel in an organization. A function of administration of technological systems that allow the organizing, structuring and distribution of information of a company.

A course that fosters this knowledge, very complete requirements for a good professional!

For whom is this course:

• Students
• Technology professionals
• Technology consultants
• Database Technology Enthusiasts
• Professionals and students who want to enter the DBA area

Section 1: Introduction

1. Instructor Presentation
2. Support material
3. The DBA
4. About SQL Server
5. Limits
6. Installation requirements

Section 2: Installing and Parameterizing SQL Server 2017

7. Installation Scenario
8. Installation of the . net Framework
9. Installing SQL Server 2017 1st Instantiation
10. Installing SQL Server Management Studio
11th SMSS Overview
12th System Databases
13. Installing the 2nd SQL Server Instance
14. Knowing the file structure
15. Configure and Reconfigure
16. Configuring memory for SQL Server

Section 3: Recommended settings and data files

17. Good Security Practices
18. Disabling NetBios and SMB
19. Enabling TCP/IP, Named Pipes and Swapping the Default Port
20. Data Files, Primary, Secondary, and Log

Section 4: DDL Language Definitions

21. DDL Language Definitions
22nd Constraints
23. DDL Commands Part 1
24. DDL Commands Part 2
25. DDL Commands Part 3
26. DDL Commands Part 4

Section 5: Security - Server, Databases, and Objects

27. SQL Server Security Overview
28. Difference between Login and Users
29. Server Roles
30. Database Roles
31. Object Permissions - DCL
32. Creating Server Logon
33. Creating database users
34. Modifying A Bank Owner 1
35. Modifying A Bank Owner 2
36. DCL GRANT PART 1
37. DCL GRANT PART 2
38. DCL REVOKE PART 1
39. DCL REVOKE PART 2
40. DCL DENY PART 1
41. DCL DENY PART 2

Section 6: SCHEMAS

42. INTRODUCTION TO SCHEMAS
43. WORKING WITH SCHEMAS PART 1
44. WORKING WITH SCHEMAS PART 2

Section 7: MAINTENANCE MODES

45. INTRODUCTION MAINTENANCE MODES
46. PRACTICING MAINTENANCE MODES PART 1
47. PRACTICING MAINTENANCE MODES PART 2

Section 8: BACKUP AND RESTORE

48. INTRODUCTION TO BACKUP
49. BACKUP AND RESTORE GRAPHIC MODE
50. BACKUP AND RESTORE COMMAND LINE MODE
51. BACKUP AND RESTORE LOG
52. BACKUP AND DIFFERENTIAL RESTORE
53. BACKUP AND RESTORE MULTIPLE FILES
54. BACKUP AND RESTORE BACPAC

Section 9: DAY-TO-DAY ACTIVITIES AND TASKS

55. INFORMATION OF THE INSTANCE
56. INTRODUCTION ATACH AND DETTACH
57. ATACH AND DETTACH GRAPHIC MODE
58. ATACH AND DETTACH T-SQL
59. SHRINK INTRODUCTION
60. APPLYING SHRINK
61. CONFIGURING DATABASE MAIL
62. CONFIGURING OPERATOR
63. ANALYZING THE FRAGMENTATION OF INDICES PART 1
64. ANALYZING THE FRAGMENTATION OF INDICES PART 2
65. ANALYZING SPACE AND GROWTH OF DATABASES

Section 10: MANAGING LOCKS, BLOCK AND DEADLOCKS

66. WHAT IS LOCK, BLOCK AND DEADLOCK
67. LOCK AND BLOCK SITUATIONS
68. DEADLOCK SITUATIONS

Section 11: DATABASE STATISTICS

69. INTRODUCTION TO DATABASE STATISTICS
70. APPLYING STATISTICS MODES

Section 12: DBCC - DATABASE CONSOLE COMANDS

71. DBCC INTRODUCTION
72. DBCC - MISCELLANEOUS
73. DBCC - INFORMATION
74. DBCC - VALIDATION
75. DBCC - MAINTENANCE

Section 13: AGENT AND MAINTENANCE PLAN

76. AGENT INTRODUCTION
77. CONFIGURING AGENT
78. SCHEDULING BACKUP TASK
79. SCHEDULING STATISTICS TASK
80. MONITORING JOBS
81. BACKUP MAINTENANCE PLAN
82. BACKUP MAINTENANCE PLAN ADD-ON
83. CKECKDB MAINTENANCE PLAN
84. EDITING MAINTENANCE PLAN

Section 14: DMV - DYNAMIC MANAGEMENT VIEWS

85. INTRODUCTION DMV
86. DMV INFORMATION
87. LOG FILE DMV
88. SESSION DMV
89. DMV QUERY HEAVIER
90. DMV DE TRACES

Section 15: LINKED SERVER

91. INTRODUCTION TO LINKED SERVER
92. LINKED SERVER CONFIGURATION PART 1
93. LINKED SERVER CONFIGURATION PART 2

Section 16: SQLCMD

94. SQLCMD INTRODUCTION
95. CONNECTING SQLCMD
96. RUNNING BAT WITH SQLCMD

Section 17: PERFORMANCE OVERVIEW

97. LOGICAL PROCESSING SQL STATEMENT
98. PERFORMANCE ADJUSTMENT CYCLE
99. PERFORMANCE ADJUSTMENT TIPS
100. KNOWING INDEX(INDICES)
101. HOW THE BTREE INDEX WORKS
102. PERFORMANCE ANALYSIS PART 1
103. PERFORMANCE ANALYSIS DATABASE
104. PERFORMANCE ANALYSIS DATA COLLECTION - EXECUTION PLAN
105. PERFORMANCE ADJUSTMENTS PART 1
106. SETTINGS FOR PERFORMANCE PART 2

Section 18: CONFIGURING ALWAYS ON (HA-DR)

107. INTRODUCTION ALWAYS ON AVAILABILITY GROUPS
108. PRESENTATION OF THE USE CASE
109. PREREQUISITES AND TIPS
110. AVAILABILITY MODES
111. INSTALLING WINDOWS SERVER FAILOVER CLUSTERING (WSFC)
112. CONFIGURING WSFC
113. CONFIGURING QUORUM
114. MANAGER CONFIGURATION PARAMETERS
115. CREATING DATABASE FOR HA
116. SETTING UP AVAILABILITY GROUPS
117. CONFIGURING LISTENER (VIRTUAL IP)
118. JOIN DATABASE IN AVAILABILITY GROUPS
119. SQL SERVER PANEL FAILOVER TEST
120. WSFC PANEL FAILOVER TEST
121. Hadr's DMV ́S