Advanced sql proceduresJobb

Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok

Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer

Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget

Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...

Behöver återkommande hjälp med att bygga hemsidor i wordpress. Jag arbetar själv som webbutvecklare men har för mycket jobb och hinner inte med. Du behöver kunna och förstå dig på Advanced Custom Fields och Visual Composer. Hör av dig med referenser och ett timpris!

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Hey, I want a complete website like () but it should be mobile friendly. I create my own web pages so I could edit and manage the look. What I need the most help with the programming of all functions. As advanced search function, member page, where a member can post ads, manage, edit, etc. Hej, jag vill ha en komplett hemsida likt () men den ska vara mobilvänlig. Jag skapar själv webbsidor så jag skulle kunna redigera och sköta utseendet. Det jag behöver mest hjälp med är programering av alla funktioner. Så som avancerad sökfunktion, medlemssida, där en medlem kan lägga upp annonser, hantera, redigera etc.

I'm seeking a skilled MEAN Stack developer to improve our existing web application. Your tasks will involve multiple areas including: - Modifying existing features for better functionality - Reworking the user interface - Enhancing performance - Refac...(subscriptions, CRM), Firebase and have previous experience with Azure resources. A working knowledge of Agile or Scrum methodologies is also required. It's important that you have proven experience with both the front and back-end of web development, as this is a full-stack position. While it's not required for this job, experience with e-commerce functionality, social networking features, or advanced search options could be considered a plus for future tasks. Please, only apply if you have a demonstrated record i...

We are seeking a highly skilled PCB designer to develop a custom board featuring the RP2040 microchip to control multiple DC motors and MOSFETs, with integrated voltage regulation. This project requi...Proficient in electronic design automation (EDA) tools. Strong analytical skills and attention to detail. Proposal Requirements: Portfolio showcasing relevant projects, especially those involving power management and microcontroller integration. Detailed proposal including timeline, milestones, and budget estimation. We are excited to collaborate with a professional who is passionate about bringing advanced electronics projects to life. If you have the expertise we are looking for, please submit your proposal and let’s discuss how you can contribute to the success of this innov...

We are seeking an experienced online instructor to create and record French courses for our trucking industry training platform. You will be provided with a 9-hour English dispatching course, which you must condense into a 6-hour French course. Deliverables include recording 3 hours per week, resulting in a complete 6-hour course over two weeks. Recordings should feature your face in a small circle within the video. Candidates should be fluent in French, experienced in online course production, and able to independently research and adapt content.

...looking for a skilled video editor capable of advanced editing techniques and motion graphics creation. The project involves editing a video intended for social media use for an NGO, with a runtime of less than a minute. My NGO has recently hosted an event and I'm looking for a video editor that can edit the footage that was taken during the event! The videos need to be edit because there is a lot of blown light. I need someone creative, that can produce an video that is going to be engaging for the audience and look professional! Your tasks: - Advanced video editing, including trimming, scene transitions, and color corrections - Incorporating motion graphics for animated titles and visual elements Ideal candidates are experienced with advanced editing fea...

...down. The core essence of footage should be preserved while unnecessary parts are trimmed away. The end-product should be clear, concise, and engaging for the audience. Features & Requirements: - Basic video editing including cutting, trimming and sequencing - No additional visual effects or graphics required - Ability to work within a specified deadline and communicate well Ideal Skills: - Advanced proficiency in video editing software like Adobe Premiere Pro, Final Cut Pro etc. - A keen storytelling perspective to maintain the core narrative - Patience to sift through 1-3 hours of raw footage - Excellent attention to detail. Experience in basic video editing without any fancy effects is ideal for this project. If you have previously accomplished such tasks successful...

...NEGOTIATE OR CHANGE THE PRICE, YOU WILL BE BLOCKED, RISKING EXCLUSION FROM FUTURE PROJECTS OF MINE. Project Description: Development of a mobile application "Easy Moovie" for Android and iOS using Flutter. The app aims to enhance the urban mobility experience by providing an integrated platform that supports various modes of transport (trains, buses, metro, shuttles, trams). It will utilize advanced geolocation and user interface technologies to deliver innovative features. Technical Requirements and Features: Fastest Route Tracking: Implementation using Google Maps API to calculate real-time routes, managing events like delays or cancellations. Direct Localization: GPS integration to display the current user location and nearby transportation options. U...

