Small sql queryPekerjaan
We have created an additional field. This additional field contains data. Unfortunately, you can only see an excerpt on the frontend and not the entire text
...that your offer. if you have satisfy with my work and continue with next step , kindly accept this quote otherwise kindly mention the query or doubts based on the we will do improvements our Task. our working Style : * discuss the project with client * After implemented and show the working demo * if client satisfy then will only pay !!! so kindly verify our output , its helpful for your work, then kindly accept this quote. upto Completed Work: 1. Read Audio Files 2. Preprocess the deviated values 3. Extract the features 4. Training using Neural network 5. Compute the Calculated values from Audio signals 6. Evaluate performance Thank you :) if any query related to this project feel free to ask, if you need working code also we will send. (we like to do team w...
I have a Microsoft SQL Server installed and in operation, however, I am currently experiencing issues with slow query execution that ideally require rectification. I am seeking an experienced professional with specialization in performance tuning for Microsoft SQL Server. Skills & Experience Required: - Proven expertise in Performance Tuning and Query Optimization - In-depth understanding of SQL Server's underlying architecture, metadata and statistics to optimize queries - Solid experience in system analysis, profiling and tracing to diagnose and resolve performance problems - Ability to translate findings into actionable strategies to improve performance - Strong communication skills to effectively relay steps taken and results achieved. Th...
...Responsibilities for Website development: • Write high quality and maintainable code on open-source (Linux based) web platforms (Example: Wordpress) • Creation of custom plugins/widgets written to conform with the WordPress coding standards • Experienced in both front-end and back-end website development. • Build websites with a responsive and fluid front-end mobile design. Experience with at least 1 SQL and NoSQL database. Able to grasp the key essentials and marketing concepts after discussion with management. • Manage database and server integration. • Troubleshoot, debug and upgrade existing website. • Adhere to project timelines. • Create security and data protection settings that are compliance with PDPA policy. Job Responsibilities ...
I need an SQL and SSIS developer for my personal project. My primary goal is to optimize my SQL database, which is currently facing several performance issues. Key Problems: - Slow query execution - High resource consumption - Inefficient indexing The ideal candidate should have a strong background in SQL and SSIS for database optimization. A thorough knowledge of SQL query optimization, resource management, and indexing is essential. I am seeking an expert who can effectively address these specific issues and enhance the overall efficiency of my SQL Server development. Any suggestions for further improvements are also welcome.
...owner, I urgently need a skilled SQL Server and SSIS (SQL Server Integration Services) Developer to propel my database optimization objectives. Your primary tasks will focus on: - Fine-tuning SQL queries - Carrying out schema optimizations - Development using SQL I'm currently dealing with several performance issues, including slow query execution, high disk I/O, and index fragmentation. Therefore, for this task, the ideal candidate should possess a sharp understanding of query tuning and optimization, as well as practical experience with complex SQL Server and SSIS development projects. If you have proven experience in eliminating these types of issues and know how to implement effective optimizations, I am eager to work with y...
I'm in need of an expert developer who is highly skill...using the power platform. - Workflow Automation: We want to streamline our processes and increase efficiency with automation. - Power App Development: The developed app should have a user-friendly interface, provide real-time data updates, and intensive integration with existing systems. Specific Data Sources: For this project, we'll need to integrate Excel spreadsheets, SharePoint lists, and SQL databases. You should have prior experience working with these data sources. The ideal candidate is proficient in MS Power Platform, excellent in data analysis and has experiences in workflow automation and App development, with a knack of creating intuitive interfaces and integrating diverse data sources. Let's con...
I am in need of an experienced SQL database expert to assist me with setting up a Failover Cluster on a Windows Server 2019 system. We have setup two servers, setup as a windows cluster then setup SQL High Availability failover cluster, however the second database will not sync
Hello, I am the owner of a new small company named Cypher Key. The company is about Automotive key services, like cloning, remote control coding, all keys lost, ?etc. As a pioneer step, I am looking for a skilled logo designer who can assist me in setting the visual tone for my brand. Key Tasks: - Design a minimalistic, clean and modern logo - Utilize the specific color choice: green - Create a design that fits the identity and direction of the company Ideal Freelancer: - An experienced graphic designer with proven experience in minimalistic design - Proficient in color matching and branding - A portfolio showcasing logos created for other businesses I look forward to working with someone who can capture the vision of Cypher Key and manifest it into a remarkable logo.
...proposition of through proposals and presentations to the prospects. Lead nurturing, engagement, and closing sales. Persuade clients to sign search contracts on an exclusive and/or retainer basis. Provide accurate and detailed forecasts on weekly/ monthly funnel of identified and proposed customers to meet and exceed sales requirements. Email coordination/timely update on whatsapp group by managing query flow of calls/emails/messages from candidate/internal team/clients. Stakeholder Management and Negotiation Requirements 2-4 years of business development experience in a recruitment agency/staffing firm. Proven track record in Client Acquisition and winning new business. Proven track record of increasing revenue through the generation of leads and placements. Lead and ...
Seeking a dynamic web developer to assist me with finalizing my website via enhancements in the JetEngine features. Need help with the following but not limited to: - Create queries in Query Builder that call from existing data. - Create tables in Table Builder based upon the Queries - Tie the tables into display on the front end pages that call for the inventory item.
HI 1: We require 2 basic elements to be updated in colour from the aqua colour to the colour of 1our logo. You can see on the screenshots the 2 elements and our URL is so you can view. 2: We require one line of text to be added im not sure where but its simply a counter of trees we plant and meals we serve. Something we can update weekly. Something like: So far we have planted 77 (tree icon) and 119 (meals (meal icon) We will not give access however you can take the css file and update it and we can upload. Budget is $10 and required asap.
An existing 400 sqf garage to ab ADU legally. One side is attached to the home. Address is 10028 Leona ave Tujunga Ca 91042. I need the paperwork to be submitted to the city to get permits. As a property owner, I’m looking to convert a small 1-2 cars garage into an Accessory Dwelling Unit (ADU), primarily for generating additional income via rent. Here are my specific needs: - Creative Utilization of Small Space: The existing garage is small, accommodating 1-2 cars. Your architectural creativity will come in handy in making the most out of this space to create a comfortable ADU. - Functional Design: As the goal is renting, your design should balance style and functionality to attract potential renters. Without specific features given, I look forward to your s...
...admin panel. The backend will be developed using FastAPI, a high-performance web framework for building APIs with Python, and MongoDB for data storage. Requirements: Expertise in FastAPI and MongoDB is essential. In-depth understanding of RESTful APIs, CRUD operations, and web security best practices. Ability to implement robust security measures to protect against common vulnerabilities such as SQL injection, cross-site scripting (XSS), and cross-site request forgery (CSRF). Experience with user authentication and authorization mechanisms, including token-based authentication and role-based access control (RBAC). Strong communication skills and the ability to collaborate effectively with our team. Deliverables: Develop a FastAPI backend with CRUD endpoints for managing admin ...
I'm looking for a MySQL expert who can create a complex query to retrieve data from multiple tables (Table A, Table B, and Table C) of my database. These tables are interconnected, and the goal is to join data from all these tables, perform necessary calculations, then save the result into another table. Excel file with explanation is attached. Required Skills: - Experience in MySQL query writing - Ability to handle multi-table complex join operations
I'm looking for a skilled professional to create a precise grading plan for a new, medium pool (28 feet in length) rectangular shaped pool I'm building. The ideal freelancer should have significant experience in designing grading plans for pools, with a strong understanding of local regulations and standards. Key tasks include: - Creating an accurate grading plan with regard to the pool's dimensions and preferred shape - Ensuring the plan aligns with local building regulations Sound understanding of pool construction and terrain design will be highly advantageous to this project's success.
I require a highly skilled Node.js developer to help...with social network functionalities. Key responsibilities will include: • Backend Development: Implement server-side logic that governs how our website behaves. The candidate should have a deep understanding of Node.js and its frameworks. • Database Management: You will be tasked with designing, implementing, and managing a database system to store, manipulate, and retrieve data. Knowledge in SQL or NoSQL databases will be a strong asset. The ideal candidate would have experience in developing advanced web applications and a strong understanding of database systems. You will be a perfect fit if you thrive on complexity and have built rich, dynamic, and robust applications before, especially those targeted towards so...
Looking for someone who can do these test tasks today. If you can, there is a ton of work and hours available for you. This is an API for a chat app. It has three assistants. 1. First assistant asks the user questions, and then 2. Second assistant is internal and takes the conversation to output as JSON and save in Postgres for the third assistant. 3. Third assistant takes all of that information into its prompt as context from Postgres, and answers user questions. Four tasks in this order: 1. OpenAI --> Anthropic 2. Deploy on render or railway 3. Add message history in Upstash Redis KV 4. Connect and retrieve new Supabase Postgres. The code already does it. Your task is to make some tweaks, and create a fresh Postgres database
I'm in need of a highly skilled 3D designer to create a small, high-detail replica of an image I have. This part will be used as a replacement and needs to be an STL file that's 3D printable. The part name is: "5G0941607" The images uploaded are of Right Part, I am looking for left part, hence the suggested image needs to be flipped accordingly. Required Skills & Experience: - Proficient in 3D design software - Experience creating detailed STL files - Understanding of 3D printing requirements To echo my needs: - The part needs to be small - The 3D printable file should have high detail - The created part will be used as a replacement Please include similar past projects in your proposal. I look forward to your expert assistance in creating this ...
...needs to support), leveraging GraphQL's introspection capabilities. We do not expect you to start from scratch - please see: Responsibilities: 1) Provide a bespoke GraphQL adapter for Apache Superset, ensuring it can dynamically introspect the provided GraphQL schema and translate SQL queries into GraphQL queries. 2) Implement logic to handle both Relay-style connections and standard GraphQL schemas, including advanced query translation for filtering, sorting, and pagination. 3) Map GraphQL responses to a format that can be consumed by Apache Superset, ensuring data integrity and compatibility. 4) Write comprehensive unit and integration tests to validate the functionality of the adapter across various scenarios. 5) Prepare detailed documentation
Project Deadline: Within 1 Day Project Budget: $50 Project Type: Web Scrape Number of Records/Pages: 18,512 Number of Data Points to Scrape Per Page: 6 Output Format: CSV & SQL 5* FEEDBACK WILL BE LEFT FOR YOU
I got a web stresser source code i need it to be edited to match the look of another stresser website which will be given in messages, it also has some small backend problems which will need to be fixed . Need a freelancer with good knowledge in HTML,CSS,JS,SQL And PHP
I am in need of a SQL Server expert to grant specific permissions for database access on my system. The primary role would involve enabling access controls and assigning user permissions for various actions, including: - Select - Insert - Update - Delete Ideally, the successful bidder will have considerable experience handling SQL Server and any relevant certifications would be a bonus - the complexity of the system requires high expertise. Your attention to detail is paramount, as well as being able to provide proof of your work. This project offers potential for future work, should the results prove satisfactory. Please account for communication time in your bid, as clear, understandable reporting is part of the task.
...HellasFin είναι μια από τις μεγαλύτερες και πιο δυναμικές εταιρείες επενδυτικών υπηρεσιών στην Ελλάδα. Αυτήν τη στιγμή αναζητούμε έναν Back End Developer που μπορεί να βοηθήσει σε...
I'm looking for a talented Python developer with a solid understanding of Django and MySQL. The purpose of this project is to develop a robust database management system. These are some key features that the application should have: - Integration with Django's ORM (Object-Relational Mapping) library. - Custom SQL query functionality for advanced data operations. - A system for data backup and recovery to prevent data loss. You should have a proven track record with both Django and MySQL, and be able to show examples of similar projects you have worked on. A strong understanding of database design and management is a must.
I'm seeking a proficient FlutterFlow deve...these kind of applications will be greatly beneficial to this project. Specifically I am looking to debug my VoiceFlow Bot integration. I have copied over to a new FlutterFlow project just a test chat page to debug, then impliment into my main app. Here is the link to the page - click on the purple button in the app to launch the chat. You will see a "NULL" value returned when entering in a text query. My API Call in the backend of FlutterFlow works fine in the API Section but is not in the front end chat. I believe my issues are as follows: 1. API JSON paths, incorrect payload 2. Custom Code - JSON Return paths 3. Incorrect Launch Request upon chat page load Respond with your favorite food
I own a small business and am seeking an expert accountant well-versed in a wide range of accounting practices. I need comprehensive services which will include: - Bookkeeping: Maintaining accurate records of all financial transactions. - Tax Preparation: Ensure compliance with tax laws and regulations, provide guidance about potential tax liabilities, and handle filing requirements. - Financial Statement Preparation: Prepare statements like P&L, and balance sheet to provide insight on the company’s financial status. - Expert use of Zoho for accounting entries. - Other services including GST filing and TDS. Ideal candidates should be certified accountants with considerable experience working with small businesses. Familiarity with Zoho is a must. Maintain top-lev...
I have magento as the base API when we run the stored procedures the SP works fine When we then run the SP in loops to cover all areas via PHP that calls the SP then the issue throws SQL error: "SQLSTATE[HY000]: General error (0)" I am not sure why. I suspect it it is locking processes but I am not sure. This is affecting several APIs so it must be resolved immediately But it seems to be possible to resolve it locally in he phpo code also I have seen on tickets. The work requires: - In-depth understanding of MySQL stored procedures - Extensive knowledge of Magento interface - Experience in API error troubleshooting - Expertise in handling 'data missing in response' type errors The ideal freelancer is one who is meticulous in bug detection and correction, ...
I am seeking a freelancer with experience in hosting .NET Core web applications on AWS. Although I have not decided on the specific AWS service to utilize, candidates with know-how in Elastic Beanstalk, EC2, or Lambda will be greatly appreciated. Key Requirements: - Experience in hosting .NET Core web applications on AWS. - Familiarity with Entity Framework Core and ASP.NET Core. - Proven track record in developing and deploying .NET Core applications. Past work examples will be highly valued during the selection process. As the perfect candidate, you must demonstrate your expertise in these areas and be able to contribute strategically to the decision-making process regarding the ideal AWS service for my project.
As a holder of a Drupal website with an Access/MS SQL database, I need to directly update Drupal tables using data from our database. We can transfer data from our Access database to the MySQL database, but need to update Drupal content from this data seamlessly. We would like to be able to create content directly from our database that can then be viewed as Drupal content. The timelines are strict and the project should ideally be completed within a month. Needed Skills: - Strong PHP programming with profound Drupal knowledge. - An understanding of SQL server and Microsoft Access although we have our own MS Access developer, so this will be to support them. - Previous experience with a similar project will be a plus. Please note, the scope of what information will be ...
I'm looking for a seasoned programmer, skilled in working with MIFOS (Fineract) software. The project primarily revolves around two key tasks:...looking for a seasoned programmer, skilled in working with MIFOS (Fineract) software. The project primarily revolves around two key tasks: 1. **Platform Customization and Enhancement** - Your role will involve optimizing our MIFOS platform to meet our unique needs and implementing minor enhancements for better functionality. 2. **Report Generation** - You will be needed to generate two types of SQL reports - sales and financial reports. Immediate availability is preferable as I'm keen on having the project completed ASAP. If you have a background in fintech and have previously worked on these tasks, you're likely the perf...
As an existing business, we are in need of a professional who can help us install and set up an Open EMR system. The project will include, but not limited to: - Installation of Open EMR - Configuring the server for optimal performance - Creating a user-friendly interface for our small team No data migration is needed. We are starting from scratch so we need the system to be clean and ready for us to input new data. Ideal candidates should have: - Strong experience in Open EMR installation and customization - Knowledge of server configurations - Ability to complete the job swiftly and efficiently This is a unique opportunity suitable for professionals who are well-versed in Open EMR and server maintenance. Your expertise and diligence will play a foundational role in our bus...
Hello, I have a simple php page and a complex database. My database size is very high and when I query a data I don't get a response for a very long time. I created a basic API and I have complex data in my database. I need a system that will delete repeated data in the database, destroy all unnecessary data and work with a proper, reliable api.
...patching, database performance tuning, sizing and capacity planning, database backup and recovery in a Unix O/S using RMAN and Oracle export/import utilities, administration, and maintenance to provide backup and disaster recovery. • Knowledge of installation, configuration, and maintenance of multi-node Oracle RAC enabled databases, including Oracle ASM and Oracle CRS management. Knowledge of PL/SQL packages, shell, and Perl scripts for task automation, and proactive database monitoring and notification using Oracle OEM Grid Control. • Demonstrated written and oral communication skills reviewing and editing established database policies and procedures and developing new SOPs for database software installation and configuration. • Experience with Cloud(AWS/Azure/OC...
As an experienced .NET Developer, I am looking for assistance with code optimization and feature development in both .NET 8 and Visual Studio 2019. My specific areas of concern are: - Improving execution speed - Enhancing scalability - Adding new functions to the software The development scope includes: - Microsoft SQL Database integration The ideal partner for this project would be proficient in .NET 8, Visual Studio 2019, Fluent in database integration and experienced in optimizing software for improved speed and scalability. Your track record in enhancing software functionality will also be invaluable.
I urgently require the creation of a 300x250 pixel banner. Unfortunately, the specifics of the banner's purpose have not been provided, but it should be a versatile design that could be used to promote a product, advertise an event, or display a message. Ideal Skills and Experience: - Proficient in creating digital banners - Exceptional creativity and innovation - Excellent time management - Professional approach to time and deadlines. Application Requirements: While I didn't specify any specific information freelancers should provide, any information you think might help me choose you as the successful candidate will be appreciated. This could include examples of past work, your experience or a detailed project proposal. However, considering the urgency of this project, a s...
I'm in need of an expert interior designer to curate a modern style for my small living room (under 500 sq ft). The project involves not only creating an appealing and comfortable design but also providing a 3D floor plan and a 3D video representation of the design for a more realistic perspective. Key aspects of the project: - Developing a modern design that efficiently utilizes the available space, making it feel airy and comfortable. - Creating a 3D floor plan, offering both a bird's eye view and a detailed layout of the proposed design. - Producing a 3D video view of the floor plan for a vivid walkthrough experience of the designed space. Essential Skills: - Proven experience in Interior Design, particularly modern styles. - Proficiency in 3D rendering tools f...
This is a reasonable small job, I don't need a team, I just need 1 x web builder I can talk to, react and work with me directly. I don't need an agent to pass on messages. Design is pretty much not required. I provide image and content. You just build it. The homepage needs to be completed before 25th of March 2024. The rest of the pages just mark as "Coming Soon" for now. But I do need those done after I travel back from oversea. Please see attached an rough insight of "Homepage Building".
I'm in need of a proficient expert in Excel, SQL, and Python for data analysis, data visualization, and automation. The data complexity is moderate, so a good understanding of data manipulation and cleansing techniques is required. IT IS A TIMED TASK - please only reach out if it’s okay Main Responsibilities Include: - Analyzing the given data - Visualizing analyzed data - Automating tasks that involve data manipulation
1. We have 32 backups from the same database as .sql-files. From one table of this database we need all instances in one csv-file (with the same codepage as stated in the sql-file ). So basicly you must: - import 1st backup on your sql-server - export the table "contracts" to "csv for Excel" - repeat for all 31 other backups - put everything together in one big csv-file that is readable in Excel (pls maintain german umlaute) 2. There should be a menu-item (i.e. "Report"); clicking this asks for the date "Welches Datum?"; the current date is proposed but can be changed by choosing a date in a calendar. The report should consist of: 1. All customers that have been added at the given date. 2. All contracts that have been ad...
For our enterprise SaaS system, we need an experienced analyst/CRM specialist proficient in Salesforce, HubSpot, or similar platforms. Our focus is on customer data integration and setting up optimal data structures and workflows. A successful candidate must demonstrate: - Expe...workflows. - Ability to train and support a medium-scale user base. There will be multiple projects on an ongoing basis and may require you to attend online meetings once every few days, so please let us know if you have availability during the day. Must be U.S. resident and at least permanent resident. Some project will require background checks. We have a separate project for an individual with SQL, data analysis and Dashboard experience as well. If you have those skills you can work on both projects.
(the songs already exist) I need a small edit, about 1 minute, or 1:30. You take parts of each song, mostly chorus. And make them transition smoothly. So we don't notice a sound stop when it switches to another song. This is a rather small quick edit.
I require a talented and experienced database architect to efficiently design and establish an SQL database for my project. Key Functions: - The database should proficiently support data storage and retrieval. Key Details: - Unfortunately, I can't provide specifics about the type of data to be stored. Understanding of a broad range of data types and versality is crucial. Ideal Skills: - Advanced knowledge of SQL - Expertise in database architecture - Excellent problem-solving skills - Ability to work without specific data requirements Time Frame: - This project is urgent. I need it completed as soon as possible, so efficiency and dedication are essential. I look forward to working with a meticulous and dedicated professional who can meet these requirements ...
I'm seeking a skilled web developer to create a robust, web-b...skilled web developer to create a robust, web-based business management software for my small company. This software should incorporate a variety of functionalities including: - Customer Relationship Management (CRM) - Financial reporting capabilities - Booking management system - Task assigner/tracker - Invoicing system The style of the platform should be modern and minimalistic, focusing on user-friendliness and clear navigation. Prior experience building similar platforms would be highly beneficial. Strong understanding of CRM and financial reporting software development is particularly important. The ideal candidate should have a keen eye for simple, efficient systems and be in-tune with the needs of a sma...
I own an IT consulting firm which is recently extending its offerings to trainings in tech. The tech trainings offered are mainly focused on data analytics/science, BI and cloud computing. The courses are mainly given to people who have no prior tech or coding experienc...mainly given to people who have no prior tech or coding experience but those who want to break into tech career. I am looking to hire a skilled BI developer with extensive experience with Tableau, Power BI and other BI tools. The freelancer will be helping me design the curriculum and also teach BI and data visualization Must have skills: 1) Power BI-DAX, M Language, Data Modeling, Power Query 2) SQL 3) Good teaching skills. 4) Great command of English PLEASE SUBMIT YOUR PROPOSAL WITH YOUR RANGE OF EXPE...
I'm in need of a proficient Azure SQL developer skilled in query optimization and stored procedure. The purpose of this project is to automate certain tasks within our existing system. This will involve: - Optimizing my existing SQL scripts to ensure smoother operations - Developing new SQL scripts as required, to further enhance automation I expect candidates for this project to have robust experience in Azure SQL, particularly in developing efficient procedures and scripts. Proven problem-solving abilities and a keen eye for the fine-tuning of processes will significantly benefit this assignment. Familiarity with task automation will also be highly regarded.
I am looking for a proficient developer who can successfully integrate our Phone system API with our SQL server. The purpose of this task is mainly: - To fetch specific data fields from the call logs which include: 1. Caller ID 2. Call duration 3. Time of call 4. Call outcome 5. Call type 6. Caller's location 7. Internal/External Flag 8. Recipient Name/Internal Extension - Store this information in the SQL server. About the Database: - The storage should be in raw format. - Importantly, the call logs should be segmented by the call type. - A strong emphasis must be put on timestamps while storing data. Necessary Skills: - Proficiency in working with APIs, SQL servers - Knowledge and experience in data extraction and storage - Strong understanding of call log d...
As the owner of a small business, I'm in need of an experienced accountant well-versed in tally QuickBooks for our sales and purchases-related bookkeeping. Key Responsibilities: - Maintain our books on a monthly basis - Record day-to-day financial transactions - Reconcile sales and purchases - Generate monthly financial reports Ideal Skills and Experience: - Certified Public Accountant (CPA) - Proficiency in QuickBooks - Experience in bookkeeping for small businesses - Keen attention to detail - Record of reliability and confidentiality Your ability to keep up with tight deadlines will guarantee a long-term partnership. Looking forward to finding the perfect fit for this task.
Project Description: We've built a backend API using .NET...various environments (dev, staging, production) for efficient development and deployment. - Be able to run the backend API for local testing purposes. - Should also be able to make amendments to the .NET API What We Offer: Long-term Collaboration: We value long-term relationships and are looking for someone who can become a part of our team. Proficiency in , JavaScript, .NET API's, and SQL databases Strong understanding of data validation and security best practices, Strong understanding with creating charts, working with CDN's Experience working with existing codebases and contributing to ongoing projects Ability to run backend APIs for local testing Experience setting up development, staging, and produ...
