Sql commandsKazi

I require a skilled freelancer with experience in Amazon Web Services (AWS). We have a an ERP Developed on Laravel which is currently on a On-Premise Windows Server. We would like to move the application to AWS using a windows OS and SQL Server Database. Please guide as to which option would be better. The selected freelancer would have to set up a Windows operating system. Skills and Experience Required: - Proficiency in AWS, - Demonstrated experience deploying Please ensure to include examples of your previous AWS work in your bid. Your ability to efficiently handle tasks in the AWS environment is paramount for this project.

Step by Step Process to Host Asp.Net Web-Api Project into Docker Container. In both Windows & Linux. Explain with Sample Project. with all commands. Feel free to message me with your experience in these areas, and your availability to begin work. Thank you!

...candidates should have plenty of experience with Flutter Development, as well as a portfolio of past work to demonstrate their expertise. - Proficiency in Flutter development - Experience in developing for both iOS and Android platforms - Ability to work independently with minimal guidance You have to setup and configure both the flutter application (iOS and android) as well as the backend PHP, my SQL, firebase, docker etc. As the client, I did not specify the key features to be prioritized, giving you the flexibility to design the app in a way you find most effective. Similarly, there is no predesignated design requirement for the app, paving the way for creative freedom. Given the lack of specifications, the ideal freelancer should be highly creative and intuitive, capable...

We've developed an MS Access database front end with a SQL Server back end. Now we need to install both of these with government agencies in South America whose IT people only speak Spanish. We provide written installation instructions in English. Our clients can only meet the contractor online for server installations during business hours in American time zones. This is periodic work, installing databases whenever clients request them. At present we have six clients in the queue. The applicant must guide and troubleshoot each installation online in fluent Spanish. The successful applicant will have a record of relevant database work. We're a university-based not-for-profit.

MUST READ FIRST =============== MUST HAVE - Blazor experience of at least 3 years - Latest version of .NET & SQL Server - At least 1 hour of availability between 6:00PM and 11:00PM EST - Your price is the one that you REALLY want to have with 10% +- NOTE - APIs will be provided (you will not develop APIs) - No development will be done on My Computer. - DO NOT APPLY if your fees can exceed 10% or your bid PROJECT I have C# Blazor Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Make code debuggable. 2- Error message appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from APIs instead of...

I'm in need of a professional who is skilled in both graphics and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and data-dri...

...months to 15 months Position open: 2 Data scientists Key Responsibilities: - Perform data analysis and visualisation on trading or stock market data - Use your data science skills to provide valuable insights - Ensure the accuracy and efficiency of your predictive modeling Ideal Skills and Experience: - Proven experience in trading or stock market data analysis - Proficiency in Python, R, and SQL - Strong analytical and problem-solving skills - Prior experience with predictive modeling and algorithm development - Ability to handle a variety of data sizes and formats, as the size of the data may vary If you have previous experience in the trading industry and can confidently handle data analysis and visualisation, this opportunity is perfect for you. Your work will play a vita...

Tengo un Insert que proviene de una tabla que esta consumiendo mucho CPU al momento de ejecutarse, es un SP simple pero requiere de índices o validar que los que ya están creados no estén causando conflicto y aumenten el consumo del CPU

I am in need of a proficient and experienced Windows Server and Active Directory expert who can assist with troubleshooting (also by CLI commands). My system is fully set up, but I am currently encountering some server errors that need to be addressed. Key responsibilities will include: - Diagnosing and repairing server errors. - Enhancing command line management. - Help in effective Server and Active Directory configuration. The ideal candidate would have extensive experience with Windows Server, Active Directory and knowledge on CLI commands to swiftly identify and rectify any errors. Your goal is to improve the overall health and performance of my existing setup. Errors like failed test DFSREvent",and replication faults

...few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. 4. Agile, fast delivery, and responsive 5. Integrity, Honesty, Independently initiative, responsible, straight forward, loyal, modest, discipline, emphatically fair, hard wor...

