Need someone sql skillsPekerjaan

I am in need of someone to post a technical project for me to improve brand visibility. This project is for personal use and requires someone with the ideal skills and experience in technical project management. Requirements: - Experience in posting technical projects on freelancer platforms - Knowledge of how to effectively showcase technical projects to attract potential clients - Familiarity with the specific requirements and guidelines for posting technical projects on freelancer.com - Ability to provide a detailed and compelling project description to entice potential bidders - Excellent communication skills to effectively communicate project details and requirements to interested freelancers Skills and Experience: - Technical project manag...

I am in need of someone to post a technical project for me to improve brand visibility. This project is for personal use and requires someone with the ideal skills and experience in technical project management. Requirements: - Experience in posting technical projects on freelancer platforms - Knowledge of how to effectively showcase technical projects to attract potential clients - Familiarity with the specific requirements and guidelines for posting technical projects on freelancer.com - Ability to provide a detailed and compelling project description to entice potential bidders - Excellent communication skills to effectively communicate project details and requirements to interested freelancers Skills and Experience: - Technical project manag...

<SQL> SELECT o.sales_order_number AS 'Order', AS Container, t.tag_id AS Tag, IFNULL(, 'ALL') AS Priority, Pickup_Location AS Origin, Delivery_Location AS Destination, DATE(Delivery_Time) AS Delivery_Date, Tender_Time, Pickup_Time, Depart_Time, Arrival_Time, Delivery_Time, Deliver_Driver AS Driver, m.Business_Unit, AS Party_Name FROM summary AS m LEFT JOIN tag AS t ON m.tag_row = LEFT JOIN priority AS p ON = LEFT JOIN shipment_packing AS k ON m.tag_id = LEFT JOIN shipment AS s ON = LEFT JOIN table_order AS o ON s.buy_order = LEFT JOIN business_unit ON CAST(m.business_unit AS SIGNED) = LEFT JOIN party ON = WHERE Deliver_Driver IS NOT NULL and Delivery_Time

We have a parking management system, where sometimes we see 30 vehicle in month get access to no card login, which should not be the case, We need an expert who can access it on share screen and fix it asap. Changes required only in SQL server stored procedures only.

...project, I am seeking a skilled developer with a passion for engaging, adult-orientated role-playing games. The project will focus on creating a mobile RPG that will enthrall an adult target audience. Key requirements include: - Mobile RPG production experience - Strong understanding of adult gaming sensibilities - Exceptional storytelling capabilities - Advanced graphics and user interface skills - understanding of developing business simulations - knowledge of human psychology or learning principles will be an added advantage The ideal candidate would have prior experience in developing sophisticated mobile RPGs for adults. They would understand the unique narrative and gameplay needs of this mature demographic. My ultimate goal is to engage, and cater to, adults with comp...

We are looking for a skilled full-stack developer with experience in C# and .NET Core developer to join our team for a stack development project. The ideal candidate should have a strong understanding of both front-end and back-end development, as well as proficiency in C#, .NET Core, SQL Server and Azure Cloud. Skills Required: .NET, C# Programming, Full Stack Development, Azure, SQL Server

I'm looking for a skilled freelancer to create a powerful web scraping tool that can effectively extract specific information from various online sources. Here's what I need in a nutshell: - **Data Extraction:** - Text-based content and links. - Emails and phone numbers as key data points. - **Target Sources:** - Scrape across business directories. - Extract from diverse social media platforms. - Cull information from multiple news websites. - **Output Specifications:** - Final data should be delivered in JSON format. **Ideal Candidate Skills:** - Strong experience in web scraping and data mining. - Proficiency in handling different types of websites (directories, social media, news). - Expertise in Python or similar programming language, espec...

I'm looking for a skilled freelancer to create a powerful web scraping tool that can effectively extract specific information from various online sources. Here's what I need in a nutshell: - **Data Extraction:** - Text-based content and links. - Emails and phone numbers as key data points. - **Target Sources:** - Scrape across business directories. - Extract from diverse social media platforms. - Cull information from multiple news websites. - **Output Specifications:** - Final data should be delivered in JSON format. **Ideal Candidate Skills:** - Strong experience in web scraping and data mining. - Proficiency in handling different types of websites (directories, social media, news). - Expertise in Python or similar programming language, espec...

