Lifetime
An ITU Online Training exclusive. The only Buy Once, Never Pay for IT training again program available. Plus, get all new and updated content for life.
- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft SQL Database Administration : Optimize Your SQL Server Skills
This sql server administration course offers students a comprehensive understanding of how to maintain and optimize a Microsoft SQL Server database. It is specifically tailored towards individuals who want to gain knowledge features in numerous versions of SQL server as well as learn about essential capabilities throughout the entire data platform. Students will emerge from this training with an extensive set of skills for managing their own MS SQL Server environment along with its databases!
Included In This Course
Included In This Course
7 Hrs 37 Min
41 On-demand Videos
Closed Captions
6 Topics
75 Prep Questions
Certificate of Completion
Course Description
Elevate your career learning SQL Database Administration with our comprehensive Microsoft SQL Server Administration training. This course is designed to provide you with the skills needed to manage MS SQL Databases effectively, making you proficient in SQL Server Administration. Whether you’re an SQL Administrator, SQL Server DBA, or someone who works with MS Databases, this course is your gateway to mastering Microsoft SQL DBMS.
What You Will Learn In This SQL Database Administrator Course
- SQL Server Database Management: Gain hands-on experience in SQL Server Databases, focusing on the newest features in SQL Server 2016, 2017, and 2019.
- SQL DBA Essentials: Learn the core responsibilities of an SQL DBA, including SQL Server installation, Server Database maintenance, and data recovery.
- SQL Database Administration: Master the art of SQL Database Administration, covering essential capabilities across the SQL data platform.
- Microsoft SQL Server Database Certifications: Although the course is not certification-specific, it equips you with the knowledge that can help you pursue Microsoft SQL Server Database Certifications.
Who Should Enroll
This course is primarily aimed at individuals who administer and maintain SQL Server Databases. It’s also beneficial for those who develop applications that deliver content from SQL Server databases or work in environments where Server Databases are crucial.
SQL Database Administrator Course Highlights
- 6 Training Hours
- 41 On-demand Videos
- Closed Captions
- 75 Prep Questions
- Certificate of Completion
Topics Covered
Module 1: Installation
Begin your journey into SQL Server Administration with an introductory lesson on the role of an SQL Administrator. This module will guide you through the installation process of Microsoft SQL Server 2019, setting the foundation for your career as an SQL Server DBA.
Module 2: Data Storage
This module delves into the intricacies of Data Storage in SQL Server Databases. Learn how to manage storage for both system and user databases effectively. The module also covers the process of moving database files, a crucial skill for any SQL Database Administrator.
Module 3: Data Recovery
Data Recovery is a vital aspect of SQL Database Administration. This module introduces you to SQL Server Recovery Models and helps you plan a robust backup strategy. Learn the techniques for backing up databases and transaction logs using SQL Server Management Studio (SSMS). The module also covers various restore processes, including how to restore a database and use T-SQL for backup and restore, equipping you with advanced restore scenarios.
Module 4: Monitoring
Monitoring SQL Server is essential for optimizing performance and ensuring database integrity. This module introduces you to Dynamic Management Views and Functions, server reports, and the System Performance Monitor. You’ll also learn about tracing SQL Server workload activity and using Extended Events, key skills for an SQL Server Database Administrator.
Module 5: Security
Security is a cornerstone in SQL Server Administration. This module provides a comprehensive overview of SQL Server Security, including managing server-level and database-level security. Learn about Row Level Security (RLS) using policies and various database security tools. The module also covers auditing data access in SQL Server and implementing Transparent Data Encryption, essential for MS SQL Database security.
Module 6: Maintenance
The final module focuses on the Maintenance of SQL Server Databases. Learn how to ensure database integrity and maintain indexes, both crucial for SQL Database Administration. The module also covers automating routine database maintenance tasks and SQL Server Management, as well as monitoring SQL Server errors and configuring Database Mail.
Salary Opportunities for a Microsoft SQL DBA
These figures are approximate and can vary based on various factors such as experience, education, and company size.
| Major U.S. Cities | Low Salary Range ($) | Median Salary Range ($) | High Salary Range ($) |
|---|---|---|---|
| New York, NY | 90,000 | 115,000 | 145,000 |
| San Francisco, CA | 95,000 | 125,000 | 160,000 |
| Boston, MA | 85,000 | 110,000 | 140,000 |
| Chicago, IL | 80,000 | 105,000 | 135,000 |
| Seattle, WA | 90,000 | 115,000 | 145,000 |
| Austin, TX | 78,000 | 100,000 | 130,000 |
| Atlanta, GA | 75,000 | 98,000 | 125,000 |
| Los Angeles, CA | 85,000 | 110,000 | 140,000 |
| Washington, DC | 80,000 | 105,000 | 135,000 |
| Denver, CO | 78,000 | 100,000 | 130,000 |
| Miami, FL | 75,000 | 98,000 | 125,000 |
| Phoenix, AZ | 72,000 | 95,000 | 120,000 |
| Dallas, TX | 75,000 | 98,000 | 125,000 |
| Houston, TX | 76,000 | 99,000 | 130,000 |
These salary ranges are based on various industry reports and surveys and are intended to give a general idea of what a Microsoft SQL DBA might expect to earn in these cities.
You Might Also Be Interested In Our Comprehensive SQL Courses
- Microsoft SQL Database Design
- Introduction to Microsoft Power BI
- Querying SQL Server With T-SQL – Master The SQL Syntax
- Microsoft SQL Database Administration : Optimize Your SQL Server Skills
- Microsoft Server – SQL Data Analysis
- Microsoft SQL – SQL Big Data
- SSAS : Microsoft SQL Server Analysis Services
Key Term Knowledge Base: Key Terms Related to Microsoft SQL Server 2019 Administration
Understanding key terms in Microsoft SQL Server 2019 Administration is crucial for anyone working in or interested in database administration, especially when dealing with Microsoft’s SQL Server. Familiarity with these terms will aid in better understanding the software’s capabilities, troubleshooting issues, optimizing database performance, and effectively managing data. Here’s a list of key terms that are integral to this topic:
| Term | Definition |
|---|---|
| SQL Server | A relational database management system developed by Microsoft, designed to store and retrieve data as requested by other software applications. |
| Database | A structured set of data held in a computer, especially one that is accessible in various ways. |
| Query | A request for data or information from a database table or combination of tables. |
| T-SQL (Transact-SQL) | Microsoft’s proprietary extension to the SQL (Structured Query Language) used to interact with relational databases. |
| SSMS (SQL Server Management Studio) | An integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. |
| Table | A collection of related data held in a structured format within a database. |
| Index | A database object that improves the speed of data retrieval operations on a database table. |
| Stored Procedure | A set of SQL statements that can be stored in the server and executed whenever required. |
| View | A virtual table in SQL that is used to represent a subset of data from one or more tables. |
| Joins | SQL operations that combine rows from two or more tables based on a related column between them. |
| Backup | The process of creating a copy of data on a database to prevent data loss. |
| Recovery Model | Determines how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are available. |
| Replication | A set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. |
| Clustered Index | A type of index where the table records are physically stored in the order of the index keys. |
| Non-clustered Index | A type of index where the physical order of the rows is not the same as the index order. |
| Normalization | The process of organizing data in a database to reduce redundancy and improve data integrity. |
| Data Types | Specific kinds of data, such as integer, float, or varchar, that define what can be stored in a table’s column. |
| Schema | The structure of a database system, described in a formal language supported by the database management system. |
| Partitioning | The database process where very large tables are divided into multiple smaller, more manageable pieces, yet still treated as a single table. |
| Log Shipping | A strategy of automatically sending transaction log backups from one server to another server. |
| High Availability | Systems designed to be available most of the time, minimizing downtime. |
| Disaster Recovery | Strategies and processes for recovering from catastrophic events that cause significant data loss or damage. |
| Performance Tuning | The process of optimizing database systems for more efficient query processing. |
| Security | Measures and protocols to protect database integrity, confidentiality, and accessibility. |
| Data Migration | The process of transferring data between storage types, formats, or computer systems. |
This list encompasses the fundamental concepts you would encounter in Microsoft SQL Server 2019 Administration, providing a solid foundation for understanding and working with this powerful database management system.
Frequently Asked Questions About Microsoft SQL Server Administration
What Are the Core Responsibilities of an SQL Server Database Administrator (SQL Server DBA)?
An SQL Server DBA is responsible for managing MS SQL Databases, ensuring their performance, availability, and security. Core tasks include SQL Server installation, data storage management, data recovery planning, and SQL Server monitoring. They also handle SQL Database Administration tasks like backup and restore operations, as well as implementing security measures.
How Do I Plan a Backup Strategy for SQL Server Databases?
Planning a backup strategy is a critical aspect of SQL Database Administration. It involves understanding SQL Server Recovery Models, selecting appropriate backup types (full, differential, log), and scheduling them using SQL Server Management Studio (SSMS) or T-SQL commands. The strategy should also include off-site backups for disaster recovery.
What Are the Best Practices for SQL Server Security?
SQL Server Security is a key focus area for any SQL Database Administrator. Best practices include managing server-level and database-level security, implementing Row Level Security (RLS) using policies, and auditing data access in SQL Server. Transparent Data Encryption can also be used to enhance data security.
How Can I Monitor the Performance of MS SQL Databases?
Monitoring is an essential part of SQL Server Administration. SQL Server DBAs commonly use tools like Dynamic Management Views and Functions, server reports, and System Performance Monitor for this purpose. Advanced techniques include tracing SQL Server workload activity and using Extended Events for in-depth analysis.
What Maintenance Tasks Are Essential for SQL Server Databases?
Routine maintenance is crucial for the long-term health of SQL Server Databases. SQL Database Administration involves tasks like ensuring database integrity, maintaining indexes, and automating routine database maintenance. Tools like Database Tuning Advisor can be used to optimize performance.
Proudly DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Course Outline
Microsoft SQL Server 2019 Administration Course Content
Module 1: Installation
SQL Admin Intro
Installation
Module 2: Data Storage
Introduction to Data Storage with SQL Server
Managing Storage for System Databases
Managing Storage for User Databases
Moving Database Files
Module 3: Data Recover
Intro to Data Recovery
Understanding SQL Server Recovery Models
Planning a Backup Strategy
Backing up Databases and Transaction Logs
Using SSMS For Backup
Understanding the Restore Process
How to Restore a Database
Using SSMS For Restore
T-SQL Backup and Restore
Advanced Restore Scenarios
Introduction to Transferring Data
Importing and Exporting Table Data
Copying or Moving a Database
Module 4: Monitoring
Introduction to Monitoring SQL Server
Dynamic Management Views and Functions
Server Reports
System Performance Monitor
Tracing SQL Server Workload Activity
Extended Events
Database Tuning Advisor
Module 5: Security
Introduction to SQL Server Security
Managing Server-Level Security
Managing Database-Level Security
Row Level Security (RLS) Using Policies
Database Security Tools
Contained Database
Auditing Data Access in SQL Server
Implementing Transparent Data Encryption
Module 6: Maintenance
Introduction to Maintenance
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance
Automating SQL Server Management
Monitoring SQL Server Errors
Configuring Database Mai
Your Training Instructor
James is a full-stack developer with over 40 years of experience. He has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. James has also been teaching technology courses for over 20 years. In addition to his extensive background in technology, he has also worked as a professional opera singer.
Subscribe To All-Access
Lock In $14.99 / Month Forever
Start this course for free with our 10-day trial of the all-access subscription providing access to over 2,600 hours of training.
$49.00 $14.99 Monthly
OR
$49.00
Microsoft SQL Database Administration : Optimize Your SQL Server Skills
Microsoft SQL Database Administration : Optimize Your SQL Server Skills
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.
Monthly All-Access Subscription
7 Days Free - $39.00 / month
A great option at an affordable monthly price.
Annual All-Access Subscription
$229 / year
A discounted price when paying for your All Access library on an annual basis.
Lifetime All-Access Library
$379 One time payment
Exceptional Value. Pay once, never have to buy IT training again.
Related Courses
$49.00
Master the skills to effectively manage SQL Server with our Microsoft 70-764 training course. Get started today!
The Microsoft 70-764 SQL Server 2016 Administration course is designed to equip students with all the skills and knowledge necessary for them to confidently pass the Microsoft Certification Exam 70-764. By mastering this program, learners will be fully capable of administering a complete Microsoft SQL 2016 server solution – from installation through maintenance tasks.
$49.00
Become a Microsoft Certified Database Designer! Learn Microsoft 70-465: Designing Database Solutions for SQL Server with ITU’s comprehensive online course.
In this course you will learn how to plan and implement enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. This course will teach you how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions. You will learn how to create plans and designs for database structure, storage, objects, and servers.
$49.00
Enhance your web dev skills with our CSS online course. From basic concepts to advanced techniques, everything you need to know to create stunning websites.
Cascading Style Sheets (CSS) provides the ability to create visually pleasing and sophisticated websites. In this CSS3 Training course, users at all levels will be instructed on how to use it effectively with ease.
Mary Beth helped me. She was wonderful.