Freelancer desktop application windows database jobs

...Build Errors: My project has been spawning various build errors that hinder the execution of the application. The freelancer is expected to help identify and rectify these errors. • UI Layout Problems: There are also vital concerns with the user interface layout. Some pages don't render correctly on different screen sizes, and the general responsiveness of the UI is inconsistent. The task would involve pinpointing these problems and implementing effective solutions. • Platform: The application is to be developed for both Android and iOS platforms. Therefore, experience with cross-platform app development will provide a definite advantage. Please apply only if you can work via remote desktop (AnyDesk), have a robust internet connection, start...

Assist in writing answers for 3 questionnaires for Grant application criteria for an Allied Health Company demonstrating the company's setup All answers for the criteria's are to be written within 750 word limits each. Assessment Criterion 1: Service delivery [750 word limit] Describe how your organisation will deliver the services in the identified ACPRs in the application. Assessment Criterion 2: Stakeholder Engagement [750 word limit] Describe how your organisation will cultivate or expand links with other service organisations, infrastructure and resources, including the Regional Assessment Services (RAS) and other relevant specialist services e.g. dementia supports. Assessment Criterion 3: Efficient and Effective Use of Grant Funds [750 word limit]

I'm seeking a proficient individual to assist me with finalizing the setup of Social Bee on my Windows system. Key Requirements: - I've already begun the setup process and have some features working. I need someone to help me with the final adjustments. - The primary task involves setting up social media account integration within the Social Bee application. Ideal Skills and Experience: - Proficiency with Windows operating system - Prior experience with Social Bee or similar social media management tools - Adept at setting up social media account integrations - Strong attention to detail to ensure the setup is completed accurately and fully Please provide a quote and an estimated completion time for this task. Your assistance is much appreciated.

I'm seeking an experienced .NET programmer to add a new feature to my existing application. Specifically, I need a modification to bypass member search by using a querystring. The page concerned is this:- We wish to have a direct url that replaces the process of searching for a member (eg member no 161068) and arrives at page two directly. For example, entering 161068 in the search box and selecting Checkedandvetted then pressing 'review this company' moves the user to page 2- review your experience. This is what we want to achieve with a single url. This is so that we can provide a url like that will do the same as the previous steps. Ideal skills for this job will include: - Strong knowledge

I require a proficient WPF developer to design and create a user-friendly desktop application with the functionality and design, on par with that of Visual Studio. My project would need your expertise in: - Data Binding: Connecting the software to a database for efficient processing and managing of information. - UI Design: As Visual Studio served as inspiration, the application must have a clean, intuitive user interface, prioritizing user experience. - Navigation and Control: Implement a logical, coherent system to smoothly navigate around the application. The ideal candidate should have experience developing desktop applications, data visualization tools, and creating user-friendly interfaces, particularly in WPF. Familiarity with Visual Studi...

I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

I'm seeking a talented individual to enhance the design of my existing Windows software. The project involves: - Implementing a new color scheme: I'm looking to update the software's aesthetic with a fresh, modern color palette. The colors should be easy on the eyes and enhance user experience. - Improving typography: The new design should feature refined typography that is both visually appealing and easy to read. This will help to give the software a more polished and professional look. Experience in software design and an eye for modern, clean aesthetics is a must. Previous experience working with JavaScript and Angular is preferred as the software is built using these technologies. A strong understanding of UX principles is also desirable. Your role will be t...

I'm in need of an expert in software engineering, particularly in the realm of Windows game engine development using C#. The project requires the implementation of a robust physics engine into the game engine. Key Requirements: - Proficient in C# programming for Windows platform - Demonstrable experience in game engine development - Strong understanding of software engineering principles The main focus will be on integrating a physics engine into the existing framework of the game engine. If you have experience in creating 2D or 3D physics engines, that would be a huge plus. It is important that you are able to work independently and are self-driven, as the project will involve a lot of individual problem solving and innovation. Experience with multiplayer capabilitie...

