SQL Jobs

Write SQL statements (MySQL/MariaDB SQL) to: Create a relational database named ‘GourmetHub’ using MySQL/MariaDB SQL (write also the statement to use it). Create the following table: RESTAURANT (CODE, name, location) with the following restrictions: CODE is the primary key. It is an alphanumeric code designating each unique restaurant. The code can have 1 to 5 characters. NAME is an alphanumeric sequence, it is required, and it is unique. LOCATION is an alphanumeric sequence, indicating the address or area of the restaurant, and it is required. Create the following table: DISHES (CODE, name, type, price) with the following restrictions: CODE is the primary key. It is a four-character alphanumeric code designating each unique dish. NAME is an alphanumeric sequence, it is requir...

Database for Small Business Inventory Management - Preferred Database System: Open to either SQL or NoSQL - Primary Purpose: Inventory Management - Anticipated Data Storage: Less than 1GB Skills and Experience: - Proficiency in SQL and/or NoSQL database systems - Experience in designing and implementing database solutions for inventory management - Knowledge of data storage optimization techniques for small-scale databases - Familiarity with data backup and recovery procedures - Understanding of data security measures for protecting sensitive business information Business logic description: Preparation of Shelves and Racks Labeling of Shelves and Racks: Create unique barcodes for each shelf and rack. This will allow for quick identification of the location of each item. Coding System:...

Offline Library Database I am looking for a freelancer to create an offline library database for a public library. The ideal candidate should have experience in creating databases using MySQL. Requirements: - Create a database management system using MySQL - The database should be able to hold less than 1,000 books/items - Design a user-friendly interface for easy navigation and searching within the database - Implement a system for organizing and categorizing books/items - Allow for adding, editing, and deleting book/item records - Include features for tracking book/item availability and borrowing history Skills and Experience: - Proficiency in MySQL and database management - Knowledge of library systems and book/item organization - Experience in designing user-friendly interfaces - At...

Objective: The goal of this project is to develop a robust algorithm for trading in trendy markets, enhancing the existing capabilities for identifying and capitalizing on trends. Additionally, we aim to implement a mechanism within the algorithm to intelligently detect sideways market conditions and abstain from executing trades during such periods. Components: Trend Identification: Employ advanced technical indicators such as moving averages, MACD, and ADX to accurately identify the presence and strength of market trends. Volatility Measurement: Integrate volatility indicators, such as Bollinger Bands and Average True Range, to gauge market volatility, a key factor in distinguishing trending from sideways markets. Pattern Recognition: Develop algorithms for pattern recognition to id...

Generalidades del proyecto. 1. Las facturas de compras y ventas se manejan en XML. 2. Se hará el proceso para 3 compañías pequeñas. Proyecto *Registro automatizado de bills e invoices. * Proceso: Desestructurar el XML que llega a correo, alimentar una base de datos MySQL de forma automatizada cada vez que llega un XML adjunto a un correo y posteriormente, cada vez que se crea una línea en MySQL verificar de que compañía es y hacer el registro de forma automatizada por medio del API. Todo debe quedar bien documentado, en una aplicación web, y es mandatorio que sea en MySQL. Si el proyecto sale satisfactoriamente, existe la posibilidad de un segundo proyecto un poco más grande, que también resulta urgente. Ind...

Seeking an Appsheet developer to complete a simple app today. I will provide a flowchart and SQL database and some very rough wireframes. Start immediately and finish within 48hr

I am looking for a freelancer who can assist me with database design using ERD and SQL. Purpose: - The main purpose of this project is database design. Specific Entities and Relationships: - I have a detailed list of specific entities and relationships that must be included in the ERD. Scale: - The scale of the database is small, with less than 50 records. Ideal Skills and Experience: - Strong knowledge and experience in ERD and SQL - Proficiency in database design - Attention to detail in following specific requirements - Ability to handle small-scale databases efficiently

I am looking for a skilled SQL query writer who is experienced with big query. The ideal candidate should have expertise in writing complex queries. Requirements: - Proficiency in MySQL, Oracle, or SQL Server - Ability to understand and execute complex query requirements - Strong problem-solving skills to optimize query performance - Experience in working with large datasets and handling complex data structures Responsibilities: - Collaborate with our team to understand the specific query requirements - Write complex SQL queries to extract and manipulate data from our big query database - Optimize query performance for efficient data retrieval - Troubleshoot and resolve any issues related to query execution Skills and Experience: - Strong knowledge of SQL and different database systems...

