Sql mdbงาน

I have two DBs in MySQL. I need the "source" DB to match the "target" DB's structure. There are a few columns missing, but I don't know how many. There are 300 tables, but the first half are OK. I will send the structure of the two and you provide the SQL to run to adjust the "source" so that it matches the "target" Project will only be FINISHED once I can export data from source and import successfully into target. Data will not be provided, as it's confidential.

...experience (3+ years) in C# development, including strong knowledge of the .NET framework. • In-depth understanding of software design principles, design patterns (such as MVC, MVVM, etc.), and their practical application in real-world scenarios. • Solid understanding of object-oriented programming concepts and techniques. • Proficiency in working with relational databases and writing efficient SQL queries. • Experience with web development frameworks and technologies such as ASP.NET, HTML, CSS, JavaScript, and frameworks like Angular or React. • Familiarity with source control systems (e.g., Git) and agile development methodologies. • Strong problem-solving and debugging skills with the ability to analyze complex technical issues and provide effecti...

I am seeking an experienced web developer proficient in SQL and PHP to create a new web application from scratch. Key responsibilities include: - Understanding and implementing the functional requirements of the project. - Designing, coding, and testing the application. - Ensuring the application is robust and easy to maintain. The ideal candidate should have: - Proven experience in SQL and PHP - Knowledge of web development best practices - Ability to create a clean and efficient code.

Hello there! My name is Jalindhar and I am a Python engineer with 1 years of experience. I understand that you are looking for someone to develop a backend and frontend development for existing webpages and I believe I am the perfect person for the job. I specialize in building complex software applications using Flask, HTML,MySQl,SQl,Javascrip,CSS, Python,Django and other relevant technologies. Additionally, I have extensive experience in data engineering/ machine learning /internet research / web search / databsees/ social networks integration I am available 24X7 via freelancer messenger if needed. Additionally, I have delivered many projects in a ZIP file format

...and efficiency. Skills Minimum of 5 years of experience of web development with React, coupled with a thorough understanding of its core principles. Experience with React Native is desirable. In depth knowledge of AWS services and infrastructure management. Familiarity with using Adobe and Figma wireframes and design files. Excellent HTML/CSS/JavaScript skills. Excellent DB and RDMS skills with SQL and GraphQL. Postgres experience is desirable. Experience of designing, developing and integrating with RESTful APIs. Knowledge of modern authorization mechanisms, such as JSON Web Token. Familiarity with modern front-end build pipelines and tools. Familiarity with common programming design patterns and best practices. Experience with common web development tools and services, such a...

I am looking for a Node/React developer who can generate PDF exports based on an SQL database. The project requires custom styling and design for the PDFs. Skills and experience needed: Proficiency in Node.js and React - Strong knowledge of SQL databases and query optimisation - Experience with generating PDFs - Ability to handle multi-table joins in SQL queries for data retrieval The ideal candidate should have experience in designing and styling PDF exports, as well as expertise in retrieving specific information from a database and displaying it using line charts and pie charts. This report will need to have variations based on data within the database. Relevant information will be provided to the successful person. A basic interface will be provided that will p...

As Group CFO of a thriving retail/fashion company, I require a highly experienced freelancer to take on a PowerBI project. This role, potentially long-term, involves key tasks such as: - Building a well-structured and functional PowerBI from scratch. - Linking PowerBI to diverse data sources including Excel Spreadsheets, SQL databases and Cloud-Based Databases. - Executing data visualization, cleaning and manipulation, and data modeling. - analysis of data. The ideal candidate should have advanced/expert skills and experience in handling PowerBI reporting and data-related tasks, particularly in the financial sphere. Being in a timezone close to DK time would be beneficial. Your understanding of finance should be solid and your ability to produce analytical insights, robust. if yo...

Laravel building fuction query change to my sql

I am looking for a freelancer to create a server and RDS monitoring dashboard for me. I currently do not use any monitoring tools and would like to have a custom-built tool specifically for monitoring CPU usage. The monitoring data should be updated every minute. Skills and experience needed for this project include: - Strong knowledge of server and RDS monitoring tools - Experie... Skills and experience needed for this project include: - Strong knowledge of server and RDS monitoring tools - Experience in developing custom monitoring dashboards - Proficiency in capturing and analyzing CPU, Memory, Network Traffic usage data - Ability to update monitoring data in real-time or at frequent intervals Our current environment details 1. Server : Windows and Linux 2. RDS : MS SQL and ...

