SQLtest: prática SQL

Employee Database (Firebird)

Employee is a sample database that comes with the Firebird cross-platform database management system. You can use this database to explore Firebird SQL and other DBMS features.

Below is a list of this DB tables:

• COUNTRY - table of countries.
• JOB - table of jobs.
• DEPARTMENT - table of departments.
• EMPLOYEE - table of employees.
• PROJECT - table of projects.
• EMPLOYEE_PROJECT - table of employee to project relations.
• PROJ_DEPT_BUDGET - table of project budgets.
• SALARY_HISTORY - table of employees salary changes history.
• CUSTOMER - table of customers.
• SALES - table of sales.

Introdução à Linguagem SQL: Abordagem prática para iniciantes

Atualmente as empresas estão coletando dados a taxas exponenciais e mesmo assim poucas pessoas sabem como acessá-los de maneira relevante. Se você trabalha em uma empresa ou é profissional de TI, este curto guia prático lhe ensinará como obter e transformar dados com o SQL de maneira significativa. Você dominará rapidamente os aspectos básicos do SQL e aprenderá como criar seus próprios bancos de dados. O autor Thomas Nield fornece exercícios no decorrer de todo o livro para ajudá-lo a praticar em casa suas recém descobertas aptidões no uso do SQL, sem precisar empregar um ambiente de servidor de banco de dados. Além de aprender a usar instruções-chave do SQL para encontrar e manipular seus dados, você descobrirá como projetar e gerenciar eficientemente bancos de dados que atendam às suas necessidades.

Table COUNTRY

• COUNTRY - Name of the country.
• CURRENCY - Currency used in the country.

Table JOB

• JOB_CODE - Job code.
• JOB_GRADE - Job grade.
• JOB_COUNTRY - Country associated with the job.
• JOB_TITLE - Job title.
• MIN_SALARY - Minimum salary for the job.
• MAX_SALARY - Maximum salary for the job.
• JOB_REQUIREMENT - Job requirements.
• LANGUAGE_REQ - Language requirements.

Table DEPARTMENT

• DEPT_NO - Department number.
• DEPARTMENT - Department name.
• HEAD_DEPT - Head department (can be null).
• MNGR_NO - Manager number.
• BUDGET - Department budget.
• LOCATION - Department location.
• PHONE_NO - Phone number for the department.

Table EMPLOYEE

• EMP_NO - Employee number.
• FIRST_NAME - First name of the employee.
• LAST_NAME - Last name of the employee.
• PHONE_EXT - Phone extension for the employee.
• HIRE_DATE - Date of employee's hire.
• DEPT_NO - Department number.
• JOB_CODE - Job code for the employee.
• JOB_GRADE - Job grade for the employee.
• JOB_COUNTRY - Country associated with the employee's job.
• SALARY - Salary of the employee.
• FULL_NAME - Full name of the employee.

Table PROJECT

• PROJ_ID - Project ID.
• PROJ_NAME - Project name.
• PROJ_DESC - Project description.
• TEAM_LEADER - Team leader for the project.
• PRODUCT - Product associated with the project.

Table EMPLOYEE_PROJECT

• EMP_NO - Employee number.
• PROJ_ID - Project ID.

Table PROJ_DEPT_BUDGET

• FISCAL_YEAR - Fiscal year.
• PROJ_ID - Project ID.
• DEPT_NO - Department number.
• QUART_HEAD_CNT - Quarter headcount (can be null).
• PROJECTED_BUDGET - Projected budget for the fiscal year.

Table SALARY_HISTORY

• EMP_NO - Employee number.
• CHANGE_DATE - Date of salary change.
• UPDATER_ID - Updater ID.
• OLD_SALARY - Previous salary.
• PERCENT_CHANGE - Percentage change in salary.
• NEW_SALARY - New salary after the change.

Table CUSTOMER

• CUST_NO - Customer number.
• CUSTOMER - Customer name.
• CONTACT_FIRST - First name of the contact person.
• CONTACT_LAST - Last name of the contact person.
• PHONE_NO - Phone number for the customer.
• ADDRESS_LINE1 - Address line 1.
• ADDRESS_LINE2 - Address line 2 (can be null).
• CITY - City of the customer.
• STATE_PROVINCE - State or province of the customer.
• COUNTRY - Country of the customer.
• POSTAL_CODE - Postal code of the customer.
• ON_HOLD - On hold status (can be null).

Table SALES

• PO_NUMBER - Purchase order number.
• CUST_NO - Customer number associated with the order.
• SALES_REP - Sales representative number.
• ORDER_STATUS - Order status.
• ORDER_DATE - Date of the order.
• SHIP_DATE - Date of shipment.
• DATE_NEEDED - Date needed (can be null).
• PAID - Payment status.
• QTY_ORDERED - Quantity ordered.
• TOTAL_VALUE - Total value of the order.
• DISCOUNT - Discount applied.
• ITEM_TYPE - Type of item in the order.
• AGED - Aged value.