Summary of SQL

Home

SQL

SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.

Teacher: admin admin

Skill Level: Beginner

Announcements

MySQL tutorial for beginners (intro + installation)

MySQL: How to create a DATABASE

MySQL: How to create a TABLE

MySQL: How to INSERT rows into a TABLE

MySQL: How to SELECT data from a TABLE

MySQL: How to UPDATE and DELETE data from a TABLE

MySQL: AUTOCOMMIT, COMMIT, ROLLBACK

MySQL: CURRENT_DATE() & CURRENT_TIME()

MySQL: UNIQUE constraint

MySQL: NOT NULL constraint

MySQL: CHECK constraint is easy

MySQL: DEFAULT constraint is easy

MySQL: PRIMARY KEYS

MySQL: AUTO_INCREMENT

MySQL: FOREIGN KEYS

MySQL: JOINS (INNER, LEFT, RIGHT)

Functions in MySQL

MySQL logical operators

MySQL wild cards

MySQL ORDER BY clause

MySQL LIMIT clause

MySQL UNIONS

Course info

SQL

SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.

General

Announcements

MySQL tutorial for beginners (intro + installation)

MySQL tutorial for beginners (intro + installation)

MySQL: How to create a DATABASE

MySQL: How to create a DATABASE

MySQL: How to create a TABLE

MySQL: How to create a TABLE

MySQL: How to INSERT rows into a TABLE

MySQL: How to INSERT rows into a TABLE

MySQL: How to SELECT data from a TABLE

MySQL: How to SELECT data from a TABLE

MySQL: How to UPDATE and DELETE data from a TABLE

MySQL: How to UPDATE and DELETE data from a TABLE

MySQL: AUTOCOMMIT, COMMIT, ROLLBACK

MySQL: AUTOCOMMIT, COMMIT, ROLLBACK

MySQL: CURRENT_DATE() & CURRENT_TIME()

MySQL: CURRENT_DATE() &amp; CURRENT_TIME()

MySQL: UNIQUE constraint

MySQL: UNIQUE constraint

MySQL: NOT NULL constraint

MySQL: NOT NULL constraint

MySQL: CHECK constraint is easy

MySQL: CHECK constraint is easy

MySQL: DEFAULT constraint is easy

MySQL: DEFAULT constraint is easy

MySQL: PRIMARY KEYS

MySQL: PRIMARY KEYS

MySQL: AUTO_INCREMENT

MySQL: AUTO_INCREMENT

MySQL: FOREIGN KEYS

MySQL: FOREIGN KEYS

MySQL: JOINS are easy (INNER, LEFT, RIGHT)

MySQL: JOINS (INNER, LEFT, RIGHT)

Functions in MySQL

Functions in MySQL

MySQL logical operators

MySQL logical operators

MySQL wild cards

MySQL wild cards

MySQL ORDER BY clause

MySQL ORDER BY clause

MySQL LIMIT clause

MySQL LIMIT clause

MySQL UNIONS

MySQL UNIONS

SQL

SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.

MySQL: CURRENT_DATE() & CURRENT_TIME()