Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-01-14 08:15:54
30-Day Money-Back Guarantee

This course includes:

  • 6 hours on-demand video
  • 27 downloadable resources
  • 1 practice test
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development SQL Server

Essential SQL Server Administration Tips (Hands-On Guides)

Learn essential tips and techniques for efficient SQL Server database administration (performance, security and more)
Rating: 4.2 out of 54.2 (23 ratings)
172 students
Created by Artemakis Artemiou
Last updated 11/2020
English
English [Auto]
30-Day Money-Back Guarantee

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 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

Course content

9 sections • 82 lectures • 6h 11m total length

  • Preview02:33
  • Preview01:04

  • Section Overview
    00:50
  • How to Patch a Standalone SQL Server Instance
    07:10
  • How to Patch a SQL Server Failover Cluster Instance
    07:04
  • Preview07:40
  • Searching for Keywords in SQL Server Agent Jobs
    07:32
  • The SQL Server Browser Service and UDP Port 1434
    05:02
  • Getting the Disk Usage Statistics for all Tables in a Database
    05:23
  • Handling Disk Space Issues During Heavy Index Rebuild Operations
    03:09
  • How to Add a Database to a SQL Server Availability Group Using T-SQL
    03:44
  • Migrating to a Contained Database in SQL Server
    09:59
  • Modelling Database Creation with the Model System Database in SQL Server
    04:51
  • Preview03:33
  • Backup Compression in SQL Server
    03:06
  • Transferring Ownership of All Database Objects Back to DBO
    06:35
  • Section Recap
    00:43
  • SQL Server Maintenance
    4 questions

  • Section Overview
    00:28
  • The Importance of Database Indexes
    01:24
  • Index Maintenance Scripts
    06:23
  • The TempDB System Database in SQL Server
    03:33
  • tempdb growth
    05:29
  • Introducing In-Memory Optimization in SQL Server
    05:17
  • In-Memory Optimization in SQL Server: A Simple Experiment
    08:34
  • Getting the RAM Usage per Database in SQL Server
    04:45
  • Getting the CPU Usage per Database in SQL Server
    04:37
  • Locking and Blocking in SQL Server
    03:58
  • Section Recap
    00:40
  • SQL Server Performance
    4 questions

  • Section Overview
    02:05
  • Why You Need to Secure Your SQL Server Instances
    02:33
  • Transparent Data Encryption (TDE) in SQL Server
    14:27
  • Preview03:05
  • Encrypting a SQL Server Database Backup
    09:21
  • SQL Server Support for TLS 1.2
    01:37
  • How to Enable SSL Certificate-Based Encryption on a Standalone SQL Server
    07:16
  • How to Enable SSL Certificate-Based Encryption on a SQL Server Failover Cluster
    08:01
  • The SELECT ALL USER SECURABLES Permission in SQL Server
    06:12
  • Dynamic Data Masking in SQL Server 2016 or Later
    07:36
  • Preview01:39
  • SQL Server Row Level Security by Example
    05:55
  • Should Windows “Built-In\Administrators” Group be SQL Server SysAdmins?
    01:55
  • How to Rename Logins in SQL Server
    03:42
  • Handling Orphaned Users in SQL Server
    06:14
  • Section Recap
    00:41
  • SQL Server Security
    4 questions

  • Section Overview
    00:34
  • Using Proxy Accounts in SQL Server Agent Jobs
    04:07
  • Using Unicode in SQL Server
    03:47
  • Preview03:19
  • How to Create a Simple Linked Server Between SQL Server Instances
    04:09
  • Section Recap
    00:30
  • SQL Server Integration
    4 questions

  • Section Overview
    00:59
  • Resolving the Error Message: Rule “KB2919355 Installation” failed
    01:53
  • Preview02:55
  • Database […] cannot be upgraded because it is read-only or has read-only files
    00:58
  • Could not load file or assembly ‘Microsoft.SqlServer.Smo, Version=10.0.0.0, …
    01:33
  • A connection was successfully established with the server, but then an error...
    02:13
  • The SELECT permission was denied on the object ‘extended_properties’, database..
    01:32
  • ORDER BY items must appear in the select list if SELECT DISTINCT is specified
    02:19
  • Preview02:24
  • There is no SQL Server Failover Cluster Available to Join
    04:25
  • An error occurred within the report server database. This may be due...
    04:19
  • Operating System Error 170 (Requested Resource is in use)
    05:02
  • Cannot Connect to WMI Provider (SQL Server Configuration Manager)
    04:59
  • The Multi-Part Identifier Could not be Bound
    05:18
  • Argument data type ntext is invalid for argument 1 of left function
    05:21
  • String or binary data would be truncated
    06:38
  • Microsoft SSIS Service failed to start. Configuration system failed to...
    01:54
  • Section Recap
    00:54
  • SQL Server Troubleshooting
    4 questions

  • Section Overview
    00:49
  • Preview04:18
  • How to Suppress the “N Row(s) Affected” Output Message in SQL Server
    01:51
  • Preview02:37
  • How to Enable Stretch Database in SQL Server
    15:36
  • Running Queries and Scripting to T-SQL
    07:39
  • Methods of Importing and Exporting Data in SQL Server
    10:48
  • How to Write to a Flat File Using SQL in SQL Server
    05:02
  • How to Read from a Flat File Using SQL in SQL Server
    03:19
  • How to Install SQL Server on CentOS Linux
    11:10
  • How to Connect to SQL Server from a C++ Program
    07:43
  • SQL Server Installation and Setup Best Practices
    12:31

  • What Have you Learned in this Course?
    01:23
  • Essential SQL Server Administration Tips
    20 questions

  • Bonus Lecture
    06:58

Requirements

  • At least basic SQL Server knowledge is required
  • It would be helpful to know some basic database-related concepts

Description

In this course, you will learn many useful SQL Server administration hands-on tips, that will help you efficiently administer Microsoft SQL Server instances and databases, within the context of SQL Server maintenance, performance, security, integration and error handling.

Microsoft 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:

    • 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.


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:

  • 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

Who this course is for:

  • SQL Server Administrators (DBAs)
  • SQL Server Engineers
  • SQL Server Architects
  • SQL Server Developers who want to learn more about SQL Server Administration

Instructor

Artemakis Artemiou
Award-Winning Database Expert, Trainer, Author, Speaker.
Artemakis Artemiou
  • 4.3 Instructor Rating
  • 398 Reviews
  • 4,069 Students
  • 13 Courses

Artemakis is a Senior SQL Server and Software Architect and a former Microsoft Data Platform MVP (awarded for 9 consecutive years). He has over 20 years of experience and he has taught thousands of people to efficiently work with SQL Server, Data Access/Entity Framework, Azure, .NET/C#, Programming and more, via his video tutorials, blog and guest articles, public speaking, eBooks and online courses.

Artemakis published hundreds of articles and videos that explain in simple words, how to perform complex technical tasks and he really enjoys the interaction with the technical communities.

Besides his regular blogging activities, Artemakis is also a guest author on many prestigious online technology journals.

Moreover, he currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).

Artemakis, really enjoys sharing hands-on knowledge on a large set of technology topics, and thus helping his fellow tech community members, to easily start using these great technologies. To this end, he is really looking forward to seeing you in his online courses on Udemy!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.