Sql database tables jobs

Please Sign Up or Login to see details.

I need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the lines on the Stock data table. I am happy to share the data model as it is only sample data.

Able to follow instruction, can be done in 3 days. CRUD for 3-4 tables only

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I am seeking a detail-oriented freelancer who can expertly transfer text data from PDF files into a database. The ideal candidate should possess the following skills and experience: - Proficiency in working with PDF files - Expertise in data entry tasks - Experience in formatting and structuring databases - Excellent attention to detail Suitable candidates need to handle copious amounts of text data, accurately convert the text-containing PDF files into a structured and organized database. This includes careful validation to ensure no data is lost or misrepresented during the data entry process.

Hi Ashish, this is for the tasks I emailed about.

...tools, etc.). Describe an evaluation plan, including process evaluation. Develop an evaluation tool (types of survey questions) that would be appropriate for this scenario, given the main outcome. You should include other variables of interest and a data analysis plan. State the variable types and specific analyses needed. Using the data provided (see attachment) , create a tables: Table 1 - demographics based on comparison groups, Table 2 - outcome table other associated variables with comparison groups, and Table 3 Analysis - multivariate analysis of your choice and written interpretation of the analysis. Section 2 - Scenario Two Scenario: Based on scenario 1 in this section, you have been asked to detail the epide...

I'm looking for a detail-oriented freelancer to help me with an Excel data entry project. The task primarily involves typing text from scanned documents into my Excel sheet....The task primarily involves typing text from scanned documents into my Excel sheet. **Key Requirements:** - Accurate typing of text from scanned documents into Excel - Organizing the data into tables and lists **Skills Needed:** - Proficient in Microsoft Excel - Attention to detail to ensure accuracy - Experience in data entry, ideally with scanned documents - Ability to organize data into tables and lists The ideal candidate should be comfortable working with scanned documents, have a knack for accuracy and attention to detail in typing, and be able to organize the data effectively into t...

I'm searching urgently for an experienced PHP architect who can const...items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attention and the chosen freelancer needs to be able to commit and delive...

I require some help from 2 people to move some furniture items from Nunawading to Ringwood in Melbourne. I have a van I can get from the storage place I'm moving to but another one wouldn't hurt if you have one. The items to move are: 1. 1 Queen size bed with mattress 2. 2 kid single beds with mattresses 3. A heavy drawer 4. Some side tables 5. A couple of boxes 6. A washer and a dryer. 7. Maybe 1 or 2 other smaller things. Ideal Skills and Experience: The perfect candidate for this job is someone who has is strong and lives in the Melbourne metro and who has another strong mate. The job should take no longer than 2 hours and needs to happen on Tuesday the 23rd of April (next Tuesday) and start anywhere between 10:00am and 3 pm.

I have an urgent web scraping task that needs to be completed as soon as possible. This project involves: - Scraping specified data from a list of instagram accounts. The information includes phone number and email of account and also phone nu...completed as soon as possible. This project involves: - Scraping specified data from a list of instagram accounts. The information includes phone number and email of account and also phone number and email of account tagged in the bio description The ideal freelancer for this job should have: - Proven experience in web scraping - Proficiency in handling different types of data (text, images, tables) - An excellent track record of delivering projects on time. Please apply if you have the expertise and availability to tackle an urgen...

We have a website where the homepage currently loads slowly due to multiple API calls. Despite implementing asynchronous API calls, the page load time is still not meeting our target. We are looking for a skilled developer to optimize the homepage to load within 1 second. we need some one who can : Optimized homepage that loads within 1 second. Cron job implementation for fetching and updating api data of tokens price/5%/24%//etc basically - i want to load data everything from DB only , rather than multiple api calls. thakns

I am looking for...Oracle DBA with experience in both Oracle RAC (Real Application Clusters) and standalone Oracle databases. The primary goal of this project is performance tuning. Ideal Skills and Experience: - Proven experience with Oracle RAC - Proven experience with standalone Oracle databases - Specialization in performance tuning - Familiarity with Oracle Database 19c Key Responsibilities: - Implementing performance tuning strategies - Monitoring and optimizing database performance - Troubleshooting issues related to performance - Ensuring the smooth operation of both RAC and standalone Oracle databases The ideal candidate should have a deep understanding of Oracle databases and be able to provide tailored solutions for enhancing performance on both Oracle RAC and s...

