TriPAL Point

SQL Database Administration

Become an IT professional responsible for the installation, configuration, upgrading, administration, monitoring, maintenance, and security of databases in an organization.Learn the development and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements. They may also plan, co-ordinate and implement security measures to safeguard the database.

0 STUDENTS ENROLLED
    OFFER NOTE
    Find out how you can get 100% reimbursement when you buy this course.

    It is FREE – Register Now

    Course Curriculum

    Installing SQL Server
    Choosing installation options
    Upgrading from previous versions
    Essential Tools
    SQL Server Management Studio
    Transact-SQL
    SQL Server Configuration Manager
    Policy-based Management
    Creating and Managing Databases Storage Structures
    Creating databases and transaction logs
    Defining file groups
    Managing Database Space
    Permitting automatic database growth
    Specifying database options
    Moving Databases
    Scripting objects and moving data with Transact-SQL
    Detaching and attaching databases
    Implementing Server and Database Security: Logins
    Contrasting Windows and SQL Server authentication
    Making logins members of server roles
    Enforcing password policy
    Authorizing Database Access
    Adding users and defining new roles
    Delegating privileges with predefined roles
    Handling mismapped logins
    Managing Permissions: Scoped Privileges
    Permitting object creation
    Granting blanket permissions
    Schemas
    Designing schemas
    Assigning a default schema
    Handling Object-Level Permissions
    Limiting object access
    Meeting complex permission requirements with roles
    Examining permission hierarchies
    Disaster Recovery
    Backing-Up Databases
    Choosing a recovery model
    Performing full, log and differential backups
    Reclaiming transaction log space
    Restoring Databases
    Recovering user databases
    Testing recovery scenarios
    Automating Tasks: The SQL Server Agent
    Configuring the agent
    Setting up Database Mail
    Multistep Jobs
    Defining jobs to handle routine tasks
    Creating alerts and operators
    Associating alerts with jobs
    Performing Database Maintenance
    Identifying and curing fragmentation
    Finding and repairing database corruption
    Database Maintenance Plan Wizard
    Choosing maintenance tasks
    Scheduling plan execution
    Ad-hoc Monitoring
    Identifying problems with Activity Monitor
    Querying Dynamic Management Objects
    Management Data Warehouse
    Configuring data collection
    Reviewing the reports

    Course Reviews

    No Reviews found for this course.

    TAKE THIS COURSE
    • $ 999.00
    • 2 yearsSTARTS IN
    • month, 2 weeks

    Popular Courses

    Recent Posts

    Term : Taxonomy Mismatch: Selected Term does not exist in Taxonomy ! ..more..
    Template Design © VibeThemes. All rights reserved.