Sql query selecting tree data punët
Pershendetje Glen. Jam e interesuar per ndihmen tuaj ne SQL. Do te me duhet ndihma jote ne nje provim neser. A mundeni te me ndihmoni me nje shume prej 10 euro per 1 or e gjysem?
...Wordpress. We have all the contents (text, photos and a draft logo). What I need is: - install Wordpress in Italian on a domain opened by us; - install the theme and the various plug-ins recommended by us; - there will be suggestions on how to use themes and plug-ins recommended by us; - possibly improve or create a logo; - place the logo in the header of the site; - create the "home page" by selecting the best text and the best photos with automatic scrolling (slide); - create the "company" page where there will be texts and photos explaining the company's history; - create the page "products" and / or "services" in which there will be texts and photos that explain the products and services of the company; - create the "gallery&q...
Programing in Dot Net & SQL Server. Visual Studio 2010, SQL Server 2012 Express ose më të avancuar. Modify existing modules, add modules, design interface, Reports...etc
...designer with a knack for minimalism to create an engaging and straightforward logo for my company, Blue Oaks. Here's what I'm envisioning: - Main Theme: A simple silhouette of a large oak tree on a blue background. I’m interested in exploring different shades of blue, so don't hesitate to present a few options. - Colors: Predominantly blue with a contrasting white silhouette. Note: I'm open to suggestions for a secondary color if you think it could enhance the design. - Text & Font: I've no specific font preference. However, it's essential that the company name, Blue Oaks, is visibly positioned under the tree. The font should complement the minimalist style of the logo, and maintain clear legibility at various sizes. Ideal Ski...
I need a simple form that will look goo...form will collect NAME EMAIL CITY PHONE NUMBER phone number will be a formatted 10 digit max, and email will need validation for properly formatted. This will take the data and post it to our existing base and will then revert form back to a page that says success, and then auto redirect to the form page. The form page will look neat and clean and also contain a couple lines of text and our logo. You will use the existing config file to connect to our base, instead of creating a new one. This project needs completed today and should only take an hour to complete. This is to be written in php 8.2 and connected to sql dbase. You will be paid $30 when it is complete and verified to be working on our server. Ping me if you can co...
...to take part in my ongoing web development projects. The main goal of the project is to enhance an existing application. Requirements: - Proficiency in .NET for backend development - Strong experience with Angular for frontend development - Excellent understanding of SQL Server and MongoDB databases - Previous work with DevExpress is essential Your responsibilities will include: - Developing APIs using .NET for enhancing the application - Integrating Angular for improving the frontend - Ensuring seamless operation with SQL Server and potentially MongoDB Ideal candidates should have a strong understanding of web development and be able to contribute effectively to enhancing the current state of the application. The ability to work with a team, meet deadlines and commu...
...implement an Echart tree diagram in our application. Our project has specific requirements that you need to keep in mind: - Customizable node color and style: I need the freedom to customize the color and style of individual nodes within the tree structure. - Ability to handle large data sets: The tree diagram should be able to efficiently represent and navigate through large amounts of data without sacrificing performance. - Interactive features like drag and drop: The diagram should support interactive features such as drag and drop. The main objective of implementing the Echart tree diagram is to help us in: - Visualizing hierarchical data: The tree diagram should help us represent and understand the hierarchical structure ...
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
I'm seeking a proficient data analyst to create a comprehensive Looker Studio report for me using Google Search Console (GSC) and Google Analytics data. Here's what I need: * Consolidation of GSC data and Google Analytics data into a thorough report. * Ability to effectively analyze and interpret this specific data, and capture relevant screenshots. * Unfortunately, I've not decided on the specific GSC and Google Analytics metrics nor the specific screenshots for this project so flexibility and the ability to suggest relevant metrics is crucial. Skills and Experience: * Proficiency in using Looker Studio to generate reports * Extensive experience with GSC and Google Analytics * A knack for data interpretation and analysis * Exce...
Hi, Job Title: Senior Developer - SQL Server Analysis Services Experience : 5+ Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, exce...
I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.
...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....
we are looking for a senior experienced PHP developer with a minimum of 15 years of experience Skills and Experience MUST HAVE: - 15+ years of core PHP development experience. - Proficient in Laravel framework. - highly knowledgeable in php programming and experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - **must be an independent developer, not an agency! - must be able to work on github - lastly making sure platform is mobile responsive Must have experience in social media or multi-user platform, chat system, ecommerce platform *******We will only hire independent freelancer. If you are an agency, if you are a marketing person or project manager and will delegate the work to someone else, meaning, will subcontract the job to someon...
...exploit vulnerabilities in our user login process. - Authorization Controls Testing: We need thorough testing on the authorization controls in place to ensure that only authorized users can access specific resources. - Input Validation Testing: We need someone who can identify any weaknesses in the input validation of our website. This is crucial in preventing common security vulnerabilities like SQL injection and cross-site scripting. Ideal Skills: - Proven experience in ethical hacking and website security testing. - Strong expertise in PHP and web application security - Familiarity with OWASP Top 10 standards - Excellent understanding of user authentication, authorization controls, and input validation - Good communication skills to report and explain findings clearly If yo...
As an online learning provider, I offer a broad range of technical courses. I'm seeking an experienced sales person with an understanding of technical courses to drive the business forward. Key courses: - Web development - Data science - Embedded systems - Cyber security - Digital marketing - Auto CAD - Adobe Photoshop - Robotics - SQL - AWS - Data structures and algorithms Ideal candidate should possess: - Proven sales experience in the e-learning or tech industry
I need an experienced developer to extend my existing PHP SQL driven platform. This project revolves around adding innovative features to the current structure. . Your job will include: - Analyzing the current structure and proposing alterations to accommodate the new functionalities robustly. - Implementing these suggestions after my approval with special emphasis on maintaining the overall performance & responsiveness of my website. To be an ideal fit for this project, you should: - Have previously worked on expanding PHP SQL based platforms. - Be capable of producing detailed project proposals. Apply with your most detailed project proposal, including your understanding of this task, estimated timeline, milestones, and why you think you're suitable for this...
...Development needed to accommodate the expected volume of registrations Development to prevent IP bans Detailed feature description: Member Login Sign-up Permission assignment Individual inquiry Immediate rank crawling Tracking target management Individual input Bulk Excel upload & download Keyword-based crawling On/Off Deletion Background crawling of tracking targets Naver Place keyword (1 daily query) Rank change history Generate a shareable URL (reset every week) Display in a popup from step 3...
I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in wordpress e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70
I am seeking a database expert who can successfully migrate mixed structured and unstructured product data from Oracle to SQL. This project requires a comprehensive understanding of database architecture, data migration best practices, and extensive knowledge of Oracle and SQL. Key Tasks: - Analyze and understand the structure of existing Oracle database - Prepare a thorough plan for data migration ensuring minimal downtime - Coherently migrate mixed structured and unstructured product data to SQL Ideal Skills and Experience: - Previous experience with Oracle to SQL data migration - Understanding of both structured and unstructured data - Deep knowledge of database architecture and design - Ability to troubleshoot any...
...Tracking: The app should be able to track the shared taxi in real-time, allowing users to know the exact location. - Passenger and Driver Monitoring: I would like the ability to monitor both passengers and drivers for safety and service optimization. User Interaction: Users should be able to request a shared taxi through the following methods: - By manually entering the desired address. - By selecting their location on a map. Additional Information Collection: In addition to basic details, the app should also collect and store the following information: - Full name - Phone number - Profile picture - Email address Ideal Skills: - Experience in developing multi-platform applications for Android, iOS, and Web. - Proficiency in real-time location tracking systems. - Previous work ...
...Collaborate with us to design and develop the platform . Write clean, efficient, and maintainable code. Test and debug software to ensure functionality and performance. Work on constructive feedback. Stay up-to-date with emerging technologies and best practices. Requirements: Proficient in Java, J2EE, Spring MVC, Spring Core, Spring boot and JavaScript. Excellent knowledge of Relational Databases, SQL and ORM technologies (JPA, Hibernate) 5+ years of hands-on experience in designing, developing, testing and maintaining RESTful APIs and Microservices 4+ years of experience in API layer security (e.g., JWT, OATH2), API logging, API testing, creating REST API documentation using Swagger and YAML or similar tools Work on multi-threading and optimize performance for complex systems. ...
I am looking for a detail-oriented writer to help me create a comprehensive Industrial Experience Report highlighting my internship at Electrical Shelf - an electrical engineering firm. I would like the report to focus on the following aspects: - Electrical system design: This includes designing circuit diagrams, calculating power requirements, and selecting the right components. A good understanding of electrical engineering principles and practices will be required for this. - Switching board assembly: This involves understanding wiring diagrams, troubleshooting electrical faults, and ensuring proper insulation and safety measures. Experience in handling electrical assembly tasks will be beneficial. - Problem-solving techniques: My internship entailed regular problem-solv...
I'm experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you've dealt with this before, you're t...
...19c database through JDBC. The primary goal of this project is to incorporate essential data operations into the application, mainly including reading, writing, and updating data in the database. Key Responsibilities: - Establishing a secure connection to an Oracle 19c database using JDBC. - Implementing CRUD operations (Create, Read, Update, Delete) features within the application. - Ensuring the application is optimized for efficient data handling and processing. Security Requirement: - The application must be able to securely access the database using username/password authentication. Ideal Candidate: - Proficient in Java and Springboot framework development. - Experienced with Oracle database SQL and JDBC connectivity. - Prior experience in implementi...
I'm currently seeking an Oracle SQL developer with exceptional proficiency in creating logics. This task requires: - Writing an SQL code for data extraction purposes. - The code needs to be written as quickly as possible, with a time frame of 1-2 hours. - The solution should deal with the joining of multiple tables and creating doing some further order by, group by codes Decent knowledge of Oracle and experience in handling similar tasks would be ideal for success in this project. Your ability to deliver accurately and timely will be greatly valued. The code should be written using simple statements. I am not sure how to set up a connection to our datapool though. I can show couple of other related codes that can help
...experience - User-friendly design that is accessible and engaging for beginners - The ability to track user progress and provide feedback If you have a passion for teaching and a strong background in machine learning, I would love to hear from you. Please provide examples of similar work you have done in the past. #Machine Learning Algorithms# -Linear regression -Logistic regression -Decision tree -SVM algorithm -Naive Bayes algorithm -KNN algorithm -K-means -Random forest algorithm -Dimensionality reduction algorithms -Gradient boosting algorithm and AdaBoosting algorithm #Types of Machine Learning Algorithms# -Supervised Learning -Unsupervised Learning -Semi-supervised Learning -Reinforcement Learning I need totally 14 article. Each article must consist of 1500 words. Pyt...
...integrate a Dymo printer into my system. Here's a breakdown of the project: - **Integration**: I need the Dymo printer to work seamlessly with my Access 2013 database. The goal is to automatically print stock labels based on query results. This means you'll need to set up the system to take the query output and send it to the printer for label creation. - **Printing Specifics**: The labels I need printed are stock labels. The process should be automated, so the labels are generated and printed without manual intervention. The labels will be printed based on the results of a query in Access and some limited entry from the operator with such things as qty of labels and which of 2 labels (it's the DYMO LabelWriter 450 Turbo) with slightly different fie...
...information into work orders. A direct connection to our SQL server is essential. The app should have the following key features: - Access and view work orders: Our employees should be able to easily browse and access the work orders. - Update work orders: A functionality to update the status of work orders is pivotal. - Add additional information: The app must also enable employees to input further necessary information into the work orders. Minimum qualifications include: - Proficient in app development. - Familiarity with SQL for direct server connection. - Prior experience building work order or similar task management apps. Ideal candidate has worked on projects requiring direct connection to SQL server for real-time data access. Prior experien...
I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70
I'm looking for a skilled professional who can help me with a data analysis project. The project includes a variety of tasks such as Index Development and Justification, Data Selection, data cleaning, Multivariate Analysis, Normalisation, Weighting and Aggregation, Link to Other Indicators, Visualisation of Results, and Version Control. Skills/experience required: - Proficiency in data analysis techniques - Experience with data cleaning and normalization - Strong knowledge of multivariate analysis - Ability to create visual representations of data - Experience in version control of analytical work The specific data you'll be working with is open to your choice. Your expertise in selecting, cleaning, and analyzing the da...
...assist me with a combination of SQL and Python tasks. - SQL: I need help with SQL in three specific areas: 1. **SQL Syntax:** Assistance with basic SQL commands, especially in working with subqueries. 2. **SQL Queries Optimization:** You should be able to optimize SQL queries for data retrieval accuracy. Your goal should be to ensure that the data collected is as accurate as possible. 3. **SQL Database Design:** You should be able to assist with database design, ensuring proper schema design and normalization. - Python: While the primary focus is SQL, some tasks may require basic Python knowledge. If you are proficient in both SQL and Python, even better. **Ideal Skills:** - Strong understanding...
Deliverables - Full fledged and mobile app (ios&android) with admin backend pannell. - Nearby Store locator - User can place a order with the combination of 3 (ex. Customer will chose part 1 of order from the multiple options, after selecting part 1, user will choose part 2, then part 3 from multiple available options and each item from each part will include individual cost and after choosing all 3 combinations it will be redirected to checkout page which includes all the details of selected items including cost breakdown, afterwards to payment page. - Web and app includes trending section, offers sections, trending designer collection section. - Blogs. - Gift cards. - influencer affiliate program. - Basic pages such as, contact us, about us, customer support, tracki...
I'm seeking an experienced web developer to migrate my existing website (approximately 50 pages) to WordPress. The main goal of this migration is to improve the site mana...recommending and integrating proper security plugins. - Implement performance optimization plugins to enhance the overall functionality and speed of the site. Ideal Skills and Experience: - Proven experience with website migration to WordPress, including content, functionalities and features. - In-depth knowledge of SEO best practices and experience with SEO optimization plugins. - Proficiency in selecting and integrating security plugins for WordPress. - Experience with performance optimization plugins, ensuring the site loads quickly and functions smoothly. Please outline your experience and approach in...
I'm looking for a skilled professional to help me create an introduction video about family tree with audio & video editing, Key Requirements: - The main goal of this project is to visualize family tree & relationships in a digital format. - I want the family tree to be interactive, with some engaging features that can help viewers understand the relationships more effectively. Ideal Skills and Experience: - Experience in video editor
I am in need of a professional with experience in SQL Server, ODBC and Quickbase pipeline to assist me with data integration. Job Duties: - Connect my SQL server via ODBC - Utilize Quickbase Pipeline and on-prem gateway for seamless integration Preferable Skills and Experience: - Strong understanding of SQL Server and ODBC - Experience with Quickbase pipeline and on-prem gateway - A history of successful data integration projects, particularly with transaction data Credentials: -I have all the necessary access rights and credentials to my SQL server. I require your expertise to navigate the technical process. Your responsibility would be solely the technical integration. No data management or further SQL Server maintenan...
I'm seeking a talented designer to help me with the creation of a product design portfolio. The main goal of this portfolio is to showcase my previous work. The projects I've worked on have been predominantly in the area of product design. Key Requirements: - Designers with experience in creating portfolios that feature product design projects. - Skills in selecting and arranging images to effectively tell the story of each project. - Expertise in creating visually appealing image galleries. The portfolio will be the main tool I use to display and share my past work with potential clients, so it is crucial that it is well-designed and leaves a lasting impression. It should be able to capture and represent the quality, innovation and uniqueness of my work. Please share...
Seeking an experienced PL/SQL developer to assist with multiple tasks in my project. This includes: - Oracle database management - XML table manipulation - JSON parsing - Dynamic SQL operations - Development of PL/SQL objects - Utilization of collections and arrays in PL/SQL The project will also involve intricacies such as: - Error handling and exception management - Performance optimization - Crafting of database triggers and stored procedures - Harmonious integration with other systems - Performing data migration and transformation tasks Ideal freelancers for this project should be adept in PL/SQL and Oracle development, with particular skill in SQL*Plus and PL/SQL Developer tools.
I am looking for ...scope of work includes web applications, mobile applications, and desktop applications. Key Responsibilities: - Identify and correct various security vulnerabilities specifically: cross-site scripting (XSS), SQL injection, and session hijacking. - Devise strategies to enhance the security of all our applications. - Regularly conduct security checks to identify potential threats. Ideal skills: - Proven experience in securing different application platforms. - In-depth understanding of XSS, SQL injection, and session hi-jacking. - Comprehensive knowledge of network security and data protection. I need someone who is adept in application security to safeguard our digital assets. Your expertise will play a fundamental role in establishing the secur...
I'm in need of a highly skilled WordPress professional to oversee my website and guide other developers. Your primary responsibilities will include: - Providing general support and answering any questions that arise - Assisting with theme customization to ensure a visually appealing and user-friendly design - Creating and editing content to engage with my diverse audience - Selecting and setting up plugins to enhance the website's functionality As my target audience is broad, including the general public, business professionals, and specific niches, I need someone who can tailor the site's content and features to suit their needs. Your role will be crucial in ensuring a seamless and optimal experience for all users. The ideal candidate should have a deep understand...
...- Creation: The plugin should enable the user to create quizzes. Please advise on the best quiz type to use. - Embedding: The plugin should allow for easy embedding into website pages or blog posts. Being able to place the quiz in a sidebar widget would be a bonus. - Interaction: I am open to different ways for users to interact with the quiz, either by clicking on options, typing answers, or selecting from dropdown menus. Your insights on the most user-friendly option are welcome. - Management: The plugin should provide an interface to manage the quizzes. Ideal Skills and Experience: - Experience in creating interactive quizzes. - Strong UI/UX design skills for user-friendly interaction. - Excellent communication skills for explaining the best approach for quiz creation. Scre...
...- Creation: The plugin should enable the user to create quizzes. Please advise on the best quiz type to use. - Embedding: The plugin should allow for easy embedding into website pages or blog posts. Being able to place the quiz in a sidebar widget would be a bonus. - Interaction: I am open to different ways for users to interact with the quiz, either by clicking on options, typing answers, or selecting from dropdown menus. Your insights on the most user-friendly option are welcome. - Management: The plugin should provide an interface within WordPress to manage the quizzes. Ideal Skills and Experience: - Proficiency in WordPress Plugin Development. - Experience in creating interactive quizzes. - Strong UI/UX design skills for user-friendly interaction. - Excellent communication ...
...This includes familiarity with text classification, sentiment analysis, and machine learning models that handle language data. 3. **Software Development Best Practices**: Understanding of software engineering principles, such as version control with Git, continuous integration/continuous deployment (CI/CD) practices, and agile development methodologies. 4. **Problem-Solving Skills**: Ability to troubleshoot and improve upon existing code, optimize application performance, and solve complex software development issues. 5. **Data Management Skills**: Proficiency in managing and manipulating large datasets, understanding database management, and possibly experience with SQL or NoSQL databases. 6. **UI/UX Design Experience**: Knowledge of creating user-friendly inte...
As an experienced PL/SQL user, I am looking to collaborate with a seasoned developer to help further scale my project. The role primarily involves: - Building novel PL/SQL procedures - Innovative database architecture and design You would be perfect for this job if you can demonstrate: - Extensive background in PL/SQL - Expertise in database architecture - Experience in crafting innovative procedures The tasks will encompass: - Data manipulation - inserting, updating, and deleting data - Data retrieval using the 'select' function - Implementation of integrated business logic I am excited to see how we could improve database structure and efficiency together.
Having an integral project already in place, I'm in need of a skilled SQL Developer to contribute towards its further development. Specifically, the tasks I require assistance with include: - Query Optimization: Tailoring and enhancing the performance of our current queries is a significant aspect of this role. - Database Maintenance: Maintaining the overall health and efficiency of our SQL Server is also a necessity. Ideal candidate must have a comprehensive understanding of SQL Server, as well as notable expertise in query optimization and database maintenance. I prefer someone with a proven track record of successfully managing and enhancing existing projects. I look forward to seeing your bids.
...understand their vision, preferences, and requirements for the renovation project. - Assess the current layout of the main floor and propose alternative layouts that optimize space utilization and flow while preserving the heritage charm of the home. - Provide design concepts and visualizations to illustrate proposed layouts, including floor plans, 3D renderings, and mood boards. - Assist in selecting appropriate design elements, materials, finishes, and fixtures that reflect the Craftsman style and complement the historic character of the home. - Offer guidance on furniture arrangement, lighting design, color schemes, and decor to enhance the overall aesthetic appeal and functionality of each space. - Work within budget constraints and provide recommendations for cost-effective ...
...skilled professional who can help me with an exciting object detection project using LiDAR data. This project primarily involves: - Implementing object detection algorithms on LiDAR datasets. - The detection should be detailed, focusing on specific models like car models and tree species. - The detected object data will be used for research and development, aiming to refine and improve current detection algorithms. The ideal candidate for this project should have: - Strong background in LiDAR data processing. - Proficiency in object detection algorithms, particularly for LiDAR data. - Experience in working with detailed object detection, such as specific models. - Ability to use the detected object data for research and development purposes....
I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.