I'm in need of expert assistance in pushing my Quotex trading themed YouTube channel to the top of search results. My channel hosts over 50 videos and has already had some SEO optimization done, but I need a seasoned professional to drive further growth and visibility. Expectations from this project include: - Conducting detailed SEO analysis on current content - Designing and executing an SEO strategy for improving rankings - Recommending changes and improvements to video titles, descriptions, tags, etc., and where required, boarding new SEO-focused content Ideal skills for this job: - In-depth knowledge of YouTube's algorithm and ranking factors - Excellent record in SEO strategy and implementation for YouTube channels - Familiarity and understanding of the Quotex trading...

Básicamente quiero que me ayuden a crear la base de datos para un gimnasio en SQL server

I require an expert proficient in Python, SQL, and Java to work on a Codility assessment. The assessment will be conducted at an intermediate level and will be inclusive of various tasks that I will be solving in the language of the question. Key Requirements: - Comprehensive Knowledge in Python, SQL, and Java - Proficiency in tackling Codility assessments - Understanding of the assessment's specific concepts and frameworks Remember to adhere to Codility's test format and code-writing guidelines. Your completion and success of this project will greatly depend on your ability to grasp and execute these particularities.

...communications directed at client companies. Multi-company Functionality: Provide robust functionality for changing companies within the platform, specifically designed for administrators and users with multiple roles. Required Skills and Qualifications: Proven experience working with React.js and Next.js. In-depth knowledge in API integration and error handling in web applications. Ability to implement advanced UI/UX functionalities. Experience in developing multi-company systems is a plus. Deliverables: Complete source code with proper documentation. Functionalities implemented according to the listed requirements. We already have a template ready; we do not want to modify the design, only implement the functionality. Functionalities to be implemented: API connection ...

I need assistance to solve three coding tasks using Python, Java, and SQL. The challenge involves - Analytical problem-solving - Implementing quality checks - Code compilation The challenges require proficient skills in the aforementioned languages, while also ensuring code efficiency. Prior experience in problem-solving and understanding how to efficiently check and maintain the quality of code is a big plus.

Skills -core php, laravel, Codeigniter my sql database Min 1 to 5 year experience location - Mohali,Punjab, India

I'm seeking a skilled software developer to create a visitor management system that offers a range of advanced features. Key Features: - Visitor check-in/check-out: The software needs to manage visitors as they enter and exit the premises, logging their check-in and check-out times. - Visitor registration: A system that allows the entry of visitor details for security purposes. - Visitor badge printing: A key feature that's crucial for the seamless identification of visitors. - Delivery: The software should incorporate a delivery management system, tracking and notifying visitors when a delivery arrives. - Employee Sign in and sign out: A function that tracks the presence of employees as they arrive at and leave the premises. Device Compatibility: The software should be ...

I am in need of a highly skilled and experienced Python developer to join our team. This can be the full time remore job opportunity to work on EST. My ideal candidate must have over 8 years of experience in Python, with proficiency in web development, data analysis, and machine learning. Key Responsibilities: - Develop the website from scratch, ensuring it is user-friendly and responsive. - Implement and integrate user registration and login functionalities. - Create interactive data visualizations to help users understand and explore the data. - Incorporate real-time chat support for enhanced user engagement. The ideal candidate should have: - Over 8 years of experience in Python. - Proven expertise in web development, data analysis, and machine learning. - Strong understanding of use...

I'm in need of an expert to carry an advanced data scraping task on Github. Key project specifics: - The kind of data to be harvested includes not only text content and links, but also user IDs, emails and names. Therefore, this project requires someone with a skill set that allows for scraping beyond the surface level. Ideal Freelancer: - Ability to implement advanced scraping techniques to ensure quality and completeness of obtained data. - Experience in harvesting sensitive information like User IDs, emails and names. - Respectful of privacy laws and legal restrictions regarding data scraping. - Self-motivated, detail-oriented, and reliable. Please be ready to provide examples of similar projects you have completed. This will aid in the selection process.