I'm looking for a skilled freelancer to create a powerful web scraping tool that can effectively extract specific information from various online sources. Here's what I need in a nutshell: - **Data Extraction:** - Text-based content and links. - Emails and phone numbers as key data points. - **Target Sources:** - Scrape across business directories. - Extract from diverse social media platforms. - Cull information from multiple news websites. - **Output Specifications:** - Final data should be delivered in JSON format. **Ideal Candidate Skills:** - Strong experience in web scraping and data mining. - Proficiency in handling different types of websites (directories, social media, news). - Expertise in Python or similar programming language, espec...

Actualmente tenemos este desarrollo para SQL Server, y queremos pasarlo a Postgress son solo 20 end points

I'm seeking an experienced PHP developer to elevate an existing system's analytic capabilities. Here’s what I need: - Installation and customization of a PHP script, specializing in data reporting, analytics and Bulk Inventory upload Script bought from Codecanyon Ideal Skills: - Proficient with PHP and SQL databases - Prior experience with analytics-related scripts - Understanding of data privacy and security measures - Ability to optimize for performance and scalability Experience Requirements: - Portfolio showcasing past work with PHP, especially in data-centric applications - References or testimonials validating expertise and reliability Freelancers should provide a detailed proposal outlining their approach, timeline, and any suggestions for ...

...possible. The graphic will be printed on a black shirt, so optimize for black background. ***Requirements*** Proficient in using AI tools (ChatGPT+ and DALL-E 3). A keen sense of humor to discern the most effective puns generated by ChatGPT+ and come up with a funny idea for the graphic. Strong sense of design and an eye for detail. Ability to create print-ready designs. Excellent communication skills. ***Payment*** Opportunity for unlimited design submissions in the future with $1 per design! For this contest (which we use to find designers for long-term hiring), the payment is 10$ for 3 designs. Please submit the work as PNG with transparent background. No semi-transparency. No gradients. 4500 x 5400 px. You may choose from the following themes: Coffee, Pizza, Climate Ch...

...follows: • Designing the User Interface: Inject your creativity and expertise to assist in creating an engaging and intuitive interface for our platform. • Implementing Server Side Logic: Harness your skills to deliver solid server-side solutions and ensure the functionality of our platform meets the project requirements. • Managing the Database: Utilisation of the Microsoft Database/SQL to effectively manage and organise information on our platform. Ideal Skills and Experience: • Extensive knowledge in HTML, CSS, JavaScript required. • Mastery in Node.js/Express.js, React.js, and Microsoft Database/SQL or other similar database platforms necessary. • Proven experience in UI design, server-side logic implementation, and datab...

...management business. The ideal candidate will have: * A deep understanding of Google AdWords. * Solid experience with using Google AdWords in the property management industry or a related field. Though generating leads/sales, increasing web traffic, and enhancing our brand awareness are all important to us, I have not specified a stringent goal for this AdWords account. Therefore, I am looking for someone who can provide strategic, goal-oriented input based on their experience and expert understanding of Google AdWords. The freelancer should include their past experience in their application. Their prior experience in setting up and optimizing AdWords accounts, especially pertaining to the property management industry, is significant to me. I'm looking forward to understa...

I'm in immediate need of a skilled Data Science professional to collaborate on various tasks. Here's what I'm looking for: - Mastery in **Python**, **R**, and **SQL** - Comfortable with **data cleaning and preprocessing** - Capable of conducting **statistical analysis** - Experienced with **machine learning modeling** Ideal applicants should demonstrate: - Proven track record with relevant **past work** - Substantial **experience** in similar projects - Ability to craft a **detailed project proposal** Your expertise will play a crucial role in the success of my project. If you possess the skill set mentioned and are available for immediate start, I look forward to your proposal!