I'm seeking a freelancer with targeted experience in HTML, Python, and SQL for a series of minor tasks. Each of these tasks will revolve primarily on these programming languages: Please note, that the budget is set at $40, making it approximately $3.3 per task. This project is ideal if you're seeking a quick job as it's set to complete within 3-4 hours. Only reach out if you're comfortable working within the stated budget. Ideal Skills & Experience: - Proficiency in HTML, Python & SQL - Web development experience, particularly in HTML - Experience in managing and manipulating database using SQL.

I am currently in search of an experienced professional with a strong background in SQL and Power BI for a critical task related to my office job. This is a one-hour task that requires a high level of expertise and precision. Requirements: • Extensive experience with SQL databases, including writing complex queries and database management. • Proficient in Power BI, including data visualization, report generation, and dashboard creation. • Ability to quickly understand and interpret business requirements to deliver accurate results. • Excellent problem-solving skills and attention to detail. • Good communication skills and the ability to work under tight deadlines.

Laravel Query Convert to My Sql Query

ESP32 with Mic Voice to Text Integration and Real-time Text Content Updates to SQL Database/Server - I am looking for a skilled developer who can integrate the ESP32 module with a microphone to convert voice input into text. - The preferred method of voice input is through a microphone. - The converted text content needs to be sent to a SQL database/server. - The text content updates should be in real-time, ensuring immediate and continuous data synchronization. - The ideal candidate should have experience in ESP32 programming, voice recognition technology, and SQL database management. - The project requires strong knowledge of mic voice to text conversion algorithms and SQL database integration. - The ability to develop a reliable and efficient real-time data ...

I'm in need of a highly experienced MS SQL Database Administrator. The ideal candidate will possess: - A minimum of 10 years' experience in MS SQL – DBA - A strong proficiency in database management, query optimization, and database schema designing - Excellent skills in MS SQL Server Please note: - This work can be performed remotely, however it's essential that you're based in India - You will be compensated on an hourly basis - The engagement will be project-based A strong track record in similar roles and the ability to meet deadlines efficiently will be highly regarded.

Are you a Python Developer with expert level experience? We are looking for someone to assist us with web development tasks using the Django...Developing and maintaining web applications using Python - Implementing and customizing features within the Django framework - Optimizing website performance and ensuring scalability To be successful in this role, you should have: - Expert level experience with Python - Strong understanding of the Django framework - Proficiency in HTML, CSS, and JavaScript - Experience with database management and SQL - Knowledge of version control systems, such as Git If you have a passion for web development and are an expert in Python, we would love to hear from you. Apply now and showcase your skills in creating robust and efficient web applications usi...

I require a meticulous Android developer skilled in Kotlin to turn my vision of an accounting app into a reality. Although the specifics of the functionalities weren't pointed out, the primary purpose of the app is for accounting use leveraging the power of Cloud SQL. Ideal Skills: - Proficient in Kotlin programming language - Familiarity with Android SDK and different versions of Android - Experience with Cloud SQL - Understanding of material design principles and interface guidelines - Diligent with a keen eye for detail - CRUD Application Requirement: To evaluate your competency for this project, kindly provide examples of past work relevant to this project while applying. I'm mainly interested in seeing your experience with Kotlin as well as your ability to ...

PHP Symfony -Moduł dla systemu analizującego dane pobrane z api różnych platform. Firma Serini poszukuje programisty: Oczekiwania co do technologii : PHP 7-8, PHP Symfony 5-6, jQuery, javaScript, Doctrine, SQL ,git Standardy programowania , Umiejętność pracy na oprogramowaniu Jira Dodatkowe (mile widziane) : CSS, HTML, Ajax, integracje api , Sprgn MVC, java od 1.8 Rodzaj pracy: zdalna, elastyczne godziny pracy Sposób pracy :umowa B2B, zlecenia stałe rejestrowane godzinowo przez oprogramowanie Jira. Opis zadania : Zadanie będzie polegało na wykonaniu modułu do prezentacji i zatwierdzania danych pobieranych przez api różnych platform np. Amazon , eBay itd. a następnie przedstawieniu ich w formie wyliczeń lub wykresów na systemie serini-cloud. Zadanie...

I am looking for a skilled developer who can create a script to merge two sqlite databases of the same structure. The ideal candidate should have experience working with sqlite databases and be proficient in scripting languages such as Python or SQL. The primary purpose of the merged database is to migrate data from two separate databases into one. The script should be able to merge the data from both entries into a single entry, ensuring that no duplicate entries are created. The database contains about 20 tables with many relations between tables. I can provide the database schema diagram to anyone that messages me. As for specific requirements or preferences for the script, I am open to suggestions. I would appreciate any recommendations or expertise the developer can provi...

Overview: As a Marketing Analytics Assistan...related field. Basic understanding of marketing concepts and analytics. Proficient in Microsoft Excel or other spreadsheet software. Strong attention to detail and organizational skills. Good communication skills and the ability to work in a team. Preferred Qualifications: Internship or coursework in marketing analytics or a related field. Familiarity with data visualization tools. Basic knowledge of SQL or other data querying languages. Eagerness to learn and grow in the field of marketing analytics. Salary The salary for this position is negotiable and will be commensurate with experience and qualifications. How to Apply Interested candidates should submit their resume and a cover letter detailing their relevant experience and quali...

Need a programmer to pull data from MS SQL view to export it to XML. We have seperate view for the header and separate view for the invoice lines.. We have to provide XML to to TAX office. Save the uploaded invoce data in a ms sql table with the result. invoice id, error messege or ok, timestamp

Es un proyecto de mantenimento de un desarrollo en Collective Access, donde es necesario el apoyo tecnico para un desarrollador con conocimientos importantes de php, javascript, html, sql, pero sin conocimiento especifico de Collective Access. El conocimiento previo de Collective Access es indispensable.

I'm in need of an experienced Oracle SQL developer with 5 to 10 years of expertise for a large-scale project. The tasks include: - Data Modeling - Query Optimization - Database and SQL Query performance tuning. My project specifically needs a professional familiar with Oracle 19c. If you're experienced in this area, I would be interested in learning more about your skills and how you could contribute to the success of this project. Ideally, your portfolio will demonstrate previous large projects handled with efficiency and effectiveness.

other than this topic FOOD DELIVERY SYSTEM FAST FOOD SELF-SERVICE ORDER SYSTEM STUDENT MANAGEMENT SYSTEM CAR RENTAL SYSTEM CAFE MANAGEMENT SYSTEM HOSPITAL MANAGEMENT SYSTEM FOODTRUCK ORDER SYSTEM STAFF MANAGEMENT SYSTEM TASK MANAGEMENT SYSTEM ZOO MANAGEMENT SYSTEM STATIONERY RETAIL STORE MANAGEMENT SYSTEM suggest a ...MANAGEMENT SYSTEM STATIONERY RETAIL STORE MANAGEMENT SYSTEM suggest a topic! Project scope: 1) Minimum of THREE (3) OOP concept: a) Inheritance b) Polymorphism c) Interface d) Abstract 2) Java Collection: List / Set / Map 3) GUI 4) Exception Handling (Create your own) 5) Connecting to database (Insert, view, search, update, delete) submit: 1) UML diagrams 2) Source code (.java) 3) Database (.sql) 4) Deliverable 5) Task distribution (.xls) – name, matric nu...

We are looking for a . Net Developer with min 5+ of experience, for 06 months contract, who can support us...configuration of existing systems, new package/system evaluation, back-end and front-end development. Nice to have 1-year experience on Angular 2+. Nice to have experience working with MS Azure. C#, Web API Web service .NET core .Net with Web API C# LinkQ Entity framework 6.0 Mock unit testing .Net Framework 4.0 and above, Visual (2019) SQL Server 2016 and above HTML/CSS, AJAX, jQuery, JSON, JavaScript GIT repository, BitBucket SSIS (SQL Server Integration Services) packages Experience working in Scrum teams Familiar with Design patterns. Hands on experience with design pattern will be plus. A Good understanding of OOP principles A good understanding of N-tier archi...

We are looking for a Full-time Data Engineering Experts ( min. experience 5-15 years) with the following skills and experience: Skills: - Proficiency in Python - Strong knowledge of SQL - Familiarity with Big Data technologies - Snowflake experience is a plus Ideal candidate: - Has experience in building data pipelines - Can efficiently clean and process large datasets - Can create a robust data infrastructure Scope of the project: - Data cleaning and processing

This is a JOB SUPPORT ROLE Exp - 7+ years of exp in sql developer specially in Azure, Python and Dynatrace/Splunk Basic React 5 days in a week [Removed by Admin] Remote support role You will have to help developer for completing the task Timings - 8:30 to 10:30 am IST (or evening IST) Payment - You will be paid for those hours while you will be working, You will be informed in advance if there is no work and for those hours you will not be paid. Budget = 500 INR /hr I'm seeking an experienced Python and Azure-Splunk developer to monitor and analyze transaction logs in my application. - Primary responsibilities include: - Implementation of a Python script for data extraction, transformation, and analysis - Using Splunk to monitor application logs, specifically focusing ...

...API keys, and accordingly funnel this data into a SQL Server database. The main purpose of this task is to facilitate database integration. It's important to note that an example of a working API from another company that fulfills a similar task will be provided for guidance. Ideal Skills and Experience: - Expertise in API development and integration - Proficiency in service-oriented architecture - Understanding of SQL Server databases - Experience working with transactional

...stock sold over the weekend - whereby the client place a new delivery order for the following weekend / delivery for Thursday or Friday - each client will log into the app and in the back office, they will do stock control Monday or Tuesday, by scanning the items and stock not sold over the weekend, whereby a new order for stock delivery will be created, also a invoice will be send automatically (SQL database to deduct the stock from previous week for the invoice to be send to the client) - Push notifications: The app should have push notification functionality to send updates and promotions directly to our clients' devices. Visual Design: - The client has specific design elements in mind for the app. We will provide the freelancer with the necessary design assets and gu...

...site should handle transactions for boosting orders efficiently and securely. - Live Chat Support: In order to provide top-tier customer service, it will need to integrate live chat support. - Account Security Measures: The site should implement robust security measures to ensure user accounts are protected. The ideal freelancer will have experience in Wordpress, HTML, Designer skills, PHP, and SQL. They should have prior exposure to creating similar websites and, ideally, an understanding of the video gaming community. Their expertise should extend to implementing security measures to protect user data and accounts, and integrating live chat features. Attention to detail, creativity, and a proactive approach are highly valued. elo boost website Functionalities: User Acces...

...Google Cloud services, including but not limited to Cloud SQL for database hosting. Security Implementation: Implement SSL for secure communication. Set up Identity and Access Management (IAM) roles to control access. Ensure compliance with security best practices. Database Integration: Connect the CRM application to Google Cloud SQL. Migrate existing CRM data to the Cloud SQL database. Subscription Management: Integrate a payment gateway for handling subscription payments. Implement user authentication and authorization based on subscription plans. Skills and Experience: Proven experience deploying PHP applications on Google Cloud. Expertise in containerization using Docker. Knowledge of Google Cloud services, including Cloud SQL. Experience implemen...

I require an expert to oversee a financial performance tracking project using Power BI and Excel. The main data source will be Excel spreadsheets, with potential for other sources such as SQL databases or online services. These sources have not yet been confirmed, providing the freelancer with the flexibility to propose an optimal solution. Key Responsibilities: - Generate insightful financial tracking reports - Ensure daily data updates Ideal Skills: - Proficiency with Power BI and Excel - Experience with data integration from various sources - Familiarity with financial performance metrics - Strong report generation skills This is a strategic project that requires accuracy and attention to detail. Your ability to provide daily updates and encapsulating insights is of utmos...

