Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..
Batch
Date: Dec
27th @8:00AM
Faculty: Mr. Srihari (7+ Yrs of Exp,..)
Duration : 30 Days
Venue
:
DURGA SOFTWARE SOLUTIONS,
Flat No : 202,
2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038
Ph.No: +91- 9246212143, 80 96 96 96 96
Syllabus:
SQL SERVER DEVELOPMENT
1. Sqlserver Introduction
- What is Data
- What is Information
- What is a Database
- Types of Databases
- Advantages of Database
- Database Objects
2. Datatypes
- Number Datatypes
- String Datatypes
- Date Datatypes
3. Sql commands
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Control Language (DCL)
- Transaction Control Language (TCL)
- Data Query Language (DQL)
- Order of Operations
4. Operators
- Arthimetic Operators
- Relational Operators
- logical Operarors
- Special Operators
5. Functions
- Number Functions
- String Functions
- Aggregate Functions
- Date Functions
6. Constraints
- Definition
- Advantages of Constraints
- Types of Constraints
- Primary Key
- Unique
- Check
- Not Null
- Default
- Foreign key
- How to define constraints for existing table
- Cascading update and delete
7. Joins
- Types of Joins
- Inner join
- Left outer join
- Right outer join
- Full outer join
- Self join
8. Subqueries
- Definition
- Non-correlated subquery
- Ccorelated subquery
9. Views
- Definition
- Types of Views
- Advantages
- Differ with Table
10. Index
- Definition
- Clusered index
- Non-clusered index
- Execution plan
- Index scan
- Index seek
11. Rank functions
- Row_number()
- Rank()
- Dense_rank()
12. Set operators
- Union
- Union all
- Intersect
- Except
- Advantages
- Ccomparision with Joins
13. Common Table expression (CTE)
14. Temp tables
- Local temptable
- Global temptable
15. Normalization and ACID properties
16. Tsql Introduction
17. Procedures
- Definition
- Paramaters
- Advantages
18. Exception Handling
19. User Defined functions
- Scalar Function
- Table Valued Function
- Differ with Procedures
20. Triggers
- Definitions
- Types
- Advantages
21. Case Statement
22. Pivot table
23. Identity column
24. Bulk Insert
