SQL-introduction

SQL stands for Structured Query Language. It is easy and allows you to create a database.

SQL-introduction

SQL-introduction

     

SQL stands for Structured Query Language. It is easy and allows you to create a database. It is an ANSI language which allows an user to write queries to access, modify and delete the customize data. SQL consist of data definition language (DDL) and data manipulation language (DML).

Data Definition Language : It is used to create, alter, drop or delete new database tables. You can also create indexes and even make a link between tables. The selected keywords which are used to perform the particular task are as under:

CREATE TABLE - creates a new table

ALTER TABLE - alters a database table

DROP TABLE - deletes a database table

CREATE INDEX - creates an index (search key)

DROP INDEX - deletes an index

Data Manipulation Language : It is used to getting, insert, delete and update data in database and tables. The selected keywords which are used to perform the particular task are as under:

SELECT - displays data from table

UPDATE - updates data in table

DELETE - deletes data from table

INSERT INTO - inserts new data into table

Tutorials

  1. SQL Alter Table Primary Key tutorial
  2. SQL Date, SQL Date Examples
  3. MySql Remove Tutorials
  4. PHP SQL Timestamp
  5. Mysql Date in where clause
  6. MySQL Alter Tutorial, Database MySQL MySQL Crash Tutorial Tutorial
  7. MySQL Examples, Learn MySQL with examples.
  8. MySQL Injection
  9. Mysql Update command
  10. Mysql Trigger After Delete
  11. Mysql Date Part Only
  12. MySQL Append Column
  13. SQL-introduction
  14. Data Normalization
  15. Create a database
  16. The INSERT INTO Statement
  17. The UPDATE Statement
  18. The DELETE Statement
  19. The SELECT statement for SQL
  20. WHERE Statement in SQL
  21. Aggregate Functions
  22. SQL Example, Codes and Tutorials
  23. SQL for Beginner
  24. SQL Introduction
  25. Create Table in Database
  26. Insert Records in Table
  27. Select data from Table in Database
  28. Update Records in Database
  29. Delete a Records in Database
  30. Where Clause in SQL
  31. Drop Table in Database
  32. SQL UNION ALL Operator
  33. SQL Right JOIN
  34. SQL BETWEEN Operator
  35. SQL AND Statement
  36. SQL Add Column Position
  37. SQL Example, Codes and Tutorials
  38. SQL % Wildcards
  39. SQL UNIQUE Constraint
  40. SQL UNION Operator