...integrations. - Firestore for data storage, with new indexes created to improve the efficiency of data retrieval operations. === Third-Party Integrations - Use MarketCheck API for accessing up-to-date automotive data. - Integrate SalesGPT or similar AI models to support intelligent recommendations and customer interactions. - Employ tools like for additional functionalities like voice commands, reducing development time. == Implementation *Phase 1: Rapid MVP Development* - Refine existing FlutterFlow application setup. - Complete necessary Firestore indexing for optimal data use. - Integrate MarketCheck API and configure data usage. - Implement voice and chat functionalities using external tools like and GoHighLevel. *Phase 2: Enhancement and Scaling* (Futur...

I'm seeking a developer to create a Telegram bot for my group. The key feature I'm looking for is an automated welcome...an automated welcome message for new users, in order to improve the onboarding experience. Key Requirements: Everthing should be in Hebrew. - The bot should automaticly send welcome to a new member. - The bot should not allow posting between 11pm to 7am. - The bot should delete duplicates images from specific members during the same day (7am to 11pm) - The bot should avoid members to write bot commands. - The design should be professional and corporate in line with our group's image. Ideal Skills and Experience: - Proficient in Telegram bot development. - Experience with creating automated welcome messages. - Able to deliver a professional and co...

...this project should have proven experience in time series forecasting, Python programming, and developing interactive dashboards. A solid grasp of data visualization principles would be a plus. The output should be in a form of a python file with 4 models above and related dynamic visualizations. The text preprocessing is required and can be done in any necessary technologies (HADOOP/SPARK,NOSQL/SQL databases) - screenshots of the bash code are required....

Se debe mantener un sistema hecho en .Net el cual esta vinculado a una base de datos SQL Server de Microsoft. El postulante debe manejar a la perfeccion el idioma Español.

I'm searching for an expert in Visual Studio 2022, MS SQL, and VB.net, for the main objective of maintaining and updating an existing software application. Key tasks: - Primarily, the project will involve optimizing the application's performance. Skills and experience: - Experience with Visual Studio 2022, MS SQL, and VB.net is a must. - Proven expertise in software optimization. - Knowledge of system maintenance and updating.

I have a 500MB XML file that I need loaded into SQL across approximately 20 tables. I'm in need of a Python script to handle the transformation. The script will need to handle normalization of the data. Key requirements: - Develop a Python script to read the XML file and transform the data into a normalized structure across 20 tables. - You will need to create the SQL tables as part of the normalization process. - Experience with large data transformations and SQL is vital.

I'm seeking a skilled .Net developer to assist in developing a comprehensive retail system that has features such as user authentication and authorization, inventory and product management. Requirements: - Proficiency in C#, .Net, Entity Framework and SQL Server - Ability to develop a retail project from scratch - Strong understanding of user authentication and authorization - Experience in inventory management and product cataloging It's crucial that the chosen freelancer has prior experience in building online retail systems and a strong understanding of the retail business model. The ideal candidate should be able to deliver a secure, efficient and scalable retail project. Any experience with Angular/react/Node would be plus

I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.

...completion) Whereby; candidates can create a profile upload their CV, images or link to images and videos recruiters can search CVs with a Boolean type search functionality & save searches. Candidates and recruiters can message each other. Admin can manage the back end. Suggested technical skill set but not a complete one… • Cloud-based server solution • Azure or Single server solution • MS SQL Database (NoSQL document database might be more appropriate?) • OAuth • Payment gateway • .net We suggest design led development process where we sign off the look and feel of the web pages… the back end is for the supplier to advise the best scalable solution for the application. Please send your credentials/ skill sets and cost struct...

...managing user profiles, cataloguing orders, generating recommendations, and facilitating payment systems. 1. Implement a QR code as the entry point for users to access WhatsApp chat. 2. Utilize WhatsApp APIs to initiate chat sessions. 3. Employ Language Model (LM) capable of Hindi, English, and Hinglish for conversational interactions. 4. Integrate LM with backend logic for CRUD operations on a DB (SQL/NoSQL). 5. Store restaurant data including name, menu, pricing, and location details. 6. Capture user profile data such as name, preferences, allergies, and delivery addresses. 7. Manage user records and orders in the backend. 8. Prompt new users to provide necessary details. 9. Facilitate dish selection based on user preferences. 10. Display sorted dish options in sets of four ...

