دانلود فیلم آموزش مهارت های DBA در SQL Server

تعرفه تبلیغات در سایت
عنوان عکس
عنوان عکس
عنوان عکس
عنوان عکس
عنوان عکس

آرشیو مطالب

جستجوگر

یافته ها در جستجو

    امکانات وب

    پر مخاطب ها

    برچسب ها

    Requirements
    You should be able to use a PC at a beginner level
    Basic knowledge of Database Concepts
    Basic SQL knowledge
    Description
    SQL Server DBA Skills are in hot demand due to the growth and reliance on data.SQL Server is a relational database management system from Microsoft that’s designed for the enterprise environment.

    A DBA ( Database administrator) has to perform several responsibilities to ensure the smooth running
    of the SQL sever database.

    Some of the key daily responsibilities of a SQL Server DBA includes:

    Backups
    Confirm that backups have been made and successfully saved to a secure location
    Check the backup failure alerts, correct the errors and rerun the backups
    Review the average duration of backup, any significant changes occurred investigates on this.
    Most of the time it happens due to networking low bandwidth
    Validate the backup files using restore verify only. Jobs can be created to take care of the task and to send a notification if it fails to verify any backup.

    Performance
    Regularly monitor and identify blocking issues.
    Check Performance counters on all production servers and verify that all counters are within the normal range.
    Throughout the day, periodically monitor performance by collecting relevant data
    Create indexes to reduce the time it takes to get responses from the SQL Server after a T-SQL Script is executed.

    Security
    Check the auditing logs for failed logins and notify the audit team if necessary
    Implement relevant permissions to prevent authorized access to SQL Server databases

    T-SQL ( Transact -SQL )
    Transact-SQL is central to using SQL Server. All applications that communicate with an instance of SQL Server
    do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.
    T-SQL is Microsoft’s proprietary version of the standard SQL(Structural Query language)

    Using T-SQL you can communicate with SQL Servers to perform task like:

    Retrieving data from the database
    Updating data
    Inserting data into databases
    Deleting data

    Who is the target audience?
    Support Engineers
    Aspiring DBA’S
    Aspiring Programmers
    Aspiring Developers
    Aspiring Data Warehouse professionals
    Data Analyst
    Data Scientist
    Graduate looking for career in IT
    Courses :
    Getting Started with SQL Server
    SQL Server Integration Services -SSIS
    SQL Server Reporting Services -SSRS
    Creating a Column Chart with SSRS
    Creating a Pie Chart with SSRS
    Using SSRS to add Indicators to Reports
    Adding a Gauge with SSRS
    Adding Maps to Reports with SSRS
    Database Backup and Recovery
    Monitoring SQL Server Performance

    نویسنده : حمید بازدید : 8 تاريخ : دوشنبه 30 مرداد 1396 ساعت: 16:58

    آخرین مطالب

    خبرنامه

    عضویت

    نام کاربري :
    رمز عبور :