Getting Started with SQL Server 2016 Administration – آموزش مدیریت اس کیو ال سرور

Microsoft SQL Server یک نرم‌افزار مدیریت پایگاه داده رابطه‌ای است که توسط شرکت مایکروسافت توسعه داده می‌شود. از جمله ویژگی‌های این سامانه، می‌توان به ساخت و مدیریت بانک اطلاعاتی رابطه‌ای، پشتیبانی از ACID، پشتیبانی از Referential integrity، قابلیت‌های انتقال پایگاه و بسیاری از قابلیت‌های دیگر داده اشاره کرد. این نرم افزار دارای ویرایش‌های متنوع و متناسب با محیط‌های کاری مختلف است.

لینک دانلود ویدئو آموزشی Getting Started with SQL Server 2016 Administration

 

دانلودحجم: 849 مگابایت

رمز فایل: technet24.ir

Getting Started with SQL Server 2016 Administration

Video Details
ISBN 139781787123199
Course Length3 hours and 49 minutes

Video Description
SQL Server DBAs enable efficient administration of its SQL Server solution to get breakthrough performance and top-notch security. This video will teach you basic as well as advanced administration tasks for handling, managing, and monitoring your SQL Server 2016 efficiently. After setting up and configuring your virtual machine for SQL Server 2016, you will implement various techniques to improve query performance, create indexes, and perform activity monitoring. You will learn how to secure your SQL Server solution by implementing various authentication techniques. Finally, you’ll ensure your database is always available and ready for any catastrophe.

This comprehensive tutorial is packed with real-world examples and tips to solve the trickiest of challenges. By the end of this course, you will have a solid foundation in all SQL Server administration concepts and will be able to implement them in a production environment.

Style and Approach
This video is a step-by-step guide to help you understand and master the administration aspects of SQL Server 2016, with examples and use-cases wherever required. Every topic is explained in a clear, easy–to-understand manner.
Table of Contents
Installing SQL Server 2016
Login and User Security
Databases
Administering Database Objects
Improving Query Performance

What You Will Learn

How to install SQL Server
Login and user security
Creating user databases
Administering database objects
How to improve query performance

Authors
Steve Jones

Steve Jones has been working with SQL Server since 1991. He has worked with all versions of SQL Server as a developer and DBA, in a variety of industries and companies. Over the last 25 years, he been greatly pleased with the enhancements and growth of the platform; he feels SQL Server is an outstanding database platform that is suited to a wide variety of needs and situations.

In 2001, Steve founded SQLServerCentral.com with Brian Knight, Andy Warren, and three other partners. In 2002, Steve left his job with PeopleSoft to manage SQLServerCentral as a full-time editor, publisher, and writer. Andy, Brian, and Steve continued to manage and grow SQLServerCentral until 2007 when it was sold to Redgate Software along with Database Weekly (then Database Daily). At that time Steve went on to work for Redgate and has continued his work with SQLServerCentral and Red Gate as a writer and speaker.

Steve regularly presents at SQL Saturday conferences and other technical events on career and technical topics, and enjoys meeting and interacting with the SQL Server community. He has been a presenter at //build/, the PASS Summit, Dev/IT Connections, VSLive, SQL Bits, SQL Intersection, and many user groups in the US.

Steve is a graduate of the University of Virginia. He has been awarded the title of Microsoft Data Platform MVP from 2008–2017 for his many contributions to the SQL Server community. Steve holds an MCSE from NT 4.0, an MSITPro in SQL Server, and numerous other MCP certifications in SQL Server.

90%
Awesome
  • Criteria
7 دیدگاه
  1. اشکان پزشکی says

    عالی بود ممنونم

  2. amin13739864 says

    سلام
    لینکتون مشکل داره لطفا درست کنید ( من که کلا از سرور dl3 شما نمیتونم چیزی دانلود کنم بقیه سرورا مشکل ندارن)
    ممنون

    1. Technet says

      سرور dl3 در حال انتقال هست. بزودی مشکل برطرف میشه.

      1. amin13739864 says

        ممنون پس ما منتظریم

      2. امین says

        هنوز مشکل داره

  3. afshinzv says

    سلام وقتتون بخیر امروز پس از کلی سختی تونستم به وبسایت دسترسی پیدا کنم با توجه به اینکه از زمان اکانتم تنها 50 دقیقه باقی مونده و اینکه قول داده بودید لینک دانلود این فایل رو درست بفرمایید تا بتونیم از این سرور دانلود کنیم باز هم میبینم هنوز مشکل داره.
    با کمال تشکر از همکاریتون، اکانت اینجانب هم تمام شد

    1. technet24 says

      سلام
      لینک دانلود اصلاح شده…

دیدگاه

آدرس ایمیل شما منتشر نخواهد شد.