Pl sql queries for practice 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
Graphic design, also known as communication design, is the art and practice of planning and projecting ideas and experiences with visual and textual content.
I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration
I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.
I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, acco...log in securely. - Profile Management: Agents should be able to edit and manage their profiles. - Commission Tracking: The system should track and calculate commissions for each agent. The specific functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL ...
...looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Setting up ActiveMQ for JMS messaging - Configuring it to handle synchronous and asynchronous messaging effectively Furthermore, I plan to utilize SOAPUI Open Source for automated testing of these messages. Your role will be essential in ensuring that the system works seamlessly with this tool. I will be expecting below: Create a framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for...
Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database
I'm seeking a skilled draftsperson with expertise in Autodesk Inventor to create a small-sized CAD design alon...with expertise in Autodesk Inventor to create a small-sized CAD design along with recorded video of a bush with internal grooves specifically for lubrication. This design will be optimized to reduce friction, thereby enhancing its overall performance. 2) 2nd cad part as well recorded video Unfortunately, details regarding the bush's durability weren't disclosed, but proficiency in creating this critical machine part is essential. Ideal candidates should have: - Proficient knowledge of Autodesk Inventor. - Expansive experience in mechanical drafting. - Excellent understanding of part function and performance improvement techniques. - Pragmatic practice...
I'm in need of a highly skilled and advanced CISSP trainer for on-prem training in Kuwait. The training will be for a small group of 1-10 participants. The ideal candidate should be able to provide the following training materials: - Comprehensive printed manuals and handouts - Digital copies (PDFs, slides) for participants to refer to post-training - Practice exams and quizzes to help reinforce learning and assess understanding The trainer will be expected to travel to Kuwait for this assignment. Experience in providing CISSP training in a physical setting, particularly in the Middle East, would be a significant advantage. The ideal candidate should be able to deliver complex CISSP concepts in a clear and engaging manner, ensuring participants can ...
I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentatio...
As a newly established cyber company, I am looking for a skilled web developer to create an lead generating and informational platform for our business. This website will serve as our primary tool for selling our services and solutions online. Key Features: - The most crucial feature of this website will be the Contact Form. It is vital that potential clients can easily reach out to us with queries or service requests. Products/Services: - The primary focus of the website will be to sell our services and solutions. Therefore, the website needs to be designed in a way that effectively showcases our services and solutions and makes it easy for customers to engage with them. Ideal Skills & Experience: - Proficiency in lead generating website develo...
Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.
...assist me with my project. I'm looking for a PHP expert who can aid in the development of a web application, website, or mobile app. You should be proficient in both front-end and back-end development, capable of crafting user-friendly interfaces and integrating complex functionalities. Your role will involve: - Understanding project requirements and delivering high-quality work - Developing secure, efficient, and scalable code - Implementing user authentication, integrating databases, and possibly setting up payment processing systems - Ensuring timely and reliable completion of the project If you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this project is for you. Your abili...
I'm looking for an experienced Python coder to tackle two key aspects of my project - data analysis and automation. Here's a breakdown of the requirements: - **Data Analysis**: The primary task involves analyzing datasets in CSV format. The selected candidate should be adept with NumPy, able to make sense of the data and derive meaningful insights. - **Automation**: The second crucial aspect is automation. I'm looking to automate certain processes in my project that involve database queries. Proficiency in Django will be necessary here. Ideal candidates for this project would have: - **Strong Python Skills**: You should be well-versed with working on data analysis and automation tasks using Python. - **Experience with NumPy & Django**: Proficienc...
I am looking for an experienced and skillful data analyst or statistician who can help me present a detailed paper explaining data analysis techniques, with a special emphasis on Multivariate Test Effect Pillai's and Descriptive Statistics. what I need in this project is to explain for me how and why the calculation is done in this way in the paper that I will provide you later on so the statistic analysis is already done. I only need the explanation for my own understanding. So is there any possible way that we can conduct this explanation exercise today The target audience for this paper are academics and researchers, therefore, the tone and depth of the content should accommodate this group effectively. The ideal freelancer should have: - A strong ...
I'm seeking 2-5 experienced tele callers who can effectively communicate about commercial real estate properties. The ideal candidates should possess: - Strong communication skills in English - Proven experience in the real estate sector, particularly with commercial properties - Exceptional phone etiquette and persuasion skills - An ability to handle client queries professionally Your primary task will be reaching out to potential clients to discuss our available commercial real estate listings. Please submit your proposal highlighting your related experience and successful projects.
...issues with the search bar on my site. It suffers from slow loading speed and provides irrelevant results, causing a less than ideal user experience. The existing search feature has been built using PHP. To improve the functionality and user satisfaction, I'm seeking a professional with vast experience in PHP who can implement critical improvements. - Autocomplete Function: For faster and user-friendly search queries, incorporate a reliable autocomplete function. Having this feature can save users' time and enhance the browsing experience. - Enhanced Filtering Options: Alongside the autocomplete feature, the search bar needs to have advanced filtering options to serve the most relevant results to the users. This will not only speed up the site navigation ...
Hi I'm about to advertising a learning course. I will be delivering the course by zoom ov...course materials, and interact with the course participants. A draft of the course information is attached. I'm looking for a freelancer who can support me with my Moodle platform. I have never used moodle before, so I need help with installation and setup, and ensuring that our required functionality is possible. I am working with an assistant and we both need to be able to access the participant forums to respond to queries, and to upload and receive materials. Please provide a succinct proposal, and an expectation of how long this would take. I am after a very simple solution at this stage, as the moodle element is only for communicating with participants, ...
I a...looking for a graphic designer to create the header of my prescription paper. I'd like the header to include: - My name and credentials - The name and address of my clinic - Contact information including phone number, email, and website - Basically, I have attached a sample Heade File, the data I need is the same as given. Need very clear and vibrant design, latest design. Doctor name font should be very standard and clear. The header should be designed to fit an A4 paper size. I don't have a specific colour scheme in mind, so you have creative freedom in that aspect. Ideal skills for this job include graphic design and a good understanding of branding and visual hierarchy. The header must look professional and clean, while also having a cohesive design t...
...Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Delivery 3. Collaborative as a team 4. Responsible, Credible, Reliable and Integrity person 5. No agency, only...
...features and requirements: Primary Functionality: - Users should have the ability to create their own accounts, which is crucial for creating a personalized shopping experience and tracking orders. - The app must support in-app purchases, as it is central to the shopping functionality. - Incorporating a live chat feature will enhance customer service, providing users real-time support and interface for queries and concerns. Ideal Skillset: * Strong proficiency in iOS and Android app development. * Past experience designing e-commerce apps. * Experience in incorporating in-app purchases and live chat functionality is preferred. * Knowledge in user-interface design for retail mobile apps. The perfect candidate should have a proven track record in developing...
I'm in need of a web designer and developer who can create a new website for my business. While I have a logo, I don't have a predetermined color scheme. The website will be an information hub about my business, hence no e-commerce functionality is required. Key Features Needed: - Contact Form: The site should have a user-friendly contact form for easy interaction with visitors. - Gallery: A gallery to exhibit my business' work or products is a must. - FAQ Section: An FAQ section is necessary to address common queries and to provide better understanding of my business. As the designer/developer, you'll need to be creative with colors (drawing inspiration from the logo), and ensure that the website is clean, professional, and easy to navigate. Ex...
...carry out multiple tasks: - Answer typical queries - Offer relevant advice - Schedule meetings - Perform any function that is currently possible for it to do verbally The AI chatbot should be compatible with Slack and eventually extend to all phone applications. The chatbot should integrate with a database. We could explore other data integration requirements during our discussions. Ideal applicants are those familiar with AI chatbot programming, Google Assistant integration, and broad-reaching app compatibility. Database integration knowledge is essential, with bonus points for those who can offer a variety of data integration possibilities. Please bid only if you are skilled in these areas and ready to collaborate on this task. 'm looking for a sk...
...`11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game. ----------------------------------------------------------------------------------------------------------------------------------------------------------------- Ideal skills for this project: - Strong experience with WordP...
...tax filing for both US and Canada. I am a dual citizen of Canada and the USA, having obtained my US citizenship in 2020. Due to a recent move to Arizona and plans to sponsor my wife for her green card, I have discovered the need to file my Canadian taxes with the USA. I require an experienced and licensed accountant who specializes in both US and Canadian tax laws, particularly for dual citizens, to get my taxes in order promptly. Responsibilities: File Canadian tax returns for the years since obtaining US citizenship in 2020. Ensure compliance with both Canadian and US tax laws and regulations. Provide accurate and timely filing of all necessary documents. Assist with any additional tax-related queries or issues that may arise during the process. P...
...creativity. Here's a rundown of what I'm looking for: * Distinct use of a beautiful spectrum of colors. A full blend of colors one might expect in a rainbow should be apparent in the design. * While I don't have a specific symbol in mind, I encourage the creative freedom to introduce elements that playfully reflect the characteristic of the brand, while preserving its professional appeal. * Message and Feel: the logo needs to send a clear statement of creativity. It should also suggest a child-friendly vibe. *This logo will be for a pediatric speech language pathology private practice. The name of the practice will be The Speech and Language Place which plays off of SLP which stands for speech-language pathologist. The ideal freel...
Requirements: - Vuejs, Nuxtjs - Tailwind CSS - Supabase/PostgreSQL - Nodejs/Deno - Typescript - Responsive Design - Maintainable and readable code - APIs - Authentication, Authorization, Roles & Permissions - Docker - Bonus: Tests Job: - Program members portal (tasks, events, payments, backoffice) - Blog & Blog backoffice with - Create and use queries and mutations - Newsletter: manage emails and newsletter backoffice (sendgrid and others) - Manage registrations (calendly like) 12 Pages: - Portal Login - Registration - Portal Dashboard - Portal Events - Portal Tasks - Portal Profile - Portal Settings - Portal Payments - Backoffices - Blog Main - Blog Single - Others
...skilled freelancer to implement Continuous Integration and Continuous Deployment (CI/CD) using GitHub Actions, set up logging for each service, and configure an HTTPS domain for our web application hosted on Google Cloud Platform (GCP). The ideal candidate should have extensive experience with GCP, CI/CD pipelines, and HTTPS configuration. Scope of Work: 1. CI/CD Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. ...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65...
We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 prod...
I'm looking for an Angular developer who can help me ensure my project is responsive across all devices, including desktops, mobile phones, and tablets. Ideal skills: - Strong proficiency with Angular and responsive design concepts - Understanding of CSS and media queries - Experience with cross-browser compatibility - Able to work independently and meet deadlines Your primary task will be to design and implement a responsive layout that's user-friendly and visually appealing on all devices. Please note that I do not have any specific color scheme or branding guidelines, so you'll have the creative freedom to suggest a design that complements the responsiveness of the project. Looking forward to seeing your proposals.
...effective admin dashboard with user authentication. The template for the dashboard is ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email an...
I am looking for a social media expert who can help me create Instagram reels for my gynecology practice. My main goal is to generate leads from this campaign. Key Responsibilities: - Help in deciding on topics that resonate with women aged 18-52. - Creating and editing appealing and engaging reels that are relevant to my field and attractive to my target audience. Ideal Skills: - Proven experience in creating and editing Instagram reels - Understanding of gynecology or medical field is a plus - Ability to create content that resonates with women aged 18-52 - Previous experience in generating leads through social media marketing would be a bonus. Please include examples of your previous work in your proposal.
We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.
Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.
I am looking for an experienced CodeIgniter developer to upgrade my existing CodeIgniter 3 project to CodeIgniter 4. The project is currently live and needs to maintain the same database structure and functionality. The key tasks include: Upgrade CodeIgniter Version: Migrate the entire project from CodeIgniter 3 to CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest securi...
I require a logo for a dental practice called "The Dental Retreat" located in Texas, USA. Through this logo, I'm aiming to project a calm, warm, and welcoming environment. Nature is a huge source of inspiration for me, especially trees and the earth tones of natural wood. Consequently, a logo steeped in these elements would be ideal. Though the client didn't specify colors, elements, and style, the vision for this project leaves room for creativity. However, here's a guide to help you: - Colors: Given the practice's affinity for nature, adopting colors like green, brown, and blue would be beneficial. - Elements: Trees would be great nature-inspired elements to include in the logo design. - Style: There's an emph...
I am looking for a website designer to create a modern, minimalistic website for my cosmetic surgery practice. The website should significantly enhance the generation of potential client leads. Key features for the website include: - An online booking system for appointments, providing an easy and convenient way for potential clients to reach out. - A cutting-edge before and after photo gallery showcasing the results of various cosmetic procedures. - A testimonials section featuring feedback from previous patients to inspire trust and confidence in potential clients. Experience in designing healthcare or professional service websites would be ideal for this project. The design should be sleek, clean, and modern to align with the professional...
...e-commerce marketplace that supports multiple vendors, with an emphasis on vendor dashboards. Here's a breakdown of the key components and features I'm looking for: - **Purpose**: The platform will be primarily for selling products. It will be app-oriented, with main categories dedicated to specific apps, and subcategories under each app to organize products effectively. - **Vendor Dashboards**: Critical for vendors to manage their products, sales, discounts, wallet, delivery options, and other details effectively.. - **API Integration**: I need a sophisticated API to allow for seamless integration with different systems and services, allowing for extended functionality and data exchange. Payment integration with all major payments gateway...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
...experienced development team to build a comprehensive online marketplace for collectibles. The platform will include both web and mobile applications, providing users with the ability to buy, sell, trade, showcase their collections, and interact with other collectors. The project encompasses advanced features such as live sales, image recognition, and a robust community engagement system. Project Overview: Key Requirements: User Accounts and Profiles: Secure user registration and login Profile management with collection tracking and wishlists Customizable user profiles Product Listings: User-submitted items with high-resolution images, detailed descriptions, prices, and availability Categories and subcategories for easy navigation Advanced search and filtering options ...
I'm looking for a talented artist to create a minimalistic cartoon character based on a paperclip with arms, eyes and legs for my project. The character will convey a focused emotion and will be illustrated in two different scenarios. There will be more work if the first 2 are suitable. - Climbing out of a cardboard box. - Picking up litter. The character should exhibit a unique blend of simplicity. This project is perfect for freelancers with experience in character design and a knack for minimalism. Particle knowledge of conveying emotions through characters would be desirable but not mandatory. Feel free to reach out if you have any queries. See the picture for the sort of thing I'm looking for.
I'm seeking a skilled web developer to construct an intuitive booking and scheduling website for my therapy practice. My scheduling is done through acuity, I would prefer to do initial site on Squarespace. Although I would ideally like to do it in Wordpress for future SEO optimization References: Key Features: * An Availability Calendar - Visible, easy-to-navigate interface displaying my availability for appointments. * Automatic Reminders – A system that generates reminders for clients' appointments. * Personalized Booking Page – Each client should have their own dedicated booking page. A standout aspect of this site is the Resources section, which must include: * Regularly updated articles and blog posts about relevant ther...
I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.
