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

COURSE NAME: SQL TRAINING
COURSE DURATION: 1 MONTH / 2 MONTHS



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

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

Institute Address :

BRILLIANT Makers

Near SBI Bank, Geeta Nagar, Rishikesh
(Uttarakhand)
249201
Follow us on: