Project vba sql database jobs

We are looking for a skilled database architect to design and manage the database architecture of our social media platform . The ideal candidate will have a deep understanding of database management systems and data modeling techniques. Feature in application : 1. User details 2. Upload a video feature like shorts and reels 3. Post a content like Linkedin 4. There are different types of video's category 5. Likes, comments, share 6. Other features Relevant skills for this role include: - Proficiency in database management systems in PostgreSQL - Expertise in data modeling and schema design - Strong understanding of database optimization techniques - Hands-on experience with SQL queries and performance tuning - Knowledge of database ...

...support. Database Management - Manage and optimize MySQL database interactions within the WordPress environment, ensuring efficient data retrieval and storage. System Integration and Testing - Oversee the integration of all system components, employing best practices in continuous integration and deployment to maintain system integrity and performance. Documentation and Support - Produce detailed documentation and user guides for the system architecture, API interfaces, and operational procedures. Provide ongoing support and troubleshooting to ensure system stability and user satisfaction. Essential Skills and Qualifications: - Expertise in using Visual Studio for software development, including .NET and PHP programming. - Proficiency in Azure DevOps for ...

...is passionate about coding and eager to learn. In this role, you will have the opportunity to work on exciting projects, collaborate with a talented team of developers, and gain valuable experience in backend development. If you have a strong foundation in programming and a desire to grow your skills, we want to hear from you! Responsibilities: Collaborate with senior developers to understand project requirements and translate them into technical specifications. Develop and maintain backend systems and applications using industry-standard programming languages and frameworks (e.g., Python, Node.js, Django, Flask). Write clean, efficient, and well-documented code that adheres to coding standards and best practices. Participate in code reviews to ensure code quality, reliability,...

I urgently need to create manual backups for my Remote Microsoft SQL Server database using VB.Net. This project requires an experienced VB.Net developer who has in-depth knowledge of SQL database operations, particularly in the area of Remote backup and recovery. The right candidate should be proficient in: - VB.Net programming - Microsoft SQL Server database management The timeline is of utmost importance as we need this running as soon as possible. Please provide evidence of comparable projects you've completed. Looking forward to a reliable and efficient solution.

I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional who can d...

As a growing organization, we are seeking skilled administrators to join our team. We are looking for passionate individuals in three specializations - office administrators, HR administrators and database administrators. The ideal candidates should possess the following: - Strong communication skills, - Proficiency in Microsoft Office Suite, and - Experience with database management. Applications should include: - A cover letter explaining why you're the right administrator for us, - Educational certificates to validate your qualifications, and of course, - A detailed CV showcasing your previous experiences. Looking forward to receiving your applications and potentially welcoming you to our driven team. Apply now and make a difference!

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I need a Form Builder project using ASP.NET to create a form builder website with a simple authentication sytem (sign up and login using email , password) I need a form builder project using asp.net 1- registration with signup and login 2-A form builder with the full input controls such as : checklist, text fields, dropdowns, radio buttons, etc... 3- be able to create forms or fill out forms 4- need a database to save all answers and databases 5- Ability to translate the page from english to arabic. (I really need it done before 18/5)

I'm looking for a database design expert to help me create a new database. The specifics are a bit unclear at this stage, so I'll rely on your expertise to help me determine the best database type and functionality. Key Responsibilities: - Partner with me to decide on the most suitable database type, considering the intended purpose - Design the database from scratch, ensuring it's optimized for efficient storage, retrieval, and maintenance - Implement any necessary functionality to support the database's purpose Ideal Freelancer: - Proven experience in database design, particularly in creating new databases - Strong knowledge of various database types (relational, NoSQL, object-oriented) - Ability to collaborate and c...

...an internal business tool/website. A very BASIC MS SQL schema will be provided for Functionality to interact with. The project includes: The development of a lightweight css, jquery design that is simplistic but still looks ok. Static Pages - Home - Contact Us - About Us Functionality Pages - User Registration - User Login - User self management) - Password reset via email. - User Management admin The sample should show, connecting to an ms sql database. Displaying data through a non defined data source eg (a query enbeded in the code) as well as a defined Datasource. The site should use headers and footers. VS2022, has a sample site, it could be possible to simply use that and make the 'users' logging in / connecting to the database...

