My sql databases jobs

I'm looking to build a new React application that leverages a .NET API, all from scratch while utilizing an existing SQL database. - **Core Functionalities:** - **User Authentication:** Secure login system using email and password. This system should ensure that user data is protected and only authorized users can access the application. - **CRUD Operations:** The ability for users to create, read, update, and delete data within the database seamlessly. This includes managing user details, settings, and other data points relevant to the application. - **Role-Based Access Control (RBAC):** Different levels of access and permissions for users based on their role within the application. Specifically, I need two roles: Administrator and Standard User. Administrators should ...

I require a specialist to focus on integrating my Bubble platform with a specific database. The following details the specifics of the project: - The primary task involves integrating the Bubble platform with the Quickbooks and Job Nimbus CRM databases. - The reason behind this integration is to develop a customizable dashboard that brings the data from Quickbooks and our CRM system together. Ideal skills and experience: - Experienced Bubble developer with a clear understanding of its functionality and capabilities. - Hands-on experience with Quickbooks and Job Nimbus CRM. Knowledge of these platforms is crucial for the smooth flow of the project. - A freelancer with prior experience in database integration projects, especially relating to Quickbooks and CRM syste...

I am in need of a skilled Power BI Designer and Developer. Your key tasks will be: - Handling Data modeling - Creating Reports - Designing Dashboards The main goal of this project is to visualize my data insights. This means designing highly interactive and informative dashboards. You will also be expected to create reports that are insightful and easy to understand. I'm working with local databases so a strong proficiency in this type of data source is required. Familiarity and past experience with working directly with such databases is a big plus. Strong attention to detail, accuracy, and the ability to work within deadlines will be critical to your success on this project. I'm looking for someone who is proactive, open to feedback, and ready for an ong...

I'm experiencing a persistent "Cannot establish database connection" issue on my AWS EC2 Linux based Wordpress site and I need your expertise to solve it. There have been no recent changes to my EC2 instance's settings or WordPress plugins, and the database credentials in my WordPress configuration file have been checked and verified. Error is Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /opt/bitnami/apps/wordpress/htdocs/wp-includes/ on line 1987 No such file or directory Ideal Candidate should: - Possess knowledge and experience working with AWS EC2 Linux Instances and SQL databases. - Be well-versed in troubleshooting Wordpress database connection errors. - Be detail-oriented, reliable, and efficient...

I urgently need help retrieving my GSTIN number. The task demands a specific level of expertise because it entails activating a dormant GSTIN. Here's what I need: - Assistance in retrieving my GSTIN number from a location that will be disclosed privately. - Aid with the reactivation process of my GSTIN number. Ideal candidate should: - Be familiar with GSTIN number retrieval and reactivation procedures. - Have experience and understanding of government databases as this is where the retrieval will be happening from. - Be a professional with efficient communication and able to handle sensitive and confidential matters professionally. Please bid if you can do this quickly and responsibly. All further details will be disclosed during the selection proc...

...6 + years of software engineering and development, including 2 years in technical leadership. - Significant experience as a full stack developer. - B2 level English. - Must be well versed with C#, .NET, Angular(Or React), SQL Server and Azure DevOps. - Significant experience in new computing architectures and implementation of networked computing structures. - Experience developing NT, Unix, and/or Windows based applications, strong component, process and data modeling skills. **Preferred Skills** - Azure DevOps and/or Native Cloud Services - Agile/Scrum - C#, .NET, SQL Server, or Angular or React certifications **Compensation Pay Disclosure** Top Talented is committed to pay that’s fair and equitable, which means comparable pay for comparable roles and responsib...

Thank you for looking into my project. I'm in urgent need of an expert PHP and SQL Developer who can assist me with my PHP code file. Your primary task would be: - Extract the UPDATE queries from my existing PHP code file. Create the sql quart form the pho file. The freelancer I am looking for ideally has: - A strong background in PHP and SQL - Extensive experience extracting and optimizing SQL queries - A deep understanding of MySQL databases Please submit your proposal detailing your experience with the tasks listed above and how you plan to accomplish it. Your ability to communicate clearly and effectively will play a factor in who gets awarded this job. Looking forward to your bids.

...Frontend: The frontend will be developed using ReactJs, ensuring a modern and responsive user interface. Backend: The backend will be implemented using either Java or Golang, depending on the developer's expertise and preference. The backend should seamlessly handle data processing, user authentication, and overall system functionality. Database: The application will utilize both NoSQL and SQL databases to efficiently manage and store data. This hybrid approach is intended to provide flexibility and scalability. Key Features: Property Listings: Users should be able to browse and search for properties based on various criteria such as location, price range, and property type. User Accounts: Implement a secure user authentication system allowing users to create acc...

I'm looking for an experienced developer who can build a simple, yet effective online management system. Essential technology skills include C#, SQL, WebAPI, Bootsrap, and CSS. Key features will include: - User authentication: You should have prior experience designing secure login systems. - Data entry forms: These need to be intuitive and easy for end-users. - Reporting and analytics: Ability to create meaningful insights from data. - Selling and inventory: Inventory adjustments should be accurately reflected and synchronized with sales. - Create invoices: This functionality should be simultaneously linked with the sales and inventory module. The primary purpose of the system is inventory management, but it will also integrate other important areas like sales management....

I'm in search of an experienced web developer who can design a top-notch portfolio website for my business that is modern, user-friendly, and high-performing. Key Features: - Service/Products listing: The website should have a section to showcase my services or products. It should be easy to navigate and have a clear, concise layout. - Contact form: I'd like to make it effortless for prospective clients to get in touch with me. For this, I need a streamlined contact form that collects basic information such as name, email, and message. Skills: - Web Development: You should be highly proficient in multiple web development languages, frameworks, and databases. - UI/UX Design: You should have a keen sense of aesthetics and user experience design to ensur...

Looking for someone with good skills in Airflow, Pyspark and SQL.

I am in need of a proficient Power BI specialist to create a comprehensive dashboard for my business. This project will involve reading unidentified data sources which can be in the form of Excel files, databases like SQL Server, or Web services such as APIs. Due to business confidentiality, I cannot disclose the exact nature of the data sources at this stage. However, prior experience working with diverse and varying data sources will be ideal. The dashboard should be designed to include a variety of visualizations — specifically, bar charts, line graphs, and pie charts . The exact data and metrics required to be highlighted on the dashboard cannot be stated at this moment, but the expert should be well versed in presenting a multitude of business parameters ...

...dashboard using data from SQL databases. The ideal candidate should have strong skills in SQL and Power BI, with a strong understanding of customer data analysis. The project will require: * Designing a Power BI dashboard to visualize our SQL database. * Selecting specific information from the SQL databases for display on the dashboard, mainly focusing on customer data. * Performing analysis on specific aspects of customer data. SCOPE OF THE WORK: * Data Analysis: Analyze customer demographics and customer behavior trends within our SQL databases to identify useful patterns or insights. * Dashboard Design: Create a dashboard that presents this data in a meaningful and digestible way. The ideal freelancer should: * Have a prov...

...relationships and entities. Key tasks: - Designing the structure for the RDF graph database - Implementing the basic level graph with less entities and few relationships - Setting up the database to effectively manage and process numerical data Ideal Skills and Experience: - Strong understanding and experience of RDF graph databases - Proficiency in Python for application - Ability to handle numerical data efficiently - Experience in developing basic level graph databases with few relations and less entities Those bidding should have a good work ethic and excellent communication skills, as I value updates and progress reports. I'd also appreciate a flexible attitude to alterations or adjustments which may arise during the project. Please share examples of similar p...

