SQL Server

Microsoft SQL Server is a relational database server, developed by Microsoft. It is a software product whose primary function is to store and retrieve data as requested by other software applications. Data is accessed through Structured Query Language (SQL) from SQL Server. SQL allows you to SELECT your data, INSERT new records, UPDATE or DELETE existing records. SQL can be embedded in other languages or you can run scripts of SQL directly against the database. PL/SQL is the procedural language extension to SQL. PL/SQL is a programming language like C or Java. SQL can be natively embedded in PL/SQL programs. By the end of this course, students will have learned how to write SQL queries and PL-SQL programs.

Audience

• This course is for programmers, end users, DBAs, or anybody who is interested in accessing data from SQL Server or developing applications using SQL Server.
• Students seeking to establish their career in Data ware housing or SQL/PL-SQL programming.
• Java/.NET front end programmers to enhance their skills in back end database.

Prerequisites

• Students should have some knowledge of a programming language (preferably C).