Sql queries for dummiespekerjaan

...working with it where possible... unless its deemed a rebuild is cost effective. The opencart system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart version. The business we operate in is parts for coal and wood fires, this is a business that is reducing overtime, due to environment issues, however, the stove market has recently had a mini boom due to gas prices being high with a record number of new stoves being sold over the last 3 years (we do not sell new stoves, just the parts for these stoves). We expect to see at least another 5 years from this business. We have been told by our current developers we should look at a google shopping program, however, we are concerned the margins are not in the products...

Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.

I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.

...fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions. 1. What type of Software you have done in Laravel+Vue? 2. Ho...

I'm looking for someone to help me set up Zobot Zoho for my customer support team. Key Tasks: - Integrate live chat: I want my customers to be able to easily chat with our agents. - Implement automated ticketing: I need the system to efficiently create and manage support tickets. - Set up FAQ self-service: I'd like to reduce the workload on my team by having a self-service option for common queries. The ideal freelancer will have: - Proven experience in setting up Zobot Zoho - Strong understanding of customer support systems - Familiarity with integrating live chat and ticketing systems - Ability to create a user-friendly FAQ self-service interface - Excellent communication skills to ensure a smooth handover to my team. Please note that my team c...

...a focus-driven developer to build a web application for my travel agency. The purpose of the application is to implement a backoffice system for managing bookings. The functionalities I'm aiming are: - User needs to enter details like Agency name, pax name, mobile number, pick up location, pick up time, date of flight travel, flight departure time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Proficiency in PHP...

I'm looking for a skilled web developer to create a website that is tailored for a teenage audience. Key Features: - The website is primarily informational, hence the main focus should be on providing clear, engaging and relevant content for teenagers. - One of the key features I need is a Contact Form. This is to ensure that the teens visiting the site can easily reach out to me with any queries, comments or feedback they might have. Ideal Skills: - Proficient in Web Development with a good understanding of UI/UX especially for a teenage target audience. - Experience with integrating and customizing Contact Forms. I'm open to your suggestions on how to best cater to the teenage demographic. Please include any relevant experience you have ...

I am looking for a virtual assistant to support me with schedule management, data entry, and guest interactions. Key Responsibilities: - Schedule Management: The assistant should help me keep track of my appointments, deadlines, and important dates. This includes setting reminders and ensuring I'm always aware of my upcoming commitments. - Data Entry: There will be a need to input various types of information into spreadsheets or databases, ensuring accuracy and efficiency. - Guest Interactions: Good communication skills are essential. The assistant will be in charge of interacting with guests, handling queries, and providing assistance in a professional manner. Ideal Candidate: - Experience in virtual assistance or similar roles. - Proficient in the use of mobile apps...

...JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is adept at managing the full project lifecycle from the front end to the back end and can make informed decisions about SSL types as necessary, then I am looking for you. Long-term relationship is preferred i...

I'm looking for a professional who can help me scrape detailed product information from a website that I will share with you. This data should be filtered according to specific product details. Key Requirements: - Retrieving product information including SKU, Category, Sub-Category, Color, Gender, Age, Material, Sleeve Length - Implementing a filtering mechanism to sort and organize the scraped data - Attention to details for accurate data scraping The ideal freelancer for this job should have: - Experience in web scraping and data mining - Strong understanding of data sorting and filtering - Proficiency in managing and storing large sets of data - Excellent communication skills to understand and address any queries regarding the project Looking forward ...

I'm looking for a skilled developer who can refactor and migrate my current LAMP Web App into an Angular (frontend) Node.JS (backend) application. This is a project that requires a strong understanding of both LAMP and MEAN stacks. Key requirements for this project include: - **Refactoring:** The existing codebase is procedural-functional, with a mix of HTML, DB-Queries, PHP echoing out JScript, and inline-stylings. I want to move towards a more organized, maintainable and modular structure, following MVC principles. - **Migration to Angular/Node.JS:** You must have a demonstrated experience in working with Angular for the frontend and Node.JS for the backend. The functionality of UI views is clear, and the queries on the DB are available, so...