This is a personal project questing for an adept software engineer or system administrator to create a multiboot machine. Ideally, this machine will be configured with both Windows 10 ISO and Ubuntu 22.04. However, instead of the conventional Grub, we will utilize the Burg Bootloader with the Metro theme. This is a technically demanding task requiring the following: - Profound knowledge in Operating System installations. - Expert ability to setup multiboot configurations. - Experience with the Burg Bootloader is highly desirable. - Familiarity with the Metro theme. The purpose of the multiboot configuration is to provide a platform where I can experiment with different operating systems. Please ensure the optimal setup is achieved such that I can independently manage the system ...

I need assistance to create a freelancer job account with a focus on income and expense tracking. This project will entail setting up a robust system, specifically designed to manage financial details. Key Tasks: - Establishing a freelancer account - Implementing a system for income and expense tracking - Ensuring this system can generate comprehensive financial reports Ideal Skills & Experience: The perfect candidate for this job would be someone with immense experience in detailed bookkeeping and solid technical skills in setting up job accounts. Proficiency in creating systems that can generate financial reports is of utmost importance. If you're an expert in these areas, you'll be the perfect fit for this task!

...on my CentOS server. The process /usr/sbin/mariadbd is showing 109% CPU usage in the WHM task manager, although the server load is stable and I haven't made any recent changes. Your primary task would be to diagnose and resolve this problem. No error messages or warning signs have appeared, making the source of the issue somewhat inscrutable. Access will be provided via AnyDesk or a remote desktop connection for swift and efficient troubleshooting. Your expertise in the following areas would be invaluable: - Proficiency in CentOS server administration - Expertise in WHM and server task management - Experience in identifying and resolving high CPU usage issues - Strong communication skills to work collaboratively and explain the fix If you are able to investigate and r...

I'm looking for a proficient developer who can add a page to my website that interfaces smoothly with my MySQL database. The website already has formatting etc, so I'm not looking for that. The database stores a variety of exercise data, and the webpage needs to display this data in an intuitive and user-friendly manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from ...

I'm looking for a ready made software with complete code base Key Features: - The software should offer a user-friendly interface to handle user management efficiently. Who should bid: - Freelancers who have prior experience in creating user management systems. - Proficiency in developing software compatible with Windows and MacOS. - Understanding of the unique needs of business users. Your bid should give me confidence in your understanding and ability to deliver on these requirements. Let's create a tool that simplifies user management for businesses across these key OS platforms!

I am looking for an expert Oracle DBA with experience in both Oracle RAC (Real Application Clusters) and standalone Oracle databases. The primary goal of this project is performance tuning. Ideal Skills and Experience: - Proven experience with Oracle RAC - Proven experience with standalone Oracle databases - Specialization in performance tuning - Familiarity with Oracle Database 19c Key Responsibilities: - Implementing performance tuning strategies - Monitoring and optimizing database performance - Troubleshooting issues related to performance - Ensuring the smooth operation of both RAC and standalone Oracle databases The ideal candidate should have a deep understanding of Oracle databases and be able to provide tailored solutions for enhancing performance on both O...

There are 4 slots to be chosen according to the devices availability. Only 1 test case is allowed per participant. Must have access to ONE or all THREE of the following devices: Android mobile (Android 5 and above) iPhone (iOS 12.4 or later) Desktop/Laptop All required screenshots must be in the English language. All required screenshots must show the current time (using notification or taskbar).

ONLY RE...for the current implementation are unknown as the previous question was skipped. In terms of hardware, my setup currently includes Windows and GPU. Thus, the successful freelancer should have experience working with these specifications and will consider this in the implementation process. The ideal freelancer should have an extensive background in Stratum v2 protocol, have efficient problem-solving skills, as well as have a competent understanding of mining software integration and optimization. Experience in working with Windows and GPU hardware is also a major plus. IN YOUR RESPONSE LEASE include - (1) how have you configured and set-up "tproxy in windows? (2) Have you used Awesome Miner? Have you used Minstrat? ONLY RESPONSES THAT...

I am looking for patent lawyer or licensed patent agent to help my Canada patent application: Application claims have Indefiniteness, Lack of Clarity, not comply with section 60 of the Patent Rules. If you can help, please submit your profiles, Thank you.

