Simple sql query 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?
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
Desgin an Admin Theme for simple HTML Web Site
...Existing Environments. Maintain Documentation For System Processes And Procedures. Participate In Code Reviews, Contribute To Team Knowledge, And Mentor Junior Developers. Required Skills: Strong Proficiency In Perl Scripting And Python Programming. Experience With XML Technologies, Including XML Parsing And XSLT Transformations. Good Understanding Of Relational Database Management Systems And SQL. Excellent Problem-Solving Skills And Ability To Think Analytically. Strong Communication And Interpersonal Skills, With An Ability To Communicate Complex Concepts To Non-Technical Stakeholders. Additional Qualifications: Experience With Web Technologies (HTML, CSS, JavaScript) Is A Plus. Familiarity With Software Development Methodologies Such As Agile/Scrum. Perks And Benefits:...
I'm in need of a skilled freelancer to set up and install Primavera P6 EPPM 21.12 locally on Windows. This is a single user setup, with SQL database configuration included. Key Tasks: - Install Primavera P6 EPPM 21.12 on a Windows system - Complete and configure the SQL database for the software Ideal Freelancer: - Experienced with Primavera P6 EPPM installations - Proficient in SQL database setup and configuration - Understands the intricacies of Windows OS - Prompt and clear in communication
...address and make a payment. Rating page. Users will be prompted to login before accessing this. Star ratings will be filled in here, and the welcome text will have each users [first_name]. Generate a custom QR code to a rating page with pre-filled order number (unique identifier from above) Order confirmation email. With animated banner and QR code. SQL database. All data from the users, questionnaires, orders, and ratings will be stored in a postgres SQL. I have specified the database design (see below). Currently there is no API to warehouse/shipping (postage of orders are handled manually, but please set up the database with the future API integrations in mind). Manual order (in backend). Basically, I want to be able to look at the sample ratings for each sample order a...
We need an online Virtual assistant to help us with our company tasks such as social media posts, research data entry etc... The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role.
I require an expert in both C# and AWS to build a AWS Lambda function using .Net Core. The function should create a simple message in the SQS queue. The deliverables should include: 1. AWS Lambda Function: The AWS Lambda function should be capable of both Asynchronous processing and Dead letter queue. It should be written in C#. 2. Serverless Template: A serverless template is required that will be used by our gitlab pipeline to create the queue on AWS account. This template should be comprehensive yet efficient. 3. Gitlab YAML: Lastly, a gitlab yaml will be needed to facilitate the Lambda's deployment. Ideal Experience: - Highly skilled in C# programming - Extensive experience using AWS services - Familiarity with serverless templates - Understanding of Gitlab YAML for depl...
I'm in need of a skilled .NET developer to create...additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While this is currently marked as 'unsure', the ability to handle this efficiently would be a plus. Ideal Skills: - Proficiency in .NET development - Strong knowledge of SQL databases and data management - Experience in user authentication and registration systems - Previous work involving user role and permission management - Flexible to adapt and integrate external systems when required If you're a skilled .NET developer with a track record of creating user-centric web applicatio...
We are seeking a remote administrative professional to daily post job listings on LinkedIn. Key Responsibilities: - Daily job posting on LinkedIn, One job post per day. - Ensuring all necessary details and requirements are included Ideal Skills: - Strong administrative background - Excellent written communication skills - Detail-oriented with a focus on consistency This Task is easy and simple only takes few mins per day, also good for those who are starting out as freelancers and want to build their profile. We will provide all the necessary steps to follow so anyone can apply.
I'm in need of an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project sho...
I'm in need of a skilled web developer highly experienced in both Angular and Javascript. The primary objective for this project is to create a website with a responsive design that aligns with my provided brand guidelines. Key Qualifications: - Proficient in Angular and Javascript - Extensive experience in responsive design - Extensive experience in .Net Core and SQL Responsibilities: - Adhere to design and branding guidelines during web development - Create a website that is user-friendly on all devices. Please ensure to provide examples of past work with responsive web design during your application.
Description I have a small Node/Docker application which does not work if the MongoDB library is included. Structure of the application is: Node Express application - Exposes a few simple test API endpoints. Docker - The Node application runs in a Docker container MongoDB Atlas - Currently this is *not* included but it is the objective of this work. I want the Node application to make a connection to MongoDB using the *native Mongo* driver. NOT Mongoose. NodeMon - Project is setup with file monitoring to save development time. Also, the Visual Studio debugger is enabled and appears to be working well. Here is a link to a Visual Studio project which contains a test version of the application error. It has had files removed for security and to reduce the file size. Here&rs...
...applications, with the aim to identify and eradicate any potential vulnerabilities. Key Tasks: - Perform Open Source Intelligence (OSINT) - Port scanning - Man-in-the-middle (MiTM) attack simulation - Focus intensively on injection attacks (SQL, XSS) - Authentication and session management puncturing - Cross-Site Scripting (XSS) evaluation The ideal freelancer will have: - Strong experience in cybersecurity and penetration testing - Excellent knowledge and experience with Linux-based systems - Proven experience in web application security testing - Firm understanding of SQL, XSS and authentication vulnerabilities Your final deliverable will be a complete penetration testing report, detailing vulnerabilities found, their potential impact, and recommended remediation step...
I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing
I'm looking to create a basic, static website that's solely for educational purposes. Here's what I'm seeking: - Content: The site will contain a mix of tutorials, courses, and resources for students. - Design: A clean, user-friendly design that makes accessing and engaging with the educational material easy. - Functionality: I don't need any advanced features like e-commerce, but the site should be responsive across devices. Ideal skills for this job include: - Proficiency in web development, particularly building educational websites. - Strong understanding of user experience and interface design for educational purposes. - Ability to create a clean, minimalistic design that aligns with the educational content provided. I have a budget of $10 - $20 so if ur wa...
...processes it in Wordpress. The Incremental link makes a POST request to this script containing the data. In the script you see 3 types of actions in a switch: Add (new vehicle) Change (vehicle exists, adjustment is being pushed) Delete (vehicle is deleted) Below is a brief explanation of the three functions involved: add_post Here I build a Wordpress Query containing data from the POST request. Then I run a "wp_inset_post" function with this query. From that Wordpress function you will then receive a "post_id" with which I will add photos to the post. change_post Same as "add_post" but I use the "update_post" function because I already know the post_id. Then I'll delete all the photos from this post and add them again. I do ...
I'm in need of a 3D designer specializing in product designs. The task involves creating small and simple 3D models, suitable for different applications. Though the intended use of these designs is unspecified, the final output should be of a quality that could be used in marketing materials, manufacturing, or for prototype testing. Key requirements: - Expertise in 3D modeling and designing. Prior experience with product design is a plus. - Ability to create small and simple 3D models efficiently. - Strong understanding of design principles and aesthetics.
Description: We are in need a fresher candidate who handle bulk email sending tasks. Requirements: Basic familiarity with email writing. Responsibilities and Frequency: Sending bulk emails twice a week. Timeline: No strict deadlines, but consistent quality work is essential.
...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
Preciso uma programação para SQL donde será trocados dados sensíveis entre clientes y um vendedor. Esta exigido encryption. A aparência dos dados deve ser com boa visão geral e também com busca fácil na base de dados. A SQL deve ser conectado no front end também para o público unidirectional de mandar ficheiros.
I'm searching for an experienced app developer to create a basic iOS application that calculates sales commissions. Functionality: - The app should be constructed to input five distinct values: Sales amount, Commission rate, Material Total, Labor Total, Par Sale after Discounts. - The application should compute the commission based on the percentage of the Sales amount. - The method of calculating the percentage in relation to the other input values has not been specified, so flexibility and adjustability should be built into the app to address this. You enter the total cost of materials and labor separately plus the current commission rate. Then you choose from calculated values what discounts can and will be applied. The you enter the actual agreed upon sale price. The attac...
...not receive any pre-existing design templates such as Figma, but you may refer to a competitor's website for inspiration. The goal is to build a platform that efficiently categorizes Telegram channels and groups by country and category, facilitating easy navigation. This website will be developed using React, Node.js, and PostgreSQL. It must be fast, secure against common web threats including SQL injections, Cross-Site Scripting, and IDOR's. It should also be optimized for search engines to achieve high visibility online. Key Features of the Website: * Channel and Group Organization: Separate listings for channels and groups, categorized by countries and specific categories. * Search Functionality: Advanced search options allowing users to find channels and groups...
I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing
I'm looking for a skilled freelancer with considerable experience in Angular, especially Angular 17. The project is relatively straightforward as it features a basic UI with few functionalities and does not require any integrations. Although the primary function of the site has not been made explicit, an understanding of a variety of site purposes, including informational, transactional, and interactive sites, is beneficial to ensure flexibility throughout the project. Ideal Skills And Experience: - Proven experience with Angular, particularly Angular 17 - Ability to create a seamless and user-friendly UI - Strong knowledge of Keycloak - Versatility to adapt to different site purposes - Excellent problem-solving capabilities - Meticulous attention to detail.
I need new website for company . 5 pages .
I'm in need of a Spark Developer who has a good, intermediate level competence in Scala. Your primary task will include: - Processing and analyzing structured data similar to SQL databases. Given the nature of this project, prior experience with data processing and working with SQL databases would be a huge advantage. While performing machine learning algorithm implementation or real-time data streaming isn't explicitly required, any exposure to these areas would be beneficial.
I'm looking for a skilled ASP .NET web developer to work on a small project. Key requirements: - Fullstack development: The project involves both front-end and back-end development. The ideal candidate should be proficient in C# and ASP .NET. - Database Integration: The project will be using SQL Server, so experience with this database type is needed. Skills required: - Proficiency in C#, ASP .NET, and SQL Server - Experience in fullstack web development - Strong understanding of database integration and management Your role will be to take the project from concept to completion, ensuring that all elements are well-integrated and functioning smoothly. If you are a reliable, detail-oriented developer with a strong track record in ASP .NET web projects, I'd love to...
...learning. Strong analytic skills related to working with unstructured datasets. Experience with big data tools: Hadoop, Spark, Kafka, etc. Experience with data pipeline and workflow management tools. Experience with AWS cloud services: EC2, EMR, RDS, Redshift. Experience with object-oriented/object function scripting languages: Python, Java, Scala, etc. Proficiency in SQL and experience with relational databases, query authoring (SQL) as well as familiarity with a variety of databases. Excellent problem-solving skills and ability to work independently or as part of a team. Strong communication and collaboration skills to effectively work with teams across the organization. What We Offer: Competitive salary and comprehensive benefits package. Opportunities for prof...
...secure authentication practices, such as password hashing and the use of access tokens, to prevent unauthorized access. 5. Input Validation and Sanitization: To mitigate the risk of security vulnerabilities, the application will implement strict input validation and sanitization techniques. This section emphasizes the importance of validating user input to prevent common vulnerabilities, such as SQL injection and cross-site scripting (XSS) attacks. 6. Secure Transaction Processing: The application will incorporate secure transaction processing mechanisms to ensure the integrity and confidentiality of financial transactions. This section discusses the implementation of secure communication protocols, such as HTTPS, to protect sensitive data during transit. It also highligh...
...JavaScript framework (React, Angular, Vue.js) considering factors like project complexity, team expertise, and desired features. Back-end: Select a server-side technology (Node.js, Python with Django/Flask, PHP with Laravel) based on performance requirements, scalability needs, and developer familiarity. Database: Choose a suitable database (MySQL, PostgreSQL, MongoDB) based on data structure, query complexity, and scalability requirements. Other Considerations: Authentication/authorization, payment processing (if applicable), CMS (if needed). 3. Development Process: Front-end Development: Implement the user interface and user experience using your chosen framework, following component-based architecture for maintainability. Back-end Development: Build your server-side APIs usin...
I'm looking for a professional who can assist me with certain multimedia editing tasks. The work involves adding text, incorporating a logo, and trimming videos. Though I didn't specify the type of logo, it will be a standard, text-based, or image-based one. Ideal skills and experience: - Proficient in editing multimedia content - Capable of incorporating logos into videos - Skilled in adding text effectively - Experience with trimming videos - Ability to work flexibly with different types of logos Please reach out if you think you can help me with these tasks.
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 have a simple data entry project. Watch the explainer video. excel file to enter into is attached to the project
I'm looking for a proficient SQL professional with notable expertise in SQL Server 2019. Key tasks will involve: - Query optimization - Database design - Data migration The ideal candidate should have a solid understanding of SQL Server tools and a proven track record in handling similar projects. Your previous experience and knowledge of SQL Server 2019 will be pivotal in this role. Your task will be primarily centered around maximizing the efficiency and effectiveness of the SQL Server. Preference will be given to professionals with certifications in SQL Server 2019 or related fields. Solid written and verbal communication skills are desirable.
...understand and implement complex backend features in my apps. - Firebase rules: A good understanding of how to set secure and efficient rules in Firebase is essential. - State management: I need to understand advanced state management techniques in FlutterFlow. - Data handling: I need to learn how to efficiently handle data within my applications and understand the best practices. I am a veteran PHP SQL developer and I find it difficult to wrap my mind around nosql and mobile app development in general. I am looking for: - An individual with advanced knowledge and experience in FlutterFlow. - Someone who can teach effectively in a one-on-one setting. - A patient mentor who can break down complex ideas into easily digestible concepts. - IMPORTANT: we need to understand each othe...
As an exper...experience in Laravel and you're familiar with Laravel 11. • You've previously developed websites using Laravel 11. • Your forte is optimizing code efficiency and database queries. • You have a strong understanding of how to improve page load times and database query speed. Your task: • Optimize my existing codes in Laravel 11, for open source project • Main areas for optimization include database queries and code efficiency • The goal is to achieve faster page load times and improved database query speed. • Test subscription and plans, if it works fine or not Please, only apply if you have the mentioned skills and experience and you're able to demonstrate evidence of past projects you've optimized for p...
Buscamos incorporar especialista programador .net freelance con conocimientos en: c# .net, asp, sql server se valorará experiencia en: integraciones api, en back-end y front-end. Trabajo principalmente en remoto, para colaboración continuada en desarrollos propios de nuestra empresa, con un mínimo de 40 horas mensuales.
...to work with. We now want help to create some new features. - We want to have a droplist with all the variants of The Configurable Product but still keep the original texts and links for the Simple Product. The Configurable Products is hidden and we only want to show each Simple Product separately, but inside the Simple Product there should be a droplist with all variants. When you select a variant, we want you to be redirected to chosen Simple Product. So we need a function that checks if the product is linked to a Configurable Product but retrieve a list of links to all the interconnected Simple Products. We will need help with more things but we can start with these to move the project forward. Do not write to us if you have never worked with...
I'm in need of a simple yet robust Android app for my workshop. The ideal candidate for this project should have experience in developing efficient and user-friendly applications for Android systems. Key Functions: - The app should provide a seamless offline experience, while also being capable of working online. - The primary features of the app should focus on creating and sending invoices, as well as generating vehicle inspection reports. The app should be designed to be intuitive, practical, and user-friendly. It should streamline the process of managing invoices and generating vehicle inspection reports, making it an essential tool for our workshop. Ideal Skills and Experience: - Proficiency in Android app development - Prior experience with creating invoicing and repor...
As a startup in AI and AI/ML solutions, we are seeking a part time senior data scientist to help us to design a text 2 sql solution using existing open source solution, integrate with other data service. Having a deep understanding of ,LLms , NLP, Text2SQL and AI Agent (OpenAI) , stream-lit will be essential. 3 hours days in average for a part time jobs for months; - The successful applicant must be fluent in Python and have a solid understanding of latest GPTs, GenAI and langchain, GenAI etc The ability to develop and fine-tune algorithms as per project requirements is paramount. If you are able to make AI comprehend and utilize human language, efficiently and effectively, your expertise is needed here.
I am in need of an exp...developer to create an interactive, transactional platform with the ability for information sharing, social interaction, and query resolution. This platform should be accessible both as a mobile app and a website, with seamless functionality across Android, iOS, and various web browsers. The ideal candidate for this job would have the following skills and experience: - Expertise in both app and web development, with a portfolio of interactive, transactional sites/apps. - Experience with Android & iOS app development. - Understanding of user experience, particularly in relation to e-commerce and social networking. - Proven problem-solving skills in the area of query resolution. Please provide examples of your work and detail your experience w...
I'm seeking a skilled Java and MySQL developer to assist me with two exercises from a training course. Here's a more detailed explanation of the job: - The exercises are centered around Error Handling and Debugging, along with Array and String manipulation and Exception handling. It's crucial that you are well-versed in these areas. -Since this is a learning exercise, I would appreciate it if the code included detailed comments and explanations. Please see the document attached for full details before bidding. Please apply only if you have experience and confidence in these areas.
...accomplished Power BI and DAX expert who can help me develop a comprehensive dashboard for data analysis. Key Responsibilities: - Create a data analysis dashboard in Power BI that is user-friendly, visually appealing, and easy to interpret. - Establish reliable connections to SQL databases to pull in the necessary data. - Implement DAX functions and calculations to ensure accurate data analysis. Ideal Candidate: - Previous experience in developing Power BI dashboards for data analysis. - Proficient in working with SQL databases and connecting them to Power BI. - Strong knowledge and understanding of DAX functions and calculations. - Excellent communication skills and ability to work collaboratively. The current data is being updated manually, so a part of this project ...
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 need a Full Stack Developer comfortable with React, Sass, .NetCore, and SQL Server to work on my website, web application, and mobile/desktop app. The primary goal of this project is to develop a responsive, high quality website that also functions as a web application, with the potential for further expansion into mobile and desktop applications. We are looking forward to have a complete Computerized Maintenance Management System (CMMS) / Maintenance Work Order(MWO). A Complete Control Pannel on Web based asapplication along with the Mobile APP + Desktop APP. With the below added features.:- + It will have Website Fully responsive, Mobile APP, Control Pannel Application + It must fully SAAS Based means related to the SAAS Based all the screen to be designed and implemented +...