Project Description: I am looking for a skilled Jira expert to help migrate our normal software project to a service desk project. This project is for an existing job on my team and our desired outcome is to have service desk functionality in place. We need this project completed within a month or 45 days. Ideal Skills and Experience: - Strong proficiency in Jira Service Desk (Data Center) and experience with Jira project migration - Knowledge of Jira service desk functionality and best practice by analysing existing software project. - Reports to show specific metrics and key performance indicators (KPIs) 
 - Collect & Analyze Customer Satisfaction. Satisfaction rates (Out of 5) - Service Level Agreements: With Location of the user & holiday info : ability to set and track SLA...

Project Description: - I am looking for a skilled developer to make a small patch in my application. - The application was developed using [programming language]. - The patch is required to fix a specific bug where the function in the app is not displaying the value t. - I have access to the source code of the application. - The ideal candidate should have experience in [programming language] and be familiar with debugging and patching applications. - Attention to detail and the ability to work efficiently are essential for this project. - The patch should be implemented in a timely manner to ensure the smooth functioning of the application. - Please provide examples of previous work or relevant experience in your proposal.

Project Title: App for a Networking App Description: I am looking for a skilled developer to create a networking app that connects local businesses with local people. The app should be available on both iOS and Android platforms. App for the Business, App for the local people and analytics dashboard. Key Requirements: - Experience in developing apps for both iOS and Android platforms - Ability to create a user-friendly interface for seamless networking experience - Strong understanding of social networking functionalities - Knowledge of professional networking features - Familiarity with event networking capabilities - Proficient in integrating location-based services for connecting local businesses with local people Timeline: The desired timeline for completing the app development is ...

Largest Excel database you most likely have seen: 1. 10 millions indivdual records with 6 fields 2. Each file represents the 50 USA States 3. Some files (States) may have 500 records 4. Some States may have 1 million records 5. Need to export each State (50) into individual (50) Excel reports 6. Evaluate each State (50) records to determine how data may be extracted into Excel 7. After evaluating the Excel Data recommend Data export options for searching ease Successful appiicant(s) will review Excel Data via a DropBox connection.

I am looking for a freelancer to help me with my MS ACCESS Database project. The purpose of the database is to store and manage customer data, track inventory and sales, and analyze financial data. Specific requirements for the database include: - User-friendly interface for easy data entry and retrieval - Ability to generate custom reports and queries - Integration with other applications, such as Excel or Outlook I anticipate needing less than 5 tables in the database to meet my requirements. Ideal skills and experience for this project include: - Proficiency in MS ACCESS and database design - Knowledge of SQL and query optimization - Strong attention to detail and ability to meet deadlines If you have any examples or suggestions for additional features that would enhance the functi...

Need to support sms integration into web like demo version

Project Title: O365 SQL DBA I am seeking assistance with database administration tasks as an O365 SQL DBA. Specifically, I need help with the following: - Database administration - Performance tuning - Backup and recovery I require this service on a regular basis and my expected timeline for this project is within 1 year. Ideal skills and experience for the job include: - Strong knowledge and experience in O365 SQL DBA - Proficiency in database administration, performance tuning, and backup and recovery - Ability to work on a regular basis and meet project deadlines

Job Title: Database Developer with Snowflake and MDM Location: HYD/Remote Duration: Full Time Required Skills: • At least 7plus years of experience in Snowflake development which includes creating Stored Procedures, Tasks, Stages, Views and Tables. • Experience working with SQL Query optimization and Cost optimization of Snowflake resources. • implement security measures to protect sensitive data such as, Role-Based Access (RBAC), Data Encryption and Data Masking. • Proficiency in building ELT/ETL pipelines with focus on Change Data Capture (CDC), History Snapshots, Audit logging and other best practices. • Working experience with any of the ETL tools such Five trans, Informatica, etc., • Perf...

