Query design Jobs

Suche einen Ghostwriter für eine Online Klausur am 27.01.2023 gegen 16:20 Uhr Thema: Grundlagen Datenbanken, SQL Datenbanktheorie: -Transaktionen -Index -Normalisierung SQL (Structured Query Language): -Datenselektion -Datenmanipulation -Datendefinition -Trigger

Proje...geht aber die Meldeseite nicht mehr lauffähig darauf ist. Habe Sie wieder auf 7.4 zurückgesetzt. Die Fehlermeldung lautet wie folgt: Fatal error: Declaration of PDO::prepare(string $query, array $options = []): PDOStatement|false must be compatible with DoctrineDBALDriverConnection::prepare($prepareString) in /customers/c/b/f/ on line 0 Die Aufgabe bestünde in der Aktualisierung der notwendigen Komponenten um die bestehende Anwendung unter php 8 lauffähig zu machen. Hier die URL zum Ergebnis (mittlerweile ohne Design/Hintergrund) In Anlage die php Datei auf die die Fehlermeldung verweist. Für weitere Infos stehe ich gerne zur Verfügung

Hi, I am using a shopify system. Through this URL shopify shows the product id of a SKU: https://[...]/admin/products/:80 80 = SKU When opening this website in a shopify system it shows the data of a product like this: {"products":[{"id":7584457720037,"title":"Deutschland Fahne | Schwarz Rot Gold | Hissflagge + 2 Ösen | Flagge | 150x90cm | Fußball WM","body_html":"u003cul data-mce-fragment="1"u003enu003cli data-mce-fragment="1"u003eFahnengröße: 90x150 cmu003cbr data-mce-fragment="1"u003eu003cbr data-mce-fragment="1"u003enu003c/liu003enu003cli data-mce-fragment="1"u003eseitlich zwei Metallösen zum Hissenu003cbr data-mce-fragment...

Verbesserung einer bestehenden Excel Datenbank

...amount of RAM is still free -> mysql query caching possible? Since the site is highly dynamic (activity feed, comments, groups and forums, messaging between members), complete caching is difficult to implement. We have already exhausted some possibilities for optimization: * Caching of some repetitive and "expensive" (i.e. slow) queries using static variables and using Wordpress transients. * Caching of various HTML widgets that don't need to update themselves all the time * Deletion of outdated transients, purging and cleaning of old DB entries and logs * Rewriting of plugins to avoid SQL queries within for loops, for example * Memcached and OPCache PHP Extensions were installed * Update to PHP 8 because of JIT still in consideration * Wordpress Plugin: Q...

...simplen Webform abfragen.) Bestätigungsmeldung bei erfolgreichem Import in Google-Calendar bzw Fehlermeldung bei Misserfolg. Job description A PHP script is required which carries out the following steps: Obtaining CSV file from external password protected (session ID) website. (Query login data in a simple web form.) Processing of the related data. Preparation of a custom CSV file according to Google Calendar Standard. Automatic import of the custom CSV file into Google Calendar with a predefined Google account. (Query login data in a simple web form.) Confirmation message for successful import into Google Calendar or error message for failure. ...

Fachinformatiker (m/w/d) in Erfurt Vollzeit Einsatz: 6 Monate mit Option auf Verlängerung Ort: Einweisung vor Ort in Erfurt Arbeitsort: Erfurt bevorzugt / Homeoffice möglich Die Akcay-Schwarz Consulting GmbH mit Sitz in Eschborn, seit mehr als 20 J...Anwendungsentwicklung • Deutsch/Englisch • Einsatztage 6 Monate mit Option auf Verlängerung / Einweisung vor Ort in Erfurt Arbeitsort Erfurt bevorzugt / Homeoffice möglich • Systemsoftware (Entwicklung, Programmierung, Analyse) • Programmieren Ihre Kenntnisse: • Web-Applikationen (Entwicklung, Programmierung) • PHP, Datenbanken JavaScript, Laravel (von Vorteil) • Datenank: SQL • Datenbankdesign • SQL-Query • Deutsch / Englisch – Kenntnisse • Hardwareinst...