I'm in need of a competent web developer skillful in ASP.NET webforms, JavaScript, and familiar with techniques such as Fetch and AJAX. The project involves building a comprehensive hotel management system with a SQL server database. Key functionalities required are: * Booking Management - the system will need to handle a volume exceeding 50 bookings a day efficiently. * Inventory and Room Management - keeping track of hotel supplies and managing room distribtution. * Customer and Account Management - managing customer details and accounts in an organized manner. * API Integration - this is necessary for booking from an external website, the API should provide real-time booking updates and show availability and rates. * website must be RTL. * with Code Source ...

...write-ups. Besides some edge-case frames, the UI/UX is completed. We're looking to launch our alpha asap but need a talented developer or two to build the foundation and get this platform to market. The application has many features and conditions, but the logic for each is relatively simple, as is the UI/UX. We are not creating a new or ground-breaking technology, we are simply consolidating and simplifying existing mechanisms to create a unique and efficient solution. Integrations and API's: - Stripe - Contacts, Calendar, and Location data - SMS/Email/Push notifications required - AWS Hosting (anti-spam, and security features included via AWS) Expected programming experience: - Python - SQL - Mobile application development - AWS certified would be a plus, ...

I am looking for a Backend Developer with established skills in Node.js, who also had experience in handling both SQL and NoSQL databases. The primary purpose of the project is to fetch Indian market IPO allotment status. What i want is a system where i send users PAN number and it fetches me the data whether IPO is alloted to user or not. I want something similar to narada app Key Responsibilities: - API Integration: Besides strong Node.js skills, experience with API integration is crucial. As most of the data will be served from external sources, fluency in API handling is crucial. - Database Management: The developer should be able to comfortably work with both SQL and NoSQL databases, managing and optimizing data flow as necessary. Ideal candidates wil...

I require a proficient data entry expert focused on database entry and handling. Key Tasks Include: - Handling data input into the database Ideal Skills: - Proficiency in handling large amounts of data - Skill in using various database systems - Attention to detail and high accuracy - Experience with SQL, NoSQL, or cloud-based databases is highly desirable, but not required. Please apply if you can consistently deliver high-quality work on schedule, and you're open to long-term work updates.

I'm in need of a competent web developer to create two critical pages for an upcoming web project. Your expertise should align with front-end development and database integration. Here's what I’m looking for: - **Page Design & Functionality:** - First page with a *registration form:* to gather user's personal details, qualifications, and experience. - Second page featuring a *robust search bar:* displaying submitted user details as a table below the search query. - **Database Implementation:** - Efficiently store registration data and allow for easy retrieval during search. - **Skills and Experience Ideal for This Job:** - Proficiency in HTML, CSS, and JavaScript - Backend programming knowledge (PHP, Python, Ruby, etc.) - Database handl...

...process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI). Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis. Knowledge and understanding of the applicable tools and practices used in data governance including query and data profiling techniques Proven skills in data analysis – including queries to calculate data quality. Solid written, verbal, and analytical skills Strong research and problem determination and solution skills...

I need a reliable freelancer to extract specific user data from website's database that will enable me to contact users for promotional activities. Requirements: - Retrieve user names, phone numbers, and email addresses from the database. - Ensure data accuracy and integrity. Purpose: - My goal is to use this user data for promoting our latest offers and services. Ideal Skills: - Experienced in database management and data extraction. - Proficient with SQL queries and data mining. - Understanding of data privacy and protection laws. - Excellent attention to detail. Please provide examples of similar projects you've worked on and explain how you will ensure the security of the extracted data. Looking forward to your bids!

I am seeking a skilled freelancer to create a captivating 3D odometer effect animation for my project. Here's what I'm envisioning: - Develop a realistic 3D odometer effect. - Ensure the animation is suitable for promotional purposes. Ideal Skills: - Proficiency in 3D animation Using Html, CSS, JS, SQL - Experience in creating animations for marketing and promotion - Ability to animate realistic mechanics and movements - Strong portfolio showcasing 3D animation expertise The final product should be of high quality and delivered in a format that can be easily integrated into various promotional materials. I'm excited to work with a talented animator who can bring this 3D odometer effect to life.

