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 CompTIA Security+ Amazon AWS Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift 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
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business 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
Development Database Design & Development Server Administration

SQL Server Administration Part 2

Learn how to optimize, improve performance, review and analysis statistics, use monitoring tools, and create indexes
Highest Rated
Rating: 4.5 out of 54.5 (1,489 ratings)
10,122 students
Created by Raphael Asghar
Last updated 8/2018
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • At the end of SQL Administration Part 2, the student will be able to create indexes for to gain performance, use the SQL Profiler to find and trouble shoot expensive queries, use the activity monitor for analysis, deploy the performance monitor to find specific about SQL Server internals, use DTA utility, create and investigate issues with DMVs and extended events, look at SQL logs, monitor the health of the SQL Server more efficiently and much more.
Curated for the Udemy for Business collection

Course content

1 section • 49 lectures • 10h 12m total length

  • Preview06:28
  • Preview14:40
  • Install SQL Suite
    11:20
  • POST ADDENDUM
    08:11
  • APPS NEEDED
    07:34
  • CREATE VM
    18:22
  • INSTALL SQL SERVER 2017
    09:43
  • ADVENTUREWORKS 2017 DB
    08:13
  • COMPARISON SQL SERVER 2014 VS 2017
    02:38
  • Clustered Index
    16:59
  • Create non cluster index
    12:07
  • Composite Index
    18:06
  • Use or not use indexes
    11:20
  • Deciding factors in creating indexes
    20:09
  • using sql profler for indexes
    19:41
  • Reorganize and Rebuild Indexes
    15:47
  • Into To SQL Profiler
    17:57
  • SQL Profiler longest running query
    13:37
  • Audit logins
    12:11
  • SQL Profile with Index Tuning
    10:40
  • SQL Profiler Best Practice
    05:24
  • SQL Server Side Trace
    16:31
  • Database Engine Tuning Advisor
    12:10
  • Statistics
    11:44
  • Activity Monitor
    14:01
  • SQL Performance Monitor
    16:24
  • SQL Performance hardware issues
    12:49
  • SQL Performance Monitoring Hardware CPU
    16:47
  • SQL Performance Monitoring Hardware memory
    10:10
  • SQL Performance Monitoring Hardware disks
    08:46
  • 23 SQL Perfmon scehdule
    08:51
  • DMV
    13:53
  • Block and Locks
    13:15
  • BLOCKING
    10:45
  • Deadlock
    04:45
  • Extended Events
    18:20
  • Extended Events via TSQL
    11:59
  • Database Snapshots
    15:12
  • Import Export Data
    10:01
  • BCP
    12:59
  • Partition
    19:51
  • Partition part 2
    19:51
  • Partition 3
    12:46
  • Contained datababase Part 1
    11:47
  • Contained datababase Part 2
    10:12
  • Policy Based Management
    18:46
  • Linked Servers
    08:20
  • SQL server and agent logs
    05:24
  • SQL ADMINISTRATION PART 3
    05:32

Requirements

  • All the student needs is a laptop or a desktop. All material where appropriate will be downloaded via internet. Plus, you will need as a pre-requisite SQL Administration Part 1. All scripts and documentation will be provided by me to the student via zip file.

Description

SQL Administration Part 2 will benefit the student by providing the necessary guide lines for enhancing SQL Server performance by utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics; and also I will explain a handful of utilities to gather information about SQL Server internals, such as SQL Profiler, Database Tuning Advisor (DTA), Extended Events, SQL performance monitor, Activity monitor, and teach about partitions, creating contained database for recovery, reviewing SQL server logs and by installing SQL Server 2014 as the newer SQL version.The student will not only add to the knowledge gained bur SQL Administration Part 1, but get prepared for the next course SQL Administration Part 3 – the high availability solutions.

Who this course is for:

  • Student who are interested in managing SQL Server, Developers, IT Admins, System Admins and anyone who is responsible for the databases.

Featured review

Kunal Banerjee
Kunal Banerjee
14 courses
4 reviews
Rating: 5.0 out of 5a year ago
Many things to learn. the learning experience is very smooth enjoying and learning at the same time 😊. I am always trying to visualize the scenario of my workplace and apply those ideas on workplace.

Instructor

Raphael Asghar
Production SQL Database Administrator
Raphael Asghar
  • 4.5 Instructor Rating
  • 16,049 Reviews
  • 104,012 Students
  • 25 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
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.