As the client of this project, I need a knowledgeable individual to integrate AirTable data bases. My goal is to efficiently collect, update, and disseminate information from leads gathered during a trade show. Here are the specifics: Collection of Information: - Our focus is to gather name, contact details, best time to schedule interaction, and any specific comments from the leads. Data Submission: - We would like the leads to submit their details either by email or text message, thereby cutting down on time and ensuring quicker responses. Dissemination of information: - A personal letter tailored with links to resources will be sent to leads either through email, text, or both. This depends on the lead's preference. Our ideal candidate for this role would ...

Please Sign Up or Login to see details.

I am in need of an experienced developer with strong skills in .NET and SQL. My project currently has some issues that I am unable to resolve on my own. Work needs to be done on my premises in Las Vegas. Key Tasks: * Debugging: The application has been developed but is encountering syntax errors and runtime errors which need resolution. Ideal Skills and Qualifications: * Strong experience with .NET and SQL * Proven debugging and problem-solving abilities * Knowledge of application development and programming languages If you have the ability to quickly identify and fix these issues, I would love to hear from you. Please share examples of similar work you have completed. Thank you.

We require a ClickUp expert who is able to develop a form that captures key patient information including name, contact details, appointment particulars and patient history. The same expert should be proficient in integrating the form with our ClickUp CRM. Our needs are: - Fluent with ClickUp functionalities - Proficient in data management - Adequate knowledge in healthcare databases The form should be designed to synergistically feed collected information into our ClickUp CRM in real time. No manual importing should be required. All captured data must be stored automatically. Experience in similar projects within the healthcare sector will be highly regarded. Familiarity with data privacy and HIPAA laws givens the nature of the information being captured is crucial.

...someone with outstanding SQL skills to assist me in creating and formatting various SQL queries. The job will involve: - Writing data extraction queries based on specific requirements that I will provide. - Assuring SQL syntax is correct and the formats are professional. - Delivering optimized, efficient queries to extract data smoothly. The ideal candidate for this job will be: - Proficient in SQL and comfortable handling different types of queries, particularly data extraction ones. - Experienced in SQL syntax and formatting, assuring that all work done is up to professional standards. - Capable of writing efficient scripts to ensure the least amount of load on our servers and the fastest possible results. This project may be straightforward fo...

I am in need of a talented developer who can design and build a RESTful API with a focus on several specific functionalities. As the ideal candidate, you are skilled in multiple programming languages (Python, Java, JavaScript) and databases (MySQL, PostgreSQL, MongoDB), in order to deliver the best fitting solution to our needs. The central features that the API should possess include: - User authentication: An integral feature to ensure only verified users gain access - Data encryption: To secure the data and safeguard privacy - File upload/download: This functionality will aid in seamless data transition The idea of the job is to create an interface with our internal système to the format data in a simple an easy to understand format for the web. To do so we ex...

I'm personally in need of a proficient developer who can assist in creating a reliable XML to CSV converter for my cloud-based system. Your expertise will be critical in resolving database connectivity issues that I'm currently facing. Key project requirements: - Develop an XML to CSV Converter applicable to a cloud-based system - Must be able to effectively debug and solve database connectivity issues - A thorough understanding and experience with cloud-based systems is necessary - Proficiency in script coding, particularly SQL scripts are highly desirable. Your role will primarily be focused on ensuring the smooth conversion and transfer of data between XML and CSV formats in the cloud. Please, only serious and committed freelancers should bid. I'm loo...

...already converted 50-60% to ) and also transfering our .NET to .NET CORE and our MS SQL to PostgreSQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and

I am experiencing an issue with my SQL Server Management studio 14. Whenever I attempt to execute a query, I receive a specific error message stating The type Initializzer for ' StatusBarManager.' threw and exception. I have attempted to resolve this issue by uninstalling and reinstalling the program, but the problem persists, over and over again. Key Requirements: - I need someone who has experience dealing with this particular error message. This is a highly specific issue, so experience in identifying and rectifying errors in SQL Server Management Studio 14, in particular, is greatly valued. - You need to be able to demonstrate a solid grasp of SQL server management; particularly in executing and managing queries. Please include

