Sql parentchild tree query trabalhos

...startup that is innovating at the leading edge of Artificial Intelligence movie and game production. Our competitors are the likes of Sora, DALL.E and Runway.ml. This remote work job is for initially 10 hours per week at NZD $31 per hour with the opportunity for promotion in the future. Technologies that you must be able to use competently. C# and LINQ Visual Studio 2022 MS Web API Javascript SQL We are looking for someone who: * Is fundamentally enthusiastic and passionate about learning AI technologies. * Can learn quickly. * Can speak English well enough to communicate appropriately in a joint Zoom session with our English speaking developers. * Be available to RDP into our data center resources from 3pm and 5pm Monday to Friday New Zealand time while performing Zoom m...

I am looking for a skilled freelancer with profound expertise in Excel and SQL, particularly on the Mac platform. Key tasks include: - Importation of numeric data from an Excel workbook into Microsoft Azure Data Studio using Python - The data is arranged over multiple worksheets, all of which are interrelated. - Apart from the primary data importation job, the freelancer will be tasked with devising an efficient method of performing this task on a daily basis. Ideal Skills: - Strong Excel and SQL skills with experience in data migration. - Proven ability to handle related datasets spread over multiple worksheets. - Experience with automation, to maintain daily import tasks. - Familiarity with Mac operating systems. Your bid should demonstrate a clear understanding of...

Please completely read this project description, and check attached requirements file before bidding. TECHNICAL REQUIREMENTS Solution Solution must be delivered in Visual Studio 2022 Community Edition Awarded freelancer must provide SQL scripts to create database and tables. Prefered solution projects structure in VS Solution: API DTO Models Repository Services WebAssembly Backend Asp.net Core 8 SQL Server 2019 or later Frontend Blazor Web Assembly The budget placed on this project is already final and negotiations for it will not be entertained. Tip is only provided to those freelancers who accomplish the job before the estimated days by the freelancer when bidding. I only pay additional money for new additional requirements, not included in original s...

I'm seeking an experienced Laravel developer with knowledge in SQL Database Management, MQTT, and IoT integrations. Essential skills and experience involve: 1. **IoT Devices Integration**: The professional should have previous experience integrating Laravel with various IoT devices. In this case, the object of integration includes smart home devices, industrial sensors, and wearable devices. 2. **SQL Database Management**: I need assistance in managing my SQL database for various functionalities. Specifically, the task requires skills in data retrieval, data storage, and data synchronization. 3. **Template Customization**: I have my own pre-designed templates which need adjustments. The main element to be modified is the layout and structure. Experience in cust...

I am in need of a seasoned PHP/SQL programmer to create a robust Admin Panel for my website. The panel should focus mainly on two key functionalities: User management and Content management. For User management, the software should allow me to function as a Super Admin with the rights to full access of all components and operations within the panel. Content management is another critical feature. It should specifically cater to handling products, allowing me to conveniently add, update and remove product listings. Ideal skills for this project includes: - Proficient in PHP/SQL - Experience in building admin panels - Sound understanding of user and content management - Familiarity with product-based platforms is a plus. Your proposal should include your previous work s...

...robust functionality and user experience. • Provide documentation for the plugin, including installation, configuration, and user guides. • Offer technical support and updates as needed to address any issues, improvements, or Moodle updates. Requirements: • Proven experience in Moodle plugin development, with a portfolio of previous projects. • Strong proficiency in PHP, HTML, CSS, JavaScript, and SQL. • Familiarity with Moodle's architecture, coding standards, and best practices. • Excellent understanding of UX/UI design principles, especially in the context of educational platforms. • Ability to work independently and collaboratively in a remote environment. • Strong communication skills, with fluency in English. • A passion for...

...present means of storing credentials. Instead of its current session storage, we're switching to database storage specifically with MySQL. The aim is to improve functionality and security. The work should be done in a demo environment and I will add the code to the live site. Key Details: - The Xero App in question can be found at this link: - We've chosen MySQL as our preferred DBMS. Ideal Candidate: - Proficient in PHP and MySQL - Familiar with database structure modification - Understanding of Xero apps is a plus - Can optimize for security and speed - Transparent and maintains good communication. I look forward to working with someone who can add value to this project. Please feel free to reach out if you need any additional

