SQL Server Administration Part1

SQL Server Administration Part1, available at $79.99, has an average rating of 4.6, with 59 lectures, based on 6221 reviews, and has 24752 subscribers.

You will learn about Manage SQL Server Administration; install SQL Server in a Production environment following best practice, review storage, data and log files necessities, understand the importance of backups and restores, configure security and more This course is ideal for individuals who are I have designed the course for beginners that want to learn how to manage a SQL Server. With examples that are practiced in the real world, the student will valuable lessons that is not taught in books. It is also designed for experienced network adminstrators,developers, programmers, analysts and accidental dbas that want to learn SQL Administration It is particularly useful for I have designed the course for beginners that want to learn how to manage a SQL Server. With examples that are practiced in the real world, the student will valuable lessons that is not taught in books. It is also designed for experienced network adminstrators,developers, programmers, analysts and accidental dbas that want to learn SQL Administration.

Enroll now: SQL Server Administration Part1

Summary

Title: SQL Server Administration Part1

Price: $79.99

Average Rating: 4.6

Number of Lectures: 59

Number of Published Lectures: 59

Number of Curriculum Items: 59

Number of Published Curriculum Objects: 59

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Manage SQL Server Administration; install SQL Server in a Production environment following best practice, review storage, data and log files necessities, understand the importance of backups and restores, configure security and more

Who Should Attend

I have designed the course for beginners that want to learn how to manage a SQL Server. With examples that are practiced in the real world, the student will valuable lessons that is not taught in books. It is also designed for experienced network adminstrators,developers, programmers, analysts and accidental dbas that want to learn SQL Administration

Target Audiences

I have designed the course for beginners that want to learn how to manage a SQL Server. With examples that are practiced in the real world, the student will valuable lessons that is not taught in books. It is also designed for experienced network adminstrators,developers, programmers, analysts and accidental dbas that want to learn SQL Administration

The following course will introduce to you the foundation of SQL Server Administration Part 1 as it’s practiced in the production real world situations. I have designed this course for the beginner but at the same time introduced elements that are practiced in the real world, so the student gains a faster understanding of the requirements in the production server. Anyone interested in understanding, configuring, managing or is responsible for SQL Server systems will benefit from this course. My first course T-SQL, while not mandatory, should be taken so you gain a better understanding of this course. All software, SQL Scripts and documentation is provided for you. All you need is a desire to learn and fullfill you future goals. These courses will give you that direction.

Course Curriculum

Chapter 1: SQL Server Administration Part 1

Lecture 1: What is a Domain

Lecture 2: Software to download and install

Lecture 3: POST ADDENDUM

Lecture 4: APPS NEEDED

Lecture 5: CREATE VM

Lecture 6: INSTALL SQL SERVER 2017

Lecture 7: ADVENTUREWORKS 2017 DB

Lecture 8: COMPARISON OF SQL 2014 VS 2017

Lecture 9: Create Virtual Machine Domain Controller

Lecture 10: Promote Domain Controller to Active Directory

Lecture 11: Create Vm for SQL Server 2012 Install Part1

Lecture 12: Create Vm for SQL Server 2012 Install Part 2

Lecture 13: Install SQL On Separate Drive with Service Accounts Part 1

Lecture 14: Install SQL On Separate Drive with Service Accounts Part 2

Lecture 15: Installing Service Packs and Fixes (SP2)

Lecture 16: Touring SQL Server Management Studio (SSMS)

Lecture 17: Introduction to System Databases

Lecture 18: SQL Server Data and Log Files

Lecture 19: Detail Transaction log ATM Example

Lecture 20: Auto Growth and sizing of transaction log

Lecture 21: Types of Recovery Models

Lecture 22: Function fn_dblog to view inside a transaction log

Lecture 23: What is virtual log file (VLF)

Lecture 24: Create a SQL database

Lecture 25: The importance of Tempdb

Lecture 26: Attach and detach a database

Lecture 27: Introduction to Backups

Lecture 28: Full Database Backup

Lecture 29: Transactional Log Backups

Lecture 30: Differential Backups

Lecture 31: Introduction to Restore

Lecture 32: Restore database with GUI

Lecture 33: Restore database using differential

Lecture 34: Recovery mode with tail log backup

Lecture 35: Backup using Maintenance plan

Lecture 36: Backup database using Maintenance plan

Lecture 37: Maintenance Plan Tasks

Lecture 38: Don’t shrink a database

Lecture 39: The importance of using SQL Server Agent

Lecture 40: Create a simple backup job using SQL Server Agent

Lecture 41: The importance of DBCC CheckDB

Lecture 42: Using SQL Server Agent with multiple steps

Lecture 43: Setting up SQL Database Mail

Lecture 44: Setting up SQL Database Mail Part2

Lecture 45: Setting up alerts Severity Errors from 17 to 25

Lecture 46: Central Management with SQL Server Agent (CORRECTION)

Lecture 47: Central Management with SQL Server Agent

Lecture 48: Installing free VMware Pro Player for virtualization

Lecture 49: Introduction to SQL Server Security

Lecture 50: Demonstration of Users Logins Roles

Lecture 51: Managing security with T SQL

Lecture 52: Selecting Authentication or Mixed Mode security

Lecture 53: Accessing SQL Server using SQL Login

Lecture 54: Understanding SQL Server Roles

Lecture 55: Managing SQL Server Roles via TSQL

Lecture 56: SQL Server Roles Demonstration

Lecture 57: Managing SQL Server Permissions

Lecture 58: Best SQL Server Practice Security

Lecture 59: SQL ADMINISTRATION PART 2 TABLE OF CONTENT

Instructors

Raphael Asghar
Production SQL Database Administrator

Rating Distribution

1 stars: 58 votes
2 stars: 82 votes
3 stars: 596 votes
4 stars: 2222 votes
5 stars: 3262 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu