Title: SQL Training in Pune
1Introduction 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?
- An online telephone directory would definitely
use database to store data pertaining to people,
phone numbers, other contact details, etc. - Your electricity service provider is obviously
using a database to manage billing , client
related issues, to handle fault data, etc. - 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. - 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
5Types 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
7For more Information Visitwww.classboat.com/tech
/sql-classes-pune/area-deccan
- Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com