Bases of SQL
18 USD 1 . The subject of the project (may be any)
2nd Preliminary assumptions (restrictions)
Three Conceptual and logical scheme
4 . The database should be at least in a third normal form.
and 5. Minimum of 8 tables
6 . Structure of Table
7 . SQL Procedures for adding and updating data (minimum two)
8 . Minimum of 4 views
The 9. Critical assessment of the completed project
The 10. Documentation (the title sheet with the school’s logo, headline, schemes, description) in PDF format
11 of 11. SQL code in TXT format
12 . You provide two files with the name Index_Surname_Name (one PDF, the other TXT)
13 . You send all to the Platon platform in Zalicza_projekt (you can send only 2 (two files)
14 . Files cannot be packed (Do not use RAR ZIP)
Final deadline - two days before the last class (07.02.2023)
Evaluation: compliance with minimum requirements is a satisfactory assessment (3)
Client's review of cooperation with Vladislav Oleksyuk
Bases of SQLThe project was successfully implemented. All wishes were taken into account.
Freelancer's review of cooperation with Sevda Titov
Bases of SQLI recommend cooperation!
Current freelance projects in the category Databases & SQL
1C database for the enterpriseA database is needed for managing the auto dismantling inventory, controlling finances, and generating orders. It is necessary to add a car as an object and attach parts to it. I will explain the full structure of how it should look and work during the conversation. Databases & SQL ∙ 5 hours 14 minutes back ∙ 2 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 1 day 10 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 2 days 16 hours back ∙ 33 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 2 days 19 hours back ∙ 13 proposals |
Project: Basic Setup of End-to-End Analytics (Analytics Engineer / Data Analyst)
203 USD
About us and current stack: We are a B2C web product. Currently, we have disparate data that needs to be consolidated into a single system for marketing decision-making. Database: PostgreSQL (user data). Payments: Stripe. Web analytics: Google Analytics 4. Traffic sources:… Databases & SQL ∙ 4 days 14 hours back ∙ 10 proposals |
Warszawa