Write MySQL Queries for time based reporting and table indexing design

Good Day, One of my speciality is mySQL DBA. Part of my daily work is query optimisation against the database data model. I work with data comprising of multi million row large datasets. My rule of thumb is if a query is taking longer than 1 second you are doing something wrong. I will be happy to assist you with your project. My first language is English which will make communication easy. I will be more than happy to also provide you with a short document describing what I have done so that you may understand what my optimisation steps and thoughts entail. Thanks

Hello there, it seems that you require to pre calculate the data for faster searching which is good but to be honest 1 million is not huge. Pls share me more details so we can discuss. I’ve been working with a hundred of million before so I don’t think its a problem to me. Waiting for your response if interested. Thank you!!!

I have more then 15 year’ experienced in full stack .NET developer in ASP.NET Core / MVC / WinForm, C#, Razor, Jquery, HTML5, Telerik, DevExpress, SQL Server, MySQL, PostgreSQL. As i am expert, I can build it according to your requirements. Because I have a lot of the experiences about these fields, I can build your project as soon as possible perfectly. I offer excellent software quality work and provide the best support on your project. If you give me this job, I will do my best to finish your job until your timeline. If you want to see my past works, I can show you my past works right now. Ready to discuss with you about the task now. Thank you for the reading.

I have designed and provided solution for similar problem in past. You will definitely need a aggregator table to store results day, week and month-wise. I can help you with this. Do note that quote is not actual. Why me? I only take one job at a time and work on the same till it's delivered. I believe in proactive communication and quality delivery. I assure you that I will satisfy with my work ⭐⭐⭐⭐⭐ (My Freelancer Reviews: https://www.freelancer.com/u/rockingrik.html#/reviews). We can discuss more over chat. Thanks

Hi Hiring manager C#, ASP.net, ETL, BI, DBA, SQL and PL/SQL Expert 15+ years experience in software development, database programming and administration, and project management. My proficiency are given in the following- Specialist: SQL, PL/SQL, T-SQL, PL/pgSQL, ETL, Database Migration, SQL Optimization, Stored Procedure , C# , ASP.NET, AWS, Google Cloud, Microsoft Azure Database Expertise: MySQL, MariaDB, Oracle, MSSQL Server, PostgreSQL, EnterpriseDB, DB2, MS Access Database Administration and Programming: Install, configure and administration database server Design and Implement real time database replication and clustering Design and Implement data warehouse solution Database load balancing Database backup and recovery Database performance tuning and optimization Database Migration SQL Optimization Creating procedure, functions, triggers and packages Web Application Development: ASP.net, C#, HTML, CSS, Java Script, Ajax, Jquery, Entity Framework, Crystal Report, Microsoft Reporting Desktop Application Development: VBA, VB6, VB.net, C#, Crystal Report, Microsoft Reporting Application Server and Middle-ware: IIS, Apache Tomcat, HaProxy, PgPool-II, Proxy SQL Cloud Computing: Google Cloud, AWS & Azure. Operating System: Red-hat Linux, Centos, Ubuntu, Windows DevOps and Automation: Ansible, Python, Bash Shell Script, Jenkins, Apache Airflow ERP and CRM: Microsoft Dynamic Great Plan (GP) Microsoft Dynamic CRM Customized ERP and more Thanks

SQL , Mysql Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.

I am profasional database designer and SQL query expert. I checked your mentioned details and confident one that I can do perfectly

Hi There!! No upfront milestone and 24*7 Support With a 100% money-back guarantee. We are here to provide the best quality solution for all your requirements related to: - Websites design and development - Online Stores - PSD to HTML, HTML/PSD to WordPress - Mobile apps - SEO/SMO optimization - Graphic designs - Web-based applications - Website development Do you know Our prime GOAL, Motivation to work and Motto converge only on CLIENT SATISFACTION! henceforth, we succeed in establishing long-time and reliable business relationships with my valuable clients. resulting in very high Hire rate. WHY CHOOSE US: ✔️Experience: 194+ successful projects on freelancer.com and 500+ overall ✔️Quality Satisfaction: 5 Rated reviews with a very high repeat hire rate. ✔️Best Support: provides support after project delivery. ✔️On-time delivery ✔️Fair price and standard quality work ✔️Always available here for future assistance. You just need to click on the HIRE ME: button and we will be with you to transform your ideas into a successful business. Thanks & Regards. NaylaZ

Dear ! I'm ready for your Job this is owner able for me I'm work for you and complete it in professional way. Looking forward with you. Regards: Theata Solution

*** EXPERT SQL DEVELOPER *** I may provide you all queries and optimize your database according to your requirements. My expertise includes the following - MySQL - MS SQL - Oracle - .NET - ASP. NET - C#.NET - WPF - WEB FORMS - WINDOWS FORMS - Android - PHP - Python - Files Processing (File Formats: PDF, WORD, XML, CSV, TEXT) I have already worked on different projects and databases for websites and desktop-based Applications. Let us talk and discuss your task to start it right now. Hopefully seeking the acceptance of the proposal.

