Create table and insert data sql jobs
...simple and not more than 2-3 hours job if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command
I need an expert to create a Video for a Facebook ad for an English learning Website. The video will be in Spanish language since the target audience will be Spanish speakers in South America who wish to learn English. I therefore need someone who is a native Spanish speaker (from South America) but who is also proficient in English. I prefer someone currently living in South America. The target platform will be primarily mobile and secondarily laptop users. The video should be a sketch/testimonial of sorts highlighting the effectiveness of the language learning approach taken by the website (see below). Creative, performance, acting, and video producing/editing skills are required. About the website's language learning approach: In order to acquire a new langua...
... * insert a link to a document for download on one of the site pages (this document has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, month, account status and account number (these fields have been created, you just need to display them on the page). It should be possible to delete and download invoices, both individual documents and all at once. * There are 2 fields created on the site (tariff payment and number of contacts). You need to make sure that these fields are als...
...Developer and Graphic Designer to create a dynamic, user-friendly recruitment agency website targeting German employers. The goal is to design a site similar to but tailored to our specific needs, including custom graphics and a unique logo that represents our brand identity. KEY REQUIREMENTS Languages and Frameworks: - Frontend: Expertise in HTML5, CSS3, JavaScript, and experience with frameworks like React.js or AngularJS. - Backend: Proficiency in server-side languages such as PHP, Python, or Node.js, with database management using SQL or MongoDB. - CMS Experience: Capability to integrate and customize content management systems (CMS), preferably WordPress or Drupal. Design and Graphics: - Creation of a unique logo and...
need to change document to look more professional have it save as a pdf and have auto signature on it i will need my logo put on to it. i will need to be able to insert pictures i will be needing to do all of this from a Samsung tablet, so if i take the pic on the tablet i want to be able to insert that pic into the doc all of the information on the original doc will stay the same and i want them to stay as tick boxes the attached doc is an example of that the original doc is
...ability to create gripping and vivid horror scenes while maintaining the manga art style. Your role will involve: - Creating detailed, expressive, and dark characters in the traditional manga style - Designing terrifying environments and settings - Setting the mood with your art and paneling - Working closely with me to ensure that the art matches the script It's essential that you bring a passion for horror and a knowledge of the genre to the table. Your work should be both visually engaging and contribute significantly to building the tension and atmosphere of the webtoon. Ideal skills and experience: - Proficient in manga art style - A strong portfolio of previous horror-themed work - Ability to work co...
We are in need of a creative and knowledgeable content writer who can utilize copyright-free AI generated contents based on the following titles topics (see image) We want some content to be edited manually to insert and optimize based on the keywords for each topic. Blog posts and Articles with an advanced comprehension of Business Lending and Finance.
Hi we have small web application on PHP we have face issue to save or publish some data and some table shorting please bid if you can fix this quickly
Create a form in google Sheets following the pre-determined options. The results of the answers must be recorded in a second tab
...of a qualified developer to create a pipeline utilizing DBT and SQLLITE. The goal is to process a multitude of json files housed in a particular folder. Please refer to the assignment document for detailed instructions Step 1. Initial Setup: ● Use DBT and SQLite to create a pipeline that processes files from a folder structure. You can access the folder here Step2: Adaptation for Continuous File Deliveries: ● Adjust the pipeline to handle continuous file deliveries, where new folders with JSON files are added over time. For example: Step 3: Data Quality Assurance: ● Create a suite of data checks to ensure the data is clean and add a DBT command to run these checks. ● Suggest additional information or metrics that could be...
...tracking and resolution. As the priority of the project, I require the CRM to systematically record and track customer issues, from initial identification through to final resolution. The ideal candidate for this project will have: - Strong experience in creating web-based CRM platforms - Expertise in developing customer service focused CRM systems - Proven track record in integrating issue tracking and resolution functionality - Proficiency in customer database management and optimization The deliverable is a Web-based CRM application that is easy to navigate and meets all the desired functionality aspects. It would be added advantage if you have previously built CRM systems following a similar brief. This job requires an understanding of how custo...
...understanding of data organization and presentation will be appreciated. In this project, efforts will be channeled towards changing 7 existing SPSS tables to match APA 7th edition requirements, including double-spacing, 12 point-font, Times New Roman font style, and, if needed, notes under the table or necessary italicization or bolding of headers/keywords. Manual entry of descriptive text and data values to form each independent table is needed. In other words, raw data cannot be provided to manipulate or recompute in SPSS or any other program! The SPSS tables currently display: Table 1. 4 columns and 13 rows Table 2. 11 columns and 7 rows Table 3. 11 columns and 6 rows Table 4....
...need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the y...
I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server...
I'm facing an issue with my Laravel admin panel, specifically a database table owner error that's occurring when uploading a zip file. - The error seems to be centered around the database table ownership. - The error happens during the process of uploading a zip file. - I can provide more details on the issue if required. I'm looking for a professional with experience in Laravel, database management, and debugging to help resolve this issue. The ideal candidate should be familiar with Laravel's database interactions and be able to navigate and troubleshoot these types of issues efficiently.
Hi, I am looking for someone to take my text-only Microsoft Word document and create a nice-looking visual booklet for people to read. I have already typed out the document and would like someone to add some good fonts, formatting, images, and themes. It is important that this be done in something like Microsoft Word or even Microsoft Powerpoint for me to make the final adjustments. ***I will send a quick message with the word document and what the preferred themes and colours are to be. *** I have attached an example Handbook as a Guide to what is to be made.
As the client, I require the services of a skilled copy typist who can accurately duplicate a PDF document. The original document contains tables, so a certain level of precision and attention to detail will be necessary. Your tasks: - Copy typing a PDF document - Transcribing tables as text - Ensuring 100% accuracy The ideal freelancer for this job has previous experience with copy typing and transcription, and is familiar with working with PDF documents and tables. A strong understanding of English and high attention to detail is imperative.
Create an astronaut helmet logo similar to the style of the logo attached. Please show how your logo looks on a white background and on a black background.
I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and...
I am urgently in need of an expert in Data Build Tool and SQLite database who can efficiently develop a data pipeline. The pipeline will handle extracting all files from a specific folder location on my local drive. The goal here is to create a pipeline that can universally extract all types of files. Ideal Skills and Experience: - Proficient with Data Build Tool - Extensive knowledge of SQLite database - Prior experience with data extraction projects - Quick turnaround time - Ability to work with local storage systems This is a two-hour assignment and the steps required for the task are detailed in the document provided. Your quick assistance is highly appreciated!
...a catchy kids song created about the digestive system. The lyrics should be fun and explain how food works its way through the digestive system including: - the mouth where food is chewed and saliva begins to break down the food - the esophagus where food travels to the stomach - the stomach where food is broken down into small pieces, like a blender - the small intestine where nutrients like vitamins and minerals are soaked up from the food for the rest of the body to use - the large intestine where all the left-over waste from the food turns into poop. The deliverables should include a) the complete song with the vocals and the instrument backing track, and b) a second file with just the backing track. And I want the song to be very catchy. ...
...candidates should possess: - Strong writing and editing skills - A knack for structuring information effectively - The ability to create engaging and clear content however, no Chatgpt , no google Bard/Gemini, or any other AI tool. Cybersecurity CIA Analysis (2019-Present) Need in-depth analysis of CIA triad in recent research? 5 IEEE papers (2019-present) Comparative table with key insights ⚡ Fast, expert research & delivery Order now & unlock cybersecurity knowledge! Tags: cybersecurity, research, CIA, IEEE, analysis, comparison - Identifying potential vulnerabilities in multiple IoT in smart city systems - Analyzing existing cybersecurity measures - Proposing enhanced security solutions The ideal candidate will understand Security Challen...
...existing website (created with laravel by botble. See this link for the product we have and their support documentation. We need a checkout option for Zelle and for Cashapp. These will be seamless just like checking out with credit card. The customer will select one of the two options and then they will be prompted to login to their account to complete the payment then upon successful payment they will be reverted to the payment success screen. Additionally you will add a field into the product category table and to the product add/edit pages in the admin panel for payment options allowed. Certain product categories can be paid with credit card whereas the others cannot. So something like cc_allowed and the answer would be y or n. Upon the opt...
...SSRS Reporting Service on a staging environment. I have configured the WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the call since this is a secured environment...
As a data enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. ...
...coded in python. You have to create the APIs for webapplication. Then you create the Website which has 2 user types. Job Seeker and Employer. Login to use (home page) Job seeker will upload their resume details using a fixed form. Employer can post as many jobs using an upload job form. The data is stored in a table. On clicking the Find Jobs button (after uploading resume) or Find Profiles (for each job posting uploaded) the results page will show the ranked results (either job or resume depending on user). Home Page - Login SignUp buttons only...no design or banner or random stuff. Profile Page - Form Filling page with resume details. Resume Form Page Job Description Page Simple Dashboard (employer only) page with My Jobs Results Page for job ...
...Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the ...
...native PHP and JavaScript. As this app is now deprecated and outdated, we are looking to rebuild it entirely from the ground up while retaining its core functionalities. Project Overview: We are seeking to develop a modern web application using cutting-edge technologies: - Frontend: React.js for dynamic and responsive user interfaces. - Backend: Laravel for robust and scalable server-side logic and API development. To begin, we can provide you with access to a working instance of the current application, which you can run locally using XAMPP or WAMPP. Please ensure that PHP version 5.6 is installed to ensure compatibility and functionality. If you are interested in this exciting project and would like to discuss further deta...
...creating a custom WordPress hosting management plugin and integrating Snipepay as a payment gateway in WooCommerce. Our hosting company currently sets up client accounts manually through a control panel that supports API integration. The successful development of this project requires extensive knowledge of this API to enable full automation of the account setup, hosting package ordering, and management processes directly from our WordPress site. The developer will need to ensure seamless communication between our WordPress interface and the control panel's API, enabling users to perform all actions in an automated, user-friendly manner without manual intervention. This includes the ability to manage domains, select hosting packages, and complete purcha...
Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )
I need an expert API developer to create a functional, reliable API for automating table reservations and event bookings on my website, integrating with Tabology. The task involves: - Understanding the existing booking system on the site - Defining specific automation processes for table reservations and event bookings - Integrating these processes with Tabology to enhance efficiency and usability A successful freelancer for this project should demonstrate significant experience with API development and have a deep understanding of booking system operations. Familiarity with Tabology integration will definitely be an added advantage.
...looking for a skilled freelancer who can help me with importing product data from XML sheets. The data needs to be imported into multiple Prestashop faced search feature tables. Key project details: - I need the product information to be imported - The data needs to be updated daily and in real-time - Multilingual support is not required, so a single language is sufficient Ideal Skills and Experience - Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feat...
I am looking for a professional logo designer who has a keen eye for creating engaging and dynamic logos. You need to be a creative thinker who can bring fresh new ideas to the table as I do not have a specific concept in mind. Key Responsibilities: - Creating an innovative and captivating logo design - Being open to feedback and willing to make adjustments as needed Ideal Skills: - Extensive experience in logo design - Creative thinking and open-mindedness - Strong communication skills to understand design requirements and feedback I can't wait to see what unique ideas you bring!
I'm working on a film or TV production and in need of an experienced 3D artist who can help me with 3D modeling, Visual Effects (VFX), and Computer-Generated Imagery (CGI), all with a focus on creating a realistic visual theme. Key Requirements: - Proficient in 3D modeling, VFX, and CGI - Experience working with a realistic visual style - Previous work on film or TV productions is highly preferred Looking for someone who can bring creativity, technical skills, and flexibility to the table, while delivering high-quality and realistic CGI work. If you've got the right skillset and experience, I'd love to hear from you.
I need a talented interior designer who has a knack for modern styles to revamp my home. This includes the living room, kitchen and bedroom. Creativity and originality are crucial; I'm looking for someone to bring fresh, innovative ideas to the table. Experience And Skills: - Understanding of modern interior design elements. - Previous work on residential homes. - Ability to turn visions into reality. - A portfolio showcasing previous design work. The aim of this project is to transform these rooms into efficient, aesthetically pleasing spaces. If you understand the subtleties of modern design and can apply them to residential surroundings, then this project is for you.
I will do these screen design in figma they are exactly 8 screens as following: 1- login 2- home with the table of tasks 3- forget password. 4- my profile. 5- search for vehilce 6- vehicle Details. 7- taking images of vehicle (repeatable screen) 8- Milage screen
...new logo will be used on our website and on our social media platforms, making it essential to be visually effective in both large and small formats. Specific Requirements: Colors: The design must incorporate the color palette of the current logo. Design: The design should be original and clearly differentiate from our current logo and from free online examples which I will attach for reference. These examples are just to indicate styles or elements we like, but the final design must be unique. Adaptability: The logo should be easily adaptable for use in digital formats (such as website headers and social media profiles) as well as printed materials. About Us: We are Cubaherald, an online newspaper dedicated to covering relevant news from Cuba, Spain...
...simple and not more than 2-3 hours job if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command
I need a tech-savvy freelancer to create a custom thank you page for my WooCommerce website. The page should have a particular focus on: - Presenting order details effectively. These details must be displayed within a detailed table, allowing for a comprehensive overview of the purchase made. Ideal skills and experience: - Experience in programming and website development. - Familiarity with WooCommerce and creating custom pages. - A knack for clean, efficient code and attention to detail. - Knowledge in creating user-friendly, intuitive layouts and designs. Please note the client has opted not to include any interactive elements within the detailed table on the thank you page. Therefore, ensuring factual accuracy and perfec...
I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.
...link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criteria is small. If I pass filter for say 50 GUIDS then this query does not return...
I'm seeking an interior designer with the skills and experience to create a Bohemian-style design for a /laboratory and living room. The ideal candidate will be able to deliver a design that is both aesthetically pleasing and cost-effective. Key Requirements: - Design for a small space - under 500 sq ft - Bohemian style - Earth tones color scheme Ideal Skills and Experience: - Proven experience in small space design - Creative flair for Bohemian design - Ability to work within a budget - Strong understanding of working with earth tones This project will require close collaboration and communication on design choices and adherence to a strict budget. I'm looking for a designer who can bring fresh, innovative ideas to the t...
I need a 3D modeler to create a straightforward product model based on provided photos. There's no need for intricate details or textures, just a model that captures the basic shapes and proportions of the product accurately. Key points: - The model is based on photographs only; I will not provide sketches or detailed drawings. - The aim is to create an 3D model (STL) - Leg from table. - Experience with product modeling and the ability to work from photos is crucial.
I need an editable Word template created. The document will have permanent styles, but editable sections for my team to fill in. Key Features: - The template should include common formatting options like font styles and sizes, bullet points, numbering, and page borders. - I need the following styles to be fixed in the template: Heading styles, Paragraph styles, Table styles, Font, color, alignment, Indentation. - The main body content should be the only editable section for my team. Ideal Skills: - Proficient in Microsoft Word and its advanced features. - Experience in creating editable templates. - Attention to detail to ensure that the permanent styles are consistent throughout the template.
I need an editable Word template created. The document will have permanent styles, but editable sections for my team to fill in. Key Features: - The template should include common formatting options like font styles and sizes, bullet points, numbering, and page borders. - I need the following styles to be fixed in the template: Heading styles, Paragraph styles, Table styles, Font, color, alignment, Indentation. - The main body content should be the only editable section for my team. Ideal Skills: - Proficient in Microsoft Word and its advanced features. - Experience in creating editable templates. - Attention to detail to ensure that the permanent styles are consistent throughout the template.
...project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB...
...below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats....
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
...professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and...
