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
留言