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 user–request 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@classboat.com | www.classboat.com
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@classboat.com | www.classboat.com
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@classboat.com | www.classboat.com
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@classboat.com | www.classboat.com
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@classboat.com | www.classboat.com
SQL Process
Classboat.com Mobile No. +91-7767904499 | E-mail :- support@classboat.com | www.classboat.com
For more Information Visit www.classboat.com/tech/sql-classes-pune/area-deccan Mobile No. +91-7767904499 | E-mail :- support@classboat.com | www.classboat.com