Relatório sqlmunkák
Hello, I need Microsoft SQL Server Mgt Studio query for a large dataset 1,000,000's of rows, which - only looks at the rows with the latest revisions (identifable by a revision no); - and for this latest data, sums selected fields to aggregate the data - and applys the above for a selected subset (region) and from date A sample (dummy) dataset and more detailed requirements is provided/attached (excel)
I am seeking an SQL expert with significant experience in SQL Server and data analysis. This project involves the management of personal data requiring precision and security. You will need: - Demonstrable experience with SQL Server. - Experience handling personal sensitive data. - Proven track record of executing data analysis operations. The key task will be to extract insights from substantial personal information datasets. The qualified freelancer will need to demonstrate in-depth knowledge and experience with SQL Server, data analysis, and handling personal data. Strict adherence to data privacy rules is compulsory.
Seeking a database developer adept in creating a user-friendly, star rating system for my website. This will allow users to review and rate companies. Requirements for this project are: * Development of a database to be integrated into an existing website. * Set up a star rating system through which users can rate compa...companies. * Establish categories for rating - I've left this open for discussion, so expertise in creating impactful categories is appreciated. * Star rating should visibly translate into results, displayed out of a total of 5. Consideration will be leaned towards those with experience in developing interactive databases and user rating systems. Advanced skills in programming languages such as SQL, PHP, Python or Ruby are a huge plus. Looking forward to ...
I am looking for a developer who can help me convert specific PayPal transaction data to SQL in a DevExpress XAF XPO application using C#. The ideal candidate for this project should have experience with C# programming, DevExpress XAF XPO, and SQL database management. Specific requirements for this project include: - Converting PayPal transaction data, including Transaction ID, Amount, and Customer Information, to SQL format - Working with a relational database structure - Completing the project within a timeline of less than 1 month If you have the necessary skills and experience, and can meet the specified timeline, please submit your proposal. Thank you.
Ho la necessità di utilizzare un software personalizzato che si appoggia a Microsoft SQL. Sui nuovi MAC Chip M non è possibile installare Microsoft SQL per cui è necessario utilizzare Docker Desktop che deve essere configurato per far funzionare il mio software in ambiente Windows 11 ARM. La configurazione standard di Docker, effettuata dai tecnici Parallel, non è sufficiente per installare un localhost sul quale appoggiare il mio software. L'obiettivo è far ripartire il mio software. Il progetto sarà assegnato se si riesce a riattivare il mio software
I am looking for a developer who can help us create internal database, write api queries to automate extracting data from suppiers and sales platform, and create apps using Retool. Experience in Postgre...queries to automate extracting data from suppiers and sales platform, and create apps using Retool. Experience in PostgreSQL, JavaScript, and structuring database schema will help me with a project. The primary goal is to establish a functional database connected with API for automated workflows. The timeline for the project is flexible. Ideal Skills and Experience: - Storng proficiency in Postgre SQL and JavaScript - Experience with database schema development - Experience with Retool app development - Knowledge of workflow automation techniques - Ability to work within flexible...
I'm in need of a SQL expert who can quickly resolve an issue I'm having with incorrect results from my queries. I'm not entirely sure which database management system I'm using, so a solid background in multiple systems such as MySQL, Oracle, and PostgreSQL would be ideal. I require immediate attention, as I need the project completed as soon as possible. This job requires: - Strong SQL skills, with experience in troubleshooting and resolving issues - In-depth knowledge of different Database Management Systems - Excellent problem-solving and attention to detail - Ability to explain complex issues in simple terms. Your prompt response is much appreciated.
...building customer-centric software products · Analyze existing software implementations to identify areas of improvement and provide deadline estimates for implementing new features · Develop software applications using technologies that include and not limited to core Java (11+ ), Kafka or messaging system, Web Frameworks like Struts / Spring, relational (Oracle) and non-relational databases (SQL, MongoDB, Hadoop, etc), with RESTful microservice architecture · Implement security and data protection features · Update and maintain documentation for team processes, best practices, and software runbooks · Collaborating with git in a multi-developer team · Appreciation for clean and well documented code · Contribution to databas...
I am looking for an experienced Oracle Forms and Reports 11g developer to assist with an intermediate level project. The project has no specific timeline and requires expertise in handling intermediate complexity tasks. Skills and Experience Required: - Proficiency in Oracle Forms and Reports 11g - Strong understanding of database management and SQL - Ability to work independently and meet project requirements - Experience in developing intermediate level projects using Oracle Forms and Reports 11g - Attention to detail and ability to troubleshoot and debug code If you have the necessary skills and experience, please submit your proposal.
I am looking for a freelancer who can assist with the maintenance and repairs of my Microsoft Access SQL server. The specific tasks that I need help with include database optimization and we have an error 3464 for mismatched information in "booking Notifications". the database contains Credit card information so it is safety sensitive. The size of my database is less than 1 GB. I already have a backup plan in place for my database but it will need to be updated/merged if repair can not be implemented in a short period of time. Ideal Skills and Experience: - Strong knowledge and experience in Microsoft Access SQL server maintenance - Expertise in database optimization - Familiarity with query optimization - Experience with data migration would be...
...Freelancers, I hope this message finds you well. I am currently seeking a skilled Python developer to assist with the creation of a script that can establish a connection to a Google SQL server. Project Overview: I have a Google SQL server set up on a Windows server, and I need a Python script that can connect to this server. Requirements: Proficiency in Python programming. Experience working with Google SQL databases. Strong understanding of database connectivity and security best practices. Scope of Work: The selected freelancer will be responsible for: Developing a Python script to connect to a Google SQL server. Implementing secure authentication methods. Ensuring the script is robust and error-resistant. How to Apply: If you are interested in taking...
Im looking to update an ms access application from 32 to 64 bit. Set-up: 2 files, 1 program, other pure data - Basic functions of buttons (printing, updating, sorting) - VBS some scripting for special routines & functions - SQL import/export The app has a number of functions, but I'm not sure in how many cases there will be an effect on them because of the upgrade from 32 to 64 bit version of access Here are some extra points: 1. we import xls files into the database daily. 2. we import data from csv files daily 3. we export data to csv files 4. we export data to a MYSQL database 5. it is basically an ordermanagement and shipment app So in short, we import orders, we add shipping data, create shipping labels and import/export data in various formats
I am looking for a Python programmer to develop a Python program with the following specific functionality: 1) Bulk-open all excel files ...project 32 bit compilation (or give a class on what to install in my computer and how to create compiled .exe files) 64 bit compilation The expected timeline for completion of this project will be determined according to the quote provided by the freelancer. Ideal skills and experience for this job include: - Proficiency in Python programming language - Experience in data management and CSV, SQL, tables, Excel and scrapping - Knowledge of GUI development Please provide a quote and estimated timeline for completing the project. Botted answers are going to be ignored. If your response don't begin with "NoBotAllowed" it will ...
I am looking for an experienced .Net developer, well versed in Net MVC/Core and DevExp...DevExpress to develop a new module in the web application as described below:. Key Functionalities: * We will use as a control data source the Microsoft SQL Server Analysis Services Data Depth: * We are using two devexpress web controls in particular, which are: Pivot Grid: BI Dashboard - Ideal Skills and Experience: * Expertise in .Net, MVC Core, and DevExpress * Proficiency with data analysis and reporting functionalities * Experience handling User Activity Data is a big plus. * Microsoft SQL Server Analysis Services Over to you now. Do you think you can do it?
I am in search of an experienced Java developer who possesses excellent knowledge of the Angular framework and Microsoft SQL. The main scope of this project is centred around three key aspects: - Java development - Angular Framework - Microsoft SQL For this project, I require specific functionalities which include: - Database integration and management: You will need to link the application with a Microsoft SQL database and efficiently manage data flows. - Data visualization and reporting: The application should be able to generate insightful reports and present data in an easily digestible format. - Business Logic and UI changes: Apart from backend tasks, I also need someone who can make significant changes to the user interface and business logic based on user int...
I am looking for a data scraper who can help me with my project. The ideal candidate should have experience in web scraping and be familiar with SQL databases. Specifics: - The project involves scraping website URLs. - The scraped data should be stored in an MS SQL format. - The data needs to be scraped continuously, on an ongoing basis. Nature of Work: - Retrieve Data (15 mins & Hourly Table) - Summary / Technical Indicators / Moving Averages Tables Data - Add option to change MSSQL login & pwd details - Attached Screenshots for Reference data Tables - Retrieve data continuously from below url's
...how to interpret user interaction data. Your role will involve not only setting up the tracking system but also providing insights based on the data collected. With your help, we aim to improve the user experience and functionality of our Power BI dashboards and reports based on the insights gained from this activity log. The information we need to collect needs to be saved in a database on Azure SQL Server or as a second option in a blob storage. For this project, I want to use something called the Get-PowerBIActivityEvent PowerShell cmdlet rather than the Get Activity Events REST API. The project will automatically check for user activities from the day before, it could be shceduled in a server or similar. We will run this every day making sure to get all the information from...
I need to create a schema to manage data about shipments and packages. See details in the following file. Skills and Experience: - Strong experience in building database schemas using MySQL - Familiarity with database design principles and best practices - Ability to suggest and implement a suitable structure for the database schema based on the client's requirements - Proficiency in writing efficient and optimized SQL queries - Attention to detail to ensure data integrity and security measures are implemented - Excellent communication skills to understand and clarify the client's needs and provide regular updates on the progress of the project.
Full Stack React Developer with Node.js, SQL, and Python I am looking for a Full Stack React Developer with expertise in Node.js, SQL, and Python to assist me with my project. The ideal candidate should have experience in the following areas: Skills and Qualifications: - Strong proficiency in React.js and Node.js - User registration and login integration. - Proficient in SQL, specifically MySQL - Familiarity with Python - Experience with API integration - Host site in windows server. Project Requirements: - User registration, login, and 3 Level user dashboards. - API integration: The project requires seamless integration of APIs to enhance functionality and optimize user experience. - Timeline: The project needs to be completed within a month. - Database: The pre...
Hello, Please read carefully : SQL Expert Only ! I am looking for someone who can build me a sql function that will transform a text column into a 10 characters/digits column. If the text column have duplicate then the 10 characters should be the same in the new column. Also the function must avoid any collision : 2 different text cannot have the same 10 characters. A check must be done to avoid colision. Thank you.
I am looking for a skilled developer who can customize existing features and fix bugs on accounting CRM system I have purchased. The system based on CodeIgniter framework (files: JavaScript JS, CSS, PHP, SQL). The changes needed have a high priority and must be completed within 2 weeks. Ideal Skills and Experience: - Strong experience in customizing CRM systems and fixing bugs - Proficiency in coding languages such as PHP, JavaScript, and SQL - Familiarity with accounting principles and workflows - Attention to detail and ability to understand and interpret user requirements - Excellent problem-solving and troubleshooting skills
...candidate should have a solid understanding of research methodologies and be able to support our research objectives through the use of GIS. Ideal skills and experience for the job: - Proficiency in GIS software and tools such as ArcGIS, QGIS, or similar. - Strong understanding of spatial analysis and modeling techniques. - Experience in data management and database design, including knowledge of SQL or other database query languages. - Familiarity with research methodologies and the ability to apply GIS techniques to...
Project Description: Restore a Encrypted Database on Azure SQL Managed Instance - I am looking for a skilled professional who can help me restore an encrypted database on Azure SQL Managed Instance. The database has been encrypted using TDE (Transparent Data Encryption). - The client is not sure if they have the necessary decryption keys for the database, so the ideal candidate should have experience in handling TDE encryption and should be able to assist in verifying the availability of decryption keys. - The restoration of the database is not urgent, so there is no immediate deadline. However, the candidate should be able to complete the task within a reasonable timeframe. - The ideal candidate should have experience working with Azure SQL Managed Instance and shoul...
I'm in need of an expert freelancer, proficient in PHP, JavaScript, and SQL, to remedy feature malfunctions and augment missing functionalities in my application. Based on the complexity of the task, only one diligent developer will be responsible for undertaking corrections and improvements. The bugs are mainly related to several feature malfunctions whilst adding significant features that are currently missing. Specific examples will be provided later in order to target the issues accurately. Ideally, prior experience in advanced app debugging and enhancement, along with an acute understanding of system architecture, will be beneficial for this project. Understanding customer needs for better UI/UX will be advantageous in this role.
Job Description The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills. The successful candidate will be responsible for the configuration and maintenance of the SQL Server Warehouse and performing data backups and supporting issues of multiple development teams. Must be capable of working independently and collaboratively. Responsibilities - Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. - Configure and maintain database servers and processes, in...
I'm looking to have both WordPress and Joomla hosted on my domain. The primary domain will house the WordPress site while the Joomla...Joomla hosted on my domain. The primary domain will house the WordPress site while the Joomla platform would be settled on the subdomain. For this project, you will not only help me setup Joomla 5 on my subdomain, but also assist in restoring a backup joolmasite and SQL file. The Joomla website has already been created and a backup, along with an SQL file, is ready for use. Key requirements for this project: - Experience with WordPress and Joomla installation - Knowledge of hosting and subdomains - Skill in backup and SQL file restoration I look forward to your bids and more importantly, looking forward to getting our platfor...
Criar um banco de dados pesquisavel com painel de controle (integração SQL e Power By) para armazenamento e pesquisa de dados de vendas e propostas, com avaliação de propostas de concorrentes. pesquisável por cliente, código parcial e total, descrição do produto parcial, concorrente, data.
...history 5.2. Sort chats by new / find by date / find by user 5.3. Customer Support Chat backend 5.4. Use best practice for chat data management 5.4.1. Optimize Database Reads and Writes 5.4.2. Cache Data Locally 5.4.3. Query Optimization (Eager loading) 5.4.4. Use Pagination 5.4.5. Optimize Database Design (Normalized schema, indexing) 5.4.6. Use HTTPS and encryption, secure database 5.4.7. SQL Injection Prevention 6. Gallery 6.1. View all images uploaded on the app by users, in one place 6.2. Use some kind of CMS 6.3. Ability to search images per user 6.4. Images in pet sitter profile should have tags and attributes for SEO (Alt text, title, description, etc.) 6.5. All images need to be compressed to good ratio resolution vs. storage size 7. Settings 7.1. Ability to set i...
...Requirements: • Strong experience in web development with a focus on mobile user experience, particularly for iPhone users. • Expertise in JavaScript, including familiarity with popular libraries and frameworks. • Proficient in C# MVC framework, with the ability to integrate JavaScript seamlessly. • Must have access to Bitbucket and Visual Studio 2019 for development and version control. • Must need to have SQL express installed. • Ownership of an iPhone (latest model preferred) for testing and development. • Decent problem-solving abilities, with a keen eye for user interface design and enhancing user experience. • Decent communication skills, capable of providing regular progress updates and actionable insights. Candidates requires to sh...
I am seeking an SQL expert with significant experience in SQL Server and data analysis. This project involves the management of personal data requiring precision and security. You will need: - Demonstrable experience with SQL Server. - Experience handling personal sensitive data. - Proven track record of executing data analysis operations. The key task will be to extract insights from substantial personal information datasets. The qualified freelancer will need to demonstrate in-depth knowledge and experience with SQL Server, data analysis, and handling personal data. Strict adherence to data privacy rules is compulsory.
I'm in need of a skilled data analyst to join my project. The tasks you'd be handling include, but are not restricted to: - Cleaning and preprocessing data - Data visualization - Statistical analysis Expertise in Python, R, and SQL is a must. You will mostly be dealing with data from various sources such as excel spreadsheets, CSV files, and database systems. A strong attention to detail and ability to interpret complex data are crucial for this role. Looking forward to work with someone passionate about data and ready to drive valuable insights.
I'm seeking an experienced NodeJS MongoDB SQL Developer to further enhance my existing website by adding new features. The specific features intended to be added aren't particularly outlined, presenting an opportunity for you to get creative with me and present your ideas. An engaging detailed proposal would be greatly appreciated and will significantly boost your chances of being selected. Ideal skills for the job: - Expertise in NodeJS, MongoDB, and SQL - Previous experience in implementing new features to existing sites - Knowledge in user authentication, data filtering, and real-time data updates would be a bonus. Since the area of the website where the new features are to be implemented isn't defined, it's crucial that the freelancer is able to w...
...Requirements: • Strong experience in web development with a focus on mobile user experience, particularly for iPhone users. • Expertise in JavaScript, including familiarity with popular libraries and frameworks. • Proficient in C# MVC framework, with the ability to integrate JavaScript seamlessly. • Must have access to Bitbucket and Visual Studio 2019 for development and version control. • Must need to have SQL express installed. • Ownership of an iPhone (latest model preferred) for testing and development. • Decent problem-solving abilities, with a keen eye for user interface design and enhancing user experience. • Decent communication skills, capable of providing regular progress updates and actionable insights. Candidates requires to sh...
I am seeking an SQL expert with significant experience in SQL Server and data analysis. This project involves the management of personal data requiring precision and security. You will need: - Demonstrable experience with SQL Server. - Experience handling personal sensitive data. - Proven track record of executing data analysis operations. The key task will be to extract insights from substantial personal information datasets. The qualified freelancer will need to demonstrate in-depth knowledge and experience with SQL Server, data analysis, and handling personal data. Strict adherence to data privacy rules is compulsory.
I am looking for a skilled freelancer to assist me as a collaborator on my web application project. Specifically, I need help with back-end development using the ASP.NET framework and SQL SERVER. I already have a project outline in place, so the freelancer will be able to jump right into the development process. For communication and collaboration, I prefer using a project management tool to keep everything organized and on track. Ideal skills and experience for this job include: - Proficiency in ASP.NET framework and SQL SERVER - Strong knowledge of back-end development - Experience working on web application projects - Familiarity with project management tools for effective collaboration.
...skilled developer to build a document management UI on a Sql database. The ideal candidate should have experience in creating user-friendly interfaces for document management systems. Features: - File upload and storage: The UI should allow users to easily upload and store documents in the database. - Document search and retrieval: Users should be able to search and retrieve documents based on specific criteria. Design preferences: - Minimalist: The UI should have a clean and simple design, focusing on functionality and ease of use. User count: - More than 50: The UI should be able to handle a large number of users, ensuring smooth performance and efficient document management. Skills and experience: - Strong knowledge of Sql database management - Experie...
I'm seeking an expert to help me develop a custom Camunda Tasklist application using .NET Core. Key features to be incorporated include: - User Task Management - Workflow Visualization - Integration with External Systems The application will leverage Microsoft SQL Server as the database management system. The ideal candidate for this project would bring a deep understanding of .NET Core, workflow modeling with Zeebe, and integration with SQL Server for robust database management. Working experience with Camunda Tasklist development is also an asset.
I'm looking for a skilled data scientist who is adept at handling various tasks such as: - Data Analy...skilled data scientist who is adept at handling various tasks such as: - Data Analysis: The key task includes analyzing small-scale data (less than 1,000 records). The depth of the analysis needed requires a thorough understanding of statistical and computational algorithms. - Machine Learning: Building predictive models and algorithms to interpret this data is essential. Proficiency in Python, SQL, and Java is a must, these being the primary tools for data manipulation. Relevant experience in handling similar data volume and the ability to generate effective solutions is ideal. Clear communication of findings, both in reporting and visualization, will be an expectation fo...
I am seeking an SQL expert with significant experience in SQL Server and data analysis. This project involves the management of personal data requiring precision and security. You will need: - Demonstrable experience with SQL Server. - Experience handling personal sensitive data. - Proven track record of executing data analysis operations. The key task will be to extract insights from substantial personal information datasets. The qualified freelancer will need to demonstrate in-depth knowledge and experience with SQL Server, data analysis, and handling personal data. Strict adherence to data privacy rules is compulsory.
Refactor bash script to work with AWS Lambda function and oracle rds in two days Skills and Experience: - Strong knowledge of SQL and bash scripting - Experience with RDS, AWS Lambda and serverless architecture - Understanding of refactoring and optimizing code - Ability to work under tight deadlines - experience in docker
I am seeking an SQL expert with significant experience in SQL Server and data analysis. This project involves the management of personal data requiring precision and security. You will need: - Demonstrable experience with SQL Server. - Experience handling personal sensitive data. - Proven track record of executing data analysis operations. The key task will be to extract insights from substantial personal information datasets. The qualified freelancer will need to demonstrate in-depth knowledge and experience with SQL Server, data analysis, and handling personal data. Strict adherence to data privacy rules is compulsory.
looking for an expert can make whatsapp chat bot can help my customers to query there balance my website is ready front end + back end ... just want whatsapp chat bot to reply the customer by getting data from my site ... I mean when customer send word "balance" to my number he receive his finale balance best regards
Hello! I need a junior developer I can pass work to. Ideally you should know and have some experience working with php, javascript and sql. Strictly no companies! I want an individual working from home. South Indian Tamil speaking preferred but not important. I have some big projects and need someone I can pass clean-up and the repetitive parts of jobs to. This is not fulltime. First part: Please create a small voice recording introducing yourself and your qualification experience etc. Also your hourly rate. Feel free to say what you want save as an mp3 and attach on here. You can also add work samples source code etc. Please only provide work you have worked on directly! I will check!!! Please start your bid with "I am ready to send a recording" and I will mes...
...MySQL. Java Spring Boot Development: Develop, test, and deploy high-quality Java Spring Boot applications. Implement RESTful APIs and integrate third-party APIs when necessary. Ensure code quality, maintainability, and adherence to coding standards. Database Management: Proficient in MySQL database management, including database design, optimization, and maintenance. Write efficient and optimized SQL queries and stored procedures. Troubleshooting and Debugging: Identify and resolve performance bottlenecks, bugs, and other technical issues. Conduct thorough testing and debugging of applications. Collaboration and Communication: Work closely with cross-functional teams, including front-end developers, UI/UX designers, and other stakeholders. Communicate effectively to share pro...
Busco un profesor para mysql y ejercicios de lenguaje de automatización en Linux.
I am looking for a developer to create a database for my project. Database Type: - MS Access Preferred Programming Language: - No preference Number of Tables: - This question was skipped Skills and Experience: - Experience in developing databases using MS Access - Proficiency in SQL and database design - Ability to work independently and meet project deadlines
Need machine production and job report. data available in SQL database
...Independent Contributor, who can support us for 8 hours a day over fixed schedules with the following skill set. Location: - Remote - India Experience -5+ Yrs Contract Tenure : 6 months + Extension Timings : 10:00 am to 07:00 PM IST 3+ years of .NET or JAVA development experience Exposure to Outsystems and/or Appian for Low-Code preferable 3+ years with relational databases 3+ years of MS SQL or MYSQL 1+ years designing and developing REST APIs Proficiency in C#, .NET, HTML, and/or Javascript Exposure to JIRA and BitBucket/Git for source control a plus Practical understanding of data structures, algorithms, and design patterns in a web environment Cloud first architectures (AWS, Azure, Cloudera, etc.) a plus Log aggregators (SumoLogic, Splunk) a plus ...
...and make it easier for others to understand. Make sure data is correct and can be used properly. Create and manage databases and tools to work with data. Make reports and cool dashboards that show important info. Build websites that people can use easily and that work on different devices. Fix any problems that come up on websites. Skills and Qualifications: Know how to use tools like Python, R, SQL, or others for data stuff. Use programs like Tableau or Power BI to show data nicely. Understand numbers and how to use them to help make decisions. Work with languages like HTML, CSS, JavaScript for websites. Be good with things like React, Angular, or Vue.js for making websites. Know about databases like MySQL or MongoDB. Make websites that look good and are easy to use. Solve pro...
