Kql queryemplois

...Excel file in the Qliksense platform, you create the 20 graphs and you prepare the printing in PDF of the report containing the 20 graphs with date of publication and page numbers. The goal is to be able to upload a new version of the Excel file each month and the report to be relaunched automatically. In a future version of the project (not in this project), Qliksense queries should be able to query the same Excel file located in a Nextcloud cloud. Once we agree on the 3-day deadline and on a price, I send you the Excel file....

J'ai besoin d'aide avec la modélisation d'un environnement BI avec 1 ou 2 schémas en étoile. J'ai déjà créé le schéma, Entrepôt de donnée, Cube mais j'ai besoin de conseil et de l'aide pour construire un dashboard Power BI en Direct Query. Voici quelques infos: J'aimerais avoir une nouvelle fonctionnalité dans le système qui m'aiderait à voir ce qui se passe au sein de ma compagnie. J'aurais besoin de voir l'avancement des apprenants dans un parcours d'apprentissage, puis aussi avoir une vue haut niveau des parcours. Si possible j'aimerais aussi voir si les apprenants suivent bien leur cours, et si les gestionnaires font bien les in...

...management of our hosting. We work with a plesk server and all of our websites upon purchase are installed with wordpress plesk. We do not give access to plesk to our clients and they cannot exit the whmcs interface. What we would like to develop: a module for whmcs which adds a button in the ClientArea of ​​whmcs allowing direct connection to the wordpress site as administrator. so this one must query plesk in order to obtain the password and the identifier of the customer to be able to automatically connect as administrator to the page FRENCH: Bonjour notre entreprise utilise whmcs pour la gestion de nos hébergement. Nous travaillons avec un serveur plesk et tout nos site internet lors de l'achat sont installé avec wordpress plesk. Nous ne donnons pa...