...monitor that utilizes a hook-based approach for Windows 7, 8, 10, and 11. The monitor will specifically keep an eye on application settings and alert me via email whenever any changes have been made. Key features will include: - Targeting application settings in the registry. - The ability to detect any changes to said settings. - Sending an email alert every time a change is detected. Freelancers with experience in creating similar systems or possessing a deep understanding of the workings of Windows OS will be preferred. Additional Details: Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, send mail to a group, in case of change not applied through Service. 7. Logs needs to be updated to SQL via a A...

...elements we envision for the website include: - A sleek and appealing design: Our preference is for a romantic and elegant look, with the use of bold and vibrant colors to bring the site to life. - RSVP Management: We need a well-functioning RSVP system that allows our guests to confirm their attendance and provide essential details. - Photo Gallery: A beautiful photo gallery that can display our engagement photos and other important moments leading up to our special day. - Countdown Timer: A countdown timer that builds anticipation and excitement among our guests as they await the wedding day. The ideal candidate for this project would have: - Extensive experience in WordPress development, with a strong portfolio of elegant and sophisticated websites. - A keen eye...

To apply for this job you must submit a voice recording using (add the recording to your cover letter) Please record in English. You will not be considered without a recording. Key Responsibilities: - Conducting customer support calls in English and Spanish. - Handling technical troubleshooting queries as they arise. - Responding to product inquiries with clarity and confidence. - Resolving complaints effectively and professionally. I need someone who is: - Fluent in both English and Spanish. - Experienced and comfortable with customer support via telephone. - Proficient in handling technical queries. - Skilled at complaint resolution. - Knowledgeable or trainable in automotive industry specifics.

I'm urgently seeking a skilled developer to create a Telegram bot that can perform a range of essential functions. Key Features: - Sending automated messages - Providing information or FAQs - Collecting user feedback Tasks: - Sending notifications - Providing weather updates - Answering user queries I expect the project to be completed as soon as possible. Ideal Candidate: - Experienced in Telegram bot development - Proficient in various messaging APIs - Familiarity with automated messaging systems - Skilled in data collection and feedback mechanisms - Able to create a responsive and user-friendly interface I need someone who can work efficiently and effectively to deliver a high-quality product within a short timeframe. Please submit your bid only if you can meet these r...

...search for an experienced Sales and Marketing assistant who can help me get vendors on-board and increase sales on my e-commerce platform. The diverse requirements of this role will match ideally with someone who has experience in both vendor acquisition and social media marketing. Responsibilities will include: - Contacting potential vendors to sign up with us and add their products. An introductory message highlighting the benefits we offer could be crucial, although I am open to other strategies you bring with you from your past experiences. As this task was not answered in the pre-questionnaire, it requires further briefing. - Applying successful business development strategies to onboard new vendors. You need to have an open and active communication channel with them fo...

...experience in TypeScript frameworks for server-side rendering and React.js or Vue.js for web development, as well as React Native or Flutter for mobile app development. Responsibilities: - Develop user authentication and profiling features, including sign up, basic details collection, and user categorization. - Implement job posting functionalities, allowing users to create detailed job listings with prompts and boilerplate templates. - Design and integrate payment gateways, specifically utilizing Midtrans Indonesia for secure transactions. - Develop interactive features such as chat portals, notifications, and file repositories to facilitate communication and project management. - Create user-friendly interfaces for browsing projects, applying ...

I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.

I'm looking for a highly skilled professional to develop a comprehensive accounting website with functionality similar to TAXFYLE. Key Features To Include: - Efficient AI chatbot: The chatbot should be capable of understanding complex queries, providing personalized responses based on customer needs, and featuring an advanced search function. Its purpose is to instantaneously respond to user inquiries. - User friendly Invoice Upload System: Users should be able to effortlessly upload their invoices on the platform. - Company Formation Service: This significant feature should allow users to start their own companies. - Specific Services Post Login: Provide an exclusive area for users to initiate a company formation process and check out other services after they...

I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query ...modifications is to: - Display specific custom fields - Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP and MySQL Please provide examples of similar projects you have worked on, and explain your approach to modifying ...

I'm currently experiencing some problems with SQL Server 2019 regarding a synchronization error in my Snapshot Replication model. Present issue: - Synchronization process follows an error. Desired solution: - Ability to correct the synchronization errors to allow for smooth data replication. Ideal Skills: - SQL Server 2019 expertise - Solid understanding of Snapshot Replication model - Proven experience in troubleshooting synchronization errors. I'm seeking assistance from someone with these expertise, who can provide a quick and efficient resolution to this problem.

