SQL Jobs

Queries implementadas na linguagem SQL aplicadas no SGBDR Oracle, apoiadas no SqlDeveloper. Utilizar o MER Físico e BD Pedido disponibilizado para treinamento da disciplina de Banco de Dados.

Hi, I am looking for a freelancer to help me with my Microsoft Access database. Specifically, I need assistance with the structure of the database and intermediate level complexity. This project is to create reports from the database; managing customer data and tracking inventory are not part of this project. I am looking for someone who is experienced in working with Microsoft Access and is capable of creating a database that meets my goals. If this sounds like something you could help me with, please let me know. Thank you for your time.

need someone to fix a typescript and node js bug. can work via anydesk for entire project. long term project possible.

Responsibilities: Database Administration: Perform all aspects of Oracle database administration, including installation, configuration, monitoring, tuning, backup and recovery, and troubleshooting. Performance Tuning: Analyze database performance using various tools and techniques, identify bottlenecks, and implement necessary optimizations to improve system performance. Security and Compliance: Implement and maintain database security measures, including user access control, data encryption, and database auditing. Ensure compliance with data protection regulations and industry best practices. Backup and Recovery: Develop and maintain database backup and recovery strategies, perform regular backups, and test the recovery process to ensure data integrity and availability. Database Monito...

develop a menu-based console application for Internet Banking with .NET 7.0 written in C# using Visual Studio 2022 with an Azure Microsoft SQL Server database. Database access is to be implemented with and SQL using the package as the provider.

I am in need of a website that will help to showcase my company and its services. I need a multi-page website that is visually appealing and functional, with features like a portfolio, online payments, messaging, and contact forms. Additionally, I have ideas for branding that I would like to incorporate into the design of the website; a logo and color scheme that will help to identify the company and create a cohesive look. I am looking for a professional freelancer who has a great portfolio, experience designing websites, and familiarity with HTML and coding. The freelancer should be able to work with me to create a website that meets my needs and brings my ideas for branding to life. The website should be easy to navigate and understand, with clear indicators of what services I offer an...

DotNet developers required for Improvement Work in thenafter Host on server. Developers should also have knowledge about Synchronisation of sourcecode and database of his done-work with other developer's done-work on GitHub. 'Improvements List' explained in given video link at the end. Website address- User emailid- @gmail.c Password- kaspersky Link for Explaining 'Basic functionalities' video is below- Link for Explaining 'Improvements work to be done' video is below-

i have a table with FullName, Primary Key Unique ID, Email id and Sponser Id of each euser... its tree struture and 1 user can have many childs.. every child have parent... now i want stored procedure that will give me all members in tree of a particular person like list of members at first level, at second level, at third level and soo on....

I am looking for a skilled developer to help me link my SQL Server 2022 to Oracle Database 12c for a data migration project. The ideal candidate should have experience in: - SQL Server administration - Oracle Database Administration - Set up Oracle ODBC connection The goal of this project is to create a link between sql server and oracle so I can select data from a oracle database in SQL Management Studio.

I am looking for a freelancer to create a Power BI template for my business. The ideal candidate will have experience working with SQL databases and be able to incorporate this data into the template. While I have some ideas for KPIs and metrics to be analyzed, I am open to suggestions and recommendations. I prefer visualizations in the form of charts and graphs and tables.

