25 Jun SQL Tutorial
SQL is a Standard Query language used to manage, access, and manipulate data in an RDBMS. It is used to insert, update, and delete records from a database. Also, set permissions on tables and views with SQL.
Video Tutorial
The SQL tutorial is prepared for students, engineers, and professionals. Beginning with the introduction and installation, you will learn how to create a database and tables, and how to insert records and select them. We have also included operators, clauses, and subquery lessons. With that, step-by-step text and video lessons are provided.
Run SQL Online
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
-- create CREATE TABLE EMPLOYEE ( empId int, name varchar(100), dept varchar(50) ); -- insert INSERT INTO EMPLOYEE(empId,name,dept) VALUES (0001, 'Clark', 'Sales'); INSERT INTO EMPLOYEE(empId,name,dept) VALUES (0002, 'Dave', 'Accounting'); INSERT INTO EMPLOYEE(empId,name,dept) VALUES (0003, 'Ava', 'Sales'); -- fetch SELECT * FROM EMPLOYEE; GO |
SQL Index
The following lessons are covered in the SQL Tutorial,
SQL – Install & Setup
No Comments