SQL - SELECT * FROM | SQL Fundamentals - 2 | Coding Exercise
Coding Exercise | SQL Fundamentals - 2 | SQL - SELECT * FROM | SQL Queries
SELECT: This keyword indicates that we want to retrieve specific columns from the table.
In SQL, the asterisk symbol (*) is often used as a wildcard character, in the context of the SELECT statement.
When you write SELECT *, it means "select all columns" from the specified table.
Consider a Employees data set contains following tables:
Departments - dept_no, dept_name
Dept_emp - emp_no, dept_no, from_date, to_date
Dept_manager - emp_no, dept_no, from_date, to_date
Employees - emp_no, birth_date, first_name, last_name, gender, hire_date
Salaries - emp_no, salary, from_date, to_date
Titles - emp_no, titles, from_date, to_date
Craft a query to uncover the first names & last names of female employees who were hired in the year 1999? Arrange the results in descending order of
first names.
DDL – Data Definition Language
DML – Data Manipulation Language
DCL – Data Control Language
TCL – Transaction Control Language
Data Definition Language: Used to create, modify & delete database objects such as tables, views, indexes & constraints.
Data Manipulation Language: Used to SELECT, insert, update, delete & retrieve data from a database table.
Data Control Language. Used to manage access control and security of a data base. Commands like GRANT, REVOKE.
Transaction Control Language. Used to manage transactions in a data base. Commands like COMMIT, ROLL BACK.
These subsets of SQL allow users to perform different types of operations on a database and provide a powerful set of tools for managing and manipulating data.
#sql #sqltutorial #sqlqueries #sqlcourse