...skilled developer who can build a customized matchmaking database for my internal use. The database will primarily focus on matching investors to investment opportunities. Key Features: - Storing Match Preferences: The database should be able to store various match preferences including minimum/maximum investment, minimum/maximum funding amount, geographical preference, and the type of funding. - User Authentication: As this database will be for internal use only, the user authentication should be secure and limited to specific staff members. No external user authentication is required. - Search Criteria: The database should have search functionality based on the geographic location. Ideal Skills: - Proficiency in database management ...

I have an unfinished Flutter app that requires a skilled individual to handle its database connection. The app is designed and now, I need help connecting it to a MySQL database using an API. Key Responsibilities: - Complete the database connection for my Flutter app - Utilize MySQL to store the following data types: user profiles and authentication, transactional records, content and multimedia files Ideal candidate: - Proficient in Flutter and experienced in developing Flutter apps - Skilled in MySQL and API integration - Familiar with handling user data and transaction records securely - Strong background in data storage and retrieval for content and multimedia files This project is not for a business, but rather a personal venture. Your expertise will help me b...

I'm in need of a talented furniture designer who specializes in Modern style. The project involves creating a range of pieces including chairs, tables, and storage units. Ideal skills and experience for the job include: - Proficiency in furniture design software - A strong portfolio showcasing Modern furniture design - Knowledge of materials such as wood, metal, and upholstery - Understanding of ergonomics and functionality in furniture design - Ability to create designs that are both aesthetically pleasing and practical.

Seeking an expert Access Developer to undertake some key aspects of a large-scale relational database for our office team. Tasks include: - Database Design and Development: Plan and construct a robust relational database incorporating more than 20 tables. - Form Creation and Customization: Create and customize user-friendly forms for data input and manipulation. - Report Generation and Analysis: Design analytical reports that will aid our decision making. Ideal skills: Proficiency in Microsoft Access, understanding of relational database theory and form design, experience with report generation and analysis. Prior experience working on large-scale databases would be a plus. This project offers a challenge but also a great opportunity for you to show...

I'm seeking a proficient individual for constructing an Access database for my project. The principal requirements include: - Experience with Access, as that's the selected database management system. - Expertise in data storage and retrieval is essential. - The database will be storing textual and numerical data. Experience in handling these types of data is crucial. Ideal skills would include an in-depth understanding of Access, database design, data storage/retrieval techniques and knowledge in handling both textual and numerical data. This should make for a streamlined and efficient process. I'm excited for us to kickstart this project together!

Project Title: "Customer Order Management System" for an online retail business in MS Access. Objective: To develop a comprehensive database system that allows for efficient tracking and management of customer orders, inventory, and shipping. Key Features: 1. Customer Management - Store customer information including name, address, email, and phone number. - Track customer order history. - Customer feedback and preferences. 2. Inventory Management - Maintain a detailed list of products, including product ID, name, description, quantity in stock, and reorder levels. - Automated alerts for low stock levels. 3. Order Management - Enable creation of new orders with customer information, order details (product, quantity, price), and shipping method. - Trac...

The database is on the National Environmental Agency's website, and it includes all of the applications submitted for environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate

We would like to hire a freelancer expert in development of Postgres Database and Synchronization of Data from our Headquarter to our Multiple Area Office (10 No.) and to Multiple Local PC (Around 300 Nos.) locations available in Network.

We have attached the details we need to sync our data from Headquarter to Area Office and than to local PCs and back again. for RFID based application.

I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.

• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Selenium Automation Unix Finan...

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industr...users and team members at all levels for performance improvement and suggestions. • Understand and prepare Ad hoc reports. • Identify the opportunities of automating reports, snapshots and dashboards using advanced formulas, Advanced Excel, Python and other techniques • Consolidate, sort, organize and summarize data using basic mathematical operations • Interpret data and metrics using charts, tables, Dashboard and other graphics in Microsof...