...working on my PhD thesis, with its focus primarily on statistical analysis. I am in need of an expert in statistical analysis, particularly in inferential statistics, to assist me in my study. Key Skills and Experiences Needed: - Deep understanding of inferential statistics - Familiarity with hypothesis testing and established statistical software, such as AMOS SPSS - Background in handling advanced statistical analyses for academic research or a related area Expectations: - Assisting to lay out inferential statistical methods in the form of hypothesis testing - Converting raw data into comprehensive and understandable terms - Constructing and presenting data effectively to contribute to the robustness of my research. Your role will be instrumental to strengthen the statis...

I'm looking for an expert w...Requirements include: - Real-time synchronization: All data updated in any of these accounting software should reflect on my ERP system instantly. - Automatic data updates: An ability to schedule regular automated updates. - Custom Reporting: Tailored reports based on the data received from the platforms. - Error handling and Data Validation: Ensuring data is validated with robust error handling procedures. Given that I skipped indicating the specific data, your proposal should outline a solution for an All-in-One integration, that is ready to extract and integrate any type of data. High proficiency in API integration, backend development, PHP, Laravel and understanding of accounting systems are ideal skills for this project. Two APIs required: ...

I am in need of a skilled photo editor to provide advanced editing for a set of 30 images. This comprises of not just light adjustments or retouching, but manipulating the images and even adding new elements to enhance them. The details required are as follows: - The images need to be edited to an advanced level, including manipulation and addition of elements. - The final format for the image edits will need to be in JPEG. - These images must be delivered in high resolution. For this task, I require an expert who has extensive experience with photo manipulation and has an excellent command of photo editing software. An eye for details, creativity, and accuracy is a must. Proven experience in delivering high-resolution image edits and an ability to work to tight deadlines w...

I'm looking for someone who has very good experience in Laravel's real world situation. What Queue drivers are available in Laravel? Will ignore any ...Queue drivers are available in Laravel? Will ignore any replies without answering to the above my question. Here is my problem now. We are using Laravel project and it's running on production. It's using Queue heavily and queue driver is database now. We are getting following issue. SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (Connection: mysql, SQL: select * from `jobs` where `id` = 111111 limit 1 for update) Let me know how to fix this then I will hire you immediately and you can be employed in our project. Please don't waste my time if you don't know...

...developer who is skilled in machine learning and natural language processing, with a particular focus on training models for Text-to-Speech (TTS) applications. In this project, I require assistance in training a dataset from scratch to create a functional, ready-to-use model for Coqui AI TTS specifically designed for the French language using a specific voice. Key requirements: - Intermediate to Advanced level experience in machine learning and NLP. - Previous experience in training TTS models, especially with Coqui AI. - Proficiency in French is a plus. - Familiarity with working on a model for a specific voice. The ideal candidate should be able to guide me through the process of dataset preparation, model training and fine-tuning, and assist in making the model ready for dep...

I'm currently seeking a skilled tutor to assist me in two key areas of MS Project - Scheduling and Task Depen...Task Dependencies. My current proficiency in MS Project is considered intermediate. I'm looking to improve these skills and advance to a more professional level with the software. I learn best through practical, hands-on exercises. This means that I'm looking for a tutor that can provide me with interactive, project-based learning experiences. Ideal Skills and Experience: - Proficiency in advanced MS Project features, particularly in Scheduling and Task Dependencies - Previous experience in tutoring or teaching MS Project - Ability to create engaging, practical exercises for effective learning - Excellent communication skills to convey complex concepts ...

I'm in need of assistance with Codility assessments, specifically focusing on intermediate-level problem-solving tasks. Your work should encompass: - Expertise in SQL or Python. Familiarity with both languages is advantageous. - Proficiency in algorithmic programming, capable of thinking strategically to solve intermediate-level problems. - Ability to assist in solving three different task types in Codility, including: 1. Time complexity problems 2. Sorting and searching problems 3. Counting elements problems Ideal candidates would have experience preparing or mentoring for codility assessments and a strong background in programming. Your intricate knowledge of problem-solving within the realms of algorithmic programming would be highly beneficial. A methodical appro...

