startup_script.sql
● Verified
--
-- PostgreSQL database dump
--
\restrict RaEsQQwrsO3Bl7tgGh5toTTgQjVDcbL7sXt9a1z2jcUOJBgwsxiNj5zdk510acm
-- Dumped from database version 18.6
-- Dumped by pg_dump version 18.6
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
--
-- Name: main; Type: SCHEMA; Schema: -; Owner: -
--
CREATE SCHEMA main;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: usr; Type: TABLE; Schema: main; Owner: -
--
CREATE TABLE main.usr (
id integer,
name character varying(20),
lastname character varying(20),
mail character varying(50),
address character varying(100),
city character varying(20),
profesia character varying(50)
);
--
-- Data for Name: usr; Type: TABLE DATA; Schema: main; Owner: -
--
INSERT INTO main.usr (id, name, lastname, mail, address, city, profesia) VALUES (3, 'Olga', 'Fajn┼бmekrova', 'prefajnsmekrovtentim@gmail.com', 'Park Angelum', 'Kosice', 'HR');
INSERT INTO main.usr (id, name, lastname, mail, address, city, profesia) VALUES (0, 'Ruslan', 'Penkov', 'ruslan.penkov2007@gmail.com', 'Prazska 2', 'Kosice', 'DBA');
INSERT INTO main.usr (id, name, lastname, mail, address, city, profesia) VALUES (2, 'Jordan', 'Overtake', 'jordan.overtake@ukr.net', 'okolie banky ─Н.2', 'Los Santos', 'Pravnik');
INSERT INTO main.usr (id, name, lastname, mail, address, city, profesia) VALUES (4, 'Ondrej', 'Tomas', 'ondrej.tomas@student.upjs.com', 'Horky', 'Vranov nad Toplou', 'HSE specialist');
INSERT INTO main.usr (id, name, lastname, mail, address, city, profesia) VALUES (1, 'Alexa', 'Kohracova', 'arga_majanan@gmail.com', 'namestie oslobotitelov', 'Kosice', '┼бofer');
INSERT INTO main.usr (id, name, lastname, mail, address, city, profesia) VALUES (5, 'Roman', 'Haluska', 'roman.haluska1@upjs.sk', 'tulcik', 'Presov', 'DBA');
INSERT INTO main.usr (id, name, lastname, mail, address, city, profesia) VALUES (6, 'Jozef', 'Prles', 'jozef.prles23@gmail.com', 'Miami', 'USA', 'CFA');
INSERT INTO main.usr (id, name, lastname, mail, address, city, profesia) VALUES (8, 'Jozef', 'Prles', 'jozef.prles23@gmail.com', 'Miami', 'USA', 'Manager');
INSERT INTO main.usr (id, name, lastname, mail, address, city, profesia) VALUES (9, 'Marta', 'Juzna', 'marta.juzna@32', 'Raslavice', 'Presov', 'Upratova─Нka');
INSERT INTO main.usr (id, name, lastname, mail, address, city, profesia) VALUES (7, 'Sara', 'Novakova', 'saranovakova@gmail.com', 'Rakackeho22', 'Kosice', 'Stahovac');
--
-- PostgreSQL database dump complete
--
\unrestrict RaEsQQwrsO3Bl7tgGh5toTTgQjVDcbL7sXt9a1z2jcUOJBgwsxiNj5zdk510acm
Example Screenshot
Preview of the SQL query execution and generated table data.
DDL.sql
Database structure and schema creation.
Example
CREATE TABLE main.usr (
id INTEGER,
name VARCHAR(20),
lastname VARCHAR(20)
);Additional table definitions are available in the downloadable file.
DML.sql
Data insertion and manipulation.
Example
INSERT INTO main.usr
(id, name, lastname)
VALUES
(1, 'Alexa', 'Kohracova');The complete data population script is available in the downloadable file.
DQL.sql
Tasks and SELECT query solutions.
Example Task
-- Show all users from Kosice
SELECT name, lastname, city
FROM main.usr
WHERE city = 'Kosice'
ORDER BY lastname;The complete assignment containing multiple tasks and solutions is available in the downloadable file.
Word Document
Word Document containing additional information - tasks.
The complete data population script is available in the downloadable file.
DQL2.SQL
Document containing additional questions with the answer.
The complete data population script is available in the downloadable file.
DQL2(join).SQL
Document containing questions and examples about JOIN operations.
The complete data population script is available in the downloadable Word file.