Sql database university store project jobs

I have a magento webstore running on magento 2.3.4. I want to update it to the latest version with all patches, while maintaining current customers/database/products. I also want usps first class mail parcel/usps ground advantage to show up again as a shipping method.

I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring hostin...

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immed...

I'm looking for a skilled WordPress developer to assist me in creating a custom, multipage form using Contact Form 7. This form will have a unique requirement of collecting data at multiple points in a user's session. Key Requirements: - The form needs to be integrated with Contact Form 7 plugin - Should support multipage logic for better user experience - Collect and store user-provided data including: - Name and contact information - User input and preferences - Additional comments and feedback - Implement a method to save all incomplete form data. This data should be: - Sent to a designated email address - Stored in a specific page inside WordPress dashboard, already configured Furthermore, I require the setup of an export mechanism for this incomp...

...at this stage - I want to be surprised with your interpretation. A vital aspect of this website is a lead generator integrated with ZohoCRM for lead tracking. It should use the webform provided by Zoho. Additionally, the site should incorporate a store locator function, guiding customers to physical locations where our products are sold. Ideal skills and experience for the job: - Proficiency in WordPress and ZohoCRM integration - Experience devising and maintaining bilingual websites - Experience creating interactive and user-friendly store locator/maps - Understands GDPR requirements for collecting personal information through a lead generator. - Must work with graphic design tools to improve our product catalog - Must create the online catalog for our products By ...

I need a skilled web developer to create a fully interactive website for a university project. Key Features: - Discussion Forums: The website should have a user-friendly and secure discussion forum feature where students can interact with one another, engage in academic discussions, and receive support. - Online Quizzes: The platform needs to offer online quizzes. This includes a user-friendly interface, automatic grading, and a progress tracking system for students. Target Audience: The main users of this website will be students. The website should be appealing and engaging to this demographic. Ideal Skills: - Proficient in web development with experience in creating interactive websites. - Knowledge of discussion forum and online quiz functionalities. - Prior experienc...

...business user, I need assistance with the configuration of SSRS Reporting Service on a staging environment. I have configured the WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the ca...

I'm looking for an experienced SEO specialist to optimize my Google My Business (GMB) page at a city level, focusing primarily on keyword optimization. The ideal candidate would be someone who can confidently assure guarantied positive results, as success is key for our project. Our company o have retail store of Battery Operated three Wheeler. Therefore, knowledge and hands-on experience in this sector would be advantageous, particularly when pinpointing the most effective keywords to use. This project does not have a hard deadline and I am open to a flexible timeline. However, I would appreciate someone who can deliver guarantee results within a reasonable timeframe. We are into multiple business, will hire the person for other projects too. Ideal Skills: -...

...efficiency. Project Requirements: Branch-specific Design: Each of our four branches should have its own section within the app, complete with a unique logo and a tailored list of services. Service Listings: Detailed information on the variety of services offered at each location, including descriptions and pricing. Custom Pricing: The application should display different pricing structures for each branch, reflecting our diverse service offerings. Appointment Booking System: A straightforward, user-friendly system for customers to book appointments. This system should integrate smoothly with each branch’s schedule to offer real-time availability. Platform Availability: The app should be developed for both Android and iOS platforms, with deployment on Google Play and the A...

... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicate...

I've got an exciting project for skilled Android developers. My vision is to create a Matka gambling app, targeted at the general public. I have three key functionalities that need to be incorporated: • User Authentication: It's crucial our user base is securely authenticated to ensure a safe environment for all players. • Push Notifications: Our users need to stay updated with new features, game-related alerts and other relevant information. Using push notifications, we will keep our users engaged and informed. • APK to ABB file: I need the app converted to an Android App Bundle (ABB) for uploading to the Google Play Store. If you have mastered Java and Kotlin languages, have experience with Android SDK, and are familiar with secure user authe...

I'm seeking a skilled developer who ...main responsibility on the design front involves refining my site's navigation. This implies that you'll need to understand how the navigation menu is currently arranged and accurately remove specific items. - Database Optimization: I am excited to augment the performance of my website. For this, I require optimal reformation of the existing database structure. This task demands proficiency in managing Laravel databases and an understanding of optimization best practices. The ideal candidate for this project is detail-oriented and exhibits a strong understanding of Laravel, database optimization techniques, and UI/UX principles. Knowledge of the latest design trends and how to selectively prune menus for us...

