SQL - USE Keyword | Coding Exercise | SQL Fundamentals - 1

Published: 04 September 2023
on channel: TecTute

414

SQL Fundamentals - 1 | SQL - USE Keyword | Coding Exercise | SQL Queries

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

On this page of the site you can watch the video online SQL - USE Keyword | Coding Exercise | SQL Fundamentals - 1 with a duration of hours minute second in good quality, which was uploaded by the user TecTute 04 September 2023, share the link with friends and acquaintances, this video has already been watched 414 times on youtube and it was liked by 14 viewers. Enjoy your viewing!

163,192

827