Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL DBA For Beginners
Rating: 3.7 out of 5(21 ratings)
1,198 students

SQL DBA For Beginners

Common issues faced by SQL DBA in the Real time World.
Created byRajasekhar Reddy Bolla
Last updated 6/2021
English
English [Auto],

What you'll learn

  • How to Monitor the SQL Server in Real World?
  • Transaction log File is Full. How to resolve in Real World?
  • How to Shrink TempDB without restarting SQL Server in Real word?
  • Your SQL server is slow? Perform below actions will drastically improve
  • SQL Server Best Practices

Course content

1 section • 5 lectures • 51m total length

  • 1.How to Monitor the SQL Server in Real World?10:53

    Learn real-world SQL server monitoring techniques to track performance metrics, identify blocking and deadlocks, monitor CPU and memory, and use scripts and tools to inspect execution plans and missing indexes.

  • 2.Transaction log File is Full. How to resolve in Real World?10:31

    This lecture explains why a transaction log file becomes full and how to resolve it in real world. Discover checks on space, log backups, checkpoints, and handling long running transactions.

  • 3.How to Shrink TempDB without restarting SQL Server in Real word?5:48

    Shrink tempdb in SQL Server without restarting the service by cleaning the buffers and caches and running a targeted script to reclaim space.

  • 4.Your Sql server is slow? Perform below actions will drastically improve9:58

    Improve sql server performance by focusing on missing indexes, automatic indexing suggestions, avoiding duplicate and excessive indexes, and using clustered indexes and temporary tables wisely.

  • 5.Sql Server Best Practices14:11

    Apply sql server best practices to boost performance by focusing on maintenance jobs, indexing (missing, duplicate, user indexes), and up-to-date statistics, plus selective file groups, backups, restores, compatibility settings.

Requirements

  • I have designed the course for the people that want to learn how to manage a SQL Server

Description

Become a real expert on SQL server DBA by going through all these videos. I'm 100% sure. You really like these videos and documents.

There are 5 Videos on this course and 5 documents for each video.

  1. How to Monitor the SQL Server in Real World?

  2. Transaction log File is Full. How to resolve in Real World?

  3. How to Shrink TempDB  without restarting SQL Server in Real word?

  4. Your SQL server is slow? Perform below actions will drastically improve

  5. SQL Server Best Practices

This course will introduce to you the foundation of SQL Server Administration 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.  All Scripts and documentation is provided for you. All you need is a desire to learn and fulfill you future goals. These courses will give you that direction.


This course will introduce to you the foundation of SQL Server Administration 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.  All Scripts and documentation is provided for you. All you need is a desire to learn and fulfill you future goals. These courses will give you that direction.

This course will introduce to you the foundation of SQL Server Administration 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.  All Scripts and documentation is provided for you. All you need is a desire to learn and fulfill you future goals. These courses will give you that direction.

This course will introduce to you the foundation of SQL Server Administration 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.  All Scripts and documentation is provided for you. All you need is a desire to learn and fulfill you future goals. These courses will give you that direction.

Who this course is for:

  • I have designed the course for the people that want to learn how to manage a SQL Server

Report abuse