Microsoft Sql Server Development Online Training
Details
- Introduction to SQL Server
- SQL Server Databases
- Types of Databases
- System Databases
- User Databases
- User Databases
- Creating Databases using Object Explorer
- Creating Databases using Query Editor
- Types of Databases
- DDL, DQL, DML, TCL, DCL Commands
- Data Integrities
- Types of Integrities
- Pre defined integrities
- Entity Integrities
- Domain Integrities
- Referential Integrities
- User defined integrities
- Types of Integrities
- Operators in SQL Server
- Arithmetic operators
- Logical operators
- Comparison operators
- Range operators
- List operators
- Null operator
- String operators
- Modified comparison operators
- Functions in SQL Server
- Types of Functions
- Library Functions
- User defined Functions
- Types of Functions
- JOINS
- Types in Joins
- Inner join
- Equi join
- Non Equi join
- Outer join
- Left Outer join
- Right Outer join
- Full Outer join
- Cross / Cartesian join
- Self join and Natural joins
- Inner join
- VIEWS
- Types of Views
- Creating Views
- Altering Views
- Dropping Views
- SUB QUERIES
- Nested Sub queries
- Co-related sub queries
- Transactions and Locks
- Types of Transactions
- Implicit Transactions
- Explicit Transactions
- Types of Locks
- Shared lock
- Exclusive lock
- Update lock
- Types of Transactions
- Types in Joins
- STORED PROCEDURES
- Types of Stored procedures
- System Stored Procedures
- User Stored Procedures
- Creating Stored Procedures
- Altering Stored Procedures
- Dropping Stored Procedures
- Types of Stored procedures
- TRIGGERS
- Types of Triggers
- DML Triggers
- DDL Triggers
- Creating Triggers
- Altering Triggers
- Dropping Triggers
- CURSORS
- Types of Cursors
- Defining Cursors
- Fetching rows from Cursor
- Close Cursor
- Deallocate cursor
- Types of Cursors
- INDEXES
- Types of indexes
- Clustered indexes
- Nonclustered indexes
- Creating indexes
- Dropping Indexes
- Types of indexes
- User Defined Functions (UDF)
- Types of User Defined Functions
- Scalar Valued Functions
- Inline Functions
- Table Valued Functions
- Types of User Defined Functions
- Types of Triggers
SV Soft Solutions is a premier IT Training and Placement Institute. We attempt best quality courses in areas of PeopleSoft, SAP, Oracle, Android, Microsoft, Servicenow, Datawarehousing, Hadoop, Amazon Web services and Tibco. Our online training institute is the best place for you to brush up your technical leading and build a good career ahead in IT related technologies. Our main assets are our Trainers who have minimum 8 years of experience in IT. Our training takes place with well prepared training materials. We provide excellent documentation and preparation materials for learners.
Online Learning Course Benefits
- Industry Expert Trainer
- Real time Scenario
- Doubt session Support
- Topic to Topic Assignments
- Resume Preparation
- Interview Q/A
- Record Sessions
- Detailed Study Material
- 24/7 Support
Data warehousing :
1)Informatica Online Training
2)Cognos Online Training
3)MicroStrategy Online Training
4)Qlikview Online Training
5)MSBI Online Training
6)Teradata Online Training
SAP Modules :
1)SAP HANA Online Training
2)SAP ABAP Online Training
3)SAP BASIS Online Training
4)SAP BO Online Training
5)SAP BODS Online Training
6)SAP BW Online Training ...