sql

Quick sql

Course Fee – 15k

§  What is Database,Tables,Rows and Columns

§  Database Server and Management Studio

§  Create Query and Drop Query

§  Add New Column, Drop One column

§  Alter Query – Add, Drop and sp_RENAME

§  Data types in sql server

§  What is Allow Null(Not Null)

§  Simple Sql Queries

·         Select

·         Insert

·         Update

§  Primary Key, Unique Key,Candidate Key, Alternate Key

§  Identity Column

§  Relationships

§  Composite Key Foreign key and

§  Where,In ,between

§  Wild Card Operator

§  Aggregate functions 
Sum, Avg,Count, Max, Min

§  Delete and Truncate

§  Top, Order by

§  Is Null vs. collaese

§  Union and Union all

§  Joins in SQL Server

·         Inner

·         Left ,Right, Full Outer

·         Cross

·         Self

§  Group by, having

§  Sub Queries and correlated sub queries

§  Indexes 

·         Select performance

·         Insert Delete and Update Performance

·         Clustered vs. Non Clustered

§  Stored Procedure

§  Functions – Scalar valued, Inline and Multistate

§  Returns vs. Return

§  Stored procedure vs. Function

§  Exists function and sys.objects and IF

§  Select * into

§  Table Variable and Temporary tables

§  Triggers , Inserted and Deleted Tables  

§  Views

§  Views vs.StoredProedures  -Virtual Table vs stored Sq Statements that get compiled into Single Execution Plan

§  Normalization and De-normalization

§  ACID

§  SQL Transactions