I am seeking a talented developer, ideally experienced in Xano, for backend system development. This project encompasses. Need help in checking current sql server table structure and recommend us proper We have created api in in java and sql server based database system. Need to convert existing api to xano

I'm looking for a talented Python developer with a solid understanding of Django and MySQL. The purpose of this project is to develop a robust database management system. These are some key features that the application should have: - Integration with Django's ORM (Object-Relational Mapping) library. - Custom SQL query functionality for advanced data operations. - A system for data backup and recovery to prevent data loss. You should have a proven track record with both Django and MySQL, and be able to show examples of similar projects you have worked on. A strong understanding of database design and management is a must.

I'm looking for an expert in WordPress plugin troubleshooting, specifically with knowledge of the "Sideways8 Private Pages" plugin. My site is currently having issues with this plugin, as it's no...issues with this plugin, as it's not compatible with the WordPress version and hindering user authentication to private pages. The issue specifics are as follows: - Compatibility: The plugin isn't working with the WordPress version. Ideal candidates should have experience in WordPress plugin development and troubleshooting, with an extra emphasis on authentication issues. Knowledge in PHP and SQL is also crucial. Your task will involve resolving the aforementioned issues and ensuring the "Sideways8 Private Pages" plugin are fully functioning as...

Excel web query to extract data into Excel spreadsheet from also extract Live odds comparison table from Currently, these 2 tables are not showing up using Excel web query

As an organization, we are aiming for proficient data analysis and reporting using the SQL database, which is below 1GB. We need an experienced professional with skills in: - Writing strong SQL queries - Developing effective SSIS packages - Creating insightful SSRS reports This project primarily focuses on enhancing our data comprehension and subsequent reporting, thus requiring a thorough command of SQL related tasks. The suitable freelancer for this job should possess strong analytical skills and have a proven track record of database management and optimizing results.

...Demonstrated sales/marketing acumen. Strong verbal and written communication skills in English. Basic understanding of Information Technology. Shift Timings: 9:30 AM EST to 2:30 PM EST. Previous experience in inside sales/marketing is advantageous. Familiarity with Whitepapers, SQL, MQL, HQL, and BANT campaigns. Proficiency with online research tools such as LinkedIn Sales Navigator, , and Seamless.ai. In order to apply, please share the answers to the below questions 1. Have you worked on Whitepapers, SQL, MQL, HQL, and BANT campaigns before? 2. How many years of cold calling experience do you have in USA 3. How many calls can you make in 5hours a day Please attached give a link to your recording for us to evaluate....

...regularly conduct activities for our members, and need an effective way to manage these. - Reports: Generation of detailed reports is critical. - Membership payments: Ability to handle membership payments. The ideal freelancer for this job would be someone with a strong background in web development. Experience in converting local apps into web-based systems is a tremendous plus. Proficiency in SQL, HTML, JavaScript and knowledge in online payment systems is necessary. Previous experience with NGOs or membership-related systems would give you a great headstart. Expectations: To deliver a fully operational, easy-to-use web-system that meets our functionalities requirement. Your focus should be on user experience, functionality, and system efficiency with a touch of simplicity....

I am looking for an experienced Python developer with knowledge in DevOps, S3, SQL and AWS Lambda. The main task will be developing a script for parsing HTML and perform the following tasks: - Extract specific data points such as text contents, meta tags, and hyperlinks - Clean and format the extracted data - Store the cleaned and formatted data in a database Prior experience in dealing with HTML parsing using Python is a must. Also, knowledge of SQL for database management and AWS Lambda for automating the parsing process would be highly beneficial. Thanks!

As we have already discussed about the project or if you have any query you can ask for it

I need a skillful Laravel developer to convert my old website. You will be required to pre...skillful Laravel developer to convert my old website. You will be required to preserve specific aspects through the transition, and also focus on boosting the security of the site. Key project requirements: - Expertise in Laravel, website conversions, and security measures. - Well-versed in protecting against SQL injection attacks. On this job, you'll have to: - Migrate the website into Laravel without losing its current features. - Implement anti-SQL injection measures. - Fortify the overall security of the website. A thorough understanding of website security is crucial for this role. Please share any similar projects you've completed. Let'...

