Sql query optimizermunkák
Mobil applikáció és webalkalmazás fejlesztéséhez keresünk fejlesztőket/programozókat. Az alkalmazás egy folyamatosan bővülő adatbázis adatai alapján végezne különböző összehasonlításokat, elemzéseket. A termékekről különböző ismérvek alapján rangsorokat, ajánlásokat tenne. Szükséges képességek lehetnek: felhő szolgáltatások ismerete, BigData, Android és iOS webapp fejlesztés, webfejlsztés (PHP, SQL, JS, HTML5, Python) adatvizualizáció, UX/UI dizájn, AI, verziókezelés. Az alkalmazásokhoz később fej...
Szia, MY SQL és PHP- webes programozásban tudnál segíteni? Lenne egy projectem. Köszi, Tomi
Szia, MY SQL és PHP- webes programozásban tudnál segíteni? Lenne egy projectem. Köszi, Tomi
Szia, MY SQL és PHP- webes programozásban tudnál segíteni? Lenne egy projectem. Köszi, Tomi
Szia, MY SQL és PHP- webes programozásban tudnál segíteni? Lenne egy projectem. Köszi, Tomi
Szia! Hosdzú távra keresünk programozót/fejlesztőt, meglévő GTA V szerepjáték szerverünkre, ami a FiveM kliensen fut. - ESX keretrendszer - Linux VDS-en fut a szerverünk Mit ajánlunk? - Hosszú távú partnerség - Havi fix fejlesztési díj (50.000Ft) Mit várunk? - Aktivitás: nagyobb bugok, hibák feltárása...őt, meglévő GTA V szerepjáték szerverünkre, ami a FiveM kliensen fut. - ESX keretrendszer - Linux VDS-en fut a szerverünk Mit ajánlunk? - Hosszú távú partnerség - Havi fix fejlesztési díj (50.000Ft) Mit várunk? - Aktivitás: nagyobb bugok, hibá...
Közismert márkanévvel fémjelzett, piacvezető, nemzetközi cég Senior Backend PHP Fejlesztő munkatársat keres meglévő és új projektekhez debreceni munkavégzéssel. Fő feladatok: Meglévő rendszerek backend fejlesztése PHP5-ben és SQL optimalizálása Új funkciók tervezése, dokumentálása és implementálása Új online üzleti megoldások tervezésében és fejlesztésében való részvétel Elvárások: PHP 5.3+ és jQuery magabiztos ismerete MySQL ismerete Adatmodellek és adatbázistervek implementálása,...
Szolgáltató váltás miatt kell átmozgatni egy oldalt. Web tartalom már lementve gzip-ként, adatbázis lementve sql-ként, csak össze kéne fésülni.
Egy ipari berendezéseket gyártó vállalat meglévő VB.NET tervező és ajánlatadó alkalmazását kell kiegészíteni ...alkalmazását kell kiegészíteni a teljes értékesítés, megrendelés, anyagbeszerzés, gyártás és implementáslás folyamatát lefedő folyamatkezeléssel. A folyamatot a könnyen megtanulható és alkalmazható ProcessMaker eszköz segítségével kell elkészíteni, amely grafikus vizuális felülettel támogatja mindezt. A folyamat kialakításához rendelkezésre áll a jelenleg kb. 60...
Keresünk Backend és frontend fejlesztőt Backend elvárások Több éves programozói tapasztalat Python 2 és 3 nyelven Több éves programozói tapasztalat főleg objektum orientált/kliens-szerver felépítésű program/rendszer fejlesztésben A Django framework alapos ismerete Django REST framework alapos ismerete Tesztelési technológiák ismerete (unit és browser tesztelés) SQL adabázisok alapos ismerete Linux alapszintű ismerete Frontend elvárások HTML5, CSS3, Javascript tapasztalat Angular framework ismerete Jasmine, Karma tapasztalat Előny az Angular Material Design ism...
Sziasztok! Egy most induló vállalkozáshoz keresnék programozókat. Akiket keresek a következő technológiák közül legalább kettőt kellene ismernie: - PHP - Relációs adatbáziskezelő rendszerek (kifejezetten MySQL/PostgreSQL) - HTML - CSS - JavaScript (lehetőleg ES2015 ismerete) Ezeken felül előnyt jelent, ha rendelkezel az agilis szoftverfejlesztési tapasztalatokkal is. Elsősorban PHP + SQL, illetve a HTML + CSS + JS együttes ismeretével rendelkező kollégákat keresek, de ha más „kombinációkban” ismered a fenti technológiákat, akkor is jelentkezz. Amennyiben felkeltette érdeklődé...
...programozó kollégákat. Akit keresek, a következő technológiák közül legalább kettőt kellene ismernie: - PHP - Relációs adatbáziskezelő rendszerek (kifejezetten MySQL/PostgreSQL) - HTML - CSS - JavaScript (lehetőleg ES2015 ismerete) Ezeken felül előnyt jelent, ha rendelkezel az agilis szoftverfejlesztési tapasztalatokkal is, illetve ha Budapesten vagy Debrecenben élsz. Elsősorban PHP + SQL, illetve a HTML + CSS + JS együttes ismeretével rendelkező kollégákat keresek, de ha más „kombinációkban” ismered a fenti technológiákat, akkor is jelentkezz. Amennyiben felkeltette érdeklődésed a ...
Incident management software Django frontend-del, MS SQL Server adatbázissal, .NET vékonykliens ticketing üzenetek előnézetéhez, REST API
Van egy működő WP oldal, amibe szeretnénk importálni a régi (egyedi cms-t használó) oldalon publikált cikkeket...legtöbb esetben egy folyóirat cikkei. Az importáláskor nem számít a publikálási idő, hanem az eredeti megjelenés (évfolyam, lapszám) szerint vannak kategorizálva. A régi adatbázis cikkekhez rendelve tartalmazza ezeket a tulajdonságokat. Az új WP-s oldal tudja kezelni az eredeti szerzőt és az megjelenést is, tehát csak az importálás kell, új funkciók a WP-be nem. A régi oldal fejlesztője készített sql queryket az importáláshoz, de nem...
Van egy működő WP oldal, amibe szeretnénk importálni a régi (egyedi cms-t használó) oldalon publikált cikkeket, s...legtöbb esetben egy folyóirat cikkei. Az importáláskor nem számít a publikálási idő, hanem az eredeti megjelenés (évfolyam, lapszám) szerint vannak kategorizálva. A régi adatbázis cikkekhez rendelve tartalmazza ezeket a tulajdonságokat. Az új WP-s oldal tudja kezelni az eredeti szerzőt és az megjelenést is, tehát csak az importálás kell, új funkciók a WP-be nem. A régi oldal fejlesztője készített sql queryket az importáláshoz, de ne...
Mobilfejlesztő iOS / Android / Windows8 Feladatok: • együttműködés a fejlesztésben résztvevő kollégákkal • programterv elkészítése • automatikus teszt rutinok megírása • együttműködés az árajánlathoz szükséges feladatbecslésben Elvárások: • Java, vagy .NET programozói ismeretek • mobile SDK felépítésének és kezelésének ismerete • SQL, SQL Lite ismerete • kliens-szerver hálózati kommunikáció programozás tapasztalat • 0-2 éves fejlesztői tapasztalat • gyors tanulási ...
...illetve mennyi idot toltott el mindevvel. (Testek, jatekok kesobbiekben.)rnrnMinta megjelenites honlap vazlat letoltesevel tekintheto meg. (Kezdo oldal )rnrnrnrnErdeklodesem ket feladatra vonatkozik: rn1. MS Access/ SQL programozasra vonatkozo feladat rnrnAlabb belinkelt PHP-ban irott script-er at tudja-e inri MS Access-be, vagy SQL-be.rnFuncioja nagyjabol a kovetkezo: megnezi, hogy adatbazisban adott nyelven talalhato szohoz van-e letoltve kiejtes, es ha nincs, akkor GoogleTranslate-bol letolti hangfajl formatumban egy adott konyvtarba.rnMennyi idobe kerulne egy ilyen program megirasa? rn(Egyelore az elvi lehetosege es a kapcsolodo dijazasa erdekel. Pontos specifikalasara
I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.
Hi, I am looking for expert to connect SQL database togoogle looker studio so we can analise data and creat reports, it is a long term coopartion. Please provide implementation cost and hourly charge. Best.
...programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation fro...
App para elaborar presupuestos fuera de la tienda. actualmente tengo un sistema de escritorio elaborado en sql server para facturacion. El sistema Funciona perfecto y tiene la opción de realizar cotizaciones pero quiero incorporar una app para realizar las cotizaciones de los clientes foráneos ya que tengo un empleado que los visita semanalmente y me toca estar transcribiendo los pedidos. Seria una app que permita cargar los inventarios y los clientes al momento de estar en la tienda Y luego poder realizar los pedidos o cotizaciones offline cuando se este fuera. Para luego cuando llegue a la tienda hacer la actualización o descarga de pedidos. que tan dificil es hacer la app para android y para ios.
We are seeking an experienced freelance developer to design and develop an online service booking platform targeted at legal professionals. The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user int...booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies (e.g., React, Node.js).Experience with SQL or NoSQL understanding of UX/UI design to meet deadlines.
...standards of code quality and push for continuous improvement. **What You Need:** - BS/MS in Computer Science, Engineering, or related field. - 2-3 years of full-stack development experience, with significant focus on mobile apps. - Strong proficiency in Flutter or similar, front-end technologies (HTML5, CSS3, JavaScript), and backend development (Node.js, Django). - Experience with databases (SQL & NoSQL), cloud services (AWS, Google Cloud, Azure), and versioning tools like Git. **Why Join Us?** - Flexible working hours and a chance to work in a dynamic, fast-paced environment. - Continuous learning and professional development opportunities. ? **Apply Now!** Send your resume, a cover letter, and work samples/portfolio demonstrating your expertise relevant to the role. ...
...user login/signup, in-app messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode scanning, Face Recognition - API integration with Google services This project will require rigorous testing to...
I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The p...Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in these areas. I'm looking for a reliable, communicative individual who can deliver a high-quality...
...diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQL - Experience with ER diagram creation - A...
I'm in need of a comprehensive, AI-driven resume web application tailored to job seekers. This application should serve as a one-stop solution for individuals seeking to construct and refine their resumes. Key features include: - AI-Powered Tools: The application must have automated resume building and optimization suggestions, allowing users to generate a robust resume without the hassle, and further fine-tune it for enhanced professionality. - Varied Templates: To cater to a diverse user base, the application should provide a variety of resume templates. Specifically, I am looking for professional, creative, and functional templates that give users the flexibility and range they require. Ideal applicants for this project should have extensive experience in web application develop...
I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples of your past ...
I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration ...be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are high...
i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it
I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...
...availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automate File Transfer Based on Client and Project: Implement a system that automatically transfers the transport query from one file to another in the local drive based on the client and the current project folders. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (distance, size, location). Automate Communication: Automate the process of contacting couriers via Outlook, including sending inquiry emai...
Kérjük, regisztráljon vagy jelentkezzen be a részletek megtekintéséhez!
...Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multipl...
I'm looking for a talented web developer to help improve my existing website. The changes I seek span across editing the design, content, and functionality aspects. (I just bought this from Astra Pro with Spectra, essential, Optimizer and YOAST - along with the Godaddy WordPress hosting) I have decent content from another of my sites to copy across to - Compress components with gzip Add Expires headers Make fewer HTTP requests Design Updates: - Changing colours: I want to refresh the colour scheme of the website to make it more vibrant and engaging - Updating fonts: The current font is outdated. I need a modern, sleek, and readable font to be implemented - Redesigning the logo: A logo redesign to reflect the updated color scheme and font Content Updates: - Updating
I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused
A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...
I'm looking for an expert in Microsoft Power Apps to develop...the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quality, functional solution w...
...assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, in...
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...
...setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on
...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product s...
Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking
Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).
Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto
I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the...
I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.
...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush or...
I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...
