Oracle sql label column query jobs
I need assistance with renumbering my Excel file. The task involves: - Sequentially numbering all rows in column B with simple integers (1, 2, 3, ...). The freelancer should be proficient in Excel and have experience with data manipulation and formatting.
I need a professional photographer for a studio photoshoot of lip gloss and concealer products. The images will be used for marketing, so high-quality, visually appealing shots are a must. There is a total of 20 products, for which I only need 1 good photo for each. I will be buying and shipping the products to you, and after the job is done I will be making a prepaid shipping label so you can ship the products back to me. Ideal skills include: - Experience with product photography, specifically cosmetics - Proficiency in studio photography - Ability to create high-quality, marketing-ready images The job is US only, as I can only ship the products there.
I'm looking for a logo that embodies a "Southern Gentleman" theme, with visual elements reminiscent of a Jack Daniels whiskey label. The logo should be simplified and less-busy than the attached sample, but still convey a similar aesthetic to evoke slight recognition without infringing on trademark or copyright. The only text in the logo should be "Southern Gentleman" Key Requirements: - The primary focus of the logo should be visual elements similar to Jack Daniels, while being unique enough to stand alone. However, no reference to Jack Daniel’s or whiskey - the logo is for a seafood distribution business so if any subtle reference it should be an oyster - A color scheme of red, black, white, and silver. Ideal Skills and Experience: - Graphic design...
I'm seeking a professional designer to create a modern-style template for my Mailchimp newsletter. The design should feature three columns and provide flexibility for content placement, including buttons, images, videos, and hyperlinks. Key Responsibilities: - Design a sleek, modern, three-column Mailchimp newsletter template. - Ensuring the design accommodates various content types; buttons, images, videos, and links. - Incorporate my logo into the design. Ideal Expertise: - Proficient in Mailchimp and newsletter design. - Experienced in modern design aesthetics. - Able to integrate branding elements seamlessly. Content Focus: The primary focus of the newsletter will be articles and news updates. The design should support this content type effectively.
...close below SMA if not isBelowSMA isBelowSMA := true isAboveSMA := false belowCount := 1 // Reset to 1 when we start a new count below SMA else belowCount := belowCount + 1 // Increment if we're already counting below SMA aboveCount := 0 // Reset above count // Plot the 9 SMA for reference plot(sma9, color=, linewidth=2, title="9 SMA") // Label each candle above the high with slight offset, using brilliant white text if isAboveSMA (bar_index, high + (high * 0.001), text=(aboveCount), color=(, 80), textcolor=, style=label.style_none) else if isBelowSMA (bar_index, high + (high * 0.001), text=(belowCount), color=(, 80), textcolor=
I need a freelancer to calculate the standard deviation of a small dataset stored in a text file. The dataset has only one column. Ideal Skills: - Proficiency in statistical analysis - Experience with data manipulation - Familiarity with standard deviation calculations Please have access to either Google Sheets or Excel for this task.
...(outstanding/active) on a financial analysis platform. Extract data as per columns in attached example. I essentially want the deliverable to look exactly like the file I uploaded; except with all of the new countries I am requesting. Again, no actual analysis needs to be performed, I just need the raw data for the last 30-trading days. Additional information - The extracted data should exactly replicate the column structure as shown in the attached example Excel file....
...code for a program which needs to be completed if there are any missing pieces. 2. You'll be responsible for programming the database, which will be SQL Server. 3. Finally, the completed program will need to be uploaded on a server, where you will also run it. The code might need improvement in the following aspects: - Functionality/features - User interface - Error handling and debugging Part II: Apps Developer I need skilled apps developers to create Android and iPhone apps based on the aforementioned program. Ideal skills and experience for the job includes: - Proficiency in Dotnet programming - Extensive experience with database SQL and MySQL Servers - Strong skills in Android and iPhone app development - Able to improve code functionality and user interface...
I'm seeking a skilled professional to assist me in setting up Tomcat 9, APEX, ORDS, and an SSL certificate on my Oracle Linux 19c DB. Key Tasks: - Install Tomcat 9, APEX, and ORDS - Configure SSL Certificate About the Environment: - The operating system is Oracle Linux 9 The required software packages for Tomcat, APEX, and ORDS are already available. Your expertise in installation and configuration will ensure a successful setup. Please reach out if you need further details.
I need column AB from this list created - email addresses for the people in each row
...Deals**: Enjoy members-only discounts, limited-edition collections, and personalized recommendations tailored to your preferences. 4. **Worldwide Accessibility**: Whether you’re shopping for yourself or looking for the perfect gift, Osaka Mall delivers luxury products directly to your doorstep, no matter where you are in the world. 5. **Customer Support**: Our dedicated support team ensures every query is addressed promptly, enhancing your shopping satisfaction. #### **Why Choose Osaka Mall?** - **Authenticity Guaranteed**: Every item is sourced directly from official brand partners, ensuring quality and authenticity. - **Diverse Product Range**: From haute couture to premium gadgets, Osaka Mall is a one-stop shop for all luxury needs. - **Luxury Redefined**: E...
I need this list data scraped for personal emails Scrub1 list worksheet ~3500 lines Column AB in pink
I need a Pyspark code that reads join rules from a txt file and applies them in the main program. The joins will be based on multiple columns, with the rules formatted as column names with conditions. The code should only implement inner joins. Ideal candidates should have comprehensive experience in Pyspark, understand how to manipulate data frames, and can write clean, efficient code.
...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 Candidate: The ideal trainer will be someone with extensive ...
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 ...runs as efficiently as possible. • Deliver the source code with minimal documentation so that I can easily understand where the logic has been programmed and which calculations have been added. Skills Required: • Strong proficiency in MySQL, particularly with cursors and loops. • Ability to work with provided simple formulas and integrate them into the cursor logic. • Expertise in optimizing SQL queries and minimizing database load for performance. Project Timeline: • Ideal...
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-fill by 20% through process optimiz...
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 Requirem...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 r...
...Store raw data temporarily in Amazon S3. Data Parsing Clean and structure raw data for further processing. Ensure data validity and store parsed data in S3. Data Transformation Enrich and reshape parsed data for analysis or database upload. Store intermediate results in S3 for staging. Data Upload to SQL Database Save transformed data into Amazon RDS (PostgreSQL/MySQL) with optimized database inserts. Ensure data integrity and performance. Data Analysis and SQL Transformations Execute SQL procedures and queries in RDS for additional analysis and derived insights. Store final results in the database for website access. RESTful API Development Build a secure RESTful API using AWS API Gateway and Lambda to provide real-time data to the website. Optimize database q...
I'm in need of a modern, minimalist label design for my line of natural and organic skincare products. The labels should be in neutral tones, with a clear, easy-to-read layout that includes the following elements: - My company logo - An ingredients list - A product description - Net contents - A designation for organic ingredients Ideal candidates for this project should have experience in product label design, particularly for skincare or beauty products. They should have a strong portfolio of modern, minimalist designs and be able to work within a neutral color palette. Knowledge of organic and natural product standards and labeling requirements would be a plus.
I need help with explore an Oracle database on my Windows 11 machine, this project will be conducted remotely for security purposes. Please note, this project will be conducted remotely for security purposes, so a reliable and secure remote connection is essential. Your understanding and expertise in these areas will ensure the successful completion of this project.
I'm in search of a ready-made, white-label crypto exchange. The platform should allow for user registration and login, with a primary focus on the trading of various coins, including both major cryptocurrencies and custom coins. Key Requirements: - Comprehensive admin and user panel management - Extensive coin listings, both major and custom - Ability to list my own coins - Trading options for my coins, including a set up for 'Hit Coin' - Full-fledged KYC features, from basic verification to advanced options with document uploading - Compatibility with Namecheap's shared hosting - A white-label solution that we can sell - Spot Trading - Convert Crypto - OTC Market -Accept all major fiat currencies - Futures Trading -Options Trading -P2P Market -Merchant ...
I'm seeking a professional with expertise in label design compliance within the Food and Beverage industry. This project involves a comprehensive review of my product's labels to ensure they meet all necessary regulations concerning: - Nutritional Information Accuracy: Ensuring all nutritional claims are precise and substantiated. - Health Claims Regulation: Verifying that any health claims made on the packaging are compliant with industry regulations and standards. - Allergen Labeling: Ensuring that allergen information is clearly and accurately presented in accordance with regulatory requirements. The ideal candidate for this project will have extensive experience in label design compliance, particularly within the Food and Beverage sector. They will have a keen...
I have an Excel sheet with text data in various columns that needs to be sorted according to a specific sequence. The task involves: - Identifying the text data in the columns - Sorting this data following a predetermined custom sequence Ideal candidates for this project should have: - Proficient Excel skills - Experience in sorting data according to custom criteria - Attention to detail to ensure all data is sorted accurately according to the specific sequence
...page-id=84%3A1486&node-id=149-2579&node-type=canvas&viewport=238%2C173%2C0.02&t=rYA2znUGosArvFcq-1&scaling=scale-down&content-scaling=fixed&starting-point-node-id=149%3A2579&show-proto-sidebar=1 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 with the Figma design and implemented using .NET framework 8, SQL server DB, JavaScript, and AJAX (in search). - Two language versions are required: Arabic and English. - All website functionalities need to remain unchanged, including user authentication, data reporting, real-time updates, and all existing links and data. Some links should be editable from the control panel to open external links ; So you...
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
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.
I'm seeking an SEO specialist to help enhance my website's on-page SEO. This includes keyword optimization, content creation, and refining meta tags and descriptions. Managed SEO Maximize our online potential with professional white label SEO services. Implement effective strategies to improve our website’s search engine rankings Locally and nationally. Including comprehensive keyword research, on-page optimization, content creation, link building, and more, to ensure that our site is optimized for both search engines and users. Whether you’re looking to increase traffic, drive sales, or build brand awareness, As our SEO needs to start seeing real results for our websites ASAP . Also including discussions on Backlink strategy ,Citations, Local Search - GBP ...
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. Thank you.
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
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.
...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 notifications - Integration with our current RIS/PACS system for seamless information transfer - Customer query handling and support Please note that we don't require payment processing at this stage. Ideal candidates should have: - Extensive experience in web and mobile app development, particularly for CRM systems - Proficiency in iOS and Android platform development - Previous experience with integrating apps with RIS/PACS systems - Skills in creating secure, private interaction sec...
I need a simple yet effective user interface in Roblox, integrated with the Leonardo AI for image generation. The UI should include a text input field for AI prompt entry, a label to display the generated image, and a button to initiate the image generation process. Key functionalities: - User inputs a prompt in the text field. - Upon clicking the button, the prompt is sent to the Leonardo AI server (I have API key) via HTTPService. - The server responds with a link to the generated image. - The image is uploaded to Decals (Decals or another approach) and shown in the label. Expectations: - All code written must be in Lua using Roblox Studio. - The project must comply with Roblox Community Standards, with no inappropriate content or policy violations. - Robust error handlin...
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...
I need a Python Data Analyst skilled in processing data from an SQL database and conducting descriptive statistics.
...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. Filters: Allow users to filter results by parameters like price, rating, or features. Comparison Table: Detailed comparison of attributes such as cost, features, and ratings. Action Buttons: "Learn More" or "Contact" buttons for each option. we can discuss this in detail after project allocation. Technical Requirements: Frontend Framework: React.js. API Integra...
...web-based systems. -- Work on web development projects using Python and associated tools. -- Ensure code is scalable, maintainable, and efficient. Required Skills: -- Strong experience in Python (3-5 years). -- Proficient with Selenium WebDriver for web scraping and automation. -- Experience with BeautifulSoup, Requests, Scrapy, and other web scraping frameworks. -- Solid understanding of Databases (SQL/NoSQL) and integrating them with web applications. -- Experience in web development (preferably with frameworks like Django or Flask). -- Strong knowledge of Flutter for mobile development. -- Ability to work independently and deliver quality code within deadlines. Additional Requirements: -- Proven experience of 3-5 years in Python and web development. -- Strong problem-solving...
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 need a freelancer who can help me extract and label data from a collection of past exam papers. The final product will be a 126 page Excel spreadsheet. The data needs to be organized in the following format: - exam_year_month - exam_id - question_id - scenario_text - question_text - total_marks - answers Ideal skills and experience: - Proficient in Excel - Attention to detail - Experience with data extraction and labeling
I need a freelancer who can help me extract and label data from a collection of past exam papers. The final product will be a 126 page Excel spreadsheet. The data needs to be organized in the following format: - exam_year_month - exam_id - question_id - scenario_text - question_text - total_marks - answers Ideal skills and experience: - Proficient in Excel - Attention to detail - Experience with data extraction and labeling
...things. I am looking for someone who can understand the intricacies of data processing and can help ease the burden of manual tasks. The goal is to streamline our operations and enhance productivity. -- Basically, we have a data processing project which is going to be presented into our new website. We need a backend Python Developer whom can process data in our Google sheet then be dumped into SQL, eventually going to be presented into our new website. Therefore, the Python developer needs to be familiar with Google sheet API, Django framework API, and scrapping for our data processing. Data synchronization should occur in real-time. Our budget is $3/hour for maintaining the codes and website $5/fix rate for replicating or making a new code, but for a specific code if...
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 am looking for a cross-platform (iOS and Android) white label app that delves into the anatomy of the human eye. This app should be rich in content, incorporating text descriptions, 3D models, and videos. Key Features: - Interactive Quizzes: To engage users and test their knowledge. - Search Functionality: Allowing users to easily find specific information. - Bookmarking Sections: Enabling users to save their progress or interesting sections for later. Ideal Skills: - Proficient in cross-platform app development. - Experienced in creating educational apps. - Knowledgeable in 3D modelling and video integration. The aim of this project is to create a comprehensive, interactive, and user-friendly app about the human eye, suitable for both iOS and Android users.
We have 2 SQL databases. A source database and a target database that have completely different structures (tables, field names/types and relations). We're doing some migration planning from source to target and need some consulting advice on how to best map tables and fields for ETL migration. We are looking for a solution that uses AI and/or ML to avoid doing this all manually the schema mapping. Please put "SCHEMA123" at the start of your proposal so we can filter out automated responses. Please list any details of your experience in doing a project like this. Thanks!
I'm looking for a seasoned professional with advanced knowledge in SQL database architecture. The primary task will be designing a new database. Ideal Skills and Experience: - Extensive experience with SQL - Proven track record in database design - Ability to understand and meet project-specific requirements - Strong problem-solving skills - Excellent attention to detail
Title: Development of a Personalized Property Rating System Description: We are looking for an experienced developer to help us create a system that can generate personalized property...on relevant metrics. • Integrate the system with an existing CRM platform. • Provide ongoing support and maintenance. • Work independently and ensure the system runs with minimal manual intervention. Technical Requirements: • Experience with API integrations and data processing. • Familiarity with CRM systems and integration. • Strong skills in data processing technologies (e.g., Python, SQL). • Ability to generate reports and analytics based on property data. If you are interested in this project, please send us your resume and relevant experience. We lo...
Seeking an experienced ZebraDesigner professional to create and troubleshoot new barcode label designs. Labels will contain product details, serial numbers, and batch numbers. Ideal candidates should be: - Proficient in ZebraDesigner - Bilingual: Fluent Spanish speaker - Experienced in creating barcode labels - Skilled in troubleshooting design issues Please provide examples of relevant past work and your level of proficiency in Spanish.
