- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft SQL Server Administration – 2019
This sql server administration course offers students a comprehensive understanding of how to maintain and optimize a Microsoft SQL Server 2019 database. It is specifically tailored towards individuals who want to gain knowledge on the newest features in SQL server 2016, 2017, and 2019 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
6 Training Hours
41 On-demand Videos
Closed Captions
6 Topics
75 Prep Questions
Certificate of Completion
Course Description
Self-paced training online training program
Taking our SQL server administration course course, students can learn about SQL Server installation, data storage, data recovery, monitoring, security, and maintenance. Instructor James Ring-Howell brings with him over 40 years of applicable IT experience and has taught technical courses for over two decades.
This Microsoft SQL Server Administration course is specifically for obtaining working IT skills and is not certification-specific training.
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility or work in environments where databases play a key role in their primary job. The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.
- Install and Configure SQL Server 2019
- Work with Databases and Storage
- Plan and Implement a Backup Strategy
- Restore SQL Server 2019 Databases
- Import and Export Data
- Monitor SQL Server 2019
- Manage SQL Server Security
- Audit Data Access and Encrypt Data
- Perform Ongoing Database Maintenance
- Automate SQL Server 2019 Management
- Monitor SQL Server 2019 by Using Alerts and Notifications
Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence, and analytics applications in corporate IT environments. Microsoft SQL Server is one of the three market-leading database technologies, along with Oracle Database and IBM’s DB2.
Like other RDBMS software, Microsoft SQL Server is built on top of SQL, a standardized programming language that database administrators (DBAs) and other IT professionals use to manage databases and query the data they contain. SQL Server is tied to Transact-SQL (T-SQL), an implementation of SQL from Microsoft that adds a set of proprietary programming extensions to the standard language.
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2019 database. The training focuses on teaching individuals how to use SQL Server 2019 product features and tools related to maintaining the server environment and the databases it contains and is designed for customers who are interested in learning SQL Server 2016, SQL 2017, or SQL Server 2019. It covers the new features in SQL Server 2019, but also the important capabilities across the SQL Server data platform.
Topics include Installation, Data Storage, Data Maintenance and Recovery, Monitoring, Security, and Server Maintenance. This course requires that you meet the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. Some experience with database design is recommended.
Frequently Asked Questions About Microsoft SQL Server Administration
What will I learn in this course?
Our online course will give you a comprehensive understanding of how to maintain and optimize a Microsoft SQL Server database. It’s perfect for those who want to gain knowledge on the newest features in SQL server 2016, 2017, and 2019 and by the end, you’ll have a solid set of skills for managing your own SQL Server environment and its databases
Who is this course intended for?
The primary audience for this online training course are individuals who administer and maintain SQL Server databases. This might be their primary responsibility or a key part of their job. However, anyone interested in gaining practical IT skills related to SQL Server 2019 can benefit from the training course​.
Can I try before I buy?
Absolutely! You can start today with a 7-day free trial of the All Access Monthly Subscription. This will give you access to the SQL Server Administration course, along with over 2,500 hours of on-demand content. If it’s not for you, no sweat, you can cancel anytime within those 7 days.
How long will this online training course take?
The training course is designed to be completed in about 6 hours. But remember, it’s a self-paced training, so you can take your time and learn at a rate that’s comfortable for you​.
Who is the instructor for this course?
The course is led by James Ring-Howell. He brings over 40 years of applicable IT experience to the table and has been teaching technical courses for over two decades. So you’re in good hands!
What are some of the specific topics covered in this training course?
The training course covers a wide range of topics including: how to install and configure SQL Server 2019, working with databases and storage, planning and implementing a backup strategy, restoring SQL Server 2019 databases, importing and exporting data, monitoring SQL Server 2019, managing SQL Server security, and auditing data access
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.
$49.00
OR
Subscribe To All-Access
Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.
$49.00 $14.99 Monthly
Microsoft SQL Server Administration – 2019
Microsoft SQL Server Administration – 2019
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
Take your SQL Server skills to the next level with ITU Online’s Microsoft 70-466 course on implementing data models and reports. Enroll now!
In this course you will learn how to create managed enterprise BI solutions. You will learn how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. This course will also teach you how to create BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.
$49.00
Master the skills to become a Microsoft Certified Solutions Associate with our 70-462 Administering SQL Server course. Enroll now and start your journey!
In this Microsoft 70-462: Administering SQL Server Databases course you will learn how to perform installation, maintenance, and configuration tasks. This course will also teach you other responsibilities including setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. This course will provide students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.
$49.00
Learn how to develop cutting-edge web applications with Microsoft .NET 4.5 Programming and HTML5. Enroll now and get certified!
In this online IT learning course you will learn the .NET open source developer platform. This platform provides a comprehensive and consistent programming model for building web applications that have visually stunning user experiences and seamless and secure communication. HTML 5, Javascript and CSS3 can integrate with this platform.
I was looking for an online course for Six Sigma as my new boss is a true believer and I wanted to have a better handle of what is Six Sigma. I started looking around and found ITU, and bought the course, and could not be happier. I have no intention of getting certified, but at least now I can speak the jargon and understand what my boss is talking about.
The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.
The CompTIA PenTest was an excellent course and the instructor, Chrys, explained the material in a clear and easy way for me to understand and comprehend essential techniques. Highly recommend!