RISHIKESH NO. 1 - IT Education Training Institute - Reasonable Fee, Learn Unlimited

Get Enrolled in National Tally Championship 2019 and get benefits of scholarship upto 50% on Tally Xpert Course ::: New Admissions are Open for Tally Xpert , Interior Designing , Web Designing , Graphic Designing , DCA, ADCA, DIT, CTTC etc.   ::: Vacancies available in companies in the field of Tally / GST / AutoCAD / Interior Design / Graphic Design / Front Desk / Web Design :: please contact +91-9760004085


SQL Training Course Details

Module 1

Introduction To DBMS, File Management System And Its Drawbacks, Database Management System (DBMS) and Data Models, Physical Data Models, Logical Data Models, Hierarchical Data Model (HDBMS), Network Data Model (NDBMS), Relational Data Model (RDBMS)

Module 2

Introduction To SQL Server, Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2, Connecting To Server, Server Type, Server Name, Authentication Modes, Sql Server Authentication Mode, Windows Authentication Mode, Login and Password, Sql Server Management Studio and Tools In Management Studio, Object Explorer, Object Explorer Details, Query Editor

Module 3

History and Features of TSQL, Types Of TSQL Commands, Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), Data Control Language (DCL), Transaction Control Language (TCL), Database, Creating Database, Altering Database, Deleting Database, Constrains, Procedural Integrity Constraints, Declarative Integrity Constraints, Not Null, Unique, Default and Check constraints, Primary Key and Referential Integrity or foreign key constraints, Data Types In TSQL, Table, Creating Table, Altering Table, Deleting Table

Module 4

Data Manipulation Language, Insert, Identity, Creating A Table From Another Table, Inserting Rows From One Table To Another, Update, Computed Columns, Delete, Truncate, Differences Between Delete and Truncate

Module 5

Data Query Language (DQL), Select, Where clause, Order By Clause, Distinct Keyword, Isnull() function, Column aliases, Predicates, Between … And, In, Like, Is Null

Module 6

Set Operators, Union, Intersect, Except, Joins, Inner Join, Equi Join, Natural Join, Non-Equi Join, Self Join, Outer Join, Left Outer Join, Right Outer Join, Full Outer Join, Cross Join

Module 7

Sub Queries, Single Row Sub Queries, Multi Row Sub Queries, Any or Some, ALL, Nested Sub Queries, Co-Related Sub Queries, Exists and Not Exists

Module 8

Indexes, Clustered Index, NonClustered Index, Create , Alter and Drop Indexes, Using Indexes, Views, Purpose Of Views, Creating , Altering and Dropping Indexes, Simple and Complex Views, Encryption and Schema Binding Options in creating views

Live Projects & Assignments

We helps students to develop dynamic projects.

Job Opportunities

- Data Analysist
- Database Administrator
- Data Security Advisor
- Database Engineer

Call us now at 9897614085 for professional training

100% Job Assured Courses
Brilliant Makers offers job placement assistance to students &
recruitment assistance to companies looking to hire trained IT professionals.

BRILLIANT Makers - A Centre for IT Education ,Spoken English & CAD
Geeta Nagar, Near SBI Bank,
Haridwar Road ,
Rishikesh (Uttarakhand), INDIA

Mobile: +91-9897614085, 9760004085
Email: brilliantmakers@rediffmail.com

Call Us Between 7AM To 7PM
+91-989 761 4085
Email: brilliantmakers@rediffmail.com

Institute Address :


Near SBI Bank, Geeta Nagar, Rishikesh
Follow us on: