Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Server Administration Part1
Bestseller
Highest Rated
Rating: 4.7 out of 5(8,399 ratings)
30,087 students

SQL Server Administration Part1

SQL Education with a purpose
Bestseller
Highest Rated
Created byRaphael Asghar
Last updated 1/2019
English

What you'll 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

Course content

1 section • 59 lectures • 10h 5m total length

  • What is a Domain7:12

    Understand how a domain centralizes user accounts and resources via an active directory domain controller and virtualization with VMware to deploy Windows 2012 and SQL Server.

  • Software to download and install8:03

    Learn to set up a production SQL database environment by downloading VMware Workstation, Windows Server 2012, and SQL Server 2012, creating domain controllers, dedicated drives, and SQL Server service accounts.

  • POST ADDENDUM8:11
  • APPS NEEDED7:34

    Rafael guides you to collect and download six essential apps—virtual box, Windows server 2016 ISO, SQL Server, SSMS 17, AdventureWorks from GitHub, and Visual Studio 2015—then prepares a VM setup.

  • CREATE VM18:22

    Create a new VirtualBox virtual machine and install Windows. Set up SQL Server 2017 and SSMS, allocate host memory and disk, and enable guest additions.

  • INSTALL SQL SERVER 20179:43
  • ADVENTUREWORKS 2017 DB8:13

    Install SQL Server and SSMS, then install SSDT and restore the Adventure Works 2017 database on a virtual machine.

  • COMPARISON OF SQL 2014 VS 20172:38

    Compare SQL Server 2014 and 2017 to show their similar front-end interfaces, and apply the same database administration principles across versions, ensuring script compatibility with Adventure Works.

  • Create Virtual Machine Domain Controller6:00
  • Promote Domain Controller to Active Directory15:06

    Promote a Windows Server 2012 VM to a domain controller by installing the Active Directory Domain Services role and DNS to create the sql.com forest.

  • Create Vm for SQL Server 2012 Install Part110:29
  • Create Vm for SQL Server 2012 Install Part 213:46
  • Install SQL On Separate Drive with Service Accounts Part 111:13

    Install sql server 2012 using active directory service accounts and separate data and log drives, creating virtual drives for data on i and logs on l.

  • Install SQL On Separate Drive with Service Accounts Part 213:23
  • Installing Service Packs and Fixes (SP2)9:20
  • Touring SQL Server Management Studio (SSMS)10:28
  • Introduction to System Databases13:32

    Identify the system databases—master, model, msdb, temp—and the read-only resource database, and understand their roles, template behavior, and backup considerations.

  • SQL Server Data and Log Files8:21
  • Detail Transaction log ATM Example7:35
  • Auto Growth and sizing of transaction log16:11
  • Types of Recovery Models12:15

    Learn how simple, full, and bulk recovery models govern transaction log backups and log truncation, balancing data safety with log growth in production SQL Server.

  • Function fn_dblog to view inside a transaction log7:18

    Explore how the fn_dblog function reveals transactional log activity via LSNs, and demonstrate how transactional log backups truncate the log while full backups do not.

  • What is virtual log file (VLF)11:22
  • Create a SQL database14:06

    Learn how to create a SQL database using GUI or scripting, set initial sizes and auto growth for data and log files, and script production databases for repeatable deployment.

  • The importance of Tempdb13:24

    Discover how tempdb, a busy system database rebuilt on restart, hosts temporary objects like tables and procedures, and how pre sizing boosts performance.

  • Attach and detach a database8:28
  • Introduction to Backups13:45

    Explore backup and restore strategies essential for a production SQL database administrator, including full, differential, and transactional log backups, with planning for redundancies and restore timeframes.

  • Full Database Backup10:59
  • Transactional Log Backups10:56
  • Differential Backups8:16
  • Introduction to Restore5:19
  • Restore database with GUI11:39

    Restore a deleted database via the GUI using a full backup and subsequent transaction log backups in sequence to recover data without gaps.

  • Restore database using differential9:11
  • Recovery mode with tail log backup11:56
  • Backup using Maintenance plan11:11

    Automate system database backups with a maintenance plan wizard in SQL Server, configure full backups, schedule daily runs, and verify backup integrity.

  • Backup database using Maintenance plan10:33
  • Maintenance Plan Tasks5:45
  • Don’t shrink a database15:43
  • The importance of using SQL Server Agent7:58
  • Create a simple backup job using SQL Server Agent5:20

    Create a simple SQL Server Agent backup job that runs a T-SQL full backup of the admin database, scheduled daily at 9:31 PM, with enablement and basic success/failure handling.

  • The importance of DBCC CheckDB9:38

    Learn how to use dbcc check database to validate both physical and logical integrity of databases, manage resource-intensive checks, and implement production-ready job scheduling for reliable backups.

  • Using SQL Server Agent with multiple steps5:59
  • Setting up SQL Database Mail10:58
  • Setting up SQL Database Mail Part25:16

    Learn to set up and monitor SQL Server database mail via GUI and T-SQL, create accounts and profiles, enable through sp_configure, and script mail status and logs for multiple servers.

  • Setting up alerts Severity Errors from 17 to 2514:23
  • Central Management with SQL Server Agent (CORRECTION)0:52
  • Central Management with SQL Server Agent12:21

    Learn to manage many SQL Server instances with central management, using multi server administration to propagate identical jobs from a master to target servers.

  • Installing free VMware Pro Player for virtualization17:44
  • Introduction to SQL Server Security13:44
  • Demonstration of Users Logins Roles11:43

    This demonstration shows how SQL Server administration handles users, logins, and roles using Windows authentication and SQL logins, mapping Windows users to SQL logins and assigning database permissions.

  • Managing security with T SQL6:27
  • Selecting Authentication or Mixed Mode security13:19

    Explore windows authentication versus mixed mode in sql server, including the risks of the sa account, and learn to enable, disable, or rename it with strong passwords.

  • Accessing SQL Server using SQL Login12:46
  • Understanding SQL Server Roles11:45
  • Managing SQL Server Roles via TSQL5:57
  • SQL Server Roles Demonstration12:59
  • Managing SQL Server Permissions14:38
  • Best SQL Server Practice Security13:22
  • SQL ADMINISTRATION PART 2 TABLE OF CONTENT0:53

Requirements

  • While not 'mandatory', it is highly recommended that the student take my first course T-SQL - and have access to a desktop or laptop. All software, scripts, documentation will be provided

Description

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.

Who this course is 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

Report abuse