Query designPekerjaan

Filter

Pencarian saya terakhir
Filter menurut:
Anggaran
hingga
hingga
hingga
Jenis
Keahlian
Bahasa
    Pernyataan Pekerjaan
    2,000 query design pekerjaan ditemukan, seharga USD

    ...fitur: Sebagian fitur yang ada dalam proyek ini udah nggak diperlukan atau relevan lagi. Jadi, fitur-fitur ini perlu diambil dari sistem dan dihapus biar aplikasinya lebih sederhana. - Kita juga butuh meningkatkan sistemnya: Kita perlu perbaiki beberapa aspek dari sistem yang udah ada biar performanya lebih baik dan pengalamannya lebih baik. Mungkin ada keperluan untuk mengubah kode, mengoreksi query database, atau implementasi algoritma yang lebih efisien. - Setelah semua modifikasinya selesai, aplikasinya perlu di-deploy ke penyedia hosting gratis: Aku udah cek ada beberapa penyedia hosting yang gratis. Kita bisa diskusi bareng-bareng buat milih yang paling cocok buat projek ini. Kalau kamu tertarik buat kerjasama sama aku, aku mau minta informasi berikut: Kapan kamu bisa m...

    $158 (Avg Bid)
    $158 Rata-rata
    24 penawaran

    Halo, saya mencari apakah anda dapat mengubah data no sql firebase saya menjadi database sql case : Saya membangun app mobile menggunakan flutter dengan database firestore no sql karena memudahkan bagi saya, tetapi dilainhal disisi website saya lebih familiar dengan php database dari sql, untuk itu...mengubah data no sql firebase saya menjadi database sql case : Saya membangun app mobile menggunakan flutter dengan database firestore no sql karena memudahkan bagi saya, tetapi dilainhal disisi website saya lebih familiar dengan php database dari sql, untuk itu apakah anda dapat membantu untuk dapat setiap saya login ke admin website , data no sql akan diinject ke dalam database sql untuk saya query database sqlnya saja. website yang saya gunakan hanya menggunakan framework bootstr...

    $176 (Avg Bid)
    $176 Rata-rata
    3 penawaran

    Baris kode yang saya punya tidak dapat melakukan pencarian query, masalahnya adalah API memiliki level access "essential" sedangkan terkendala karena pencarian tidak dilakukan melalui "twitter API v2 endpoint". Project akan dianggap selesai ketika baris kode dapat melakukan penarikan query hanya dengan level access "essential"

    $25 (Avg Bid)
    $25 Rata-rata
    1 penawaran
    SSIS Engineer Berakhir left

    Deskripsi Pekerjaan PT Sharing Vision Indonesia masih membutuhkan beberapa orang minimal S1/D4/S2 dari Teknik Informatika/Sistem Teknologi Informasi/Teknik Elektro/Teknik Telekomunikasi/Sistem Inform...Vision Indonesia masih membutuhkan beberapa orang minimal S1/D4/S2 dari Teknik Informatika/Sistem Teknologi Informasi/Teknik Elektro/Teknik Telekomunikasi/Sistem Informasi/Fisika/ Matematika/Statistika/Ilmu Komputer/Engineer lainnya, untuk posisi sebagai: SSIS Engineer Penempatan WFO di Jakarta Persyaratan: 1. Pengalaman dalam SSIS Admin 2. Berpengalaman dalam pekerjaan ETL 3. Memiliki kemampuan query MySQLdan SQL Server tingkat lanjut 4. Diutamakan mempunyai background pemrograman (misal python) 5. Menguasai tool dashboard seperti Tableau, Google Studio, dll akan menjadi nilai ta...

    $500 (Avg Bid)
    $500 Rata-rata
    2 penawaran

    Website terdiri dari 7 user dimana fungsi utamanya adalah mengkoleksi data berdasarkan inputan formulir dan divisualisasikan kedalam bentuk grafik batang dan pie chart. query data berdasarkan wilayah juga diperlukan dalam rangka download data

    $1021 (Avg Bid)
    $1021 Rata-rata
    14 penawaran

    butuh jasa untuk mengkonversi sistem informasi untuk halaman admin milik saya yang dibangun dengan php native anda hanya perlu mengkonversikan source code php native ini kedalam codeigniter. tidak perlu membuat database karena sudah disediakan (.sql) tinggal diimport saja tidak perlu memikirkan query sql karena sudah tinggal konversi saja assets sudah tersedia tinggal pakai saja (ajax,js dll) tidak perlu menganalisa sistemnya waktu pengerjaan (10-14 hari)

    $28 (Avg Bid)
    $28 Rata-rata
    9 penawaran

    Kami sebelum nya sudah membuat website e-commerce ini namun masih banyak hal yang perlu di perbaiki sehingga...E-commerce CS CART - mengetahui instalasi server Linux CentOS - mengetahui / pernah instalasi payment gateway seperti DOKU Wallet - menguasai / mampu HTML, HTML5, JS, CSS3, bootstrap (HTML/CSS 3/JS) - mengetahui editing gambar (Photoshop) - mengetahui dalam UI Design (Material Design) - Menguasai database MySQL - menguasai Query SINTAX (SQL QUERY) - Memahami Google Analytics - mempunyai pengalaman minimal 2 tahun dibidang yang sama Syarat : - Lebih di sukai yang berdomisili di jakarta - Dapat melampirkan Portofolio Design Web yang pernah dikerjakan minimal 2 portofolio (*) Jika berminat, silahkan menyertakan juga nama, nomor / ...

    $285 (Avg Bid)
    $285 Rata-rata
    11 penawaran

    Membuat Modul Persedian Saya butuh programmer untu...saya. Fitur yang dibutuhkan: 1. Master Produk (ini sudah ada tetapibutuh modifikasi) 2. Produk gudang Sub menu/link > input stok awal > Harga per customer group > History HPP > History harga jual 3. Transfer item antar gudang 4. Stok Opname 5. Produk hilang 6. Produk cacat Scripting: PHP base code OpenCart database: postgreSql untuk query sudah saya buatkan framework query dari opencart ke postgre desain database dari saya, setiap perubahan struktur database harus dikonsultasikan terlebih dahulu (Penambahan kolom/tabel baru) Silakan kirimkan penawaran Anda (biaya dan lama pengerjaan), hanya untuk yang minimal sudah menguasai opencart 1.5.6 ya. Untuk detail si...

    $55 (Avg Bid)
    $55 Rata-rata
    4 penawaran

    Saya butuh programer untuk konversi Native PHP ke codeigniter. Mungkin teman-teman disini ada yang sudah pernah melihat sisfo kampus buatan mas setio dewo (open source), saya mau mengkonversi module super adminnya menggunakan codeigniter. Singkat cerita, yang perlu anda ...kampus buatan mas setio dewo (open source), saya mau mengkonversi module super adminnya menggunakan codeigniter. Singkat cerita, yang perlu anda lakukan : - Tulis kodenya dengan codeigniter Yang tidak perlu anda lakukan : - Melakukan analisa sistem, - membuat database, - setup framework, - memikirkan query SQL yang harus ditulis. I will provide a ready to use codeigniter with template you will use on this project. I will provide you the database. I have Native PHP query, just convert it wi...

    $98 (Avg Bid)
    $98 Rata-rata
    3 penawaran
    Build a Website Berakhir left

    Halo! Saya mencari Web Developer untuk develop web app (Koperasi) dengan kriteria sebagai berikut: 1. Paham dengan PHP Framework seperti Zend Framework / Laravel / Code Igniter 2. Bisa optimasi query (untuk reporting) 3. Familiar dengan Native Javascript, Jquery dan Ajax Diutamakan lokasi di Jakarta Selatan, untuk luar Jakarta juga bisa bisa asal report progress jelas. Timeline project 1 bulan. Buat yang berminat, silahkan bid project ini. Jika ada yang ingin ditanyakan, bisa langsung PM. Thanks!

    $373 (Avg Bid)
    $373 Rata-rata
    11 penawaran

    ...buat aplikasi android rekam suara. Format dari file suaranya adalah .amr dan penamaan dari file suara tersebut sudah disetting dengan ("yyyy_MM_dd_HH_mm_ss"). Ketika rekam suara berjalan, nama dari file suara tersebut langsung dikirim ke database dan setelah selesai proses rekam suara tersebut, file suara tersebut di upload ke server. Aplikasi ini menggunakan xampp sebagai server lokal dan my sql query browser sebagai database dan menggunakan file php untuk proses mencatat ke database. Problem yang saya alami adalah ketika rekam suara berjalan, nama dari file suara rekaman tersebut tidak tercatat ke database tetapi file suara tersebut berhasil diupload ke server lokal(htdocs). Tolong bantu kenapa hal tersebut terjadi. File dan merupakan file di folder layout dari

    $22 (Avg Bid)
    $22 Rata-rata
    2 penawaran
    Mobile Apps android Berakhir left

    Membuat User Interface untuk penghubung aplikasi web, cara kerjanya adalah membaca query dari database.

    $60 (Avg Bid)
    $60 Rata-rata
    3 penawaran
    Livescore Website Berakhir left

    ...Tennis / Basket / Badminton masih perlu pengembangan lebih lanjut seperti : 1. Pengelompokkan pertandingan setiap liga/negara. 2. Statistik setiap pastisipan. Kami mempunyai 2 opsi dalam pengerjaan ini, Anda menginginkan untuk memulai dari awal pengerjaan situs atau hanya mengembangkan untuk olah raga lain. Ruang lingkup dari pekerjaan ini adalah, Anda akan memerlukan pengetahuan SQL-Query untuk melakukan seleksi dari sejumlah database yang banyak (kurang lebih 50 table) dan melakukan pengelompokkan yang sesuai berdasarkan data dan pertandingan. Kami tidak membutuhkan halaman admin (back-end) karena database sudah secara otomatis ter-input dari pihak ke-3. Sebagai referensi

    $205 (Avg Bid)
    $205 Rata-rata
    4 penawaran

    Membuat aplikasi website dengan memanfaatkan data dari API yg saya sediakan (tersedia berbagai library dalam API: Python, PHP, Ruby). 1. Menyimpan hasil query API kedalam database 2. Menampilkan hasil query kedalam website sebagai konten website (CMS) Query akan ditambah setiap saat dengan query query baru (tidak ada pengulangan query yang sama).

    $1192 (Avg Bid)
    $1192 Rata-rata
    5 penawaran

    Dibutuhkan programmer dengan kemampuan : 1. PHP 5.0 or above 2. MySQL 5.0 or above 3. Familiar dengan framework codeigniter. 4. JQuery & framwork Kondisi Existing: 1. HTML, CSS, Bootstrap sudah ada. 2. Akan bekerja sama dengan seorang webdesigner 3. Sistem Backoffice sudah ada, mostly data produk disimpan pada sistem backoffice dan tinggal query saja. 4. Menggunakan Git Repo Responsibility: 1. Write, Test, Implement 2. Unit Testing 3. Every 2/3 Days Progress Report Deadline: End of this month (3 Weeks)

    $352 (Avg Bid)
    $352 Rata-rata
    7 penawaran

    ...Varien_Db_Statement_Pdo_Mysql->_execute(Array) #3 /var/www/clients/client1/web6/web/lib/Zend/Db/Adapter/(479): Zend_Db_Statement->execute(Array) #4 /var/www/clients/client1/web6/web/lib/Zend/Db/Adapter/Pdo/(238): Zend_Db_Adapter_Abstract->query('DELETE FROM `ca...', Array) #5 /var/www/clients/client1/web6/web/lib/Varien/Db/Adapter/Pdo/(419): Zend_Db_Adapter_Pdo_Abstract->query('DELETE FROM `ca...', Array) #6 /var/www/clients/client1/web6/web/lib/Zend/Db/Adapter/(661): Varien_Db_Adapter_Pdo_Mysql->query('DELETE FROM `ca...') #7 /var/www/clients/client1/web6/web/app/code/core/Mage/Index/Model/Resource/(112): Zend_Db_Adapter_Abstract->delete('cataloginventor...') #8 /var/www/clients/client1/web6/web/app/co...

    $19 / hr (Avg Bid)
    $19 / hr Rata-rata
    12 penawaran

    ...improvisasi pada situs http://livescores.web.id. Untuk jenis olahraga Soccer/Sepak Bola, sudah mencapai 85% dari target yang diinginkan. Sedangkan jenis olahraga lain yang tersedia seperti Tennis / Basket / Badminton masih perlu pengembangan lebih lanjut seperti : 1. Pengelompokkan pertandingan setiap liga/negara. 2. Statistik setiap pastisipan. Tantangan : Anda akan memerlukan pengetahuan SQL-Query untuk melakukan seleksi dari sejumlah database yang banyak (kurang lebih 50 table) dan melakukan pengelompokkan yang sesuai berdasarkan data dan pertandingan. Sebagai referensi, Anda dapat melihat juga situs lainnya seperti : http://soccerstand.com. Kami akan

    $216 (Avg Bid)
    $216 Rata-rata
    1 penawaran
    Livescore Website Berakhir left

    ...Tennis / Basket / Badminton masih perlu pengembangan lebih lanjut seperti : 1. Pengelompokkan pertandingan setiap liga/negara. 2. Statistik setiap pastisipan. Kami mempunyai 2 opsi dalam pengerjaan ini, Anda menginginkan untuk memulai dari awal pengerjaan situs atau hanya mengembangkan untuk olah raga lain. Ruang lingkup dari pekerjaan ini adalah, Anda akan memerlukan pengetahuan SQL-Query untuk melakukan seleksi dari sejumlah database yang banyak (kurang lebih 50 table) dan melakukan pengelompokkan yang sesuai berdasarkan data dan pertandingan. Kami tidak membutuhkan halaman admin (back-end) karena database sudah secara otomatis ter-input dari pihak ke-3. Sebagai referensi

    $704 (Avg Bid)
    $704 Rata-rata
    3 penawaran
    Livescore Website Berakhir left

    ...seperti Tennis / Basket / Badminton masih perlu pengembangan lebih lanjut seperti : 1. Pengelompokkan pertandingan setiap liga/negara. 2. Statistik setiap pastisipan. Kami mempunyai 2 opsi dalam pengerjaan ini, Anda menginginkan untuk memulai dari awal pengerjaan situs atau hanya mengembangkan untuk olah raga lain. Ruang lingkup dari pekerjaan ini adalah, Anda akan memerlukan pengetahuan SQL-Query untuk melakukan seleksi dari sejumlah database yang banyak (kurang lebih 50 table) dan melakukan pengelompokkan yang sesuai berdasarkan data dan pertandingan. Kami tidak membutuhkan halaman admin (back-end) karena database sudah secara otomatis ter-input dari pihak ke-3. Sebagai referensi, Anda

    $649 (Avg Bid)
    $649 Rata-rata
    1 penawaran

    ...improvisasi pada situs http://livescores.web.id. Untuk jenis olahraga Soccer/Sepak Bola, sudah mencapai 85% dari target yang diinginkan. Sedangkan jenis olahraga lain yang tersedia seperti Tennis / Basket / Badminton masih perlu pengembangan lebih lanjut seperti : 1. Pengelompokkan pertandingan setiap liga/negara. 2. Statistik setiap pastisipan. Tantangan : Anda akan memerlukan pengetahuan SQL-Query untuk melakukan seleksi dari sejumlah database yang banyak (kurang lebih 50 table) dan melakukan pengelompokkan yang sesuai berdasarkan data dan pertandingan. Sebagai referensi, Anda dapat melihat juga situs lainnya seperti : http://soccerstand.com. Kami akan

    $474 (Avg Bid)
    $474 Rata-rata
    6 penawaran

    ...improvisasi pada situs http://livescores.web.id. Untuk jenis olahraga Soccer/Sepak Bola, sudah mencapai 85% dari target yang diinginkan. Sedangkan jenis olahraga lain yang tersedia seperti Tennis / Basket / Badminton masih perlu pengembangan lebih lanjut seperti : 1. Pengelompokkan pertandingan setiap liga/negara. 2. Statistik setiap pastisipan. Tantangan : Anda akan memerlukan pengetahuan SQL-Query untuk melakukan seleksi dari sejumlah database yang banyak (kurang lebih 50 table) dan melakukan pengelompokkan yang sesuai berdasarkan data dan pertandingan. Sebagai referensi, Anda dapat melihat juga situs lainnya seperti : http://soccerstand.com. Kami akan

    $106 (Avg Bid)
    $106 Rata-rata
    13 penawaran
    Develop Website Berakhir left

    Pembuatan Website mirip dengan data query bisa ambil dr yahoo ato google dan beberapa site. dan beberapa bagian yang di input manual dan berkala.

    $65 (Avg Bid)
    $65 Rata-rata
    1 penawaran

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

    $8 (Avg Bid)
    $8 Rata-rata
    4 penawaran

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

    $61 (Avg Bid)
    $61 Rata-rata
    9 penawaran

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

    $5 / hr (Avg Bid)
    $5 / hr Rata-rata
    39 penawaran

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

    $6 / hr (Avg Bid)
    $6 / hr Rata-rata
    21 penawaran

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

    $107 (Avg Bid)
    $107 Rata-rata
    19 penawaran
    Python SNMP Developer Needed 6 Hari left
    TERVERIFIKASI

    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.

    $220 (Avg Bid)
    $220 Rata-rata
    12 penawaran

    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.

    $21 (Avg Bid)
    $21 Rata-rata
    20 penawaran

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

    $21 (Avg Bid)
    $21 Rata-rata
    16 penawaran

    I am seeking a ML, Data Science, and software architect specialist to help me conceptualize and design my platform's architecture, specifically experience with embeddings and vector search. I am building a platform where creators can share content across multiple formats and be remunerated fairly. We ingest various content, from podcasts, articles, white papers and infographics, then agglomerate it, extract the most relevant pieces of information based on the end user's profile (demographic data, parameters, queries, etc) and generate a response. Based on the user, the response may have multiple sources with various contributions to the generated answer. Using weighted calculations, we can allocate the proceeds to the content creators. Example: the podcast contributes 70...

    $612 (Avg Bid)
    Mendesak PK
    $612 Rata-rata
    4 penawaran

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

    $31 (Avg Bid)
    $31 Rata-rata
    36 penawaran

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

    $195 (Avg Bid)
    $195 Rata-rata
    9 penawaran

    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.

    $105 (Avg Bid)
    $105 Rata-rata
    33 penawaran

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

    $128 (Avg Bid)
    $128 Rata-rata
    13 penawaran

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

    $33 (Avg Bid)
    $33 Rata-rata
    47 penawaran

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

    $25 (Avg Bid)
    $25 Rata-rata
    25 penawaran
    Healthcare Data Scientist Needed 5 Hari left
    TERVERIFIKASI

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

    $2347 (Avg Bid)
    $2347 Rata-rata
    16 penawaran

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

    $1500 - $3000
    Bersegel
    $1500 - $3000
    94 penawaran

    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.

    $112 (Avg Bid)
    $112 Rata-rata
    18 penawaran

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

    $14 / hr (Avg Bid)
    $14 / hr Rata-rata
    29 penawaran
    Access Database Query Development 3 Hari left
    TERVERIFIKASI

    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

    $24 (Avg Bid)
    $24 Rata-rata
    41 penawaran

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

    $98 (Avg Bid)
    $98 Rata-rata
    16 penawaran

    I am seeking a Python expert with extensive experience in MS Access da...merge multiple MS Access databases into a single, coherent database. - Data Transformation: The data within these databases will need to be transformed to fit the new structure. - Query Optimization: Your role will also include optimizing queries to ensure efficient data retrieval and manipulation. Key Objectives: My main goal is to facilitate easier data management through this process. The end result should be a well-structured, consolidated database that is optimized for performance. Ideal Skills: - Proficiency with Python and MS Access - Extensive experience in database merging, data transformation, and query optimization - Strong problem-solving skills - Ability to deliver efficient and scalable d...

    $92 (Avg Bid)
    $92 Rata-rata
    80 penawaran

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

    $3 / hr (Avg Bid)
    $3 / hr Rata-rata
    15 penawaran

    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.

    $85 (Avg Bid)
    $85 Rata-rata
    12 penawaran

    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

    $3 / hr (Avg Bid)
    $3 / hr Rata-rata
    6 penawaran

    I am in need of a skilled front-end developer with experience with Reac... 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-friendly. Your experience in integrating Elastic Search with Django and your keen eye for modern design are what I prioritize for this proje...

    $12 / hr (Avg Bid)
    PK
    $12 / hr Rata-rata
    12 penawaran
    DevExtreme Scheduler API Integration 2 Hari left
    TERVERIFIKASI

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

    $93 (Avg Bid)
    $93 Rata-rata
    75 penawaran

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

    $3186 (Avg Bid)
    PK
    $3186 Rata-rata
    21 penawaran