I want to obtain the information of this bible: This is the Genesis website but it has to be about all the books. The important thing about this project: You have to get all the data now an example of the tables Tables and Their Fields Books book_id: Primary key, unique identifier for each book. name: Name of the book. testament: Indicates whether the book belongs to the Old or New Testament. Chapters chapter_id: Primary key, unique identifier for each chapter. chapter_number: Number of the chapter. book_id: Foreign key referencing book_id in the Books table. Verses verse_id: Primary key, unique identifier for each verse. text: Text of the verse. verse_number: Number of the verse. chapter_id: Foreign key referencing chapter_id in the Chapters table. Annotations annotation_id: Pri...

## Automated...interviews (2 rounds) ## ## Open for freelancers from INDIA only ## Fullstack MERN Developer Mid-Level (5-7 years) Requirements:  Experience with front-end code in HTML5, CSS3, JavaScript, ReactJS or similar.  Experience in frameworks such as , NestJS, or proven ability to learn on the job.  Exposure to collaboration tools like GitHub, JIRA, Confluence.  Understanding of Sql and NoSql Databases i.e., MySQL, Mongo DB etc.  Proven track record of building scalable, high-quality software solutions.  Experience of working at a product-oriented company.  Thorough understanding of agile software development methodology, and ability of proactively manage task, projects and issues.  Experience with Elasticsearch, Redis, Memcached will be a plus

...8, 6.x, or 7.x, depending on your experience and preference. - Manage and build upon the existing codebase to improve its performance and scalability. Must-Have Skills: - Solid understanding and experience with Laravel and Vue.js - Knowledge of best practices for PHP development - Strong experience in backend development using Laravel and frontend development using Vue.js - Experience with databases Project Specific Requirements: - A specific feature I'd like to see is the handling of a KYC (Know Your Customer) photo upload issue. Hence, I'd prefer if you have experience in troubleshooting and resolving such matters. - Do note that we do not have any specific KYC service providers for the photo uploads, so your flexibility in handling various photo upload operations...

I'm encountering an issue with my Perfex CRM where data is not appearing in certain modules. Specifically, the leads module and the invoices module are not displaying any data. As such, I need a professional who can address this issue swiftly and restore the formerly smooth functionality of these modules. An ideal candidate for this job would have: - Prior experience with Perfex CRM - Proficiency in troubleshooting data inconsistencies - A robust understanding of how CRM leads and invoice databases operate.

...Visualization Platform, modeled after Datapad. This platform will provide businesses with the capability to seamlessly connect, integrate, and visualize data from diverse sources, facilitating efficient monitoring and analysis of key performance indicators (KPIs). data integration and visualization tool that allows you to connect various data sources, such as Google Analytics, Facebook Ads, Google Sheets, SQL, and more, and create stunning dashboards and reports. You can use it to track your key performance indicators (KPIs), monitor your competitors, and analyze your marketing and sales performance. Datapad is designed for small businesses and power users who want a simple and fast reporting ://://:// • To

As an Oracle developer, I'm seeking a capable freelancer who can assist me in ut...other pertinent information are accurately transmitted through the Teways API. Requirements: - Sound experience with Oracle databases, including the ability to efficiently read from tables. - Proven experience in implementing and working with APIs, particularly the Teways API. - Familiarity with data parsing and manipulation to ensure accurate message transmission. I already have the necessary credentials for the Teways API. Therefore, your focus will be on integrating it with our existing Oracle database to enable SMS sending. The ideal freelancer will be a fast learner, detail-oriented, and a strong communicator. If you are adept at working with both Oracle databases and SMS APIs, I�...

I require a talented Vue.js developer for the construction of an admin backend. This project does not involve integration with any external APIs. Key Features: - User Managemen... This project does not involve integration with any external APIs. Key Features: - User Management - Data Visualization - CRUD (Create, Read, Update, Delete) operations The ideal person for this role should have the following skills: - Proficient in Vue.js development. - Experience with admin backend development for data management. - Strong knowledge and experience in working with SQL databases. Please ensure, before you bid, that you have substantial experience in these areas. Your task will be designing a user-friendly, sleek admin backend from scratch while optimizing for performance an...

