Course in Microsoft SQL Server
Course
In Chennai
Description
-
Type
Course
-
Location
Chennai
Facilities
Location
Start date
Start date
Reviews
Course programme
The course ‘Designing, Implementing, and Administering Databases using SQL Server 2005' introduces the learner to the databases, explains the processes of designing and implementing databases. Further, it also explains how to manage a database server.
Contents...
Introduction to the Relational Database Management System
Define a Database Management System (DBMS)
Create an entity-relationship model
Map an entity-relationship diagram to tables
Normalize and denormalize data in tables
Querying and Managing Data Using SQL Server 2005
Appreciate SQL Server 2005
Query Data
Query Data using Joins and Sub queries
Manage Databases and Tables
Manage Data in Tables
Implement Indexes, Views, and Full-Text Search
Implement Stored Procedures and Functions
Implement Triggers and Transactions
Course in Microsoft SQL Server