I have created a Wordpress site and I need you to upload and run my backup file with .sql to ftp. But the content that is on the site needs to stay and just add this extra backup folder to it and make it display just fine.

I am looking for a freelancer with WordPress skills to fix my website and make sure it's all running properly after being down for a while. - Plugin installation and configuration - I have some specific plugins in mind, but I am also open to recommendations from the freelancer - I will need continuous support after the project is completed for maintenance and updates Ideal skills and experience for this job include: - Strong knowledge of WordPress - Experience with plugin installation and configuration - Ability to recommend suitable plugins based on project requirements - Availability for ongoing support and maintenance

Project: We are developing a financia...developing a financial product including Europe's largest debt exchange and financial forecasting. Main job: - extending and updating the data set while meeting product targets - creating data flow diagrams Skills we are looking for: - Data Science, Big Data, Statistics, Business Analysis - Quantitative and qualitative research - Cartography&MapApps, Spatial data analytics. - Programming (Excel macro, Delphi, SPSS, Python (Jupiter Notebook)) - Statistical analysis - SPSS, Python, Excel. - Business analysis - Forecasts, ML, DSS, SEM. - Databases development (SQL, MySql, Access, VBA). - Data flows schemes Nice to have: - work with financial products nice to have - work with registry data nice to have - soc...

I'm looking for an experienced Azure professional with expertise in handling SQL Server Database. The main task includes creating a convenient setup on Azure and migrating both text and numeric data from Excel or table into the newly established SQL Server Database. There's no need for pre-processing the data, it can be directly loaded into the database. High familiarity with Power BI for Azure setup is also crucial for this job. Proficiency in data migration and database administration would be ideal for this project.

I'm seeking an experienced MS SQL database administrator to help with important tasks related to database backup and recovery, with a focus on performance tuning. Key Responsibilities: - Performance tuning to achieve significant improvements. - Administer routine monthly database backup and recovery. Required skills and experience: - In-depth understanding of database structure principles - Experience in MS SQL - Previous experience with database backup, recovery, and performance tuning - Solid understanding of SQL server troubleshooting and problem-solving.

I need a MS Access database designed and developed with for a simple task. The backend will be SQL. Here is a brief of the requirements - 1. Query data from the source SQL DB using the search parameter. The SQL query is ready. The parameter value needs to be displayed prominently in all further screens until saved and closed. 2. Show all available line items in the UI and user can select the ones needed for processing. 3. All the selected items will be shown in the next screen for entering data in a few fields. (This can be a table view for easy processing). 4. The selected and edited items need to be saved in a separate SQL DB. 5. Option to search and edit the saved records is needed. 6. User login is also needed. Possibly with the UserID/PW or ...

Hi all, I am looking for someone who can create a crypto exchange like binance and already have worked in blockchain industry and understand how all crypto exchanges works. will be needing MM as well.

I'm searching for a seasoned expert in Microsoft SQL databases to create a perfect backup of my current database. This is not a data migration project nor will it require any data cleansing or de-identification. The key tasks include: - Copying the entire database with its existing structure intact - Ensuring that the newly created backup of the database is a perfect replica The ideal freelancer for this job would be proficient in handling large Microsoft SQL databases and have a proven track record of creating seamless database backups. Your experience and ability to create a flawless backup without any distortions to the structure or loss of data will be crucial for this task.

I require a talented designer who can give my logo a modern revamp and create a unique illustration based on my guidelines. - Logo Update: My logo is a mix of text and icon which needs to be tidied up. I'm envisioning a clean and modern redesign that amplifies our current brand. The two logos need to be recreated to be neat and clean cut, following the logo very closely, I would like one by itself and one with the number 300 written eight below the logo - Original Illustration: Along with the logo redesign, I want you to freehand draw a specific picture following my guidelines. I will provide some image references, but I highly encourage your own creative input to make it unique. I have given a few different pictures for what I want, a spartan shield with two spears in an x ...