We have 2 vps running on same datacenter which share local IP We have master / slave running good already on 1 server (1 master sql and 1 slave sql) We use mariadb as database system Now we want to setup 1/ 2nd VPS same with 1st vps 2/ make a group of master for 2 vps 3/ setup a connection url to 2 masters 4/ setup a connection url to all slaves node Example : tcp:// We need you to build complete 2 dockerfiles for slave and master servers Output : dockerfiles running well with docker compose We can connect to mariadb at 3306 (master) 3307 (slave) 3308 (slave) with sql tool If we write on master - slave automatic replica it we run it on our environments (all vps running ưubuntu 20.04), we share vps ssh with you and we check together too. Our budget is 75$, please dont bid if its ...

Project Title: CloudOneX Customization and Bug Fixing Description: We are seeking a skilled developer to customize and fix bugs in our CloudOneX platform. The ideal candidate should have experience in web development and be familiar with the CloudOneX system. Unfortunately we tried to communicate with the original developers on more than 1 case but support is none-existent, so we're looking for long-term developer relationship. Additional Information: - If you have experience with CloudOneX or similar cloud-based platforms, it would be highly advantageous. - We are open to suggestions for additional features or functionalities that could enhance the platform, and we are willing to discuss these further. If you are a detail-oriented developer with experience in customization and bug...

Need customization for Acumatica ERP. If you never worked with AC DO NOT BID. Im gonna report your profile.

We are a consulting company with a digitalization project in front of us for one of our customers. We need to develop a custom Document Management System with OCR using AWS and open source. We need a partner to propose and develop a technical solution in AWS. The features to develop: - Document Storage: Centralizes and organizes electronic and physical documents. - Version Control: Tracks different versions of a document as it gets edited. - Search and Retrieval: Facilitates the search and retrieval of documents using tags, keywords, or metadata. - Security and Access Control: Determines who can access, view, or edit documents. - Workflow Automation: Automates document-related processes such as approvals and reviews. - Backup and Disaster Recovery: Provides options for backing up and reco...

I have some frm and ibd files on my computer for a MYSQL database. I need to make a SQL file of certain tables or the whole database - and i need help with it it must be done via anydesk or help me via chat as i cannot give u the database files

Looking for an ASP.net developer, JavaScript, and jQuery need to be utilized. Candidate should also be good with report writing to explain the project.

Rebuild SharePoint SQL Connection After Active Directory Failure Project Overview: We are in need of a skilled professional who can help us rebuild the SQL connection for our SharePoint 2010 system after an active directory failure. Requirements: - Expertise in SharePoint 2010 and SQL connection troubleshooting - Familiarity with Active Directory integration in SharePoint - Ability to work with limited access to Active Directory data (no backup available) - Strong problem-solving skills to identify and resolve the issue - Experience with full administrative access to SharePoint server - Excellent communication skills to effectively collaborate with our team Deliverables: - Identify the cause of the SQL connection failure in SharePoint 2010 - Develop and implement a solution to rebuild ...

Note: This is a short deadline project. Only experts who can finish in 1 day respond. Others plz ignore I am looking for a skilled SQL developer who can create complex SQL queries to generate reports and dashboards on Databox. Database: SQL Server Report Format and Data Points: - I have specific requirements for the report format and the data points that need to be included. Deadline: - The deadline for this project is 1 day. Skills and Experience: - Strong SQL skills and experience in creating complex queries - Knowledge of Databox and its reporting capabilities - Ability to understand and interpret specific report requirements - Attention to detail to ensure accurate and reliable reports - Ability to work quickly and efficiently to meet the tight deadline

Note: This is short deadline project which has to be completed in a day. Freelancer who quote more than 1 day plz stay away. I am looking for a skilled freelancer who can write multiple complex SQL queries on Databox to generate dashboards. The purpose of the dashboard is to analyze sales data, track website traffic, and monitor customer behavior. Specific metrics or data points that should be included in the dashboard will be provided by me. Although there are no specific SQL functions or commands required, I can provide guidance on the desired outcome. Ideal skills and experience for this job include: - Proficiency in SQL and Databox - Strong analytical and data visualization skills - Ability to understand and interpret business requirements - Attention to detail and the abilit...

O365 developer with Migration Experience As an Office 365 Migration Engineer, you will be using cutting edge technologies to streamline services to our clients. Join our team of Data and Cloud professionals and accomplish what others only dream of. Ability to obtain a Q Clearance. This is a remote position. • Experience with Data Loss Prevention (DLP) and Azure Information Protection (AIP). • Experience with Office 365 Modern Workplace migrations and implementation • Ability to perform health checks and assessments of on-premises systems prior to migrations • Collaborate with members of the development team and project managers to deliver solutions that surpass client expectations • Implement AIS cloud infrastructure solution offerings based on public cloud, ...

