SQL for School Students

 SQL full form is (Structured Query Language) which found is everywhere in today’s digital world contain massive amounts of data being assembled every day and stored into a database.

 

-:SQL contains following topics at TCCI:-

 

Ø  Basics of SQL Queries

Ø  Advanced SQL Queries

Ø  Relational Queries

Ø  Modifying Database

 

Basics of SQL

 

Ø  SQL is stands for Structured Query Language.

Ø  SQL is used to access and manipulate databases.

Ø  SQL is used to execute queries against a database.

Ø  SQL is used to retrieve data from a database.

Ø  SQL is used to insert records in a database.

Ø  SQL is used to update records in a database.

Ø  SQL is used to delete records from a database.

Ø  SQL is used to create new databases.

Ø  SQL is used to create new tables in a database.

Ø  SQL is used to create stored procedures in a database

Ø  SQL is used to create views in a database.

Ø  SQL is used to set permissions on tables, procedures, and views.

Database Tables

 

A database contains one, two or more tables. Each table is recognized by a name (e.g. "Employee"). Each table contain different records (rows) with data.

 

Below is a common format of the "Employee" table:

 

Id	Name	DA	TA	HRA	Sal
101	Ram	100	50	50	200
102	Sam	200	50	50	300
103	Man	300	50	50	400
104	Rony	400	50	50	500
105	Tom	500	50	50	600

 

The above table contains five records (one for each employee) and six columns (Id, Name, DA,TA, HRA, Sal).

 

TCCI provides best teaching in different SQL terminology through different learning method/media as per students convince.

 

For More Information:                                          

Call us @ 9825618292

Visit us @ http://tccicomputercoaching.com