I'm looking for a PyG expert to help me predict links in my e-commerce heterogeneous graphs. The main goal of the project is to predict links in the e-commerce data graphs. This task is essential for understanding and predicting customer behavior in my online store, which is crucial for improving services and increasing sales. Ideal skills and experience for the job include: - Expert proficiency in PyG (PyTorch Geometric) - Prior experience with link prediction on heterogeneous graphs - Strong understanding of e-commerce data and its characteristics Your role in the project will involve working closely with the e-commerce data, understanding the underlying patterns and relationships, and building a robust link prediction model that can be utilized to make in...

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including t...number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Excel.

...conceptualize and execute a modern design for a 250ml Energy Drink Can. Key Responsibilities: - Develop a unique, modern look that conveys energy and excitement. - Ensure design stands out on store shelves amongst competition. - Incorporating mandatory information into the design layout. Ideal Candidate: - Has experience in beverage packaging design, with a portfolio showcasing this. - Can work quickly and efficiently to meet a 'ASAP' deadline. - Able to effectively communicate throughout the project, providing updates and revisions as needed. If you think you're the right fit for this project, please include examples of your previous work in your proposal. Inspire yourself of our website Not too much colors please. The name of the DRINK i...

Please bid based on the actual price you believe it will cost, not just to get in our inbox. We are a hosting company looking to automate our services through our WordPress site. This project involves two main tasks: creating a custom WordPress hosting management plugin and integrating Snipepay as a payment gateway in WooCommerce. Our hosting company currently sets up client accounts manually through a control panel that supports API integration. The successful development of this project requires extensive knowledge of this API to enable full automation of the account setup, hosting package ordering, and management processes directly from our WordPress site. The developer will need to ensure seamless communication between our WordPress interface and the control panel's...

I'm in need of a custom Android application that will help me manage my daily tasks and ke...Tracking: - Manual entry of expenses: I'd like the app to have a simple interface where I can manually input my expenses. - Categorizing expenses: The app should allow me to categorize my expenses for better organization. I'm not looking for a complex or feature-heavy app. The focus is on the functionality and ease of use. Also, I'm not interested in having the app published on the Google Play Store; an APK file for personal use is sufficient. Ideal Skills: - Android App Development - User Interface Design - Task Management System - Expense Tracking System Your experience in developing similar applications will be highly appreciated. Feel free to ask any questions...

Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )

I need an expert to design a DICOM database specifically for storing and retrieving radiology images. Key requirements are: - Comprehensive understanding of DICOM Standards - Proficiency in database design and administration - Experience in handling medical images, particularly radiology The proposed database should support retrieval of images via Unique Identifier Codes (DICOM's UID). Being well-versed in medical systems integration will be considered a great advantage. This project will require strict adherence to privacy regulations and standards.

I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.

...bring this vision to life. Key Features: - Cloud-Based POS: The system should be user-friendly and accessible from any location. - Inventory Management: The POS should allow for easy tracking and management of ticket inventory. - Sales Reporting: I need a comprehensive sales reporting system that provides insights on movie ticket sales. - Customer Management: The system should be able to store basic customer details for future marketing and analysis. The Ticket Sales: - The ticket sales will be done physically at the theatre; hence, the system should be optimized for this environment. - The Android app should provide a user-friendly interface for sales staff to process ticket sales and manage customer transactions. - Integration between the cloud-based system and th...

I'm seeking a proficient Shopify web designer who can breathe life into my project. Key requirements include: - Developing a product catalog and an efficient shopping cart system. - The primary purpose of the website will be selling physical products. - A vibrant and energetic aesthetic is ideal to align with the brand identity. Strong expertise in Shopify's diverse features is crucial for this role, coupled with an unerring eye for vibrant and dynamic design cues. Demonstrate a strong understanding of brand consistency to qualify for this role.

I need a proficient data specialist to compile a comprehensive database of Romanian companies. - Compatibility: The database must be compatible with Windows and Mac platforms. - Specific Details: Every company's record in the database must contain the company's name, phone number, and email address. - Extent of Database: Aim for a sizable database that contains information about 100,000 companies. Ideal candidates will have experience in data mining and database management, and an understanding of Romanian market dynamics. Strong accuracy and attention to high-quality data is a must.

I want to integrate the categories and subcategories provided by the suppliers into my woocommerce store.

Needs to hire 2 Freelancers Fitny, a leading fitness app specializing in stretching and gym instructions, is seeking two skilled and dynamic Black coaches or sports professionals, one male and one female. The selected candidates will participate in a content creation project to produce educational photo and video materials for our app. This freelance opportunity offers a chance to showcase your expertise and contribute to a growing fitness community. Key Details: Location: Filming will take place in Cyprus in May. Duration: The shooting period will last for 10 days. Content: The content will focus on basic gym exercises, predominantly without audio instructions. Responsibilities: - Demonstrate proper exercise techniques for filming. - Collaborate with the app's in...

...candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name

I am working on a Market Research Project, for which I looking for someone living in Mexico. And are open to recording a video of 5 minutes or more in length each which would be recorded shopping IN-STORE (videos can be recorded using their smartphones). One shopper needs to record 2 unique videos. Also, if you can have your friends/family record videos for you then you can earn more with it. For more details please reach out to me.

I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.

I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter...

I am in need of Employment verification services for my pre-employment vetting process. Skills and Experience Required: - Experience in conducting education/employment verification checks - Familiarity with the educational system and institution in University Hospital Of Tours. Additional Information: - Attention to detail and accuracy are crucial in ensuring the accuracy of the verification process. Candidate Volume: - The project involves vetting 1-5 candidates. Please note that this project does not require additional verification services such as drug testing, credit checks, or social media screening.

I need assistance to perfect the login and dashboard functionalities of my nearly complete store inventory management system website. I require a polished user registration and login process, including: - Email verification for new users - Password recovery mechanism for existing users - High-security two-factor authentication protocol These implementations are crucial for maintaining a secure and user-friendly environment for me to release the website to end-users. I'm seeking professionals experienced in user interface creation and user experience enhancement. The project needs to be executed and completed ASAP, so timely delivery is important. Experience with similar projects would be advantageous.

I'm looking to develop...experience. Key Features: - Personalized Recommendations: The website should utilize AI to analyze user's browsing behavior, purchase history, demographic info, and other relevant data to suggest tailored products. - Whatsapp Business Integration: A key part of the project is integrating with WhatsApp Business to provide seamless customer support and order processing. - Merchant Dashboard: The platform will incorporate a dashboard for merchants to track sales, manage stock, and oversee their online store. The ideal candidate for this project is a developer with experience in e-commerce and AI integration. Proficiency with WhatsApp Business API and merchant platforms would be highly valued. A strong understanding of fabric clothing m...

We are looking for an e-commerce development agency for a plant-based product manufacturer. The agency will take over the management of the e-commerce store. The agency will be responsible for: - Website performance - Update content - Social media - Design of website - Connect with amazon - Metrics and sales funnels - Promotional campaigns - Setup whole sale operations - End to end update of the webshop to make it more higher converting andrevenue generating Who are we looking for: - Agencies who has total focus on e-commerce - Can do end to end support - Can show a list of projects they have worked on - Small, budget friendly company

...candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name

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 ...

...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: - Proficie...

...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: - Proficie...

...the website and the database we use to run our suppliers prices. Our stock database was designed by me and built by our then developers. We also link into accounting to import customers orders and convert to invoices. We also link / interface to Ideal skills for this project would include: - Proficiency in Opencart system development - Strong UI/UX design capabilities, especially in mobile responsiveness - Experience in developing and implementing referral programs in e-commerce systems - A good understanding of security features to ensure customers' data is protected - Excellent communication skills to understand and deliver on the specific requirements Please note that I'm open to any suggestions or proposals that you may have to enhance this ...

I'm in need of a logo for my upcoming online store, "The Pink Spot". The concept is centered around selling women's clothing and accessories. Name: The pink spot We will sell women's clothes and accessories, we want it to be a pink background with black letters (if something else in letters is suitable, we can see it) to definitely have the check mark in it, like google map spot. We want the color baby pink Key Points: - Color Scheme: The logo should feature a pink background with black letters. - Style: I'm looking for an elegant and refined font, something that speaks to the target audience of women. - Design: It should include an icon. The icon should be relevant to the brand and the products we are offering. Ideal Skills: - Experienced in logo d...

I need a skilled professional to conduct a thorough review of my Shopify store. I'm primarily concerned about: * Navigation and user interface * App integration issues * Store performance and speed With 5-10 apps currently installed, the review should confirm that they are best practice and working efficiently. The freelancer should have significant experience with Shopify, UI/UX design, and ecommerce app integration. Recommendations for improvements are expected. Let's enhance the shopping experience and performance for my online customers.

As a forward-thinking business, we're looking to have a replacement app developed for our Shopify store. This app will replace our current Tapcart app, providing our customers with a sleek, user-friendly, seamless mobile shopping experience. Key Features: - Product Catalog: The app should showcase our entire range of products, with easy-to-navigate categories, filters, and search functions. - Shopping Cart: A seamless and secure shopping cart is essential, facilitating worry-free transactions. - Push Notifications: Ability to send targeted push notifications, informing our customers about our latest offers and updates. - Integrations: The app needs to smoothly integrate with Wishlist, loyalty schemes, and various social media channels. Platforms: The replacement app needs t...

I require a skilled graphic designer to create a logo for our home & kitchen products brand "COSRAAN". The logo will be applied across various platforms, particularly our e-commerce store. Here are some specifics: - Color Scheme: Incorporate the color blue predominantly in the design. - Style: Unique - Given the brand's emphasis on "unveiling the beauty within your walls", the logo should encapsulate this spirit. - Symbols: No specific symbols are requested given the last question was skipped by the client. However, creativity with incorporating relevant elements affiliated with home and kitchen are encouraged. - Deliverables: Please provide a source file with all relevant fonts and design elements. Please DM me if you have any questions or requir...

I'm in need of a proficient database specialist to manually collect email addresses and phone numbers, and compile them into an efficient and reliable database system. The leads to be collected are specifically from the Social Media industry. Ideal Skills and Experience: - Proven experience in data collection and management. - Exceptional research abilities, particular in the social media landscape. - Ability to use manual collection methods efficiently and effectively. - Knowledge and understanding of database management and lead generation. - Accuracy and attention to detail in dealing with phone numbers and email addresses. Roles: - Locating and collecting required data from specific direct websites. - Organizing the data into a systematic database...

I need someone who can finishg my shopify store. we started but we have a lot of bugs.,

Request for Proposal (RFP): Mobile Application Development Introduction: We are inviting proposals from freelancers, teams, or vendors to develop a comprehensive mobile application and a supporting website. This application is designed to cater to a diverse audience. The project will include features for content creation, management, and user engagement through intuitive interfaces. 1. Project Objectives: - Develop a dual-platform mobile application compatible with iOS and Android. - Establish a minimalistic website for administrative purposes and to serve as a marketing portal. - Provide a seamless user experience akin to popular media streaming services like Netflix. - Construct a scalable and secure backend architecture utilizing Google Cloud Platform (GCP) or Amazon Web...

I need a Zapier expert to create a flow that will automate the discount application process on my Shopify store from a Google Sheets CSV. Key Requirements: - The ZAP should identify new email addresses added to the CSV, and then add a customer tag "REGATHLETE" to them in Shopify. When the tag is added, they will be eligible to use that discount, as we have already created a customer segment for customers with the tag. - The ZAP must be able to add the tag both to new and existing customers in our Shopify database. Required Skills: - Proficiency in working with Zapier - Experience in creating Zaps with google sheets and matching CSV/data fields - Experience in automating processes and dealing with CSV files. The timeline is asap, and the budget for this is £...

I'm seeking an expert in Entity-Relationship Modelling and Rational Database Design. Key Requirements: - I need an expert in this particular area. Please only apply if you have a proven track record in both Entity-Relationship Modelling and Rational Database Design. - I'm looking for a high-level overview of the Entity-Relationship Diagram. This means I don't need every minute detail, but rather a clear and concise depiction of the core entities and relationships. - Experience is key. Please share your past work in this field. Ideal Skills: - Proficient in Entity-Relationship Modelling - Experienced in Rational Database Design - Strong track record in this particular project type - Excellent communication and understanding of client needs. ...

We are from De Risc Backgrounding screening company based in UAE. we want to verify an Education certificate from a institute in Odense, Denmark. I am in need of Education ve...verification services for my pre-employment vetting process. Skills and Experience Required: - Experience in conducting education verification checks - Familiarity with the educational system and institutions in University Of Southern Denmark. Additional Information: - Attention to detail and accuracy are crucial in ensuring the accuracy of the verification process. Candidate Volume: - The project involves vetting 1-5 candidates. Please note that this project does not require additional verification services. If you have the necessary skills and experience to assist with this project...

I need a capable graphic designer who can create 2-3 urban-themed backdrop designs for my store. The backdrops should be medium in size, ranging from 5x5 to 10x10 feet. Ideal Skills and Experience: - Proficient in graphic design - Experience in creating backdrops or large-scale designs - A keen eye for urban aesthetics - Able to deliver 2-3 unique designs - Can work in close collaboration with me to ensure the ideas are aligned Please include relevant samples of your past work in your bid.

...Water Heater Brands in the store (focus on electric instant and storage water heaters): Visit 1x store (pick the biggest and most popular store) of each Major Retailer. Then compile a list of popular water heater brands, including pictures, prices, and key features. Highlight the most sought-after brands in each country. 3. Online Platforms: Document online platforms selling water heaters, providing links to their websites and additional information. Additional Points to Consider: • Availability of different water heater types (e.g., tankless, storage) • Warranty and after-sales service offered by retailers and brands • Customer reviews and ratings for various brands and models • Government regulations or certifications affecting the sale of wat...