As an active member of the risk management sector, I am in need of a dedicated individual who can efficiently implement a minimum spanning tree algorithm in Python for stress testing. This project has a direct correlation with financial data, where scenario analysis is a critical requirement. Key tasks: - Development of a robust Python-based solution for testing financial stress - Implementation of scenario analysis using minimum spanning tree algorithms Ideal Candidate: - Strong programming skills in Python - Experience with algorithms, specifically minimum spanning tree - Exceptional understanding of financial data processing - Knowledge in risk management and stress testing methodologies, specifically scenario analysis In conclusion, I am hoping to collabo...

...fast-paced environment using Lean Startup and Agile methodologies. Foster a culture of innovation, sharing knowledge, and promoting best practices. Qualifications: Preferably 1-3 years of relevant experience. Proficiency in at least one compiled language (Extra points for Go) and one interpreted language (Extra points for JavaScript). Good familiarity with various database technologies, including SQL and Document-based storage (MongoDB). Experience with API Design, LCM & implementations (REST API, OpenAPI specs). Familiarity with DDD/TDD and CD/CI practices. Strong experience in Microservice-based architecture and services. CloudOps/DevOps experience, ideally with AWS and/or Azure. Comfortable working in a fast-paced environment with Lean Startup and Agile methodologies...

mình cần tuyển anh em kỹ sư bảo trì partime remote cho Microsoft SQL, AX, CRM. yêu cầu: Microsoft SQL: Hệ thống AX: CRM: Vai trò này yêu cầu bảo trì thường xuyên hàng tháng

I'm in need of an expert who can work with SQL to generate an SSRS report that focuses on the analysis of medical test results. Your work will contribute to crucial data examination to aid our operations. Key tasks will include: - Building an SSRS report for data analysis using SQL stored procedure or cursor or any other mechanism as per requirement - Incorporating medical test results in the report Ideal skills and experience: - Proficient in SQL and SSRS report development - Background in handling and analysing medical data - Attention to detail and accuracy - Proven track record of delivering projects on time I'm looking forward to receiving bids from candidates who can show they have the necessary skills and experience for this task.

As the project owner, I'm looking for a proficient full stack developer with expertise in: - .NET Core - Asp.net - MVC - Angular /React - SQL - Azure Specific skills and experience needed include: - Strong background in full stack development - Extensive experience with C# and MVC - Proficiency in .NET Core and Angular/react - Proven ability in SQL and Azure No specific design is required, but a clean, user-friendly approach to the project is always appreciated. The project needs to be completed within a month. If you think you're the right fit for this role, don't hesitate to apply! Looking forward to working with dedicated and skilled professionals.

