Call Now  892 015 0908

SQL Server Training Institute

SQL Server

SQL Server is Microsoft's social database administration framework (RDBMS). It is a full-included database essentially intended to contend with contenders Oracle Database (DB) and MySQL.

Like all major RBDMS, SQL Server bolsters ANSI SQL, the standard SQL dialect. Notwithstanding, SQL Server likewise contains T-SQL, its own SQL implemention. SQL Server Management Studio (SSMS) (beforehand known as Enterprise Manager) is SQL Server's fundamental interface device, and it underpins 32-bit and 64-bit situations.

Introduction to Databases

  • Databases – Relational and Others
  • SQL Server vs. Other Relational Database Systems
  • The Database as Part of the System Architecture
  • The Role of the Database Administrator (DBA)

Introduction to Microsoft SQL Server

  • SQL Server Versions and Editions
  • SQL Server Services and Components
  • SQL Server Client Tools

Database Design

  • Entity-Relationship Diagram (ERD)
  • Entities, Attributes & Keys
  • Types of Relationships
  • Inheritance
  • Normalization Rules
  • Denormalization Scenarios
  • The Physical Design Process
  • Types of Tables

System Infrastructures Overview

  • Operating System Basics
  • Active Directory Fundamentals
  • Introduction to Storage
  • Introduction to Networking

Installing a SQL Server Instance 

  • Preparing to Install SQL Server
  • Upgrade Considerations
  • The Installation Process
  • Configuring the Instance

Introduction to the Transact-SQL Language

  • SQL vs. Transact-SQL
  • Types of Transact-SQL Statements
  • Transact-SQL Syntax Elements
  • System Functions and System Stored Procedures
  • Connections, Sessions, Batches and Transactions

Programming Basics

  • Working with Variables
  • Conditional Statements
  • Control of Flow Statements
  • Error Handling

The SELECT Statement

  • A Simple Query
  • Formatting the Result Set
  • Filtering the Data
  • Grouping and Sorting
  • Joining Multiple Tables

Advanced Querying

  • The CASE Clause
  • Combining Multiple Result Sets
  • Using Sub-Queries
  • Window Functions
  • Common Table Expressions

Modifying Data

  • Inserting Data
  • The UPDATE Statement
  • Deleting Data
  • The MERGE Statement

Transactions with Security

  • Transactions Overview
  • Nesting Transactions

Writing Procedural Code with Transact-SQL

  • Working with Cursors
  • Dynamic Execution

SQL Server Object Hierarch- All about Databases

  • Overview of System Databases
  • Filegroups and Files
  • Introducing the Transaction Log
  • Database Configuration Options
  • Creating a Database
  • Database Maintenance Tasks
  • Database Snapshots
  • Contained Databases
  • Schemas and Database Objects

All about Tables

  • System Tables and System Views
  • System Data Types
  • The Use of NULL
  • Creating a Table
  • Special Data Types
  • User-Defined Data Types
  • Table @Variables vs. #Temporary Tables

Indexes and Statistics

  • Introduction to Indexes
  • Creating an Index
  • Guidelines for Planning Indexes
  • Index and Statistics Maintenance

Table Constraints

  • Data Integrity Overview
  • Primary Key and Unique Constraint
  • Foreign Key
  • Check and Default Constraints
  • Creating and Disabling Constraints

Views

  • Introduction to Views
  • Modifying Data through a View
  • Partitioned Views

User  and System -Defined Functions

  • Introduction to User-Defined Functions
  • System defined Functions
  • Table-Valued Functions

Stored Procedures

  • Introduction to Stored Procedures
  • Stored Procedure Interfaces

Triggers

  • Introduction to Triggers
  • The INSERTED and DELETED Tables
  • Creating a Trigger
  • Nested and Recursive Triggers
  • Triggers Pros and Cons
  • Scenarios for Using Triggers

Backup and Recovery

  • Backup Types
  • Database Recovery Models

Implementing Replication 

  • Overview of Replication
  • Implementing Snapshot Replication
  • Implementing Transactional Replication
  • Implementing Merge Replication
  • Implementing Peer-to-Peer Replication
  • Replication Topologies

Full-Text Search 

  • Introduction to Full-Text Search
  • Full-Text Search Architecture
  • Querying Using Full-Text Search
  • Full-Text Search Administration

Transferring Data with SQL Server

  • Overview of Data Transfer
  • Using the Import and Export Wizard
  • Performing Bulk Operations
  • The Copy Database Wizard
  • Introducing SQL Server Integration Services
  • Identifying Data Changes

SQL Server Analysis Services 

  • Introducing SQL Server Analysis Services (SSAS)
  • Data Sources and Data Source Views

The Reporting Layer

  • Introducing SQL Server Reporting Services (SSRS)
  • Creating Basic Reports

Getting Ready for the Real World 

  • Organizational Structures
  • The DBA Role in the Organization
  • Interfaces with Other Roles in the Organization
  • Organization Politics
  • Review & Summary

Microsoft SQL Server Certification exams

Microsoft Certification can take you from the start of your career to its pinnacle. Certification can increase your visibility, differentiate you from your peers, and validate your knowledge and skills.

Get More Details About Microsoft SQL Server Certification Exam