Deleting records sql jobs
I'm in need of a virtual assistant to help manage my daily inventory data updates and email handling tasks. Responsibilities: - Daily Inventory Data Updating: You'll be responsible for keeping our inventory records up-to-date. This will include tracking stock levels, monitoring product movements, and ensuring all changes are accurately reflected in our system. - Email Handling: I need someone to manage my email correspondence. This will involve: - Responding to Customer Inquiries: You'll be required to engage with customers who reach out via email, answering their questions, and addressing any concerns they may have. - Managing & Organizing Emails: Your role will also involve organizing my inbox, ensuring nothing gets missed and that I'm able to prioriti...
I'm a BCA student with proficient skills in Microsoft Office, Access, Oracle & my SQL. I'm currently seeking a freelancer with advanced data entry proficiency to assist with data entry tasks. Specifically, I need help with: - Entering data into a document - Ensuring that the document has advanced formatting requirements, including tables, charts, and images Ideal skills and experience for this job include: - Proficiency in MS Office Suite (Word, Excel, PowerPoint, Access) - Experience with advanced document formatting - Attention to detail - Ability to work with data accurately and efficiently Please note that while my project is mainly focused on data entry, a background in database management and SQL will be considered a plus.
I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus
I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.
I'm looking for a skilled Python developer with experience in web scraping and Selenium. Your task is to extract a domain list from a given URL (). The data extracted should be cross-referenced for each domain with the follo...with the following fields: name, full address, email, and phone. Key Requirements: - Extract domain list from a specific website () - Implement cross-referencing for each domain with name, full address, email, and phone - Proficiency in Python and Selenium for web scraping - Ideally, experience with data cleaning and manipulation Please note that the number of records on the dealer locator is unknown. Your ability to handle large data sets will be crucial for the successful completion of this project.
...infrastructure. The goal is to enhance security, ensure data privacy, reduce dependency on third-party email services, and customize the email system to meet our specific needs. The project will involve setting up the server, configuring DNS records, installing and configuring necessary software, securing the server, and ensuring seamless email access for all users. Key Deliverables: Infrastructure Setup: Set up a dedicated server or VPS with a static IP address. Configure necessary storage and network resources. DNS Configuration: Configure MX, SPF, DKIM, and DMARC records to direct email traffic to the server. Software Installation and Configuration: Install and configure Postfix for email delivery. Install and configure Dovecot for IMAP and POP3 services. Optionally...
I'm in need of a logo for my upcoming record label, 9 Acres Records. It's a small project, but I'm looking for a high-quality, professional design that captures the essence of my label. Here are the key requirements for the logo design: - Name: 9 Acres Records - Color: Green Grass - Style: *Sketchs & examples attached* Font MUST be in OLD English font Ideal Skills and Experience: - Experience in logo design, particularly for the music industry - Ability to deliver a professional, eye-catching design - Creativity and willingness to collaborate on ideas - Excellent understanding of color theory - Strong communication skills to ensure we're aligned on the design I want this logo to be the face of 9 Acres Records, so I'm looking for a talen...
I'm seeking a skilled developer to make specific improvements to my exi...QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Order Number" The ideal freelancer for this project should have: - Proven experience working with PHP, particularly in customizing and enhancing applications. - A solid understanding of QuickBooks Online's...
I am in need of a skilled developer to assist with an existing API integration between SilverStripe website and REX Software, with a focus on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and updates property listings between these two platforms. Ideal Skills: &bull...
...“schedules”); A. Account Receivable, B. Account Payable, C. Payroll (Included MPF) D. Loan, E. Accrued expense. F. Amount due from/to G. Bank transaction. H. Fixed asset (with depreciation) 5. Prepare monthly financial statement (with the schedules Above) "Additional Scope" (I want you to do) 6. Using the accounting system "Odoo" for better recording process A. The Ideal scenario is keeping all the records at the Odoo. 7. Advise and enhance better workflow in accounting with our colleagues. 8. Translation from the Chinese to English from both. “Advance Scope” (I hope you to do) 9. Recording in manner of Managerial Accounting (costing schedule by projects) 10. Communication with clients or vendors regarding accounting matters 11. Assisti...
...companies, and airline carriers register through a user-friendly web interface. User details, including CRM data, are captured during registration. Freight Tracking and Reimbursement: Record transportation details (departure, arrival, quantity of commodities) for each shipment. Calculate reimbursement amounts based on sales and freight costs. Automated reconciliation ensures accurate financial records. Automated Reporting System: Generate real-time reports on: Freight expenses Commodity quantities transported Reimbursement status Funding approvals User activity User Roles: Commodity growers: Apply for funding, track shipments, and receive reimbursements. Shipping companies: Register, manage shipments, and provide freight services. Organization officers: Monitor approvals, oversee...
I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus
...and dexterous home assistant and sitter who can competently handle a number of responsibilities. It’ll be 6 days a week. And 3-5 hours per day. Tasks and Responsibilities: - Able to follow instructions. - Computer literacy. - Manage home. Home Management: In addition to the above, the successful candidate will assist with household inventory management, maintaining comprehensive records and ensuring that everything is in its rightful place. Ideal Skills and Experience: - Demonstrated experience in home sitting and assistance. - Exceptional organizational and management skills. - An eye for detail, especially when dealing with inventories. - Good communication skills. - Ability to follow orders. This is a demanding job that requires a flexible...
...data must be verified using third-party tools before submission. Only verified records will be accepted, and payment will only be issued for data that is verified to be accurate. Verification Process: After you have submitted the verified data, we will also be verifying the data ourselves to ensure the accuracy of the data. We will verify the email addresses through Zero Bounce, the phone numbers through Tele sign, the addresses through USPS Address Lookup, and will test all URLs and links to ensure they are accurate as well. Payment / Replacement Data: Once the data is verified, we will then release final payment, and if any of the contact details come back as invalid, we will request replacement data records. If this project is successful, we will have many more proj...
I'm running a Node.js website where the last user's data is mi...promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving similar issues is a plus. - Deadline-oriented and able to work efficiently to resolve this issue. Please refer to the attached video for better understanding of the issue. Your prompt attention to this ...
I need a skilled professional to install Mail-in-a-Box on my RackNerd server. You should set up all the necessary DNS records and ensure the installation is fully secured by implementing a Secure Connection SSL / STARTTLS. Key Requirements: - Installation of Mail-in-a-Box on RackNerd server - Setting up all necessary DNS records - Implementing Secure Connection SSL / STARTTLS Ideal Skills and Experience: - Proven experience with Mail-in-a-Box installations - Strong understanding of DNS management - Expertise in SSL/TLS configuration - Prior experience with RackNerd servers The primary purpose of this project is for educational/nonprofit use, so your help in ensuring the security and functionality of this setup is crucial. Please only apply if you have relevant experience a...
... Essential Skills and Qualifications: - Expertise in using Visual Studio for software development, including .NET and PHP programming. - Proficiency in Azure DevOps for project lifecycle management, including CI/CD pipelines and agile project management. - Experience with Microsoft Azure, especially Azure Service Bus and Azure Functions. - Strong knowledge of database management with MySQL and SQL. - Ability in RESTful API development and OAuth security practices. - Excellent problem-solving skills and ability to work effectively in a team environment. Education and Experience: - Bachelor’s or Master’s degree in Computer Science, Software Engineering, or related field. - At least 7 years of full-stack development experience, with a focus on complex cloud-based solut...
I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ...features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations shoul...
I am looking for a skilled developer to create an engaging Employee Pre-Verification system. This system will focus on Background check and Referral check. Key Functionalities: - **Background Check**: This system should have the ability to conduct background checks on potential employees. This can involve checking criminal records, credit history, and other relevant information. - **Referral Check**: The system should also incorporate a referral check system. This can help verify the authenticity of the references provided by the employee. User Interface: - The UI of this system should be interactive and engaging. This will ensure that the system is not only functional but also user-friendly. Reporting System: - The system should generate reports in two ways: - **Downloadable ...
I'm looking for an experienced WHMCS developer to help improve an already developed financial history graph. I had a developer from before that told me he could improve the module by take order dates and other dates already in the database to fill in missing data of the graph. Right now the graph just records order and financial information in the database and displays it on the graph. Where there is no data the graph just shows a straight line as shown in the demo screenshot. So I want the graph to show the data that its table is missing by getting this information from the WHMCS database. The end result would fill in the missing data of the straight line and also show the history on the graph from the start of the database, right now it only goes back 3 years because that is ...
I need a CRM solution designed around the latest version of Odoo, O...designed around the latest version of Odoo, Odoo 13 or Zoho. I'm looking for developers with specific skills and experience customizing Odoo CRM or Zoho Creator (CRM). Key features I need to integrate: - Contact management - Management of the Contracted Services pipeline - Customer support tickets - Agenda management with confirmations via automation via email and Whatsapp - Patient Medical Records - Integration and Management of WhatsApp messages - Built-in video calling appointments Additionally, the project requires specific design and branding elements that will be explained in more detail during the selection process. An eye for detail and a creative mindset are required to meet the specifics of the p...
...com/ Base Website Custom Design: Includes up to 4 unique page designs. Responsive Layout: Mobile-friendly design that adapts to various screen sizes and devices. CMS Integration: WordPress installation and setup, allowing for easy content management. Content Strategy Session: Session to outline the site’s content needs and SEO goals. Contact Form: Integration of a basic contact form which stores records in the CMS system. Google Analytics Setup: Integration of Google Analytics for tracking website traffic. Security Plugins: Installation of security plugins to help protect the website from common threats. The following pages are included in the base design package. • Home • About • Travelers • Clients Additional Page Development Creation of additional web...
Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, reca...
I'm on the lookout for an experienced GDPR solicitor who can provide sound advice and representation on legal issues primarily concerning data breaches. My organization routinely deals with a considerable volume of potentially sensitive phone call records. Here are the main tasks that the right candidate should be prepared to handle: * Legal Guidance: I need expert advice on how to navigate legal disputes related to potential data breaches involving phone call records. * Legal Representation: The ideal candidate must be well-versed in representing an organization during any potential legal dispute, with an emphasis on data breaches. If you have a thorough understanding of GDPR compliance, with a particular emphasis on data breach protocols - I would like to hear from y...
...platforms, and is designed to provide users with medical opinions using AI. Key features to be included in the app are: - Diagnosis Suggestions: The app should provide users with accurate diagnosis suggestions based on their reported symptoms. - Symptom Checker: A symptom checker that helps users identify the possible medical conditions related to their symptoms. - Medical Records Storage: A secure and easy-to-use medical records storage system, allowing users to keep track of their health history. Ideal candidates for this project should have: - Proven experience in designing UI/UX for mobile applications, particularly in the medical or healthcare sector. - Proficiency in understanding and translating complex requirements into user-friendly designs. - A strong portfolio...
I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration
I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.
I urgently need an expert in C# to integrate my Point of Sale/Enterprise Resource Planning (POS/ERP) system with QuickBooks Online. The goal is seamless syncing of different modules, including, but not limited to: - Customer Information - Inventory Status - Purchase History - Sales Records - Products, Categories, etc... Familiarity with QuickBooks Online APIs and proficiency in C# .net Core is imperative for this role. Past experience with similar projects will be highly valued. The timeline is urgent; I need this integration done ASAP. we already have a code we made integration with SAP Business One, we can share this code to have the fastest development, and also we have the code of a previous developer who made of Quickbooks so it would help to see how to integrate
I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Manag...agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL is required, a...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
Looking for a professional who can integrate a donation page into a website using CCAvenue as payment gateway.. Tasks Use our donation page with 6 different donation options and amounts and make the checkout via CCAvenue work. Design/create form to c...to collect donor details (name, email, address, PAN etc) based on a sample form that will be provided. Backend Development (PHP): Integrate CCAvenue API using their PHP libraries. Develop functionality to capture donation amount and donor details. Send transaction data (amount, details) securely to CCAvenue for payment processing. Create a database to store donor information and transaction records. Payment Processing: Handle CCAvenue response (success/failure) after payment authorization. CCAvenue account to use for this project...
In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Set...framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ability to deliver on...
Hi, Looking for a person to create an spread sheet monthly for sales records during that month. Will need to take information off of individual sales order sheets/emails and transfer it onto a spread sheet... buyer/address/item(s) they bought/amount they paid etc. Will be a reoccurring task per month. Will pay per month, expecting 100-200 sales per month. Please show rate per entry.
Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database
I need a reliable professional to help me with monthly inventory updates from the dealers and the sales department. Key Tasks: - Quantity Update: Ensure all stock levels are accurately reflected in our records. - Product Description Update: Make sure all product descriptions are up-to-date and accurate. - Product Code, UOM (Kit/Vials), Rupee Value: Cross-check and update product codes, Unit of Measure (Kit/Vials) and Rupee Value accordingly. Format: I have a specific format that the inventory updates need to be in. You will need to use this template to ensure data consistency and compatibility with our existing systems. Frequency: This is a monthly task and I would need your support on an ongoing basis. Ideal Skills: - Proficiency in inventory management. - Attention to detail ...
I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment info...
Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.
...Communicate effectively with clients, providing updates on order status, resolving issues or concerns, and addressing additional requirements. 5. Utilize platforms such as Alibaba and other sourcing channels to place orders and manage procurement processes. 6. Coordinate logistics and courier services for shipments, ensuring accurate and timely delivery of products to clients. 7. Maintain detailed records of procurement activities, including orders, contracts, and correspondence with suppliers and clients. 8. Proactively identify opportunities for process improvement and efficiency gains within the sourcing and procurement function. 9. Able to handle one to two client accounts simultaneously, ensuring each receives the highest level of service and attention. Benefits: 1. Flexibl...
I am seeking a full stack PHP developer to assist me with my project. I'm l...you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this project is for you. Your ability to work both independently and collaboratively will be key to our success. Ideal skills and experiences include: - Proficient in PHP and related frameworks - Strong knowledge of HTML, CSS, and JavaScript - Familiarity with SQL and database management - Experience in user authentication and payment processing - Understanding of project management and problem-solving - Excellent communication and time management skills I am looking to commence this project at the earliest convenience, so please get in touch if you're avail...
I need a freelancer who can conduct a comprehensive background check for pre-employment purposes. The task involves: - Conducting a thorough check on the candidate's criminal records - Verifying the candidate's employment history - Confirming the candidate's educational qualifications The ideal freelancer for this project should be well-versed with background checks, have access to reliable databases and be able to compile the information accurately and efficiently. Please note that the privacy and confidentiality of the candidate's information is of utmost importance.
I'm looking for an experienced hacker who specializes in database scraping to assist with lead generation. My main aim is to get detailed contacts to grow my business. - Specific Tasks: - Database scraping - Extract contact details - Contact Information: - Email addresses - Phone numbers Idea...get detailed contacts to grow my business. - Specific Tasks: - Database scraping - Extract contact details - Contact Information: - Email addresses - Phone numbers Ideal candidates should have previous experience in the field. Proficiency in data mining and scraping is a must, along with an understanding of lead generation strategies. Strong grips and successful track records on obtaining accurate contact details are key to perform this j...
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
...hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Perso...
I am in need of an expert who can proficiently implement DMARC, DKIM and SPF records to improve my email deliverability and security level. I'm currently using GoDaddy as my email service provider, hence, hands-on experience with GoDaddy will be crucial for this project. Key Requirements: - In-depth understanding of implementing DMARC, DKIM and SPF records - Expertise in email security - Experience with GoDaddy and Klaviyo - Ability to complete the task ASAP Only bid if you are confident you can meet these criteria. This is a priority for me and should be handled with the utmost professionalism.
I'm looking for a skilled app developer with expertise in both iOS and Android platforms. The primary function of the app is car service booking. It should have a clean, intuitive interface and be secure to ensure use...booking. It should have a clean, intuitive interface and be secure to ensure user trust. Ideal Skills and Experience: - Expertise in developing apps for both iOS and Android - Experience in developing service booking apps - Knowledge of secure app development - Strong UI/UX skills Features to Include: - Users should be able to book and pay for services - The app should store previous service records for easy rebooking - Should have a system to compare prices from different service providers. Your proposal should include a timeline and cost estimates f...
...---------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need look up the `11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game.
I'm dealing with a critical issue related to fake accounts on Ins...uncover these identities for Court purposes. I am already involved in an open lawsuit with the one believed to be the source for obvious reasons, but need solid evidence to prove harassment of these fake accounts. Your Experience: • You should present your experience in tracking down fake profiles. • Familiarity and skill in dealing directly with these platforms is a must. - Able to produce records for legal purposes. Project Expectations: • Leverage your past experience to track down the IP address and identity behind these profiles. • I emphasis on performing the task via direct communication with the relevant platforms. Don't just bring your experience - bring solutions. It�...
...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randoml...
