SQL is NOT case sensitive: select is the same as SELECT.
Most of the action you need to perform on a database are done with SQL statements.
SELECT * FROM Customers;
Semicolon after SQL Statements?
- Some database system require a semicolon at the end of each SQL statement.
- Semicolon is the standard way to separate each SQL statement in database system that allow more than one SQL statement to be executed in the same call to the server.
Some of The Most Important SQL Commands:
- SELECT – extract data from a database.
- INSERT INTO – insert new data into a database.
- DELETE – delete data from a database.
- UPDATE – update data in a database.
- CREATE DATABASE – create a new database.
- ALTER DATABASE – modify a database.
- CREATE TABLE – create a new table.
- ALTER TABLE – modify a table.
- DROP TABLE – delete a table.
- CREATE INDEX – create an index (search key).
- DROP INDEX – delete an index.
Learn how to use SQL to store, query, and manipulate data. 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.
- Lectures 41
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 0
- Certificate No
- Assessments Self