Simple sql punët
Pershendetje Glen. Jam e interesuar per ndihmen tuaj ne SQL. Do te me duhet ndihma jote ne nje provim neser. A mundeni te me ndihmoni me nje shume prej 10 euro per 1 or e gjysem?
Programing in Dot Net & SQL Server. Visual Studio 2010, SQL Server 2012 Express ose më të avancuar. Modify existing modules, add modules, design interface, Reports...etc
Desgin an Admin Theme for simple HTML Web Site
We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data ...
...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...
...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...
I'm looking to upgrade my current system, perhaps keeping the current Opencart (V1.52) system and 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 v... 4. Any other 3rd party systems (including internally) that the website communicates with (sending data either way) and any data grabs. NO 5. Confirmation of payment gateways used. Realex (redirect to payment interface), PayPal 6. How the databases (products, customers, orders) are stored and if the data can be exported. Standard OC table structure… yes it can be exported as SQL data dump and all the products to stock link via the export featur...
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.
I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.
I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.
...calculate the hourly rate and the time needed to complete different task documents, on an agreed 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....
I need a ...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 or a similar back-end programming language - Strategic problem-solving skills and attention to detail The success of this project requires not just technical expertise, but also a clear understanding of travel agency operations and the importance of efficient booking management. If you have relevant experience and the right skill set, I look forward to...
I'm looking for a skilled AutoCAD designer for a mechanical design project. You'll be responsible for creating a simple drawing with few parts. Key considerations for this project include: - Emphasising dimensions within the design - Including detailed material specifications - Clearly indicating connection details Ideal skills for this project: - Proficiency with AutoCAD, with a focus on mechanical design. - Strong attention to detail to clearly display all required elements. - Experience interpreting and applying design specifications. Please add samples of relevant work to your bid.
The icon should look exactly like this, but should say "Most Savings"
I'm seeking a talented web designer who can create a simple website for me. Key Requirements: - A clean, simple and professional design - Incorporation of text and images The site will be minimal, with only a few pages, so the project shouldn't be too complex. Ideal Skills: - Web Design - Graphic Design Please include a portfolio of your previous work in your proposal. I'm looking forward to reviewing it.
I'm seeking a reliable and competent coder, open to any programming language, be it JavaScript, Python or Java, etc. The complexity of the task is simple, shouldn't pose a challenge for an experienced developer. - Ideal Skills: Proficiency in any high-level programming language, with a track record of successfully completed projects. - Application Requirement: Your application should showcase your past works, preferably related to the project at hand. This will allow me to gauge your skill level and suitability for this project. Looking forward to your bid.
I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using 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 f...
I am looking for Dafny developer that can implement two simple functions, with proofs, asserts and lemmas to show it really works as intended.
I am looking for Dafny developer that can implement two simple functions, with proofs, asserts and lemmas to show it really works as intended.
...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 API POST call (this endpoint is developed you need to call this Only) and keep a backup at local database. POST JSON - { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Policy2": "2" } ], "removedPolicies": [ { ...
We need an online Virtual assistant to help us with our company tasks such as social media posts, research data entry etc... The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role.
I'm in need of a React application that will serve as a simple login system. The app will be using MongoDB to store user login information. Process will be: User logs in. Their login information persists in their state and they can create a user profile and access their user profile Log out and log back in
Homepage: Hero Section: Headline: "Delivering Peace of Mind: Reliable & Secure Courier Solutions" Subheading: "Specialized Same-Day Courier Services for Healthcare and Businesses" Call to Action: "Get a Quote" or "Contact Us Today" Background Image: [Image of a Quiet Craft Solutions INC delivery vehicle parked in front of a hospital or medical facility, showcasing professionalism and healthcare focus] About Us Section: Company Overview: "At Quiet Craft Solutions INC, our mission is to deliver peace of mind through dependable, secure, and timely courier services. We are committed to exceeding customer expectations by leveraging our expertise, technology, and dedication to excellence. As a Service-Disabled Veteran-Owned Small Business (SDVOSB)...
I'm seeking a skilled freelancer who has experience with creating Airtable Dashboards. I posted this previously but I wasn't very clear on specifically what I needed. Please do not respond with an auto-reply as those bids will be ignored. Here is specifically what I need help with: I currently have a database setup in Airtable. It has all the data that I need for my dashboard inside. But special formulas will be needed to calculate certain aspects of the dashboard. Example: I receive a total of 4 individual payments from a vendor. I initially receive 3 of the 4 payments a week after the sale, but I don't receive the 4th payment until ~a month later. Each payment is a separate row in Airtable, but the grouped payments all use the same SAN#. Therefore, I need Airtabl...
...for jobs, and managing profiles and portfolios. - Build an admin portal with role-based access for monitoring user activity, managing complaints, and generating reports on job listings and user satisfaction. Preferred Tech Stack: - Front End: TypeScript framework with Server Side Rendering (React.js or Vue.js for web, React Native or Flutter for mobile) - Back End: Utilize GCP services (Cloud SQL, Cloud Functions, etc.) - Payment Gateway: Midtrans Indonesia. This work is going to be divided into 6 major stages, corresponding to 6 milestones: 1. Planning 2. Designing (Software design) 3. Developing 4. Testing 5. Implementation & Integration 6. Maintenance Details upon each stage will be discussed through online meeting If you're passionate about creating innovati...
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 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...
Hello See this short video of what I need done = !AnaknzarFP1X1kt2ispbIwh-z-Q2?e=2eBDNY Can you do it right now?
I have a very small dataset and need to do some statistical analysis using SPSS. Need the results in 2 days due to small dataset. Key Responsibilities: - Conducting hypothesis testing using SPSS - Descriptive statistical analysis - Interpretation of the analysis - etc. See the attached files. Ideal Skills and Experience: - Proficiency in SPSS - Strong background in hypothesis testing The answers should be clearly written in a word document. Should you choose to take on this project, please be prepared to start immediately.
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]: Integrity ...
i need to get build a simple android mobile app. This is based on games. The app must have links open in its own platform. It must operate like a browser.
I'm seeking a talented full stack 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. - Patient Web A...
...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. - It should also include the option to save searches, which will be a convenient feature for users who are actively looking for properties. Ideal Skills: - Proficiency in Xamarin development - Experience with ...
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 cheating, the appl...
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 Cloud/o...
...set of Prev_page/Next_page buttons we should be able to scroll the currently selected file one page at a time. I hope you understood the functionality I want. Also, the app should be able to detect the aspect ratio of each page in the pdf file so that it displays it in 100% view without distorting the text or the images in the pdf file. Please kindly let me know if you can develop this very simple app. Also, the app should be a single standalone exe file. That is, it should not require any sort of installation process to install it. It should just run as soon as we double click it. I believe you can use the pyinstaller app to develop such a single standalone exe file. By the way, I need the file to be developed in python, and all source files should be provided together with ...
* Set label to Estimate or Invoice (using the same form to either quote client 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 Com...
I'm in need of an experienced developer to create my Shopify store from scratch. This is a single product online business selling sunglasses and I have both high-quality images and descriptions ready to use. Your task will involve: - Developing a clean, user-friendly e-commerce website. - Setting up a product catalog and managing inventory for one product. - Ensuring secure payment processing pathways are integrated. This must include the popular credit and debit cards, along with other online payment systems. - Integrating the site with social media platforms for increased visibility and customer interaction. Key skills include Shopify development, e-commerce, inventory management, payment gateway integration, and social media integration. Previous experience in developing singl...
I am in need of an individual with proficient skills in data entry for a simple text word document project. Requirements: - Ideal candidates will have a strong background in data entry with a high accuracy rate. - A keen eye for detail is necessary to ensure the entered data is correct and coherent. - Experience with word processing software is crucial, specifically within Microsoft Word. - This project involves purely simple text data, so no complex calculations or figures will be worked with. Objective: - Transform supplied plain text data into neatly structured, accessible Word documents following guidance I will provide. If you feel that this fits your experience and skillset, please provide evidence of any previous data entry projects you've completed.
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 to hear from you.
I'm in need of a seasoned IT specialist 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 da...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 engineering Looking fo...
I have three performances of the same song: vocal, guitar, and the same guitar from a different angle. I need to edit these into a single video, switching between the shots dynamically and sometimes combining 2 or 3 at the same time. Here are a few references: Here's a folder with the music and the videos, all in sync: Requirements: - Choose the best shot(s) for every moment of the song. - All videos have been glued from smaller clips, and there are obvious abrupt snaps between those clips. Please hide them by jumping to another angle or musician. - When you combine 2 or 3 vids please use thick white borders (collage style) like this: - No other effects are required. - 4K, MP4, H.264 I'll run the conest in 2 phases: pre-selection and selection. Pre-selection phase: -...
I am looking for a UK based professional with experience in patenting design rights to aid in the protection of my unique household item. Key Responsibilities: - Navigating the process of design patent registration - Preparing necessary legal documents - Providing advice on design protection strategy Skills and Experience: - Expertise in Design Patent Law - Previous work in patenting simple, non-interactive design - Our product we make is an outdoor imitation rock , designed to store either a pet or humans cremation ashes safley inside.