Hello, i would like to hire a database administration but needs ti prepare for some exams before Please contact mee!!

The primary responsibility of this role is to lead the migration of our SQL databases from an on-premises environment to Azure SQL Managed Instance. This role requires a deep understanding of both on-premises SQL Server and Azure SQL technologies, with a strong emphasis on planning, executing, and managing the migration process. Migration Planning and Execution: Develop and implement a comprehensive migration plan for moving our SQL databases from on-premises servers to Azure SQL Managed Instance. This includes assessing the current environment, planning the migration phases, and executing the migration with minimal downtime. Cost Estimation: Provide detailed cost estimates for the migration process, including Azure resource utilization, potential licensing needs, and any additional reso...

I am looking for a C# Asp.net developer to create a web page that demonstrates the capabilities of the Open AI Assistants API. I will provide the design and layout for the page, so no specific requirements or preferences are needed in that regard. However, the project will require special features and functionalities, such as database integration and user authentication. Ideal skills and experience for this job include: - Proficiency in C# and Asp.net - Familiarity with the Open AI Assistants API - Experience with database integration and user authentication using popular authentication schemes such as google, microsoft and apple. If you have any suggestions or advice regarding the project, I am open to hearing them.

Sierra One is hiring individuals to aid with designing and implementing software solutions for our suite of products. The role of Programmer Analyst will quote, write, modify, integrate and test software changes; identify and communicate technical problems, processes and solutions. Most importantly Sierra One is looking for self-motivated individuals who are excited to learn new skills and build best-in-class products. We're engineering a next-generation digital workshop with a remote-first, result-oriented, timeframe-based strategy; this means as long as you get your tasks done in the requested timeframe, we won't drag you into worthless meetings. This is an ideal position for a developer that is self-directed and mission-oriented. Qualifications Completed College or Universi...

I can only access phpMyadmin through WHM when I have the following in my /etc/ file - [mysqld] skip-grant-tables But then I am not able to retrieve the data from mysql table in my webpages. However when I remove skip-grant-tables from , I an able to view the data in my webpages but phpMyAdmin stops working. I get the message - mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: YES) I am using AlmaLinux 8

Simran invited for Improvement work in thenafter Host on server. Website Address - User emailid- @gmail.c Password- kaspersky Video link for Explaining 'Improvements work to be done' is below- Text contents are below- 24th October 2023 - - - - - Improvement work for 1. IN ADVERTISEMENT - (I) Change text 'Submitter's Account' by 'Creator's Account'. (II). 'Create Ad', 'Edit Ad', 'Remove Ad', 'Creator's Account' grey buttons should appear if logged in user created advertisement. OR only 'Create Ad' button should appear if user logged in user didn't created apper advertisement. (III) Thenafter Headline should appear in appearing advertisement. (IV) thenafter image/video of advertiseme...

I am looking for a Tableau expert to work on a project that involves setting up a date filter and creating a formula for calculating the count of targets met divided by the total opportunities. The desired outcome of this project is to generate actionable insights for decision-making. I have all the necessary data ready for this project, so there is no need for data collection. Each contract has metric IDs and associated target we have to count the total opportunities by counting the total metric I'd with target and second parameter is counting the how many targets are meeting The table should only show the data for previous week I have attached the formula but it's not working with new data source

I am looking for a Tableau expert to work on a project that involves setting up a date filter and creating a formula for calculating the count of targets met divided by the total opportunities. The desired outcome of this project is to generate actionable insights for decision-making. I have all the necessary data ready for this project, so there is no need for data collection. Each contract has metric IDs and associated target we have to count the total opportunities by counting the total metric I'd with target and second parameter is counting the how many targets are meeting The table should only show the data for previous week I have attached the formula but it's not working with new data source

A connection will be established to Firebird 2.5 with Laravel 9.

Es una aplicacion tipo ERM para cosas mas especificas relacionadas a manejo de pequeñas y medianas empresas. .NET para aplicaciones web.