I am looking for a software developer proficient in Python, JavaScript, and Java. The primary task for the project will be to create a software that can convert HTML output into downloadable Word files. At the backend we use My SQL. Key Responsibilities: - Design and develop a program that accurately transfers text content, images, and tables from HTML to Word documents - Ensure there is no loss of information or image quality during the conversion - Optimize the process for maximum efficiency Ideal Candidate: - Proficient in Python, JavaScript, and Java - Experience with HTML, Word file generation, and conversion tools - Strong understanding and experience of software development and coding - Capacity to meet the deadlines If you believe you are a perfect fit for this task, kin...

...highly skilled developer with a deep understanding of Bitcoin Ordinals Protocol and a mastery of SQL. The project requires: - Creation of 2 SQL tables (1 for deploys and 1 for mints.) - Each row will extract filtered data relevant to the protocol (eg: "p":"x", "op":"mint", etc) for specific parameters (columns), starting from a specific block #. - Cronjob to add new rows every 10 minutes (new Bitcoin blocks to update tables data - new deploys, new mints or inscriptions ownership change/address owner) - UI with a user address search query, that will reflect the information of the 2 tables related to that address (mints and deploys relevant to the user address.) For the index, you can either use the SQL suggested method above...

I am in need of a skilled developer who can create a React MVC ASP.NET Core application with SQL Server and Entity Framework. The primary purpose of this application will be to import and process cashflow information. Preferred Technology Stack: - React - ASP.NET Core - SQL Server - Entity Framework Specific Features and Functionalities: - Advanced analytics and reporting for cashflow information processing Expected Timeline: - The project is expected to be completed within 4-8 weeks. Skills and Experience Required: - Proficiency in React - Strong knowledge of ASP.NET Core and Entity Framework - Experience working with SQL Server - Familiarity with cashflow information processing and advanced analytics

I have created a Wordpress site and I need you to upload and run my backup file with .sql to ftp. But the content that is on the site needs to stay and just add this extra backup folder to it and make it display just fine.

Project Description: Solve Website Database Connection Error The following errors occurred: SQLSTATE[HY000] [1045] Access denied for user 'root'@'' (using password: NO) (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from where table_schema = 'botble_cms' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)

Fix problem with /tmp in whm "“MySQL” database “mysql”: 1021 (Disk full (/tmp/#);"

He visto que una carpeta esta dañada y hay que renombrarla.

...Interaction Forum – to foster a community of knowledgeable and engaged readers. *Database to retrieve the blogs from and store account information Competence in website development and a keen eye for user-friendly design is necessary. A strong understanding of blog management systems, SQL, Laravel or other relevant programming languages would be of great benefit. Previous experience in constructing dynamic blog platforms would be highly regarded. Please provide examples of previous work that highlights your skills in these areas....

Preciso de um desenvolvedor para criar um pdv para um erp já existem. Para trabalhar neste projeto você precisa ter familiaridade com essa stack: - Asp.net mvc .NET Framework 4.8 - C# - SQL Server - Entity Framework Adicionalmente você precisa ser capaz de trabalhar dentro de uma VM que será disponibilizada por mim, você vai precisa de uma internet boa e estável para consegui trabalhar. Vou deixar a VM configurada com o projeto pronto para você iniciar o trabalho imediatamente sem se preocupar com o setup do projeto. Aqui segue a referência de PDV que vamos seguir: Abaixo segue o escopo do trabalho com base a referência acima: 1. Lista de vendas realizadas via PDV com: a. Opções de filtro (por data, cliente...

For my ongoing SQL projects, I require assistance on a monthly basis. Primarily, the role entails focusing on aspects of database administration. Key tasks that need attention include: - Overseeing optimal backup and recovery processes - Ensuring ongoing performance monitoring - Maintaining the security management of the database The ideal freelancer for this role should have substantial experience in SQL database administration, with a particular emphasis on the areas specified above. Demonstrable skills in managing database security, monitoring database performance and conducting effective database recovery are essential.

I need to create an automated system that efficiently processes Sales Order data. This system should be capable of retrieving PDF files from specified emails, extracting relevant Sales Order information from these PDFs, and then accurately inserting this data into our MySQL database. Functionalities: 1. Email Integration: Develop a method to automatically access a designated email account, detect emails containing Sales Order PDF attachments, and download these files. 2. PDF Data Extraction: Implement a reliable solution to read and extract specific Sales Order data (such as order number, customer details, product information, etc.) from the PDF files. The PDFs can have a structured format, but the solution should be robust enough to handle minor variations in layout or design. ...