From an existing code make some modifications below 1. Revise a string connection from front end (GUI) to config location, 2. attach exe file into an icon (able to click on an icon to run the application), 3. write out a manual instruction to build the application that only run dll for the application (other users can not see application source codes. 2. Set default Months in 4 textboxes once these are displayed showing the current month and last month. Other textboxes show current month and last 6 months. 3. Pull out data in a column from SQL server and make some if statements that will discuss in detail.

Identification Document and Agent Affirmation screens Please enter 3 pieces of identification. WebPicID needs 3 pieces of identification and an agent to affirm the new Member’s identity. The Agent is credited an Agency Fee for each Act of Agency. New Members can enter the ID details in text or Take Pictures of their ID. The Agent(must be 18+ years old) needs to look at the Pictures of the Id documents or Text and the original Id contents. Members can type in the information on the ID Document screens below. OR _Press here to select Picture input Then the primary ID picture input form appear. Canera feed Picture Take a picture Once we take a picture The agent fills out the type expiry date and serial number. We need a save and next button to save the picture. And Create a hidd...

I am in need of an Oracle APEX developer to create an application for me. The purpose of the application is for data management. I have a clear design plan in mind, so I need a developer who can work with my specific design. I require an intermediate level of Oracle APEX experience from the developer. Ideal skills and experience for the job include: - Expertise in Oracle APEX development - Ability to work with a clear design plan provided by the client - Experience in data management - Intermediate-level knowledge of Oracle APEX.

I am looking for a freelancer who can convert my Second Life Linden Scripting Language to PHP and MySQL. The specific task I need the scripting language to perform is data storage and retrieval. I do not require assistance with database design and setup, as I can set it up myself. However, I do need an intermediate level of PHP and MySQL expertise for this project. Ideal skills and experience for this job include: - Proficiency in Second Life Linden Scripting Language - Intermediate level of PHP and MySQL expertise - Experience with data storage and retrieval - Ability to integrate with third-party APIs as needed.

I am seeking an individual with expertise in Penetration Testing to provide ad-hoc services for my project. The specific area of my system that requires testing is Web Application Security. I am looking for someone who can work on this project on an ad-hoc basis. Ideal skills and experience for this job include: - Expertise in Penetration Testing - Knowledge of Web Application Security - Ability to provide ad-hoc services - experts with SQL inj If you have the skills and experience required for this project, please apply with your proposal. Thank you.

I am looking for a skilled developer to create a web-based Brick Carting Logistic Application with a regional scope. The ideal candidate would have experience with web development and an understanding of logistics operations. The application should include the following specific features: - Order Tracking: The application should allow users to track their orders from the point of collection to delivery. - Scheduling and Dispatch: The application should provide users with the ability to schedule and dispatch their orders efficiently. - Invoicing and Subcontractor payments Please submit a proposal if you possess the necessary skills and experience to create this application. Background. The customer is currently using an application developed in an old version of MSACCESS. The applicatio...

I am in need of a web developer who can assist me with creating a website that will allow me to send reminders to all my clients by triggering the date from an excel sheet. The website will require both frontend and backend coding, with the ability to upload excel data and send SMS reminders. Ideal skills and experience for this job include: - Proficiency in both frontend and backend coding - Experience with uploading and manipulating data from Excel sheets - Knowledge of SMS reminder systems - Strong attention to detail and ability to troubleshoot issues - Past experience with similar projects My budget for this project is less than $50. I am looking for freelancers who can provide detailed project proposals outlining their plans for successfully completing this project.

I am looking for a SQL Server expert to create a stored procedure that will send emails with Excel attachments. The data included in the attachment will be in raw format. I do not have any specific formatting or styling requirements for the attachment. The frequency at which the emails should be sent will be on a custom schedule. Ideal skills and experience: - Strong proficiency in SQL Server and stored procedure creation - Experience with sending emails through SQL Server - Knowledge of Excel and attachment creation - Ability to create customizable schedules for email frequency

I am looking for an experienced Azure Data Warehouse specialist to help build a comprehensive, Azure Data Lake Gen2, Azure Data Factory, Azure SQL DB ( data warehouse) solution using Contoso ERP Sample Data (for only HR). This project requires a great degree of analysis and technical understanding of the various Azure DWH components required to create the system, including data extraction, loading, and transformation. The successful candidate must have experience with creating and managing Azure SQL DB solutions, as well as Contoso ERP Sample Data (only HR). The individual should be familiar with generating reports, analyzing trends, and identifying correlations. This is a great opportunity for someone who is looking to develop their skills and expertise in Azure DWH solutions with a cl...

I am looking for a freelancer who can help me replicate a bar chart in SSRS Report Builder. The chart needs to be an exact replica of the original, which is currently sourced from a SQL Server Database. The ideal candidate will have experience with SSRS Report Builder and be able to replicate the chart with precision. Some additional details about the project include: I have attached images of the original chart and what the chart looks like currently in report builder. - Chart type: Bar Chart - Data source: SQL Server Database - Level of customization: Exact replication If you have experience with SSRS Report Builder and are confident in your ability to replicate this chart, please submit a proposal. Thank you!

As the manager of my organization, I have been tasked with setting up an HRMS system that caters to our needs. Our team consists of more than 100 employees, so getting the right system up and running is essential. The most important feature for this system that I require is an Employee Database since this would help us keep track of our resources and their information. No specific integrations are needed as we would prefer the system to be standalone and self-sufficient. With the right HRMS system in place, I am confident that it would greatly enhance our efficiency in managing the human resources of our organization.

Hello How are you doing? Hope you are well ! Am looking asp.net core using microservice with Angular if you are available please let me know we will discuss in detail. Project name : school management system Mentioned the technology is must. If you guys interested send me the praposal Thanks

I am looking for a skilled developer to convert my existing inventory system from Visual FoxPro 9 to Visual Studio 2019. The current size of the inventory database is small, with less than 10,000 records. I do not require any additional features in the new system, just a direct conversion. I prefer the new system to be developed using C#. The ideal candidate should have experience in converting Visual FoxPro to Visual Studio and proficiency in C# programming language. can used GPTchat .will provide the source code convert exisitng desktop inventory system using visual studio 2019 screen design will be provide with sql table feature add item menu with photo, transact in input via weight scale barcode printing , transact out via barcode scanner reports generation with excel export sending ...

I would like to create a website that users can use to search a data of various products that will match their individual circumstances and priorities. I intend on connecting the website to a CRM platform like HubSpot to manage workflow automation between the website users and the product providers. In the first instance, I only need to build a searchable database that can match the website users and their individual circumstances and priorities with a database of products that have their specifications.

I am looking for a skilled web developer to create a new e-learning website for me. The website should have more than 10 pages, and I am open to custom-built e-commerce platforms. The primary purpose of the website is for e-learning, so experience in developing similar websites would be ideal. like

I have a project in visual fox pro 9.0 and need to change a field from a visual fox pro form, change percent (receive 10%) to raw numbers, and finally add this as result and store in database, I need a guidance to achieve this. Let m clarify, I'm going to do it, but I need an expert in VISUAL FOX PRO 9, who connect to me via remote could be Google meets maybe or some tool like that, and who guide me through the process to achieve it.

** ONLY LOOKING FOR AGENCY WITH TEAM OF UX,BA,DEVELOPER BID WILL BE CONSIDER*** Field Service Management Subscription Software I am in need of a CRM with subscription capabilities for my field service management operations. The software should have the following features: - Scheduling and dispatching - Work order management - Inventory management Additionally, I do not require integration with any existing systems such as QuickBooks or Salesforce. The preferred platform for this software is web-based + Mobile. Ideal skills and experience for this job would include: - Proficiency in developing and implementing CRM software with subscription capabilities - Experience in field service management software development - Knowledge of web-based software development and deployment.

I need to integrate a Fantasy Football game into my existing friends and family chat app. The developer for this job will need to create VB.Net (VS 2012 or VS 2019 project) class/classes using http GET / POST using an existing API like Yahoo Fantasy Football API. The VB.Net app needs to comprehensively have all the API's functionality, from creating a league/joining a league to the end of who won/lost. The developer needs to explain the process of the finished app so that we are able to integrate that app into our existing chat app. The app needs to handle multiple users (1000's). My backend database is MS SQL.

