Find Jobs
Hire Freelancers

Log de actividades (campos modificados SQL)

€12-18 EUR / hour

Closed
Posted 4 months ago

€12-18 EUR / hour

Análisis y guardado de cambios producidos en unas tablas y campos determinados de SQL
Project ID: 37687074

About the project

42 proposals
Remote project
Active 3 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
42 freelancers are bidding on average €18 EUR/hour for this job
User Avatar
Dear Vanessa J.,   We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time.   We are 25 years in this business and our technical specialists have strong experience in SQL, MySQL, Database Administration, Database Programming, Microsoft SQL Server and other technologies relevant to your project.   Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews.   Please contact us via Freelancer Chat to discuss your project in details or let's appoint time for Zoom meeting to meet and discuss your project in details.    Best regards, Sales department Tangram Canada Inc.    P.S. As seen from the details of your profile, you located in Europe. Be informed that our technical offices located in Europe too i.e. you will be able to work with our developers almost in the same time zone. 
€25 EUR in 5 days
4.9 (56 reviews)
7.5
7.5
User Avatar
Hello Good afternoon , I just finished reading the job description . I see you are looking for someone experienced in developing products using Database Administration, Microsoft SQL Server, Database Programming, MySQL and SQL. This is something I can do, Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) My Portfolio: https://www.freelancer.com/u/AwaisChaudhry Please start the chat to discuss it further. Regards, Awais
€22 EUR in 26 days
5.0 (28 reviews)
7.0
7.0
User Avatar
Buenos diás Solution for "log de actividades (campos modificados sql)": One approach to creating a log or record of activities with modified fields in SQL would be to use a trigger. A trigger is a database object that is associated with a table and automatically executes when a specific event occurs, such as a modification to a field in a table. To implement this solution, you would first need to identify the specific tables and fields that you want to track for changes. Then, you could create a trigger for each of these tables that will capture and store the information on any changes made to the specified fields. The trigger would need to be programmed to insert a new record in a separate log table every time a change is made to a specified field. This log table could have fields such as date and time of the change, user who made the change, the old and new values of the modified field, and any other relevant information. Additionally, you could set up the trigger to only log certain types of changes, such as updates, inserts, or deletes, or to track changes made by specific users. This would allow for more specific and targeted tracking of activities. Another option would be to use an auditing feature if available in your SQL database. This feature would also allow you to track and record modifications made to specified fields in a table. However, this may require additional configuration and permissions from the database administrator. In conclusion, by using triggers or database auditing, you can easily and efficiently create a log of activities with modified fields in SQL. This will provide a record of all changes made to the specified fields, allowing for better monitoring and tracking of data. Project description for "análisis y guardado de cambios producidos en unas tablas y campos determinados de sql": The goal of this project is to analyze and save changes made to specific tables and fields in SQL. This will enable better tracking and monitoring of data modifications for auditing or data analysis purposes. To achieve this, a trigger or database auditing feature can be set up to capture and store any changes made to the specified tables and fields. This will require identifying the relevant tables and fields and programming the trigger or setting up the auditing feature accordingly. The end result will be a log of activities with modified fields in SQL, containing details such as the date and time of the change, user who made the change, and the old and new values of the modified field. This log can be used for auditing purposes or for data analysis to identify patterns or trends in data modifications. Best regards, Giáp Văn Hưng
€25 EUR in 7 days
5.0 (52 reviews)
5.6
5.6
User Avatar
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. ..
€45 EUR in 887 days
5.0 (4 reviews)
4.6
4.6
User Avatar
Hello!! Good to see you. Thank you for reaching out regarding the analysis and logging of changes in specific tables and fields within your SQL database. I appreciate the importance of maintaining a comprehensive record of data modifications for effective data management and auditing purposes. Key Components of the Proposal: 1. **Analysis of Changes:** - Conduct a thorough analysis of the specified tables and fields to identify changes, additions, or deletions in the data. 2. **Change Logging Mechanism:** - Implement a robust logging mechanism to record and store the details of any changes made to the identified tables and fields. 3. **Timestamps and User Identification:** - Include timestamps for each change to provide a chronological record, and capture user identification information to track the source of modifications. 4. **Customizable Reporting:** - Develop a reporting system that allows for customized reports on changes, enabling easy retrieval and analysis of historical data modifications. 5. **Notification System:** - Optionally, implement a notification system to alert relevant stakeholders in real-time or at specified intervals about significant data changes. I am eager to discuss this proposal further and to understand any additional details or specific preferences you may have. Please let me know a convenient time for a discussion, I look forward to contributing to the success of your data management strategy. Best Regards, Sachin T.
€15 EUR in 40 days
5.0 (5 reviews)
4.8
4.8
User Avatar
As a highly skilled Full Stack Web developer with extensive experience in MySQL and database management, I'm confident that I can handle your Activity Log project flawlessly. Over the years, I've developed numerous software applications that required complex data monitoring and analysis, giving me deep insights into how to effectively store and analyze changes in SQL databases. In my over a decade-long career, I've successfully provided my clients with high-quality web-based management systems that optimized their business processes, including ERP, CMS, and Inventory Management Systems. This experience aligns perfectly with the task of analyzing and saving changes in specific tables and fields in your SQL database. Furthermore, I understand the importance of data security in your project. Being proficient in Web Security measures, I will ensure that all information is effectively protected and accessible only to authorized personnel. Don't miss out on my proven expertise, let's give your system a superpower together!
€15 EUR in 2 days
5.0 (15 reviews)
4.5
4.5
User Avatar
hello! After checking the job posting, I felt that your project was similar to one I had worked on before. I have undertaken similar projects to ensure I can provide you with satisfactory results. I can start your project right away and you would be interested in discussing the project details. Thank you for taking the time to review our letter. We look forward to hearing from you regarding further steps. thank you
€18 EUR in 40 days
5.0 (1 review)
3.6
3.6
User Avatar
Dear Vanessa J., I am Milos, a highly experienced professional with over 9 years of expertise in MySQL, SQL, Database Administration, and Database Programming. I have a proven track record of delivering exceptional results, as evidenced by my portfolio and customer reviews. I have carefully reviewed your project requirements and I am confident in my ability to provide you with high-quality results. Moreover, I am willing to work in the Spain time zone to ensure real-time updates on the progress of the project. I would be thrilled to connect with you and discuss the details of your exciting project further. My skills in SQL, MySQL, Database Administration, and Database Programming make me well-equipped to handle the analysis and storage of changes occurring in specific tables and fields in SQL. Thank you for considering my proposal. I look forward to the opportunity to work with you and contribute to the success of your project. Best regards, Milos
€18 EUR in 7 days
5.0 (1 review)
3.8
3.8
User Avatar
Hola, Soy un desarrollador SQL con más de 10 años de experiencia. Desarrollo disparadores, consultas SQL complejas, procedimientos almacenados, funciones y optimizo código SQL y bases de datos. Trabajó con bases de datos SQL Server y MySql. Estaría encantado de utilizar mi experiencia para desarrollar un mecanismo de registro para su tablas. Espero saber más sobre su proyecto.
€12 EUR in 40 days
5.0 (5 reviews)
3.8
3.8
User Avatar
As an experienced developer with a focus on Database Programming and deep knowledge of SQL and MySQL, I am confident that I can provide you with the perfect solution for your project. Throughout my 5-year career, my professional life has been dedicated to designing, developing, and publishing high-performing web and mobile applications. My solid understanding of front-end and back-end integration ensures that I can handle all aspects of the project proficiently. In regard to this specific task of analyzing and saving changes to specific tables and fields in SQL, I have extensive experience in capturing and tracking data modifications – a skill that will be incredibly valuable for your project's success. Alongside my proficiency in Database Programming, I bring strong skills in front-end development (JavaScript, React, Angular, VueJS) as well as back-end expertise (Python, PHP, Java, C#) to the table. Moreover, as a collaborative team player who values communication and timely delivery, you can be assured that the project will be completed according to your needs and time frame. I look forward to working with you on this project and delivering results that exceed your expectations.
€15 EUR in 40 days
5.0 (8 reviews)
3.8
3.8
User Avatar
Dear Client, I am well-versed in the analysis and tracking of changes in specific SQL tables and fields. With my expertise, I can implement a robust system to monitor, record, and save alterations within your database. My experience in handling similar projects ensures a seamless integration of this functionality. I am ready to commence work immediately. Let me manage this aspect for you, providing a secure and efficient solution. Additionally, I am committed to completing the task before seeking any advance payments. Looking forward to your positive response. Best regards, Vinod Malviya
€18 EUR in 40 days
5.0 (4 reviews)
3.0
3.0
User Avatar
Hello, As a Senior Web and Mobile Developer with extensive experience in SQL and database management, I believe I am the perfect fit for your project on analyzing and saving changes on specific tables and fields in SQL. Having worked with MySQL for many years, I have developed a deep understanding of its nuances, making me adept at building complex SQL queries for fast and efficient search/filters – a valuable skill in logging activities. In addition to my exceptional SQL expertise, I also have a strong grasp on various backend web development frameworks like Yii, Laravel, Slim 3, and Symfony, which will facilitate seamless integration of your logging system into your existing infrastructure. My proficiency in JavaScript (jQuery, Vue.js) further empowers me to handle front-end tasks that may arise during this project. Thanks
€12 EUR in 40 days
3.8 (2 reviews)
4.0
4.0
User Avatar
⭐⭐⭐======Hi Vanessa J. =====⭐⭐⭐ I am excited to submit my proposal for your project. I have developed a strong set of skills that make me confident in my ability to deliver high-quality work to your project. My approach to any project is to first gain a deep understanding of the client's needs and requirements. I will work closely with you to ensure that I understand your project goals and objectives, and that I am able to deliver results that meet or exceed your expectations. In terms of technical skills, I have extensive experience in Microsoft SQL Server, SQL, Database Programming, Database Administration and MySQL. I'm able to work independently, be detail-oriented, have strong problem-solving ability and excellent communication skills. Overall, I am confident that I can provide the best result beyond your requirements, and help you achieve your project goals. Looking forward to the opportunity to work with you and contribute to the development of the new website. Thank you.
€45 EUR in 33 days
5.0 (1 review)
2.6
2.6
User Avatar
Hi, there! Having confirmed the job posting, it seems like you might be looking for a senior developer for your project - Log de actividades (campos modificados SQL). I have worked with similar projects so that I can provide you with a satisfied result. This project really caught my attention because I have been working in this specific industry for 10 years now, and have not only gained experience or knowledge but, I have got the answer to the main problem which many clients face which is communication and I can assure that you will be satisfied and updated throughout the process, if we move forward. Can't wait to have you on chat with me, and to get started with this project. Regards
€27 EUR in 36 days
5.0 (2 reviews)
2.6
2.6
User Avatar
Hi! Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific field, making me the ideal candidate to handle your project. My proficiency includes MySQL, Database Administration, Database Programming, Microsoft SQL Server and SQL, which positions me as the best choice for the successful completion of your project. While I am well-prepared to begin, I have a few clarifying questions. Kindly drop me a message in the chat so that we can engage in a discussion regarding the project's budget and deadline. Thank you, and I look forward to the opportunity to collaborate on your project.
€12 EUR in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hola He visto tu descripción y entiendo lo que quieres hacer. No tengo problemas en hacerlo y puedo terminar en una semana. Vamos a discutir con más detalle. Gracias.
€15 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Client. Have read your job description carefully, and it's very interesting job for me. Always provide clean and well-structured code, with detailed specifications. So my product is easy to analysis, scale for even other junior developers. Promise only the top quality, fast turnaround, and great communication. You will be reported with the intermediate deliveries and project status everyday, and you will be able to take control over the whole progress. Whether it is a small or big project, I will always be aware that they are highly important to the client and I will do my best. Please feel free to contact with me. Thank you.
€20 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am proficient with SQL and will assist you perfectly with the requirements, let me know when we can connect to discuss this further and get started working on it ASAP. Looking forward to working with you
€15 EUR in 40 days
0.0 (1 review)
0.0
0.0
User Avatar
Hi, Could you provide more details about the tables and fields that need to be analyzed and saved in SQL? Are there any specific conditions or criteria for saving the changes? We have solid experience in SQL and database management, having worked on several projects involving data analysis and storage. With our expertise, we can efficiently handle this task for you. We are providing services since 1989 and you can check our portfolio on our official webhttps://www.iagsoft.com.pk. We are available to discuss the project and your requirements further. Let us know if you would like to proceed.
€15 EUR in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Amplia experiencia en el manejo de bases de datos sql, analisis y diseño, uso de ETL, herramientas de ciencias de datos
€20 EUR in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SPAIN
Leganés, Spain
5.0
6
Payment method verified
Member since May 30, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.