MS SQL Server Database Developer

Overview
Curriculum

Training for MCSA (MICROSOFT CERTIFIED SOLUTION ASSOCIATE)

Generally, speaking databases are an organized collection of data, generally stored and accessed electronically on a computer system. There are several modeling and storage techniques for databases. Relational Database management system or RDBMS is the most prominent and dominant among them. There are several ISV (independent software vendors) that provide the frameworks in order to model and create the same.

MS SQL 2016 version of an RDBMS database framework is the latest from the Microsoft Corporation. The database developer also called database programmer is primarily responsible for creating and implementing the computer databases. The main responsibility of a database programmer is to analyze given organizations’ database needs and to produce an effective database system to meet those needs.

MODULE – 1	Introduction to RDBMS.	12 HOURS
a	Overview Of Database Management System
b	Entity-Relationship Model
c	Relational Model
d	Structured Query Language
e	Database Security Na Recovery

MODULE – 2	Introduction to MS SQL Server	8 HOURS
a	The Basic Architecture of SQL server.
b	Versions editions and installation of MS SQL Server Express edition
c	Getting started with SQL server management studio

MODULE – 3	Introduction T-SQL	24 HOURS
a	Sets, Predicate logic
b	Creating tables using DML statements
c	Writing simple select statements
d	Filtering and sorting
e	Eliminating duplicates
f	Using exists, grouping, aggregate
g	Using table aliases, writing case example
h	Subqueries
i	Union, except and intersect operators
j	Joins, Inner and outer joins