I am searching for an experienced programmer with skills in vb.n...development of a CanOpen protocol program making use of an IXXAT USB-CAN Converter. It run on windows 2000 operating system Key Responsibilities: - Develop a program using VB.Net/LabVIEW/Labwindows, capable of implementing the CanOpen protocol - Program must be able to read and write data to the IXXAT USB to CAN converter - The software should control devices using the CanOpen protocol Ideal Skills: - Proficiency in VB.Net, LabVIEW, and Labwindows - Advanced understanding of CanOpen protocol - Experience with IXXAT Converters It's essential that the chosen candidate guide me through the installation and testing process until we have a successful operation. The program must be compatible with Windows ...

I own a vacant property and have basic sketches of it. I'm looking for a planning agent who is a member of RTPI to apply for full plan permission. The main changes I want to make are: - Change the unit from Use Class E to residential (C3) - Use a summer house for acupuncture, massage, and herbal treatments (Sui Generis) The right professional for this role should have experience and expertise in the following: - Knowledge of UK planning regulations - Proven track record of successful planning applications - Experience liaising with local planning authorities - Excellent communication skills to keep me updated throughout the process I'm open to suggestions and advice, but the goal is to secure the necessary permissions for these changes in a timely manner.

I'm looking for a professional who can refresh the exterior of my home. The tasks at hand include: - Removing current siding and replacing it with a new, modern one. - Applying a new color that's contemporary and stylish. -Possibly changing the color of the windows too Since I've not decided on the color yet, a freelancer with a keen eye for aesthetics and a knack for color coordination will be appreciated. Samples or portfolios of your previous work would be ideal to see. Due to the urgency of this project, I'm interested in someone who's available to begin immediately and has a proven track record of delivering quality work swiftly and efficiently. If you have previous experience in home exterior renovation and think you'd be a good fit, I&#...

...as well as a transition from a sidebar menu to a bottom menu. I'll provide examples of interfaces that I like, which I'd like you to incorporate into the design. I have a few specific layouts in mind that I'd like you to integrate into the new design. I will provide those examples of other apps and drawings to you. I will also give you access to the current assets we have for our mobile and desktop app now in Figma. The ideal candidate for this project would have: - Expertise in UI/UX design for both iOS and Android - Proficiency in Figma - A portfolio showcasing sleek, clean, and intuitive mobile app designs - Experience in advanced app design would be a plus I'd love to see how you can turn my vision into a visually appealing and user-friendly reality...

...overseer of an exciting cross-platform application project, I am in need of a proficient Flutter developer. The project will require your expertise in various areas including User Authentication, Push Notifications, and In-App Purchases. The application needs to be compatible with iOS, Android, Web, and Desktop platforms. I have already prepared a specific design for the application, freeing you from the responsibility of conceptualization. Ideal skills and experience: - Profound knowledge in Flutter development - Experience with multi-platform app development - Practical understanding of user authentication, push notifications, video players integration, quiz, - Ability to work from an existing design and wireframe Your role will involve the applica...

I'm seeking a Customer implementation go-live implementation manager Need a very strong customer focused project manager skills Work with the business and customer teams managing multiple streams of work for a project implementation go-live Gap analysis on application deployment V implementation deployment Highly pressured deadline, with lots of client focus

I am looking to build a functional e-commerce website for selling physical products. The site needs to be user-friendly, scalable, and robust. Here's what I am looking for: Similar Site: - Product Organization: with a clear categorization by product type - Versatile Payment Options: the site must support all payment methods including Credit Card, PayPal, and B...proficiency in building secure admin panels. Prior experience in developing similar websites would be appreciated. The main aim is to provide an easy-to-navigate, secure, hassle-free shopping experience to our customers. Note: I need estimate for design and development for both website and backend admin panel. Website must be responsive layout design, so it should proper display on mobile device and desktop.

