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

Опубликовано: 04 Сентябрь 2023
на канале: 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

На этой странице сайта вы можете посмотреть видео онлайн SQL - USE Keyword | Coding Exercise | SQL Fundamentals - 1 длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь TecTute 04 Сентябрь 2023, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 414 раз и оно понравилось 14 зрителям. Приятного просмотра!

4,705

151