|
|
|
SQL
Server
Course Details |
|
Batch
Date: July
7th @ 4:30PM
Faculty: Mr. Narayana
Duration : 30 Day's
Fee: 800/-INR Reg Fee 100/-INR
Location
: Maitrivanam, Hyderabad.
Venue
:
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Plot No : 202,
IInd Floor ,
HUDA Maitrivanam,
Ameerpet, Hyderabad-500038.
Ph.No : 09246212143, 80 96 96 96 96, 040-64512786
Syllabus:
- Introduction To SQL Server
- Database Management System
- SQL Server Management Studio
- Server Types, Server Name And Authentication Modes
- Data And Information
- Database
- What is a database, and types of databases
- Master, Model, MSDB, TempDB and ResourseDB
- Creating user defined databases.
- Database Files, File Groups
- Database Objects
- Data Integrity
- Data Types
- System defined data types
- User defined data types
- Sub Languages Or Commands
- Data Definition Language(DDL)
- Data Manipulation Language(DML)
- Data Retrieval Language(DRL)
- Data Control Language(DCL)
- Transact Control Language(TCL)
- Clauses
- From , where, group by and having
- Distinct, top, order by, cube and roll up
- Identity Property
- Types Of Columns
- Normal columns
- Identity columns
- Computed columns
- Alias Names
- Column level alias names
- Table level alias names
- Using literals in Select Statement
- Types Of Functions
- System defined functions
- Scalar or single valued functions
- Group or aggregate functions
- User defined functions
- Constraints
- Not null constraint
- Primary key constraint
- Unique key constraint
- Default constraint
- Check constraint
- Foreign key constraint
- Candidate key, super key, alternative keys
- Levels of constraints
- Giving names for constraints
- Cascading Rules
- On DELETE set null/ set default/ cascade/ set no action
- On UPDATE set null/ set default/ cascade/ set no action
- Operators
- Assignment, arithmetic and comparison operators
- Logical, special and compound operators
- Set Operators
- Union all
- Union
- Intersect
- except
- Cloning The Tables
- When destination table is existed
- When destination table is not existed
- Joins
- Inner join
- Outer joins
- Left outer join
- Right outer join
- Full outer join
- Cross join
- Self-join
- Sub Queries
- Normal sub queries
- Single value sub queries
- Multi value sub queries
- Correlated sub queries
- Wild Card Operators
- Ranking Functions
- Row_number()
- Rank()
- Dense_rank()
- Ntile()
- Views
- Simple views
- Complex views
- Working with schema binding, encryption, check option
- Indexes
- What index and purpose of indexes
- Clustered indexes
- Non clustered indexes
- Temp Tables
- Purpose of temp tables
- Types of temp tables
- Table variable
- Merge Statement
- What is merge statement and purpose of it
- CTE(Common Table Expressions)
- What is CTE and purpose of CTE
- Derived Tables
- What is derived table and purpose of it
- Differences between normal table and derived tables
- Sequence
- Pagination
- Synonyms
- Stored Procedures
- What is a stored procedure
- Purpose of stored procedures
- Working with some system defined SPs
- User Defined Functions
- When do we go for use defined functions
- Purpose of user defined functions
- Types of user defined functions
- Cursors
- What is a cursor
- Disadvantage of cursors
- Types and attributes of cursors
- Triggers
- What is trigger and purpose of triggers
- Types of triggers and Magic tables
- Isolation levels
- Read committed
- Read uncommitted
- Repeatable read
- Serializable
- Snapshot
- Transactions and locks
- ACID Properties
- Different types of locks
|
|
|
|
|
|