I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...

...delays using predictive models. Handle inquiries and provide solutions dynamically during service disruptions. Contingency Management: Develop a knowledge base with rules and plans for managing emergencies and unusual train service situations. Provide guidance and actionable steps to operational staff during emergencies through the chatbot. Technical Requirements User Interface (UI): Text-based or multimedia, adaptable to web or mobile platforms. Natural Language Processing (NLP): Understand and process user inquiries accurately. Knowledge Base (KB) and Reasoning Engine: Store and retrieve information, answer queries, and support decision-making. Prediction Model: Use historical data to forecast train delays and communicate expected arrival times. Database: Maintain recor...

I am looking for a Magento 2 developer who can help me fix a specific cron job error I've been experiencing. The error states "SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in". Ideal Skills and Experience: - Proven experience with Magento 2 development - Strong understanding of cron jobs and how they work within Magento 2 - Familiarity with debugging and resolving SQL integrity constraint violations Please note that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Int...

...developer for initial software development for a pathology lab. The software must be responsive, user-friendly, and robust, catering to patients, staff, and referring doctors. Here's what we need: 1. **Choice of Platform**: As the client, I am open to using Angular, React or PHP for the development along with SQL Server/MySQL for the database. Feel free to recommend a platform when you apply. 2. **Essential Modules**: - Building Patient Database (From existing Lab Software - Which will remain as is). This database will be used for Whatsapp , email , SMS Marketing (This also is part of scope) and also For Patient Web App interface. Whatsapp API interfacing will be required for sending and interacting with Patients. - P...

I'm looking for an experienced Xamarin developer to create an Android app for my real estate business. The app should have similar functionalities to the app and should connect to my SQL Server database. Key Features: - Property Search: Users should be able to search for properties in my database - Property Details: Users should be able to view detailed information about the properties - Favorites List: Users should be able to save properties to a favorites list User Authentication: - The app should allow users to sign in using their Email and Password. Property Search: - The property search feature should integrate a map view for a better user experience. Users should be able to visualize the location of the properties they are interested in. - ...

I need a developer to create a proctoring exam application using Python and SQL Server. The primary role of this app is to monitor candidate behavior during online exams. Key features include: 1. Online Registration Of Candidates: A feature for students to easily register for exams. 2. Password-Based Authentication: To authenticate candidates before they can access the exams. Prior experience in implementing secure login mechanisms is preferred. 3. Advanced Browser Disablement: Unfortunately, there will be instances when candidates try to cheat the system. I need to prevent this by disabling browsing other tabs, accessing other applications, and the copy-paste function during the exam period. 4. Random Image Capturing & Video Monitoring: To further deter any chea...

I require an expert to set up a CPanel template for my NeoBank website. Files are already uploaded, just need installing and SQL setup. Links to website setup provided.

"Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, in case of change not applied through Service. 6. Reading Frequency - 1 min, 10 min etc needs to be update in Regedit - HKEY_LOCAL_MACHINESOFTWAREVShieldService, Polling -1 7. Logs needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and keep a backup at local. api/logs/ { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Policy2": "2" } ], "removedPolicies": [ { "Policy3": "2" ...

Job Title: Senior Master Data Management (MDM) Developer Monday to Friday Remote via Zoom 2-3 hours/day IST Night (7pm to 12amIST) Salary: 30,000 I...Developer Monday to Friday Remote via Zoom 2-3 hours/day IST Night (7pm to 12amIST) Salary: 30,000 INR per month We are seeking a Senior Master Data Management (MDM) Developer with a focus on healthcare. Strong SQL skills for data manipulation and querying. Experience with ETL development and integration. Familiarity with Azure Data Factory and cloud/on-prem migrations is advantageous. One needs to be available in the mentioned timings and willing to work by screen share and remote control via Zoom. Skills Required: Master Data Management (MDM) ETL development and integration Strong SQL skills SSIS Azure Data Factory ...

...or invoice client) * Be able to Password Protect the site * pre configure services * pre cofnigure suggested price, can change price if needed * e-mail clients & myself (pre configured) * Save estimate & Invoice as PDF * Process payment using stripe using API * SQL Database to store client info for repeat customers * Search client up by name, phone, address, or e-mail * Ability to move database & php script to other domain if needed * Ability to Backup Script & DB with a click Desired Programming Language: PHP * I'm looking for the best deal possible, please be very competitive. * Milestone release upon completion of the project & is bug-free. * Need Source Code when Job is Complete, After any Bug fixes, and Updates ⭐⭐⭐⭐⭐ Please post &quo...

I'm in search of skilled translators who can help in translating a set of shopping platform queries on my E-commerce website. The translations must be accurate, without losing the intended message and context. Your tasks will include: - Translating the queries from Spanish, French, Italian, Corean, German, Turkish, Russian, Arabic, Japanese, Portuguese, Thai, Indonesian, Vietnamese, Polish, Ukrainian, Dutch, Hebrew to English - Ensuring the translated queries are culturally appropriate for the target language. Ideal candidates should have: - Proficient language skills in the above-mentioned languages. - Experience in translating technical documents, with a preference for those experienced in the e-commerce sector. - Attention to detail to ensure ac...

...PostgreSQL database that's optimized for handling textual, numerical, and image data efficiently. The database will serve as both a data storage and retrieval system and as an application backend. Key tasks include: - Creating the database structure to accommodate textual, numerical, and image data. - Ensuring the database is optimized for fast and efficient data storage and retrieval. - Implementing the necessary queries for both data storage and application backend functionalities. Ideal skills for this project are: - Proficiency in PostgreSQL database design and administration. - Experience in optimizing databases for various data types. - Strong understanding of data storage and retrieval best practices. - Ability to implement compl...

I am seeking a proficient Python and Java programmer to develop a desktop software for me. Key Responsibilities: - Software development utilizing Python and Java. Ideal Skills and Experience: - Proficient with OpenAI and creating queries with api - Flask or similar backend with javascript, etc, front end - Microsoft Azure deployment - Working with database - Proficiency in Python and Java programming languages. - Extensive experience in software development, specifically desktop applications. - Strong problem-solving abilities and attention to detail.

I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like ...

I'm in need of a seasoned IT specialist with diverse skills. Key Responsibilities: - Website De...with diverse skills. Key Responsibilities: - Website Development: You should be able to create websites from scratch, maintain them, and make necessary updates. - Data Analysis and Reporting: Experience in data analysis and reporting is crucial for this role. - Network Setup and Maintenance: You'll be responsible for setting up and maintaining our network infrastructure. - Software Development: A good grasp of various programming languages and technologies is necessary. Skills & Experience Required: - Proficiency in Python, Java, C++, Ruby, PHP, SQL, Dart, React.js, and javascript - Experience in project management - Strong background in software engineeri...

Hello, there? I have done the project. We can process as our promise. Is it possible to award? I will wait for you.

question is can you recover old domain to connect to my old sql database? if yes. please recover my webpage back.

I'm in need of an very experienced and talented web app developer to create a cutting-edge Software as a Service (SaaS) platform. The primary goal of this project is to establish a robust, scalable solution for my business that manage the offer and distribution of financial products like Bonds among players in financial markets. Key functionalities: - User Management and Authentication: The webapp will be required to manage and authenticate user information from 3 different profile as well as to manage the new user onboarding process in some steps like the pre registration, e-mail confirmation and admin platform release and competition of registration.A seamless user experience is paramount. A figma will be provided to help illustrate this flow. - Dashboard: A dashboard w...

...columns - There's frustratingly missing data in some cells This mess stands between me and importing the data successfully into my database. If you can efficienty wield the tools of data cleaning and if you excel at attention to detail, this could be the job for you. Skills and Experience: - Proficient in csv files management - Highly skilled in data editing, cleansing and validation Please note, I haven’t determined which software I'll use to import the .csv file. Your input on this area will be valuable! I'm open to MySQL, Oracle or MS SQL Server. Let's make things right!...

...experience in TypeScript frameworks for server-side rendering and React.js or Vue.js for web development, as well as React Native or Flutter for mobile app development. Responsibilities: - Develop user authentication and profiling features, including sign up, basic details collection, and user categorization. - Implement job posting functionalities, allowing users to create detailed job listings with prompts and boilerplate templates. - Design and integrate payment gateways, specifically utilizing Midtrans Indonesia for secure transactions. - Develop interactive features such as chat portals, notifications, and file repositories to facilitate communication and project management. - Create user-friendly interfaces for browsing projects, applying ...

Sila Dafter atau Log masuk untuk melihat butiran.

...or invoice client) * Be able to Password Protect the site * pre configure services * pre cofnigure suggested price, can change price if needed * e-mail clients & myself (pre configured) * Save estimate & Invoice as PDF * Process payment using stripe using API * SQL Database to store client info for repeat customers * Search client up by name, phone, address, or e-mail * Ability to move database & php script to other domain if needed * Ability to Backup Script & DB with a click Desired Programming Language: PHP * I'm looking for the best deal possible, please be very competitive. * Milestone release upon completion of the project & is bug-free. * Need Source Code when Job is Complete, After any Bug fixes, and Updates ⭐⭐⭐⭐⭐ Please post &quo...