This is a VB.NET project, taking over someone else's work that was not able to complete. Please see attached. The application takes sql queries and parses for the join conditions and puts in an output format. The issues that need to be corrected: 1-these specific files have issues: assetstatus is including schemaname on some rows, but not all. the other 2 files don't have any output, but they should...looks clean sql that should be able to parse. This needs to be fixed to handle. 2-currently it generates output for each input file. I need this to have option (checkbox) to put the output of all files in one output. Without duplicates (see #3 below). 3-this needs to add another column at the end that will write/append the file name that the row (which means t...

I'm seeking an experienced Laravel developer who can help customize my recruitment portal in Laravel. My ideal candidate has at least 2 years of experience in Laravel. Key Responsibilities - Develop frontend elements with a clean, minimalistic design. Prior experience creating such designs is appreciated. - Integrate SQL databases. Knowledge of SQL database management is a must. - Work on API integration. Familiarity with APIs in a professional setting would be a strong advantage. You'll ensure smooth integration in all these aspects to deliver a seamless user experience. Please submit your portfolio showcasing similar projects when bidding.

...and maintain databases, including database design, optimization, and data modeling. Implement security measures to protect data integrity. Troubleshoot and resolve database-related issues. Requirements: Proven experience as a C# developer with a strong portfolio of desktop and mobile application projects. Expertise in MIUI development and optimization. Proficiency in database management (SQL, database design, optimization, etc.). Self-motivated and capable of working independently. Excellent problem-solving and critical-thinking abilities. Effective communication skills. Additional Information: This is a freelance/contract position with a flexible schedule. The role is entirely remote, and you can work from anywhere. Compensation will be based on experience and project s...

I'm seeking an expert for automating a process where a booking on my website sends a Whatsapp message to the customer. Upon a new entry into our SQL database, the chosen freelancer will design a system using Zapier to automatically send this message. This is not only to confirm the booking but also to provide them with additional information. The automated WhatsApp message should entail: - Details of the booking - Promotional offers - Links to related services The booking information to be included is: - The date and time of the booking - Services booked Ideal skills for this project would include a deep understanding of SQL databases, proficiency in using Zapier, and experience in automation integration with Whatsapp. A successful freelancer would be able to deliver...

We have already made a app on Agriculture automation but we need a proper connection. We are creating which work on sensor , we have already defined the structure of application with few features functional. Requirements: We need to store data into SQL. need toperform visualisation of that data. Enhanced UiI for the app with login and signup page. Technology: SQL, JAVA Android, UI, Visualisatiion for android

I am looking for a freelancer who is proficient in SQL, Node.js, and React to complete a simple assignment within a week. SQL Database Structure: - I have a detailed layout for the SQL database structure that needs to be implemented. Node.js and React Functionalities: - I have specific requirements for the Node.js and React parts of the assignment that need to be implemented. Ideal Skills and Experience: - Proficiency in SQL, Node.js, and React - Strong understanding of database design and implementation - Experience in developing web applications using Node.js and React - Ability to meet tight deadlines and deliver high-quality work If you have the necessary skills and experience, and can complete the assignment within the specified deadline, please submit...

This project demands for the identification of phishing websites and subsequently building a dataset for the same. The goal is to advance the understanding and detection of phishing threats. The final product needed is a SQL database, reaching a comprehensive consolidation of data. Curating this dataset will require not just technical knowledge but also a keen eye for identifying phishing tactics. Skills and Experience: - Proficient in HTML, CSS and JSP - Experience in analyzing and identifying phishing websites - Expertise in creating SQL databases - Strong analytical and critical thinking skills - Familiarity with different phishing attack strategies - Ability to work securely and privately, to avoid any data breaches or leaks.

I require an expert to oversee a financial performance tracking project using Power BI and Excel. The main data source will be Excel spreadsheets, with potential for other sources such as SQL databases or online services. These sources have not yet been confirmed, providing the freelancer with the flexibility to propose an optimal solution. Key Responsibilities: - Generate insightful financial tracking reports - Ensure daily data updates Ideal Skills: - Proficiency with Power BI and Excel - Experience with data integration from various sources - Familiarity with financial performance metrics - Strong report generation skills This is a strategic project that requires accuracy and attention to detail. Your ability to provide daily updates and encapsulating insights is of utmos...

I'm currently working on a web development project and I'm seeking an experienced technical leader well-versed in C#, Blazor, HTML, and SQL Server. • Primary Role: Your main task will involve code programming and guidance on hour-basis. I'm looking for someone who can provide support in Spanish and follow COT time zone. • Sprint Planning Assistance: Your input during our sprint planning will be critical to ensure efficient and effective execution of tasks. • Demonstrated Blazor Experience: A hands-on experience with Blazor from previous projects is mandatory, to handle the challenges we may encounter with proficiency and aplomb. Let your portfolio testify your excellence.

Need an integration with 4 dynamic dropdown lists which gathers data from sql server. The data which is stored in the sql database is a with compatible vehicles. The 4 dropdowns should be make, model, fueltype and Engine. Based and the selected valuta, the remaining datas should be shown for the vehicles that fits the criterias.

...am looking to set up a CentOS machine that will act as a gateway for a network of security cameras. Ideally running on our digital Ocean account. The machine will need to run an OpenVPN client and serve as the gateway to the private IP addresses within the VPN network. One of the key features I am interested in is the ability to dynamically add or update IP routings via a Python script or from a SQL database. This will allow us to easily manage the network as we add new devices. Does this project sound like somthing you can help with? Cloud Services: - Currently using Digital Ocean for cloud services Skills and Experience Required: - Experience with cloud service providers such as Digital Ocean, Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform (GCP) - Knowle...

I need a classic ASP programmer that is proficient in classic ASP and MS-SQL database driven website to update and write a few new scripts. Must also be proficient in English and be able to work asap.

Seeking a Python coder for a data analysis project. Specific task: Data analysis. Dataset: Open to either options, either I have a dataset or it needs to be sourced. Timeline: Need the task to be completed within a week. Ideal skills and experience: - Proficient in Python programming language. - Strong analytical skills. - Experience in data analysis and manipulation. - Familiarity with data visualization tools. - Ability to work within tight deadlines.

...inventory. To connect django with the webserver you are going to use rest API’s Vs code will be used for the front end and we will be using html css. This will not be stored in the cloud. The programming language for the backend will be Django. This will be stored in the google app engine. For sql you will be using mysql. The browser will be able to connect to the app engine, which will be coded in HTML. cloud storage 2. rest APIs to connect Django to the webserver 3. Google app engine 4.sql database to connect to Mysql 5. Each user will be able to use their Google accounts (using Google’s authentication mechanism) to access their inventory. Implementation: Languages to use: ● Python: Main language for coding the application's logic. ● HTML: Utilized...

Android app, admin panel Technology: React Native Php My sql

Need Oracle Fusion/Cloud document for all modules( Fin，Dis，MFG，etc.) including: BR100,TE040,BP080,MD050,etc. Need Oracle Fusion/Cloud SQL scripts which are offten used

I need proficient database support encompassing MS SQL and MySQL, specializing in L3 activities. This includes: - MS SQL Activities: Your duties will involve database administration, performance tuning, and query optimization. - MySQL Responsibilities: Along with the same mentioned MS SQL tasks, additional activities include conducting mock drills, handling major P1 cases and performing DC-DR drills. - Frequency of Tasks: Although no regular frequency, tasks should be completed whenever required. Ideal candidates will possess strong skills in both MS SQL and MySQL database administration, performance tuning and query optimization. Experience in handling P1 cases, conducting DC-DR and mock drills using MySQL is a must. Exceptional problem-solving abilities are ...

...scalable systems, we want YOU! What We Need 1) Collaborate with cross-functional teams to understand project requirements and deliver high-quality solutions. 2) Must have good command on MySQL/Oracle. 3) Knowledge of PHP Frameworks preferably Laravel/ CI 4) Proficient in creating and consuming RESTful APIs. 5) Excellent problem-solving and debugging skills 6) Database design and implementation. SQL query/schema optimization experience. 7) Proven experience of web applications development. 8) A strong portfolio showcasing your backend mastery. 9) Version control system experience (subversion, git). What You'll Be Doing 1) To make admin panel & user Interface Panel 2) Developing and maintaining backend functionalities using PHP Laravel. 3) Collaborating with the fronten...

BUDDI AI, a US healthcare AI product company is seeking a highly skilled and experienced Database Architect/Administrator with expertise in Microsoft Azure SQL to join our team. The ideal candidate will play a key role in designing, implementing, and managing our database architecture, ensuring optimal performance, scalability, and reliability. This position requires a deep understanding of database systems, cloud technologies, and a proven track record in designing and administering complex database solutions. The selected freelancer will be responsible for designing and implementing database architectures for projects in-hand. The ideal candidate should have a deep understanding of database concepts and be able to create efficient and scalable solutions. Some of the responsibil...