DBA SQL Server 2016 Essential

Description

The world of one of the most widely used database managers in the job market: SQL Server. You learn from the beginning, how to install SQL Server in a professional way in an Active Directory domain, learn the protocols and their advantages, server architecture, file sizing and distribution in different Hard Services, access security and permissions, sending e-mail, generating alerts of various configurations, all in a virtual environment.

For whom is this course:

• University students who want to enter the DBA area
• Professionals who want to deepen their knowledge in a large-scale Database
• Database Students
• Database interns

Section 1: Let's download!

1. Downloading Windows Server 2012
2. Download SQL Server 2016 - Developer
3. Downloading Virtualbox

Section 2: Building the environment - Look how much to learn (and do)!

4. Creating the first VM - Domain Controller
5. Windows 2012 installation in domain controller
6. Guest Additions
7. Classic Shell
8. Renaming a Windows 2012 Server

Section 3: Wait! Where am I?

9. Don't know what a domain is? Let's learn!

Section 4: Understanding a little about physical and logical networks

10. Setting up network modes
11. Promoting a server to Domain Controller
12. Organizational Units and Accounts Services

Section 5: Installing SQL Server professionally and securely

13. Creating the Database Server - Adding Disks to Data Files and Logs
14. Preparing Windows to be a DB Server
15. Setting up additional Disks in Windows
16. Joining The Database Server in the Domain
17. Installing the .Net Framework
18. The time has come! SQL Server installed as it should be!
19. Installing Management Studio
20. BI Tools - SQL Server Datatools
21. Complementary lesson - DataTools Installation

Section 6: Instances and Banks - Ending the Mystery!

22. Instances of Banks, clients and introduction to SSMS
23. Management Studio - The Essentials for a DBA
24. Installing a named instance
25. Comparing: Standard Instances vs. Named Instances

Section 7: Tools

26. Overview - Tools the DBA should know

Section 8: Server Security

27. How clients connect in databases + Understanding Shared Memory and TCPIP
28. Remote connections - Standard and named instances
29. Changing connection ports
30. Configuring the Firewall and checking used ports
31. Alternate ports in the Firewall
32. Best Practices: Hiding an instance on the network and changing the default port

Section 9: SQL Server General Architecture 2016

33. Detailing SQL Server Services 2016
34. Understanding ACID
35. Detailing system databases
36. How Databases Work on SQL Server
37. Overview - Database Creation
38. SQL Server File Architecture
39. File Distribution by Filegroups and HDS - Logical x Physical
40. Archive Architecture in Practice - Part 1
41. Archive Architecture in Practice - Part 2

Section 10: Schemas - Logical vs. Physical

42. What are schemas?
43. Schemas in practice - Physical Organization x Logic

Section 11: Communication in SQL Server - Emails, Operators and Automation

44. Creating an email account
45. Setting up a Database Mail
46. Configuring the Server Agent
47. Creating an Operator
48. Download and Install the Adventure Works base
49. Backup with email sending
50. Understanding, configuring and creating alerts
51. Ending Alerts
52. Backups and Restores
53. Demo Part 01
54. Demo Part 02
55. Demo Part 03