Getting Started with Your First SQL Server Instance

سرفصل های دوره

This course will teach you the basics of SQL Server architecture, installation, tools, and configuration in order to help you understand SQL Server administration.

01. Course Overview

01. Course Overview

02. Introducing SQL Server

01. Introduction

02. SQL Server Beginnings

03. Current and Future Versions

04. SQL Server Services

05. Databases and Files

06. The SQL Triad

07. Tools and Utilities

08. Logical Structures

09. Versions vs. Editions

10. Summary and Additional Resources

03. Installing SQL Server 2017 Developer Edition

01. Introduction

02. Prerequisites and Downloads

03. Demo- Installing SQL Server

04. Management Studio Install

05. Demo- SSMS Install and Instance Verification

06. Summary and Additional Resources

04. Understanding the Different SQL Server Tools and Utilities

01. Overview

02. Configuration Manager - Services

03. Configuration Manager - Networking

04. SSMS - Open and Connect

05. SSMS - Instance Properties

06. SSMS - Databases

07. SSMS - Security

08. SSMS - Maintenance Plans

09. SSMS - Errorlogs and Database Mail

10. SSMS - SQL Agent and Jobs

11. SSMS - More Options

05. Configuring Your SQL Server Instance

01. Welcome and Overview

02. Demo Introduction

03. Demo- Backup Compression and Maintenance Plan

04. Demo- CheckDB Plan

05. Demo- MAX Memory and Cost Threshold

06. Demo- Instant File Initialization

06. Summary and Resources

01. Summary and Resources

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight