Sql Server 2012

Duration : 30 Hrs

SQL Server is a RDBMS developed by Microsoft. We give online training on Sql Server Admin.It  is a software product whose main function is to store and recover data as asked  by other software applications, be it those on the same computer or those running on different  computer across a network There are at least a dozen  editions of Microsoft SQL Server designed for  different audiences and for different applications (ranging from small applications that store and extract data on the same computer, to millions of  computers that access huge amounts of data from the Internet at the same time). Its chief query languages are T-SQL and ANSI SQL.

DB CONCEPTS
  • What is data
  • Difference between data & information
  • What is database
  • What is DBMS
  • Advantages of DBMS
  • RDBMS Tools
  • Normalization (1NF,2NF,3NF)
INTRODUCTION TO SQL SERVER 2012
  • Introduction To SQL Server 2008
  • SQL Server Management Studio
  • Editions
DDL AND DML
  • Create Table
  • Using New Date and Time Data Types
  • Alter Table
  • Drop Table
  • Insert
  • Insert trough select
  • Update
  • Delete
SELECTING DATA FROM COLUMNS
  • All columns
  • Some columns
  • Derived columns
  • Using DISTINCT
  • Naming result columns
  • WHERE and comparison operators
  • Nulls
SELECTING USING OPERATORS
  • Arithmetic Operators
  • Relational Operators
  • Logical Operators
  • Other Operators
SELECTING USING FUNCTIONS
  • Number Functions
  • Character Functions
  • Date and Time Functions
  • Aggregate Functions
  • Other Functions
ORDER BY
  • ASC
  • DESC
  • Multiple columns
  • Expressions
  • Columns not in SELECT list
GROUP BY
  • Single column
  • Multiple columns
  • HAVING considerations
  • With ORDER BY
JOINS
  • INNER
  • OUTER (LEFT, RIGHT & FULL)
  • ON vs. WHERE
  • Cartesian product
T-SQL PROGRAMMING
  • Variable Declarations
  • Programming Constructs
  • Conditional statements
  • If-else
  • Case
  • While
  • Break
  • Continue
IMPLEMENTING DATA INTEGRITY BY USING CONSTRAINTS
  • Data Integrity Overview
  • Creating Constraints
  • Implementing Constraints
  • Not Null
  • Unique Key
  • Primary key
  • Check Constraints
  • Default
  • Foreign Key
  • Disabling Constraints
 TRANSACTION MANAGEMENT
  • What is Transaction
  • Commit
  • Savepoint
  • Rollback
INDEXES
  • Requirement of index
  • Advantages of index
  • Create index
  • Optimizing Indexes
  • Tuning Indexes
  • Drop index
DATA CONTROL LANGUAGE
  • Creating Logins
  • Creating Users
  • Grant
  • Revoke
  • Deny
IMPLEMENTING VIEWS
  • Introduction to Views
  • Creating and Managing Views
  • Optimizing Performance by Using Views
  • Creating Indexed Views
  • Creating Partitioned Views
CURSORS
  • What is Cursor
  • Cursor Life Cycle
  • Implementation of Cursor
IMPLEMENTING STORED PROCEDURES
  • What is Stored Procedure
  • Creating Stored Procedures
  • Executing Stored Procedures
  • Creating Parameterized Stored Procedures
  • Handle errors in a stored procedure
IMPLEMENTING FUNCTIONS
  • Creating Functions.
  • Implement Scalar Functions
  • Create Table Valued Functions
 IMPLEMENTING TRIGGERS
  • INSERT triggers
  • DELETE triggers
  • UPDATE triggers

Reviews

No reviews

Post Review

Name
Email
Review Title
Rating
Review Content
View All Categories

Quick Enquiry

captcha

Technology Portfolio

Loading...