I need an expert in procurement policies and procedures to conduct a thorough review of my current practices, focusing primarily on contract management, the supplier selection process, and compliance with regulations. Your responsibilities will include: - Reviewing current procurement policies and procedures - Identifying areas for improvement and updating the policy accordingly Due to the scope of this project, previous experience in the following areas would be advantageous: - Contract management policy development - Supplier selection procedures - Compliance with procurement regulations Although certain areas are not specified for review, like streamlining of contract approval process or establishment of clear criteria for supplier evaluation, they should no...

Training for model deployment, training and fine tuning. Agenda for training session - Quick intro (concept, process, procedures and tools) - Environment requirements and setup - Installing / deploying a model (local and cloud) - Training a model (prerequisites included) - Fine tuning a model - Running ML Model with API - Q & A

I am looking for an experienced video editor who can help me create engaging content for both Instagram Reels and TikTok. The primary goal of these videos is to captivate and interact with my audience. Key Responsibilities: - Performing advanced video editing to enhance the quality of the content. - Ensuring the videos are suitable for both Instagram Reels and TikTok. - Implementing creative ideas to engage with the audience effectively. Ideal Skills: - Proficiency in advanced video editing techniques. - Experience in creating content specifically for Instagram Reels and TikTok. - A deep understanding of audience engagement strategies for social media. If you're a talented video editor and content creator who can help me achieve these goals, I am excited to hear from ...

As an entrepreneur ready to take my business online, I'm in need of a proficient web designer to help me create a state-of-the-art e-commerce website. Key requirements for the website are: - Focus on Physical Products: The website is intended to sell physical goods, thus a user-friendly interface for showcasing these products is paramount. - Inventory Management: The site should feature an automatic inventory management system to streamline operations and ensure up-to-date stock levels. - Payment Method: I’ve chosen Stripe as my preferred payment method. Therefore, seamless integration of Stripe as a secure mode of payment on the website is crucial. The ideal freelancer for this project should have a wealth of experience in e-commerce website design, proficiency in the int...

As a representative of Belize at United Nations Climate Change conferences, I've highlighted the specific difficulties of climate change our country faces. These include: - Rising sea levels - Coastal...practices It is expected that these initiatives will lead to the: - Reduction of vulnerability to climate change impacts - Enhancement of resilience to extreme weather events Therefore, professionals with experience in environmental conservation, renewable energy projects, and climate-resilient agricultural practices will be instrumental to the success of this project. Demonstrated experience in advanced coastal protection engineering is equally beneficial. By addressing these challenges, we will ensure sustainability and resilience for Belize in the face of varying climate ...

...to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE Data Integration: Prior experience working with NSE data feeds would be advantageous. - Educational Content Creation: Experience in simplifying complex financial concepts into easily digestible content would be a plus. Looking forward to working with a professional who can deliver a top-notch, educational Exce...

I'm looking for a skilled video editor who can take my raw footage and transform it into engaging, high-quality content. My primary focus is on Reels - these short videos need to be creatively edited with advanced techniques like color grading and special effects. Key Requirements: - Skilled in advanced video editing techniques - Ability to execute color grading and special effects - Proficient in creating short-form content, particularly Reels - Experience in Instagram marketing The end goal of these edits is to drive sales, so I need someone who can help me create content that is not only visually appealing but also strategically crafted to encourage conversions. If you have a proven track record in video editing and Instagram marketing, I'd love to hear from ...

I'm after an experienced video editor with expertise in advanced effects and motion graphics. The video should incorporate a music video style which we are keen to integrate into our project. Additionally, we require expertise in Social Media Marketing to promote this content effectively. Key Responsibilities: - Create high-quality video content with advanced effects and a music video style approach. - Optimize this video content for social media platforms. Required Skills: - Proficiency in video editing with a demonstrated understanding of motion graphics. - Extensive experience in Social Media Marketing. Having a background in creating music videos would be a particular advantage. The passion for social media marketing and staying on top of trending content i...