I am looking for a seasoned Oracle Apex developer with a knack for artistic flair to develop a unique user interface for our new application. Specifically, your role will revolve around: • Leveraging SQL to create an aesthetically pleasing, functional user interface that aligns with Oracle APEX principles. • Leveraging your design prowess to develop an artistic, visually-engaging user interface. Your competencies should include: • Proven proficiency in Oracle APEX and SQL • A portfolio showcasing previous user interface designs, ideally within the Oracle APEX framework • A keen eye for artistic, visually pleasing design aesthetics • Superb problem-solving abilities while working within design constraints. Prior experience developing simila...

...this project, I am seeking a dedicated individual to manage the customer service aspect of my business and to take charge of a small database (containing up to 1,000 records). Key responsibilities will include: - Customer Service: Responding to client enquiries, resolving user issues, and maintaining high customer satisfaction levels. - Database Management: Handling information pertinent to the customer service role, conducting regular updates, ensuring record accuracy, managing data privacy, and maintaining overall data integrity. The ideal candidate would have: - Prior experience in a customer service position, demonstrating excellent communication and problem-solving skills. - Proficiency in database management, more specifically with small scale datab...

...I want the tracking of the inputs to function. My "coding" ability is a limited working-knowledge of JavaScript PDF and Excel VBA. I need someone to provide council and advise on what is possible, what tools or platform would be best for the end product I want to develop, and to advise on any alternatives. Basically, I am in the early stages of a long development process and I need an expert coder to review my outline and provide advise for the best way to accomplish what I want. This project is very large, so I would like to start with a very high-level review of my concept: Current job and price is for 1) The review of a 2-page outline of my development project, up to (6) PDF and/or Excel documents that are currently in use, and (1) Excel-Based product...

...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 should have: ...

I am seeking a Java expert to build a simple and efficient Java Servlet application that will seamlessly connect to my Oracle 19c database via JDBC. Key requirements for the project: - A Java Servlet application tailored to connect to Oracle 19c database - The application should be able to execute both read and write operations on the database. - The solution should be robust, secure, and optimized for performance Ideal candidate for this project should have: - Proven experience with developing Java Servlet applications - Strong background in working with Oracle databases - Proficiency in JDBC and database management - Familiarity with database read and write operations - Ability to deliver a high quality, efficient and well-documented so...

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

We have an internal database with about 2000 European investor profiles from the last 20 years. I'm looking for a skilled developer to integrate OpenAI GPT to allow users to search for suitable investors in our database without needing to input a specific format, but normal text. the GPT then translates this text into a format of our database and based on a matching / scoring algorithm will select the best 10 investors for our set of 2000. The user should be able to go on our website. ask a question leave an email and get an answer with the top 10 list as an email attachment. That person needs to leave his contact details which will be automatically added to our Zoho CRM with a trigger action to setup a call for one of our sales people. Key Project Deta...

Error establishing a database connection This either means that the username and password information in your file is incorrect or that contact with the database server at localhost could not be established. This could mean your host’s database server is down. Are you sure you have the correct username and password? Are you sure you have typed the correct hostname? Are you sure the database server is running? If you are unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress support forums.

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

I need a simple app developed using Microsoft Power Apps. Th...the employees in our organization. There are a few reference tables like Project, Category, Expense type, etc and then there is a main table called Expenses which has project, category, expense type, quantity, price as the columns. These tables are currently available as part of my azure SQL database but I am open to suggestions if you want to store this data differently. The main screen would show a list of projects on the left. The right section will show details like total expenses, expense per category chart of the selected project. Upon clicking inside the project you will see a list of expenses. This screen should have functionality to add a new expense. There should also be sc...

I need a simple code to conect a accdb file with password in visual basic 6. It´s very simple. I need a code working with Visual Basic 6 SP6 The connection need to be by code.

Please Sign Up or Login to see details.

data base design (model, sql) 590 laravel auth customized for phone (ALMOST DONE) 2360 Referral logic 2360 referral page register configuration Event Script (creates new even every 3 min will be a cron job for linux) 3540 Additional Pages 2478 { withdrawal page 708 Account details 472 Recharge page 708 Contact us page 826 } Betting Page 4720 includes the following { time and result feature 2000 betting feature 1000 events feature 500 my history feature 500 } Admin Panel 8378 withdrawl 1600 user manage 2000 manage result 1700 past events 800 earnings 1000 TOTAL 21950

