Online SQL Server Learning With Examples & Projects

Online SQL Server Learning With Examples & Projects

 SQL SERVER - 2005 & 2008

 CSE-IT-LIVE-PROJECTS - LEARN UNIQUE & USEFUL

The History of SQL Server and relational databases

    Relational database history
    The evolution of SQL Server
    SQL Server and ANSI standards

Installing and configuring SQL Server

    Pre-installation steps
    Installing SQL Server
    Configuring the run-time SQL Server system
    Patching SQL Server - Service packs

SQL Server data storage management

    SQL Server file management architecture
    Creating database files
    Creating SQL Server log files
    Using SQL Server file groups

Managing data with the DTS utility

    Using DTS to export and import SQL Server table data

SQL Server Security management

    Windows security management for the server
    Windows authentication mode
    SQL Server rights and role management

SQL Server Backup & Recovery

    Overview of SQL Server backup & recovery
    Incremental backups
    Restoring a SQL Server database
    Standby database overview
    Shipping SQL Server log files to standby databases

SQL Server database Replication

    Microsoft replication architectures
    Creating a replication topology
    Configuring SQL Server replication

SQL Server Job scheduling

    Common database scheduled jobs
    Configuring SQLMail
    Setting SQL Server and server alert thresholds
    Creating customized error conditions
    Scheduling multi-step job streams

If you want any project in any language then mail the details to "amitguptarcetit09@gmail.com"

Tweet