Database and Storage
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
Tags :
