Link database sql jobs
I am seeking a professional with proficiency in MS SQL Server’s SSIS (Integration Services), SSAS (Analysis Services), and SSRS (Reporting Services) to create a basic level, sample case for using data warehousing. Specific Goals: - Develop a data warehouse for analyzing business data. - The case should familiarize the users with the concept, rather than providing an advanced level of expertise. In SSIS Integration section, the following concepts are to be included: - Data Extraction - Data Transformation - Data Loading The ideal candidate will have a solid understanding of data warehousing and extensive experience with MS SQL Server’s services. A knack for simplifying complex information and a background in training or education will be appreciated.
...specialty in MySQL databases to help me with optimizing query speeds. This personal project requires proficiency in both SQL database handling and WordPress development. Key responsibilities: - Analyzing my WordPress site's interaction with the MySQL database. - Tweaking and fine-tuning to enhance query speeds. - Testing and confirming the increase in performance. Skills and Experience: - Detailed knowledge of MySQL databases. - Extensive experience with WordPress development and optimization. - Proficiency in writing efficient SQL queries. - Ability to diagnose and optimize databases for better speed performance. This project offers the opportunity to showcase your skills in SQL optimization, while significantly improving the speed and usabili...
...proficient understanding of SQL databases to help resolve an issue that's negatively affecting my website's performance. The problem is specific to the updating of posts; every time an update is made it takes exceedingly long, undermining efficiency and productivity. We've identified that it's related to wordpress WPML plugin's SQL queries. To solve this issue, I'm specifically looking for a professional who can optimize our database. Familiarity and experience with the WPML plugin is a must. Additionally, we've made several modifications to our database structure and queries which include tables, SQL, and indexes modifications. Skills Required: - WordPress development - SQL database optimization - Ex...
I'm looking for a Python expert with solid experience in SQL to complete an assignment for me. This project requires: - Thorough understanding of Python - Strong skills in SQL - Ability to focus on details and meet deadlines I'm trying to connect to a database but it's not connecting to my users. My code isn't getting any errors tho Your task will be to apply your Python and SQL knowledge to complete specific tasks provided in the assignment. Eagerness to share ideas and take project direction positively will be ideal. Your experience in Python and SQL will be a deciding factor. I am looking forward to seeing your smart solutions and getting the assignment done to my satisfaction.
I need an experienced database developer to create a highly functional Access database. Required functionality: - Robust data entry and retrieval system - Capable of generating custom reports and analyses - Seamlessly integrated with other software The database will store: - Customer information - Product inventory - Sales transactions Expectations: - Development of significantly more than 10 tables - Efficient organizing and handling of these tables The ideal candidate should possess significant experience working on Access Database creation, be able to confidently handle extensive data and complex systems integration. Expertise in table management and data analysis would be an added benefit.
I need a proficient Apache Airflow and SQL consultant to provide expert-level support, specifically focused on complex query formation. - Specific Project Tasks - Implementing Apache Airflow - Creating complex SQL queries - Handling financial transaction data The ideal collaborator should have: - Proven experience working with Apache Airflow - Proficient in SQL, with an emphasis on generating complex queries - Prior experience managing financial transaction data is highly desirable. The objective is to streamline the handling, management, and processing of large volumes of financial transaction data, ensuring efficient and accurate results.
We are a small hobby website looking to redesign both our site and the database structure behind it. The site consists of a database with blog content and a user sign-in system. We currently use a proprietary CMS with SQLite3, but would prefer to rebuild the database in MySQL or something more modern to add more features. We'd also prefer to migrate the CMS to WordPress.
I am in need of a comprehensive school examination system. - The system should cater to three primary user groups: students, teachers, and administrators. It's crucial that the system is user-friendly for all these categories. - Key features should include online examination capabilities, a question bank, and an automated grading system. To apply for this project, kindly include your past work in similar systems. Your previous experience in this area will be a significant asset. Thank you
I'm looking for an experienced crawler specialist to help me crawl databases, and specifically collect certain datasets. Key Project Requirements: - Crawler Type: T...specialist to help me crawl databases, and specifically collect certain datasets. Key Project Requirements: - Crawler Type: The focus for this project will be on databases, not websites or APIs. - Objective: The primary goal is to extract specific datasets from these databases. - Data Format: The extracted data should be delivered in CSV format. Ideal Skills and Experience: - Proficiency in database crawling and data extraction is a must. - Previous experience in collecting specific datasets from databases is highly preferred. - Familiarity with working with CSV data format. Please share relevant experienc...
...behind this modification is to heighten our security measures against web threats and ensure robust protection of our sensitive data from unauthorized access. While we're not currently aware of any explicit vulnerabilities or security issues, we're proactive in our efforts to ward off potential threats. You'd be expected to deliver the following functionalities with the WAF: - Protection against SQL injection - Prevention of Cross-Site Scripting (XSS) attacks - Blocking zero-day exploits Ideal candidates should have significant experience in network and web security, a strong working knowledge of Citrix Gateway, and fundamental understanding of industry regulations. Prior expertise with WAF enabling will be greatly valued.
I'm in need of a skilled SQL developer to assist with the creation of 2 stored procedures in MySQL. These procedures are essential for managing calibration data in our system and compare new data with the calibration data. Key Objectives: - Develop a stored procedure to generate a calibration table (avg + stdev) - Implement another procedure for creating a score table, which will be linked to the calibration data Calibration Table Requirements: - The calibration table should include the following columns: ID, Value, CalibratedValue, StandardDeviation. These columns are critical for our system's calibration functionality. Score Table - This table will check the difference from new data to calibration data Ideal Candidate: - Proficient in MySQL and SQL programmin...
...dashboard needs to determine the shipment location based on the stock availability. If an item is not in stock at either of our regional warehouses (Belmont and Richmond), the order should be fulfilled from our India warehouse. Ideal Candidate: - Proficient in Power BI: You should have a solid understanding of Power BI and previous experience in creating live dashboards. - Skilled in SQL: Knowledge of SQL is crucial for working with our MySQL databases. - Experience with inventory management: Any background in inventory management systems or similar projects would be beneficial. - Able to work under tight deadlines: The project has an ASAP timeline, so the ability to deliver promptly is essential. If you're confident in your ability to deliver this project effi...
...accuracy. You can expect to interact with an SQL database for fetching and storing research documents. Ideal skills for the job: • Expertise in programming with C# and .Net • Experience working with SQL databases • Familiarity with blockchain technology • Knowledge in document analysis and parsing Encouraged but not required: prior experience in developing similar plagiarism detection systems. Your primary task: • Create a reliable system to analyze and flag duplicate content in research papers from the entire text, not just specific sections. • Ensure the system efficiently interacts with an SQL database for the save and retrieve process. Achieving these goals will play a crucial part in preserving the integrity o...
I'm in need of a PHP developer who can create a MySQL database from a small CSV file with less than 1000 rows of data. The structure of the new database should replicate that of the CSV file. Rest assured, the file contains no sensitive information. Key skills needed for this job include PHP, SQL, and database design. The successful freelancer will have experience with both CSV file manipulation and MySQL database creation. Client uploads av csv file, then open a website, then, automatic creation of mysql database on a button click First row in csv file is the column names Table name should be the csv file name truncated to the last 16 numbers in the csv file. UTF-8 Varchar 255 PHP 8.3 running
I'm looking to improve the search engine rankings of my E-commerce website. The primary goal is to enhance our online ...Use the most effective organic SEO strategies to drive more natural traffic to our website. - Improve keyword rankings: Research and implement the best keywords for our Ecommerce site to stand out in search engine results. - Boost backlinks number: Generate quality backlinks that can help to improve our site's authority and reputation. Ideally, you should have a proven track record in SEO and link building, specifically within the E-commerce industry. Experience in increasing organic traffic, improving keyword rankings, and growing the number of backlinks is vital. Your proposals should demonstrate your experience and proposed strategies to achieve the...
I have an urgent issue in my Laravel project. The problem is related to database connection, and it's causing the application to malfunction. Key Requirements: - Quick Fix: This is a high priority task. I need this issue resolved within 24 hours. - Laravel Expertise: You must have extensive experience with Laravel, particularly in resolving database connection issues. - Troubleshooting Skills: The ability to quickly identify the root cause of the issue and implement a fix is critical. Please note that I haven't provided any existing documentation or error logs. As such, you'll need to rely on your expertise and debugging skills to resolve the problem.
...Integrate SAP B1 with other third-party applications using APIs, web services, and middleware. Design and develop custom modules, add-ons, and extensions using .NET programming languages such as C# or VB.NET. Create and maintain SQL queries, stored procedures, and database objects to support SAP B1 data management and reporting requirements. Collaborate with functional consultants and business analysts to gather requirements, design technical solutions, and implement enhancements. Develop and maintain reports, dashboards, and analytics using SAP Crystal Reports, SQL Server Reporting Services (SSRS), or other reporting tools. Perform data migration, data integration, and data synchronization tasks between SAP B1 and other systems. Provide technical support, troublesh...
...entry. The job involves entering numerical data into an existing database system, and creating a comprehensive database from it. Key Responsibilities: - Entering numerical data into the database - Ensuring the accuracy and completeness of entries - Cleaning up any errors or inconsistencies within the data - Creating a systematic database for easy reference and use Ideal Skills and Experience: - Proficiency in data entry with a focus on numerical data - Experience with handling databases, particularly in creation of new databases - Attention to detail and persistence in data accuracy - Ability to work with digital formats like Excel or CSV files The data entry will require a meticulous approach to ensure that the database is error-free and can be ef...
I need an experienced developer to collaborate with to design and develop a secure and scalable ASP.NET Core/SQL Server based application that will tightly integrate the client's custom legacy systems to Microsoft Dynamics 365 Business Central (APIs). Key responsibilities would include: - Developing the required application using ASP.NET Core (Blazor) - Integrate data from custom applications to Microsoft Dynamics 365 Business Central using APIs The following skills are essential: - ASP.NET Core - Microsoft Blazor (preferred, but the candidate can propose any - MVC/Angular, etc) - SQL Server - Entity Framework Core/Dapper - Microsoft Blazor Fluent UI Components (preferred, but candidate may suggest other) The timeline for completion is 1 month. Please outline your exp...
I have C# MVC Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Error message appear with no details, need to make the error message has Show More to display the details of the error. 2- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 3- Packages Load from APIs instead of loading from DB (2 APIs) 4- SubscribedPackages Call API instead of inserting into a DB (1 API) 5- Schemes Load from APIs instead of loading from DB (1 API) 6- Uploads Call API instead of inserting into a DB (1 API) 7- Users Call API instead of inserting and reading from a DB (5 APIs) you must have C# MVC experience. -------...
...! I'm searching for a competent Strapy developer to assist with issues concerning the extraction of data from an internal database. The project involves implementing responsive design and user authentication. Your role's priorities include: - Assuring efficient extraction of data from our internal database, solving the current difficulties we're experiencing. - Skillfully integrating our internal database with the Strapy development project. - Implementing responsive design that works seamlessly across different platforms. - Setting up a dependable user authentication method. Ideal skills for this role include Strapy development, extensive understanding of database systems, proficiency in implementing responsive design, and ability with sett...
I'm in need of a proficient freelancer to create an ecommerce website for selling physical goods, with important features included. Key website features: - Product search functionality - Shopping cart integration - Customer review section Ideal skills include proficiency in PHP, domain management, website development, ecommerce systems, and SQL. A keen understanding of online consumer behavior and shopping patterns will be beneficial. Your experience in creating user-friendly, engaging ecommerce websites will be critical to this project. oscommerce i whant i have domain and webhostsing but will have websides on my pc just use remote destop Norwegian languare and an template on oscommece, ( i can put in new mods
I am student and my course project is a tourists application I have designed the interfaces but I need someone to code them in c# language and connect them to the database through Visual Studio. The following are the key aspects of the project that need to be delivered: - Mobile Interfaces: code the mobile interfaces using C#. - Database Connection: The interfaces should be seamlessly connected to a SQLite database. This involves ensuring proper data transfer, retrieval, and storage. ** There is a note to be considered there are a survey pages the user answers the questions and then the application make a schedule based on these answers and the user preferences . Then the data should be passed to the plan page and create the schedule Here is the interfaces ( ...
I'm in need of an Azure Data Engineer versed in data warehousing. The task involves warehousing structured customer data, specifically structured data such as SQL. The ideal freelancer should have: - Experience with Azure Data Warehousing - A track record in handling customer data - Proficiency in managing SQL structured data This role requires both technical skill and careful handling due to the sensitive nature of the data involved. Note : First help me to fix my connection error then we will move to the project
1500$ payment for MySQL multiple Databases recovery.
I'm looking for a knowledgeable freelancer with solid experience in MS Access 2016 and Excel. Key Components: - ...information. - Excel integration: Expertise in linking data between Access and Excel is crucial. You'll be expected to establish a seamless and functional link between the MS Access database (housing the customer information) and Excel. Ideal skills and experience: - Proficiency with MS Access 2016 - Proficiency with MS Excel - Experience in handling customer data - Expertise in data linking between MS Access and Excel - Strong data management skills As this is a critical business function, reliability and attention to detail are paramount. You are expected to test and ensure the robustness and accuracy of the Access-Excel link...
...admin panel for managing fairs and participant companies' data For the front-end development, you should be proficient in Bootstrap for responsive web design, and competent in HTML, CSS, and JavaScript programming languages. A minimalistic yet user-friendly design is desired for the best user experience. Concerning the back-end development, it is necessary to have strong skills in database integration with SQL Server. This blend of skills will enable you to efficiently create functionality relevant to my logistics project. Please provide proof of these skills in your bid....
I need a developer who is well versed with MySQL. I have a database server that has thousands of databases. I need a query that will print the name of all the databases where a specific table has a specific row. For example, consider attached sql script. It creates 5 small dbs, I need a query that will print the names of DB where in sales_target table, there is a row where key=Q1 and value=100
...an SQL query that can pull specific information from our SAP B1 database. The query will need to return Serial Numbers for the transactions in Sheet 1 of AR Invoices, AR Credit Notes and Sheet 2 AP Invoices, and AP Credit Notes, all filtered by Transaction Date. Key Requirements: - The query should return the following fields: Document Number, Transaction Date, CardCode, CardName, Item Code, Item Description and Serial Number. - The data should be filtered specifically by Transaction Date. - Transactions types to be included are AR Invoices, AR Credit Notes, AP Invoices, and AP Credit Notes. - Should not return duplicate serial numbers per Transaction type Ideal skills for this project: - Strong experience with SQL, particularly in the context of SAP B1. - Knowled...
I need a local database. Please read the details attached carefully to know more about the project. To be awarded this project, we will need to discuss and agree with you on the following: - Prove your capability to do the work by showing a similar past work. - Address the program will be used. (preferred a MS App or a free & compatible to windows program) - Your competitive offer. - Timeline to completion.
I'm in need of an experienced developer who's proficient in a range of technologies including HTML, CSS, JavaScript, Stripe, PHP, SQL, and XAMPP. Key Issues: - **Login Functionality**: I've encountered a problem where the user isn't being redirected to their profile page after logging in. This issue needs to be fixed promptly. - **Shopping Basket Functionality**: The project also involves fixing several aspects of the shopping basket. I need assistance in: - Ensuring a message is displayed when the same item is added to the cart again, thus preventing duplication. - Maintaining the cart products even after the page is reloaded. - Implementing a capability where the number of items in the cart icon increases on addition and decreases on removal. - Integrating Str...
I'm in need of an experienced developer who's proficient in a range of technologies including HTML, CSS, JavaScript, Stripe, PHP, SQL, and XAMPP. Key Issues: - **Login Functionality**: I've encountered a problem where the user isn't being redirected to their profile page after logging in. This issue needs to be fixed promptly. - **Shopping Basket Functionality**: The project also involves fixing several aspects of the shopping basket. I need assistance in: - Ensuring a message is displayed when the same item is added to the cart again, thus preventing duplication. - Maintaining the cart products even after the page is reloaded. - Implementing a capability where the number of items in the cart icon increases on addition and decreases on removal. - Integrating Str...
I'm in need of an experienced developer who's proficient in a range of technologies including HTML, CSS, JavaScript, Stripe, PHP, SQL, and XAMPP. Key Issues: - **Login Functionality**: I've encountered a problem where the user isn't being redirected to their profile page after logging in. This issue needs to be fixed promptly. - **Shopping Basket Functionality**: The project also involves fixing several aspects of the shopping basket. I need assistance in: - Ensuring a message is displayed when the same item is added to the cart again, thus preventing duplication. - Maintaining the cart products even after the page is reloaded. - Implementing a capability where the number of items in the cart icon increases on addition and decreases on removal. - Integrating Str...
I need email IDs and contact number of decision makers in the transportation industry for India.
I'm seeking a skilled IT developer, specifically one with an exemplary track-record in database development. Programming language skills aren't my primary concern, so I'm open to experts proficient in Python, Java, C#, or any other suitable language. Here's what I'm looking for: - Proven Experience: Highlight your background in database development, outlining projects you've undertaken and their outcomes. - Competent Advice: As an expert, I'm expecting you to guide me on the best practices and platforms to use in this project. - Adaptability: Since a specific programming language wasn't picked, you should be versatile and comfortable working in different environments. If this sounds like it aligns with your skill set, I look forward...
I am seeking a skilled data engineering trainer, speed in using Hadoop, Apache Spark, and SQL is paramount. Your expertise will guide me through nuanced uses of these technologies, with a particular focus on data migration. Key Requirements: - Proficiency in Hadoop, Apache Spark, and SQL - More than 10 hours availability weekly - Proven experience in real-world data migration projects Ideal candidates should have a flair for explaining complex concepts in simple language. This engagement will focus on moving data from diverse sources into a data warehouse, thereby making it readily available for business intelligence functions.
...Create summary Excel table with link to source, info how to get data, data examples, pricing, etc. 1. Data Collection: Gather detailed data on past space missions, focusing on trajectory, time of burns, orbital maneuvers, velocity and acceleration, fuel usage, mass, payload details, etc. 2. Data Structuring: Organize the collected data into a structured format suitable for machine learning applications. This includes creating standardized data fields such as mission name, launch date, spacecraft type, trajectory details, maneuver sequences, and outcomes. 3. Preliminary Analysis: Conduct a basic analysis to identify any glaring inconsistencies or outliers in the data that might affect later stages of machine learning modeling. Deliverables: A comprehensive database of hist...
We are in need of a detailed, accurate database of female influencers in the fashion niche on Instagram and TikTok. The influencers must be from Romania, Bulgaria, Hungary and Greece and have follower counts between 3,000 and 200,000. The required data points for each influencer are Username, Location, Profile link and Follower count. This project requires great attention to detail and knowledge of social media marketing, particularly in the fashion sector. Ideal freelancers should have a firm grasp of the Instagram and TikTok platforms, plus the capability to accurately ascertain and calculate influencer engagement rates. Knowledge of the fashion niche and Eastern European influencer market is key.
I'm having trouble with database connectivity in my Node backend. Experienced freelancers who have previously handled similar issues are preferred. Please include details of your past experience in tackling such problems in your application. As the specific functionality that needs fixing was not specified in the project description, having a broad range of expertise in Node would be beneficial. Please bid accordingly.
I need a proficient .NET developer who can handle the backend development and database management of my project. Key Requirements: - Proficient in C# for backend development. - Proficient in SQL for database management. - Experience with SQL Server database management system. Additional Information: - The focus is on the efficiency and reliability of the backend processes. - The database management will include schema design, query optimization, and ensuring data integrity. Please include relevant experience in your bid.
Read a JML/JSON (see the example) file created by Selenium IDE and save it into an Access Database (.mdb) Requirements: 1) The application is a Windows desktop application 2) Development language: C# .NET latest version 3) The application will be called ImportBotJob 4) The application must include all of the components to run on a PC without Office installed.
...to handle a two-part project. Firstly, the MySQL database requires a series of updates, including the addition of new data fields, the modification of existing ones, and the removal of obsolete fields. Moreover, the database as a whole will need updating. The second part of the project involves the development of a front-end interface for this database. The interface must feature a user authentication and login mechanism, as well as an intuitive search and filter system. Key Requirements: - Proficient in PHP and MySQL - Experienced in updating and maintaining MySQL databases - Skilled in crafting user-friendly front-end interfaces - Ability to design with a minimalistic and clean aesthetic Please consider the following points: - The database updates shoul...
I need help collecting address and service information from business websites and storing the data in a MySQL database. Key requirements: - Data Collection: You will be required to visit select business directories and scrape relevant information, such as addresses and services provided. - Database Creation: Once the data is collected, it needs to be organized and stored in a MySQL database. Ideal Skills: - Web Scraping: Experience in scraping data from websites is crucial for this project. - Database Management: Proficiency in MySQL and structuring the database is essential. - Attention to Detail: Ensuring accuracy and completeness of the collected data is important. - Time Management: Ability to complete the task within the agreed timeline. Pleas...
My Wordpress site, hosted on a shared server, is showing 'Error establishing a database connection'. I haven't made any recent changes and it was working fine before. I'm unsure what triggered this issue. Key tasks: - Determine the root cause of the database connection error - Resolve the issue and ensure the website is fully functional - Investigate and identify potential vulnerabilities that may be connected to the issue for future prevention Ideal skills and experience: - Extensive experience with Wordpress troubleshooting, particularly database connection errors - Proficiency in PHP, MySQL, and other relevant technologies - Ability to efficiently diagnose and resolve issues on shared servers - Strong communication skills in order to explain th...
I require an experienced SQL and C# professional to help me establish a secure MySQL database connection for my application. The main purpose for this connection is to - restrict processor hacker to track conn string I'm looking for an expert with a proven track record working on similar projects. i am using c# with mysql database, here i want when i make a connection with mysql that time process hacker cannot access to my connection string, for now it is recorded in my process hacker tool.
We' re looking for a small team from BANGALORE. The team must be ready to work from our office under our supervision. Team must be able to handle the complete technical requirements of the project. Please respond with your team composition, rough estimate, timelines. Experience developing similar applications (web based analytics ) is mandatory. We are proposing MERN stack, Postgres SQL and Tableau. Any better suggestions are welcome. I'm in need of an experienced small team with a deep understanding of MERN stack and PostgreSQL, data analysis, visualization and proficiency in Tableau, . You'll be building a web platform that crucially measures aspects of campaign performance. Key Characteristics: - Superior web application design: Responsibly answering to...
I'm looking for a skilled Python developer to create a web application designed primarily for web scraping. The main functionalities of this app should be: - Scrape E-comme...main functionalities of this app should be: - Scrape E-commerce Data: The application needs to scrape data from various e-commerce platforms. A specialist with experience in working with different web sources is preferred. - Database Integration: The scraped data will need to be integrated into a database. Therefore, experience with database design and management is crucial. The ideal candidate should have a solid understanding of both web scraping and database management. Practical experience with Python web scraping libraries and familiarity with various database systems w...
I'm in need of an Excel database creation expert to help me establish a system to store and manage customer information. The project is time-sensitive, so I need someone who can get on it ASAP. Key Responsibilities: - Building an Excel database for customer information, possibly by using Chat GPT for data population - Ensuring the database is well-structured and easy to navigate for future reference - Implementing any necessary formulas or functions that can enhance the utility of the database - Ensuring the project is completed in a timely manner, as I need it done ASAP Ideal Skills: - Proficiency in Excel, with experience in database creation and management - Knowledge of using Chat GPT for data entry is a plus - Ability to structure data in a c...
I'm in need of an Excel database creation expert to help me establish a system to store and manage customer information. The project is time-sensitive, so I need someone who can get on it ASAP. Key Responsibilities: - Building an Excel database for customer information, possibly by using Chat GPT for data population - Ensuring the database is well-structured and easy to navigate for future reference - Implementing any necessary formulas or functions that can enhance the utility of the database - Ensuring the project is completed in a timely manner, as I need it done ASAP Ideal Skills: - Proficiency in Excel, with experience in database creation and management - Knowledge of using Chat GPT for data entry is a plus - Ability to structure data in a c...
