Database Management System using SQL Server 2016 2 x 12 days 24 Hrs Rs. 5,000
These Courses are designed for Undergraduate Students
1 – Introduction to SQL Server (RDBMS)
Client Server Database Computing
Installation
Client Tools & Database Server
2 – Basic Data Types of SQL Server
3 – DDL Definition
Create Tables view Snapshots
Drop Table view Snapshot
Alter Table view Snapshot
4 – DML Definition
Select commands with Syntax
Insert commands with Syntax
Delete commands with Syntax
Update commands with Syntax
5 – SQL Server Basic Operators
6 – Functions
Character , Number, Date / Time
Conversion Functions
Constraints and their Types
7 – Relational Data Modeling
Queries and their Types
Triggers & their types
8 – Visual Administrative Tools
SQL Server Service Manager
Configure the Database
9 – Create Users & Role
Default system administrator and Granting Privileges
10 – SQL Server Query Analyzer
11 – SQL Server Client Network Utility
12 – Backup and Recovery Operations
13 – Import & Export tools