I have a large set of car data that I output on my website - Here is an example page: There are many cars in my SQL database and the table plugin pulls certain columns with this query: SELECT Baureihe AS Modell, Motorisierung AS Motor, Motorart AS Kraftstoff, PS AS "Leistung in PS", Hubraum AS Hubraum, HSN AS "Schlüsselnummer HSN", TSN AS "Schlüsselnummer TSN", Getriebeart AS Getriebe, Steuer AS "KfZ Steuer pro Jahr*", Modellrange AS Baujahr, CO2WLT AS 'CO2 Ausstoß nach WLTP', CO2NEF AS 'CO2 Ausstoß nach NEFZ', Modellende AS Modellende, Modellstart AS Modellstart FROM carwiki_OPEL WHERE Baureihe='Crossland X' ORDER BY Steuer The problem is, that every car has a date range in the column n...

Ich brauche nur eine left join Query mit einem MAX() Wert

...technology should contact us. to the order: I would like to get developed a program, which crawls from a certain side the article conditions and the prices of the respective articles. The dealer is a competitor and I would like to match my articles to his prices, or make them cheaper. There are two problems. A safety program is used. If too high or too fast a request is made, there will be a captcha query. The second problem is the amount. There are almost 1,000,000 items. These would have to be compared every day or every two days. That is, in one hour the program would have to generate 40,000 queries in one day, and for two days it would be 20,000 to 25,000 queries per hour. If you want to know more, please contact me personally. I look forward to hearing from you....