...life into a 20-page Microsoft Word document (no need for you to research, I need just your creativity to adjust the document). Here's what I'm after: • Use of custom fonts for a unique look • Development of a color scheme that permeates the document • Designing an interesting yet professional header and footer and unique cover page On top of this, I need someone with proficiency in inserting tables and graphs into the document, making it more interactive and engaging. The attached document will give you an idea about what I am looking for (DON'T make it as same the attachment, just I need something similar to it) Ideal Skills for this project: Microsoft Word, Graphic Design, Typography. Experience in similar projects is a big plus. Unique fonts ...

i have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NOT bid. budget is $35

My WordPress site hosted on AWS is currently down due to a database connection issue. Key requirements: - **Database Connection Issue**: The site is throwing an 'Error establishing a database connection' message. I believe this is related to database connection details in the WordPress configuration file. If you are experienced with AWS and WordPress, this could be a quick fix. - **Backup Restoration**: I have a recent backup of the site. However, I'm not confident about the database connection details in the configuration file. Restoring the backup and ensuring the database connection works correctly is crucial. - **AWS and WordPress Expertise**: Ideal candidates should have experience with both AWS and WordPress. Familiarity wi...

Please Sign Up or Login to see details.

I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantag...

I'm in need of an expert who can fix my corrupted .FIC file in my HFSQL database. Key Project Requirements: - The file is currently not opening and is producing errors, so the main goal is to restore it to its original state and ensure it can be opened without any issues. Please note that I can provide the corrupted .FIC file for analysis. Ideal Skills and Experience: - Proficient in HFSQL database management. - Proven track record in repairing and recovering corrupted database files. - Strong problem-solving skills to identify and rectify the issues within the file. If you're confident in your ability to handle this task efficiently, please provide details of your relevant experience and how you plan to approach this project in your bid.

Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.

...specifying the exact functionalities, the developer should anticipate working on tasks such as: Work on 45 pages, each very simple. There are 3 main page features: 1. View table from DB 2. Create new record in that table 3. Edit record in that table Most the pages are the same, just a different table. A few tables have some other functionality but it's all very easy. All html design has been done already, you just have to add some PHP/MySQL code to make the pages work with the database. You also need to create the DB, table and records. Though most have been created already. You would need to double check them though. I also need the web services to connect the DB to our mobile app. Technical details: Admin Panel ----------------------------- Common Page...

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

...Predictive Analytics functionalities. Key Requirements: - Proven experience in implementing AI features in Power BI is a must. - Strong background in Natural Language Processing, Machine Learning Models, and Predictive Analytics. - Proficient in working with SQL databases and Online APIs for data integration. - Ability to deliver a dashboard with basic filtering and sorting capabilities. Your main tasks will include: - Integrating the AI functionalities into the Power BI project. - Ensuring seamless communication between Power BI and the SQL databases, Online APIs. - Implementing a user-friendly interface with basic filtering and sorting options. If you are confident in your Power BI and AI skills, and have the technical expertise to deliver such a project, I would love...

...side hustle. We'll be building something together that has the potential to change the game in the finance world. What I'm Looking For: Someone who's passionate about building scalable applications. Experience with backend development, RESTful APIs, and microservices. Familiarity with database management (SQL/NOSQL) and cloud services. A creative problem solver with a knack for turning ideas into reality. What You'll Do: Set up the backend architecture. Implement core and advance functionalities. Database Management Monitoring and Performance Optimization and much more If you're up for the challenge and want to be part of something special, let's chat! Drop me a message with your experience and let's see if we're a match...

I need a database for the UK market, with a focus on company names and Email ID. Key Points: - The project primarily involves creating a comprehensive database for the UK market - The main data points to be included are company names and Email ID's - Information can be extracted from Yellow Pages, Business Pages, Associations, Business Chambers and similar. - Accuracy of data, specially Emails - Sample File of Required database is attached - To start with we require 10,000 records. - Will pay INR 0.60 per record. Ideal Freelancer: - Prior experience in creating detailed databases - Proficiency in data gathering, scraping and organization - Familiarity with the UK market would be a plus Please include your relevant experience in your application.

...JavaScript, and PL-SQL, as well as familiar with Oracle Database, PL-SQL Developer, Oracle SQL Developer, Eclipse. The project involves writing comprehensive tests for a range of technologies including: - Java and JavaScript. - Spring Framework. - Oracle Database. - XML and JSON. - Junit. - Eclipse/Intellij. - PL-SQL Developer. - Utilizing Github and other version control tools. The ideal candidate must have a deep understanding and practical experience with these technologies. The project has an urgent timeline, so the selected candidate must be able to work under pressure and deliver high-quality results quickly. Ideal Skills: - Proficient in Java, Spring Framework, Oracle, XML, JSON, Junit, and JavaScript. - Experienced with Eclipse/Intel...

...metrics like age, experience, tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-to-date and accurately represented. Ideal freelancer should have: - Proven experience in HR analytics and dashboards - Excellent Excel skills - Ability to present complex data in a clear and concise manner...

...need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accurately. - Experience with design: To create visually appealing tables usin...

I am seeking an experienced and competent furniture designer and engineer with whom we can collaborate with to assist us in the design and development of an extensive range of high-end, multifunctional furniture products. This project includes the design and engineering of various types of luxury beds, sofas, chairs, tables, dressers, cabinets and more. We deal in furniture of all types and styles; Italian, European, modern, contemporary, futuristic, and multifunction (everything furniture). The designer should incorporate very detailed features in each design such as ; material quality, comfort, solid structural build (inner/outer), ergonomics, convertibility, functionality (electric recline, components, wiring, mechanical/mechanism placement and operations). The furniture wi...

I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.

I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completion. I need this help ...

I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!

Project Title: Adalo Database Setup for Real Estate Mobile App Project Description: We are seeking an experienced database developer with proficiency in Adalo to complete the database setup for our mobile real estate application. The app’s interface design is complete, and we now require expertise in backend development to ensure that the data structures are optimized for performance, scalability, and future maintenance. *Please provide Adalo sample apps for reference* Current Status: Interface design with all the user-facing screens is completed. The app is designed to facilitate real estate transactions and interactions between buyers, sellers, and real estate agents. Screens for sign-up, log-in, property listings, filters, property details, chat functional...

I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work wit...

I am searching for an experienced app developer who excels in designing and implementing Android-based applications. The main functionality required for this task is the creation of a comprehensive employee database system. Key Functionalities: • Instant tracking of employees' online and offline status • Storing and displaying contact details of each employee • Categorizing employees based on their department The developer should have a strong understanding of database structuring and management for Android systems and a proven track record of delivering similar projects. Familiarity with real-time data sync and user-friendly UI design are also desirable.

I need assistance in compiling a large, extensive database of more than 5,000 working professionals earning a salary under 3 lakhs per annum. The data profile will include: - Name and contact details - Education and qualifications - Current job title and company Interestingly, these professionals should spread across various industry sectors such as Technology and IT, Healthcare and Medicine, as well as Marketing and Advertising. Particular skills and experience that would set freelancers apart for this job include: - Proven experience in data mining and data scraping - Familiarity with the mentioned industry sectors - Ability to accurately cross-reference and verify data - Excellent attention to detail Freelancers with extensive experience in maintaining data integrity and c...

I'm in need of someone with the expertise, resourcefulness and knowledge to draw up an email lead list from public domain databases. The focus of this project is identifying professionals, specifically those with active websites for contact. Key requirements: - Extraction of email leads from public domain databases - Target demographic: Professionals of various walks with active websites - Experience with large-scale data extraction - Proficiency in managing information databases Your past work in email lead generation will be beneficial for the successful completion of this project. Your ability to provide clean, organized, and verified email lists will also be very important. Please only bid if you have the experience and know-how to deliver on the stipulated requirements.

I am in need of a competent data engineer for a small-scale data analysis task. - The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience wi...The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience with data engineering will be a significant advantage. Your role will mainly involve performing data analysis tasks, so a deep understanding of data engineering and analysis is essential for this project. A strong background in Python, R, or SQL is highly preferred, though not mandatory. Please note that the project timeline is quite flexible, so you will have ample time to complete ...