I'm looking for an experienced AI developer who could build an AI calling agent for me. The agent will be programmed to handle a variety of call types - sales, customer support, and appointment scheduling. Key Capabilities: - Sales calls: The AI agent should be able to not just sell but also address any queries a prospective customer might have. - Customer Support: It should serve as a first point of contact to solve any customer issues. - Appointment scheduling: Setting up meetings is another primary function that the bot should handle. The AI agent will be deployed in the field of real estate and is expected to accomplish the following: - Qualify leads: It should be able to discern potential customers from casual inquiries. - Provide property informa...

I'm in need of a dedicated customer support agent with exceptional email management skills. The selected freelancer will be expected to: - Handle customer queries promptly and accurately. - Actively follow up on customer complaints ensuring each situation is resolved smoothly and efficiently. - Manage a high volume of customer interactions daily, typically 50 or more. The ideal candidate will have proven experience in a customer service position, strong problem-solving abilities, excellent written communication skills, and a positive, customer-focused attitude. Knowledge in using customer service software and databases will be a plus.

I'm in need of a talented customer service representative to provide phone support, email support, and live chat support. Key Responsibilities: ● Handle a low volume (1-50 inquiries per day) effectively and professionally. Improving customer service experience, create engaged customers and facilitate organic growth ● Manage large amounts of incoming queries through multiple channels (voice, in-app, email) ● Taking ownership of customers issues and following problems through to resolution ● Keep accurate records and document customer service actions and discussions ● Analyze statistics and compile accurate reports ● Follow communication procedures, guidelines and policies ● Take the extra mile to engage customers Skills and Experience Required: ● Experience in providing cus...

I have an existing Microsoft SQL Server database that I'm looking to migrate to a NoSQL database system. Ideal skills and experience: - Strong experience with database programming - Previous database migration experience - Proficient in both Microsoft SQL Server and NoSQL databases Please let me know your experience in such projects and the approach you would take to ensure a smooth and successful migration.

I have an existing Microsoft SQL Server database that I'm looking to migrate to a NoSQL database system. Ideal skills and experience: - Strong experience with database programming - Previous database migration experience - Proficient in both Microsoft SQL Server and NoSQL databases Please let me know your experience in such projects and the approach you would take to ensure a smooth and successful migration.

I have an existing Microsoft SQL Server database that I'm looking to migrate to a NoSQL database system. Ideal skills and experience: - Strong experience with database programming - Previous database migration experience - Proficient in both Microsoft SQL Server and NoSQL databases Please let me know your experience in such projects and the approach you would take to ensure a smooth and successful migration.

Job Title: Senior Full Stack .NET Developer Monday to Friday 2-3 hours/day IST Night (7am to 11am IST) Salary: 25,000 INR per month Job Descript...000 INR per month Job Description: We are seeking a highly skilled and experienced Senior .NET Developer to join our team. The ideal candidate should have strong proficiency in C#, ASP.NET MVC, and the .NET Framework, along with expertise in various web-related technologies such as HTML, CSS3, JavaScript, and jQuery. Additionally, familiarity with database technologies including SQL Server and T-SQL is essential for this role. One needs to be available in the mentioned timings and willing to work by screen share and remote control via Zoom. Skills Required: C# ASP.NET MVC .NET Framework Entity Framework HTML CSS3 JavaS...