SQL Server
Databases perform both simple and complex transactions
- OVERVIEW
- CURRICULUM
- FEATURED REVIEW (0)
Limitless Learning, Limitless Possibilities
Protecting data also means you need to monitor for and detect system intrusions. This includes:
- System & Database monitoring
- RDBMS (Relational Database Management Systems)
- Data protection, hide sensitive information
- Calculating the impact
- Planning to an incident response
- Disaster recovery
- Notifying the Data Protection Agency (DPA) and affected individuals
About This Course
If issues, including accidental data release, do occur, protection controls allow you to respond quickly. In addition, an important part of data protection is making sure data is accessible when needed, for both reporting and legitimate uses. SQL Server 2017 can help you protect data through these features:
Here some of the techniques you will Learn:
Install, Configure, Managing and Maintaining SQL Server, SQL Server Reporting Service, SQL Server Integration Service, Database Maintenance, Database Health Check, Rebuild & Reorganize Indexes, Database Mail, Maintenance Plan(scheduled and unscheduled tasks), Visual Studio and Data Tools.
Transport Layer Security (TLS) 1.2 is supported by SQL Server for highly secure communications. Data is encrypted to help ensure it’s not intercepted during transit to or from your database.
Transparent Data Encryption (TDE) protects data at rest. This means your data is protected even if the physical media is stolen or disposed of improperly. TDE performs real-time encryption and decryption of databases, backups, and transaction logs without requiring any change to your applications.
Always Encrypted is a technology that helps protect personal data while in use. Personal data is encrypted and decrypted by the Always Encrypted-enabled driver on the client computer without revealing encryption keys to the database engine. As a result, encrypted data is only visible to the people responsible for managing that data, not to database administrators or other highly privileged users who shouldn’t have access. Depending on the type of encryption selected, Always Encrypted may limit some database functionality like searching, grouping, and indexing of encrypted columns.
Windows Failover Clustering is a greatest HA solution along with mirroring, log-shipping and replication will be covering 100% in this course.
Always On Availability Groups help provide a high availability and disaster recovery (HADR) solution as an alternative to database mirroring. This ensures the resiliency and availability of data during adverse events.
Migration & Upgrade from different version, edition to SQL Server is easy, low cost and time saver. We will be upgrading SQL Server 2012 to 2019 and will be working on physical, remote or virtual machine in-place or side-by-side approach.
SQL Server Integration Service is one of the ETL (Extract Transform & Load) tool is commonly used in Visual Studio, Data Tools for creating package, automatic task, linked server, data warehousing data export/import and we will be covering for a DBA role.
SQL Server Reporting Service is another component of SQL Server, organization uses without additional cost. We will learn how to configure it, create, build report and deploy this report.
SQL Server
Curriculum is empty
