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.
Get Certified 4,753 students | Audio: English
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