SQL Server Online Course in Canada

-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

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

Curriculum Of SQL Server

  INTRODUCTION TO DBMS

• File Management System & Its Drawbacks
•  What are Relalational
• Physical Data Models
• Logical Data Models
• Hierarchical Data Model (HDBMS)
• Network Data Model (NDBMS)
• Relational Data Model (RDBMS)
• Object Data Model (ODBMS)
• Normalization
• Entity-Relationship (E-R) Model

INTRODUCTION TO SQL
SERVER

• Introduction to Management Studio
• Authentication Modes.
• Types of System Databases in SQL.
• Database Language.
• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Query Language (DQL)
• Data Control Language (DCL)
• Transaction Control Language (TCL)
• Datatypes in SQL Server.

DATA QUERY LANGUAGE (DQL)

• Select
• Where
• Order by
• Distinct
• Like
• In
• Between

CONSTRAINTS IN SQL

• Not Null
• Unique
• Default
• Check
• Primary Key, Foreign Key.

BUILT IN FUNCTIONS

• Numeric Functions
• Character Functions
• Conversion Functions
• Data Functions
• Aggregate Functions
• Ranking Functions

JOINS

• Inner Join
• Outer Join – Left Right,Full
• Self join
• Natural join
• Cross join

STORED PROCEDURES

• Introduction to Stored Procedure
• Advantages of Stored Procedure
• With Parameter
• Without Parameter
• Input-Output and Optional Parameters

SET OPERATORS

• Union
• Union All
• Intersect
• Except

VIEWS

• Introduction to View
• Advantage of view
• Creating, altering and dropping view

FUNCTIONS

• Introduction to Function
• Types of Function
• Creating Scalar Functions
• Creating Table Valued Functions

TRIGGER

• Introduction to Trigger
• Types of Triggers
• Creating, altering and dropping trigger
• For/after/instead of trigger

INDEXES

• Introduction to Indexes
• Types of Indexes
• Creating, altering and dropping Indexes

TRANSACTION MANAGEMENT

• Introduction
• Begin Transaction
• Commit Transaction
• Rollback Transaction
• Save Point
• Working with Multiple Transaction

DATA CONTROL LANGUAGE

• Creating Users & Roles
• Granting & Revoking of Roles & privileges

CURSORS

• Introduction to Cursor
• Working with cursor
• Types of cursors, Creating a cursor
• Advantages of cursor

BACKUP AND RESTORE

• Generating SQL Script
• Executing SQL Script
• Generating Change Script
• Taking database Backup
• Restoring database using backup

ADVANCE FEATURES

• CTE
• Using XML Data type
• IF-Else
• Loop
• SQL Case Expression

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