SQL Jobs

I need help with a MS access database that has already been created. the data base is about product suppliers and products. Some products are suplied by many suppliers and one supplier will have many products. the goal is for me to easily compare the price of single product from various suppliers so that i can select the supplier. i have already created this database but want a professional to have a look at this and provide the following improvements. I want to enter data about new products from the products table. From the products table, if i need to enter a new supplier information, i should be able to do it from this table also. i have uploaded a relationship diagramme. the data base will be send to the selected freelancer

I'm looking to hire a savvy website developer to help me build an e-commerce website. I'm not sure if of I need a content management system for this, so I'm open to suggestions and advice from experienced professionals. On top of this, I'd like to explore the possibility of websites specialized features that could take my project from ordinary to extraordinary. I'm excited to see what creative ideas potential freelancers may have, and I'm looking forward to getting started!

I am looking for programmer that knows Azure, SQL, and the skill to assemble a platform from several integrated programs.

pls assist in code in sql as per requirements

-Produce a SQL query about how to extract a report on Adult's shoes performance for the date range 26th-30th -Produce a SQL query about how to identify the top 5 products by revenue for each gender SQL Query: Using the “with” construct, write a query to pull the necessary data from the tables performance data and product data (attached). Joining and aggregating the data together and filtering to match the conditions, there is not access to database. So, it is approximated, not need to validate it.

I'm looking for an experienced Power BI expert who can help me with a proof of concept task that I need to have completed as soon as possible. This project will involve designing a fully functional analytics platform with Power BI. I have intermediate experience with the tool, but need a skilled professional to help me achieve my vision. I need this project completed ASAP. If you have the skills and the availability, please reach out and let me know. I look forward to hearing from you.

The development is already done and there are small methods, need to write unit tests for each postgresql, python, sqlalchemy, pytest skill required

I need help with using sql and Tableau particularly debugging the count from sql to Tableau. I am familiar with the concepts and just need someone to help me execute them. If you have expertise in this area, I would love to have your help.

I need a database for a startup company for grain storage. I need it to track each customers unloads and outlays, tonnage, what grade it is, send invoices etc. no preferences on the programming language but would need to be easy to use

I am looking for an expert consultant to help me with modeling and normalization for my relational database. I need help with design enhancements and optimization, but do not need help populating the database. Additionally, I am also in need of additional consulting services to ensure that I have a fully functional, properly designed database. The consultant should have extensive knowledge and experience in relational database modeling and normalization, as well as the ability to identify and evaluate changes that should be made to improve design effectiveness. Strong understanding of relational database concepts: The freelancer should have a solid grasp of the principles of relational databases, including tables, primary and foreign keys, relationships, and constraints. Database modelin...

Hello, We have setup a replication from MSSQL to MySQL. SymmetricDS auto creates the schema, but one table in source (MSSQL) contains trailing space => 'Artikelnr '. This gives an error with MySQL. This project is about fixing this issue so it automatically corrects it and creates the table. <!DOCTYPE database SYSTEM ""> <database name="dataextractor"> <table name=""> <column name="Artikelnr " type="VARCHAR" size="50"> <platform-column name="mssql2016" type="varchar" size="50"/> </column> Must be future proof so no one time manual fixes. A pastebin log file can be supplied for more info.

I am looking for an expert in coding SQL to help with a project. Specifically, I need help with debugging existing code, creating stored procedures and working with a MySQL database. The ideal candidate should have extensive experience in coding SQL, including working with databases, debugging code and writing stored procedures. An aptitude to problem solving is also essential.

Hi, I have multiple projects which is based on .Net. Interested person only contact me. Details will be shared with the selected candidate. Regards, Dipak

.NET MVC 5 ile yazılmış (Veri tabanı: MSSQL) Ecza deposu ERP programımızdan, 4 adet eczane otomasyon programına E-fatura iletmek için Web servisi yazdırmak istiyoruz. 4 adet eczane otomasyon programının url'lerini belirtiyorum. 1) 2) 3) 4) * ERP programımızdan bu 4 adet eczcane programı ile uyumlu, E-fatura aktarımı yapabilmek için web servisi yazılmasını istiyoruz

As per our project scope, we need to save the data from the primary server to the secondary server. However, In the secondary server, the field of date-time is considered the same server system date-time. According to the requirement Need to pass the value of date-time parameters from the primary to the secondary server. Find strings in multiple tables of the Database. Hence, I would like to request you please do the needful for the same. please let me know if you have any concerns.

I am looking for someone that is an expert at creating Dev Express Reports with the Report master tool. I have existing software that is written with Dev Express C++. Some of the reports have already been created. These reports would just need to be modified to a more modern look. I would also like to talk about adding more reports if possible. If I choose you to work with this is how it would work. I would send you a copy of the software, You would go to the admin>reports and create 1 report. You can export the database and send it to me to load on my software. I can review the report to see if it is what is needed. Please only reply if you have experience in this type of work. Give me an estimate to upgrade 1 existing report.

