Themabewertung:
  • 0 Bewertung(en) - 0 im Durchschnitt
  • 1
  • 2
  • 3
  • 4
  • 5
SQL Server Database Administrator Part-1
#1
[Bild: 3i1bpvmbmvjzwlmt3mtvggmjvb.jpg]

SQL Server Database Administrator Part-1
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 7.79 GB | Duration: 19h 21m




What you'll learn
Learn SQL Server database administration step by step. Installation, Configuration, Working with databases, Security, Database Backups and Restores, DB Mail.
Installing and Configuration SQL Server
Working with Databases and database architecture and common database issues
Working with Security, Backups and automation, Database Mail


Description
SQL Server Database Administration Part-1 covers all necessary topics to enter as a DBA. This course covers the administration basics including the following concepts.

This course is the startup course to become SQL Server Database Administrator. You can opt for Part-2 to become complete SQL Server DBA. In Part-2 I will discuss all high availability concepts including Log Shipping, Database Mirroring, Always On, Replication, Clustering and Performance Tuning concepts along with troubleshooting common issues.

Introduction to SQL Server

Application Architecture

DBA - Roles and Responsibilities

Introduction to SQL Server

Introduction to SQL

SQL Server Tools

SQL Server Services

How to Start/Stop Services

SQL Server Instances

Default and Named Instances

Instance Summary

Installation Pre-Requisites

SQL Server Installation

Installing using Configuration File

Working with Configurations

Verifying Installation using summary.txt file

Configuring Data and Log File Locations

Configuring ErrorLogs

Using Trace Flags

Configuring Backup Folder Paths

Patching SQL Server

How to rollback the patches

Configuring Memory

Configuring CPU

Configuring Remote Connections

Basic Query Life Cycle Stages

Configuring DAC

Working with Databases both System and User Defined

System Databases

Moving master, msdb and TempDB databases

Database Architecture

Log File Architecture- VLFs, Blocks, LSN

Data File Architecture - Extents, Pages

Page Architecture

Types of Pages

Database States

Database Suspect Mode scenarios

Errors 17207, 17204

Rebuilding master database

Troubleshooting common database issues

Working with Transaction Log file and its common issues

Working with Security Features

Users, Permissions and Role management

Server Roles

Database Roles

Orphan users, how to resolve orphan users

Creating users with passwords from SQL Server 2012

Encryptions

Recovery Models

Checkpoints

Types of Checkpoints

Backups and Restores

Different Types of Backups

Full, Differential, T.Log backups

File, Filegroup Backups

Copy-only backups

Backup Compression

Restoring databases

Database Recovery States

How to take tail log backup

checksum and SQL Server Backups

checksum and restores

common backup and restore issues


Who this course is for:
Freshers, SQL Server developers, Oracle DBAs, any student who wants to become SQL DBA


[Bild: sqlserverdatabaseadmicikix.jpg]

Download from RapidGator

Download from Rapidgator:

Download from Keep2Share
Zitieren


Möglicherweise verwandte Themen…
Thema Verfasser Antworten Ansichten Letzter Beitrag
  Quick SQL in VB.Net: Database Apps in Visual Basic SQL Panter 0 65 09.01.2024, 23:36
Letzter Beitrag: Panter
  Part 3 FAA Private Pilot Ground School (Part 61) Panter 0 67 13.07.2023, 02:07
Letzter Beitrag: Panter
  CBTNuggets - Microsoft Certified Azure Database Administrator Associate - DP-300 Panter 0 135 25.10.2022, 22:26
Letzter Beitrag: Panter
  Python programming with MySQL database: from Scratch Panter 0 119 18.09.2022, 03:16
Letzter Beitrag: Panter
  CBTNuggets - Server Administrator Training: Troubleshooting Panter 0 122 24.08.2022, 21:16
Letzter Beitrag: Panter
  Live Project in C# Net Core & Windows Forms by SQL Database Panter 0 121 14.08.2022, 23:31
Letzter Beitrag: Panter

Gehe zu:


Benutzer, die gerade dieses Thema anschauen: 1 Gast/Gäste
Expand chat