I am looking for an AVEVA PI Systems Engineer to help with the support of our customers systems. We need support with various tasks related to the installation, configuration, customization, and maintenance of our PI system. The ideal candidate will have experience in all aspects of PI system work including new installs, upgrades, and ongoing support. We have specific requirements for the installation, and we need someone with experience in development, configuration, and maintenance to ensure the project is completed on-time and to our satisfaction. The timeline for this project is moderate, and we need it completed within one month.

I am looking for a software expert to develop a SQL server software for my electric vehicle (EV) charger system (we are currently a 3 guys-company). This software should have the capability to handle data analytics and reporting in real-time, detect and diagnose faults, and most importantly, have the ability to monitor more than 10000 chargers. The system should be a standalone system and requires no integration with any existing software other than import data/communicate with the chargers and output data (ie who has to pay how much) to interfaces of customer´s billing tools. Features are shown in the rules ppt, manager monitor in excel sheet. hosting on aws. I’m looking for someone who is passionate about doing an excellent job and has a thorough understanding of SQL server...

My company is looking for a reliable Power BI Developer to help us create visually appealing data models to analyze our data and to create dynamic and customized Power BI dashboards. Our purpose for using Power BI is to visualize our data for data analysis and forecasting, so interactivity is key. We will be using SQL databases as our main source for data, so experience with these technologies is essential. For the report/dashboard, we are looking for an advanced level of interactivity, with features such as filtering and sorting, drill down and drill through, and customized interactions and animations. If you think you have the technical expertise, experience and interest, please apply for this project. We look forward to hearing from you!

