SQL stands for Structured Query Language and pronounced as 'Sequel' which is used against RDBMS to manage data. SQL is a computer language for accessing databases.Database is accessed using SQL statement, which is an ANSI (American National Standards Institute) standard”.
SQL is used to create and query databases i.e. creating, storing, accessing and manipulating the data. Due to its loose structure and flexibility, SQL is considered as a handy tool for building dynamic web applications.
Features of SQL :-
1. SQL stands for Structured Query Language and is used to communicate with databases.
2. SQL is NOT case sensitive i.e. SELECT is the same as select.
3. SQL is efficient, easy to use and learn.
4. SQL is used to create new databases.
5. SQL is used to create new tables in a database.
6. SQL is used to create views, stored procedures and functions in a database.
7. SQL is used to drop tables and databases.
8. SQL is used to execute queries and retrieve data from a database.
9. SQL is used to insert, delete and update records in a database.
10. SQL is used to set permissions on tables, procedures, and views.
SQL (pronounced "ess-que-el" (sequel)) stands for Structured Query Language.
SQL is used to communicate with a database.
SQL is a standard language for accessing and manipulating databases.
Database is accessed using SQL statement, which is an ANSI (American National Standards Institute) standard”. SQL is used to create and query databases i.e. creating, storing, accessing and manipulating the data.
SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment.
SQL is an ANSI (American National Standards Institute) standard. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.
Keep in Mind That...
Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.
SQL is used to create and query databases i.e. creating, storing, accessing and manipulating the data. Due to its loose structure and flexibility, SQL is considered as a handy tool for building dynamic web applications.
Features of SQL :-
1. SQL stands for Structured Query Language and is used to communicate with databases.
2. SQL is NOT case sensitive i.e. SELECT is the same as select.
3. SQL is efficient, easy to use and learn.
4. SQL is used to create new databases.
5. SQL is used to create new tables in a database.
6. SQL is used to create views, stored procedures and functions in a database.
7. SQL is used to drop tables and databases.
8. SQL is used to execute queries and retrieve data from a database.
9. SQL is used to insert, delete and update records in a database.
10. SQL is used to set permissions on tables, procedures, and views.
SQL (pronounced "ess-que-el" (sequel)) stands for Structured Query Language.
SQL is used to communicate with a database.
SQL is a standard language for accessing and manipulating databases.
Database is accessed using SQL statement, which is an ANSI (American National Standards Institute) standard”. SQL is used to create and query databases i.e. creating, storing, accessing and manipulating the data.
SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment.
SQL is an ANSI (American National Standards Institute) standard. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.
Keep in Mind That...
SQL is NOT case sensitive: select is the same as SELECT
Semicolon after SQL Statements?
Some database systems require a semicolon at the end of each SQL statement.
Semicolon after SQL Statements?
Some database systems require a semicolon at the end of each SQL statement.
What is NULL value?
A NULL value in a table is a value in a field that appears to be blank, which means a field with a NULL value is a field with no value.
It is very important to understand that a NULL value is different than a zero value or a field that contains spaces. A field with a NULL value is one that has been left blank during record creation.
