-
SQL Installing SSMS
-
SQL Syntax
-
SQL Datatype
-
SQL Database
-
SQL Table
-
SQL Select
-
SQL Distinct
-
SQL Count
-
SQL Top
-
SQL Aliases
-
SQL In
-
SQL Insert
-
SQL Update
-
SQL Null
-
SQL Like
-
SQL Wildcards
-
SQL Nested Query
-
SQL Between
-
SQL Unique
-
SQL Primary Key
-
SQL Foreign Key
-
SQL Check
-
SQL Default
-
SQL Database Diagram
-
SQL Stored Procedures
-
SQL Joins
-
SQL Inner Join
-
SQL Left Join
-
SQL Right Join
-
SQL Full Join
-
SQL Trigger
SQL Syntax
SQL follows a unique set of rules and guidelines called syntax. Here, we are providing all the basic SQL syntax.
– SQL is not case-sensitive. Generally, SQL keywords are written in uppercase.
– SQL statements are dependent on text lines. We can place a single SQL statement on one or multiple text lines.
– You can perform most of the action in a database with SQL statements.
– SQL depends on relational algebra and tuple relational calculus.
SQL statement
SQL statements are started with any of the SQL commands/keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, etc. and the statement ends with a semicolon (;).
Example of SQL statement:
SELECT “column_name” FROM “table_name”;
These are important SQL commands:
– INSERT INTO: it inserts new data into a database.
– SELECT: it extracts data from a database.
– UPDATE: it updates data in the database.
– DELETE: it deletes data from the database.
– CREATE TABLE: it creates a new table.
– ALTER TABLE: it is used to modify the table.
– DROP TABLE: it deletes a table.
– CREATE DATABASE: it creates a new database.
– ALTER DATABASE: it is used to modify a database.
– CREATE INDEX: it is used to create an index (search key).
– DROP INDEX: it deletes an index.
Course Video
YouTube Reference :
SQL Syntax in Hindi
SQL Syntax in English
