Essential SQL Server Administration Tips (Hands-On Guides)
- 6 hours on-demand video
- 27 downloadable resources
- 1 Practice Test
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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 efficiently secure SQL Server
- How to handle common errors you might get in SQL Server
- How to perform different SQL Server integration tasks
- Get deeper understanding about key SQL Server topics and concepts
In this lecture and demo, you will learn about the “Maximum Number of Concurrent Connections Setting” in SQL Server.
In this lecture, you will learn about the SQL Server compatibility levels.
In this lecture, you will learn about 10+1 useful facts about Transparent Data Encryption in SQL Server.
In this lecture, you will learn about the “Public” database role in SQL Server.
In this lecture and demo, you will learn about Unicode support in SQL Server 2019 and later versions.
In this lecture and demo, you will learn how to troubleshoot the error message: Error converting data type varchar to float.
In this lecture, you will learn how to troubleshoot the error message: A network-related or instance-specific error occurred while establishing a connection to SQL Server.
In this lecture and demo, you will learn where are temporary tables actually stored in the tempdb system database.
In this special topic, we will talk about Stretch Database in SQL Server and via a comprehensive live demonstration, we will see how it is possible via the Stretch Database technology, to store a database table on Azure SQL Database, while being able to access it from your on-premises SQL Server database.
SQL Server Administrators, among other, need to also know how to work with SSMS in terms of running queries. Therefore, in this special topic, we will see how we can run queries against SQL Server using SQL Server Management Studio, as well as how we can script different wizard-based procedures to T-SQL code.
As Database Administrators (DBAs), we are called many times for supporting developers connecting their applications to our SQL Server instances (i.e. provide the connection string, etc.). Therefore, we need to have the relevant knowledge. In this special topic, via a live demonstration, you will learn how to connect to SQL Server and run queries, via a C++ program.
- At least basic SQL Server knowledge is required
- It would be helpful to know some basic database-related concepts
In this course, you will learn many useful SQL Server administration hands-on tips, that will help you efficiently administer SQL Server instances and databases, 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.
Via my course, among other, 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:
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.
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:
6 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
A practice test in the end of the course
Ability to ask the instructor questions via the Q&A section
Certificate on course completion
WHAT ARE PEOPLE SAYING ABOUT THE COURSE:
"Very useful and well organized course. The knowledge gained will be actively used in practice.", Andreas Josephides
"The demonstrations and provided SQL scripts will definitely help in becoming a better SQL Server Administrator and make SQL Server instances perform faster which was very important for me.", Giannis Hadj
"A very interesting and useful course for database professionals. I can directly apply it at my work and believe it will resolve difficulties regarding the administration of our SQL server.", Andreas Nestorides
"Great course! Live demonstrations make it really easy for me to understand how to perform important tasks in SQL Server.", Rena Leandrou
- SQL Server Administrators (DBAs)
- SQL Server Engineers
- SQL Server Architects
- SQL Server Developers who want to learn more about SQL Server Administration