I need a simple webpage where I can search for a sku in my sql database ,select it ,then update its data on that page So lets say I have a product sku called LUX01768N that I want to update I would go to my website URL would need to be password protected requiring a user and password to continue. Once logged on I envision I would enter ‘LUX01768N’ in a search box and hit enter. The SKU would search a sql table that has all the data. Its results would display The SKU LUX01768N (Not Editable) and its Fields to be updated.. Currently these are the fields below The database table already is called . dbo_mip-product-combined-coins I will grant you user permissions to that table Some fields need a multiple choice answer Others just answer. Example [Mint Locatio...

...stages. Your tasks could range from frontend to backend development and database optimization. This platform has already been developed using Angular for the frontend and .NET Core Entity Framework for the backend after creating a database in SQL web server. Specific Aspects Needing Aid: • Frontend Development: Enhance the user interface for optimal user experience based on a customizable and user-friendly design. • Backend Development: Ensure efficient processing and functioning of API requests and responses. • Database Optimization: Make sure our SQL web server database runs smoothly and efficiently. Main Functionalities: • User Registration and Login: Users should be able to easily register and securely log in to their accounts. • Accou...

...values json = { "id": "screenName", "name": "Employee", "type": "component", "controls": [ { "id": "name", "name": "name", "label": "Name", "type": "input" }, { "id": "dept", "type": "select" } ] } => util -> typescript component: `const ${}Component = (props) => { return <> ${(c => </> }` Use babel-generete AST - Abstract Syntax Tree Output code: const EmployeeComponent = () => { const fn () => { // call api and set in state } return <> <label>Name</label><input id="na...

I'm looking for an experienced ASP.net developer to create a highly functional personal application. Key features that must be integrated into the design include: - A robust, fully-functional tree database. - Meaningful use of graphics. - TreeView object implementation. The successful freelancer will have a deep understanding of .net programming, be proficient in database management, and have the ability to work with TreeView controls. I don't have any specific design requirements for the graphics. This project demands strong technical skills coupled with a degree of creative flexibility. The end result should be a personal ASP.net application that is visually appealing and user-friendly. ************ Project *************************** Creating a C# ASP.NET websit...

We are in need of a skilled developer to create an Android application serving as an earning platform for delivery jobs. Key tasks and requirements include: 1. Design and devel...delivery jobs. Key tasks and requirements include: 1. Design and develop the application for Android platform. 2. The application will be an earning platform specifically designed for delivery related jobs. 3. It's imperative the platform incorporates features for user registration and job listing. Desired Skills and Experience: - Proficiency in Java, Android Studio, and SDK - Experience with SQL databases specifically for Android apps - Strong UX/UI design skills - Experience in developing apps that incorporate user registration and job listing features - Previous work to demonstrate these skill...

...specific requirements: - Introduce a deck or patio: I'd like an area where I can entertain and relax. - Implement garden beds: Both low and high beds would be appreciated. Mastery over soil mixes and planting techniques is expected. - Create a Children's Play Area: This should be safe and stimulating for kids, integrated seamlessly into the overall landscape design and include mud kitchen, sandpit, tree house etc - A BBQ area The designer has to be mindful of the weather elements in the UK The completion of this project is time-sensitive, as I desire to have it done ASAP. Therefore, efficiency is critical without compromising on quality. The professionals I'm seeking should be experienced in undertaking such projects and provide suggestions and ideas for the...

I'm looking for an expert SQL developer who understands XML data. My project requires the importation of XML directly into a SQL table. It's important that the output undergoes specific adjustments. Ideal Skills Include: - Advanced knowledge in SQL - Proficiency in XML data structure - Understanding of data filtering, formatting and sorting The Task: - Adjust the current SQL script to output the imported XML data as CSV files. - Apply filtering to the XML data; specifically, filtering by certain attributes. - Incorporate formatting and sorting into the output stage. Your key deliverable will be an optimized SQL script that runs smoothly and produces CSV output according to the specifications. If this is something you can deliver, I would lov...

I am in need of a PL/SQL expert to join my project. Getting error 19115 XML error need help in investing a loop plsql procedure to see where it is failing and handling exception Main Duties: * Database Design * Writing Stored Procedures * Performance Tuning Ideal Candidate: * Must have advanced level experience in PL/SQL development. Application Instructions: * Please highlight your relevant experience in your application. Only freelancers with advanced experience, and can showcase this in their applications, will be considered for this project. I look forward to your bids.

I need a proficient data analyst to create a comprehensive Power BI dashboard for portfolio analysis, drawing data from various sources including Excel spreadsheets, SQL databases, and online APIs. The Key Performance Indicators for the dashboard should focus on the computation of drawdown for multiple portfolios, specifically the maximum drawdown. Ideal Skills: - Expertise in Power BI - Experience with SQL and Excel - Understanding of portfolio analysis - Aptitude for handling Online APIs Your goal will be to generate data-driven insights to help make better financial decisions. The success of this project will lie in your ability to design and deliver a functional, intuitive Power BI dashboard.

Por favor, Cadastre-se ou Faça Login para ver os detalhes.

I'm in need of an expert who can assist me in replicating my entire SQL database. This task is primarily aimed at data distribution between 2servers on Different Public IPs Ideal Skills and Experience: - Strong experience with SQL databases - Proficient in various SQL replication methods - Previous experience with large scale data replication Please bid if you meet these requirements and are confident you can effectively assist with this project.

We are in search of highly experienced senior developers with a strong background in .NET, C#, and SQL to join our dynamic team. The ideal candidate will be adept at navigating and enhancing an established ecosystem, with a focus on adding new features and configuring APIs to seamlessly integrate with our existing framework. **Responsibilities:** - Collaborate with our development team to design and implement new features. - Ensure the scalability and reliability of the application through high-quality code and review. - Integrate third-party APIs and internal APIs to enhance the system's capabilities. - Troubleshoot, debug, and upgrade existing software. - Provide technical leadership and mentorship to junior developers.

You can see the Firestore data in the screenshot. I want to query for device name. So only show data which contains the word ELOC22 in app_data. Seems easy but i can't make it work. Anybody? If you know how to do it. It would be great if you can connect to my PC via Anydesk and show me how its done :)

I'm in need of an expert who can work with SQL to generate an SSRS report that focuses on the analysis of medical test results. Your work will contribute to crucial data examination to aid our operations. Key tasks will include: - Building an SSRS report for data analysis using SQL stored procedure or cursor or any other mechanism as per requirement - Incorporating medical test results in the report Ideal skills and experience: - Proficient in SQL and SSRS report development - Background in handling and analysing medical data - Attention to detail and accuracy - Proven track record of delivering projects on time I'm looking forward to receiving bids from candidates who can show they have the necessary skills and experience for this task.

I'm in need of an expert who can work with SQL to generate an SSRS report that focuses on the analysis of medical test results. Your work will contribute to crucial data examination to aid our operations. Key tasks will include: - Building an SSRS report for data analysis using SQL stored procedure or cursor or any other mechanism as per requirement - Incorporating medical test results in the report Ideal skills and experience: - Proficient in SQL and SSRS report development - Background in handling and analysing medical data - Attention to detail and accuracy - Proven track record of delivering projects on time I'm looking forward to receiving bids from candidates who can show they have the necessary skills and experience for this task.

Looking for a skilled graphic designer who can help me out in creating a professional logo. My company provides lawn care services. The name of the company is Crabtree Lawn Solutions LLC. I like the idea of having a leaf or a blade of grass somewhere on the logo. The "T" in the word Crabtree could even be a tree. The logo will go on a company vehicle. I also want to add the phone number (256-473-9580) to the bottom of the logo. I really like the example logo that I have attached called "Evergreen". Key requirements for this job are as follows: - Color Palette: The dominant color scheme for the logo needs to be a harmony of green, white, and black. These colors should exude a playful and bold character. - Design Style: The designed logo needs to strike a ba...

I would like a "reasonable" (video verified) by the hour price also. long time work. I will assist. seeking a skilled developer to connect Python programs to an SQL database for managing user information. This includes: - Setting up Python-SQL connection to manage data in SQLite format. - Establishing processes to handle specific user information fields such as name, email, address, and additional sales related data. - Efficiently manage user IDs and corresponding variables within Python programs. Ideal candidate should have experience in Python, SQL, SQLite and handling user data. Understanding of GoDaddy website platform is a plus as the digital site for sale is hosted there. Proven capability to generate accurate results and manage sensitive data confid...

We are seeking an experienced freelance developer to create a custom dashboard for analyzing real estate data, specifically rental prices and sale prices. The dashboard will need to aggregate and display up-to-date data ...regulations. Required Skills: Proven experience in web development and dashboard creation. Strong programming skills, especially in Python, JavaScript, and the use of web scraping libraries such as BeautifulSoup, Scrapy, or similar. Knowledge of front-end development technologies for creating user interfaces (UI), such as HTML, CSS, and JavaScript frameworks (React, Vue.js, or Angular). Experience with SQL/NoSQL databases for storing and managing collected data. Understanding of data protection issues and the ability to implement secure practices in application de...

...should be in the interior areas for use by employees. There should also be a kitchen/break room large enough to handle six to eight people seated and one or two full size refrigerators, two microwaves or microwave doors, a dishwasher, sink, pantry, and adequate cabinetry. There should be one or two additional storage areas. One for office supplies and the other for larger items like a Christmas Tree and decorations, cleaning supplies and so on. These two could be combined if efficient to do so. There is also a need for two copier areas. These should not be in separate rooms but should be in the open, possibly in small indentations somewhere with one near the front administrative area and the other further into the space. The will both require small upper and lower cabinetry...

I'm seeking an artist proficient in creating realistic or impressionistic landscape paintings with subjects. We are open to different mediums, though most familiar with oil or watercolor. This is to be given as a wedding present. Project Details: - The painting will be a simplified representation of a moment, showing two people under a distinctive pine tree in with mountains in the background and a bluebird in the tree. - We will provide reference photos, but the final work should be a creative and representational piece. - It should be painted using either oil or watercolor, based on your expertise and comfort level. - Must be delivered by early August. Ideal Skills and Experience: - A portfolio featuring previous landscape or subject paintings. - Experienced in w...

I'm seeking an experienced data engineer with a strong background in...strong background in efficient web scraping techniques and a solid understanding of SQL databases. You'll be harvesting data made up of text and images from a various websites. Details of the task include: 1. **Data Scraping**: Extract text and image data effectively from different sources based on the requirements given. 2. **Database Management**: The scraped data must be stored in a SQL-based database. Knowledge in creating, managing, and manipulating SQL databases is essential for this role. Freelancers who have previously worked in similar projects will be preferred. This is a challenging task requiring a keen eye for detail, a deep understanding of data structures and st...

Budget: 5$ I'm in immediate need of a professional with skills ...free to browse the internet and find the png logos. All the logos provided should be standard sized, transparent background in png format with one color and one grayscale export. I need the following logos: SAP SAP Business Objects SAP Analytics Cloud Microsoft Microsoft Power BI Microsoft Power Apps Microsoft Azure Microsoft Fabric AWS AWS Redshift Google Google Cloud Platform Google Big Query Tableau Qlik Salesforce Zendesk For your application to be considered, please: - Be experienced in creating and editing logos - Include at least one example of a logo for me to see you can edit this properly. Attention to detail and a quick turnaround time are critical for this project. I look forward to your sp...

...Azure App Services, Azure Key Vaults, Azure Storage Accounts, Azure App Insights, Azure AD, Embedded PowerBI, and Kubernetes Advanced knowledge in implementing consumer-grade responsive web designs Advanced knowledge of relational databases, preferably Microsoft SQL Server Advanced knowledge of building SPA web development using React Intermediate to advanced knowledge of CSS pre-processing platforms, such as LESS and SASS Intermediate to advanced knowledge of API and back-end development technologies such as C#, .NET Core, and SQL Server Intermediate to advanced knowledge of performance testing frameworks Experience in using Azure AD security Strong communication skills including the ability to effectively communicate complex technical concepts to non-technical au...

Delivery Project Front-End in Flutter or React Native (iOS and Android) where the customer finds shopping options, selects the payment method, completes the purchase, tracks, and receives the product. Flow with Figma will be provided, estimated at 50 screens. Back-End in NodeJs, SQL Server, or MongoDb. There will be connections with third-party Rest APIs. OAUTH 2.0 Authentication Merchant Portal: Java or React Native where merchants will have access to view orders, delivery control, product registration, store registration, opening hours, employees, vehicles, and other store customizations. In the same Portal, based on the access credential, the company will have the admin console to activate merchant accounts and other functionalities, such as account blocking and ge...

I am seeking a proficient developer experienced with SQL Server Reporting Services (SSRS), ASP.net, and MVC. The project involves the integration of SSRS reports onto a web platform using either ASP.net or MVC. Ideal skills and experience: - Strong understanding of SSRS - Proficiency in ASP.net and MVC - Experience in integrating SSRS reports on web platforms Specific Requirements: - The SSRS reports to be displayed on the web should allow for parameter input. - The parameter input for the SSRS reports will be implemented using internally passing parameters. If you have the desired skills and experience, I'd love to hear from you today.

I'm in need of a seasoned PHP Laravel developer for a project focused on database integration, specifically with MySQL. The core task for this engagement is query optimization. Skills and Experience required: - Profound expertise in PHP development - Familiarity and proficiency in MySQL - Proven track record of successful query optimization I'm looking forward to engaging with highly qualified and responsible individuals for swift, efficient implementation of this particular task.

My project revolves around a MySQL select query that is showing slower-than-desired execution times. I cannot provide the data as it has PII and is very large. Main issue is that for pulling 1 month of data it takes about 3 hours, regardless if it returns 500 rows or 500,000 rows. There is likely a required index that I cannot see. I will be providing 1) The query 2) The Explain Tree 3) The table definition from which it is pulling data.

I'm seeking a skilled Python developer to integrate my local project with a WordPress database. The immediate task involves retrie...the WordPress database in my local project. Key responsibilities: - Create a secure, reliable connection between my local project and a WordPress database using Python - Design and implement an efficient method for retrieving user account information - Ensure the retrieved data is displayed correctly within the local project Ideal skills: - Strong Python development skills - Experience with SQL and WordPress databases - Proven track record of creating database connections and retrieving data - Attention to detail in presenting the retrieved data in a user-friendly format Please note that the project's urgency is high and immediate comme...