Data cleaning using sql 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
...Functions: Data Architecture: Leverage your 5+ years of experience in designing and optimizing database solutions. You’ll work closely with stakeholders to create a robust data architecture that seamlessly integrates various data sources. Programming Languages: Demonstrate proficiency in Java and C#. Your code is not just functional but elegant. Team Leadership: As a seasoned engineer, you’ll mentor junior team members, foster collaboration, and drive technical excellence. Cloud Solutions: Familiarity with Azure or AWS is essential. You’ll architect, deploy, and manage cloud-based solutions. Data Import Strategy: Devise a robust strategy for importing data efficiently, ensuring data quality, and maintaining performance. Collab...
I'm seeking a professional to help me transcribe and code my interviews. Key requirements: - Transcription: I need you to transcribe 1-5 interviews with a high level of detail. You'll be coding, editing, and cleaning up the transcription for clarity. - Thematic Analysis: You're expected to assist in coding the data in a way that captures the essence of the responses in line with the descriptive nature Ideal Skills and Experience: - Proficiency in transcribing and coding qualitative data. - Excellent attention to detail to ensure the transcription is accurate and the coding reflects the nuances of the responses. - Good communication skills to keep me informed throughout the process. If you're confident in your ability to help me with these tasks a...
Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.
E-comerce hecha con React, Tailwind CSS , Framer Motion y cuenta con un chatbot con IA como asistente virtual En el Backend cuenta con una base de datos SQL y node Js y Javascript para la conexión a la BD Tiene una auténticacion de usuarios Y cuenta con integración a MercadoPago
...project and seeking a professional to help me transcribe and code my interviews. Key requirements: - Transcription: I need you to transcribe 1-5 interviews with a high level of detail. You'll be coding, editing, and cleaning up the transcription for clarity. - Thematic Analysis: You're expected to assist in coding the data in a way that captures the essence of the responses in line with the descriptive nature of the study. Ideal Skills and Experience: - Prior experience with thematic analysis in descriptive research is a must. - Proficiency in transcribing and coding qualitative data. - Excellent attention to detail to ensure the transcription is accurate and the coding reflects the nuances of the responses. - Good communication skills to keep me infor...
I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.
I'm looking to create an application using NoCode development tools, specifically Bubble and FlutterFlow. The core features I need developed are: - User Authentication: This will be based on an email and password login system. The focus should be on ensuring user credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skille...
I want to create a quiz that can be embedded into a website page builder using their embed feature. The quiz should be manageable from my dashboard, the script will be on it's own domain. Key Aspects: - Creation: The plugin should enable the user to create quizzes. Please advise on the best quiz type to use. - Embedding: The plugin should allow for easy embedding into website pages or blog posts. Being able to place the quiz in a sidebar widget would be a bonus. - Interaction: I am open to different ways for users to interact with the quiz, either by clicking on options, typing answers, or selecting from dropdown menus. Your insights on the most user-friendly option are welcome. - Management: The plugin should provide an interface to manage the quizzes. Ideal Skills and Ex...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.
I have a window cleaning business that I'm looking to expand in York Region, Ontario, Canada. I'm seeking someone who can help me find and secure 50-100 new clients in that area. You can use any method for contacting potential clients, be it email, phone calls, or even door-to-door. Ideal Skills and Experience: - Proven experience in client acquisition - Proficiency in communication and negotiation - Familiarity with the York Region, Ontario, Canada area is a plus Your main tasks would include: - Researching and identifying potential clients in York Region - Contacting clients via email, phone calls, or in person (door-to-door) - Convincing clients to book our residential window cleaning services - Keeping track of and reporting on client acquisition progress Fre...
For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project further.
I'm running a window cleaning company in the York region of Ontario in Canada, and I need help recruiting clients. Here's what I'm looking for: - **Recruitment**: I need someone to focus on recruiting residential houses only, ensuring a continuous flow of work for our team. - **Method**: I'm open to various methods for reaching potential customers, from traditional cold calling to any other approach you are comfortable with. However, I'm not interested in online advertising. - **Requirements**: The houses you recruit must be in the York region. Additionally, each recruited house should provide a minimum of $200 in business. Free Trial Opportunity: As part of our hiring process, we're offering a free trial period to assess your ability to generate re...
I am seeking an experienced developer who is well-versed in React JS and Node JS for the development of an e-commerce platform. This platform will be designed to support a range of e-commerce functions, with the main focus being on product search and filter options. Key responsibilities & requirements: - Proficiency in React JS for front-end development - Experience with Node JS for back-end development - Strong understanding of e-commerce structures and functionalities - Ability to integrate user-friendly product search and filter options The ideal candidate should be someone who has not only the technical expertise, but also the vision and creativity to enhance the user experience through these key functionalities. A portfolio showcasing previous e-commerce projects would be a s...
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.
I am looking for a skilled and experienced web developer to build a simple and engaging website for my data analytics agency. Key Functionalities Required: - A clean, professional design that reflects the precision and detail-oriented nature of our work. - Clear sections displaying our primary services which include data visualization, predictive analysis and data cleaning. - A section to attract new clients through compelling calls to action and persuasive content. - An informative section providing detailed information about the various services we offer. - A project showcase space, where we can exhibit our previous projects and achievements. While there are no specific color schemes or branding guidelines to adhere strictly to, I'd prefer a de...
I'm seeking a professional who can assist in generating leads and potentially converting them into clients for my window cleaning business. The leads should be specific to suburban neighborhoods and residential areas, with a primary aim of increasing sales. Key Responsibilities: - Identify and gather leads from the specified suburban neighborhoods. - Develop strategies to convert these leads into potential clients. - Prioritize on generating leads that have a higher likelihood of converting into sales. - Maintain a professional and engaging approach towards potential clients. Free Trial Opportunity: As part of our hiring process, we're offering a free trial period to assess your ability to generate leads effectively. During this trial period, you'll be tasked with ...
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 looking for someone who has very good experience in Laravel's real world situation. What 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 what's going on with the above message.
...skilled professional who can help me scrape text data from e-commerce sites for data analysis. Key Requirements: - Data Scraping: The primary task is to extract text data from various e-commerce websites. This includes product descriptions, reviews, and any other relevant textual information. - Data Cleaning: Ensure the scraped data is accurate, clean and ready for analysis. - Data Analysis: This project is focused on data analysis, so experience in this area is a must. The ability to extract meaningful insights and trends from the scraped text data is crucial. Ideal Skills and Experience: - Proficiency in Web Scraping: A strong background in web scraping and working with text data is essential. - Data...
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 hope you are well, sorry for the rush. I always give you the highest quality work and am ready to be by your side anytime. I hope you are happy with my service. I hope to get good comments from you. We will work together more thanks!
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...
I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.
I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions
I need a simple form that will look goo...form will collect NAME EMAIL CITY PHONE NUMBER phone number will be a formatted 10 digit max, and email will need validation for properly formatted. This will take the data and post it to our existing base and will then revert form back to a page that says success, and then auto redirect to the form page. The form page will look neat and clean and also contain a couple lines of text and our logo. You will use the existing config file to connect to our base, instead of creating a new one. This project needs completed today and should only take an hour to complete. This is to be written in php 8.2 and connected to sql dbase. You will be paid $30 when it is complete and verified to be working on our server. Ping me if you can co...
I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essentia...
...to take part in my ongoing web development projects. The main goal of the project is to enhance an existing application. Requirements: - Proficiency in .NET for backend development - Strong experience with Angular for frontend development - Excellent understanding of SQL Server and MongoDB databases - Previous work with DevExpress is essential Your responsibilities will include: - Developing APIs using .NET for enhancing the application - Integrating Angular for improving the frontend - Ensuring seamless operation with SQL Server and potentially MongoDB Ideal candidates should have a strong understanding of web development and be able to contribute effectively to enhancing the current state of the application. The ability to work with a team, meet deadlines an...
I urgently require a thorough cleanup of my contact database. The main tasks include: - Verification of the correctness of email addresses - Authenticity check of RUTs - Verification of phone numbers The right candidate for this project should possess excellent attention to detail and experience in database management, particularly in contact cleaning. Familiarity with RUT verification will be highly valued. Please apply only if you can start immediately.
...FINAL; NO LATER CHANGE IS ALLOWED. READ CAREFULLY BEFORE YOU BID. See ATTACHMENTS. Cannot share Code before you accept. I have a Journal App built in PHP/JavaScript/Laravel which allows to enter Journal entries, country, some photos and one video of limited size, different costs etc (see ). The job is to implement the feature of Travel Route Map Creation using Leaflet and OpenStreetMap (both free, opensource). There is a tutorial here Users will be able to search a place in map, create lines of different colors from one place to another, add/tie blog posts, links and pictures with the map, dates, notes and then only map creator can download the map as Image/PDF. Leaflet free plugin
I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions
Complete SPSS data analysis to test hypotheses relating to social media usage and exercise addiction. The goal is to identify and delineate trends and patterns from the data. Include a report for the results using APAstyle
I am looking for a freelancer to assist me with specific data cleaning and transformation tasks in Microsoft Power BI. Skills and Experience: - Strong proficiency in Microsoft Power BI - Experience in data cleaning and transformation techniques - Ability to work with large datasets Data Output: - The preferred format for the data output is data sets Data Collection: - I already have the data, so the freelancer will not need to collect it.
I'm looking to have a Python API built to generate a multiple-choice question bank for schoolchildren in various subjects (such as Mathematics and English) using AI APIs like ChatGPT. The API should allow for different difficulty levels for the questions. Key Requirements: Development in Python. The API should possess the following functionalities: Input Parameters: a. Users will specify the number of questions needed in one set. b. Users will indicate the topic of the questions. For example, if they want a question bank on Mathematics focusing on BODMAS, they will provide keywords like "BODMAS." Users can provide multiple keywords such as "BODMAS," "Ratio," "Percentage," etc. Similarly, for English, keywords could include "Cloze,...
Hi, Job Title: Senior Developer - SQL Server Analysis Services Experience : 5+ Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, exce...
I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.
Project Description: Customer Data Integration and Personalized Marketing System Introduction: In the contemporary business landscape, understanding and catering to the needs of customers is paramount for organizational success. To achieve this, businesses must gather, organize, and analyze data about their potential and existing customers. This project focuses on developing a comprehensive system to streamline the process of collecting, integrating, and leveraging customer data to create personalized marketing campaigns. Objective: The primary objective of this project is to establish a dynamic and continuously updated database that empowers personalized marketing strategies. By gathering, cleaning, integrating, and analyzing customer data, the system a...
...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....
I have an error in my asp.net MVC application. The form is using AJAX to show particular dropsownlist data. its working fine but if the validation works, the ajax call is reseting and stop working.
we are looking for a senior experienced PHP developer with a minimum of 15 years of experience Skills and Experience MUST HAVE: - 15+ years of core PHP development experience. - Proficient in Laravel framework. - highly knowledgeable in php programming and experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - **must be an independent developer, not an agency! - must be able to work on github - lastly making sure platform is mobile responsive Must have experience in social media or multi-user platform, chat system, ecommerce platform *******We will only hire independent freelancer. If you are an agency, if you are a marketing person or project manager and will delegate the work to someone else, meaning, will subcontract the job to someon...
...exploit vulnerabilities in our user login process. - Authorization Controls Testing: We need thorough testing on the authorization controls in place to ensure that only authorized users can access specific resources. - Input Validation Testing: We need someone who can identify any weaknesses in the input validation of our website. This is crucial in preventing common security vulnerabilities like SQL injection and cross-site scripting. Ideal Skills: - Proven experience in ethical hacking and website security testing. - Strong expertise in PHP and web application security - Familiarity with OWASP Top 10 standards - Excellent understanding of user authentication, authorization controls, and input validation - Good communication skills to report and explain findings clearly If yo...
As an online learning provider, I offer a broad range of technical courses. I'm seeking an experienced sales person with an understanding of technical courses to drive the business forward. Key courses: - Web development - Data science - Embedded systems - Cyber security - Digital marketing - Auto CAD - Adobe Photoshop - Robotics - SQL - AWS - Data structures and algorithms Ideal candidate should possess: - Proven sales experience in the e-learning or tech industry
I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions
I'm in need of a talented and experienced web designer to create a user-friendly business website that primarily showcases the services we offer (lawncare, hedge trimming, garden maintenance, pressure cleaning). The ideal candidate will be able to incorporate a photo gallery, testimonials section, and service booking system. Key Responsibilities: - Design a professional, visually appealing business website - Prioritize showcasing our services - Implement a photo gallery to display our work - Include a testimonials section to build trust with potential customers - Integrate a service booking system for easy customer interaction Requirements: - Proven experience in web design, particularly in creating business websites - Strong portfolio showcasing previous work - Proficiency i...
I need an experienced developer to extend my existing PHP SQL driven platform. This project revolves around adding innovative features to the current structure. . Your job will include: - Analyzing the current structure and proposing alterations to accommodate the new functionalities robustly. - Implementing these suggestions after my approval with special emphasis on maintaining the overall performance & responsiveness of my website. To be an ideal fit for this project, you should: - Have previously worked on expanding PHP SQL based platforms. - Be capable of producing detailed project proposals. Apply with your most detailed project proposal, including your understanding of this task, estimated timeline, milestones, and why you think you're suitable for this...
