Register Now For Free Home Counseling
Register Now For Free Home Counseling

IIHT- Kharghar
7666442227 / 09321 551 234




Online Test


Take Test Now
IIHT Courses


View Courses
Batch Schedule


View Your Batch


Asia's top IT training organization

IIHT, established in the year 1993 is a leading IT training provider of Asia. We specialize in providing training services on hardware, networking, database management, CCNA, CCNP, Microsoft Certifications, MCSA, Red Hat Linux, Virtualization, security, Software Courses, DotNet, Java, Web Development, Cloud Computing (IAAS, SAAS) and many Career Courses like B.Sc-IMS, which will lead you to IT industry. We have catered our training services to some of the renowned Fortune 500 companies.



Partner



Testimonials
Blog

How is soft skill important for an IT Professional?

Soft skills play an important role in professional career. Developing them will not only improve your potential in technical areas but also in IT field. These soft skills are the combination of communication skills, attitude, career attribu  more


More Blog


Why IIHT Kharghar ?
  • Globally recognized certified courses.
  • Training provided by Globally certified industry experts.
  • 100% Placement Assistance helping them find the right job.
  • We have 24/7 labs with latest infrastructure.

IIHTIIHT- Kharghar

(022) 49179245



Register Now For Free Home Counseling

Database Management

Contents:

  • Introduction to RDBMS
  • Introduction to Database Systems
  • File – Based Systems
  • Database Management Systems
  • DBMS Architecture
  • DBMS Architecture
  • Functions of DBMS
  • Database System Structure
  • Types of Databases
  • Hierarchical Databases
  • Network Databases
  • Relational Databases
  • Object Oriented Databases
  • Introduction to Data Modeling
  • Database Design Process
  • Entity – Relationship Model (E –R Model)
  • Mapping Cardinalities
  • E-R Model
  • Relational Data Model
  • Converting ER Diagram to Relational Database Design
  • Normalization
  • Description of Normalization
  • Role of Normalization
  • Boyce-Codd Normal Form (BCNF)
  • Introduction to SQL
  • What is SQL?
  • SQL Process
  • SQL – Data Types
  • Database Query Languages
  • SQL – Commands
  • SQL – Operators
    SQL – Expressions

  • Functions
  • Relational Database Systems – An Introduction
  • Planning the Installation and Installing SQL Server
  • Foundations of T-SQL
  • T-SQL 2008 New Features
  • Tools of the Trade
  • Procedural Code and CASE Expressions
  • User-Defined Functions
  • Stored Procedures
  • Triggers
  • Common Table Expressions and Windowing Functions
  • XML
  • XQuery and XPath
  • Catalog Views and Dynamic Management Views
  • SQL CLR Programming
  • .NET Client Programming
  • ADO.NET
  • The .NET SQL Client
  • Connected Data Access
  • Disconnected Datasets
  • Parameterized Queries
  • Nonquery, Scalar, and XML Querying
  • Data Services
  • Introducing HTTP Endpoints
  • Consuming HTTP Endpoints
  • Web Services
  • ADO.NET Data Services
  • Creating an ADO.NET Data Service
  • Creating an ADO.NET Data Service Consumer
  • New T-SQL Features
  • Enabling FILESTREAM Support
  • Error Handling and Dynamic SQL
  • Legacy Error Handling
  • SSMS Integrated Debugger
  • Client-Side Parameterization
  • Performance Tuning
  • SQL Server Storage
  • Files and Filegroups
  • Space Allocation

 

Duration: 48 Hours

Certification: MCSA: SQL Server certification Paper numbers: 461, 462, 463

Register to Enroll for this Course

Contact Us

Your Name

Your Email

Phone

Message

Captcha : captcha

Get in Touch
7666442227 /
09321 551 234
Why IIHT kharghar ?
  • Globally recognized certified courses.
  • Training provided by Globally certified industry experts.
  • 100% Placement Assistance helping them find the right job.
  • We have 24/7 labs with latest infrastructure.
  • Our accredited courses include extensive exercises, quizzes, practice tests, moderated forums and blogs for comprehensive learning.
  • Take reference from the students.
  • Contact info@iiht-kharghar.com for details.
Awards

Database Management