Project Title: Retail Management System POS /Dot NET with SQL server database I am looking for a freelancer who can create a retail management system POS for my retail store. The ideal candidate should have experience in developing POS systems for retail businesses. Features: - The most important feature for my POS system is inventory management. I need to be able to track inventory levels, set reorder points, and receive notifications when inventory is low. - I would also like customer management features, such as the ability to create customer profiles and track customer purchase history. - Reporting and analytics are also important to me. I need to be able to generate sales reports, track employee performance, and analyze customer behavior. Integration: - I need integration with acco...

Need someone who can audit SQL Server Databases and provide an audit report. Details: The Scope of work, requirements & deliverables from the Freelancer of Work: The freelancers will be responsible for the following tasks: a. Analyzing the database structure, including tables, indexes, and relationships. b. Reviewing and evaluating security settings, including user access permissions, roles, and authentication methods. c. Assessing the performance of the databases, identifying any bottlenecks or inefficiencies, and recommending improvements. d. Verifying compliance with SQL Server best practices, including naming conventions, data types, constraints, and indexing strategies. e. Identifying any potential data integrity issues or vulnerabilities. f. Reviewing storage including hard dis...

Convert static website to dynamic using PHP - The website was created using HTML/CSS only - Looking for a developer skilled in PHP to do the conversion - The goal is to add e-commerce functionality to the website - Prior experience with e-commerce development is required - Must be able to integrate payment gateways and shopping cart systems - Knowledge of SEO optimization for e-commerce is a plus

I am looking for a freelancer who can assist me with fixing the schema errors and running queries for my MySQL database. As I do not have an existing database schema, I need someone who can work with my rough idea and create a well-structured schema. Ideal skills and experience for this job would include proficiency in MySQL, strong understanding of database design and schema creation, and experience in database management systems. The goal of this project is to improve website performance by ensuring that the database is well-structured and optimized for efficient querying.

Looking for an experienced EPICOR specialist to help with customization for our business. The project timeline is more than 4 weeks, and the ideal candidate should have the following skills and experience: Understanding employees requirement and making a report Building SQL query Building reports using SSRS reporting Understand Sales and Purchase process and develop salesforce as per process Train employees for Epicor/salesforce Resolve the issue by coordinating with Epicor/salesforce support This would be a part-time position as a starter and we will see how it goes to transition to fulltime. Please send a cover letter and your updated CV/resume.

I am looking for a freelancer to assist me in automating my travel agency. The specific tasks I need to automate include booking flights and hotels, scheduling tours and activities, and managing customer data. Currently, my system for managing travel bookings and customer data is a basic Springboot based Miniproject. I am looking for someone who can make basic changes in code and UI only for the user part. The timeline for completing the project is urgent - within 1 month, and I would prefer to have it completed today or tomorrow. The ideal freelancer for this project should have experience in coding, UI design, and automation.

I am looking for a skilled database developer who can optimize my MySQL query or index the database to improve performance. The database is currently 1.3GB in size and is used for transactional processing. There are specific tables and queries causing performance issues that need to be addressed. The specific table is approx 200k rows. The query is fairly simple but taking 10 seconds to complete, and it needs to be closer to 1 second. I can provide the exact table structure and the query, but not actual data. The database is hosted on a normal windows machine. Ideal skills and experience for this project include: - Advanced knowledge of MySQL database optimization and indexing - Experience working with large databases - Ability to identify and troubleshoot specific tables and queri...

I am looking for someone to help me install phpMyAdmin and restore my SQL dump. I currently do not have a web hosting service set up and would appreciate recommendations. The project requires proficiency in PHP and only basic setup customization is needed for phpMyAdmin. Ideal skills and experience: - Proficiency in PHP - Experience with installing and configuring phpMyAdmin - Knowledge of SQL dump restoration - Familiarity with web hosting services and recommendations. and mysql and restor mysql dump as well 4-5 files