In need of assistance in the field of programming, design, and accounting, for a specific task. The ideal candidate should have expertise in one or more of the following areas: Programming: - Web development - Mobile app development - Database management

Project Title: JasperReport Description: The project involves creating a JasperReport that will display moderately complex data in the form of text. The layout for the report is open to interpretation, as the client is open to anything. Skills and Experience: - Proficiency in JasperReports - Strong understanding of report design - Ability to handle moderately complex data in a clear and concise manner - Creativity and adaptability to create a visually appealing layout for the report

I am looking for a skilled professional to assist with migrating a small MSSQL database to Oracle. The database size is less than 1GB. Around 350 tables , 100 views, 300 scalar functions, 100 table valued functions,350 sps to be migrated The project requires special attention to any specific data types or structures in the database during the migration, although I am not sure if there are any. The timeline for this project is long term, with more than 1 week for completion. Need a person from bangalore , as I would like to work with the person offline Ideal Skills and Experience: - Experience with MSSQL to Oracle migration - Strong understanding of database structures and data types - Attention to detail in ensuring a smooth and accurate migration process

I am looking for a SAP ABAP developer to assist with an enhancement implementation project. Specific requirements include: - Implementing enhancements to an existing SAP ABAP program - Following detailed coding guidelines provided by the client The timeline for this project is immediate, with completion expected within 1 week. Ideal skills and experience for this job include: - Proficiency in SAP ABAP development - Experience with enhancement implementations - Ability to adhere to coding standards and guidelines

Pervasive PSQL database has crashed and I need a DBA to import a table into Pervasive and export data to .xlsx DBA must use their own software as the PSQL is no more available to us

>Registrati o accedi per visualizzare i dettagli.

I am looking for an experienced developer to help me with writing web APIs and designing a product that can achieve optimized performance. Programming Language: .Net core Performance Requirements: - High performance is critical for the web APIs. Design Pattern/Architecture: - Preferred design pattern: Model-View-Controller (MVC) Ideal Skills and Experience: - Strong knowledge and experience in writing web APIs using .Net core - Expertise in designing products for high performance - Familiarity with the Model-View-Controller (MVC) design pattern If you have the necessary skills and experience, please submit your proposal.

Small C# asp.net core system I am looking for a developer to build a small C# asp.net core system. The system should have the following functionality: - Database entities using MySQL as the preferred database technology. - User authentication and authorization. - Integration with external APIs. For the front-end framework, I have a preference for C#. Ideal skills and experience for this job include: - Proficiency in C# and asp.net core. - Experience with MySQL database. - Knowledge of user authentication and authorization techniques. - Familiarity with integrating external APIs. Please provide examples of previous projects that demonstrate your expertise in these areas.

I am looking for a developer to implement access logging for my ASP.NET Core web application. The ideal candidate should have experience in the following areas: - Detailed logging: The access logging should include information such as user agent and request details. - Real-Time processing: The logging should be done in real-time, allowing me to monitor access to my application as it happens. - Advanced security: The access logging should provide advanced security measures, including IP address, user agent, and request details. If you have experience in ASP.NET Core and are familiar with implementing detailed, real-time access logging with advanced security measures, please apply for this project.

EMS File (Enhanced Menu System Configuration file) convert or change to a "UDS"file to be migrated into a Foxpro legacy software application

I am looking for a skilled Salesforce developer who can help me with data analysis and reporting using Salesforce Studio Analytics. I have data available for the project and I need someone who can analyze and report on this data within a week. Ideal skills and experience for this project include: - master in SAQL - knockout criteria!! - able to create a filter on periods for sales in a feasible way

This is a FIXED COST Project kindly those who wants hourly don't quote here or any diversion in the payment method either. Technology : + Angular + + SQL Server backend + Metronics Keen Theme What we required here: - One Time Cost that is mentioned in the each below pending Task. Kindly note payment upon completion of the below full task - Full Task List will be divided by Agreed Amount for each Task we will pay you - Source Code to be Check-in on Github daily bases and upload into our hosting server by the programmer - For Backend or FrontEnd the Developer will host the to the our server and give us the demo from our server his all the done job Angular with .NetCore Project Seeking Experienced Developer - Partially completed project with both front-end and bac...

build with HTML , CSS and JAVASCRIPT.

Database fed by c.50 excel-based models. Database to aggregate data, and summarise a range of outputs