DATABASE PROGRAMMING USING SQL (Oracle Academy) || some basic commands

I hope these notes will be sufficient to understand lecture 1 and to implement it practically (shown in lecture 2).

-- this command is going to help you in the retrieval of all the rows!!

SELECT * FROM <table name>;

e.g. SELECT * FROM employees;

-- this command is going to help you in the retrieval of some particular columns (employee_id, first_name, last_name)

SELECT <column name 1, column name 2, column name 3> FROM <table name>;

e.g. SELECT employee_id, first_name, last_name FROM employees;

-- this command is going to help you in the retrieval of some particular columns with particular conditions (employee_id, first_name, last_name)

SELECT <column name 1, column name 2, column name 3> FROM <table name> WHERE <condition>;

e.g. select first_name, last_name, salary from employees where salary<10000;

myTuitionBatch