SQL Server Training Institute
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