• logo
  • 9861600203
  • 5555545
  • info@mentorit.com.np
header-logo.png

Overview

SQL Server is an application software for Relational Database Management System (RDBMS), from Microsoft, that can be used for creating, maintaining, managing, and implementing the RDBMS systems. It is an extensively used application as it enables multiple users simultaneously to work on the database systems, where users can range from minor office-based machines to huge Internet-based servers. Provisions any variety of SQL programming extending from ANSI SQL (for traditional SQL) through SQL to T-SQL (Transact-SQL) used for advanced relational databases.

It is the relational database management system developed by Microsoft back in 1988. It is actually a backend application that allows us to store and process data. In simple terms, it offers us a platform where we can update, change, and manage the data. It is called the relational database management system due to its nature to store the data in tables where the tables store the data about the same entity.

There are several plus points of using SQL server over other means of data storage.

  • Data processing: It allows us to process the data stores in order to generate the desired output. The data could be computed using SQL server.
  • High storage: We can store a large number of data in the SQL server. Due to its high storage capacity, it is considered best while data storing in organizations.
  • Integration with front-end: It could also be integrated with the frontend application to offer the mechanism of dynamically data change. It is very frequently used in integration with web applications.
  • Easy to connect with.Net: As SQL server and.Net framework both belong to Microsoft, both are very easy to be connected. It works very fine or smooth when merged with an application developed on .Net.

Course Content

  • SQL server editions
  • SQL Server Metadata
  • Components of the SQL Server Engine
  • The SQLOS
  • The Scheduler
  • Memory
  • SQL Server Resource Governor
  • SQL Server 2008 Configuration
  • SQL Server System Configuration
  • SQL Server Configuration Settings
  • The Basics: Triggers and Event Notifications
  • Change Tracking
  • Tracing and Profiling
  • Extended Events
  • System Databases
  • Sample Databases
  • Database Files
  • Creating a Database
  • Expanding or Shrinking a Database
  • Using Database Filegroups
  • Altering a Database
  • Databases Under the Hood
  • Setting Database Options
  • Database Snapshots
  • The tempdb Database
  • Database Security
  • Moving or Copying a Database
  • Compatibility Levels
  • Transaction Log Basics
  • Changes in Log Size
  • Backing Up and Restoring a Database
  • Creating Tables
  • User-Defined Data Types
  • IDENTITY Property
  • Internal Storage
  • Constraints
  • Altering a Table
  • Heap Modification Internals
  • Overview
  • Tools for Analyzing Indexes
  • Understanding Index Structures
  • Index Creation Options
  • Physical Index Structures
  • Special Index Structures
  • Data Modification Internals
  • Managing Index Structures
  • Large Object Storage
  • Filestream Data
  • Sparse Columns
  • Data Compression
  • Table and Index Partitioning
  • Overview
  • What Is Optimization?
  • How the Query Optimizer Explores Query Plans
  • Optimizer Architecture
  • Statistics, Cardinality Estimation, and Costing
  • Index Selection
  • Partitioned Tables
  • Data Warehousing
  • Updates
  • Distributed Query
  • Extended Indexes
  • Plan Hinting
  • The Plan Cache
  • Caching Mechanisms
  • Plan Cache Internals
  • Objects in Plan Cache: The Big Picture
  • Multiple Plans in Cache
  • When to Use Stored Procedures and Other Caching Mechanisms
  • Troubleshooting Plan Cache Issues
  • Concurrency Models
  • Transaction Processing
  • Locking
  • Lock Compatibility
  • Internal Locking Architecture
  • Row-Level Locking vs. Page-Level Locking
  • Row Versioning
  • Controlling Locking
  • Getting a Consistent View of the Database
  • Processing the Database Effi ciently
  • Primitive System Catalog Consistency Checks
  • Allocation Consistency Checks
  • Per-Table Logical Consistency Checks
  • Cross-Table Consistency Checks
  • DBCC CHECKDB Output
  • DBCC CHECKDB Options
  • Database Repair
  • Consistency-Checking Commands Other Than
  • DBCC CHECKDB

About the instructor

DIPU MAHARJAN

BI Solution Architect

Hi I am Dipu Maharjan. I am working as BI Solution Architect. I have experience more than 10 years as Data Analyst, Database Programmer, Developer and Trainer.

No reviews for this course


Write a Message

Security Check
2 + 2 =

    Course Features