- Introduction
- Installing SQL server in a domain production Enviroment
- Software Download and VMware Installation
- Domain controller installation
- Promote Server to a Domain Controller
- Create Service Accounts
- Setup a Static IP Address
- Create another Virtual Machine
- Create Additional Virtual Drives
- Join Server to a Domain
- SQL Server installation
- How to create a database for a complete begineer
- How to Backup a database for a complete beginner
- How to Restore a database for a complete beginner
- How to take a Database offline and bring it back online
- How to create a database SnapShot for a complete beginner
What you'll learn
- How to efficiently administer SQL Server instances and databases in many aspects
- How to perform essential SQL Server maintenance tasks
- How to perform essential SQL Server performance tasks
- How to handle common errors you might get in SQL Server
- Get deeper understanding about key SQL Server topics and concepts
- How to perform different SQL Server integration tasks
Description
In this course, you will learn many SQL Server administration hands-on tips, that will help you efficiently administer SQL Server within the context of SQL Server maintenance, performance, security, integration and error handling.
SQL Server is one of the world's leading Data Platforms. It is full of features that enable you to store, organize, retrieve and transform your data into useful business insights and knowledge. Like in all Database Management Systems, in order for your SQL Server instances to operate to the best possible level in terms of stability and performance, you need to properly administer and maintain them.
I have carefully designed this course, in order to help you with your SQL Server journey. With many live demonstrations and step by step guides, via my course, I will help you learn how to perform many SQL Server administration tasks, as well as, get a deeper understanding about critical SQL Server topics that all modern SQL Server Administrators, Engineers and Architects needs to know.
In my course, you will learn how to patch standalone and failover cluster SQL Server instances, how to enable Transparent Data Encryption (TDE) for data at rest and encrypt database backups, how to enable SSL encryption for data in motion, how to tune SQL Server instances via indexes, CPU, RAM and storage monitoring, how to protect your data with Dynamic Data Masking and Row Level Security, how to use Unicode, how to troubleshoot common error messages in SQL Server and much more.
AFTER THE COURSE:
You will know how to efficiently perform different SQL Server administration tasks on the below SQL Server knowledge areas:
Maintenance
Performance
Security
Integration
Error Handling
You will have a deeper understanding on many SQL Server administration topics that fall under the above knowledge areas
You will be able to download a rich set of downloadable resources, mainly T-SQL scripts, that will help you better understand all tips provided via the course.
I WILL KEEP UPDATING THIS COURSE!!!
PREREQUISITES:
At least basic knowledge of SQL Server is required.
It would be helpful to know some basic database-related concepts (i.e. what is a database, a table, etc.) but is not a prerequisite, since we will talk about it as well.
Willingness and excitement to learn!
THIS COURSE CONTAINS/OFFERS:
2 hours of high-quality video
Live demonstrations and hands-on guides that will help you perform many essential SQL Server administration tasks
Useful quizzes for testing your knowledge on each section
Many downloadable resources such as T-SQL scripts and links
Ability to ask the instructor questions via the Q&A section
Certificate on course completion
Other Courses
Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel
Pivot Tables in Excel 2016. Learn to create basic Pivot Tables in Excel 2016 with real-life examples.
Microsoft Word (2020) - The complete Word Master Course!
Become a PRO in Microsoft Word. No matter if you are using Microsoft Word 2010, Word 2013, Word 2016 or Word 2019!
[FREE] Machine Learning Mastery 2024 - Full Roadmap
Your Ultimate Guide to Mastering ML from Scratch
Learn Salesforce in easy steps and get certified!
This course should prepare you for Salesforce App Developer certification.
About the instructors
- 4.75 Calificación
- 5317 Estudiantes
- 1 Cursos
Paul Obalonye
MCSE|MCSA|Azure Administrator |Azure DevOps Engineer
I have been in the technology field for more than 15 years. I began my career as a SQL Server database administrator and i have worked in different capacity. I am 4X Microsoft Certified Expert. My courses are not presentations that rely on slides to explain concepts. My goal is to demonstrate every concept covered, instead of using slides that cover theory, we will use the interface to configure every setting that is discussed. In my view, if you do not know how to complete a task that a course covered, that course was not beneficial. I will make sure that you know how to complete each task and the various configurations for those tasks.
Student feedback
Course Rating
Reviews
I am close to completing it but as the comment suggests so far so good. Thank you.
After installs he starts skipping through the tools assuming you know how to use them. But this is a beginner course, so he needs to show how to use the tools too.