Oracle sql label column queryPekerjaan
Looking for an experienced MSBI and powerbi developer. You would be working with me to troubleshoot and optimize an existing MSBI solution and powerbi report. Your tasks include but are not limited to: - Data Modeling - ETL Development - Report Development For this project, your primary tools would be: - SQL Server Integration Services (SSIS) - SQL Server Analysis Services (SSAS) - power bi Your experience and skills in these areas will be critical to the success of our project. Only serious and high-quality professionals need apply. This is a challenging role and previous experience in the given areas is a must. Let's enhance our MSBI solution together and make it the best it can be.
update front and back label protein coffee caramel update front and back label protein coffee with natural coffee flavour small update back label protein coffee chocolate
I'm seeking a skilled WordPress developer to build two distinct websites - a software solutions portal and a job posting/hiring portal. For both of these projects, key functionalities required are: - Client login and regi...these portals are still fluid, so you'll have the opportunity to express your creative ability and expertise in user-friendly design. Previous experience in developing similar portals will be a definite advantage. I'm open to all suggestions that can enhance the aesthetics as well as the user interface. Critical skills: - Familiarity with WordPress - Proficiency in PHP, HTML, CSS, JavaScript, and SQL - Experience in e-commerce and job/employment site design - An eye for visual design and user experience I look forward to your innovative idea...
... - Apply frameworks like , Django/Flask, Spring Boot, or Laravel to structure and streamline the development process. - Employ tools such as Postman for API testing, and Swagger/OpenAPI for documentation, ensuring a high-quality developer experience. - Integrate authentication and security protocols, including OAuth 2.0 and JWT, to protect the API and user data. - Manage databases (SQL or NoSQL) effectively, ensuring data integrity and performance. - Containerize the API service using Docker for easy deployment and scalability. - Oversee the API's deployment on cloud platforms (AWS, Azure, Google Cloud Platform) or services like Heroku, ensuring high availability and responsiveness. - Implement CI/CD pipelines using Jenkins, Travis CI, or GitHub Actions to automate te...
...assistance with a data entry project, specifically inputting numerical data into spreadsheets. The data will be sourced directly from Twitter. I have a list of tweets. Approx 300 tweets. I need you to take the list, click on the tweet and record into a spreadsheet the number of views, likes, retweets, comments that the tweet received With that same tweet, take the twitter handle and put it in a column and record the number of followers that the twitter handle has. Ideal Skills: - Proficiency in data entry - Experience with spreadsheets - Familiarity with Twitter and how to extract data from it effectively. The successful candidate will have a background in numerical data entry and sourcing information from social media. Familiarity with Twitter and its retrieval capabilit...
I am in search of an Oracle professional to lead the crucial task of migrating our less than 1TB Oracle 10g database to the 19c version. I have a comprehensive backup of the database, so data integrity and recovery won't be an issue. However, specific areas that we need expertise on are: - Oracle 19c migration - Enhanced security implementation Skills & Experience required: - Minimum of 4 years' experience with Oracle databases - Proven experience with database migration, preferably from Oracle 10g to 19c - Sound understanding of Oracle 19c's security features and how to maximize these for our business operation - Detail-oriented capability to ensure a seamless migration with minimum downtime. Your role will be central to enh...
I'm seeking a skilled Oracle database specialist to perform various tasks such as data migration, performance tuning, and query optimization. Your experience and past work will be essential, so please include detailed project proposals. The database plays a crucial role in storing and managing data, analyzing and reporting, and integration with other systems in my project. Key Requirements: - Proven Oracle database management experience - Expertise in data migration, performance tuning, and query optimization - Ability to analyse data and produce clear reports - Expertise in integrating databases with other systems Please make sure to detail your Oracle DB experience, including any past projects you've worked on - especially if they are sim...
...effective communication abilities, exceptional attention to detail, and the ability to work cordially with a diverse group of people. - Usage of vivid colors to enhance audience attention. Preferred colors include Red, Pink, Black, Purple, and White. - Creative use of fonts for improved readability and uniqueness. Please empathize that I am skilled in Microsoft Office, Excel, Word, Teams Outlook, SQL, Voya, and ADP Ideal candidate: The ideal candidate for this job would have a great eye for design, experience in creating engaging PowerPoint presentations, and an understanding of how to present personal and professional attributes in a visually appealing manner. Fluency in English is a must. This is not just about translating skills into bullet points but about telling a stor...
A automação busca informações em determinadas áreas do site, em duas páginas deste, obtem essas informações, guarda em um banco de dados, depois prenche o cadastro.
I need someone to fill in the spreadsheet below 3 times now and 3 times a week after that. I will pay (escrow and release) your $5 FL fee as soon as I hire you. Then I will pay $10 for each spreadsheet that you fill in. Attachments: JPEG: Snap...DONE: Look at JPEG Snapshot_5. There are 3 numbers: Time: 3000 Speed: 1.5 Bottom Left: 70 (Ignore the number 000 at the bottom right.) Look at the Excel Spreadsheet and the zip file Snapshots Part 1. Two of the rows are filled in with the numbers on the first two jpegs in the zip file. Your job is to fill in all rows of the spreadsheet using the 2 zip files of jpegs. (There is also an extra column and row to write any problems, questions or comments you may have.) Spam Bot test: 1. When can you start? 2. How long can you work on it now...
I am looking for a script to automatically add 7 days to a date in a table. The date format is dd/mm/yyyy and the date is located in the column "Not done late +35D". The result should be a new column with the date + 7 days, called "Not done late +42D". Specifications: The script must work on Microsoft Word. The script must be easy to use and does not require any programming knowledge. The script must be compatible with recent versions of Word (2013 and above).
I am looking for a skilled Shopify expert to re...product descriptions and the checkout process to ensure they are streamlined and user-friendly to encourage customer purchases. - Integration of upselling and cross-selling strategies: This means recommending related products or services to customers to increase the average transaction value. - Adding special features: Implementation of functionalities like live chat support for immediate customer query handling, a wishlist feature for boosting repeated sales, and personalized product recommendations to enhance the customer's shopping experience. Ideal candidates should be proficient in Shopify platform, have knowledge in UX/UI, an understanding in conversion optimization, and experience in implementing upselling and cross-sell...
...recording used. PART 3 – Kit Proposal: In the form of an Excel spreadsheet (saved to a PDF if you wish), provide a kit list proposal for a portable recording rig suitable for orchestras, choirs, small ensembles and soloists. Spreadsheet should include: Item, Number included in setup, Cost, Supplier (web link) The total budget (including cables etc.) should not exceed £20k (inc VAT). Include a column for brief notes on each item. NOTE: All Recordings and other necessary documentation would the be uploaded. Such as pictures / videos of the various mic positioning and documentation of various mics used and the distances from the sound source. NOTE: You are not to do any form of recording, the following are the Submission Requirements (In Summary) PART 1 –...
I'm looking for an expert in minimalist design to create both a label and a logo for my honey glass jars. Key elements to include in designs: - Logo: Incorporate both a honeybee and a honeycomb into a simple, clean design. - Label: Must display the name of the honey, its net weight, the ingredients, and origin. Ideally, the freelancer will have experience in minimalist design and familiarity with the food industry and product packaging. Capable and effective communication in all stages of the design process is also something I see as hugely important. With your creative input, I'm confident we can make an appealing package design that conveys the natural beauty and simplicity of my honey product.
I require a freelancer with expertise in minimalist design to craft a captivating packaging label and logo for my honey glass jars. I'm looking for: - A design that communicates simplicity, sophistication and elegance, reflecting the minimalist aesthetic. - A logo where creativity can take full flight. As I've left the elements to include open-ended, I'm eager to see where your imagination can take this. - All work to be completed within a month. You should ideally have experience in product packaging design and creating logos, a keen understanding of minimalist design principles, and a knack for turning abstract concepts into stunning visuals.
...Please show examples of things you may have done that are similar. Here are the requirements: * Animate text and resume graphic, as well as additional graphic shapes / elements * Develop an animation based on the provided script * Incorporate creative and engaging text and graphic elements * Deliver a high-quality, polished final product * Template File, with artwork and text can be changed * Label Layers, so it is easy to understand and edit * Colours To Use: Red: (#c30000), Cream (#ffecdc), Black, White. * Red can be used for headlines, cream or white can be used for background colour) * Fonts To Use: Gotham (Can be provided) or Montserrat () * Aspect ratio: 16:9, 1920x1080 (1080p) * Video length: 15 seconds maximum * Audio: None * Final file:
I’m in need of an expert who can extract and present detailed reports from Stripe Sigma SQL. Expectations are as follows: - Ability to extract following details: Customer details, Sales data, Subscription information, and specific SaaS Measures. - The SaaS measures that need to be included are Monthly recurring revenue (MRR), Churn rate, and Lifetime Value (LTV). - The reports will be expected daily, so proficiency in time management and meeting deadlines is a must. Ideal candidates will have a solid background in SQL, experience with Stripe Sigma reporting, and a detailed understanding of SaaS metrics.
... The primary function of this tool is to provide users with baby name suggestions based on their input queries. Upon receiving a query, the tool should interact with OpenAI's services to generate relevant baby names. These names should then be displayed not on the homepage but on a separate, dedicated page for the results something similar to this - Instead of these grids we could have ai generated baby images as a background for each name. These names need to clickable. For example, if the tool suggests names such as Robert, Mia, Sia, and Leon, clicking on one of these names (e.g., Robert) should prompt a further query to Open Ai gather and display detailed information about the chosen name on yet another page. my url -
More details: We require a data scientist to obtain Financial Stock Market data and create a SQL data base to analyze the data with visualization, Algorithm development and optimization We want to analyze current and Historical stock market data.
I'm looking for an experienced professional to setup Azure Data Lake (ADL) or my SQL server and integrate it with Tally ERP. **Key Responsibilities:** - Configure Azure Data Lake or mySQL server for data storage and management. - Setup real-time sync of data from Tally to ADL. **Volume of Data:** - The ADL should be capable of handling and storing less than 1 terabyte of data. **Tally Integration:** - The data to be synced includes invoice details, inventory records, and financial transactions. **Ideal Skills:** - Prior experience with Azure Data Lake setup. - Knowledge of Tally ERP and its functionalities. - Experience with real-time data syncing.
I urgently require a SQL query for my php code. It should basically delete rows from two tables
...- The scraped data should be stored in an MS SQL format. - The data needs to be scraped continuously (Every second), on an ongoing basis. Nature of Work: - Retrieve Data continuously (Every second) & update in to MSSQL - Add option to change MSSQL login & pwd details. Also Auto save the details in application - Attached Screenshots for Reference data Tables - Retrieve data continuously (every second) from below url's ,69,1081628,160,1,49776&curr-name-color=%230059B0&fields=15m,1h Gold & Silver Ratios Data from Kitco url (attached screenshot) : Skills and Experience: - Proficient in web scraping techniques and tools. - Experience with MS SQL databases. - Strong knowledge of data management
1) Continue on previous projecName existing api to: api/v1/log/post 12 New api: api/v1/log/get-time/<Serial> • For instance, api/v1/log/get-time/12344 • Returns unix time from Redis, 0 if not exist 3) Add customizable numeric return value for API functions • log_data TO log_user; 8) Change JSON to: {"serial": "AB10", "sequence": 23} and add a sequence field in the table. Sequence shall be a “small integer” – two bytes. 9) Change log_data to a hyper_table, may affect table structure. 10) Maintain a “” script with all initialization etc. 11) Restructure user/database is intended to safeguard for SQL injection? Do you also propose to sanitize strings before createing RAW SQL? 12) Provide s...
$10- Task - We are looking for a developer to help fix our Zappier Currently we have a functioning webpage where images are uploaded processed through OCR and the data is then sent to via Zappier. We need someone to do the below: - Fix the problem, stopping the data being sent to (Only one column, which is the issue) Components: - Webpage its hosted- Godaddy - Zappier zap functioning sending data to
I am looking for a script to automatically add 7 days to a date in a table. The date format is dd/mm/yyyy and the date is located in the column "Not done late +35D". The result should be a new column with the date + 7 days, called "Not done late +42D". Specifications: The script must work on Microsoft Word. The script must be easy to use and does not require any programming knowledge. The script must be compatible with recent versions of Word (2013 and above). Example:
...a delectable and enticing label design. The design should be attractive, informative, and should be able to capture the essence of the type of food being sold. Anti-freeze resistance capacity in the label material is important given the storage conditions the package will be exposed to. The label should communicate our brand identity while ensuring legal compliance with food labeling standards. The ideal freelancer for this job: - Has prior experience in graphic design, specifically for food product labeling - Understands the terms used in food safety and their importance in label design - Has an impressive portfolio that demonstrates their ability to create attractive and effective food labels - Good knowledge of printing processes, different types of ...
...The Token Pricing will need to be able to Calculate the price of Brake Tokens dynamically based on the current exchange rate between BNB and USD. You can use a price oracle or external API to get the current BNB/USD price. Token Purchase Process: Display the current price of Brake Tokens in USD on the future website. Allow users to enter the amount of Brake Tokens they want to purchase. Dynamically fetch the price of BNB from an oracle, you would need to integrate with a decentralized finance (DeFi) protocol or an oracle service that provides real-time price data for BNB. This would involve making API requests to the oracle service or interacting with DeFi smart contracts to retrieve the price data. Calculate the equivalent amount of BNB required based on t...
I'm in need of an experienced and highly creative print designer to help create the product label for a food packaging. The design must be compelling, invoke appetite, create a sense of brand reliability and remain appealing to our target demographic. The ideal candidate should possess the following: - Proven experience in print design, specifically product labels - Ability to design unique and creative labels that stand out - Familiarity with the food industry trends and designing for food packaging - Attention to detail and ability to adhere to brand guidelines. The goal is to make our food product visually appealing and effectively communicate our brand's vision through graphic design. Understanding the nuances of designing for food products is a requirement, not an ...
I currently have a SQL Server database running on an on-premise server and I'm seeking assistance to back it up on Google Drive. - Experience with SQL Server DB management is essential - Comfortable working with on-premises servers and transferring large files offsite - Familiarity with Google Drive storage and its integration with server systems - Ability to guide and advise on maintaining backup processes moving forward. Your expertise will contribute to securing our system and ensuring data protection. Regards
Currently, I'm in search of a SQL administrator who can help me set up Tableau
Hi, we have our server down due to an error on the DB. DB query failed: SQLSTATE[HY000] [2002] Connection refused MariaDB is offline. We are using Plesk. We are requesting restoration and maximum attention to the DB. Please note that we do not "open" Milestone. Payment is only made upon perfect resolution.
I'm in need of a competent developer proficient in Python, Docker, and PyMongo for microservices development. I have the code in which the lambda function integrated with S3 Storage bucket , Need to modify it and integrate with OCI Storage bucket. OCI Is Oracle Cloud services. Second need to make build and deploy it on docker and test Key Responsibilities - Development of microservices using Python, Docker, and Pymongo - Employing best practices in microservices development to enhance flexibility Ideal Candidate Skills - Profound understanding and experience in Python programming - Extensive experience with Docker and Pymongo - Proven track record in microservices development - Strong understanding of flexible microservices development techniques Consider applying if you...
I require efficient and expert assistance in the creation of a Word document incorporating various form fields: Text fields, checkboxes, and dropdown menus. The arrangement of these form fields will not follow a conventional single or multiple column layout. Instead, I require a customized arrangement modeled on a specific example I already have. This should help ensure all fields align perfectly with the given specifications of the document. Ideal candidates would have extensive knowledge of Word layouts and superior comprehension of manipulating form fields. Familiarity with complex document design will be highly advantageous. Your role will involve replicating the example provided to achieve the desired form. Attached doc that needs to be automated. The text highlighted i...
...aware that access to some sites might require a 'dealer login'. This task is an initial step towards a regular monthly assignment focused on supplier sourcing. Initially, my goal is to identify 1-2 very good distributors to kickstart the process. I would ask you to research 24 hours in 3 milestones, and each 2 days send me an excell with an update of about 8 hours of work. It could be that I add a column to the excell if needed as this is my first outsource of this task. Core Products: Pergolas, pavilions, patios Complementary Products: Outdoor furniture (tables, bar stools, lounge chairs) Porch swings (polywood swings) Patio lights, rocking chairs, daybeds For Year-Round Sales: Patio heaters, fire pits, outdoor fireplaces Finding Distributors: -Direct Website Resea...
...traffic in front of the car, we would like to develop a model that can detect all the lanes in front of the car. There could be multiple lanes visible in the field of view of the camera and the model should be able to detect every lane separately. Model Input: Video from a forward-facing camera mounted on a vehicle Model Output: 1) Detect all the traffic lanes in the field of view of the camera 2) Label all the lanes and separate them from each other Notes: I don't have any training datasets, so you need to find available labeled and open-source datasets. Example: Here is a link to a video of a similar project: Proposals: 1) I am interested to see proposals for developing a model from scratch and owning the model. We can start with developing
A financial platform that analyzes, suggests, alerts and accompanies the user based on the information he/she enters. The idea is to be very user friendly Oracle or similar If it can be in a "Google" environment, the better Preferably web access The information is entered in Excel or PDF, which will require a PDF reader and also the possibility of manual entry into the platform. Possibility to be interactive with chat Lots of graphs and user friendly ways of displaying the information
(Azure) (Cloud Storage) (API) (SQL) (NoSQL) (RESTful) We produce radio frequency identification (“RFID”) readers and use several proprietary applications during production, fulfillment, software licensing and support of our hardware products. These applications are written in C++ and Java and run on Windows. Our contract manufacturers and fulfillment centers use these proprietary applications which produce a variety of files and data stored locally during production of each device. Information regarding post-production sales of software add-on features is also stored in the database. Each operations location generates local SQLite databases and other data files which are individually copied to our home office and merged to contain data from all locations. We want ...
...and leave. Second Product is named “Xamayca “a Body Oil Spray.(Xamayca) is the original name for the country Jamaica . Ingredients Coconut Oil Castor Oil Pimento extracts Leaf of Life extracts Pineapple Oil Directions After using one of our Scrubs you can seal in back the moisture with this Body Oil. Simply towel dry then spray oil on your body and massage it in. 8oz spray Bottles Label size 5cm tall and 11cm wide...
...date" and "resignation date" fields are modified. 1d) alphabetical sorting of data (by "surname" column) when a new record is inserted into a sheet. PART2: The second part concerns the possibility of transferring some data present in the "CEL ANNUALE" sheet to a new sheet called "BORSE-TIROCINI". In this case there must be a button in the sheet that allows you to open a new userform, the "userform3" where, thanks to a search box, some fields of a record of your choice present in the "CEL ANNUALE" sheet can be retrieved and entered as such. data in the " BORSE-TIROCINI " sheet by inserting them in the first free row of the table and sorting the rows in alphabetical order according to the "surname"...
Task Description: As discussed, the task involves building a simple web page with grid-formatted data. The ...are in the rows and months are in the columns. Page 2: Store-wise Highest Hierarchy2_id Product Sales Display product sales for each store based on the highest hierarchy2_id. Page 3: Store-Hierarchy Matrix Display counts of products sold with stores in rows and hierarchy levels in columns. Additional Requirements: Add a scroll feature where missing. Implement a feature where clicking on a store column in the first page navigates to the second page, displaying store-wise details only for that specific store. Note: Please reach out if there are any questions or clarifications needed regarding the task. Kaggle Data Link :-
...being easily understood - makes an otherwise simple task - impossible. Whilst the task itself is isolated to a great extent from the much larger project, unless the meaning of the words comes as second nature - it would take more time to document the task than to just do it. Further the tasks requires access to a database key that is not a toy. As per the auto generated blurb below - celery and sql skill sets are also required. Thanks for your consideration. - Being geographically placed in the US or Canada is not a skill per se, it is desirable to facilitate better communication and collaborative working, this is not a task you will be able to just "do" - although the right person will be able to do it very quickly as its more common sense than technical skills requ...
I'm seeking a professional with proficiency in Excel to interpret and visualize my company's sales data. The project involves transforming our monthly sales figures into an intuitive, easy-to-understand line graph. Key requirements include: - Ability to translate complex data into a clear, ...to deliver within tight deadlines. Graphing details are: 1. Revenue per provider (provider initials) and clinic (overall sales)per month. 2. (Growth) monthly comparisons from years 2020 to 2023 and partial 2024. 3. Vertical axis = Revenues in dollars. 4. Horizontal axis = months Jan thru Dec 5. Chart name.= Average daily revenues per doctor and clinic. 6. Separate chart (#2) plotting R column. revenues/provider vs. each year 2020-2023. 6b. Chart name = Average daily revenues...
I require a skilled professional to connect my Windows application directly to a private cloud Microsoft SQL server single database instance. My aim is to improve efficiency in data communication between the two entities. Key Requirements and Skills: • Extensive experience in cloud computing and SQL server database • Proficiency in Direct Connection of a Windows application to a private cloud platform • Knowledge in setting up Single database SQL Server Architecture • Ability to collaborate and provide effective solutions The right freelancer will work with me closely to ensure smooth and efficient functioning of this connection. Your communication skills, prompt responsiveness and understanding of this technology will be critical for the succe...
I am looking for a Power BI developer to help me make a new visual and table where elements are mapped together. Must work over teamviewer or anydesk. I cannot give out passwords for SQL
I am currently in need of expert C# programmers who could develop a software capable of user authentication and database integration. Key functionality includes: - User Authentication: The program shou...develop a software capable of user authentication and database integration. Key functionality includes: - User Authentication: The program should allow users to securely log in using a username and password. Experience in developing secure login systems is highly appreciated. - Database Integration: The solution must integrate with SQL databases, hence, proficiency in SQL database connections is mandatory. The developers must be experienced in C# programming, SQL databases, and secure user authentication. Candidates with a proven track record of similar proje...
I need assistance in creating a Power BI dashboard that clearly visualizes survey results data. Connecting to SQL databases forms the backbone of this project. The dashboard must be updated weekely with new survey results data. Ideal Skills & Experience: - Proficient in Power BI - Experience with SQL databases - Familiar with survey results data representation - Ability to schedule monthly updates in Power BI Your primary task will be to make the survey results understandable and accessible through a well-designed Power BI dashboard. Your expertise in SQL and Power BI dashboard creation is crucial for this job.
I'm in need of a proficient freelancer who can assist me with: Creating a proof of concept web page in which an existing file, stored in OPENAI storage, is utilised as a reference during an API call. File types: To include: pdf, ms word, Excel, CSV, text, XML, JSON User acceptance: To be able to query openAI about the file and get responses that relate exclusively to the reference file. Code: Native JavaScript. Can use external libraries. Should run on any server without installing plugins. Specifications: - The file constitutes mixed data, encompassing both numerical and textual information. - The system should seamlessly interact with the entirety of the file. - The primary task involves integrating the API to fetch data from the stored file, read and analyse it as re...
I need python expert for small task , Sql task and ftp task I need it to start now be done today if you can do it pls start your bid NOW
...sources of my interest are platforms like Spark, AWS, Azure, GCP, and Hive. I want to understand effective methods for data extraction from these particular sources. Ideal Skills and Experience: - Expertise in ETL tools for data extraction - Hands-on experience with Spark, AWS, Azure, GCP, Hive - Profound knowledge in data engineering - Experience in career coaching or mentoring will be a bonus - SQL -Python This assistance will give me a competitive edge in my upcoming interviews by providing me with practical skills, knowledge, and confidence in addressing ETL-related questions. So, a mentor with over 10 years of experience in data engineering, particularly in ETL processes and in touch with modern data extraction techniques, would be ideal....
