Sql-server-database-administration

India, Uttar Pradesh, Ghaziabad
Published 1 year ago
ID #2219
QR CODE
1 photo
Check with seller
Sql-server-database-administration
India, Uttar Pradesh, Ghaziabad,
Published 1 year ago

Description

Administer SQL Server 2012 and 2014 with SQL Server Management Studio and Transact-SQL
Ensure SQL Server security with logins, roles, users and permissions
Develop backup strategies and recover from disasters
Leverage SQL Server Agent to automate administrative tasks
Isolate and repair fragmentation and database corruption

Facilities being provided: We're providing an In-class dedicated cloud based system for your sole use

Employing Transact-SQL and the graphical tools
Upgrading SQL Server 2005 and 2008 databases
Implementing security for logins, databases and objects
Restoring a database to point-of-failure
Repairing database corruption
Building a database maintenance plan

Course 2108 Contents:
Getting Started with SQL Server
Setting up SQL Server

Selecting installation options
Installing a named instance

Leveraging essential tools

SQL Server Management Studio
Configuration Manager
Transact-SQL
sqlcmd
PowerShell
Dedicated Administrator Connection

Constructing and Managing Databases
Inspecting storage structures

Relating servers, databases and files
Creating databases and transaction logs

Designing file groups

Maximizing storage utilization
Placing tables on file groups

Upgrading and moving databases

Choosing between upgrade and migration
Detaching and attaching databases

Controlling database space

Permitting automatic database growth
Adding database files to expand databases

 

Contact seller

    Seller's picture
    Kumar Amit
    Unregistered user

    Comments

    Question? Need more information? Want to ask question? Add new comment...
    Ask questions related to this listing only.
    Comments are moderated.
    Add new comment
    Check with seller
    Contact seller No phone nuxxxx

    Seller's info

    Seller's picture
    Kumar Amit
    Unregistered user

    Listing location

    India, Uttar Pradesh, Ghaziabad
    ACLM Institute Of Professional Studies Plot No. – 662 | Sector - V | Vaishali | Ghaziabad - 201010