My SQL Labs
must be complex (2 or more columns in the GROUP BY section).Important: each of the SELECTs will briefly describe what you wanted to choose with this SELECT.7 .Create 1 procedure and 1 function with a free function.The use of the variables created in the DECLARE section is mandatory.8thAdd at least 5 FOREIGN KEY to the free tables if they were not added when the tables were created.The 9.Create at least 2 indices on free columns.Use EXPLAIN to check what it has given (measure before and after the index).Important is:
The database must be exported to a .sql file.
The task is to write... SELECT..." after successfully performing SELECT, save it into a separate file;
- use of aliaxes for the names of columns, tables, view is not mandatory but desired;
- the verification material includes a .sql file with an exported database and a SELECT file;
-
3 days31 USD
290 4 0 1 3 days31 USD
Good day ,
Ready to complete your task, everything will go somewhere 1-2 days.
Write, agree on details and deadlines!
-
2 days33 USD
1351 62 2 1 2 days33 USD
Доброго дня.
Зможу виконати завдання по mysql.
- = - = - = - = - = - = - = - = - = - = - = - = - = -
-
1 day40 USD
949 22 0 1 day40 USD
Good day .
Databases are the main specialization. I will do everything quickly and well. I will be advising and answering your questions. to turn.
-
1 day31 USD
359 10 0 1 day31 USD
Congratulations to Max. Ready to help, I will do it quickly. to turn.
-
1 day56 USD
848 22 0 1 1 day56 USD
Ready to implement your project. Contact me to clarify details.
Current freelance projects in the category Databases & SQL
Accounting, planning, and sales system for a mushroom farm
600 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 23 hours 45 minutes back ∙ 48 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 1 day back ∙ 10 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr
Project Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 1 day 12 hours back ∙ 9 proposals |
Database synchronization
Synchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 1 day 18 hours back ∙ 10 proposals |
Setting up a backup system and optimizing server infrastructure
Objective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 2 days 16 hours back ∙ 23 proposals |
Kyiv