SQL Training in Pune

1
Introduction To SQL

• SQL is the programming language which is used to
  access this DBMS and the database. It is the
  language in which you write the command regarding
  how and what to access in the database.
• When a user wants to get some information from a
  database file, he can issue a query.
• A query is a userrequest to retrieve data or
  information with a certain condition.
• SQL is a query language that allows user to
  specify the conditions.

Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com
2
Concept of SQL

• The user specifies a certain condition.
• The program will go through all the records in
  the database file and select those records that
  satisfy the condition.(searching). Statistical
  information of the data. The result of the query
  will then be stored in form of a table.

Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com
3
What is Data?

• data can be facts related to any object in
  consideration.
• For example your name, age, height, weight, etc
  are some data related to you.
• A picture , image , file , pdf etc. can also be
  considered data.

Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com
4
What is a Database?

1. An online telephone directory would definitely
   use database to store data pertaining to people,
   phone numbers, other contact details, etc.
2. Your electricity service provider is obviously
   using a database to manage billing , client
   related issues, to handle fault data, etc.
3. Let's also consider the Facebook. It needs to
   store, manipulate and present data related to
   members, their friends, member activities,
   messages, advertisements and lot more.
4. We can provide countless number of examples for
   usage of databases .

Classboat.com
Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com
5
Types of SQL Keys

• Super Key
• Candidate Key
• Primary Key
• Alternate key
• Composite/Compound Key
• Unique Key
• Foreign Key
  

Classboat.com
Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com
6
SQL Process

Classboat.com
Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com
7
For more Information Visitwww.classboat.com/tech
/sql-classes-pune/area-deccan

• Mobile No. 91-7767904499 E-mail -
  support_at_classboat.com www.classboat.com