...expert to help me select the most suitable all in 1 programming language for building various applications targeting multiple platforms (mainly web) 1. I would like to build applications for Web, iOS, Android, Windows 10, Linux, and MacOS & embedded systems (like micro controllers) from single code base 2. I want to learn a language in which we write a code once and can compile for any platform. 3. One possible answer to my questions is JavaScript. We can build server side apps in JS using Node.js & Next.js. Javascript can be embedded in HTML on client side too. We can build desktop apps in JS using Electron and we can make mobile apps in JS using react & angular. But in javascript will code be exactly same for all platforms ? 4. Another option is Flutter (Da...

3D modeling of a villa in Revit: 1. Copy architectural model to construction: - Levels - Axes - Columns - Walls - Ceilings 2. Adding column sections - Wall sections - Beam sections 3. Connecting columns to ceilings 4. Linking beams to levels 5. Openings: windows and doors 6. Tables of quantities for concrete + blocks + iron.

...a talented individual who can help to give our MEAN stack application a comprehensive update. The main areas that require attention are the frontend, backend, and database. Frontend: - The scope of the frontend updates includes adding new features and enhancing the application's performance. Prior experience in user interface redesign will be an added advantage. Backend: - The primary task on the backend is to handle the implementation of new APIs. This requires a solid understanding of backend systems, particularly within the MEAN stack. Database: - While the frontend and backend are important, the database is equally crucial. Any expertise in optimizing database queries is a valuable skill I'm looking for. The ideal freelancer fo...

As we're in the development stage of building a decentralized application, I'm looking for a skilled Solana developer to join the project. The main focus of the project is on building a decentralized application. Therefore, the ideal candidate should have experience with smart contract development and blockchain integration. Skills and experience required: - Proven experience in smart contract development and blockchain integration - Strong knowledge of Solana and Rust programming - Experience in deploying decentralized applications The ideal developer will be able to work closely with our team to bring our decentralized application project into reality. The project is already in its development phase, so we are searching for an expert who can hit the gr...

...of toxic or offensive language and so on. 2) You will compare the two statements and decide which one is a better answer to the question 3) You will provide a brief justification to your decision You are our perfect candidate if: - You are a native-level fluency in Japanese or have a C1 certificate of Japan - Your English proficiency is fluent - Your laptop meets requirements: RAM from 6 GB, Windows 10+ or iOS - You have stable internet connection - You are self-organised, can work without supervision Mindy Teams is an international outsourcing company, a European leader in the field of Data Annotation for Artificial Intelligence and Machine Learning for over 10 years. Several of our clients belong to GAFAM and Fortune500 lists. We have a team of 2000 professionals. We are w...

...skilled Full Stack Developer with extensive experience in PHP to develop a web application. The primary functionalities I'm looking for in this project are around the API and the ability to handle data updates. Key Requirements: - Expertise with PHP: The ideal candidate should have a strong background in PHP, with the capability to develop robust and efficient code. - Full Stack Proficiency: The project requires both frontend and backend development. Proficiency in both areas is crucial for the success of this project. - API Development: You should have experience in developing APIs, especially around data updates. This is a core part of the requirements. The project is focused on developing a web application and ensuring that the API is capable of handling data u...

Main notes: - can be developed a variety of ways, but mainly wordpress is what I'm looking for. - should be easily accessible and usable on pc, phone, tablet. - requires the user to make an account with the website before its use. I am currently designing the website, and looking for this program to be created externally on wordpress or whichever way will fit in the budget. Important: Please only consider this project if you will are okay with the budget, and have read through the project outline. Thank you. Project details: basic functions: (the main function is to show what time the user has to work on their goals, and generate a schedule for them to use, factoring in all their tasks in their daily lives) - asks for users input on 'how disciplined are you, what are y...

...a multilingual web application with strong focus on project management features. The structure of the application is essential, it should be developed in a PHP framework, preference being Laravel, CodeIgniter, Symfony or simply Vanilla. However, it's critical that the final application is structured in MVC style. A strong knowledge of PHP is required as it's the primary language of development. The login register aspect is already catered for as that’s executed by userspice. Key Deliverables: - Project management features incorporation - MVC style structured application - Utilization of one of the preferred PHP frameworks Appropriate Skills: - Proficiency in MVC design pattern - Proficiency in PHP and relevant PHP frameworks - Experience i...

I have a website which requires a better pagespeed score. Right now its on 30 score for mobile and 60 for desktop. I want this to be 100 for both. Need someone that can do this with me either by modifying the website page or with plugins. I have some plugins installed but could not increase the score. Link will be shared in a seperate chat

