{"id":1574,"date":"2024-09-17T15:22:09","date_gmt":"2024-09-17T15:22:09","guid":{"rendered":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/?p=1574"},"modified":"2024-09-17T15:22:10","modified_gmt":"2024-09-17T15:22:10","slug":"ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd","status":"publish","type":"post","link":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/","title":{"rendered":"AB \u0431\u0430\u0437\u0430 — \u043c\u0430\u0433\u0430\u0437\u0438\u043d"},"content":{"rendered":"\n
\n\n\n\n

SQL Server<\/strong><\/p>\n\n\n\n

CREATE DATABASE ShopBase ;\nUSE ShopBase ;<\/pre>\n\n\n\n
TABLE BRANDS<\/strong><\/p>\n\n\n\n
Create table brands(\nbrand_id int primary key identity(1,1),\nbrand_name varchar(20)\n);\nINSERT INTO brands\n(brand_name) \nVALUES ('zara'),\n('h&m'),\n('dior'),\n('nike'),\n('chanel');\nselect * from brands<\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
TABLE CATEGORIES<\/strong><\/p>\n\n\n
\nCreate table categories(\ncategory_id int primary key identity(1,1),\ncategory_name varchar(20)\n);\nINSERT INTO categories\n(category_name) \nVALUES ('\u00fcler\u00f5ivad'),\n('ujumisriided'),\n('kombinesoonid'),\n('pesu'),\n('pid\u017eaama');\nselect * from categories\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
TABLE CUSTOMERS<\/strong><\/p>\n\n\n
\nCreate table customers(\ncustomer_id int primary key identity(1,1),\nfirst_name varchar(20),\nlast_name varchar(20),\nphone varchar(20),\nemail varchar(20),\nstreet varchar(20),\ncity varchar(20),\nstate varchar(20),\nzip_code char(5)\n);\nINSERT INTO customers\n(first_name,last_name,phone,email,street,city,state,zip_code) \nVALUES ('Valeria','Allik','55516475','lera@gmail.com','Narva mnt','Tallinn','Estonia',52345),\n('Daria','Halchenko','55596734','d.h@gmail.com','Peterbuuri tee','Tallinn','Estonia',54321),\n('Alexandra','Semjonova','55539674','sasha@gmail.com','Telliskivi tee','Tallinn','Estonia',13245),\n('David','Myrseth','55503752','david@gmail.com','Paemurru tee','Narva','Estonia',65432),\n('Maria','Gorbunova','55504829','maria@gmail.com','Viljandi mnt','Tallinn','Estonia',94037);\nselect * from customers\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
TABLE PRODUCTS<\/strong><\/p>\n\n\n
\nCREATE TABLE products(\nproduct_id int not null primary key identity(1,1),\nproduct_name varchar(20),\nbrand_id int,\ncategory_id int,\nmodel_year int,\nlist_price decimal(7, 2),\nFOREIGN KEY (brand_id) REFERENCES brands(brand_id),\nFOREIGN KEY (category_id) REFERENCES categories(category_id)\n);\nINSERT INTO products\n(product_name, brand_id, category_id,model_year,list_price) \nVALUES ('s\u00e4rk', 1, 1, 2020, 25.20),\n('t-s\u00e4rk', 2, 2, 2023, 10.99),\n('teksad', 3, 3, 2021, 30.50),\n('p\u00fcksid', 4, 4, 2024, 15.20),\n('ujumisp\u00fcksid', 5, 5, 2022, 9.99);\nselect * from products\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
TABLE STORES<\/strong><\/p>\n\n\n
\nCreate table stores(\nstore_id int primary key identity(1,1),\nstore_name varchar(20),\nphone varchar(20),\nemail varchar(20),\nstreet varchar(20),\ncity varchar(20),\nstate varchar(20),\nzip_code char(5)\n);\nINSERT INTO stores\n(store_name, phone, email,street,city,state,zip_code) \nVALUES ('Blive', '55583951', 'blive@gmail.com', 'Narva mnt', 'Tallin','Estonia',47382),\n('Hibe', '55503728', 'hibe@gmail.com', 'Viljandi mnt', 'Tallin','Estonia',58361),\n('Illit', '55529571', 'illit@gmail.com', 'Telliskivi tee', 'Tallin','Estonia',94017),\n('TXT', '55530681', 'txt@gmail.com', 'Paemurru tee', 'Narva','Estonia',10603),\n('SKZ', '55559306', 'skz@gmail.com', 'Peterbuuri tee', 'Tallin','Estonia',50381);\nselect * from stores\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
TABLE STAFFS<\/strong><\/p>\n\n\n
\nCREATE TABLE staffs(\nstaff_id int not null primary key identity(1,1),\nfirst_name varchar(20),\nlast_name varchar(20),\nemail varchar(20),\nphone varchar(20),\nactive bit,\nstore_id int,\nmanager_id int,\nFOREIGN KEY (store_id) REFERENCES stores(store_id),\nFOREIGN KEY (manager_id) REFERENCES staffs(staff_id)\n);\nINSERT INTO staffs\n(first_name, last_name, email,phone,active,store_id,manager_id) \nVALUES ('Kirill', 'Saats', 'kirill@gmail.com', '55594027', 1, 1, 1),\n('David', 'Lennuk', 'lennuk@gmail.com', '55573950', 0, 2, 2),\n('Martin', 'Sild', 'martin@gmail.com', '55525852', 1, 3, 3),\n('Lev', 'Jegorov', 'lev@gmail.com', '55568397', 0, 4, 4),\n('Timur', 'Bashirov', 'timur@gmail.com', '55528401', 1, 5, 5);\nselect * from staffs\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
TABLE ORDERS<\/strong><\/p>\n\n\n
\nCREATE TABLE orders(\norder_id int not null primary key identity(1,1),\ncustomer_id int,\norder_status varchar(20),\norder_date date,\nrequired_date date,\nshipped_date date,\nstore_id int,\nstaff_id int,\nFOREIGN KEY (customer_id) REFERENCES customers(customer_id),\nFOREIGN KEY (store_id) REFERENCES stores(store_id),\nFOREIGN KEY (staff_id) REFERENCES staffs(staff_id)\n);\nINSERT INTO orders\n(customer_id, order_status, order_date, required_date, shipped_date,store_id,staff_id) \nVALUES (1, 'Shipped', '2024-08-15', '2024-08-16', '2024-07-14', 1, 1),\n(2, 'Shipped', '2024-10-25', '2024-04-30', '2024-09-17', 2, 2),\n(3, 'Shipped', '2024-10-15', '2024-03-02', '2024-09-24', 3, 3),\n(4, 'Shipped', '2023-12-16', '2024-07-13', '2024-11-20', 4, 4),\n(5, 'Shipped', '2024-01-19', '2024-05-26', '2024-12-30', 5, 5);\nselect * from orders\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
TABLE ORDER ITEMS<\/strong><\/p>\n\n\n
\nCREATE TABLE order_items(\norder_id int not null,\nitem_id int,\nproduct_id int,\nquantity int,\nlist_price decimal(7, 2),\ndiscount varchar(10),\nPRIMARY KEY (order_id, item_id),\nFOREIGN KEY(product_id) REFERENCES products(product_id),\nFOREIGN KEY(order_id) REFERENCES orders(order_id),\nFOREIGN KEY(item_id) REFERENCES orders(order_id)\n);\nINSERT INTO order_items\n(order_id, item_id, product_id, quantity,list_price,discount) \nVALUES (1, 1, 1, 10, 110.50, '5%'),\n(2, 2, 2, 30, 30.99, '10%'),\n(3, 3, 3, 42, 43.80, '40%'),\n(4, 4, 4, 56, 12.99, '25%'),\n(5, 5, 5, 5, 58.35, '12%');\nselect * from order_items\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/p>\n\n\n\n
TABLE STOCKS<\/strong><\/p>\n\n\n
\nCREATE TABLE stocks(\nstore_id int not null,\nproduct_id int,\nquantity int,\nPRIMARY KEY (store_id, product_id),\nFOREIGN KEY(product_id) REFERENCES products(product_id),\nFOREIGN KEY(store_id) REFERENCES stores(store_id)\n);\nINSERT INTO stocks\n(store_id, product_id, quantity) \nVALUES (1, 1, 30),\n(2, 2, 90),\n(3, 3, 76),\n(4, 4, 81),\n(5, 5, 48);\nselect * from stocks\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
K\u00d5IK TABLES<\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
KASUTAJAD <\/strong><\/p>\n\n\n\n
STAFF<\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
MANAGER<\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u00d5IGUSED ‘STAFF<\/strong>‘<\/p>\n\n\n
\ngrant SELECT on customers to staff; \ngrant SELECT on staffs to staff;\ngrant SELECT on orders to staff;\ngrant SELECT on order_items to staff;\ngrant SELECT on stores to staff;\ngrant insert on order_items to staff;\ngrant insert on orders to staff;\nDENY DELETE on order_items to staff;\nDENY DELETE on orders to staff;\nDENY update on order_items to staff;\nDENY update on orders to staff;\n<\/pre><\/div>\n\n\n
\u00d5IGUSED ‘MANAGER’<\/strong><\/p>\n\n\n
\nGRANT SELECT to manager;\nDENY insert on stores to manager;\n<\/pre><\/div>\n\n\n
\u00dcLEVAATUS ‘STAFF’<\/strong><\/p>\n\n\n\n
select<\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
drop<\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
update<\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u00dcLEVAATUS ‘MANAGER’<\/strong><\/p>\n\n\n\n
insert<\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
select<\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
SQL Server CREATE DATABASE ShopBase ; USE ShopBase ; TABLE BRANDS Create table brands( brand_id int primary key identity(1,1), brand_name varchar(20) ); INSERT INTO brands (brand_name) VALUES (‘zara’), (‘h&m’), (‘dior’), (‘nike’), (‘chanel’); select * from brands TABLE CATEGORIES TABLE CUSTOMERS TABLE PRODUCTS TABLE STORES TABLE STAFFS TABLE ORDERS TABLE ORDER ITEMS TABLE STOCKS K\u00d5IK TABLES […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-1574","post","type-post","status-publish","format-standard","hentry","category-andmebaasisusteemide-alused"],"yoast_head":"\nAB \u0431\u0430\u0437\u0430 - \u043c\u0430\u0433\u0430\u0437\u0438\u043d - Valeria Allik portfoolio | Russian<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-\u0431\u0430\u0437\u0430-\u043c\u0430\u0433\u0430\u0437\u0438\u043d\/\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AB \u0431\u0430\u0437\u0430 - \u043c\u0430\u0433\u0430\u0437\u0438\u043d - Valeria Allik portfoolio | Russian\" \/>\n<meta property=\"og:description\" content=\"SQL Server CREATE DATABASE ShopBase ; USE ShopBase ; TABLE BRANDS Create table brands( brand_id int primary key identity(1,1), brand_name varchar(20) ); INSERT INTO brands (brand_name) VALUES ('zara'), ('h&m'), ('dior'), ('nike'), ('chanel'); select * from brands TABLE CATEGORIES TABLE CUSTOMERS TABLE PRODUCTS TABLE STORES TABLE STAFFS TABLE ORDERS TABLE ORDER ITEMS TABLE STOCKS K\u00d5IK TABLES […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-\u0431\u0430\u0437\u0430-\u043c\u0430\u0433\u0430\u0437\u0438\u043d\/\" \/>\n<meta property=\"og:site_name\" content=\"Valeria Allik portfoolio | Russian\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-17T15:22:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-17T15:22:10+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 \u043c\u0438\u043d\u0443\u0442\u044b\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#\\\/schema\\\/person\\\/be38dc15d5db1134b3b156c050997e18\"},\"headline\":\"AB \u0431\u0430\u0437\u0430 — \u043c\u0430\u0433\u0430\u0437\u0438\u043d\",\"datePublished\":\"2024-09-17T15:22:09+00:00\",\"dateModified\":\"2024-09-17T15:22:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/\"},\"wordCount\":44,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kodu4.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/pilt-64.png?w=133\",\"articleSection\":[\"Andmebaasis\u00fcsteemide alused\"],\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/\",\"url\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/\",\"name\":\"AB \u0431\u0430\u0437\u0430 - \u043c\u0430\u0433\u0430\u0437\u0438\u043d - Valeria Allik portfoolio | Russian\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kodu4.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/pilt-64.png?w=133\",\"datePublished\":\"2024-09-17T15:22:09+00:00\",\"dateModified\":\"2024-09-17T15:22:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kodu4.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/pilt-64.png?w=133\",\"contentUrl\":\"https:\\\/\\\/kodu4.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/pilt-64.png?w=133\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/2024\\\/09\\\/17\\\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AB \u0431\u0430\u0437\u0430 — \u043c\u0430\u0433\u0430\u0437\u0438\u043d\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#website\",\"url\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/\",\"name\":\"Valeria Allik portfoolio | Russian\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ru-RU\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#organization\",\"name\":\"Valeria Allik portfoolio | Russian\",\"url\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/09\\\/Pink-Bold-Retro-Aesthetic-Inspirational-Quote-Instagram-Post.png\",\"contentUrl\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/09\\\/Pink-Bold-Retro-Aesthetic-Inspirational-Quote-Instagram-Post.png\",\"width\":1080,\"height\":1080,\"caption\":\"Valeria Allik portfoolio | Russian\"},\"image\":{\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/#\\\/schema\\\/person\\\/be38dc15d5db1134b3b156c050997e18\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb13eb1a5656740feb3312c206d66a49c17d0b3f3092b85508fd48f21160ac98?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb13eb1a5656740feb3312c206d66a49c17d0b3f3092b85508fd48f21160ac98?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb13eb1a5656740feb3312c206d66a49c17d0b3f3092b85508fd48f21160ac98?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\"],\"url\":\"https:\\\/\\\/valeriaallik23.thkit.ee\\\/wp\\\/ru\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AB \u0431\u0430\u0437\u0430 - \u043c\u0430\u0433\u0430\u0437\u0438\u043d - Valeria Allik portfoolio | Russian","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-\u0431\u0430\u0437\u0430-\u043c\u0430\u0433\u0430\u0437\u0438\u043d\/","og_locale":"ru_RU","og_type":"article","og_title":"AB \u0431\u0430\u0437\u0430 - \u043c\u0430\u0433\u0430\u0437\u0438\u043d - Valeria Allik portfoolio | Russian","og_description":"SQL Server CREATE DATABASE ShopBase ; USE ShopBase ; TABLE BRANDS Create table brands( brand_id int primary key identity(1,1), brand_name varchar(20) ); INSERT INTO brands (brand_name) VALUES ('zara'), ('h&m'), ('dior'), ('nike'), ('chanel'); select * from brands TABLE CATEGORIES TABLE CUSTOMERS TABLE PRODUCTS TABLE STORES TABLE STAFFS TABLE ORDERS TABLE ORDER ITEMS TABLE STOCKS K\u00d5IK TABLES […]","og_url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-\u0431\u0430\u0437\u0430-\u043c\u0430\u0433\u0430\u0437\u0438\u043d\/","og_site_name":"Valeria Allik portfoolio | Russian","article_published_time":"2024-09-17T15:22:09+00:00","article_modified_time":"2024-09-17T15:22:10+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c":"admin","\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f":"4 \u043c\u0438\u043d\u0443\u0442\u044b"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/#article","isPartOf":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/"},"author":{"name":"admin","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#\/schema\/person\/be38dc15d5db1134b3b156c050997e18"},"headline":"AB \u0431\u0430\u0437\u0430 — \u043c\u0430\u0433\u0430\u0437\u0438\u043d","datePublished":"2024-09-17T15:22:09+00:00","dateModified":"2024-09-17T15:22:10+00:00","mainEntityOfPage":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/"},"wordCount":44,"commentCount":0,"publisher":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#organization"},"image":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/#primaryimage"},"thumbnailUrl":"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/05\/pilt-64.png?w=133","articleSection":["Andmebaasis\u00fcsteemide alused"],"inLanguage":"ru-RU","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/","url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/","name":"AB \u0431\u0430\u0437\u0430 - \u043c\u0430\u0433\u0430\u0437\u0438\u043d - Valeria Allik portfoolio | Russian","isPartOf":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#website"},"primaryImageOfPage":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/#primaryimage"},"image":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/#primaryimage"},"thumbnailUrl":"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/05\/pilt-64.png?w=133","datePublished":"2024-09-17T15:22:09+00:00","dateModified":"2024-09-17T15:22:10+00:00","breadcrumb":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/"]}]},{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/#primaryimage","url":"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/05\/pilt-64.png?w=133","contentUrl":"https:\/\/kodu4.wordpress.com\/wp-content\/uploads\/2024\/05\/pilt-64.png?w=133"},{"@type":"BreadcrumbList","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/2024\/09\/17\/ab-%d0%b1%d0%b0%d0%b7%d0%b0-%d0%bc%d0%b0%d0%b3%d0%b0%d0%b7%d0%b8%d0%bd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/"},{"@type":"ListItem","position":2,"name":"AB \u0431\u0430\u0437\u0430 — \u043c\u0430\u0433\u0430\u0437\u0438\u043d"}]},{"@type":"WebSite","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#website","url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/","name":"Valeria Allik portfoolio | Russian","description":"","publisher":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ru-RU"},{"@type":"Organization","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#organization","name":"Valeria Allik portfoolio | Russian","url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/","logo":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#\/schema\/logo\/image\/","url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-content\/uploads\/sites\/2\/2024\/09\/Pink-Bold-Retro-Aesthetic-Inspirational-Quote-Instagram-Post.png","contentUrl":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-content\/uploads\/sites\/2\/2024\/09\/Pink-Bold-Retro-Aesthetic-Inspirational-Quote-Instagram-Post.png","width":1080,"height":1080,"caption":"Valeria Allik portfoolio | Russian"},"image":{"@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/#\/schema\/person\/be38dc15d5db1134b3b156c050997e18","name":"admin","image":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/secure.gravatar.com\/avatar\/bb13eb1a5656740feb3312c206d66a49c17d0b3f3092b85508fd48f21160ac98?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bb13eb1a5656740feb3312c206d66a49c17d0b3f3092b85508fd48f21160ac98?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bb13eb1a5656740feb3312c206d66a49c17d0b3f3092b85508fd48f21160ac98?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/valeriaallik23.thkit.ee\/wp"],"url":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/posts\/1574","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/comments?post=1574"}],"version-history":[{"count":1,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/posts\/1574\/revisions"}],"predecessor-version":[{"id":1575,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/posts\/1574\/revisions\/1575"}],"wp:attachment":[{"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/media?parent=1574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/categories?post=1574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/valeriaallik23.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/tags?post=1574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}