SQL Server 2012 Developer

Duration : 30 Hrs

Microsoft SQL Server is a relational database management system developed by Microsoft. We give Sql Server Admin Online Training. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for different workloads (ranging from small applications that store and retrieve data on the same computer, to millions of users and computers that access huge amounts of data from the Internet at the same time). Its primary 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

Technology Portfolio