Many to many relationship sql query jobs
I'm an individual start-up seeking a dedicated team for ongoing maintenance and updates for my Flutte...experience require the most attention. - The code can be complex, so I'm looking for someone flexible, patient, and capable of adjusting, fixing errors, and debugging as necessary. - As a start-up, budget is crucial. Ideal candidates would have extensive experience with Flutter, Firebase, and Google Maps API, with a knack for UI/UX improvement. I value a friendly and cooperative working relationship, with a team who understands the needs of a start-up. Please note that I have not yet determined a specific method for tracking bugs and errors, so flexibility and initiative in this regard would also be appreciated. Thank you. Please view the app on stores before biddin...
I'm seeking an experienced assistant to help me prepare for an interview for an AWS Cloud PostgreSQL DBA role. The training will specifically focus on Postgres-centric DBA tasks, with an emphasis on database performance tuning. Key Areas of Focus: - Database Performance Tuning: This is a critical aspect of the training. I need to understand how to fine-tune the database for optimal performance. - Query Optimization: I would like to delve into the intricacies of making queries run as efficiently as possible. - Index Management: Understanding how to manage indexes effectively will be a key part of our sessions. - Monitoring and Diagnostics: I need to learn how to monitor the database and diagnose any potential issues. Ideal Candi...
We already have a MySQL cursor with a loop set up to fetch values and perform certain calculations. We need an experienced MySQL developer to extend this cursor with additional logic to populate more values into the table in the most efficient way possible, with minimal overhead on the database. I will provide an Excel spreadsheet with simple formulas required to replicate the logic. The extension involves implementing approximately 9 additional calculations and updating a different table using simple IF statements based on the calculated values. Key Requirements: • Extend the existing MySQL cursor, which already has a loop set up for fetching values. • Implement about 9 additional calculations based on simple formulas provided in an Excel spreadsh...
I'm seeking a PostgreSQL DBA expert to help me become professional in database tuning and optimization. Focus Areas: - Query Performance Analysis: Understanding how to assess and improve query efficiency. - Index Management: Learning how to create, modify and delete indexes for optimum performance. - Configuration Settings Adjustments: Gaining skills in fine-tuning database settings for peak performance. The ideal candidate would be one who can deliver personalized one-on-one training sessions tailored to my learning pace and style. Please include your relevant experience and approach to teaching in your proposal.
To answer your query, here are the details for each point: 1. Ideas for projects for recruiters: Projects could include developing a structured interview process, creating a candidate persona template, automating follow-up emails, or implementing an Employee Referral Program. These focus on improving hiring efficiency, candidate experience, and the overall recruitment process. 2. Technical tools or systems to assist with recruitment: This could involve researching and implementing Applicant Tracking Systems (ATS), AI-driven resume screening tools, or data visualization dashboards to analyze hiring metrics like time-to-hire or quality of hire. 3. Examples of completed projects by recruiters: Examples might include successfully reducing time-to-...
I'm looking for a skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirements: - Design a stored procedure primarily for data retrieval. - Proficient in managing joins across multiple tables. - Understands and can maintain foreign key relationships. Ideal Skills: - Proficiency in SQL and experience with stored procedures. - Strong understanding of database management and relational databases. - Excellent problem-solving skills to handle complex data retrieval tasks.
...thesis writing, specifically for chapter 2 (Literature Review) and chapter 3 (Methodology). - Chapter 2 should cover various aspects of e-wallet usage and its impact on millennials in Selangor, Malaysia. Here are some potential research objectives for studying identify the relationship e- wallet use and continuous intention among millennial’s : The specific objectives are: 1) To identify perceived usefulness and perceived ease of us of e-wallets among millennials. 2) To identify the role of use trust. 3) What is the relationship between perceived usefulness, perceived ease of us and continuous intention. - Chapter 3 should be written with a focus on a Quantitative research methodology. Of survey by 399 participant from 1 million millenials **** Must...
...thesis writing, specifically for chapter 2 (Literature Review) and chapter 3 (Methodology). - Chapter 2 should cover various aspects of e-wallet usage and its impact on millennials in Selangor, Malaysia. Here are some potential research objectives for studying identify the relationship e- wallet use and continuous intention among millennial’s : The specific objectives are: 1) To identify perceived usefulness and perceived ease of us of e-wallets among millennials. 2) To identify the role of use trust. 3) What is the relationship between perceived usefulness, perceived ease of us and continuous intention. - Chapter 3 should be written with a focus on a Quantitative research methodology. Of survey by 399 participant from 1 million millenials **** Must...
We are seeking an experienced AWS backend developer to help us design, implement, and finalize a robust data pipeline that meets both functional and operational requirements. This pipeline will enable scheduled ingestion, transformation, and analysis of API data and provide a RESTful API to dynamically serve data to our website. Objective To create a cost-effective, highly available, and secure AWS-based backend architecture that ensures seamless data ingestion, transformation, and real-time interaction with our website. Key Responsibilities Data Ingestion Schedule Python scripts using AWS Lambda to fetch data from APIs. Handle API rate limits, errors, and retry mechanisms. Store raw data temporarily in Amazon S3. Data Parsing Clean and structure raw ...
We are a small healthcare start-up based in the UK. We have an iOS and Android App built using -React native. -Firebase The App has been live for 2 years with many thousands of users. We use Firebase as a backend database. We are looking for a long-term development partner. The app is currently live on Android and iOS. 1. The Android app needs an API update. 2. The Android app also needs a Billing library update. 3. Update iOS app firmware too. 4. Successfully upload to iOS and Android stores 5. Fix some minor bugs 6. Improve user interface This will be the first stage, I am looking for more updates later on.
I've got a relationship counselling website that just needs to be made mobile and tablet friendly. The website is basically done, I just need a professional to ensure that it works seamlessly across all devices. Key requirements include: - Mobile and Tablet optimization: The entire website needs to be fully responsive and user-friendly on mobile and tablet screens. - Special attention to Navigation Menus: These need to be particularly well optimised, as they are crucial for the user experience on smaller screens. Ideal skills for the job include experience with mobile website optimization and a keen eye for ensuring a smooth navigational experience.
...construction and signal analysis and detection. I need you to design the SDR system I need and Provide the list of inexpensive equipment, instructions to assemble the handheld unit, and I need you to build the software I need. Please send me samples of your SDR projects that are close to what I need. I want to be able to detect distance, strength, direction, interference, etc... including elevation, and to be able to 3D graphic map everything. I would like to analyze 1Hz to 300GHz I know this is a wide spectrum, can you design an all in one small handheld that is inexpensive and that can see all these frequencies? The device needs to be handheld portable that is inexpensive and easy to assemble and ge...
About Us: We are a dynamic and fast-growing social trading platform, empowering traders to leverage cutting-edge Machine learning AI Models and share trade ideas within a thriving community. Our team of seasoned traders consistently delivers remarkable results, and we’re expanding to bring on more talented individuals to use our platform and tools to improve their trading. We’ve established partnerships with funds managing $200 million in AUM and have spent 7 figures developing these AI forecasting models. They’re partnered with funds exceeding $6 billion under management. Every trader has said they have never seen tools as good as this. And we have amazing reviews and case studies from our clients. We’ve also recently developed a softw...
I need a professional who is adept at using SPSS for analyzing survey data. The primary focus of this analysis will be descriptive statistics. Key Analysis Components: - Mean and Standard Deviation: I want to understand the average responses and the variation in the data. - Frequency Distributions: I need to see how often certain responses occur. - Cross-tabulations: This will help me understand the relationship between different variables in the survey. The ideal freelancer for this project would have a strong background in statistics and experience analyzing survey data using SPSS. Please provide examples of similar projects you have completed in the past. The survey is about study abroad and global perspective (higher education). This is a time sensitive project...
Points to Work On: Considering that the website’s color palette must be respected, and ensuring that, despite the complexity, the information remains simple and clear for the user. Currently, my website operates with two different filters or search engines: H-Book and WP-Booking, which means the client has to perform two searches. This greatly affects usability, and it also creates difficulties for me to manage two calendars and many plugins. Therefore, I’d like to simplify it with just one search engine. --- 1. CHECK IF EVERYTHING CAN BE DONE WITH H-BOOK Unify and optimize the search filter: Remove the current search filter from WP-Booking, which only shows available houses. Keep and improve the H-Book filter, configuring it to ...
Please Note: We’ve included a few screening questions at the end of this listing. Answering them is important for us to understand your experience and fit for the role. Proposals without answers may not be considered. Overview: We’re a small agency looking for a versatile professional who can “wear two hats” during this growth phase. In this full-time, remote role, you’ll balance responsibilities between managing HubSpot operations and contributing to development projects. This position is ideal for someone who thrives in a flexible, collaborative environment and wants to help shape our tools and processes as we expand. --- Key Responsibilities HubSpot Administration: - Design, optimize, and troubleshoot workflows for marketing...
...dynamic, and versatile Social Media Manager, Content Creator, and Brand Specialist to take charge of our social media presence across all platforms. This role requires someone who can wear multiple hats, from crafting visually stunning graphics and videos to building meaningful connections with our audience. You’ll be responsible for designing and executing content that is promotional, educational, entertaining, and engaging, while maintaining the voice and vision of our brands. Your primary goal will be to grow and nurture our social media following, drive engagement, and create a sense of community for our followers. You will need to design content such as graphics, short-form videos, and captions that speak to a diverse audience, balancing pr...
We are seeking a detail-oriented and creative specialist to rename JPEG files based on their content and the ideas they convey. This is a long-term position with steady daily work. Responsibilities: - Rename 1,000 files per day, 6 days a week. - Create descriptive and meaningful file names with a minimum of two words (preferably more, if it enhances clarity). - Use underscores (_) instead of spaces in file names (e.g., ). - Retain the original file name and append the new name to it (e.g., becomes ). - Focus on conveying the concept or meaning of the image rather than describing it literally. For example, an image of a person holding a flag on a mountain should reflect themes like "achievement," "success
I'm currently grappling with Many-to-Many relationships in Power Pivot, specifically dealing with sales and event data by SKU. My primary aim is to enhance the precision of my data analysis. However, I'm facing difficulties with incorrect data aggregation. I cannot build a relationship from the Proof and Unique Events table in the photo provided. Skills and Experience Needed: - Extensive experience with Power Pivot - Proficient in managing and interpreting sales data - Expert-level understanding of Many-to-Many relationships - Ability to troubleshoot data aggregation issues
...ideal candidate will be responsible for lead generation, client relationship management, and market research, specifically targeting the North American market. Key Responsibilities: - Lead Generation: Identifying potential clients and opportunities within the AWS sector. - Client Relationship Management: Building and maintaining strong relationships with clients to promote business growth. - Market Research: Understanding and analyzing the North American Technology market, specifically the AWS sector, to identify trends and opportunities. Ideal Skills and Experience: - Proven experience in business development within the Technology industry, preferably with a focus on AWS. - Strong skills in lead generation, client relationship management, and market...
...that do not incorporate it will be rejected. I have a concept drawing that I would like to be turned into a final product. This design will serve as inspiration for a copper backsplash in my home. The primary style is rustic, so the design should reflect this. Key elements to include: - Shapes from the concept drawing. - The finish should be an antique style, as opposed to matte or polished. Ideal skills and experience for the job: - Strong background in interior design, particularly with rustic styles. - Proficient in design software to create a detailed and accurate final product. - Ability to interpret and work from a concept drawing. -Add background features such as mountains and lake shoreline to the concept drawing -Inspiration is ch...
...website with a new UI/UX but keeping all functionalities and links to the same database. The new design should align with the provided Figma prototype (but with old website data and sections and with new design) in terms of colors and modern aesthetics, with an emphasis on ease of navigation and responsiveness. old web site: figma design: Key Requirements: - All components from the old site must be retained and linked to the same DB, but with a new identity. - The design must be compatible
I'm in search of a skilled developer or team to help design and develop a personal alarm services app. This app needs to be available on both iOS and Android platforms. Key Features: - Emergency Alerts: The app should be able to send out emergency alerts at the touch of a button. - Location Tracking: The app should include a reliable location tracking feature, providing real-time updates. - Health Monitoring: A health monitoring feature is also required, keeping track of critical health parameters. User Interface: - I'm open to any type of user interface for the app, whether it's simple and minimalistic, modern and stylish, or highly detailed with many options. However, it should be intuitive and user-friendly. Ideal Skills and Experien...
I'm looking for a proficient Terraform developer to create a script for Google Cloud. We need the script to create these items 1. networking 2. GKE cluster with one node 3. permanent volume and claim for GKE 4. Postgres SQL service - needs to be accessible from GKE 5. API Gateway - if API URL is /example1 > run a lambda function - otherwise forward API request to /endpoint/{incoming URL) (a service running in GKE) 6. IAM Role Binding for Cluster Access
...system that primarily focuses on enhancing our customer relationship management capabilities. This system must also incorporate workforce management features. Key Features: - Comprehensive Contact Management: The system should allow for efficient tracking and managing of customer interactions. - Effective Task Management: The CRM should facilitate the assignment and tracking of tasks within the team. - Resource Management: It should provide tools for managing our resources effectively. - Robust Reporting: The system should be able to generate insightful reports. - KPI Management: The CRM should have capabilities for tracking our key performance indicators. Contact Management Requirements: - Customer Segmentation: The CRM should enable us to categorize our custome...
I'm in need of professional assistance with my SuiteCRM instance installed on an AWS Lightsail server. Key Tasks: 1. Troubleshoot an error: "Error: Query limit of 5000 reached for Contacts module". 2. Review the installation and provide recommendations for an upgrade. 3. Evaluate the current backup strategy and perform tests accordingly. Please ensure to include "SuiteCRM" in your quote. Thank you in advance for your proposal and assistance.
We are seeking a professional developer with expertise in **CodeIgniter** and **Flutter** to work on our educational platform, which is based on the **EduAppGT Pro School System** Over the years, the platform has been heavily customized, and we aim to further enhance it while integrating it with a newly developed mobile application. #### Scope of Work: 1. **Mobile Application Development (Flutter)**: - Develop a completely new mobile application using **Flutter**, fully integrated with our existing educational platform (for student Users Only). - The app will provide key features such as student and teacher dashboards, interactive learning tools, notifications, and more. 2. **Ongoing Platform Development (CodeIgniter)**:
I'm in urgent need of a cyber security specialist who can perform thorough penetration testing on my React web application. The primary goal is to identify any potential security vulnerabilities, particularly: - Cross-Site Scripting (XSS) - SQL Injection - Cross-Site Request Forgery (CSRF) Your expertise in assessing these specific types of vulnerabilities will be crucial. The ideal candidate would also have experience in Quality Assurance, particularly with automated testing tools such as Selenium and Cypress. Your role will not only involve identifying security vulnerabilities, but also ensuring the overall code quality through automated testing. Please include in your proposal your relevant experience and any examples of previous work that may be applicable. Tha...
Please Sign Up or Login to see details.
I need a freelancer to set up a daily backup of my Microsoft SQL Server database from a dedicated Windows server to S3 AWS Storage. The backup files need to be compressed. Ideal Skills and Experience: - Proficiency in Microsoft SQL Server - Experience with AWS S3 - Knowledge of Windows Server - SQL database management - Data compression techniques
We are seeking a professional developer with expertise in **CodeIgniter** and **Flutter** to work on our educational platform, which is based on the **EduAppGT Pro School System** Over the years, the platform has been heavily customized, and we aim to further enhance it while integrating it with a newly developed mobile application. #### Scope of Work: 1. **Mobile Application Development (Flutter)**: - Develop a completely new mobile application using **Flutter**, fully integrated with our existing educational platform. - The app will provide key features such as student and teacher dashboards, interactive learning tools, notifications, and more. 2. **Ongoing Platform Development (CodeIgniter)**: - Customize
I'm looking for a professional to develop a comprehensive Loan Origination System (LOS) and Loan Management System (LMS) specifically for Home loans and Loan Against Property (LAP). The systems need to be built for both web and mobile platforms. 1. Executive Summary The purpose of this project is to design and implement a robust and scalable Loan Origination System (LOS) and Loan Management System (LMS) tailored for Home Loans (HL) and Loan Against Property (LAP). The LOS will streamline the loan origination process from application to approval, while the LMS will handle post-disbursement activities such as repayment tracking, collections, and customer servicing. 2. Business Objectives Automate and digitize the end-to-end lifecycle of HL and LAP. E...
I need a JavaScript-based URL redirect that includes the source URL and dynamic query parameter. The query and the source url information should be forwarded to the redirected page. Ideal candidates for this project should have a strong understanding of JavaScript, URL structures, and web redirection processes. Please also have the ability to test and troubleshoot the redirects to ensure all parameters are being correctly included and displayed.
I'm seeking a skilled developer to create an integrated webpage and mobile app for CRM tailored for our radiology company. Key Features: - Web, iOS, and Android compatibility - Communication facilitation between our company and clients/patients - Capturing information from new leads/customers, including uploading of ID cards, documents, etc - Providing reports post-diagnostic imaging procedures from our current RIS/PACS (Radiology Information System/ Picture Archiving System) by seamless integration - must be HIPPAA and HL7 compliant - A private section for inter-company interactions per client, including document and ID card uploads - Enabling clients to upload during onboarding via file upload or camera - Full database access for marketing, reminders, and push notifi...
I'm looking for a skilled Snowflake developer with extensive experience in data warehousing. The project involves integrating various data sources, primarily AWS S3 and SQL databases, with Snowflake. Key Responsibilities: - Data Warehousing: You'll be primarily focusing on the data warehousing aspect of Snowflake. - Data Integration: Integrating AWS S3, SQL databases, DBT, and Snowpark with Snowflake. - Data Transformation: Your main use of dbt will be for data transformation. Ideal Skills: - Proficient in Snowflake, dbt, and AWS. - Experience with data warehousing and integration. - Hands-on experience with live projects using these technologies. - Strong understanding of data transformation processes. Successful candidates will have previous experience working...
...start with a plan, developing a strategy tailored to your objectives and audience. Together, we decide what to post, when, and how, to maximize impact. **Content Creation:** We take care of everything: photos, graphics, videos, and engaging texts for posts and stories. Everything will be designed to showcase the best of your brand and capture your audience's attention. **Planning and Publishing:** You don’t have to worry about a thing: we schedule and publish all content according to the agreed calendar. You can focus solely on your business. **Interactive Management:** We respond to comments and private messages, maintaining an active and authentic dialogue with your audience. This way, you build trust and strengthen ...
I need a Python Data Analyst skilled in processing data from an SQL database and conducting descriptive statistics.
...experienced React.js developer or team to build a responsive, dynamic website with a search and comparison functionality. The focus is on delivering clean, reusable code and a user-friendly interface for our platform's Minimum Viable Product (MVP). Scope of Work Home Page: A modern and clean design with the following sections: Search Bar: Allow users to search items (data fetched from APIs). Featured Items Section: Highlight popular or trending items. Testimonials Section: Placeholder for user feedback. Call-to-Action Section: Encourage users to sign up for free access, login, contact us. Comparison Page: A page that dynamically displays comparison results based on API data. Key features: List View: Display items matching the search query. Filt...
... People can connect with friends or friends of friends to complete tasks together. - **Task-Based:** The platform focuses on assigning and completing simple tasks in real life. - **User-Created Tasks:** Participants can create their own tasks, tailoring them to their preferences and social circles. - **Real-World Engagement:** The tasks encourage participants to meet up in person, fostering real-world interaction. ### **Task Concept** The platform sends a series of messages to participants: - **Message Chain:** Each participant receives a message with a task to do together. - **Example:** One participant gets a message saying, "Invite your friend for a cup of coffee." They press "Okay," and the next message goes to the o...
We are currently seeking experienced Freelancer QA professionals to build a long-term working relationship through a one-year contract. The ideal candidates should meet the following criteria: - Minimum of one year of relevant experience in QA/User Experience Design - Native speakers with fluency Cantonese - Ability to respond to tasks within a week - Proficiency in English for communication Responsibilities: - Perform manual testing based on provided instructions and testing plan - Identify and report bugs and issues Additional Information: - Candidates will undergo a screening process - A small testing case will be provided as part of the evaluation - Tasks will be assigned as needed throughout the contract period - Compensation will be based on an hourly r...
I'm looking for a web-based program that can help me keep track of job participants, their payment statuses, and visualize data through a bar chart. Key Features: - Each participant should have a unique ID for identification. - A section to add new participants, requiring their Name and Contact Details, Date Joined and Payment Status. - Capability to indicate how many people are involved in a job and how many have made a payment. - A chart to visualize the number of participants added each month. Access: - Users should be able to log in with a Username and Password. Ideal Skills: - Proficiency in web development. - Experience with data visualization and creating interactive charts. - Knowledge in user authentication systems.
Description: We are looking for an experienced Python & Selenium Developer to join our team full-time. The ideal candidate will have a strong background in web scraping and web development, with proficiency in various Python libraries and frameworks such as BeautifulSoup, Requests, Scrapy, and Selenium WebDriver. Responsibilities: -- Build and maintain automated web scraping solutions using Python and Selenium. -- Scrape data from websites and efficiently process it. -- Develop and integrate databases with frontend applications. -- Work closely with the frontend team to ensure seamless integration and functionality. -- Collaborate in building and maintaining the business’s web-based systems. -- Work on web development projects using Python and associated tools. -- ...
I need assistance with manual data entry into an SQL database. The project involves working with database entries, so experience with SQL and data handling is essential. Ideal Skills: - Proficient in SQL - Manual data entry experience - Attention to detail - Data handling skills - Able to work independently and meet deadlines
I'm in need of a seasoned blockchain developer to create a secure and trustworthy blockchain escrow system. The project will encompass both front-end and back-end development, as well as design. The utmost priority for this project is the security and trustworthiness of the escrow system. Key Responsibilities: - Develop a secure blockchain escrow system on the many different coins platform - Design a user-friendly front-end - Build a robust back-end - Ensure the system incorporates essential security features such as multi-signature transactions, smart contract auditing and two-factor authentication Ideal Skills and Experience: - Extensive experience in blockchain development, specifically on the Ethereum platform - Proficiency in front-end and back-end development - S...
I am looking for an expert in Django, Python, and Google Sheets API to help automate some tasks. Key Requirements: - Task Automation: Primarily focusing on automating data processing tasks. - Data Transformation & Formatting: This will involve manipulating data into a suitable format for analysis. - Develop an automation script using Python - Utilize the Google Sheets API to synchronize data for our Django website Ideal Skills: - Proficient in Python - Extensive experience with the Google Sheets API - Strong background in automation and scripting - Understanding of data synchronization processes - Skill in Django is bonus Ideal Skills: - Proficiency in Django and Python: Essential for creating effective au...
...looking for a dynamic sales agent to promote my service across all sales channels. The primary focus will be selling subscription plans and ensuring client retention. Key Responsibilities: - Extensive reach out to many many potential clients - Outgoing personality, not afraid to reach out and grab attention - Utilize all sales outlets: online, telephone, and in-person. - Implement effective email marketing strategies. - Maintain a high level of client satisfaction and retention. Good to have skills: - Proven track record in sales, particularly in subscription services. - Strong communication and interpersonal skills. - Experience in client retention strategies. - Proficient in email marketing and familiar with various sales platforms. - Will...
I am seeking a professional query letter writer with experience in the fiction and fantasy genre. My manuscript targets adult readers and is ready for submission to literary agents. - Ideal Skills: Exceptional writing, understanding of query letters, knowledge of the fantasy genre, experience with adult fiction - Requirements: A well-crafted query letter that showcases the manuscript's appeal to agents and its potential in the market.
I am seeking a professional query letter writer with experience in the fiction and fantasy genre. My manuscript targets adult readers and is ready for submission to literary agents. - Ideal Skills: Exceptional writing, understanding of query letters, knowledge of the fantasy genre, experience with adult fiction - Requirements: A well-crafted query letter that showcases the manuscript's appeal to agents and its potential in the market.
I need a freelancer who can help me with my church's ad responses on Messenger. Many people respond to our ad with a like or a love, but they do not leave a comment. Key Requirements: 1. Send personalized messages through Messenger to these individuals without sending friend requests. 2. Ensure that my responses show up in the inbox of Meta Business Suite. 3. Deliver the messages in a way that allows these individuals to respond. 4. Provide a simple tutorial on how to do this myself in the future. 5. Track recipients' responses. 6. Segment recipients based on their reactions. Ideal Skills and Experience: - Proficiency with Meta Business Suite and Messenger - Experience in social media management - Ability to create personalized message...