Looking for a skilled Golang developer to help with both new and existing projects. Specifically, we need assistance with backend development tasks. The ideal candidate will have experience with API development and web development. We have an existing codebase that needs to be maintained and optimized, as well as a new project that requires development from scratch. The expected timeline for the project is more than 4 weeks.

I need help with writing and solving some problems connected to SQL and ER model relations.

I am looking for a freelancer who can feed the product similar to older website in my newer new website will be built using Active Ecommerce CMS. Older Website: New Website: Check the product sheet here: Weight Attribute is created already in New Website. Shade Attribute has to be fed in new website. And Product Description to be copied from older website, images wherever required will be provided in zip or drive folder.

Hi I need support oracle database for my consultant like Indian time 8:30 pm to 10 pm 11$/hourly. Payment every Friday. This support will be on zoom meeting which we will provide you and you will connect with my consultant and support him.

I am looking for someone who can develop a forex / crypto signals platform where users would sign up for subscription which admin can set up in back end and users subscribe and received X amount of signals per day via WhatsApp, Email, Telegram, or SMS. The platform will be web based and users should be able to view charts on the platform too. Payment gateways: Stripe / PayPal Any experience in similar projects would be advantageous.

Job Description: Database Engineer (Informatica/ETL) We are seeking a highly skilled and motivated Database Engineer with expertise in Informatica and ETL (Extract, Transform, Load) processes to join our dynamic team. As a Database Engineer, you will play a crucial role in designing, implementing, and managing our complex database systems, ensuring optimal data integrity, performance, and security. You will collaborate closely with cross-functional teams to deliver scalable solutions and contribute to the success of our organization. Responsibilities: • Design, develop, and implement efficient and scalable database solutions using Informatica PowerCenter and other ETL tools. • Perform data extraction, transformation, and loading (ETL) processes, ensuring the accuracy and integrit...

I am looking for a freelancer who can help me with my SQL dump to Excel project. The SQL dump file size is medium, ranging from 50MB to 500MB. I would prefer the Excel output to be available in both CSV and XLSX formats. Additionally, I require specific data filtering and sorting in the Excel file. The ideal candidate for the job has experience working with SQL dumps and Excel, and is proficient in data filtering and sorting. If you have the necessary skills and experience to complete this project, please submit your proposal.

I am looking for a skilled developer to work on a legacy Visual Basic 6 (VB6) desktop GUI VB Form project with database access. The primary purpose of the VB6 desktop GUI form is data entry. The project requires working with an existing database structure, which is already set up. The database system being used is Oracle. The feature of the desktop application GUI is to modify a few fields in a DB table (less than 10 fields), keeping the access logs. There is already an existing VB desktop application with source code, the task is to add additional GUI access VB Form for the above mentioned data access. Ideal skills and experience: - Proficiency in VB6 desktop GUI form development - Familiarity with Oracle database system - Ability to work with an existing database structure - Experienc...

I am looking for a skilled developer to create a web portal that will analyze sales data in real-time. The portal will need to have the following features: - Real-time data updates - Data visualization - Customizable reports The portal will only need to be accessed by less than 10 users. The ideal candidate should have experience in web development and data analysis. They should also have knowledge of data visualization techniques and the ability to create custom reports. There are around 100k rows of data all stored in a SQL server.

I am in need of an experienced Oracle DBA with expertise in Golden Gate configuration. I have an existing Oracle database that requires Golden Gate configuration. The task is of medium priority and needs to be completed within a reasonable timeframe. The ideal candidate should have experience in Oracle Enterprise Manager (OEM) setup and be proficient in Oracle database administration. Key requirements for this project include: - Oracle DBA with experience in Golden Gate configuration - Familiarity with Oracle Enterprise Manager (OEM) setup - Strong knowledge of Oracle database administration - Ability to work within a medium priority timeframe

We have a database of 1.4 millions names and we process 14 millions search every year. Our results are very basic and we have a lot of false positive. We need to implement the new features of Solr 9.x. Our front is in Java. Sugester Re-ranking Highlighting Faceting