Sql create table in database jobs
I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project...
I need a Graphic Designer who can compellingly create a 1 page PowerPoint. This PowerPoint is designed to introduce potential business partners to the steps in delivering our services. Your task would entail creating a 1 page Slide based on 'Boxes' of text in a spreadsheet. It must be complete by 13:00 London Time today. The requirements are: - Create a one-page PowerPoint Slide - Tone must be Professional - The target audience is potential business partners - Slide must be completed by 13:00 London Time today - Include "qqq" in your response to show you've read and understand the project details - All parts of the slide must be editable in LibreOffice - Budget is USD 50.00 The spreadsheet will be se...
I'm in need of a skilled digital marketing professional who can significantly increase the Domain Authority of my B2B website. This project is crucial as it's directly linked to my overall SEO strategy and online visibility. Key Goals: - Improve the search engine rankings of my website - Increase organic traffic to the site - Enhance the online visibility of my brand Ideal candidate: - Extensive experience in digital marketing, particularly in boosting domain authority - A proven track record of improving search engine rankings and increasing organic traffic - Demonstrable expertise in enhancing brand visibility through effective online strategies Your proposal should focus on your relevant experience, particularly on how you plan to approach this p...
I'm looking for a skilled video editor who can help me enhance my content for various social media platforms, specifically Instagram, YouTube, and TikTok. Key Responsibilities:...ensure the video is visually appealing and on-brand - Enhance audio quality to make the video engaging and professional - Optimize the video for each platform's specifications and requirements I need a professional with: - Proven experience in advanced video editing, including color correction and audio enhancement - Familiarity with social media content requirements and trends - Excellent communication skills and ability to understand and implement feedback I'm looking for someone who can bring creativity and technical expertise to the table, helping me create high-quality...
...Excel. This task involves the careful extraction of data from Excel into a pivot table. The data in question is financial in nature, and more specifically, the focus is on expenses. Here is what I require: - Just the expenses data extracted from the Excel file and made available for the creation of a pivot table. - You'll need to determine the format of the data in the Expenses column. Your skills and experience: - Advanced knowledge of Microsoft Excel, especially in working with different types of data. - Proven experience in handling financial data, specifically expenses. - Ability to interpret varying formats of data on Excel. - Good problem-solving abilities, given that the specific format of the data in the Expenses co...
Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This process will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for ...
...experiencing database connection errors on my Wordpress website. Key Requirements: - Fix database connection errors causing website load problems - Ensure the website is running smoothly and all features are fully functional - Full access to the website's hosting account and database for troubleshooting - Clear and timely communication using instant messaging for updates and feedback Ideal Skills and Experience: - Proven experience in resolving database connection errors on Wordpress websites - Strong understanding of database management and troubleshooting in Wordpress - Excellent problem-solving skills and ability to work efficiently - Previous experience in instant messaging for client communication is a plus Had issue...
As the president of 'Pravah,' our Drama Club, I'm on the lookout fo...shines on its members and their talents - Cap: A subtle addition that represents our club's official attire Your design should be visually striking, able to stand out in a crowd and spark interest in our club. The target audience for this T-shirt will be our club members, as well as potential new members. Ideal candidates for this project should have a strong portfolio in graphic design, particularly in T-shirt design. Experience with theatre or performing arts would be a plus, as it could provide you with a deeper understanding of the essence of our Drama Club. Feel free to bring your creativity and expertise to the table - I'm looking forward to seeing ...
I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases
I'm looking for a skilled professional who can convert a provided design into a PDF document using HTML format. The attached format should be replicated in the PDF. I will supply all the necessary content and images for the document. Key Requirements: - The PDF should include a header and footer as per the design. - Proper formatting and tables should be implemented. - Images and logos within the document should be accurately included. Skills and Experience: - Proficiency in HTML and experience in creating PDF documents. - Knowledge of would be advantageous. - Ability to replicate a design accurately in a PDF format. - Attention to detail to ensure all elements are correctly positioned. Budget: The fixed budget for this project is 500 INR. Please bid a...
...Executing next steps and promptly executing action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -> simple ppt stuff 5. Maintain and update the status of various tasks with regular updates 6. Be able to present information clearly in English, not getting too bogged down by confusing details (clear communication) Expectations: 1. Self-driven and motivated to quickly achieve OUTCOMES. 2. Must be available from 6am MST to 11:30pm MST (mountain standard time) for calls - calls to connect will vary day by day. Must be very responsive via messages. 3. You will manage the workload on your own time, set y...
I'm looking for an experienced and well-connected individual who can collaborate with me to source high-end individuals for a unique project. Key responsibilit...and making strategic adjustments as needed. - Generating Portfolios via Events: Plan and execute events that attract potential club presidents and generate new portfolios. The ideal candidate should have: - Proven experience in sourcing high-net-worth individuals - An existing network in the business and finance world - Strong project management skills, especially in portfolio management - Excellent communication and negotiation skills This project will be handled collaboratively, so I'm looking for someone who can bring creativity and strategic vision to the table. Please provide details ...
Please make wordpress site as atteched image. 1 column and respoinsive design.※If possible,bootstrap design. Anything is include dummy text and dummy images. I make inquiry and faq,sitemap page by myself and send you wordpress login details. Required Pages:Top page,fx,crypto-ex page,1 currency detail page Please make within $120(absolute requi...design.※If possible,bootstrap design. Anything is include dummy text and dummy images. I make inquiry and faq,sitemap page by myself and send you wordpress login details. Required Pages:Top page,fx,crypto-ex page,1 currency detail page Please make within $120(absolute requirement) and delivery within about 2 weeks and give me a progress report every about 4 days. I think only the table part is a little more challenging.
I am in need of a technophile with expertise in Microsoft Access databases. Your task will involve: - Populating my database with customer data which includes names, addresses, phone numbers, organisation affiliations, and details of last interactions. - Inputting sales transactions data which include dates, product names, and prices. The ideal freelancer should demonstrate an adept understanding of database management, particularly Microsoft Access, and be able to accurately input data with keen attention to details. Efficiency, accuracy and attention to detail will be paramount for this project.
...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of da...
...Executing next steps and promptly executing action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -> simple ppt stuff 5. Maintain and update the status of various tasks with regular updates 6. Be able to present information clearly in English, not getting too bogged down by confusing details (clear communication) Expectations: 1. Self-driven and motivated to quickly achieve OUTCOMES. 2. Must be available from 6am MST to 11:30pm MST (mountain standard time) for calls - calls to connect will vary day by day. Must be very responsive via messages. 3. You will manage the workload on your own time, set y...
I've been facing issues with a MySQL table that seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in size while it has no rows at all. The database was originally like 50kb a few weeks ago. Recently we made some minor changes, like adding index. Then it suddenly become so huge. Key points: - Table size issue: The MySQL table is bloated despite having no data, and it's causing performance problems. - Insertion operations: The table is mainly used for inserts, which are what I need it to be optimized for. The work needs to be done remotely using anydesk. If you know how to do it, it should be just a few min fix.
I am searching for an experienced freelancer who is proficient in document formatting for Windows. I need my company manuals format fixed, the table of contents, page number, spacing, etc needs to be fixed The project entails: - Formatting 1-5 company manuals to enhance readability and presentation. - Ensuring consistency in all documents, including headers, footers, and design elements. Ideal candidate: - Proficient in MS Word formatting for Windows. - Experience in handling company manual formats. The selected freelancer will help me to deliver professional and well-structured company manuals.
...is to bring UFCGYM to France. The goal is to convince investors to put money on the table with the pitch deck. For the pitch deck, we need to go to the next level by improving the general design, and also making more clear what the investor will gain from this project. We would like an investor focused pitch deck with a compelling presentation regrouping facts and figures A timeline with milestones on market number and our financial analysis Ensure clarity and simplicity by using clear and simple charts to present financial data, avoiding information overload on a single slide. Utilize data visualizations like bar charts, line graphs, pie charts, and infographics (you can redesign the charts already put in the model). Incorporate interactive visuals for digital presentati...
...for a developer to create a Bootstrap filter table with advanced filtering functionality. The table should be responsive and able to handle multiple columns. Here are the specific requirements for the project: *** DO NOT BID ON THIS PROJECT IF YOU HAVE NO UNDERSATNDING OF BOOTSTRAP OR SOME IDEA OF THIS PROJECT. A TEMPORAY SKETCH LAYOUT WITH A SAMPLE WITH BE APPRICATED TO HELP US IN MAKING A DECISON WHO TO AWARD THE PROJECT TO. *** Functionality: - Advanced filtering: The table should allow users to filter data based on multiple columns. - Custom filtering: Users should be able to specify criteria for filtering. Responsiveness: - The Bootstrap table should be responsive, ensuring optimal user experience across different devices and screen siz...
I'm looking for a talented designer to create a visually appealing presentation, portfolio or catalogue. The primary goal of this project is to showcase products and services in a compelling way. I put no restrictions on the theme or color scheme, so I'm open to your suggestions and creative inputs. This project will involve creating an engaging design that is both aesthetically pleasing and functional. The content will mainly consist of images and descriptions of products and services. I'm looking for a designer who can create a sleek, modern design that is both informative and visually appealing. You need to use the attached file and info provided there. Just need to redisign. Also need to remove all watermarks from original files or find new free...
Our existing CGI...encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and...
I am looking for architectural and design services for a mixed-use property project. This entire space covers 35k...(jk),jakusi, 2 nd 5 master bed room ,1 kitchen with extra food space and washing area ,Pooja room jakusi,1 hall ,1 room for office 3 Rd home theter,Jim , swimming pool ,table tennis 4 garden ,badminton court ,car parking Lazy river and whole home surrounded by water naturally - 5 Servant and guard rooms The commercial complex design should be modern, practical and appealing to businesses. Ideal skills and experience: - Proven experience in designing mixed-use, modern properties - Knowledge of space optimization techniques - Understanding of functional and aesthetic design for commercial spaces - Attention to detail in creating comfortable and prac...
I'm looking for a creative mind to produce engaging 15-second product level videos to be used in Meta & Pinterest Dynamic Product Level Video Ads. WHO YOU ARE: - You have a firm grasp on the interests and trends of our target demo (young families with kids; approx 20-45 years old) and can captivate this demographic through short video format - You are familiar with the short, snappy format of 15-second social media videos and can effectively convey a product's appeal in this timeframe. WHAT YOU'LL DO: - Develop compelling 15-second product videos from static images for Facebook, Instagram, Snapchat, and Pinterest. Ideal skills: - Proven experience in creating short social media videos - An understanding of Facebook, Instagram, Pinterest cre...
VM CREATION (1 VPS BIND) os CentOS 8 & 9 Stream MINIMAL Direct installation or converted from CentOS 8 Linux. (Recommended) panel add install: nginx server VARNICH APACH very important !!!!!snaphopt image creation just servers working (just os) (without admin panel)!!!I want to be able to do restores, for a new installation of another panel, if necessary.! !!! !! !!!!!! link to server add SSL ADD ALL PHP CGI AND FMP (latest 6 versions)PHP AVAILABLE FOR CUSTOMER FOR ALL SERVER ADD PHP VERSION 7.9 PACHT FMMPEG add latest version change SSH22 port verification example: ns1 . add IP.: add a Mac machine adds IP.: adds mac Example of adding HOSTENAME:
...is to bring UFCGYM to France. The goal is to convince investors to put money on the table with the pitch deck. For the pitch deck, we need to go to the next level by improving the general design, and also making more clear what the investor will gain from this project. We would like an investor focused pitch deck with a compelling presentation regrouping facts and figures A timeline with milestones on market number and our financial analysis Ensure clarity and simplicity by using clear and simple charts to present financial data, avoiding information overload on a single slide. Utilize data visualizations like bar charts, line graphs, pie charts, and infographics (you can redesign the charts already put in the model). Incorporate interactive visuals for digital presentati...
Hi Nasima, about a year ago you delivered a ver simple logo for a company named Eduna. I'm restarting that project and I need a proposal template (a word document that i can use to deliver proposal) with a nice header and footer related to events planning , wedding planning , table decoration, etc.
I'm in need of a talented designer to create a label for my chemical and coatings product. The label will be used for product packaging. Key Requirements: - The design should be industrial in style, conveying a sense of reliability and professionalism. - It needs to be suitable for use with chemical and coatings products, so should reflect this in its visuals. Ideal Skills & Experience: - Experience in label design, particularly for industrial or chemical products. - A keen eye for detail and ability to create designs that are both aesthetically pleasing and practical. - Understanding of the importance of conveying the right message through design. This is a great opportunity for a designer looking to add an industrial label design to ...
...articles. Minimum Requirements: Content Aggregator: Develop a system that pulls news data from various APIs or web scraping. User Profile Management: Create functionality for users to register, login, and specify their interests and preferences. Recommendation Engine: Implement a machine learning model to analyze user behavior and curate news content accordingly. Optional Enhancements: Sentiment Analysis: Integrate a sentiment analysis model to evaluate the tone of news articles, helping users understand the general sentiment of the news they are reading. Data Visualization: Use libraries like Matplotlib and Seaborn to create graphs showing trends in news topics or sentiments over time. Interactive Elements: Allow users to interact with the data visualizations, such...
I'm looking for a skilled web developer who can create a personal website for me. I want the site to have certain features Key Features: - Course Information and Syllabus: I expect to have a section where I can upload all the necessary information regarding the courses I'm taking. - Student Login and Registration: There should be a secure login system for students to access the personalized information. - Grades, Student Education History, Fee Details: The website should allow me to keep track of my academic performance, educational history, and fee details. - Time Table: A feature that allows me to maintain my schedule and plan my time effectively. - Downloadable Documents: Users should be able to download important documents, such as course materials or assignmen...
I'm looking for a skilled web developer who can create a personal college website for me. I want the site to be similar to my college's official website, but with some unique features. Key Features: - Course Information and Syllabus: I expect to have a section where I can upload all the necessary information regarding the courses I'm taking. - Student Login and Registration: There should be a secure login system for students to access the personalized information. - Grades, Student Education History, Fee Details: The website should allow me to keep track of my academic performance, educational history, and fee details. - Time Table: A feature that allows me to maintain my schedule and plan my time effectively. - Downloadable Documents: Users should be able to ...
I'm looking for a skilled digital marketer, with a strong focus on Search Engine Optimization (SEO) and Social Media Marketing (SMM), to help generate more leads and sales for my business. Key requirements: - Develop and implement effective SEO strategies to drive traffic to our website. - Manage and optimize social media campaigns on Facebook and Instagram to engage with our audience and b...and data collection to share with sales team The right person for this job should have a solid understanding of how each social media channel works and how to optimize content so that it is engaging on those channels. SEO expertise is a must. I'm excited to see how your skills can drive our business forward. Looking forward to working with passionate marketers who can bring fresh ideas ...
...warehousing, ad hoc reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL ...
I'm in urgent need of a professional in Delhi or Noida who can assist with the customization of various home furnishing textile products. Key Deliverables: (Customized) - Curtains - Pillow covers - Table Runner - Fabric wall art - Throw blanket/ Throw curtains - Products (details to be provided) Your application should: - Showcase past work in home furnishing or textile customization - Demonstrate experience in this field - Include a detailed proposal on how you would approach this project - Most important should be from delhi or noida I'm under a tight deadline, so the quicker the turnaround, the better.
Is it possible to create a video using Artificial Intelligence? If yes, I will provide the texts (around 300 words each) and you will do it Voices need to be male and female This is for a business website If you can do the voiceovers as well, let me know I need around 100 of them; 3 to 5 minutes each
...vous contacte pour créer une affiche pour la fête des mères pour notre restaurant, Tajinier. Voici les détails de ce que nous souhaitons : Logo : Veuillez inclure notre logo dans un endroit visible de l'affiche. Image principale : Utilisez une photo d'une famille joyeuse célébrant ensemble, entourée d'une table. L'image doit évoquer une ambiance chaleureuse et festive. Texte : Titre principal : "Venez célébrer en famille la fête des mères au Tajinier" Sous-titre : "Réservez votre table dès maintenant !" Ajouter l'adresse et le numéro de téléphone de chaque restaurant en bas de l'affiche. Design : Simple...
...experienced individual to fill the role of Database Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities ï‚· Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies. ï‚· Lead a team of developers in the implementation and maintenance of database systems. ï‚· Collaborate with other stakeholders to gather requirements and define database architecture to mee...
I have to transfer data and tables from oracle to postgres.
Project Description: - I am looking for a freelancer who can help me develop a stunning website for my IT firm - The WebSite should feel primium like apples iphone page - Home page, About us, Services and Contact us pages require
...of dummy data in Laravel. 2. Implement form data transfer from the website to the CRM Enquiry Menu in Laravel. 3. Ensure that won enquiries are correctly displayed after conversion to contacts in Laravel. 4. Highlight the current menu item on the left in Laravel. 5. Correct CSV download functionality in Contacts, ensuring filters, headers, and special characters are handled properly in Laravel. 6. Enable clicking anywhere on the contact data table to open the view of that particular contact in Laravel. 7. Remove the display of the last date from the top of the contact view in Laravel. 8. Adjust calendar functionality to match design specifications in Laravel. 9. Ensure tasks are displayed on the task list page in...
I'm in need of a desktop software that can analyze a specific type of data within a PDF table. The software should: - Read and extract data from a PDF table - Compare this data against another table - Identify and save matching data in the form of an Excel file. The tables in question will contain numerical data only. Ideal Skills and Experience: - Proficiency in developing software for Windows - Experience with data extraction from PDFs - Strong capabilities in data comparison and analysis - Knowledge in Excel formatting - Understanding of numerical data handling.
Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.
Need to 2 single and separate webpages to display data from tables in MSSQL database
I'm looking to develop a corporate website with several pages, more than 10 in total. The website should have a professional and clean design, reflecting our company's ethos. We'd like to work with a developer who has experience in creating corporate websites and can bring new, innovative ideas to the table.
can you help me with developing a typography plugin for Canva? Canva is an online graphic design platform that offers various design tools and templates. The plugin should generate visually appealing text styles based on user-provided keywords and their weights. It should support custom fonts and color schemes, and gracefully handle different user inputs. Please develop this plugin using React and TypeScript, and provide the necessary documentation and test cases. Let me know if you have any questions or need further
I need to create a small HTML file to print offers and discounts, just like the attached one. Title, Price, Product name and logo below. It is to print on a horizontal A4 sheet. I need this in html format.
I have a significant amount of text data from physical documents which I need entered into a database. The ideal candidate will have experience with both data entry and database management. Key Project Requirements: - Data Entry: You will be responsible for accurately transcribing text data from physical documents into a digital format. - Database Management: The entered data needs to be organized correctly in the database. Prior experience in managing databases is essential. Ideal Skills and Experience: - Proficiency in data entry - Strong attention to detail - Experience in database management - Familiarity with data organization techniques I'm looking for someone who can complete this efficiently and accurately.
