SQL training in Chennai

1
SQL training in Chennai
HB Education and Consulting Services Private
Limited
2

• Structured Query Language An introduction
• Retrieving information from a database file needs
  to be queried. This query is generated by the
  user.
• A query is defined as a request to retrieve
  information with a criteria or condition.
• SQL is a query language and it helps users to
  follow a set of conditions and not algorithms.

3

• SQL Concepts
• The user lays down certain conditions
• The program will run across all the records in
  the database file and these records are selected
  to satisfy the condition or search.
• It provides statistical information of the data
• The query results are stored in the format of a
  table for quick retrieval.

4

• SQL is a computer language that is used for
  manipulating, storing and retrieving data
  stored in the relational database. It is the
  standard language for Relation Database
  System. The relational database management
  systems like MS Access, MySQL, Informix,
  Sybase, Oracle, SQL Server and Postgres. SQL
  training in Chennai trains in the fundamentals
  and advanced concepts.
• Some Standard Database Languages include
• DDL Data Definition Language
• DML Data Manipulation Language
• DCL Data Control Language
• DQL Data Query Language

5

• SQL Constraints are applied to the column
  include
• NOT NULL
• UNIQUE
• FOREIGN Key
• PRIMARY Key
• CHECK Constraint
• Data Integrity
• Entity Integrity In a table there are no
  duplicate rows
• Domain Integrity Enforcing valid entries for
  columns by limiting the type
• Referential Integrity Rows used by other records
  cannot be deleted
• User Defined Integrity Enforcing specific
  business rules

6

• Data types include
• Character datatypes like
• CHAR
• NCHAR
• VARCHAR2
• NVARCHAR2
• Numeric datatypes
• Number
• Binary-Float
• Binary-Double
• Data Time Datatype
• Date
• SQL is a popular language particularly while
  working with databases. It is used in business
  very often as it can modify, retrieve and
  manipulate the data table. The syntax is
  simple and straightforward.

7

• HB Education and Consulting Services Private
  Limited
• CONTACT US
• M 91-96771 67119
• T 91-44-4211 5338
• E education_at_hbservices.in
• Visit us http//www.hbservices.in