30,000 Foot View On Air: At Air, we are obsessed with creating magical products that will make our future grandkids proud and that cause our customer’s faces to light up. We are currently working on a suite of products that help businesses scale rapidly… from a fintech platform that facilitates high ticket purchases, to a conversational AI that can have full-blown 25 minute sales calls and is indistinguishable from a human. Because of our customers' love for our products, we’ve generated $9.7MM+ in revenue since launching Air 71 days ago ($50MM/yr pace w/o a dime of VC capital) What We Are Looking For: We are looking for a general tech wizard to help with a ton of different special projects. You'll be working directly alongside the co-founders solving challeng...

Module Learning Outcomes The following LOs are achieved by the student by completing the assignment successfully 1. Evaluate techniques used to ensure security in a database-oriented information system. 2. Manage user access and user profiles within a complex and DBMS. 3. Conduct database audit. Assignment Objective 1. Understand the security attacks in the database. 2. Create database security auditing plan. 3. Implement user management controls to achieve security requirements. Write assignment

Hello I need mysql expert within DB and hosting.i have files,i will share it .it is simple work if you are check and solve my problem. Thank you

SQL - EXCEL Link for Navision General Ledger Entries with Balance and Full Record I need one excel file with SQL link to Navision and full scope General Ledger Transaktions

Description on document attached.

I'm looking for an experienced professional to build a school management system that focuses on student database management. The system should store student records and be designed with the ability to interface with any existing school systems in the future. It is important that the system is secure and organized, designed to provide seamless data access and tracking of student information. I'm looking for someone who can implement efficient processes to facilitate quick data input and retrieval, ensuring that all stored information is accurate and up-to-date. The developer should have extensive knowledge of database design to ensure functionality and optimization for the system.

Build a chatbot to teach various data engineering concepts. The topics of teaching include SQL Programming, Data Modeling, Data Visualization, ETL, Data Analysis, etc. Details on what each concept should cover will be provided. The responses should include videos, code snippets, etc. The objective is to build a chatbot to make learning complex topics simple. Need the ability to scale the bot to add new topics in the future, like Data Science, Statistics, etc. Finally, looking to build both a web page and a mobile app for the chatbot, but can focus on the web page to begin with.

We have a MySQL DB, hosted on web server with Cpanel (phpmyadmin available) we need to make some optimisation and define some helping tables and views (all database is less than 10 tables) We should also define a periodic routine to take data from one table and translate it to other table inside the DB. Please bid if you have Vast experience with MySQL DB This is first job we will need in this DB, its a couple of hours work, Budget is 70$ for this project, we would like to work with a good supplier further more on our DB issues. Good Luck

The project is written in C# (Microsoft Visual Studio 2013 or Its later version) as front end , Microsoft SQL Server database as back end with Crystal Reports. I would like to make some modifications to the program 1- The product number (or any way to protect the program from copying on multiple computers). The goal is to activate the product on one or two computers so that the program does not work when copied by the customer to another computer. 2- Print invoices after the sale process via a thermal printer with a printer selection page and print paper settings 3- Modify the barcode printing page and make it possible to choose page dimensions and printer type 3- Adding the feature of selling by installments (payment in stages, such as every month or date, when the customer pays part ...

I want to stored a trained .h5 model in SQLserver and be able to use it to predict future data

Hello everyone! I am currently looking for a developer for a FiveM project in an associative declaring structure. I suspect that DEVs are a rare commodity, but I take the liberty of throwing a bottle into the sea which, with luck, will find a recipient. I'm looking for someone with experience who can get involved over the long term, see very long term! Remuneration is of course considered, our association would like an estimate on the project in view of these ambitions Thank you for your attention and see you soon, my PMs are here for more explanations!

I want to implement SSRS and integrate with my web based application

Oracle SQL Tuning, Tuning 4 oracle Exadata queries that's taking 3-4 minutes to run to make it to run in less than 30 seconds.

Need a simple Access UI to connect to the back end sql server databases using 1) ADO Connection 2) Ability to Save the connections in the Local Database 3) Data Select and DML operations 4) Pass Through Queries Execution

I am looking for an experienced Data Warehouse Consultant with banking knowledge and experience to provide Ongoing Support for a project I am working on. I have selected the SQL Server platform but it is not absolutely necessary should you have other options that can serve my needs better. I am aware that regulation in the banking industry may be an issue, but for this particular project, no specific regulations are necessary. This is an ongoing support role and looking for someone who can provide expertise and insight into the design, development and maintenance of the data warehouse.

In line 144: SQLSTATE[HY000] [1040] Too many connections In line 128: SQLSTATE[HY000] [1040] Too many connections

One of our clients has many Access 2003 databases which they have adjusted many times. They would like to make some changes to these 2003 Mdbs and after all of their 2003 Mdbs have been adjusted they would like to upgrade all of their difference Access database to Access 2007.

I need a ColdFusion programmer who can administer and maintain a legacy CF application currently using CF 10, SQL Server 12, and Dreamweaver v11 (or a different type of application interface, if desired). The application needs to be set up in a sandbox on the development computer. Maintenance requirements are minimal and involve updating CF HTML primarily with little or no programming. After the goal listed above is accomplished, we will entertain a quote to upgrade the application to current versions of CF and SQL server.