I'm in need of a PostgreSQL script that will loop through my table and update certain columns of the rows t...row. This script should be designed to handle the following requirements: - The script will be used to filter and update specific rows based on a static condition. This condition will remain unchanged. - The script needs to efficiently loop through the entire table and update only the rows that meet the specified condition. Ideal skills and experience for this job: - Proficient in PostgreSQL and SQL scripting. - Experience in writing complex queries and scripts for data manipulation. - Ability to understand and implement static conditions within a loop. - Clear communication to confirm understanding of the specific requirements and ensure the script meets the necessar...

I need a well-structured informational website built. Although it won't be focused on e-commerce, I plan on featuring over a 100 products to keep my users informed about my collection. Therefore, a comprehensive database to catalog these items is essential. The ideal candidate would have: - Proven experience in website creation with a focus on data presentation - Ability to design intuitive UI/UX - SQL or similar database management skills - Strong attention to detail as accurate presentation of all product information is crucial - Experience with JavaScript, CSS and HTML - SEO optimization knowledge is a plus. The timeline for completion is to be discussed. Please include examples of similar projects you've completed in your proposal.

: logo with display menu: select option: Subdomains Directories sensitive parameters 4. SQL Testing 5. xss Testing 1- : (use this open source code) Options: -d, --domain: Specify the target domain. -b, --bruteforce: Enable subdomain bruteforcing. -o, --output: Specify the output file path. -h, --help: Display help information. example subdomain -d -o /home/Desktop/ This option leverages various search engines like Google, Bing, Yahoo, DNSDumpster, VirusTotal, SSL, etc., to discover subdomains associated with the target domain. 2- find Directories: (use this open source code) Options: -u

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

I'm in need of assistance for setting up a PostgreSQL database on my backend GitHub website. The primary purpose of this database is to store user data. Given the nature of my website, it's essential that the database supports concurrent access efficiently. The ideal professional will have: - Proficiency in setting up PostgreSQL databases. - Experience with integrating databases into backend GitHub projects. - Knowledge of concurrent access management in databases.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

We have existing wordpress woocommerce and C# MSSQL inventory win application db in azure db I am looking for a developer for backend operations and experience in MSSQL, WordPress wooCommerce and API integrations. The primary task deduct stock in azure ms sql stock table when order placed in wordpress woocommerce display item list in woocommerce based on mssql stock table create comand to generate order in inventory system when order placed in wordpress woocommerce Key Skills Required: - Strong experience with MSSQL, WordPress woocommerce, API - Expertise in inventory management system e-commerce integrations who have done same work earlier plesae bid I will share explaining video, if you are able to do than you need to work on remote zoom or ultraviewer plesae let me know...

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

I need...configure, and visualize data using a Power BI server. The data for visualization will be pulled from several resources such as SQL Server, SharePoint, Excel Spreadsheets, and Teradata. Key Responsibilities: - Setup and configure the Power BI server - Connect the server to mentioned data sources - Implement interactive data manipulation capabilities into the Power BI reports Ideal Skills and Experience: - Proficient in Power BI server setup - Experience with SQL, SharePoint, and Teradata - Excel data management skills - Competence in interactive data manipulation and visual analytics - Familiarity with report generation and data analysis Please note that this project requires an emphasis on interactive data manipulation in the Power BI reports, so this p...

Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me?** - ...

I'm in need of a professional who can create a straightforward database with a user-friendly GUI for Windows. Key Requirements: - The database should be able to store and retrieve data efficiently. - It should feature a GUI for easy interaction. Ideal Skills and Experience: - Proficiency in Windows database development. - Prior experience in designing user-friendly GUIs. - Strong knowledge of data storage and retrieval techniques. Please let me know about your relevant experience and a rough estimate of the time and cost required for this project. Thank you.