...full-fledged mobile application for my dance studio, compatible with both iOS and Android platforms. More than just communication, this must provide an all-encompassing experience for our dance studio users. Key Features Needed: - 'Class Schedules Registration': users should easily view and register for our classes. - 'Dance Tutorial Videos': Let our audience enjoy video content of dance tutorials from our studio. - 'Chat Room': A communication platform for users to discuss dance classes, schedules, or general queries. - 'Booking Studio Space': We have 2 dance studios for rent, users should be able to book them through the app. Registration Process: We require users to register for classes: - An Enrollment Form within the app itself - e...

...problem solving, particularly in cases with limited source information - Intermediate understanding of Laravel's native or custom password encryption standards beneficial. Backup files for the Laravel project are available. It is imperative to maintain the confidentiality of all information gained while working on this project. Note: all work must done via anydesk or teamviewer or other remote desktop...

I need a windows or online php application , whatever you do prefer that i will be able to : Connect multiple Bybit API keys *Add Key/Account - Remove Key/Account *Add notes for each API KEY *Have a check button that when i click it will get the available USDT balance from all connected accounts.

I'm in need of an experienced backend developer to create a mail parser with the following specifications: - **Email Protocol:** The mail parser should support SMTP, so proficiency in this area is a must. - **Primary Goal:** The primary function of this mail parser should be storing emails in a MySQL database. If you have experience with database integration, this would be a big plus. This project requires expertise in backend development, specifically with an understanding of how SMTP works. You should also be familiar with MySQL and have experience in integrating databases into applications. Please provide examples of similar projects you've worked on in your proposal. Thank you.

I need a VA with Wix store experience, a keen eye for detail, and proficiency in spreadsheet management. You'll be tasked with: - Keyword Optimization: Adjust the product titles on my Wix store to ensure they are optimized for search engines. Experience with SEO would be beneficial for this. - Database Creation: Develop a comprehensive database for all my products. This will include attributes like Product names, Product prices, and Product URLs. - Formatting: The database should contain separate columns for each product attribute. Strong organizational skills and experience with data entry would be ideal. Ultimately, the goal is to streamline the management of my product listings for a smoother business operation. Prior experience with Wix and creating pro...