Hi, I have an existing application which is developed on .Net 4 and we are planning to implement the new design/Theme based on the existing code. Detailed discussion will be done with the interested candidate. Feel free to contact with me. Regards, Dipak

I have a current project and i want to set it up on local pc and link to sql and php api so that i can work and debug locally.

I have an sql server which i pull service-related data from in power bi. its all organized in tables now. im looking for a person who can zoom call IMMEDIATELY right now for maybe an hour or two. Open to pay negotiations if you can REALLY help me. must know at least dax.

I'm looking for experinced .Net Developer based on Egypt to provide support for existing applications for 2 weeks only. - 5 Yrs plus in MS Technology, SQL/C#/JS/SSRS

Hola! La web es: Parece que tengo un virus o algo funcionando mal (No debería ser porque no tocamos la web) lo que sí es que derrepente te sale la pantalla de terror: "Error al establecer conexión con la base de datos" Además que se usa 15GB de RAM, 50% o más del disco de un MEGA servidor de Clodudways que NO es compartido, osea sólo nuestro.. Y está re lento al buscar pedidos, o cualquier cosa literal. Aparte quiero: 1- Saber que ocurrió. 2- Si es un VIRUS, las mejoras para que ya no suceda. 3- Mejorar velocidad de la web en general como administrador y también como cliente.

Our company is currently seeking a skilled Tableau Developer and Power BI Expert to join our team. As a data visualization specialist, you will be responsible for developing and implementing visualizations, reports, and dashboards to help us gain valuable insights into our data. Responsibilities: Design and develop data visualizations using Tableau and Power BI Create and customize dashboards to meet business requirements Generate reports and automate report generation processes Analyze data, create data models and integrate and transform data from multiple sources Optimize performance and troubleshoot issues Collaborate with stakeholders to identify business needs and design solutions Requirements: Proven experience in developing visualizations using Tableau and Power BI Strong knowled...

Hi, I need your help to optimize SQL Server performance issue.

My project is a spam classifier system built with a serverless platform and using a Naive Bayes algorithm. We are looking for an experienced developer to create the system using Python. The serverless platform will make the system highly scalable and cost-effective, while the Naive Bayes algorithm will maximize accuracy and speed in detecting potential spam. The engineer will be responsible for designing, building, and testing the system, using Python and any necessary third-party APIs to ensure proper functionality. Additionally, they must ensure that the system works seamlessly with the existing systems and data sources. We anticipate this project will take a minimum of two weeks to complete, depending on the complexity. As appropriate, the engineer must document their code and provide...

I'm looking for an experienced professional to help me with a SQL + VB.net project. The main language for the project will be SQL and I am unsure if I will need help setting up the database. User interface design assistance is not needed, but I am open to suggestions from the successful freelancer. The project requires knowledge of the latest SQL coding techniques, as well as experience working with VB.net and developing user-friendly interfaces. Successful completion of this project demands a high level of organisation and communication between invited freelancers and me. If you have the experience and skills, please consider bidding on the project.

We are looking for a simple "CRM like" asp.net based web page/application with user logins. Application should read & write data into a database i.e. view, modify & create entities. For starters, entities will be Customers, Projects, Users. Database model will be provided as a part of specification. Application will be hosted on azure web app service. Branding and visual "eye candy" is out of scope. Application needs to be created & written in a sense that it can be easily scaled up.

Looking for Remote - Power BI Developer - Full time Contract Experience - 10-12 years Job Description: Power BI Dashboards(MOQ, Retail, Camp Master, P&L), • Yardi Orion BI Dashboards(on SQL DB) • MOQ – POS Connectivity for New Tenants on .NET based Program. • Other Automation Programmes Support to the RPA Specialists Must Haves • Advance SQL query writer, tsql, ddl,dml • Power bi , DAX ability, • API read and write information, (postman, etc) • Basic C#, Python read and understandable

Se necesita que se relaice lo siguiente Boton de eliminar no elimina (solamente funciona en categorías) -no muestra usuarios, empleados y clientes una vez que se agregue uno nuevo de cada sección. -debe de tener un lector de códigos barras para los productos. (los productos una vez pasen por el lector muestre el producto) -realizar corte de caja diariamente semanal y mensuales de las ventas -realizar un reporte de ganancias de las ventas realizadas..

Here's a simple flow leading form a mobile base in website.i have sample.i need database also.

I'm looking for an expert DBA to help with a project related to moving data from an existing MySQL-based database to a new database system. Both database have different structure, table and datatype. I'm looking for someone with experience and expertise in MySQL, as well as a strong knowledge of best practices when it comes to data migration. Ideally, the candidate should have experience working on project-based tasks and be able to provide clear timelines for completion of the project. If you think you would make a great fit for this project, please don't hesitate to apply!

I need to move data around from an existing database into other databases and api sources

I am looking for someone to help me with a project involving sql (Structured Query Language). I don't need help writing a query, but I don't have an existing database nor do I have the structure set up. I also do not need help creating stored procedures. The project does not involve any of these tasks. I simply need somebody to help me with sql for a particular project.