I am looking for a Ruby on Rails developer to help maintain and upgrade our project. Skills and experience required: - Expertise in Ruby on Rails, specifically Rails 6 and 7 - Experience maintaining and upgrading RESTful APIs and API integrations - Proficiency in RSpec for testing - Strong SQL skills for database maintenance Responsibilities: - Perform regular maintenance and updates on the Ruby on Rails project as needed - Address any bugs or issues that arise - Upgrade and improve existing features and functionalities Ideal candidate: - Has experience working with Rails 6 and 7 - Familiarity with RESTful APIs and API integrations - Proficient in RSpec for testing - Strong SQL skills for database maintenance - Detail-oriented and able to troubl...

As someone seeking assistance with my Oracle SQL project, my need is precise and task-oriented. I'm grappling with some update operations on tables and would benefit from expert guidance. - Task: The primary help that I need is updating a table. It's not just about changing existing data, but the process is conditional. The condition is slightly more complex than just concerning one column value. It revolves around multiple column values. - Expertise: A suitable candidate would ideally have experience in managing data migration, query optimization, and database design. The task involves sophisticated data handling, so someone with substantial Oracle SQL experience will be an asset. Proficiency in understanding and writing conditional...

I am looking for a talented designer to create a logo for my brand and design the packaging for my healthy products. Logo Design: - I wi...talented designer to create a logo for my brand and design the packaging for my healthy products. Logo Design: - I will provide the name of my brand - I am open to the designer's creativity in terms of colors and design elements Packaging Design: - The packaging is for my healthy products - I am open to the designer's creativity in terms of colors and design elements Ideal Skills and Experience: - Strong graphic design skills - Experience in logo design and packaging design - Ability to create visually appealing and innovative designs - Understanding of branding and the ability to create designs that align with the brand�...

I'm looking for an experienced Azure Data Engineer who can assist in continuously syncing data from an On-premises SQL Server to Azure SQL Database. The specifics of the data that need to be synced are Tables, Stored Procedures, and Views. Ideally, the freelancer should possess the following: - Proficient in Azure SQL VM operations. - Experience with data migration from on-premises SQL Server to Azure SQL Database. - Understanding of syncing Tables, Stored Procedures, and Views. - Capable of setting up an hourly sync schedule. The end goal is to keep the Azure SQL Database updated hourly to reflect the changes made in the on-premises SQL Server. Ensure seamless, error-free data transfer and verify the integrity of synced data...

I am starting a new business and I am currently handling it on my own. However, I am in need of someone who can assist me in making important decisions and managing the marketing aspect of the business. Specific Areas of Marketing Help Needed: - marketing and strategy Business Type: - small scale distribution Target Audience: - Yes, but my target audience is broad Ideal Skills and Experience: - creativity and open mindedness with risk calculation and practicality is the key - understanding of the business - Ability to work collaboratively and make informed marketing decisions - Knowledge of various marketing channels and platforms - Creative thinking and problem-solving skills - Ability to adapt to a broad target audience and tailor marketing strategies ac...

...- Urgent I am in need of a data engineer freelancer who can provide urgent support for the project. The ideal candidate should have experience and expertise in working with Snowflake, DBT, Dataiku and be able to solve problems Specific Requirements: - Creating Data products in DBT with source and target as snowflake warehouse. - Integration of Dataiku with existing systems and databases. - Experience with data ingestion. - create jobs in octopus, tidal Skills and Experience: - Proven experience in implementing Snowflake, DBT and Dataiku - Strong knowledge of Dataiku features and functionalities - Familiarity with data integration and data management best practices - Proficiency in SQL, Python, and other relevant programming languages - Excellent problem-solving ...

The job is to edit an AI content creation plugin for wordpress 1., to be compatible with WPML to publish multilingual content and 2., to auto embed a relevant youtube video in each newly created post. The plugin is AIKit