Passion + Creativity + Experience = Success Hi,there,How are you? I am Arsen and thank you for posting a job that fits my skill set. I'm really interested in your project that requires a lot of experience and good problem-solving skills. I can complete this project perfectly according to your requirement because I know what can be the solution and what part will be difficult in this project. What I really like is ciritical thinking and problem solving ability. I would really appreciate it if you could contact me and discuss the assignment. I wish you best of luck in your bussiness. Thanks for your attention & Regards

Hello, I hope this finds you well. I have just seen your project requiring; SQL MySQL Database Programming Relational Databases I believe that my 10-year experience in this field is what you need right away. Avoid the headache of looking further. Let's save time and focus on the real task. My proposed timelines and budget are just placeholder and an open for negotiation to increase or decrease as per the full requirements at hand. Allow me to prove how better my review can be. Smile all the way! Click the message button, so initiate the conversation. Regards, Fridah

Hi there, I have more than 5 years of experience in web design and development. I think your job is very suitable for me . Our skills: Programming Skills: AngularJS, Bootstrap, CSS3, HTML5, jQuery, JavaScript and Ajax.. Backend Tech:- PHP, Node.js, Laravel, CodeIgniter, WordPress Mobile Stacks: IONIC 2, 3, 4, Cordova Database: MySQL, MongoDB Servers: Apache

7+ years experience in Reactjs / Redux / Angular / flutter / Nodejs / PHP / Django / Backned - Frontend development! All of our programming skills: *Front-end: - HTML, HTML5, JSON. - TypeScript, JAVASCRIPT (Ajax, , flutter, AngularJS / 2 / 4 / 5 / 6 / 7 / 10 / 12, ReactJS - Redux, Jquery). - CSS, CSS3, Twitter Bootstrap, Less, Sass, Scss, Responsive, Material. - Mobile apps: React Native, Swift, ObjectiveC. - Page speed optimize *Backend Skills: - Python (Django), ROR, C#, PHP (Framework: CAKEPHP, Yii, Laravel, Ci), Node.js. - MVC, OOP, CURL, MongoDB, Postgres, MySQL, Rest APIs. *Other skills: - Git, Heroku, SVN, Bitbucket, HG, Linux, Mac - Vagrant, VirtualBox, Gulp, Grunt - AMZ S3, AWS EC2, IIS FREE support after delivery up to 4-6 weeks

Hello , My Name Is Pedro Faria, I Have a one idea for work this , in my last work i create a query automate for users in excel and have a created variables filters and Optimized's relatory, but need a discuss.

Hello, I'm a MySQL expert, No problem to finish your job. Especially, I have strong skills in optimization of queries and creation of summary/aggregate tables I have a degree in computer science and 7 years of experience working as a MySQL expert. I am certain that I have the skills you are searching for in an applicant and I hope to meet with you soon to discuss your project in more detail. With my comprehensive experience in Relational Database and Database programming, coupled with my enthusiasm and dedication to helping clients achieve success, I believe I could swiftly surpass your expectations for this role. I look forward to discussing your needs and what I can offer in further detail. Thank you for your consideration. Sincerely, Regina R.

Hi We have a team of developers who are proficient in MySql, Oracle, and MS SQL. They work on enterprise applications like CRM, Supply Chain Management, ERP, Finance, and Insurance Domain. I assure you of timely delivery and quality work.

Hi, I sincerely hope you are doing well and safe from ✔️covid-19✔️. I like Data Modeling, DML(Data modeling language) and DDL (Data definition language) Hi, I have checked your description carefully and very interesting. I have been trying to become RDBA, I am very family with database management. While checking your job description, I knew you were looking for experienced and reliable developer. For the last 6 years, Developing more than 4 websites, I have met and solve many problems and enough experiences in this area. The techniques I got about database optimization are following: - Optimizing Queries with EXPLAIN. We can look execution plan of optimizer. - MySQL Query Log. slow executed query is stored here. - Optimizing Database Schema. Limiting the number of columns, Normalization - Use Indexes - MySQL Query Caching. provides database caching functionality. - Converting OUTER JOINs to INNER JOINs ... I can finish your issue with my skills. please check my result

Hello there, I have 2 years of SQL relational database experience and can solve your problems. If you are interested in my services, please ping me or call the number below.

Hi, My name is Layro Chrystofer and I am writing to express my strong interest in this project. I am very strong at MySQL query so I would be the best fit for this project. I can complete this project within 5 days. Please message me so we can discuss further. Best regards! Layro

Hello, I would like to know more details about the project, I have advanced knowledge and work with technology associated with your requirements.