contact_information

C & C++
img

SQL Server Syllabus :

INTRODUCTION TO DBMS
    • File Management System And its Drawbacks
    • Database Management system (DBMS)
      and Data models
    • Physical Data Models
    • Logical Data Models
    • Hierarchical Data Model(HDBMS)
    • network Data Model(NDBMS)
    • Relational Data Model(RDBMS)
    • Object Data Model(ODBMS)
    • Object Relational Data Model(ORDBMS)
    • Conceptual Data Models
    • Entity - Relationship(E-R) Model
INTRODUCTION TO SQL server 
    • Advantages and Drawbacks of SQL Server Compared To Oracle And DB2
    • Connecting to server
    • Server type
    • Server Name
    • Authentication modes
    • Sal server Authentication Mode
    • Windows Authentication Mode
    • Login and Password 
    • SQL Server Management Studio and Tools in Management Studio
    • object Explorer 
    • Objct Explorer Details
    • Query Editor
TSQL (Transact Structured Query Language) Introduction To TSQL
    • History and Features of TSQL
    • Types of TSQL Commands
    • Data Definition Language(DDL)
    • Data Manipulation Language(DML)
    • Data Query Language(DQL)
    • Data Control Language(DCL)
    • Transaction Control Language(TCL)
    • Database
    • Creating Database
    • Altering Database
    • Deleting Database
    • Constrains
    • Procedural Integrity Constrains
    • Declarative Integrity Contrains
    • Not null,Unique, Default and Check Constraints
    • Primary Key and Referential Integrity or Foreign Key Constraints
    • Data Types in TSQL
    • Table
    • Creating Table
    • Altering Table
    • Deleting Table
Data Manipulation Language
    • Insert 
    • Identity 
    • Creating A Table Form Another Table
    • Inserting Rows From One Table to Another
    • Update 
    • Computed Columns
    • Delete
    • Truncate
    • Differences Between Delete and Truncate
Data Query Language
    • Select 
    • Where Clause
    • Order By Clause
    • Distinct Keyword
    • Isnull() Function 
    • Colums aliases
    • Predicates
    • Between...And
    • In
    • Like
    • Is null 
Built in Functions 
    • Scalar Functions
    • Numerical Functions
    • Character Functions
    • Conversion Functions
    • Data Functions
    • Aggregate Functions
    • Convenient Aggregate Functions
    • Statistical Aggregate Functions
    • Group By and Having Clauses
    • super Aggregates 
    • Over(Partition by ...) Clause
    • Ranking Functions
    • Common Table Expression (CTE)
    • Union 
    • Insersect, Except
Joins
    • Inner Join
    • Equi Join
    • Natural Join
    • Non-Equi Join
    • Self Join 
    • Outer Join 
    • Left outer join
    • right outer join
    • Full outer join 
    • cross joi  
Sub Queries 
    • Single Row Sub Queries
    • Multi Row Sub Queries
    • Any or Some
    • All 
    • Nested sub Queries
    • Co- Related Sub Queries
    • Exists and Not Exists
Indexes
    • Clustered Index
    • NonClustered index
    • Create , Alter and Drop Indexs
    • Using Indexs
Security
     • Login Creation 
     • SQL Server Authenticated Login 
     • Windows Authenticated Login
     • User creation
     • Greating Permissions
     • Revoking Permissions
     • Roles
Views
     • Purpose of views
     • Creating, Altering And Dropping Indexes
     • Simple and complex Views
     • Encryption And Schema Binding Options in Creating views
Transaction Management
     • Introduction 
     • Begin Transaction
     • Commit Transaction
     • Rollback Transaction
     • Save Transaction
     • Role of Log File in Transaction Management
     • Implicit Transactions
TSQL programming
     • Drawbacks Of TSQL that Leads to TSQL programming
     • Introduction To TSQL programming
     • Control Statements in TSQL programming
     • Conditional Control Statements
     • if 
     • case
     • Looping Control Statements
     • While
Cursors
     • Working With Cursors
     • Types of Cursors
     • Forward_Only and Scroll Cursors
     • Static, Dynamic and Keyset Cursors
     • Local and Global Cursors
Stored sub programs
     • Advantages Of Stored Sub programs Compared to Independent SQL Statements
     • Stored Procedures
     • Creating,Altering and Dropping
     • Optional Parameters
     • Input and output Parameters
     • Permissions on Stored Procedures
     • User Defined Functions
     • Creating,Altering and Dropping
     • Types of User Defined functions
     • Scalar Functions
     • Table Valued Functions
     • Inline Table Valued Functions
     • Multi Statement Table Valued Functions
     • Permissions On User Defined Functions
     • Triggers
     • Purpose of Triggers
     • Exception Handling
     • Implementing Exception Handling
     • Adding and removing User Defined Error Messages
       TO And From SQL Server Error Messages List
     • Raising Exceptions Manual
CLR Integration
     • What is CLR Integration and The Steps For Implementing It
     • A Simple Example With CLR Integration
    Working With XML Data TYPE
    Backup and Restore Of dataBase
    Attach and  Detach of Database
    Normalization