I'm looking for a mid-level Project Manager in the technology sector to organize and lead a team effectively. The ideal candidate will have experience with planning, team coordination, budget management and documentation. Key Responsibilities: - Planning and organizing: You'll be responsible for laying out the project plan and ensuring milestones are met. - Team coordination: You'll be the linchpin that ensures the team is working together effectively. - Budget management: You'll need to keep a tight rein on project finances. - Documentation: You must be able to keep clear, detailed records of the project's progress. The right person for this job will have: - 2 to 5 years of experience in a Project Manager role. - Experience in the technology sector. -...

I'm currently looking for a South Korean native to help me with the process of setting up an Upbit account. As I'm not residing in South Korea, I need someone who is knowledgeable about the local regulations and procedures. Ideal freelancer should have: - Experience managing crypto trade accounts, specifically Upbit - Helping me setup an account with them Payment fee: $80 upon successful account opening and trade

I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are conf...

I urgently need an expert Laravel developer to collaborate on a web application development project. The specific features and ...an expert Laravel developer to collaborate on a web application development project. The specific features and functionalities of the project are yet to be defined, but a vast knowledge in Laravel is key. Key skills and Experience: - Proficiency in Laravel and PHP - Understanding of MVC design patterns - Knowledge of front-end technologies, such as JavaScript, HTML5, and CSS3 - Familiarity with SQL/NoSQL databases - Excellent problem-solving skills The timeline for this project is ASAP, so the ability to work under pressure is required. If you have experience in web applications, APIs, or both, it will be advantageous. Let's collaborate on this ex...

Due to time and resource constraints, I need to migrate a component written in php (symphony) to Golang. The part on github relating to services towards the DB (MongoDb) and the new REST APIs (written in Golang) to access for interfacing is already active. The system will only have to exe...render in twig template. The repository layer and service and repository are already developed in golang and will be provided. Configuration files are ready. As well as indications on the function to be translated into Golang. GIT access will be via wireguard VPN on the development environment Please contact us only if you have experience with Golang or C++: to avoid wasting time We can give you advanced technical support and explain the logic of the project and the code if necessary, being ...

...seeking an experienced web developer to bring my dynamic classified website to life. Key Features: - User Registration and Login: Implement a seamless and secure user registration and login system. - Listings and Categories: Design and incorporate a user-friendly interface for posting and structuring listings across various categories. - Search and Filters: Integrate a robust search engine with advanced filtering options for users to easily navigate and find what they're looking for. Payment Options: - Credit/Debit Card Payments: Provide a secure payment gateway for users to make transactions using their credit or debit cards. - PayPal: Integrate PayPal as a payment option, ensuring a convenient and familiar method for users. - Bank Transfer: Offer bank transfer as an alte...

21:00 CET Friday 1) Minimal Hitting Sets 2) Dynamic Slicing - Simple 23:59 CET Saturday 3) Dynamic Slicing - Advanced 4) Debugging: Slicing & Minimal Hitting Sets 5) Questions

I'm in need of a professional video editor experienced in creating entertainment and creative content. Requirements: - Execute advanced editing techniques with special effects - Prior experience in creating content for entertainment or creative purposes - Familiarity with the latest trends in video editing - Ability to deliver polished and engaging videos within the deadline The final content will be published on various platforms, so knowledge of optimal video formatting for different platforms is a plus. If you believe you're the right fit for this project, please provide examples of similar work you've completed.

Job Overview: We are seeking a detail-o...professional directories, LinkedIn, medical institutions, and other reliable databases.. Provide regular updates to the project team, highlighting progress and any obstacles encountered. Requirements: Preferable track record in healthcare research, particularly in identifying medical specialists and therapists. You must be able to provide high quality databases with a proven methodology behind it Advanced research skills, including the ability to use digital tools and databases effectively. Strong organizational skills with meticulous attention to detail. Ability to manage large datasets and meet strict deadlines. No placeholders, just bids to provide the 200 well researched names , No web scrapping this must be a well researched task based...

I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.