Database and Storage
SQL Server Training

SQL Server Training

SQL Server Training Course Duration: 2 Months

SQL Server training 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. SQL server Training by ACLM building the professionals blocks in Vaishali, Indirapuram, Kaushambi, Ghaziabad, Sahibabad, Vasundhara including Delhi NCR region.

SQL Server Training

Microsoft SQL Server Training is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications which may run either on the same computer or on another computer across a network.

Topics Covered Under SQL Server Training

Getting Started with SQL Server Training

  • Setting up SQL Server, Selecting installation options, Installing a named instance

Leveraging essential tools Using in SQL Server Training

  • 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

Handling Server and Database Security

  • Implementing server security, Comparing authentication modes, Defining logins, Creating user-defined server roles, Enforcing password policy

Granting database access

  • Contrasting users and logins, Adding users, Defining new roles, Delegating privileges with predefined roles, Repairing mismapped logins

Granting and Revoking Permissions

  • Managing database-scoped privileges, Permitting object creation, Giving blanket permissions

Defining object-level permissions

  • Limiting object access, Meeting complex permission requirements with roles

Backup and Recovery

  • Backing up databases, Selecting a recovery model, Investigating the transaction log, Running full, log and differential backups

Restoring databases

  • Performing a post-crash log backup, Rebuilding the master database, Recovering user and system databases

Streamlining Tasks with Jobs, Alerts and Database Mail

  • Configuring SQL Server Agent, Setting agent properties, Implementing database mail

Defining jobs to handle routine tasks

  • Creating alerts and operators, Initiating multi-step jobs, Associating alerts with jobs

Database Maintenance and Monitoring

  • Handling fragmentation and database corruption, Identifying and curing fragmentation, Repairing database corruption

Building database maintenance plans

  • Scheduling plan execution, Notifying operators of success or failure

Resolving contention problems

  • Identifying blocked processes, Killing blockers

Who Should Attend

  • 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

Pre-requisites

  • Basic Knowledge of Computer, Basic Knowledge of SQL Server

What You Need To Bring

  • Notepad, Laptop, Pen/Pencil

Key Takeaways

  • 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

About Trainer

  • Over 17+ years of experience in Microsoft Access
  • International Training exposure of more than 70 corporate trainings
  • Member of IFCA, AIMA
  • Contributed to several studies on financial and man-power management
  • Certifications of PMP, Six-Sigma, MS Project specialist

Leave a Reply

Your email address will not be published. Required fields are marked *

Registration open for Data Analytics & Data Science. Flexi pay options with 0% interest. Apply now.

X