Bridging the Gap between Technology and Business

SQL Server 2012 Database Course

  • Overview on RDBMS and beyond Relational
  • About SQL Server and History
  • What are system Databases and explanation
    • Master
    • Model
    • MSDB
    • Temp DB
    • Resource

  • Hardware and Software Requirements
  • Instances and Type of Instances
    • Default
    • Named Instance
  • User Databases
  • Client Tools Installation

  • What is Database?
  • Creation of Database GUI and script based
  • Database remaining
  • Primary Data Files
  • How to Add secondary Data Files
  • Log Files
  • Moving system databases from one location to another location
  • Database file and filegroups (Primary and User Defined)
  • How to rename data and log files
  • How to change collation settings
  • How to change the database from multi user to single user mode
  • How to change the database to read only mode
  • How to add .ndf file while data file disk is full
  • How to monitor Disk spaces and failed connected server
  • How to change database from full to simple recovery model
  • How to connect the server from remote level

  • SQL Server Architecture
  • Storage Engine
    • Pages and Types of Pages
    • Extents and Types of Extents
  • Transaction log Architecture
  • Memory Architecture

  • What is a protocol and types of protocol
    • Shared Memory
    • Named pipes
    • Tcp/IP
    • VIA
  • Configuring Network protocols from SQL Server Manager
  • How to Change SQL Server Port No
  • Configuring other settings from sp_configure
  • Database emails and configuration

  • What is a protocol and types of protocol

  • Starting and stopping services through configure Manager
  • Net Command
  • Start Up Parameter
  • Starting SQL Server in single user mode
  • Default Parameter and Advanced Parameter

  • Login creation
  • How to assign database for logins
  • How to map logins from production to Stand by Server
  • What is a difference between server roles and database roles
  • What is schema and its explanation
  • What is orphan user
  • How to check orphan user report
  • How to fix orphan users
  • Granting object level privilege

  • Introduction to TDE
  • How to Implement TDE
  • Enable and disable TDE
  • Removing TDE

  • About SQL Server Agent
  • Creating Jobs, Alerts and Operators
  • Scheduling the Job
  • Creating Maintenance Plans
  • Working with Job Activity Monitor

  • Recover Models
  • Backup working
  • Types of Backups
    • Full, Differential, Copy Only, Mirror, Tail Log, Compressed Backups
  • What is Restoring and types of Restoring Modes
    • With Recover
    • No Recovery
    • Stand By
  • Point in Time Recovery

  • Log Shipping
  • Replication
  • Always On
  • Clustering SQL Server

  • Index Architecture
  • How to take optimal advantage of Index
  • Clustered and Non Clustered Index
  • Index Fragmentation and defragmentation
  • Rebuilding and reorganizing indexes
  • SQL Profiler
  • How to collect data from databases using pssdiag tool
  • How to Identify CPU, Memory and I/O usage
  • What is MDW and its features
  • Database Engine Tuning Advisor

  • Upgrading server by applying server packs
  • Difference between in place and side by side
  • Upgrading the server from lower to higher version
  • In place upgrade from SQL Server 2008 to 2012
  • Upgrade Advisor

  • Migration by Backup and restore method
  • Migrating logins
  • Migrating Jobs
  • Migrating SSIS Package



Be Our Channel Partner for IT Training Division

Do you want to be a part of our mission in providing Quality Training and help in “Bridging the Gap Between technology and Business”?

  • Amoeba Technologies Sales Executive will contact you and shortlist you for being our channel partner based out on our discussion and shortlisting process
  • We only promote limited partnership depending upon the credibility, location and Business demand
  • No compromise on Trainer Technical Expertise. Amoeba Technologies will provide their own Technical Consultants and Trainers

Please drop your interest and profile at Sales@amoebatechno.com

Testimonials

We sincerely perceive, consider and positively act on our customer’s feedback

Our Clients

Our focus is only you and your benefit