...◼ Template types: page-, section-, format-, link- and table templates ◼ Definition of forms with input components ◼ Output of editorial content ◼ Using template syntax for conditions, loops, and formatting ◼ Creating dynamic, rule-based forms for editors to optimize the editorial process and validate user-based input ◼ Managing global content for re-use and configuration purposes ◼ Relational databases for managing and rendering structured content ◼ Header functions for database queries and navigation ◼ Template syntax needed for ContentCreator functionality ◼ Basics of FirstSpirit-Workflows ◼ Applying usability features correctly ◼ Introduction to the FirstSpirit API ◼ The FirstSpirit object model: reading, changing, and creating objects The ideal candidate will have an active ...

I am in need of a Salon Management System developed in .NET Technology(C#,MVC5 or later /WebAPI & SQL Server2016 or later) with latest technology. It should be modern and sleek, catering to today's technologically driven salon industry,clearly responsive with desktop and mobile platform. Key Features Needed: - Authorization system: An easy way to have secure access for Admin,Employee and Clients. Admin can access all the features in the application. - SMS/Emailing Feature: An easiest way to get alert for Clients,Admin and Employees. - Client Management(Employee): A feature that allows tracking client informations like Phone Number,Email,InstagramID,DOB,Anniversary message through sms and email to clients for first time visit. - Appointment scheduling(Employee,Clients): A...

I'm looking for a skilled developer to assist with a Google Earth project, focusing on user interface design. Main Tasks: - Designing the user interface Feat...Earth project, focusing on user interface design. Main Tasks: - Designing the user interface Features Required: I would like a Google Maps web based application. Where the users are able to click features on a map using terrene view(for example trees) JavaScript to pick up the location and address of the property that’s been selected, and the address to be saved into a database using perl CGI in my SQL database. The perl component is optional. Areas that have previously been selected should be highlighted in a yellow highlight or similar The code should work on windows and a Unix platform. I will pro...

Looking for an experienced data scraper to extract and compile data from public sources into a designated Excel spreadsheet format. The spreadsheet has 9 columns comprising of information such as Private Lender, Mailing Address, State, Zip, Site Address, Loan Amount, Transaction Date, and Purchase Price. While the source of the data hasn't been specified, it's understood it will come from public databases. Ideal Freelancer: - Extensive experience in web scraping and data extraction from various sources. - Proficiency in Microsoft Excel for the precise structuring and formatting of data. - Attention to detail, ensuring all data points are accurately covered. - Able to handle unspecified data sources. Note: While skills or tools weren't specifically mentioned, knowle...

...Quantitative Developer - Algo Trading Infrastructure Responsibilities: As a Quantitative Developer, you will be entrusted with the creation and enhancement of algorithms, with a strong emphasis on proficiency in Python or C++. The primary tools for this role revolve around the development of backend infrastructure for algorithmic trading, connecting strategies to broker APIs, setting up cloud-based databases for accurate backtesting, and scripting efficient data download and storage on servers. Key Tasks: Develop and refine the backend infrastructure for algorithmic trading. Connect trading strategies to broker APIs to facilitate seamless execution. Establish and maintain a cloud-based database for precise and reliable backtesting. Develop scripts for efficient data download ...

I am looking for an expert to help restore my SQL Server Management Studio. Unfortunately, I don't have specific details around the version of the SQL Server used or any unique errors experienced, as I missed mentioning those details. Similarly, I am unsure if there have been recent changes to the SQL Management Studio configuration. Therefore, the perfect candidate for this task would be someone proficient in troubleshooting and handling different versions of SQL Server and its Management Studio. Your role will be to restore the system to its full potential without having a detailed error or system configuration history. Skills and Experience Required: - Comprehensive SQL Server knowledge - Experience with SQL Server Management Studi...

I am in need of a skilled PostgreSQL DBA to assist in setting up and configuring a wide range of enterprise tools. The ideal candidate must have expert knowledge in the installation, configuration, and use of the following tools: - EFM (Enterprise Failover Manager) - PEM (Postgres Enterprise Manager) - EDB Migration - pgBackRest - pgBouncer - pgPool In addition to the initial setup, I require some specific expertise to fully leverage these tools. Specifically, it would be great if you have previous experience with: - Backup and restore tasks using pgBackRest - Connection pooling with pgBouncer - Load balancing with pgPool Please, only apply if you have a proven track record with these PostgreSQL tools as I would like to ensure an efficient setup process. Prior experience with similar p...

...do some work on my SMF 2.0(.17) Forum Software. The URL of the website is If you are not familiar with SMF you can find an unaltered Stock Version to download here: ;filename= But please note: MY SITE IS HEAVILY CUSTOMIZED. That is why I need a seasoned PHP developer. I do not wish to waste your time nor do I wish you to waste mine. Therefore: 1. This project is for expirienced PHP developers only! This software is written in PLAIN PHP. NO FRAMEWORK! If you are a WordPress, Magento etc. developer then this is most likely NOT your cup of tea, you have no clue of how a message board / forum works then this is not your project. 3. No coders from India please. My expirience with Indian

I require an experienced MySQL expert to help with data recovery. My database, which primarily held transactional data, has become corrupted, and unfortunately, I don't have a backup. Specific requirements are: • Expertise in MySQL data recovery, especially with transactional databases. • Demonstrated experience handling corrupted databases. • Must possess solid problem-solving skills to determine the source and extent of the corruption. • Ability to take immediate action is essential as the data is quite critical. Please note that this is an urgent request so the ideal candidate should be ready to start immediately and provide regular updates.

...candidate should possess excellent communication skills, both written and verbal, and be capable of working with minimal supervision. Responsibilities: -- Develop and maintain robust and scalable SaaS and desktop applications using NWJS, NodeJS, JavaScript, TypeScript, HTML, CSS, and JQuery. -- Ensure the technical feasibility of UI/UX designs and implement them accordingly. -- Work with MYSQL databases to handle data storage, retrieval, and manipulation. -- Utilize AWS services for deploying and maintaining applications in the cloud. -- Manage and enhance the Stripe payment system with the desktop and web applications. -- Develop WordPress websites. -- Demonstrate problem-solving skills and the ability to research and recommend innovative solutions. -- Communicate effectively ...

I urgently require an expert with a comprehensive understanding of Laravel to help me set up a script on my platform. The tasks involve: - Upgrading my CPANEL's PHP version to 8.1. Please note that the CPANEL is currently running on PHP version 8. - Importing an existing database. - Taking charge of the entire Laravel script installation process. This is the task I'm most worried about and would require in-depth expertise. The ideal candidate for this project should have solid experience in Laravel, a strong understanding of PHP, including its latest versions, and proficient skills in managing databases. I'm in a hurry to get this project executed as soon as possible. Therefore, a freelancer who can cope with a fast-paced task, maintaining great atten...

I am looking for an experienced PHP (CodeIgniter) & MySQL developer to create new modules and functionalities for my existing web application. We are looking for a collaborator, an expert in PHP (CodeIgniter) and MySQL, for a long-term collaboration. This collaboration involves the following: 1. Modification of some modules from existing applications - in the sense of adding custom menus/functionalities. CodeIgniter only. 2. Creating new applications (from scratch)t. CodeIgniter only. 3. Availability for a minimum of 16 hours per week. 4. Accepting that the work be supervised through AnyDesk (or similar) - first of all, to be able to intervene in real time in this custom programming 5. Our collaborator must be an expert in CodeIgniter. In other words, we will not pay for &quo...

...history, preferences, and behavior history. Experience in efficient data handling and privacy management is required. App in flutter with google maps main objective is to update the customer's data or register a new one and schedule the daily route for the seller. What you generate daily will serve to make this information ready for your attention for delivery the next day and you must connect to db sql server /csv /excel of clients to edit or record data and purchase history this at the time of working with the Google API but to automatically obtain latitude and longitude the supervisor at the end will be able to see the map with all the clients served On the day in them you will know how many are recurring and new. It has a web side where you can import and export the inf...

I'm looking for a skilled and experienced software developer to add to an existing Microsoft Power App that I built for my nonprofit. This application operates primarily on the Windows platform, so familiarity with this environment is a necessity. Plus our interns need to be able to access the employer database from their smartphone Key Features Needed: - The main functionality I want to add in this Microsoft Power App is another database for employers and expand the UI to include access to that database. I'm using dataverse databases/tables. - Specifically, this app will be primarily managing internship and employer data. Ideal Skills and Experience: - Expertise in Microsoft Power Apps development. - Strong experience in building apps functioning on Windows. - Kn...

I am seeking a skilled WordPress programmer to incorporate a custom search feature on my website. The functionality should include: - The ability to filter results: Users should be able to narrow down their search based on specific criteria. - Auto-complete suggestions: As users start typing, relevant suggestions should automatically populate to enhance usability. The search functionality should be restricted to post titles and contents only. Only developers with prior experience in custom WordPress search features should bid. Proven expertise in PHP, SQL, and Ajax

I'm currently in need of assistance with a MySQL query task; specifically how to make use of a subquery in order to yield accurate results in a Select statement. The main purpose here is to fetch data. **** All SQL files are attached to the files for this project. What I am Seeking: Help with the attached query. The query joins two tables. A header and details table. The intent of the subquery in this statement is to find/match a SINGLE "Invoice Date" value in the inv_details table that matches a "PO Date" from the po_details table in the subquery using the main queries currently matching "item" , "ship to city" and "customer name". Using "distinct" in the subquery generates an error (subquery returns more than on...

...Expertise in Node Red and its architecture for developing custom nodes. - Strong background in data processing techniques suitable for real-time and database inputs. - Proven experience in implementing machine learning within Node Red, specifically predictive analytics. - Ability to create intricate custom logics tailored to specified outcomes and efficiencies. - Familiarity with interacting with databases and APIs for real-time data fetching and processing. **Ideal Skills and Experience:** - Proficient in JavaScript and Node.js, as they are essential for Node Red development. - Demonstrated experience with machine learning libraries and frameworks that can be leveraged within Node Red. - Understanding of database management and API integration for seamless data flow. - Exceptio...

I need an expert in PowerBI who is capable of connecting to Excel spreadsheets and SQL databases to create a visually engaging and vibrant dashboard. This dashboard will need to provide: - Detailed analysis of sales performance, enabling a clear understanding of the areas that are working well and those that need improvement. - Thorough customer segmentation that provides deep insights into our customer base to improve marketing effectiveness. - Comprehensive trend analysis that identifies patterns over time to assist in strategic decision making. Ideal candidates should have a strong background in PowerBI dashboard creation and data analysis, as well as a good eye for vibrant and colorful design that can help to bring the data to life.

...wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales Key Responsibilities: 1) Improve angular.js performance then work on transforming angular.js to 2) Front end work migrating our current webapp from angular to , create new pages and functionalities in 3) Developers with experience in .NET API C# are an added plus as is knowledge of WordPress plugins. This is for ongoing long term

Come do interesting GIS programing in a database. *** Please no AI responses. *** Experience with snowflake and other big data a plus. Able to advise and write. Able to work TODAY. Please respond by telling me what is a 3-4. **Requirements:** - Proficiency in spatial SQL -> MUST for complex data query and retrieval. The ability to perform spatial analyses and geometric operations is crucial. - Expertise in creating engaging, interactive maps that can visualize spatial data and analyze spatial patterns on a global scale. This would involve dealing effectively with diverse data sets and potentially large volumes of data. - Strong background in PostgreSQL and PostGIS, with proven experience in writing advanced spatial queries. - Experience in web map development, wi...