#No.1 online platform for trending courses!
SQL Server DBA Training
SK, LLC provides services in complete Software Development Life Cycle (SDLC) starting from requirement gathering, analysis as per client need, the design, technical documentation, coding, testing and ongoing support. SK has a team of subject knowledge experts working in the industry with trending technical skills like Service now, Selenium, QA, Tableau, Power BI and Industry standards like ITIL setup knowledge. We partner with companies and individuals to address their unique needs, providing training and coaching that helps everyone to achieve their career goals.
Course Prerequisites
About Course
Designed to meet the industry benchmarks, SQL Server DBA is curated by top industry experts. This course is created to help you gain expertise in the SQL Server DBA. You will also master the about the skills and responsibilities of a SQL Server DBA and hear from several data experts sharing their tips & advice to start a career. Enrol now to become a SQL Server DBA expert with SK IT Software Solutions.
Curriculum
18 Lessons
Installation and configuration of SQL Server and its components.
Responsibilities of Database Administrator, Types of DBA’s, History of SQL Server – Versions
Editions of SQL Server Differences between Enterprise and Standard Editions
Working with Databases, Files, File groups and SQL Server Architecture
Security in SQL Server 2019 and SQL Server Authentication types
Designing Storage for new databases and the architecture
Configuring a SQL Server standby database for reposting purposes
Implementing the migration strategy
Managing SQL Server Agent, SQL jobs creation and maintenance
Managing and configuring databases
Implementing a SQL Server clustered instance
Optimizing, troubleshooting, and auditing SQL Server instances
Configuring and maintaining backup strategies
Restoring, Implementing, and maintain databases.
Introduction to High Availability and replication, Clustering SQL Server
Advanced Administration topics includes Database Indexes, monitoring tools and SQL server performance management
Introduction to Data Modeling
Bidirectional filters