Help sql queries jobs
I'm hoping to collaborate with an experienced e-book writer to craft a compelling self-help e-book that will focus on motivation and self-discipline. The e-book will primarily target students, professionals, and ordinary readers- all of whom often need that extra boost of motivation to conquer their everyday challenges. Skills and experiences that would be ideal for this project include: - Previous experience in creating self-help content, particularly in the field of motivation, resilience, self-discipline - Strong writing skills that can captivate readers and inspire them to take action This eBook should not only be informative but it should guide readers on practical motivational steps. The ability to break down complex ideas into easily digestible, actionable step...
We're seeking a customer support representative proficient in Spanish to handle telephonic queries, specifically on product related questions. Their primary responsibility will be to ensure customer satisfaction by solving product concerns to the best of their knowledge. Skills and Experience: - Fluent in Spanish: Your linguistic expertise will be key to engaging with a diverse clienteles who primarily communicate in Spanish. - Customer service skills: Previous experience dealing with clients over the phone is desirable. - Knowledge about our products: A good grasp of our product line is required to address related inquiries effectively.
We are looking for ETL ODI Developer for long term contract role who can support us 8 hours ...(ETL) processes • Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI). • Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis. • Knowledge and understanding of the applicable tools and practices used in data governance including query and data profiling techniques • Proven skills in data analysis – including queries to calculate data quality. • Solid written, verbal, and analytical skills • Strong research and problem determination and solution skill Interes...
I'm on the lookout for an adept .NET developer with a strong background in jQuery and SQL server. The end goal is to construct an efficient hospitality software. This is an urgent position, ideally located in Nagpur. Primary Requirements: - System development using .NET and jQuery. - Thorough understanding of SQL server operation. Key Features: - Capable of handling billing and invoicing. - Inventory management capability. Ideal candidates would have considerable experience managing comparable projects and deriving software solutions in the hospitality industry. Proven proficiency in .NET, jQuery, and SQL server is crucial to this role. Your proficiency will be key in delivering a quality solution that aligns with our objectives.
As the initiator of this project, I am looking for a skilled modder comfortable with Minecraft modpack maintenance and customization. The job involves creating and implementing detailed loot tables into my current Minecraft modpack. Key tasks: *...for the items in the loot tables, consisting of Common, Uncommon, and Rare levels. Ideal skills: * Knowledge and experience in Minecraft modding. * Familiar with loot table functions and rarity systems. * Attention to detail to ensure the specified items are correctly added with appropriate rarity levels. Your scope includes providing updates on project progression, responding promptly to any queries, and delivering a high-quality end product. Let's transform my regular Minecraft modpack into an intriguing, exciting game world wi...
I'm seeking a proficient AI specialist capable of creating an engaging, responsive chatbot AI for my website. The primary objective of the AI chatbot is to interact with my website visitors, responding to legal consultations and inquiries. Required Skills: - Proficiency in AI and machine learning methods. -...Experience with website chatbot integration. - Knowledge in designing AI training models. - Familiarity with legal terminologies and processes. Responsibilities: - Develop a user-friendly chatbot AI. - The AI should be trained to provide accurate responses to legal questions. - The implementation should be on the website interface. The aim is an efficient AI chatbot capable of handling legal queries, ultimately improving user interaction while providing important leg...
I'm in need of an expert PHP developer to craft a complex data query. The project revolves around extracting specific columns from multiple tables (User data tables, Transaction data tables, Customers data tables and Suppliers data table) into a single query. Key Requirements: - Expertise in PHP - Strong experience with SQL and database interactions Brief: I have created four tables named users, customers and suppliers and transactions. In users I have column named uid, name, email, mobile. Here users register themselves for login purpose. In customers table I have column named id, uid, name, mobile, email (here uid is the uid of user who is adding customers and name, mobile, email are the customer’s details). In suppliers table I have column named id, uid, name,...
I'm in need of an expert PHP developer to craft a complex data query. The project revolves around extracting specific columns from multiple tables (User data tables, Transaction data tables, Customers data tables and Suppliers data table) into a single query. Key Requirements: - Expertise in PHP - Strong experience with SQL and database interactions Brief: I have created four tables named users, customers and suppliers and transactions. In users I have column named uid, name, email, mobile. Here users register themselves for login purpose. In customers table I have column named id, uid, name, mobile, email (here uid is the uid of user who is adding customers and name, mobile, email are the customer’s details). In suppliers table I have column named id, uid, name,...
I am looking to publish a non-fiction self-help book, and I'm targeting the general public as my audience. This project involves not only publishing but also strategically marketing the book. Here are some tasks that the freelancer will be expected to accomplish: * Reviewing and refining the book's content to appeal to a broad audience * Designing a captivating book cover * Formatting and publishing via commonly used platforms * Developing a compelling marketing strategy to maximize reach and sales The ideal freelancer for this project should have: * Proven experience in book publishing * Strong marketing and promotional skills * An understanding of the self-help genre * Exceptional proof-reading capability * Exceptional eye for design In your proposal, please...
...means will return data for the ot_total class but i want it for the ot_shipping class im simply trying to add 2 conditions 1. return AS order_total for the = 'ot_total' 2. return AS shipping_method for the = 'ot_shipping' i dont want for = 'ot_total' so help me ? is this not possible or do i have to execute a completely sepearate query?? that seems a waste of code and resources... i know i can do it in 2 seperate queries but i am tryin to combine it in one query thanks SELECT o.orders_id, o.customers_name, o.payment_method, o.payment_module, o.date_purchased, o.last_modified, , o.currency_value, s.orders_status_name, AS order_total WHERE = 'ot_total',
We are looking for someone to work on this project and others in the future - we would prefer to have someone that is full stack that can help us and we don't want to work with an agency. If you are an independant freelancer please put INDEPENDANT in your response ;) We are in search of a skilled and experienced freelancer to design and develop a website for our cleaning services business. The website should be built using WordPress, specifically with an Elementor theme. We will select a base Elementor theme, which will then require customization to suit our unique branding and service requirements. Website Structure: Home Page: Specific details to be provided later, focusing on our range of cleaning services. About Us: A section offering insights into our company and the c...
I'm in need of an expert to construct SQL statements that will retrieve specific data from a database. I have an SQL Server with multiple databases, with existing SQL query that looks similar to Select * from union all Select * from union all Select * from The select command is a lot more advanced than a simple Select *, but I need to be able to easily extend and included more databases, without having to cut, copy, paste, then perform a find and replace of the database tables. If i was to write in DOS, it would be something like for each %i in ( Database1, Database2, Database 3){ select * from % union all } but just not sure the best way to do this in SQL, and looking quick assistance. thanks
...systems. 8. **Responsive Design**: The website should be fully responsive, ensuring a seamless experience on desktop, tablet, and mobile devices. 9. **Compliance and Legal Information**: Incorporate sections for legal information, terms and conditions, privacy policy, and regulatory compliance. 10. **Customer Support Integration**: Live chat support, FAQ section, and contact form for customer queries. **Design Preferences:** - A clean, modern aesthetic that reflects trust and professionalism. - Intuitive navigation and a user-friendly interface. - Branding elements (logo, color scheme) will be provided. **Technical Requirements:** - Use of secure and scalable web technologies. - SEO-friendly structure. - Cross-browser compatibility. - Consideration for fast load times and op...
I have a set of data that I need to organize. The set of data has Products and the product's subcomponents. I need to see which products have the same subcomponents. (Different Product #'s may have the same subcomponents).
...selecting appropriate journals based on the scope of the research and the journal’s indexing status. • Assist authors in preparing and formatting their manuscripts according to the guidelines of the target journals. • Coordinate the submission process, including managing correspondence with journal editors and handling revisions as needed. • Liaise with journal editors and reviewers to address any queries or concerns related to submitted manuscripts. • Track the progress of submitted manuscripts and provide regular updates to authors on the status of their papers. • Ensure that all necessary documentation and copyright agreements are completed accurately and submitted on time. • Stay informed about changes in Scopus indexing criteria and ...
We are currently in the process of building MVP for an enterprise SaaS platform. We need developers to help us build this MVP. Project Goals: Develop an MVP that includes key features based on product vision. Ensure the platform is scalable, secure, and maintains user privacy. Create an intuitive and user-friendly interface for data visualization and analysis. Requirements: Proven experience in developing web applications and analytics tools. Strong proficiency in front-end and back-end technologies (JavaScript, React, Node.js, Python, etc.). Experience with database management and data processing (SQL/NoSQL, Big Data technologies). Knowledge of cloud platforms (AWS, Azure, Google Cloud) for hosting and scaling the application. Familiarity with data privacy laws and best...
I need a Simple Project in Flutter (MVC), to show to a list of of records from SQL Db (Name, age, date, etc), when clicked show the same in a detailed view. Add a sort button to sort by Name, age, date. I have PHP APIs to retch records. Enable Mobile, Windows outputs. In mobile, show the Tabview under Details Pane. After project is done, you should help me to deploy it in my hosting through Anydesk. Thats all.
My client is starting several startups before the end of summer. I have been hired to find 3 Video Graphics interns. This post is presented this way for a purpose. You recently did the graphics cer... Any initial message to me that does not have a list of 1 to 10 filled out may be ignored for their inability to follow instructions. I work with many other clients and recruited many interns usually through my other client accounts. So I know the dev community quite well and what is what. So, Keep it real. Good luck - Read before bidding. Messaging is encouraged. Questions or queries are encouraged. If you bid, before fully reading, and following, simple instructions -- or -- your bid is above or below $100.00, I may ignore your bid. This is part of the selection process I use.
I am seeking a dedicated chat support executive, well-versed in phone and chat-based customer support. Ideally, you will bring a strong foundational customer service background, coupled with exceptional communication skills. Responsibilities: - Address customer queries: Your main role will be to respond to customer inquiries via phone and chat. Proficiency in verbal and written communication is crucial. Ideal Skills and Experience: - Prior experience in customer service - Excellent phone/chat etiquette - High-level communication abilities - Demonstrated ability to troubleshoot and solve problems - Ability to handle a high volume of calls/chats while maintaining a high level of professionalism The ideal candidate should be passionate about delivering high-quality customer ser...
We're seeking a customer support representative proficient in Spanish to handle telephonic queries, specifically on product related questions. Their primary responsibility will be to ensure customer satisfaction by solving product concerns to the best of their knowledge. Skills and Experience: - Fluent in Spanish: Your linguistic expertise will be key to engaging with a diverse clienteles who primarily communicate in Spanish. - Customer service skills: Previous experience dealing with clients over the phone is desirable. - Knowledge about our products: A good grasp of our product line is required to address related inquiries effectively.
I am who is seeking a home-based professional experienced in customer service, particularly in email support. The work will revolve around addressing customer concerns and inquiries in the e-commerce sector. Job requirements: - Exceptional email etiquette and communication skills - Familiarity with e-commerce sector - Availability during working hours to promptly address customer queries - Experience in handling customer emails professionally - Ability to work independently and efficiently from home As an ideal candidate, you should be a punctual, customer-first focused service provider who can ensure that our e-commerce customers find prompt and effective assistance with their concerns via email support. Having prior experience with e-commerce is a plus. Your role will be cru...
I need someone who has experience in: - backend development using python - able to write unit tests - AWS experience - AWS lambda and API gateway experience - Jenkins - Gitbash/ GitHub - Postman - sonarqube - SQL- AuroraPostgres
I need someone who has knowledge in Python to help fixing the script and make it working well start your bid with NOW if you can start immediately
I need someone who has knowledge in Python to help fixing the script and make it working well start your bid with NOW if you can start immediately
As a business, I am aiming to boost my inventory management processes by connecting my Point of Sale (POS), warehouse and inventory management to OpenAI chat GPT. Key Deliverables: - Integration with OpenAI chat GPT to improve inventory management and sales. - Implementation of predictive restocking to help forecast demand and avoid overstocking or stock outs. - Real-time inventory updates to keep the system current and reliable. - Automated inventory reporting to provide a clear overview of stock status, helping decision-making processes. - Daily advice on sales and discounts for clients based on the trends and patterns discerned from historical data. The ideal freelancer for this project should possess a strong background in AI and machine learning, with explicit knowl...
I need someone who has knowledge in Python to help fixing the script and make it working well start your bid with NOW if you can start immediately
...to create a captivating portfolio website, centralised around my customers. The design will primarily focus on portraying a professional image and effectively displaying my work, projects, and achievements. The main features I need incorporated include: - A clean, visually appealing design that enhances user experience. - A prominently placed, user-friendly contact form for potential customer queries. Please note, this website will be heavily targeted towards customers, therefore it's crucial that it's intuitive, navigable, and encourages interaction. Relevant experience in crafting user-and-customer-oriented websites is highly desired. I'm counting on your creative ideas and proven tactics to generate optimal traffic and engagement. Applicants with an understand...
Error website wordpress : Warning: mysqli_query(): (HY000/3): Error writing file '/tmp/#sql/fd=257' (Errcode: 28 "No space left on device") in /home/ on line 2349
...to meet our quality standards. We provide thorough preparation for your role, including certified didactics and methodology training. A certificate will be rewarded upon completion of this. Fixed scheduling ensures clarity regarding your work hours. We promote an open culture of regular knowledge exchange, allowing you to seek advice and learn from peers. Our team is always available for any queries, whether about the learning platform or IT infrastructure. Our goal is to provide you with a long-term career opportunity, where you can grow both professionally and personally. With extensive support and further training options, we foster an environment where you can pursue your teaching passion and contribute significantly to society. If you meet the above criteria and are exc...
...to meet our quality standards. We provide thorough preparation for your role, including certified didactics and methodology training. A certificate will be rewarded upon completion of this. Fixed scheduling ensures clarity regarding your work hours. We promote an open culture of regular knowledge exchange, allowing you to seek advice and learn from peers. Our team is always available for any queries, whether about the learning platform or IT infrastructure. Our goal is to provide you with a long-term career opportunity, where you can grow both professionally and personally. With extensive support and further training options, we foster an environment where you can pursue your teaching passion and contribute significantly to society. If you meet the above criteria and are exc...
...to meet our quality standards. We provide thorough preparation for your role, including certified didactics and methodology training. A certificate will be rewarded upon completion of this. Fixed scheduling ensures clarity regarding your work hours. We promote an open culture of regular knowledge exchange, allowing you to seek advice and learn from peers. Our team is always available for any queries, whether about the learning platform or IT infrastructure. Our goal is to provide you with a long-term career opportunity, where you can grow both professionally and personally. With extensive support and further training options, we foster an environment where you can pursue your teaching passion and contribute significantly to society. If you meet the above criteria and are exc...
...to meet our quality standards. We provide thorough preparation for your role, including certified didactics and methodology training. A certificate will be rewarded upon completion of this. Fixed scheduling ensures clarity regarding your work hours. We promote an open culture of regular knowledge exchange, allowing you to seek advice and learn from peers. Our team is always available for any queries, whether about the learning platform or IT infrastructure. Our goal is to provide you with a long-term career opportunity, where you can grow both professionally and personally. With extensive support and further training options, we foster an environment where you can pursue your teaching passion and contribute significantly to society. If you meet the above criteria and are exc...
Hello. I'd like some help to configure a brush at the SyntaxHighlighter evolved plugin. I'd also like to do some maintenance at my blog, so a quick call for you to help me would be great.
...to meet our quality standards. We provide thorough preparation for your role, including certified didactics and methodology training. A certificate will be rewarded upon completion of this. Fixed scheduling ensures clarity regarding your work hours. We promote an open culture of regular knowledge exchange, allowing you to seek advice and learn from peers. Our team is always available for any queries, whether about the learning platform or IT infrastructure. Our goal is to provide you with a long-term career opportunity, where you can grow both professionally and personally. With extensive support and further training options, we foster an environment where you can pursue your teaching passion and contribute significantly to society. If you meet the above criteria and are exc...
...to meet our quality standards. We provide thorough preparation for your role, including certified didactics and methodology training. A certificate will be rewarded upon completion of this. Fixed scheduling ensures clarity regarding your work hours. We promote an open culture of regular knowledge exchange, allowing you to seek advice and learn from peers. Our team is always available for any queries, whether about the learning platform or IT infrastructure. Our goal is to provide you with a long-term career opportunity, where you can grow both professionally and personally. With extensive support and further training options, we foster an environment where you can pursue your teaching passion and contribute significantly to society. If you meet the above criteria and are exc...
...to meet our quality standards. We provide thorough preparation for your role, including certified didactics and methodology training. A certificate will be rewarded upon completion of this. Fixed scheduling ensures clarity regarding your work hours. We promote an open culture of regular knowledge exchange, allowing you to seek advice and learn from peers. Our team is always available for any queries, whether about the learning platform or IT infrastructure. Our goal is to provide you with a long-term career opportunity, where you can grow both professionally and personally. With extensive support and further training options, we foster an environment where you can pursue your teaching passion and contribute significantly to society. If you meet the above criteria and are exc...
I need a well versed expert in Umbraco to help me with a migration task and also setup proper backup falicies.
...Resource to join our team onsite in Delhi NCR. The ideal candidate should have 5-6 years of solid experience in .NET development, focusing on building robust APIs using .NET Core. Requirements: 1. Experience: 5-6 years of .NET development experience. 2. Skills: Proficiency in .NET Core, API design, and development. 3. Technologies: Familiarity with RESTful APIs, JSON, Entity Framework Core, and SQL databases. 4. Location: Candidates must be available to work onsite in Delhi NCR. Responsibilities: 1. Design, develop, and maintain APIs using .NET Core. 2. Collaborate with cross-functional teams. 3. Participate in code reviews and debugging. 4. Ensure code quality, performance, and security. Duration: Long-term, Full-time Location: Delhi NCR, India (Onsite) How to Apply: Intere...
I'm looking for a competent Virtual Assistant (VA) capable of managing our Shopify store from A-Z. Key responsibilities include: 1. **Product Review and Troubleshooting:** We currently ha...product. This ensures our product visuals are appealing and engaging .Also will be used for fb ads. 3. **Ad Management:** The assistant will be responsible for running Facebook advertisements. This includes ad creation, set-up, monitoring and optimizing for performance. 4. **Order and Customer Management:** I need assistance with handling orders, ensuring timely fulfilment and managing customer queries and complaints. Ideal candidates have prior experience managing a Shopify store, have keen attention to detail, are familiar with Facebook advertising, and have a strong commitment to cu...
...will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales Key Responsibilities: 1) Improve angular.js performance then work on transforming angular.js to 2) Front end work migrating our current webapp from angular to , create new pages and functionalities in 3) Developers with experience in .NET API C# are an added plus as is knowledge of WordPress plugins. This is for ongoing long term
...will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales Key Responsibilities: 1) Improve angular.js performance then work on transforming angular.js to 2) Front end work migrating our current webapp from angular to , create new pages and functionalities in 3) Developers with experience in .NET API C# are an added plus as is knowledge of WordPress plugins. This is for ongoing long term
I am seeking a proficient full stack developer with expertise in HTML, CSS, PHP, JavaScript and SQL to support the continued development of our existing application. Our platform supports the software procurement process, by helping our users to identify the right solution based on their specific needs. I'd like interested freelancers to showcase past work with your bid. This will help me gauge your experience and quality of work. Please ensure that these projects align with the requirements outlined above. Your proficiency in PHP/SQL is a must, and experience in creating interactive UI/UX for e-commerce platforms would put you at a distinct advantage. As would experience with WordPress, AWS, API and integration development. I'm looking for someone based...
...retrieving and aggregating information from various tables using SQL queries. It must pull and consolidate pertinent records from a range of interconnected database assets while preserving data integrity. Specifically, the report will need to extract salient fields like identifiers, values, and timestamps from several intricately related operational stores. It should then compile and organize the extracted segments to provide a holistic view of core business operations over a specified timeframe. The constituent pieces must be intelligently linked and cross-referenced to offer meaningful insights. The underlying database schema may be intricate with numerous joins and intricate relationships between entities. As such, the SQL development will require strong expertis...
I am looking to enhance my existing logo and make it look cooler. I just want to keep the logo the same, but make it look more interesting with colours, font, etc.
I'm looki...who's great at web scraping to help with a project involving two specific websites initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deplo...
...collaborate with us to optimize and speed up our existing project. Our team consists of passionate professionals working on an ambitious and ever-evolving project in the [specify the industry] sector. We are seeking a reliable and competent collaborator who can help us improve the performance of our website, ensuring smooth navigation and optimal user experience. Responsibilities: Analyze existing code and identify potential areas for optimization. Implement improvements to increase the website's loading speed. Optimize database queries to enhance overall performance. Collaborate with the team to implement new features and enhancements. Test and debug code to ensure system stability and reliability. Requirements: Proven experience with Laravel and a deep understand...
...commonly used packages specially with GCP. Hands on experience on Data migration and data processing on the Google Cloud stack, specifically: Big Query Cloud Dataflow Cloud DataProc Cloud Storage Cloud DataPrep Cloud PubSub Cloud Composer & Airflow Experience designing and deploying large scale distributed data processing systems with few technologies such as PostgreSQL or equivalent databases, SQL, Hadoop, Spark, Tableau Hands on Experience with Python-Json nested data operation. Exposure or Knowledge of API design, REST including versioning, isolation, and micro-services. Proven ability to define and build architecturally sound solution designs. Demonstrated ability to rapidly build relationships with key stakeholders. Experience of automated unit testing, automated integra...
I'm searching for a highly skilled OpenAI expert to enhance my Wordpress and Shopify sites. Your contributions will significantly improve the user experience and overall functionality of my platforms. Specific tasks will involve developing: - A custom AI chatbot to effectively help customers navigate through the site and answer their queries swiftly. - Personalized product recommendations to boost sales conversions, based on customer's previous browsing and buying history. - Automated inventory management system for efficient stock handling and forecasting. - A system for review analysis, helping us to understand customer feedback and improve our products and services. Additionally, I'm interested in adopting a clean, minimalist design theme across the webs...
...searching for a seasoned ghostwriter to pen a step-by-step self-help eBook, primarily focusing on mindfulness and meditation. Requirements: - You should be well-versed in writing self-help content with an emphasis on mindfulness practices. - The book should be presented in a sequential pattern, ensuring the readers' easy understanding of the process of engaging in mindfulness and meditation. - Experience with organized, step-by-step, and process-driven content is paramount. Ideal Skills: - Experience in writing self-help mindfulness and meditation-themed content. - Understanding of mindfulness practices. - Great organizational and structural skills for creating step-by-step guides. The aim is to provide easy-to-follow steps to help readers incorpo...