Description: I am looking for an expert in SQL and R programming for a detailed data analysis project. This project involves extracting, analyzing, and reporting on data from a sophisticated relational database setup. The ideal candidate should have a solid background in data science, with specific skills in SQL and R. Responsibilities: Efficiently query and manage data using SQL from a SQLite3 database. Apply R programming techniques for advanced data cleaning, analysis, and visualization tasks. Ensure data integrity and optimize data processing workflows. Analyze results to derive actionable insights and compile detailed reports. Document all processes and code in a clear and comprehensive manner. Requirements: Profound knowledge of SQL with experience in ...

...multi-channel signals. • Familiarity with line level audio signal processing and mixing. We need an engineer with deep experience in high-end analog circuit design using low noise operational amplifiers. We will provide basic diagrams and objectives. The project involves high quality op amps and line drivers for an audio routing project. We will be using FPGA platforms with SPI and TCP/IP to send commands to digitally controlled audio daughterboards in a card cage configuration. The proof of concept will include circuit design and a functioning prototype of two audio channel for control and noise and sweep analysis of the output. We have pre-selected chip sets and will provide prototype hardware....

Our company develops both desktop and web applications tailored for analysing insurance premiums. These have been developed in Delphi over the past 25 years. We are seeking to establish a long term relationship with an experienced Delphi programmer with exposure to Microsoft SQL databases. ASP.net application experience is also desirable. Our software packages require continued upgrading and enhancement and given the specialist nature of our software we are seeking to establish a long term relationship. The primary requirements include understanding our business process and system design, determining and articulating technical solutions, and implementing the design into build and install stages. Australian based is preferred, our principal office is based in Sydney NSW. If you...

I'm looking for an experienced .NET developer to assist with a project. This project requires someone who has a strong background in .NET technology, particularly in C# programming, ASP.NET development, and SQL database management. Ideal candidates should have experience in developing web applications, creating software solutions, and improving existing systems. The key functionalities to be implemented by the .NET developer in this project include user authentication, data encryption, and payment integration. If you're a .NET developer with a solid understanding of the above technologies and functionalities, please reach out to discuss the project further.

...in need of an hacker to perform a thorough black-box penetration testing on my WordPress website. Key Responsibilities Include: - Testing the security from an outsider's perspective. - Identifying and using hacking techniques including SQL injections, cross-site scripting attacks, and brute force attacks to hack website as outsider so that we can plug the vulnerability. Ideal candidates should have: - Proven experience in website vulnerability testing. - A strong understanding of WordPress. - Exceptional problem-solving skills. - In-depth knowledge of SQL injections, cross-site scripting attacks, and brute force attacks. My objective is to ensure my website's robust security, and your expertise can help me to achieve this. Your keen eye and tech skills are ...

...Management System (LMS). Features the AI Should Have: - Natural Language Processing to understand the queries of our users. - Speech Recognition to interact with student's vocal commands. - Text-to-Speech to read lesson to student and for conversion of audible answers. Integration Requirement: - The AI assistant should be seamlessly integrated with the PDF viewer in the LMS. - Data synchronization between the LMS and the AI virtual assistant needs to be maintained. Interaction With Students: - Assistant should offer a chatbot interface for text-based conversations. - Should accept and respond to voice commands. - Provide clickable options for simplified user journey. Ideal Skills and Experience: - Experience in OpenAI API or similar AI technology. - Proficiency ...

...of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your approach to automating daily database updates - Your estimated timeline for completing the pro...

I need help to Update a Server with Centos 7, WHM and cpanel to Centos Stream 9, i Cant give SSH access, I need the necessary commands to do the migration here