...to scan the video, locate identify the different type of noises and their value and externalize this findings into a json file Key Requirements: - The script (OOP based) should be able to read a video in mp4, mkv, mov format. - The library used for reading the video is not fixed. You can choose from libraries like (e.g. OpenCV, PyAV, or MoviePy, but the solution should be compatible with both Windows and Linux (and mac) - The output should have details of the signal, the different type noises, the common ratios and finally the values ... - the frame number ... - the time position/time code ... - the data detected ...... - e.g. the sharpness and this should be outputed in a JSON file per video file. Ideal Skillset: - Proficiency in Python - Experience with video processing lib...

...dial a number through a VoIP service using the VCDial setup I have. The code should also play a pre-recorded message when the call is connected. The operating system I am using is Windows. Key Requirements: - Develop a Python script that can interact with the VCDial setup for dialing numbers. - Integrate the functionality to play a pre-recorded message once the call connects. - Ensure the script can run smoothly on a Windows environment. Ideal Freelancer: - Proficient in Python programming, with experience in telephony and VoIP setups. - Familiar with VCDial or similar systems. - Able to work effectively on Windows OS. - Prior experience in creating automated call systems or call centers would be a plus. My budget is not more than 5000-6000 INR for this. ...

Seeking freelancer in Portugal (preferably in the Arganil region) Are you a proactive multitasker based in Portugal, near Arganil, looking for flexible work opportunities? I am in search of a dynamic freelancer who is fluent in both Portuguese and English to assist with various tasks. Long term work, short tasks every now and then. Responsibilities include: Researching local companies and products Making phone calls Occasional site visits as required Stable internet connection for remote tasks Requirements: ✔ Fluency in Portuguese and English ✔ Reliable internet and phone communication ✔ Access to a car and a valid driver's license I offer a fixed hourly price of 8 euro per hour, but I am open to discuss a project-based price as well.

I need a Tic Tac Toe game implemented in C++. The game should support local multiplayer, with a simple text-based (console) graphical interface. Key Requirements: - C++ programming skills - Experience with game development, particularly Tic Tac Toe - Ability to create a basic text-based user interface The game should be designed for Windows platform. The core gameplay should be solid and allow for two players to play against each other on the same machine. The graphical aspect should be simple and intuitive, with text-based display. If you're an experienced C++ developer with a knack for game programming, this project could be a fun and quick one for you to pick up. Please provide examples of your previous game development work alongside your proposal.

I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.

I'm looking for a skilled individual who has a good understanding of Mechanical Engineering and Data Science to help me set up a database that records the live feed of on-board sensors in a car. Key Responsibilities: - Utilizing an On-Board Diagnostic Tool and an app to record the data - Implementing a database to store the collected sensor data - Analyzing the data primarily for predictive maintenance using statistical analysis Ideal Skills: - Mechanical Engineering background - Proficiency in working with On-Board Diagnostic Tools - Strong experience in statistical analysis - Knowledge of database management systems and data analysis tools - Experience in predictive maintenance is a plus This project requires attention to detail, analytical thinking, and the...

Hello, *Please bid only if you can deliver in 4 to 6 hours* We have a website PSD (2 page - same header etc.) created recently. It has the Desktop and Mobile versions. We're looking for someone to take our existing PSD and turn it into a pixel-perfect responsive page. Only 2 - very simple page required - Responsive. Please also mention as to how soon you can get this done. I am looking for someone who can begin immediately and be done in a few hours. We need pixel-perfect designs that are cross-browser compliant. Budget $75 Please mention - 1x773 in your bid to show that you agree to these terms.

I am searching for a Product Analyst who can apply their knowledge towards data analysis, market research, and performance monitoring. Its a small assignment This assignment involves diving into a snowflake database to explore how customers behave. The goal is to find useful information that can help the Product team make decisions to make the business grow. After you uncover insights, you'll suggest changes to the product, like adding new features, making current features better, or even getting rid of features that aren't working well. You need to do the analysis, create graphs to show your findings, share all the code you used, and also come up with a plan for an A/B test to try out one of your suggested changes. Note: Its a short assignment, not spend more than tw...

...need to choose from some options . example : name, age , address, every option have some drop list text he can choose for the format . and then after he finish . he click created order birthday . then I need approve this . after approve . he can share the invite birthday to friends and family . the design of the birthday page is full wide on screen. open only on mobile ! can't open on desktop . Can edit the invite birthday from admin . I want also later to connect this system to AIRTBALE if you know what is . the invite birthday will looks like this with unique URL - ( it's open only on mobile) in the design have the all the details from what customer put in the form . also have our logo and have button to share in WhatsApp .

It is necessary solve some few errors that have my application. It is necessary experience in laravel coding. Please send me your experiences in complex coding not simple web). If you show me the experiences, I will send the details of changes

As we're in the development stage of building a decentralized application, I'm looking for a skilled Solana developer to join the project. The main focus of the project is on building a decentralized application. Therefore, the ideal candidate should have experience with smart contract development and blockchain integration. Skills and experience required: - Proven experience in smart contract development and blockchain integration - Strong knowledge of Solana and Rust programming - Experience in deploying decentralized applications The ideal developer will be able to work closely with our team to bring our decentralized application project into reality. The project is already in its development phase, so we are searching for an expert who can hit the gr...

...performing poorly with slow website loading times and database slowdowns, which is unacceptable as I regularly have more than 500 concurrent visitors. The primary focus of this project will be optimizing the server's Plesk settings, Postgres and MariaDB databases, and PHP 8.2 configuration. Key tasks will include, but are not limited to: - Configuring Plesk for optimal performance, including adjusting server pool size - Identifying and implementing improvements to Postgres and MariaDB settings to reduce slowdowns - Tuning PHP 8.2 to enhance website speed and performance Ideal candidates for this project will have: - Proven experience in optimizing dedicated servers, particularly with Plesk and Almalinux - A solid understanding of database optimization, including ...