Contents:

  • Introduction to RDBMS
  • Introduction to Database Systems
  • File – Based Systems
  • Database Management Systems
  • DBMS Architecture
  • DBMS Architecture
  • Functions of DBMS
  • Database System Structure
  • Types of Databases
  • Hierarchical Databases
  • Network Databases
  • Relational Databases
  • Object Oriented Databases
  • Introduction to Data Modeling
  • Database Design Process
  • Entity – Relationship Model (E –R Model)
  • Mapping Cardinalities
  • E-R Model
  • Relational Data Model
  • Converting ER Diagram to Relational Database Design
  • Normalization
  • Description of Normalization
  • Role of Normalization
  • Boyce-Codd Normal Form (BCNF)
  • Introduction to SQL
  • What is SQL?
  • SQL Process
  • SQL – Data Types
  • Database Query Languages
  • SQL – Commands
  • SQL – Operators
    SQL – Expressions

  • Functions
  • Relational Database Systems – An Introduction
  • Planning the Installation and Installing SQL Server
  • Foundations of T-SQL
  • T-SQL 2008 New Features
  • Tools of the Trade
  • Procedural Code and CASE Expressions
  • User-Defined Functions
  • Stored Procedures
  • Triggers
  • Common Table Expressions and Windowing Functions
  • XML
  • XQuery and XPath
  • Catalog Views and Dynamic Management Views
  • SQL CLR Programming
  • .NET Client Programming
  • ADO.NET
  • The .NET SQL Client
  • Connected Data Access
  • Disconnected Datasets
  • Parameterized Queries
  • Nonquery, Scalar, and XML Querying
  • Data Services
  • Introducing HTTP Endpoints
  • Consuming HTTP Endpoints
  • Web Services
  • ADO.NET Data Services
  • Creating an ADO.NET Data Service
  • Creating an ADO.NET Data Service Consumer
  • New T-SQL Features
  • Enabling FILESTREAM Support
  • Error Handling and Dynamic SQL
  • Legacy Error Handling
  • SSMS Integrated Debugger
  • Client-Side Parameterization
  • Performance Tuning
  • SQL Server Storage
  • Files and Filegroups
  • Space Allocation

 

Duration: 48 Hours

Certification: MCSA: SQL Server certification Paper numbers: 461, 462, 463

Register to Enroll for this Course

Contact Us

Your Name

Your Email

Phone

Message

Captcha : captcha

Get in Touch
7666442227 /
09321 551 234
Why IIHT kharghar ?
  • Globally recognized certified courses.
  • Training provided by Globally certified industry experts.
  • 100% Placement Assistance helping them find the right job.
  • We have 24/7 labs with latest infrastructure.
  • Our accredited courses include extensive exercises, quizzes, practice tests, moderated forums and blogs for comprehensive learning.
  • Take reference from the students.
  • Contact info@iiht-kharghar.com for details.
Awards

Database Management

Contents:

  • Introduction to RDBMS
  • Introduction to Database Systems
  • File – Based Systems
  • Database Management Systems
  • DBMS Architecture
  • DBMS Architecture
  • Functions of DBMS
  • Database System Structure
  • Types of Databases
  • Hierarchical Databases
  • Network Databases
  • Relational Databases
  • Object Oriented Databases
  • Introduction to Data Modeling
  • Database Design Process
  • Entity – Relationship Model (E –R Model)
  • Mapping Cardinalities
  • E-R Model
  • Relational Data Model
  • Converting ER Diagram to Relational Database Design
  • Normalization
  • Description of Normalization
  • Role of Normalization
  • Boyce-Codd Normal Form (BCNF)
  • Introduction to SQL
  • What is SQL?
  • SQL Process
  • SQL – Data Types
  • Database Query Languages
  • SQL – Commands
  • SQL – Operators
    SQL – Expressions

  • Functions
  • Relational Database Systems – An Introduction
  • Planning the Installation and Installing SQL Server
  • Foundations of T-SQL
  • T-SQL 2008 New Features
  • Tools of the Trade
  • Procedural Code and CASE Expressions
  • User-Defined Functions
  • Stored Procedures
  • Triggers
  • Common Table Expressions and Windowing Functions
  • XML
  • XQuery and XPath
  • Catalog Views and Dynamic Management Views
  • SQL CLR Programming
  • .NET Client Programming
  • ADO.NET
  • The .NET SQL Client
  • Connected Data Access
  • Disconnected Datasets
  • Parameterized Queries
  • Nonquery, Scalar, and XML Querying
  • Data Services
  • Introducing HTTP Endpoints
  • Consuming HTTP Endpoints
  • Web Services
  • ADO.NET Data Services
  • Creating an ADO.NET Data Service
  • Creating an ADO.NET Data Service Consumer
  • New T-SQL Features
  • Enabling FILESTREAM Support
  • Error Handling and Dynamic SQL
  • Legacy Error Handling
  • SSMS Integrated Debugger
  • Client-Side Parameterization
  • Performance Tuning
  • SQL Server Storage
  • Files and Filegroups
  • Space Allocation

 

Duration: 48 Hours

Certification: MCSA: SQL Server certification Paper numbers: 461, 462, 463

Register to Enroll for this Course

Contact Us

Your Name

Your Email

Phone

Message

Captcha : captcha

Get in Touch
7666442227 /
09321 551 234
Why IIHT kharghar ?
  • Globally recognized certified courses.
  • Training provided by Globally certified industry experts.
  • 100% Placement Assistance helping them find the right job.
  • We have 24/7 labs with latest infrastructure.
  • Our accredited courses include extensive exercises, quizzes, practice tests, moderated forums and blogs for comprehensive learning.
  • Take reference from the students.
  • Contact info@iiht-kharghar.com for details.
Awards
Mobile Version Mobile Development
Mobile Version Mobile Development

© 2015 @ IIHT Kharghar   Website Development : On Target Marketing Solutions Pvt. Ltd.