I am looking for a proficient python developer to help in enhancing a Telegram PHP bot. With your skills and experience in bot programming, I am confident we can have this bot become even better. As part of this project, you need to: 1. Customize Bot Commands: - Add new commands as per the specific requirements I will share. 2. Change Chatbot Responses: - Modify existing responses in a way that improves the user engagement. - Delete some responses that are no longer relevant. 3. Integrate Third-Party APIs: - This integration will help the bot offer more utilities and functionalities. The ideal candidate for this project should have extensive knowledge in Telegram bot development, PHP, Python, and experience in third-party API integration. I look forward t...

I'm in need of a proficient PHP developer to create a custom code for communicating with an Ingenico POS terminal via Ethernet. Here are the specifics of the project: - **Communication Method:** The primary method for the communication is through Ethernet. You need to be well-versed in this type of communication to tackle this task efficiently. - **...a plus Please note that this project is solely for the communication between the system and the terminal. There is no need for integration with the banking systems or any other external services. A successful candidate should be able to deliver clean, well-documented code that is easy to maintain and expand upon. I have the tcp ip connection documentation I just need php functions to do any commands as send amout, verify if p...

Looking for a skilled developer to fill in for a team member on vacation. The ideal candidate should have: - Strong experience in C# and ASP.net - Good knowledge of SQL Server The role involves: - Troubleshooting and fixing bugs in our existing applications - Enhancing and adding new features to our applications The projected timeframe for this position is less than a month, but the role could potentially be extended. You're being hired for not only your skills but also your problem-solving abilities - an essential trait when dealing with application bugs/issues. The key objectives for this role are: - Improving the performance and stability of our applications - Enhancing the user experience and application functionality Note: We skipped the outcome due to the job's shor...

I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.

I'm currently facing potential malware attacks causing unexpected slowdowns, particularly affecting my website load times. Hence, I'm i...security professional who can identify and rectify issues within my server files. Key Responsibilities: - Investigate the root cause for the slowdown of the website load times - Pinpoint potential malware in server files - Advance and fortify the security system to prevent future occurrences Ideal Skills: - Proficiency in cybersecurity - Solid understanding of server operations, particularly SQL - Experience in malware detection and prevention Your task: Use your expertise to bring back operational efficiency and bolster my domains server's security. If you can catch the malware predator and restore the peace of my server wor...

...equipo colaborativo, español nativo. b - JAVA2EE con experiencia superior a 2 años c- Conocimientos en programación Java Swing d- Experiencia en programación previa demostrable de al menos 1 año en programas de gestión tipo ERP, SGA, POS, CRM, facturación, contabilidad, etc. e- Entorno de trabajo sobre GITHUB, JIRA, ECLIPSE f- Conocimientos de programación SQL sólidos 2.- CERTIFICACIÓN PREVIA DE LOS PERFILES. a. Es para colaborar en un producto ya en explotación y distribuido en miles de instalaciones, por lo que la calidad y certificación previa son totalmente obligatorios. b. Por ese mismo motivo buscamos colaboradores permanentes y a mu...

I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table.  Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.

...continuously improve our data solutions Key Skills :- • Bachelor's degree in Computer Science, Information Technology, or related field. • 4-5 years of professional experience as a Data Engineer with a focus on Azure Databricks and Azure Data Factory. • Strong proficiency in SQL, Python, and/or Scala for data manipulation and scripting tasks. • Experience working with data lakes, data warehouses, and ETL processes. • Familiarity with cloud platforms (preferably Azure) and related services such as Azure Blob Storage, Azure SQL Database, etc. • Excellent problem-solving skills and attention to detail. • Effective communication and collaboration skills to work with cross-functional teams. • Azure certifications (e.g., Microsoft ...

need seo experts/developer to fix google search console/SQL index issue. we have many pages not indexed on gsc, need seo experts/developer to fix it. I'm currently facing an issue with pages on my website not being indexed and therefore not showing in Google's SEO results. It's crucial for the successful completion of this project to have these pages visible on Google again. Ideal candidates for this task should have: * Extensive experience with Google Search Console * Proven expertise in resolving indexing issues * A deep understanding of SEO best practices Please include your past work related to resolving such issues in your application. A detailed project proposal would certainly be a plus. Prompt completion is advantageous, although a precise timeline has...

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 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

