Setup Menus in Admin Panel

Compu21

Setup Menus in Admin Panel

MS SQL Server 2012 Admin

MS SQL Server 2012 Admin Module 1  Overview of SQL Server 2008/2012 introduces SQL Server 2008/2012. It defines some of …

0 STUDENTS ENROLLED

    MS SQL Server 2012 Admin

    Module 1  Overview of SQL Server 2008/2012

    introduces SQL Server 2008/2012. It defines some of the important characteristics of SQL Server 2008/2012 and explains the environments in which it is designed to work. You will be introduced to the different parts of the product and given some idea as to the role played by these parts.

    Module 2  Installing SQL Server 2008/2012

    explains how to install SQL Server 2008/2012. It lists the hardware and software requirements of the program, and it explains the specific information you have to supply and the decisions you have to make during the installation process. This Module covers using default, named, and multiple instances of SQL Server 2008/2012.

    Module 3  Preparing to Use SQL Server 2008/2012

    reviews the results of installing SQL Server 2008/2012. This Module explains starting, stopping, and pausing SQL Server services. The Module also covers working with OSQL, SQL Query Analyzer, and SQL Server Enterprise Manager.

    Module 4  Upgrading to SQL Server 2008/2012

    shows you how to perform a version upgrade of a complete SQL Server 6.5 or 7.0 installation to SQL Server 2008/2012. This Module also explains how to perform an online database upgrade from SQL Server 7.0.

    Module 5  Understanding System and User Databases”

    explains SQL Server 2008/2012 databases. This includes the structure of a data file and the architecture of the transaction log. This Module concludes with a discussion about system tables, including the querying of system and database catalogs.

    Module 6  Creating and Configuring User Databases

    teaches how to create a new user database, set database options for new or existing databases, and manage the size of data and transaction log files. This Module concludes with a discussion about placing database files on multiple disks for recovery, fault to l­erance, and performance.

    Module 7  Populating a Database

    discusses the population of user databases with existing data. It shows you how to transfer and transform data. This Module focuses on the use of DTS, Bcp, and the BULK INSERT Transact-SQL statement.

    Module 8  Developing a Data Restoration Strategy

    presents an overview of the SQL Server 2008/2012 backup and restore processes and discusses the issues that you should consider when planning a backup and restore strategy for a SQL Server 2005/2008 installation.  

    Module 9  Backing Up and Restoring SQL Server

    teaches you how to perform database backups using disk and tape. It also teaches you how to perform database restorations. This Module explains how to use SQL Server Enterprise Manager and Transact-SQL statements.

    Module 10  Managing Access to SQL Server 2008/2012

    discusses controlling access to SQL Server 2008/2012, including the authentication process and the authorization process. The Module concludes by showing you how to create and manage logins.

    Module 11  Managing SQL Server Permissions

    shows how to grant data-base-specific permissions. It also discusses the use of application roles. The Module concludes by teaching you how to design an access and permissions strategy.

    Module 12  Performing Administrative Tasks

    teach you how to perform a variety of configuration tasks and setup tasks. These include the configuration of the SQL Server service, the SQL Server Agent service, SQL Mail, SQLAgentMail, and XML. The Module concludes with a discussion of the performance of periodic maintenance tasks.

    Module 13  Automating Administrative Tasks

    shows you how to automate routine tasks using operators, jobs, and alerts. It also teaches the creation of a database maintenance plan. It concludes by teaching you to create multiserver jobs.

    Module 14  Monitoring SQL Server Performance and Activity

    discusses the development of a performance monitoring methodology. This Module introduces each of the monitoring tools and shows you how to use each tool. The Module concludes by teaching you how to perform specific monitoring tasks, such as for memory use or slow-performing queries.

    Module 15  SQL Server Reporting Services (SSRS) & SQL Server Analysis Services (SSAS)

    SSRS: A complete set of tools that you can use to create, manage, and view reports.
    SSAS: Advanced data analysis and interactive reporting &could find many uses for the predictive power of data mining.

    Module 16  “Maintaining High Availability” discusses the use of standby servers, including the use of log shipping to automate the process of maintaining a standby server.

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 10 Days

    Advanced Course Search Widget

    Popular Courses

    Recent Posts