Provider
Topic
Level
College & Adult
Price
Free
Monthly
Add-ons available
Common Core
Yes
No
Images
No items found.
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.
Posted
Aug 2023
This resource has religious influence.
Similar resources
Since 2012, ITU Online has been a leader in delivering top-notch online Information Technology (IT) training courses. Our goal is to meet and exceed all learning needs of both students and corporate teams by offering an unbeatable online experience that is available for everyone. By using proven educational concepts, implementing sound instructional design principles, and employing the best leaders in the IT field to develop and teach, ITU creates exceptional courses that provide the best benefits for those in the IT training field.
Our self-paced online IT courses are designed to provide a comprehensive learning experience without the hassle of attending a physical classroom. Our courses offer industry-recognized certifications and training that is tailored to meet your needs and goals, allowing you to learn at your own pace in order to become an IT expert. With our unique approach, we will help you achieve your IT career ambitions, no matter where in the world you are.
Whether you’re a beginner or have years of experience in the IT field, ITU’s online courses offer something for everyone – from entry-level classes to advanced certifications and everything in between. We provide clear learning paths that enable students to map out their own journey, giving them the opportunity to acquire the skills they need in order to reach their career goals.
ITU is a four-time Best in Biz Award winner–taking home the prestigious titles of Company of the Year, Fastest Growing Company of the Year, Creative Department of the Year and Most Innovative Company of the Year. The accolades are well deserved as ITU continues to push boundaries with its progressive innovations that have revolutionized entire industries!
ITU is the premier content creator and developer in education, with a staggering 800,000 students already benefited by its services. ITU understands what it takes to develop stimulating and interactive virtual courses that provide optimal value for learners. The effectiveness of these courses have been proven time and again – giving you peace of mind when selecting training solutions from ITU!
Data Security Compliance
College & Adult
SalesForce: Power User Course
College & Adult
PMI Risk Management Training
College & Adult
Accounting and Business Basics
College & Adult
Certified Associate in Project Management (CAPM)
College & Adult
Free Windows 10 Courses Online
College & Adult