We want to customize an open-source wysiwyg text editor to add AI commands, autocompletion, and similar features to it so that the students will be able to use it to write their research papers and essays. There is a similar website doing this; you can check it here: We will be using vanilla javascript, html, css, and node.js for this task. After awarding the project, we will share with you the open-source text editor link that we will be using in our application. Please mention in your application whether you can do this task, and provide a short brief description of how you plan to do it.

I'm in need of a website and custom...(Django/Flask), Ruby (Ruby on Rails), or PHP (Laravel).  Database: MySQL, PostgreSQL, MongoDB, or similar.  Web server: Apache, Nginx, or equivalent. 3. Payment Gateway Integration:  Select and integrate with a payment gateway provider that meets the project requirements (e.g., Stripe, PayPal). 4. Security Measures:  Implement secure coding practices to prevent common vulnerabilities (e.g., SQL injection, XSS).  Use encryption for sensitive data storage and transmission. 5. Hosting and Deployment:  Leverage existing hosting provider of the platform supports the required technologies; otherwise recommend an alternative platform.  Set up automated deployment pipelines for continuous integration and delivery (CI/CD).

MUST HAVE - Blazor experience of at least 3 years - Latest version of .NET & SQL Server - At least 1 hour of availability between 6:00PM and 11:00PM EST NOTE - APIs will be provided (you will not develop APIs) - No development will be done on My Computer. PROJECT I have C# Blazor Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Make code debuggable. 2- Error message appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 4- Packages Load from APIs instead of loading from DB (2 APIs) 5- Subscri...

...Existing Environments. Maintain Documentation For System Processes And Procedures. Participate In Code Reviews, Contribute To Team Knowledge, And Mentor Junior Developers. Required Skills: Strong Proficiency In Perl Scripting And Python Programming. Experience With XML Technologies, Including XML Parsing And XSLT Transformations. Good Understanding Of Relational Database Management Systems And SQL. Excellent Problem-Solving Skills And Ability To Think Analytically. Strong Communication And Interpersonal Skills, With An Ability To Communicate Complex Concepts To Non-Technical Stakeholders. Additional Qualifications: Experience With Web Technologies (HTML, CSS, JavaScript) Is A Plus. Familiarity With Software Development Methodologies Such As Agile/Scrum. Perks And Benefits:...

I'm in need of a skilled freelancer to set up and install Primavera P6 EPPM 21.12 locally on Windows. This is a single user setup, with SQL database configuration included. Key Tasks: - Install Primavera P6 EPPM 21.12 on a Windows system - Complete and configure the SQL database for the software Ideal Freelancer: - Experienced with Primavera P6 EPPM installations - Proficient in SQL database setup and configuration - Understands the intricacies of Windows OS - Prompt and clear in communication

...address and make a payment. Rating page. Users will be prompted to login before accessing this. Star ratings will be filled in here, and the welcome text will have each users [first_name]. Generate a custom QR code to a rating page with pre-filled order number (unique identifier from above) Order confirmation email. With animated banner and QR code. SQL database. All data from the users, questionnaires, orders, and ratings will be stored in a postgres SQL. I have specified the database design (see below). Currently there is no API to warehouse/shipping (postage of orders are handled manually, but please set up the database with the future API integrations in mind). Manual order (in backend). Basically, I want to be able to look at the sample ratings for each sample order a...

I'm in need of a skilled .NET developer to create...additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While this is currently marked as 'unsure', the ability to handle this efficiently would be a plus. Ideal Skills: - Proficiency in .NET development - Strong knowledge of SQL databases and data management - Experience in user authentication and registration systems - Previous work involving user role and permission management - Flexible to adapt and integrate external systems when required If you're a skilled .NET developer with a track record of creating user-centric web applicatio...

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 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