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 Mindfulness Personal Development 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 Big Data
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
30-Day Money-Back Guarantee

This course includes:

  • 10 hours on-demand video
  • 35 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Development Database Design & Development Server Administration

SQL Server Administration Part1

SQL Education with a purpose
Bestseller
Rating: 4.5 out of 54.5 (3,035 ratings)
13,232 students
Created by Raphael Asghar
Last updated 1/2019
English
English [Auto]
30-Day Money-Back Guarantee

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
Curated for the Udemy for Business collection

Course content

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

  • What is a Domain
    Preview07:12
  • Preview08:03
  • POST ADDENDUM
    08:11
  • APPS NEEDED
    07:34
  • CREATE VM
    18:22
  • INSTALL SQL SERVER 2017
    09:43
  • ADVENTUREWORKS 2017 DB
    08:13
  • COMPARISON OF SQL 2014 VS 2017
    02:38
  • Create Virtual Machine Domain Controller
    06:00
  • Promote Domain Controller to Active Directory
    15:06
  • Create Vm for SQL Server 2012 Install Part1
    10:29
  • Create Vm for SQL Server 2012 Install Part 2
    13:46
  • Install SQL On Separate Drive with Service Accounts Part 1
    11:13
  • Install SQL On Separate Drive with Service Accounts Part 2
    13:23
  • Installing Service Packs and Fixes (SP2)
    09:20
  • Touring SQL Server Management Studio (SSMS)
    10:28
  • Introduction to System Databases
    13:32
  • SQL Server Data and Log Files
    08:21
  • Detail Transaction log ATM Example
    07:35
  • Auto Growth and sizing of transaction log
    16:11
  • Types of Recovery Models
    12:15
  • Function fn_dblog to view inside a transaction log
    07:18
  • What is virtual log file (VLF)
    11:22
  • Create a SQL database
    14:06
  • The importance of Tempdb
    13:24
  • Attach and detach a database
    08:28
  • Introduction to Backups
    13:45
  • Full Database Backup
    10:59
  • Transactional Log Backups
    10:56
  • Differential Backups
    08:16
  • Introduction to Restore
    05:19
  • Restore database with GUI
    11:39
  • Restore database using differential
    09:11
  • Recovery mode with tail log backup
    11:56
  • Backup using Maintenance plan
    11:11
  • Backup database using Maintenance plan
    10:33
  • Maintenance Plan Tasks
    05:45
  • Don’t shrink a database
    15:43
  • The importance of using SQL Server Agent
    07:58
  • Create a simple backup job using SQL Server Agent
    05:20
  • The importance of DBCC CheckDB
    09:38
  • Using SQL Server Agent with multiple steps
    05:59
  • Setting up SQL Database Mail
    10:58
  • Setting up SQL Database Mail Part2
    05:16
  • Setting up alerts Severity Errors from 17 to 25
    14:23
  • Central Management with SQL Server Agent (CORRECTION)
    00:52
  • Central Management with SQL Server Agent
    12:21
  • Installing free VMware Pro Player for virtualization
    17:44
  • Introduction to SQL Server Security
    13:44
  • Demonstration of Users Logins Roles
    11:43
  • Managing security with T SQL
    06:27
  • Selecting Authentication or Mixed Mode security
    13:19
  • Accessing SQL Server using SQL Login
    12:46
  • Understanding SQL Server Roles
    11:45
  • Managing SQL Server Roles via TSQL
    05:57
  • SQL Server Roles Demonstration
    12:59
  • Managing SQL Server Permissions
    14:38
  • Best SQL Server Practice Security
    13:22
  • SQL ADMINISTRATION PART 2 TABLE OF CONTENT
    00: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

Instructor

Raphael Asghar
Production SQL Database Administrator
Raphael Asghar
  • 4.5 Instructor Rating
  • 14,794 Reviews
  • 99,909 Students
  • 23 Courses

Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen.  Want to help those students that want more that the basic SQL Language.  Creating real life courses for those students who want a simple path to becoming a SQL DBA.  I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.

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