...d'un professionnel capable de retravailler l'une de mes photos. Il se trouve que j'ai une photo de moi (portrait) en noir et blanc dont je souhaiterais le fond modifié. S'agissant d'une photo en noir et blanc, j'ai pensé à un fond gris ou "atmosphère fumée" (un peu comme celui là https://fr.freepik.com/photos-gratuite/interieur-salle-3d-grunge-arriere-plan-atmosphere-fumee-fumee_6038271.htm#page=1&query=fond%20fumee&position=0 ). Je n'ai pas forcément d'idée précise du style de fond, vos propositions seront donc les bienvenues... J'espère ne pas avoir trop massacré la qualité de la photo. J'ai veillé lorsque j'ai tra...

...nouvelles à venir : - Colorflex : - Nado by A.K. : - Kasva : ;refinementList%5BMARQUE%5D%5B0%5D=KASVA#search-result - Deluxe : ;refinementList%5BMARQUE%5D%5B0%5D=deluxe#search-result - Destyle : ;refinementList%5BMARQUE%5D%5B0%5D=destyle#search-result Ce qui caractérise à la marque avec ses collections et ce que nous souhaitons véhiculer comme message : Brainstorming in english : - <b>le logo doit être élégant et chic. Les meubles vendus sont dans

Bonjour, Business analyst dans une PME, j'ai à charge le projet de créer des rapports Power BI pour nos différents départements (Commerce, Finance, ADV..). j'ai une licence Power BI Pro et j'ai commencé l'architecture de données ainsi qu'à concevoir des rapports. Ayant p...différents départements (Commerce, Finance, ADV..). j'ai une licence Power BI Pro et j'ai commencé l'architecture de données ainsi qu'à concevoir des rapports. Ayant plusieurs sources de données, j'ai du mal à les faire communiquer et rendre mes filtres interactifs entre toutes mes tables, je pense qu'il y a des liaisons circulaires et j'aurai besoin d'aide po...

Bonjour, Je cherche pour une mission longue un développeur javascript expérimenté pour une mission en télétravail pour mon Studio de développement. Vos missions seront : - Intégrer des fichiers PSD en HTML5 (évidemment) - Vous devez maitriser parfaitement les médias-query. - Le responsive doit être une évidence - L'utilisation du Framework bootstrap est requise. - Vous devez savoir développer des plugins jquery et non pas seulement les utiliser. 5 ans d'expérience exigés Démarrage : le plus tôt possible Durée : 1 mois renouvelable.

C'est un code à terminer et non à réaliser. Dans la page que je vais vous donner, vous allez voir le résultat non voulu : Cliquez sur le pack gratuit puis scrollez jusqu'à "EMPLACEMENT DANS UNE RESIDENCE" Cela donne une liste (incomplète) des résidence présente...volet avec uniquement la catégorie "Résidence" à l’intérieur comme pour "QUARTIER" juste en dessus. Voici le code : <?php /* * RESIDENCE */ ?> <div class= »row »> <div class= »col-md-4″> <span class= »title-plan »> <?php _e(« EMPLACEMENT DANS UNE RÉSIDENCE », ET_DOMAIN) ?> </span> </div> <div...

...voudrais insérer par exemple une location d’appartement dans une résidence. Donc dans l’éditeur, je me retrouve dans POST-PLACE-STEP3 et je constate que ce que je veux mettre n’est pas une taxonomie comme les autres (sinon, cela aurait été trop facile et j’aurais dupliqué un et renommé la partie de la taxonomie) Me voilà coincé avec un bout de code avec de très très mince connaissance en php et query donc besoin d’aide Voici le code normal d’un élément dans step3 : <?php /* * AREA */ ?> <div class= »row »> <div class= »col-md-4″> <span class= »title-plan »> <?php _e(‘AR...

...the search bar/form on the home page -creating and formatting the results page for web results, images results, videos results... (As clean and responsive design as possible, the wordpress theme is already responsive.) -filters, web, images, news, videos, shopping ... -filters by language, country ... -setting up pagination -spelling service (spell check and correction) -find related query terms (also try) -a Settings button in order to change the country, language and adult content moderation. ... Here are the information regarding the API and the SDK for the integration : Regards, ps: the time and budget are estimates. Bonjour, nous sommes à la recherche d'un personne qui pourrait intégrer un SDK de recherche dans notre site. Notre

...need to incorporate a search SDK in our Wordpress website. The needs are : Full integration of the SDK -add the search bar on the home page -creating and formatting the results page -filters, web, images, news, videos, shopping ... -filters by language, country ... -Incorporate the sponsored links -setting up pagination -spelling service (spell check and correction) -find related query terms (also try) -a Settings button in order to change the country, language and adult content moderation. ... Here are the information regarding the API and the SDK for the integration : Regards, ps: the time and budget are estimates Bonjour, nous sommes à la recherche d'un personne qui pourrait intégrer un SDK de recherche dans notre site

Hello, we need to incorporate the YAHOO BOSS search API in our website on Wordpress. The needs are: -add the search bar on the home page -creating and formatting the results page -filters, web, images, news ... -filters by language, country ... -Incorporate the sponsored links -setting up pagination -spelling service (spell check and correction) -find related query terms (also try) -Recognition language of the user, so it arrives on the corresponding home page and carries out research in its own language (if possible) -a Settings button in order to change the country, language and adult content moderation. Regards, ps: the time and budget are estimates Bonjour, nous sommes à la recherche d'un personne qui pourrait intégrer l'API de recher...

ModeerERP Source code for Sell * Full Source code with Support * Mulltilanguages UI * Multiskin * MultiCurrency * ERP ( AP,AR,GL,BANKS,FA,SCM,INVENTORY,MRP,CRP, etc) * MultiDatabase ( Oracle ,SQL Server, Mysql, Postgresql, DB2) * BI Interface Pivot Builder * Query Builder * Workflow Builder * Report Builder and Others For Information mobile : +2 0100 194 1294 mobile : +2 0122 128 1668

I am looking for an experienced React Native developer who can develop a functional driver app for both iOS and Android platforms. I already have UI screens, however, are open to guidelines and suggestions. The Primary function of the app ...should have: - Proven experience in React Native Development - Proficiency in working with both iOS and Android platforms - Excellent understanding of GPS integration and real-time notifications - Ability to work with provided UI screens and enhance functionality - Expertise in payment processing integration. I'm excited to see how your skills and experience match this project. If you have any query or suggestion please let me know. Looking forward to collaborating with you. Note : There are 20 UI Screens and we put a 150 Rupees per s...

...integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep knowledge of relational databases and experience in query optimization. Previous experience working with MLM databases and familiarity with their structures and terminology. Experience with Dolibarr ERP systems or similar ERP solutions. Ability to work independently and effectively solve problems. Excellent communication skills and ability to work in a team...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm seeking a knowledgeable specialist to perform benchmarks on my Pgvector Chroma Faiss database. The key objectives for this project are: - Analyzing speed and query performance. The ideal freelancer should have: - Proficiency with Pgvector, Chroma, and Faiss. - Experience in database benchmarking, with a focus on query performance metrics. - Ability to provide detailed reports on performance metrics. - Ability to offer performance tuning recommendations based on benchmark results. As this is for personal use, the project requires a specialist who can deliver thorough insights without the need for a business-oriented approach. Your technical database expertise will be crucial for this project.

Create a relational database for the following data in a single tables with parts store. You may use alphanumeric to represent store and use surrogate key as primary key. Bring a hard copy in class and answer two quires in class. (points Project creation 20 + two query 20) 1. Vendor 1: Low Hardware, 1200 Harding st, Pine Bluff, AR 71602, Phone 870-535-1000 Supplies screw Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .02 300 Yes 100 .04 6-12 Yes 3/4” .03 300 Yes 200 .06 6-32 Yes 1” .04 400 Yes 200 .08 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes 20 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” ...

...activate the account. - **1.2 Login** - Users must log in using their registered school email address. - The system should provide password recovery options. #### 2. User Dashboard - **2.1 Access** - Upon successful login, users are directed to their dashboard. - **2.2 Features** - A search box to look up universities by name. - A list of universities should appear based on the search query. - Users can select a university to view more details. #### 3. University and Course Interaction - **3.1 University Selection** - After selecting a university, a list of available courses is displayed. - **3.2 Course Selection** - Users can select a course to view detailed information, including existing reviews. #### 4. Review Management - **4.1 Review Actions** - User...

FOR MELBOURNE BASED FREELANCERS ONLY I am a finance professional with over 30 years experience in the investment markets. I need an experienced tutor in Microsoft Access to assist me with database creation and query design and optimization. The ideal candidate should be able to help me understand: - How to create a well-structured database in Microsoft Access - The best practices for query design and optimization to enhance the efficiency and speed of the database operations You should also be able to provide guidance on: - How to maintain a clean and minimalist design that is easy to navigate - The creation of a user-friendly interface that is intuitive and easy to interact with - The customization of templates to suit specific requirements The complet...

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow co...

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the y...

...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...

I am ...view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criteria is small. If I pass filter for say 50 GUIDS then this query does not return any records. I think addCustomView makes rest call and pass all filters in URL. and this URL is too big. Are you able to investigate / fix thi...

I'm seeking a skilled Python developer who can handle all aspects of SNMP for my project. Key Responsibilities: - Implementing SNMP query and data retrieval - Efficiently managing SNMP trap handling and notification - Developing a robust SNMP agent Your role will be crucial in ensuring that our system effectively communicates using SNMP across multiple versions. Ideal Skills and Experience: - Proficiency in Python - Extensive experience with SNMP (versions 1, 2c, and 3) - Strong understanding of network communication - Previous work on SNMP trap handling and agent development is a major plus If you have the right skillset and experience, I look forward to seeing your proposal.

I am looking for someone who has worked with Elementor Queries before to write a query that does the following ... Our posts have an ACF field called prsona, which is shared with the posts. When posts are created they are created with that ACF field of the creator. Now we want to display posts where the posts prsona field matches the users prsona field.

I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and carrying out dat...

I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query conditions - Sorting the query results The purpose of these modifications is to: - Display specific custom fields - Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP and MySQL Please provide ex...

I'm in need of a publishing expert in book publishing services, specifically for non-fiction genres. I have a fully-completed manuscript and I'm looking for someone to critically fine-tune my query letter and book proposal. Your role would involve: - Review and edit query letter and book proposal for UK and US agents - Offer constructive feedback and direction on improving the overall readability and marketability of the book proposal and letter Ideal candidates should have: - Proven experience in non-fiction book publishing with traditional publishers - Significant experience in the book proposal process - Solid understanding of what works in non-fiction book proposals to secure a literary agent Overall, your expertise will play a pivotal role in the overall su...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...

...that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT `o`.`entity_id`, `o`.`increment_id`, `o`.`customer_id`, `o`.`billing_address_id`, `o`.`customer_email`, `o`.`customer_firstname`, `o`.`customer_lastname`, `o`.`status`, `o`.`created_at`, GROUP_CONCAT(oi.product_id) AS `products`, `billing_address`.`city` AS `billing_city`, `billing_address`.`company` AS `billing_company`, `billing_address`.`postcode` AS `billin...

... Ideal skills and experience for this assignment include: - Expertise in Laravel & MySQL - Experience with high load applications - In-depth understanding of database performance optimization - Experience with online poll/voting systems The specific tasks I need assistance with are: 1. Addressing a database connection error which has arisen due to intense continuous voting. 2. Tackling the query performance problems coming up in our online polling setup. 3. Addressing the data inconsistency issues that have cropped up due to dynamic vote tallying. The votes are expected to be collected as per IP, hence, experience with IP-specific data handling is highly desirable. In summary, I need a Laravel and MySQL expert to revamp our online voting architecture for seamless perfo...

...A data archive is expected to allow users to have a space where they can share data privately to facilitate collaboration prior to publication. Such private enclaves must only last for a defined period of time before that data set is shared with the rest of the data archive will provide an interface that is accessible to anyone with a web browser. A data archive will make appropriate query tools and summary data easily will want to analyze and/or use visualization tools to interact with the data without downloading any data.A data archive is strongly encouraged to use cloud storage and computing possible, a data archive is expected to use existing infrastructures and standards. These could include persistent identifiers such as Digital Object Identifiers

...as peer the dashboard screen provided in figma file. The dashboard and others menus must be created in dynamic way as its menus items and widget in dashboards are different according with the user profile. - Menus and Submenus: The SaaS web app has about 18 screens that allow user to interact with some operations like add a new financial product, query data in tables or grids, update and delete data. All this screen must have filters for query and pagination capabilities. - Data Analytics and Reporting: It's essential that the platform has the capability to collect and analyze data, and present these insights in a user-friendly manner. Further details: - The design of the application should be sleek, intuitive, and responsive and must follow the figma design that...

I'm in search of an experienced MS SQL professional who can provide online training that covers from intermediate to advanced concepts. This will focus particularly on, but not limited to: - Database Administration - Query Optimization - Stored Procedures Ideal Qualifications: - Proficient with MS SQL - Previous experience in teaching or training - Ability to explain complex concepts in a simple, understandable manner - Capable of tailoring the lessons to my specific needs No preference on the tools or software versions for the training as the focus is more on learning the subjects rather than mastering specific tools. Feel free to propose the platform or versions you are most comfortable teaching with.

Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what SQL databases can achieve together!

write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru

I am seeking a skilled programming expert, proficient in either Ruby or Python, with intermediate-level ElasticSearch querying capabilities. The primary task involves intelligently executing aggregations and nested queries in ElasticSearch, extracting data, in JSON format, and then transposing it into Excel or CSV format. I'm open to whichever format you are more comfortable with, so long as it is either of the two mentioned. In addition to this, having familiarity with job automation via GitHub is critical for this project role. This background should include understanding how to automate and schedule tasks to regularly extract, convert, and save this data. Ideal Skills: - Proficiency in Ruby or Python - Intermediate level ElasticSearch querying - Experience with JSON to Excel/CSV...

...improvements to my existing Laravel application. The selected freelancer will be responsible for: - Backend Development: Your skills should allow you to work efficiently on my application's backend, ensuring all new integrations are seamless. - Database Optimization: I am specifically looking for you to boost the performance of my existing application by optimizing the database, which includes indexing, query optimization, and normalization wherever necessary. - API Integration: Your experience integrating APIs will be crucial, as a key part of this project will involve utilizing various APIs to extend the functionality of the application. - User Interface Improvement: The right candidate will not solely focus on the technical side, they must also be able to make necessa...

We're developing a scanner app coupled with an query response system. Seeking a Flutter expert with Django knowledge for UI and backend development, respectively. The ideal candidate will excel in Flutter UI design and possess the skills to manage data storage in Django backend, along with handling API integrations seamlessly.

Create a database and CREATE TABLE statements for all tables in your ERD (Part A) including primary and foreign keys. 2. INSERT INTO statements for populating the database i. Insert five rows of (made-up) data into each table. Make sure that the data you enter in these tables should be sufficient to return at least one row for each query in Task 3. AL should hold at least 5 bottles of Penfold Grange 2010 in some branch or other

...require: Features: - User Registration and Authentication: Proficiency in handling user data securely and maintaining user privacy is necessary. - Search Functionality: The website should include essential features such as Full-Text Search, Faceted Search, and Auto-complete/Suggestions powered through Elastic Search. The capacity to execute comprehensive indexation, accurate retrieval, and fast query processing is crucial. - Responsive Design: The site must be mobile-friendly and capable of rearranging its layout based on the user device screen size. Design Style: - Modern: The web design should align with the modern style. Minimalism, adaptive grids, and scalable graphics are what I'm looking for. The design should be functional yet aesthetically pleasing and user-friend...

...scheduler on my website. Your mission will be to set up API calls to request data specifically for certain resources. Key Skills/Knowledge required: - Familiarity with API integration - Experience working with DevExtreme scheduler - Strong understanding of data request and retrieval The job requirements are as follows: - To be able to query the api for scheduler data and present it. The API is already available and I can modify it at any time. I simply need to query it and present the 3 consts (tasks, appointments and assignees). Kindly note, the type of data to be retrieved and the presentation style for this data in the scheduler are yet to be defined. Your input and suggestions during this phase would be highly appreciated. Please place your bid and let's di...

...data, which can then be analyzed and displayed on the charts. - API integration - Database (Supabase) Integration Ideal Skills and Experience: - Django backend and React JS frontend - Web development experience, particularly in creating data visualization platforms. - Proficiency in real-time data integration. - Database integration - API integration - Search Engine Optimization - Query Optimization - Postgre Notes: - We have a website template that includes code for both the backend and frontend. You would just need to customize it. This is what the template looks like: - Although the template at the link looks like html, we have paid for and downloaded the django code - We have provided two screenshots

I need an EXPERIENCED Javascript developer to write me a custom React fetching mechanism. Use the Tanstack library to write me a custom hook that can fetch data and cache it too. These features should be implemented: - Assume API call always returns an array of data. - I can pass a modifiedFrom query param which is just a string ISO date. 1. Fetch the data using the cached lastFetched date for that key/api call 2. Mutate the result in the stored cache and updated the lastFetched date in cache 3. Allow data to be cleared from cache after an x time

I'm currently using Oracle and MySQL database management systems and I'm in urgent need of a dedicated database administrator who can expertl...robust backup and recovery strategies, thus to ensure database availability and consistency at all times. - Security Management: Protection of data is paramount, and as such, I require a comprehensive security configuration to guard against unauthorized access or data breaches. - Database Optimization: I'm looking to increase the efficiency of my current database setup. It involves improving query performance and optimizing database storage with a focus on increasing system scalability. It would be best if the candidate is proficient in Oracle and MySQL and has hands-on experience dealing with performance issues, backups, s...

...queries involving multiple tables. The project entails: - Diagnosing the cause of the slow performance. - Improving the efficiency and speed of these 5 stored procedures, aiming to achieve at least a 50% increase in speed. - Decreasing high memory usage of a sql server instance Ideal skills and qualifications: - Proficiency in SQL Server and complex JOIN operations. - Proven experience in SQL query optimization and performance improvement. - Understanding of advanced aspects of SQL Server performance tuning. - Excellent debugging and diagnostic skills. - Familiarity with procedures handling multi-table JOIN queries. GetInvKardexPorLote rows : 10924, max : 96'' GetKardexInventario rows : 4931, max : 72'' GetLibroAuxiliar rows : 3007, max : 94' Ge...

I'm looking for a seasoned PHP and MySQL programmer to establish the architecture of a ranking system for my multiplayer gaming site. Tasks will include but are not limited to: - Database design - Data modeling - Query optimization The ranking system will make use of user ratings, vote counts, and engagement metrics. The ideal freelancer for this project should have ample experience with ranking systems and must exhibit prowess in PHP and MySQL, with a keen understanding of database design, data modeling, and query optimization. Familiarity with gaming sites is a plus. Let’s build a competitive gaming environment together.

...I can fix this for myself so I don't run into this problem again. • If you have a knack for teaching complex concepts in a simplified manner, you are the perfect fit. I wish to understand this aspect deeply, hence it'll be a bonus if you can assist in creating a workflow that I can follow to understand and execute similar tasks in the future on my own. Let's enhance my Fusion 360 skills one query at a time....