Discussion in 'Databases' started by jesslee, Jul 21, 2014.
What we mean by sql and why we use it in databases.
SQL is a programming language designed for managing data held in a relational database management system.
SQL stands for Structured Query Language and it is used to communicate with a database.
SQL is a special-purpose programming language designed for managing data held in a relational database management system.
SQL consists of a data definition language and a data manipulation language. The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control
Structured query language is used to communicate with a database and SQL statements are used to perform tasks (such as update data or retrieve from database).
SQL refers to Structured Query Language. It is a language to communicate with the database so that data are retrieved easily.
structured Query language means SQL is the only way to communicate with the database and get back you values.
SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations. Watch this Video to learn basics of SQL.
This Video covers below topics about SQL.
0:01 What is SQL?
2:07 Creating a Table and Inserting Data
5:52 Querying The Table
8:03 Aggregating Data
11:24 Queries with AND OR
15:59 Querying IN subqueries
21:22 Restricting Grouped Results with HAVING
25:52 Calculating results with CASE
31:51 JOINing tables
37:15 Joining related tables with left outer joins
41:21 Changing Rows with UPDATE and DELETE
45:54 ALTERing tables after creation
49:51 Joining tables to themselves with self joins
53:50 Combining multiple joins
Separate names with a comma.