A reliable database migration specialist (with previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Fa...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

As a beginner level MySQL user, I am seeking someone to sit with me (virtually) for approximately 2-3 hours to aid me in running certain MySQL commands with some provided databases. Beyond this, I need assistance in creating a new database from scratch. The session will be conducted via Zoom, and it's vital that you have the requisite MySQL software and databases already installed on your own device. My needs during the call include: - Writing MySQL commands - Understanding MySQL commands - Creating a fresh MySQL database Ideal freelancer for this task would have a strong command of MySQL and proven experience in teaching or tutoring, as well as excellent communication skills in English.

As an established business relying heavily on a comprehensive tech stack, I'm in need of a seasoned .NET developer for a variety of tasks. Key responsibilities include: - Review and optimization of existing front-end, back-end, and database systems - Ongoing maintenance, troubleshooting, and improvements to enhance system performance Ideal candidates for this project should have prior experience with: - Front-end development utilizing HTML/CSS - Backend technologies such as SQL Server and Entity Framework - A strong grasp of the .NET framework This role is crucial to the successful functioning of our systems, so a proactive, detail-oriented approach and excellent problem-solving skills are must-haves. Your ability to communicate issues and improvements clearly...

I'm in need of a versatile software that can record video from endo...record video from endoscope cameras and facilitate the creation of a database from each video. Key requirements: - It should be compatible with Windows and Mac operating systems. - I prefer storing the database locally on the same device. - The software must support video formats AVI and MP4, which are the formats the endoscope cameras I use record in. The ideal freelancer for this project should have experience with: - Developing video recording software - Implementing database management systems - Proficiency in working across Windows and Mac operating systems - Knowledge of AVI and MP4 video formats Please submit your proposal with relevant experience and a clear explanation of ho...

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

WordPress & Database Speed Optimization required : 1- Database optimization as one of my plugins is sending queries to DB - some time causing connection Error - or unreachable host Error. 2- Without CDN if possible 3- Including Premium plugin - I have 10 web booster Pro subscription. - If required. 4- Automatic Photo Optimization 5- Permanent solution. 6-Minification - if required. Urgent start up required, who is free and can finish asap.

I've built a web application using .NET for the backend, Angular for the user interface, and SQL database. Now, I'm looking for someone to help me publish this website on the cloud and make it live. It's a small web app designed for a local business, with a limited number of users (around 15-20). Because of this, I'm aiming to keep costs as low as possible. I'm open to suggestions on which cloud platform would be best suited for this project. If you're interested in taking on this task and helping me get my website up and running, please reach out. Thank you!

I’m looking for an expert with MySQL skills to help me write a query...the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this off. Therefore excellent communication and patie...

I am in need of a detail-oriented individual to help with a data entry project. This involves manually entering alphabets into an Excel spreadsheet to create a comprehensive database. For this task, you should have: - Excellent attention to detail, as the entered alphabets should be strictly in lowercase. - Proficiency in Excel, as the data will be used to compile an Excel spreadsheet database. - Ability to work diligently on a potentially repetitive task. Your primary responsibility will be to manually input the alphabets into the spreadsheet with absolute accuracy. As it's vital that each data entry is correct, having strong attention to detail is paramount for this job. Experience in data entry and Excel is a must.

**Project Scope** Seeking skilled Data Analyst specializing in PUBG Mobile to elevate our team's performance using data insights. Project goals: * Performance Baseline: Deep understanding of our team's key metrics (individual players & team stats). * Competitive Benchmarking: Analyze opponents to uncover strengths, weaknesses, strategic tendencies. * Optimal Rotation Analysis: Decipher winning map rotation patterns from videos. Find areas we can improve. * Data-Driven Recommendations: Provide clear report on insights and suggest changes to team composition, drop spots, in-game decisions. **Project Deliverables** * Structured dataset in Google BigQuery with our team's gameplay stats + relevant opponent data. * SQL queries designed for meani...

Please fix my task that we spoke about

...help me with an intermediate level project. The ideal candidate should have experience in these areas and be comfortable starting a project from scratch. I will give you a dump from my MySQL table. From which I need an interactive HTML interface, based on Perl, HTML, HTMX to this table. I need to be able to search, add, edit and delete entries as well as combine two entries into one, all via one HTML::Template file with a single perl script as interface to the MySQL table. I do want an active submit button for all changes, as well as a single interactive upload button for each field of the MySQL table. also each field needs to be validated via a given specification. All code needs to be well documented and commented. Perl based database interaction needs be "...

I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding...

...experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic function...