VISTRA Ing.-Büro bietet seit 1994 Beratungsdienstleistungen im internationalen Umfeld (E...des Datenbanksystems (MSSQL) • Anpassung / Erweiterung des ASP.Net Web-Services im Rahmen von SaaS-Lösungen • Betreuung, Optimierung und Support im Microsoft Server Umfeld Ihr Profil • Abgeschlossene Berufsausbildung im Bereich IT oder ein entsprechendes Studium • Erfahrung in der Programmierung, Bestenfalls in der Umsetzung bei SaaS-Projekte • Kenntnisse in den Bereichen Transact Structured Query Language (T-SQL), ASP.net (Sprache: C#), PHP, HTML, CSS, Web-Services • Erfahrung mit Microsoft Team Foundation Server (TFS) und Microsoft Visual Studio Web-Developer (vorteilhaft aber nicht zwingend) • Selbstständige und ergebnisorientierte Arbe...

...1. Not copied 1: 1 from other sources, I can do that myself and is not asked. 2. Ideal: combination of two (opposing) topics (eg sports & literature, or typical women's issues with typical men's themes, pop culture and high culture) -> Questions Ex. see below 3. Entertaining, positive topics, not negative topics like terror, illnesses or accidents (unless there are funny accidents;)) 4. No pure query questions of numerical values ​​or data. 5. Questions for Swiss / International (no German topics such as politics and in-depth geography questions) Assignment: Create 5 questions for a moderated quiz: Combine the areas of culture (literature, poetry, painting, religion, music, history, science) with everyday / pop culture topics (memes, youth language, fast food, s...

...Hier habe ich etwas gefunden, was weiterhelfen würde. Danke für die Angebote Hy, I would like for the plugin ( ) an extension of the search. For the standard search, either tags or categories should be used. Where I use the categories already for a search. The new search is to query publicly or not publicly And select a category. I look forward to your offers. Many thank d...

Bitte melde dich an oder Loge dich ein um Details zu sehen.

...server in Germany () the other one on a server located in Hong-Kong (). If someone (located for example in Australia) is visiting our eshop .com the loading time is very slow. Therefor we are using some optimzation plugins for a better result. But the results are not that much better. If we activate some settings (Avoid landing page redirects, Remove query strings from static resources, Add Expires headers...) the sites will be crashed. Do some one have professional experiance about this subject? Please contact us if you are interessted and if you like to analyse our installations for making an offer. Thanks. ----------------------------------- Wir betreiben 2 WordPress WooCommerce eShops. Einer auf einem Server in Deutschland (

...spezifische Eigenschaften (custom attributes) hinterlegt wurden (System J!2.5 mit Virtuemart 2.0). Da die Artikeleigenschaften nur als „Verweise“ auf andere Datenbankfelder gespeichert werden, steht in der XML nur "kryptischer Kram" drin. Hier der gekürzte, bestehende Code: function daten_holen() { $GLOBALS['datakind'] = 1; $db_tableprefix = db_prefix_aus_config_holen(); $GLOBALS['query'] = ' SELECT ' .$db_tableprefix.'virtuemart_orders.virtuemart_order_id as orderID, ' .$db_tableprefix.'virtuemart_order_items.virtuemart_order_item_id as Positionsnummer, ' .$db_tableprefix.'virtuemart_order_items.virtuemart_product_id as produktID, ' .$db_tableprefix.'...

Hallo, ich suche einen IT-Fachmann für Servereinrichtung mit Expertise in Wordpress. Problembeschreibung: wir haben seit etwa einen Monat massive Probleme mit unserem Wordpress-Blog, z.B. wurden i...Neuerdings steht im Errorlog folgender Fehler: "mod_fcgid: can't apply process slot for /var/www/cgi-bin/cgi_wrapper/cgi_wrapper" Eine weit verbreitete Lösung des Problems für diesen Fehler, nämlich die maximale Anzahl an Prozessen in der zu erhöhen, hat ebenfalls keine Wirkung gezeigt. Auch die Querys in der Datenbank sehen für mich als Laien eher unauffällig aus, es läuft nur ein Query und eine Handvoll Prozesse die sich im Sleep befinden und nach 10Min gekillt werden. Da ich mit meinem Latein am Ende bin, hoffe ich, dass...

Good day Have servers are written quests in Lua (51 files) Task is to look briefly and see if a query in endless loop runs Guten Tag Habe Server questen die in Lua geschrieben sind (51 Dateien) Aufgabe ist kurz anzuschauen und schauen ob eine Abfrage in endlos Schleife läuft um So Schneller um So besser

Find a PHP coder for SQL query Good day Find a PHP coder of a table of all values ​​Auslessen and can be in a table Other transfer and to a log table The still Suche ein PHP Coder Für SQL abfragen Guten Tag Suche ein PHP Coder der von eine Tabelle Alle Werte Auslessen kann und in eine Andere Tabelle Übertragen werden und dazu in eine Log Tabelle Arbeit zeit heute noch

Guten Tag, Ich benötige eine kleine Query die über drei Tabellen via joins verknüpft ist Als Resultat sollen alle Spalten zurückgegeben werden.

...verwalteten Webseite präsentiert. * Es gibt für das Plug-In eine zentrale Konfigurationen (z.B.: Basis-URL der Web-Anwendung). * Das zu entwickelnde Plug-In wird auf mehreren Seiten im TYPO3 Baum eingebunden. * Diese einzelnen Instanzen haben spezifische Filterparameter, welche vom Redakteur angepasst werden können. * Diese Filterparameter werden beim Abrufen der Webanwendung übertragen (via http query), es müssen keine eigenen Filter-Routinen entwickelt werden. * URLs in der Antwort verweisen auf eine Detail-Ansicht. Diese müssen teilweise umgeschrieben werden, um die Darstellung der Details auch im Typo3 zu realisieren. * Die angepasste Antwort wird in die Ausgabe übernommen. Es besteht bereits ein Prototyp, der die Kernfunktionalit&...

Good morning, for my client i need to make an implementation on WooCommerce - on the store the client selects a product and then the website sends a query to the website - provide the number of products on the network. The system will then return a list of places with available quantities of a given product. The system API is in JSON format. An authorization token is required to execute the query.

...Please bid only if you're willing to work with me live via zoom. *** I'm facing significant challenges with my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server management, par...

Necesito alguien que puede dar un curso de power Bi en 10 sesiones en total 15 horas por sesion es de 1 hora y media, 2 sesiones por semana martes y jueves de 4 a 5:30 de la tarde hora Guatemala. Empezando 23 de abril y terminando 23 de mayo. Alrededor de 15 personas, las sesiones son por google meet. Temas a impartir. Editor de consultas de Power BI Extracción de datos: Extracción vs Direct Query Conectar datos alojados en diferentes orígenes Enlazar datos desde la consulta Entorno de trabajo para modelar con Power BI Introducción al modelado tabular con Power BI Tablas y relaciones Power BI – Modelos de datos Iniciación a DAX Fundamentos DAX 1. DAX en la práctica 2. Columnas calculadas y medidas 3. Tablas Calculadas ...

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

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

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 ...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 Vue.js. - Attention to Detail: Ability to ensure high-quality results and maintain consistency thr...

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

...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 will provide. - The architecture design and best practices, scalability and reliability of the platform are crucial, as it will need to support a growing user ba...

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

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