TriPAL Point

Developing SQL Server

This course has been designed and delivered by experienced mentors with a high performance record. The quality of the course material is prime and delivered through real time project like scenarios.Master the art of efficiently storing, retrieving and manipulating data in the database. The course track students will be able to write SQL script and programs using TSQL and capabilities of procedures, functions, triggers and cursors.

0 STUDENTS ENROLLED
    OFFER NOTE
    Find out how you can get 100% reimbursement when you buy this course.

    It is FREE – Register Now

    Course Curriculum

    Introduction to Microsoft SQL Server
    Databases – Relational and Others
    The Database as Part of the System Architecture
    The Role of the Database Administrator (DBA)
    SQL Server Versions and Editions
    SQL Server Services and Components
    SQL Server Client Tools
    Practice
    All about Databases
    Overview of System Databases
    File groups and Files
    Introducing the Transaction Log
    Database Configuration Options
    Creating a Database
    Database Snapshots
    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
    Table Types
    Sparse Columns
    Using FILESTREAM and FileTables
    Working with Spatial Data
    DQL, DDL, DML & TCL
    DQL : SELECT Queries Group By,Order BY,Joins,Sub Queries,Co related Sub queries
    DDL :CREATE , ALTER , DROP ,TRUNCATE, RENAME
    DML : INSERT, UPDATE, DELETE, MERGE
    TCL : BEGIN TRAN, COMMIT ,ROLLBACK
    Indexes & Statistics
    Introduction to Indexes
    Physical Structures
    Special Types of Indexes
    Creating an Index
    Guidelines for Planning Indexes(DBA)
    The Database Engine Tuning Advisor(DBA)
    Introducing Statistics(DBA)
    Understanding Execution Plans(DBA)
    Guidelines for Writing Efficient Queries
    Indexes and Statistics Maintenance(DBA)
    Table Constraints
    Data Integrity Overview
    Primary Key and Unique Constraint
    Foreign Key
    Check and Default Constraints
    Creating Constraints
    Disabling Constraints
    Partitioning
    Introduction to Partitioning
    Partitioning Setup
    Operations on a Partitioned Table
    Partitioned Indexes
    Special Guidelines
    Transactions & Locks
    Transactions Overview
    Lock Types
    Concurrency Issues
    Transaction Isolation Levels
    Locking Hints
    Deadlocks
    Nesting Transactions
    Views
    Introduction to Views
    Creating a View
    Modifying Data through a View
    Indexed Views
    Partitioned Views
    User-Defined Functions
    Introduction to User-Defined Functions
    Scalar Functions
    Table-Valued Functions
    Joining with APPLY
    Stored Procedures
    Introduction to Stored Procedures
    Stored Procedure Interfaces
    Creating and Executing Stored Procedures
    Compilation Sequence
    Triggers
    Introduction to Triggers
    The INSERTED and DELETED Tables
    Creating a Trigger
    Nested and Recursive Triggers
    Triggers Pros and Cons
    Scenarios for Using Triggers
    XML
    Introduction to XML
    XPath and XQuery
    The XML System Data Type
    XML Schema Collections
    XML Indexes
    Converting Relational Data to XML
    Converting XML to Relational Data
    Summary

    Course Reviews

    No Reviews found for this course.

    TAKE THIS COURSE
    • $ 999.00
    • 2 yearsSTARTS IN
    • month

    Popular Courses

    Recent Posts

    Term : Taxonomy Mismatch: Selected Term does not exist in Taxonomy ! ..more..
    Template Design © VibeThemes. All rights reserved.