Sql database schema stored procedure 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
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.
...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 a professional who can help me with installing the Oracle 23c database on my Ubuntu Linux system. Key Skills: - Proficiency in Oracle database installation - Specific experience with Oracle 23c - Strong understanding of Ubuntu Linux The selected candidate should be able to: - Perform a detailed installation of Oracle 23c database (enterprise version) on Ubuntu Linux - Ensure proper configuration to meet the project's requirements - Provide guidance on any post-installation tasks that may be necessary Is there any possibility to install a 23c oracle database enterprise version not free version on docker?
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 in need of a skilled developer who can create unofficial APIs for UPI Apps and IRCTC Connect, and integrate them into a my c# .net desktop application. Ideal Skills & Experience: - Proficiency in analyzing Apps network traffic, api endpoints, APIs with a strong understanding of UPI and IRCTC Connect - we need API only and encryption methods, data should be stored/retrieved in json format. The APIs for UPI Apps should handle: (Flipkart/BHIM AXISPAY/FREECHARGE/PHONEPE/PAYTM/MOBIKWIK/GPAY - any3 Only) - User registration - Listing of added banks - Checking the account balance - Handling pending/approved payments The IRCTC Connect APIs should offer functionalities such as: - User login - Searching for trains - Submitting passenger details I'm looking for someone ...
I'm currently seeking a skilled freelancer for a data entry job concerning primarily text data. The data to be entered will be provided in an Excel spreadsheet and will need to be accurately transferred to an online database. Ideal candidates should have: - Proficiency in Microsoft Excel - Experience with data entry into online databases - Attention to detail and accuracy Please place your bid based on the information provided, and get ready to embark on an engaging and fulfilling data entry task.
I am looking for an expert in data extraction, particularly from multi-page PDFs containing various elements, including text, tables, and images. This is a step one for us in developing a ne...Detailed-oriented with a focus on accuracy and consistency Project Details: - Pull data from several multi-page PDFs - Skillfully handle different types of data including text, tables, and images - Extract clean and structured data. - Systematize the stored data for easy future access The project is completed once we receive the package with the full code and a step by step guide to deploy it and run it on our server (we will provide a server for development), and run it. We will test many pdf files and expect the data to be extracted and stored in a well structured way that is e...
I need a developer to build a PHP app using Google Sheets as a database. I want add a text on a field it'll to fetch rest row and column data from sheet. Check attachment. I'll enter only order number. This will involve: - Implementing a User Authentication system. Note that no specific features like social media authentication, two-step verification, or forgot password functionality are required. Just a simple log-in/log-out system will suffice. - Data validation will be key in this project. Each entry must be checked to ensure that it meets certain criteria before being stored in the sheet. - Real-time data synchronization between the app and Google Sheets. This means that any changes made in the app should be instantly reflected in the sheet, and vice versa. ...
PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN WORK WEEKENDS!! 1st task (IMMEDIATE): Fix pagination -> our webapp uses an api endpoint to load data from stored procedure that takes 30 seconds to run. Pagination + cache was implemented but the pagination was implements AFTER the api runs (30 second wait) and should be executed inside the stored procedure to start sending data to the front end immediately, after it has the first 30-50 records instead of waiting to receive the entire 6000+ current records. We implemented cache but would like developer to evaluate the possibility of using redis to improve performance. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award i...
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 need someone to post 300 items to both my eBay and Poshmark stores. It’s about 300 totals and each item will be posted to both stores. I have all of the images of the items stored on Google Photos as well as a document that has the item date 1. Create a title and description for the item with ChatGPT 2. Post the item on eBay first with the images 3. Remove remove the background from the main image 4. Post the item on postmark with the background removed from the image as the main image just like you do for eBay You may use the same images and item description for both the eBay and Poshmark listings I will provide you with a few videos that provide detailed instructions on how to make the postings. Also, I will provide you with a Google Photos album as well as a docum...
...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 am looking for a skilled professional who can help with various aspects of data processing, storage and workflow management using Pyspark, SQL, Airflow, S3, Hadoop, and Kubernetes. Key areas of support required include: - Data processing in Pyspark: Assistance with data cleaning and transformation tasks in PySpark. - Querying databases in SQL: Advanced optimization techniques, custom queries and data retrieval. - Workflow management in Airflow: Custom workflow automation and scheduling tasks. - Data storage and manipulation in S3 and Hadoop: Support for large-scale data storage and processing. - Container orchestration in Kubernetes: Assistance with container deployment and scaling. Specifically, the ideal candidate should be able to set up tables on Iceberg in Parquet ...
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 in need of a skilled database designer and manager who' is confident in English. The project involves creating and maintaining a relational database. Key Requirements: - Advanced knowledge of Relational Databases - Proven experience in database design and management - Must be be fluent in English Experience with: - Customer data management or transaction records (preferred but not mandatory) I'm looking for someone who can work on this project with no strict time limit.
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 proje...
...Prior participation in open source projects Experience designing and developing decentralized technologies, including smart contracts Familiarity with blockchain technology and platforms such as Ethereum . Smart Contracts and Decentralized Applications Smart contracts play a crucial role in the integration of wallet connect feature and decentralization of the game. Smart contracts are programs stored on the blockchain that enable automated compliance and execution of agreements without an intermediary. Therefore, it's essential to work with developers who are proficient in writing smart contracts using languages such as Solidity and have experience in developing decentralized applications . Conclusion In conclusion, to achieve the goal of integrating wallet connect featu...
...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 professiona...
...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 highlights the need for transaction validation and auditing to maintain a transparent and accountable system. 7. Data Encryption and Storage: Sensitive user data, including financial information, will be encrypted and securely stored in the application's database. This section explores encryption techniques ...
I...list featuring more than 500 companies. In the details you collect for each organization, I'd like to see the following: - Company Name - Contact Person Name - Contact Person Email. The ideal candidate for this task would be someone who is proficient in data mining and possesses broad knowledge of Oracle EBS customers in the manufacturing, retail, automotive industry. Prior experience in CRM database creation would be an added advantage. It's essential that all information gathered adheres to privacy and data protection laws, ensuring a legally compliant list. So, a freelancer with a keen understanding of these laws would be highly preferred. Accuracy of data is of top importance, therefore meticulous cross-checking is needed for each entry. I'm looking for...
I am looking...assisting with the process of changing a beneficiary on an IRA. Key Requirements: - Experience with estate petitions and probate law - Understanding of IRA beneficiary change process - Excellent legal research and drafting skills I am an attorney representing the estate, facilitating the necessary legal steps to change the beneficiary on the IRA. Your expertise in this area is essential, as the procedure is complex and requires specific legal knowledge to ensure compliance with all relevant laws. This role will involve research, drafting of legal documents, and potentially liaising with financial institutions or other relevant parties. Your ability to navigate this process efficiently and accurately is crucial in ensuring the beneficiary change is completed suc...
I'm in urgent need of a Python Django developer to help me deploy my old website files on Namecheap. Here's a rundown of the tasks and requirements: - Deploying old website files on Namecheap: I need you to swiftly and effectively set up and configure the database for my project. - No new development or integrations: You won't be tasked with front-end or API work, just the deployment of the existing files. Your experience with Django and database setup are paramount. Time is of the essence, so I need a professional who can work efficiently and effectively.
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.
I need a professional to implement the following tasks: - Increase the number of followers of our...Increase the number of members of our associated Whatsapp channel - Increasing the website's visibility in Google (e.g. through high DR backlinks or similar) It is important that only permitted and legal methods are used to increase the number of German-speaking participants! Backlinks only from real websites with traffic! No link farms or blackhat sites! I expect a precise structure in the procedure with concrete suggestions for action for the planned implementation, already in your offers. A 100% legal implementation is important to me, without running the risk of Google and/or Meta (Facebook & Whatsapp) blocking access! Please only bid if you really have expertise in...
I’m seeking a data expert to scrape a specific database and transfer all available fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all...
...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...
For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.
I am in need of an EMV card reader PCB with Blu...reader PCB with Bluetooth capabilities, expressly for the logging of data. Here are the specifications for the task: - Main Purpose: The core purpose of the EMV card reader is Data Logging. - Data Required: The data to be logged includes the Card number and Transaction Details, the Time and location of card usage, plus the Type of card and Cardholder's name. - Storage: The logged data should be stored on the device. For this task, excellent knowledge of PCB design and Bluetooth technology is key, with proven experience in dealing with EMV card readers, along with knowledge of secure local data storage solutions. Familiarity with data privacy regulations is also advantageous, considering the sensitive nature of some of the dat...
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.
I'm in search of a proficient C/Linux developer with experience in developing desktop applications. You will develop the project in C/Linux. Project will be tested in Ubuntu 22.04 Linux 64-bit. You will develop a program to access and modify a FAT32 disk image (FAT32 volume). The disk image will be stored as a regular Linux file, which will simulate a disk formatted with the FAT32 file system. Your program will open the Linux file using the standard open() system call and access it directly in raw mode, utilizing the read() and write() system calls, without mounting the FAT32 file system. The program will be named fatmod. Through various options, it will in- teract with a file system image, enabling reading and writing of files. Detailed explanations of the specific support...
I have an Android app that I want to submit to the Google Play store. The app does not include any in-app purchases. This App is designed and used by 1 company only (not for all users, users can not register), that company will create and give account for their employees. Data in app is stored in company’s server. Now when we upload to Google play, it has been rejected as image below. We submitted many times safety data form with variety data, but google still reject our app. We don’t know where problem is. Our safety data from or our app, our code. The images below are API we use in our code, and feedback from Google. Please help us to submit this app to Google Play store.
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 need a skilled MERN stack developer who can integrate the pages my previous developers have made, i have a login page and a report generation application. I want the user to first fill the sur...generation application. I want the user to first fill the survey as a login page and once they have filled it store the details as a cookie or session so they don't need to fill again User details filled should also go into a local db or folder Then users will be sent to our report generation application and at the end when report is generated, business name and email ( from the survey form stored in session cookie) will be used at top of report Survey / Login Page : Report generation Page :
In this crucial project, we aim to significantly improve the cybersecurity of data stored on the Google Cloud Platform (GCP), using cutting-edge artificial intelligence methods. Our main goals are as follows: - Use Machine Learning and Deep Learning to detect and mitigate any potential cyber threats before they occur. - Utilize AI to predict and intercept Unauthorized Access, Data Breaches, and Malware Attacks, thereby bolstering our defense mechanisms. The ideal candidate will be proficient in AI, specifically Machine Learning and Deep Learning, and have extensive knowledge of cybersecurity on clouds. Experience with GCP would be a valuable advantage. It's essential for the chosen freelancer to be adept at translating complex AI algorithms into practical cybersecurity soluti...
We are looking for someone who is specialized in building/fine-tunning Openai Whisper model for audio transcription. To be specific, we are interested in either building or fine tunning models for special dialects. Please provide a clear milestone that illustraate the work procedure. - The purpose of this project is to have full knowledge about building/fune-tunning Openai Whisper models. - The freelancer should be capable of answering and clarifying all the questions/concerns related to selected choice (model details such as number of layers and other model parameters). - The freelancer should be capable of justifying the reasons behind the selection between fine-tunnnig or building a model from scratch based on the required task (audio transcription). - Define all the requirem...
...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 ...
...agriculture broad acre farmers. The site should serve as a detailed resource, highlighting key aspects of our work and organization. Key Features: -A professional look and feel `-Wordpress based - A comprehensive "About Us" page to outline our mission, goals, and team. - A clear display of our contact information on every page. - Easliy updated by ourselves with graphics based on data collected and stored in MS Excel -Potential for client login The perfect candidate for this job would be an individual with a keen eye for modern web design, experience building informational websites, and ideally some knowledge in Australian agriculture. Good communication skills are necessary, as you'll be expected to collaborate with our team closely. A successful end result w...
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 +...
I have a plain PHP script where users can select teams, but I haven't imported the players yet. I already have SQL queries for this, so they need to be imported and linked to their respective teams. When a user selects League 1 and, for example, Team Feyenoord, they should automatically get access to the players from that league. A league can only start if there is at least one real user active in that league. There are 10 leagues in my database. Nothing should happen if there is no active user linked to a league/team. Now, here's the exciting part. Every match should be generated at 00:00 with certain random variables. So, for example, if a player is in League 1, I want all matches in that league to be generated. I've created an example of how I want to visu...
I need a professional to clean my text data. The primary goal is to standardize the formatting of the data. - Your main task will be to format the text data in a consistent and uniform way, ensuring that all the text data is correctly and uniformly structured. - You should be proficient in text data cle...need a professional to clean my text data. The primary goal is to standardize the formatting of the data. - Your main task will be to format the text data in a consistent and uniform way, ensuring that all the text data is correctly and uniformly structured. - You should be proficient in text data cleaning with experience in standardizing the formatting of textual content. - The data is currently stored in plain text files, so experience working with this type of data storage is ...
I'm in need of a skilled developer to create a robust course management database for our educational institution. Key Functionalities: - Student Registration and Enrollment: The database should be able to store and manage student information. - Grades and Transcripts Management: The system should have a feature to track, store, and manage students' grades and transcripts. - Attendance Tracking: The database needs to have a reliable attendance tracking system. - Multiple Courses: The system should be designed to manage multiple courses efficiently. Expectation: - The database should be able to handle 50-100 users accessing it simultaneously. - It needs to be user-friendly, secure, and scalable for future expansion. - Preferably, a responsive design w...
I'm looking for an expert with exceptional Sequel database administration skills on a Windows environment. Your main task will be to handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus....
...specifics of the data extraction are as follows: - I require product details and price information from the site. - The main task involves capturing a comprehensive car database, including all car brands and models present on the site. The focus here is on the complete car directory, not just specific brands or models. If you have experience in web scraping, particularly in the automotive sector, this project is for you. Accuracy and completeness are key, as the success of the project hinges on the comprehensive nature of the dataset. I attached RAR file (Scraping code). by running this script, fetching yourself full database of cars. pocketbase queries to supoprt filters and run them on pocketbase server side routes, so that they can be used to feed data to views. (...
