Course Details

The learning programme of Microsoft SQL Server is offered to students by our institute. The topics which are included in this course curriculum are:

• Querying with Unions and Advanced Joins
• Querying Multiple Tables with Unions
• Advanced Joins
• Calculating with Compute
• Querying with Sub queries
• Sub queries
• Adding Data
• Inserting Data and Select Into
• Updating and Removing Data
• Updating Records
• Deleting Records and Deleting the Contents of Tables
• Manipulating Tables and Views
• Creating Tables
• Modifying Tables
• Deleting Tables
• Adding and Removing Views
• Manipulating Indexes
• Adding and Removing Indexes
• Ensuring Data Integrity with Transactions
• Transactions
• Creating Databases
• Creating a Database with SQL
• Deleting a Database
• Data Base Indexes - Locating something easily in the database
• Stored Procedure Units
• Procedure
• Functions
• Library
• Package
• Database Triggers
• Working with Cursors
• Overloading