Write sql statement database jobs
I'm seeking a skilled database developer to help me successfully migrate my database from .NET Framework 4.8 + EF6 + AspNet Identity to .NET 6 + EF Core + Identity. The database size is small - less than 1 GB, but it's crucial that user data is meticulously preserved during this transition. Key Tasks: - Perform data migration without any data loss. - Ensure the user login system and roles functions seamlessly in the new system. Ideal candidate should have: - Proven experience in .NET Core and EF Core migrations. - Strong attention to detail, particularly regarding user data. - Proficiency with user login systems in a .NET environment. Attached is the project source.
...this project should have proven experience in time series forecasting, Python programming, and developing interactive dashboards. A solid grasp of data visualization principles would be a plus. The output should be in a form of a python file with 4 models above and related dynamic visualizations. The text preprocessing is required and can be done in any necessary technologies (HADOOP/SPARK,NOSQL/SQL databases) - screenshots of the bash code are required....
I'm searching for an expert in Visual Studio 2022, MS SQL, and VB.net, for the main objective of maintaining and updating an existing software application. Key tasks: - Primarily, the project will involve optimizing the application's performance. Skills and experience: - Experience with Visual Studio 2022, MS SQL, and VB.net is a must. - Proven expertise in software optimization. - Knowledge of system maintenance and updating.
I am in need of an experienced professional who can work hand in hand with me in exporting my old MySQL database into my new Node.js website. There are a few discrepancies in column names that need attention, so attention to detail is crucial. This is a personal project, and the chosen freelancer should be comfortable providing remote assistance through anydesk, and maintaining open communication over a call throughout the duration of the task. I will personally guide you through the necessary steps and the specific level of accessibility that should be set for the new database. Ideal skills and experience: - Solid understanding of MySQL - Experience in Node.js website development - Exceptional problem-solving abilities - Excellent communication skills - Ability to follow...
I have a 500MB XML file that I need loaded into SQL across approximately 20 tables. I'm in need of a Python script to handle the transformation. The script will need to handle normalization of the data. Key requirements: - Develop a Python script to read the XML file and transform the data into a normalized structure across 20 tables. - You will need to create the SQL tables as part of the normalization process. - Experience with large data transformations and SQL is vital.
Looking for a proficient researcher to provide comprehensive research services e.g., market trends, competitive analysis, industry insights. The ideal candidate will have a knack for gathering and an...and the capability to present findings in a clear and concise manner are essential. If you have a proven track record in delivering high-quality research, we'd love to hear from you! Requirement; 1. Filled Verification form with Sign and Stamp along with verifier details. 2. 5-6 geotagged photos in which name board of Issuing Authority is visible. 3. In-case of refusal, I need written refusal statement with Sign and Stamp along with detail of person i.e. name, designation, email and phone number. Please get in touch with me with your relevant experience and how you can help wit...
I'm seeking a skilled .Net developer to assist in developing a comprehensive retail system that has features such as user authentication and authorization, inventory and product management. Requirements: - Proficiency in C#, .Net, Entity Framework and SQL Server - Ability to develop a retail project from scratch - Strong understanding of user authentication and authorization - Experience in inventory management and product cataloging It's crucial that the chosen freelancer has prior experience in building online retail systems and a strong understanding of the retail business model. The ideal candidate should be able to deliver a secure, efficient and scalable retail project. Any experience with Angular/react/Node would be plus
I'm looking for a skilled software engineer. THi...task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements...
I am seeking a...Accounts Receivable, and Inventory modules. Key Responsibilities: - Reviewing and assessing the accuracy of data in the General Ledger, Accounts Payable, Accounts Receivable, and Inventory modules. - Ensuring the completeness of financial data in the system. - Conducting data reconciliation to identify any discrepancies. - Producing detailed findings on the Balance Sheet, Income Statement, and Cash flow statement. Ideal Skills and Experience: - Proven track record in financial auditing, particularly within ERP systems. - Strong understanding of financial reporting and reconciliation. - Experience with Odoo ERP would be advantageous but not essential. - Excellent attention to detail and analytical skills. - Ability to communicate audit findings in a clear an...
Looking for a proficient researcher to provide comprehensive research services e.g., market trends, competitive analysis, industry insights. The ideal candidate will have a knack for gathering and analyzin...and the capability to present findings in a clear and concise manner are essential. If you have a proven track record in delivering high-quality research, we'd love to hear from you! Requirement; 1. Filled Verification form with Sign and Stamp along with verifier details. 2. 5-6 geotagged photos in which name board of Issuing Authority is visible. 3. In-case of refusal, I need written refusal statement with Sign and Stamp along with detail of person i.e. name, designation, email and phone number. Previous experience in market, competitive or consumer research would also b...
We're on the lookout for skilled animators adept at infusing life into our milkbag persona through captivating and witty Instagram Reels and animated content. Our ideal candidate possesses a solid grasp of an...to grasp the style and caliber of content we're aiming for. We aspire to achieve a similar level of ingenuity and amusement in our mascot character Instagram Reels. How to Apply: If you're passionate about animation and possess a talent for crafting entertaining Instagram Reels and understand cryptocurrencies and trading we're eager to hear from you! Please include your portfolio and a brief statement outlining why you'd excel in this role in your application. Additionally, feel free to share any relevant experience or ideas on bringing our mascot c...
I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.
I need a series of marketing materials designed for my company. We already have an established logo and brand guidelines. The design style we're aiming for is modern. The specific materials we need are: - Business card design - Email signature - LinkedIn banner image - Pull-out poster design - Letterhead - Editable company capability statement (in .docx format) The final deliverables should be in JPEG format and the company capability statement should be in .docx. Ideal skills and experience for this job: - Proficiency in Adobe Creative Suite - Strong understanding of modern design principles - Experience in creating a variety of marketing materials - Ability to follow established brand guidelines - Strong communication skills to ensure the final designs meet our nee...
...Whereby; candidates can create a profile upload their CV, images or link to images and videos recruiters can search CVs with a Boolean type search functionality & save searches. Candidates and recruiters can message each other. Admin can manage the back end. Suggested technical skill set but not a complete one… • Cloud-based server solution • Azure or Single server solution • MS SQL Database (NoSQL document database might be more appropriate?) • OAuth • Payment gateway • .net We suggest design led development process where we sign off the look and feel of the web pages… the back end is for the supplier to advise the best scalable solution for the application. Please send your credentials/ skill sets and cost struc...
...managing user profiles, cataloguing orders, generating recommendations, and facilitating payment systems. 1. Implement a QR code as the entry point for users to access WhatsApp chat. 2. Utilize WhatsApp APIs to initiate chat sessions. 3. Employ Language Model (LM) capable of Hindi, English, and Hinglish for conversational interactions. 4. Integrate LM with backend logic for CRUD operations on a DB (SQL/NoSQL). 5. Store restaurant data including name, menu, pricing, and location details. 6. Capture user profile data such as name, preferences, allergies, and delivery addresses. 7. Manage user records and orders in the backend. 8. Prompt new users to provide necessary details. 9. Facilitate dish selection based on user preferences. 10. Display sorted dish options in sets of four ...
I am looking for a professional who could potentially help me create accountant Databases. Prefer for recent ready database. Ideal skills and experience: • Data entry • Report generation • Customizable fields Contact urgent.
It is basically an app that helps the sales see the account profile data that is attached. We already have the designs ready, workflow will be decided in collaboration with the freelancer. Expertise required is app development and not design
Description: I am looking for an expert in SQL and R programming for a detailed data analysis project. This project involves extracting, analyzing, and reporting on data from a sophisticated relational database setup. The ideal candidate should have a solid background in data science, with specific skills in SQL and R. Responsibilities: Efficiently query and manage data using SQL from a SQLite3 database. Apply R programming techniques for advanced data cleaning, analysis, and visualization tasks. Ensure data integrity and optimize data processing workflows. Analyze results to derive actionable insights and compile detailed reports. Document all processes and code in a clear and comprehensive manner. Requirements: Profound knowledge of SQL with ...
...- Contractor: Faisal and his team. - Client: Wayne Problem statement: The Web application is not compiling properly i.e. it’s throwing errors when compiling on local machine using the code from Bitbucket (master branch). Contractors anticipated tasks: 1. Identify the cause of the compilation errors on local machine, 2. Fix the errors so that code compiles on local environment without errors and displays the website as in production. Deliverables: 1. Demo showing the compilation and execution of project on development environment from contractors end via screen share. 2. Document with step-by-step guide of how to fix the errors and compile code on local machine without errors. (This does not include connection to the database) Timeframe and payment structure: ...
Our company develops both desktop and web applications tailored for analysing insurance premiums. These have been developed in Delphi over the past 25 years. We are seeking to establish a long term relationship with an experienced Delphi programmer with exposure to Microsoft SQL databases. ASP.net application experience is also desirable. Our software packages require continued upgrading and enhancement and given the specialist nature of our software we are seeking to establish a long term relationship. The primary requirements include understanding our business process and system design, determining and articulating technical solutions, and implementing the design into build and install stages. Australian based is preferred, our principal office is based in Sydney NSW. If you...
I'm in need of a seasoned developer who can design a dynamic, responsive, and custom database synchronization system. Key Requirements: - Custom Data Mappings: The system should allow the designation of unique data mappings for seamless sync across various platforms. - Conditional Sync: The system should support conditional sync to ensure only relevant data is shared. - Automation: The synchronization process should be automated to reduce manual intervention and enhance efficiency. Platforms and Websites: The system should sync data with: - Social media platforms - Mobile devices Ideal Freelancer: - Proficient in database synchronization and mapping - Experienced with integration across websites and devices - Capable of designing automation processes - Knowledgeable ...
Follow directions in video. Maidstone and Unity - Janessa and Kenzie Turtleford/Shellbrook/North Battleford - Juan David and Eduardo Meadow Lake - Cody/Tristan
I'm looking for an experienced .NET developer to assist with a project. This project requires someone who has a strong background in .NET technology, particularly in C# programming, ASP.NET development, and SQL database management. Ideal candidates should have experience in developing web applications, creating software solutions, and improving existing systems. The key functionalities to be implemented by the .NET developer in this project include user authentication, data encryption, and payment integration. If you're a .NET developer with a solid understanding of the above technologies and functionalities, please reach out to discuss the project further.
...in need of an hacker to perform a thorough black-box penetration testing on my WordPress website. Key Responsibilities Include: - Testing the security from an outsider's perspective. - Identifying and using hacking techniques including SQL injections, cross-site scripting attacks, and brute force attacks to hack website as outsider so that we can plug the vulnerability. Ideal candidates should have: - Proven experience in website vulnerability testing. - A strong understanding of WordPress. - Exceptional problem-solving skills. - In-depth knowledge of SQL injections, cross-site scripting attacks, and brute force attacks. My objective is to ensure my website's robust security, and your expertise can help me to achieve this. Your keen eye and tech skills are ...
I'm looking for a talented financial writer with a keen eye for detail, capable of creating 1 to 10 demo bank statements specifically for a business account. - Required Format: The bank statements need to be in PDF format. - Account Type: The statements should reflect transactional activity for a business account. Ideal skills include: - Familiarity with financial statement preparation - Proficient in PDF generation - Previous experience creating bank statements or similar financial documents. By the end of this project, I expect professionally drawn-up bank statements that mimic authentic business transaction flows. Apply if you're well-versed in financial terminologies and possess excellent writing standards. Must include account numbers to be provided for the mont...
...wellness, or self-help niches 3) Engaging Storyteller: Skill in weaving anecdotes and personal stories with factual information to keep the reader motivated and engaged 4) Sensitivity to Tone: Capacity to maintain a supportive and positive tone that encourages lifestyle changes without judgment 5) Proficiency in English: Must have excellent command of the English language, with the ability to write clear, concise, and grammatically correct content. Additional Considerations: 1) Experience with or knowledge of the Blue Zones and longevity research is highly preferred 2) Ability to work collaboratively with the author to ensure the book’s voice and style align with their vision 3) Flexibility to incorporate feedback and make revisions as necessary during the writing pr...
...goal is to automate daily updates of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your approach to...
...professional who can smoothly transition my old database into the new one for my website. There are some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive experience in MySQL, data merging, and database...
I am seeking a...Accounts Receivable, and Inventory modules. Key Responsibilities: - Reviewing and assessing the accuracy of data in the General Ledger, Accounts Payable, Accounts Receivable, and Inventory modules. - Ensuring the completeness of financial data in the system. - Conducting data reconciliation to identify any discrepancies. - Producing detailed findings on the Balance Sheet, Income Statement, and Cash flow statement. Ideal Skills and Experience: - Proven track record in financial auditing, particularly within ERP systems. - Strong understanding of financial reporting and reconciliation. - Experience with Odoo ERP would be advantageous but not essential. - Excellent attention to detail and analytical skills. - Ability to communicate audit findings in a clear an...
...relational database design. The primary goal is to deepen my understanding and skills in E-R modeling, functional dependency theories, and database norms, particularly: * Identifying entities and relationships * Applying E-R modeling and normal forms for a well-designed relational database. The chosen candidate should be proficient in the aforementioned areas, plus have the capability to clarify how to use these skills to identify performance issues, validate data integrity, and evaluate scalability. The project scope encompasses E-R modeling, identifying entities and relationships, and applying normal forms. Ideal Skills: * Advanced knowledge in RDBMS * Proficiency in E-R modeling * Understanding of functional dependency theories * Experience in applying normal...
Looking for a skilled developer to fill in for a team member on vacation. The ideal candidate should have: - Strong experience in C# and ASP.net - Good knowledge of SQL Server The role involves: - Troubleshooting and fixing bugs in our existing applications - Enhancing and adding new features to our applications The projected timeframe for this position is less than a month, but the role could potentially be extended. You're being hired for not only your skills but also your problem-solving abilities - an essential trait when dealing with application bugs/issues. The key objectives for this role are: - Improving the performance and stability of our applications - Enhancing the user experience and application functionality Note: We skipped the outcome due to the job's shor...
I am seeking a PHP developer who is experienced in frontend development, and an expert in PHP frameworks and MySQL database integration. The focal point of the project is database management. • Main responsibility of the PHP developer will be to build new databases, thus experience in this is essential. • A background working with PHP frameworks and MySQL is crucial for success in this role. • The role also entails some front-end development tasks. Successful applicants will illustrate these skills throughout their portfolio in relation to past projects. If you are a self-starter with a penchant for database management, I look forward to receiving your bid.
I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.
I'm currently facing potential malware attacks causing unexpected slowdowns, particularly affecting my website load times. Hence, I'm i...security professional who can identify and rectify issues within my server files. Key Responsibilities: - Investigate the root cause for the slowdown of the website load times - Pinpoint potential malware in server files - Advance and fortify the security system to prevent future occurrences Ideal Skills: - Proficiency in cybersecurity - Solid understanding of server operations, particularly SQL - Experience in malware detection and prevention Your task: Use your expertise to bring back operational efficiency and bolster my domains server's security. If you can catch the malware predator and restore the peace of my server wor...
...areas: database design and query optimization. Key Responsibilities: - Database Design: I'm looking for assistance in designing the database to ensure it's well-structured and optimized for performance. - Query Optimization: I need an expert who can help in fine-tuning our queries to ensure they're efficient and have minimal impact on our database. Key Skills and Experience: - Proven experience in MongoDB database design and query optimization, especially for small datasets (less than 1 GB). - Solid understanding of indexing strategies and their role in improving query performance. - Ability to communicate effectively and work collaboratively to understand our specific needs and tailor solutions accordingly. - Familiarity with perfor...
I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table. Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.
I need a skilled graphics designer to create a vibrant, bold portfolio for my software startup. Mandatory Inclusion: - Diverse sections: Home/Introduction, Services, Portfolio/Projects, About Us, Contact, Case Studies, and Clientele. - Key elements: Previous projects and cases studies, my startup's mission statement and company values. Preferrable Skills: - Strong, bold and vibrant design proficiency. - Prior experience in creating tech startup portfolios. - Good understanding of software startups, able to highlight our services and expertise in a persuasive manner. Your creativity will make our services and prowess stand out in a saturated market.
...continuously improve our data solutions Key Skills :- • Bachelor's degree in Computer Science, Information Technology, or related field. • 4-5 years of professional experience as a Data Engineer with a focus on Azure Databricks and Azure Data Factory. • Strong proficiency in SQL, Python, and/or Scala for data manipulation and scripting tasks. • Experience working with data lakes, data warehouses, and ETL processes. • Familiarity with cloud platforms (preferably Azure) and related services such as Azure Blob Storage, Azure SQL Database, etc. • Excellent problem-solving skills and attention to detail. • Effective communication and collaboration skills to work with cross-functional teams. • Azure certifications (e.g., Mic...
need seo experts/developer to fix google search console/SQL index issue. we have many pages not indexed on gsc, need seo experts/developer to fix it. I'm currently facing an issue with pages on my website not being indexed and therefore not showing in Google's SEO results. It's crucial for the successful completion of this project to have these pages visible on Google again. Ideal candidates for this task should have: * Extensive experience with Google Search Console * Proven expertise in resolving indexing issues * A deep understanding of SEO best practices Please include your past work related to resolving such issues in your application. A detailed project proposal would certainly be a plus. Prompt completion is advantageous, although a precise timeline has...
I'm looking for an...Fibonacci levels in TradingView. The script should: Track the short high using a 100-bar lookback period. Determine the short low from the lowest low after the most recent highest high. Track the long high/low based on the selected date range. Include customizable options for line colors, widths, and visibility. Draw Fibonacci levels between long highs and lows. An error occurs with the if statement, and I need help to fix it and ensure the script works correctly without syntax issues. If you're experienced with TradingView's Pine Script and can resolve this error while maintaining the intended functionality, I'd like to hear from you. Please respond with examples of your previous Pine Script work or any relevant experience in creating or ...
...skilled and creative professional who can craft a top-notch company profile for us, that will serve a triple purpose: attracting potential clients, showcasing our expertise, and providing detailed information about our products and services. The profile will be primarily used to target potential clients and investors. Key elements to be included: - Strongly worded, engaging mission and vision statement - Compelling success stories and testimonials Ideal candidates for this project should be able to: - Demonstrate prior experience in creating engaging and effective company profiles - Have a good understanding of how to cater to both clients and investors through the same document - Possess excellent storytelling and copywriting skills - Show attention to detail, particularly ...
I am in need of an experienced accounting professional who can assist me with the comprehensive analysis of my business's financial statements. Key Requirements: - Expertise in financial statement analysis - Proficiency in analyzing balance sheets and cash flow statements Ideal Skills and Experience: - Proven track record in conducting intricate financial analyses - Strong grasp of accounting principles and best practices - Background in [industry specific experience, if you have any] could be beneficial, but not mandatory. - Familiarity with [specific accounting software, if needed] I have attached sample sheet. My required company is NESTLE.
I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing
I'm in need of a skilled developer with expertise in Yii framework to add new functionality to our existing system that serves a financial services purpose. The successful candidate will be responsible for implementing the following features: - Add menu new menu items using the language file - Bank statement mapping - Bank statement import - Bank statement transaction allocation A full specification is available for the selected candidate. Ideal skills and experience for this job include: - Proficiency in Yii framework - Strong PHP skills I look forward to your proposal for this project.
I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing
Looking for a proficient researcher to provide comprehensive research services e.g., market trends, competitive analysis, industry insights. The ideal candidate will have a knack for gathering and analyzing data, att...and the capability to present findings in a clear and concise manner are essential. If you have a proven track record in delivering high-quality research, we'd love to hear from you! Requirement; 1. Filled Verification form with Sign and Stamp along with verifier details. 2. 5-6 geotagged photos in which name board of Issuing Authority is visible. 3. In-case of refusal, I need written refusal statement with Sign and Stamp along with detail of person i.e. name, designation, email and phone number. Please bid only if you're located in Pasadena, CA or its imm...
I'm in need of a comprehensive business owner database specifically in Tamilnadu, Chennai. The database should include detailed information of business owners Contact number, Email ID from various industries like GST Filling Database, Distributors, Industries, Dealership and more
I need a fast turnaround to correct error messages in my PHP code and database. The main goal of my PHP application is to upload content to the database and ensure the site displays it correctly. Key Responsibilities: - Fixing error messages in PHP code - Addressing database issues - Ensuring smooth content uploading functionality - Ensuring the site can retrieve and display content from the database Ideal Skills and Experience: - Proficient in PHP - Strong understanding of database management - Prior experience in troubleshooting and fixing error messages - Ability to work fast and deliver under tight deadlines.
I'm looking for a task-oriented individual who can assist me with saving documents from an online database. Your assignment would primarily revolve around focusing on documents and seamlessly saving them off. Key responsibilities: - Download documents with my full permissions. - Make sure that all downloaded files are in audio file format and labelled correctly. The ideal candidate will have: - Relevant experience and proficiency in saving files to dropbox. - Excellent attention to detail ensuring the correct files are stored. May be 1-2 days of work.
