Relatório sqlproiecte

We are building a data warehouse which will gather data from different endpoints holding the same database (40+ servers). This data warehouse will live on AWS The data will be sent from the servers to S3 and then processed by AWS Glue The data lives on a SQL server DB on all different servers (schema is the same) We already have the plan laid out, we just need a devops / solutions architect to take the lead Proeficcient on: Batch / Powershell scripting AWS Glue AWS S3 AWS RDS AWS VPC / networking

...develop a "control panel" where we will manage technical service for the devices. If we fit at the budget level in the first instance, we will have a meeting for more details. Please indicate budget, agenda availability and estimated time for its development. For a preselection of the Backtend Programmer we are taking into account the following requirements: Program in languages: Java JavaScript SQL Python C# PHP HTML/CSS Previous proven experience working on frameworks, backends and frontends (to ensure integration). Experience working in a team. Experience reading Flowcharts and working with specific objectives. Is required: Immediate availability to start Agenda availability for the coming weeks Offered: Meetings to clarify any point. Seriousness, real project...

<SQL> SELECT o.sales_order_number AS 'Order', AS Container, t.tag_id AS Tag, IFNULL(, 'ALL') AS Priority, Pickup_Location AS Origin, Delivery_Location AS Destination, DATE(Delivery_Time) AS Delivery_Date, Tender_Time, Pickup_Time, Depart_Time, Arrival_Time, Delivery_Time, Deliver_Driver AS Driver, m.Business_Unit, AS Party_Name FROM summary AS m LEFT JOIN tag AS t ON m.tag_row = LEFT JOIN priority AS p ON = LEFT JOIN shipment_packing AS k ON m.tag_id = LEFT JOIN shipment AS s ON = LEFT JOIN table_order AS o ON s.buy_order = LEFT JOIN business_unit ON CAST(m.business_unit AS SIGNED) = LEFT JOIN party ON = WHERE Deliver_Driver IS NOT NULL and Delivery_Time

We have a parking management system, where sometimes we see 30 vehicle in month get access to no card login, which should not be the case, We need an expert who can access it on share screen and fix it asap. Changes required only in SQL server stored procedures only.

We are looking for a skilled full-stack developer with experience in C# and .NET Core developer to join our team for a stack development project. The ideal candidate should have a strong understanding of both front-end and back-end development, as well as proficiency in C#, .NET Core, SQL Server and Azure Cloud. Skills Required: .NET, C# Programming, Full Stack Development, Azure, SQL Server

Actualmente tenemos este desarrollo para SQL Server, y queremos pasarlo a Postgress son solo 20 end points

I'm seeking an experienced PHP developer to elevate an existing system's analytic capabilities. Here’s what I need: - Installation and customization of a PHP script, specializing in data reporting, analytics and Bulk Inventory upload Script bought from Codecanyon Ideal Skills: - Proficient with PHP and SQL databases - Prior experience with analytics-related scripts - Understanding of data privacy and security measures - Ability to optimize for performance and scalability Experience Requirements: - Portfolio showcasing past work with PHP, especially in data-centric applications - References or testimonials validating expertise and reliability Freelancers should provide a detailed proposal outlining their approach, timeline, and any suggestions for script improve...

We're looking for a talented and...an engaging and intuitive interface for our platform. • Implementing Server Side Logic: Harness your skills to deliver solid server-side solutions and ensure the functionality of our platform meets the project requirements. • Managing the Database: Utilisation of the Microsoft Database/SQL to effectively manage and organise information on our platform. Ideal Skills and Experience: • Extensive knowledge in HTML, CSS, JavaScript required. • Mastery in Node.js/Express.js, React.js, and Microsoft Database/SQL or other similar database platforms necessary. • Proven experience in UI design, server-side logic implementation, and database management. We look forward to working with a skilled professional who can con...

I'm in immediate need of a skilled Data Science professional to collaborate on various tasks. Here's what I'm looking for: - Mastery in **Python**, **R**, and **SQL** - Comfortable with **data cleaning and preprocessing** - Capable of conducting **statistical analysis** - Experienced with **machine learning modeling** Ideal applicants should demonstrate: - Proven track record with relevant **past work** - Substantial **experience** in similar projects - Ability to craft a **detailed project proposal** Your expertise will play a crucial role in the success of my project. If you possess the skill set mentioned and are available for immediate start, I look forward to your proposal!

I'm in need of a competent web developer skillful in ASP.NET webforms, JavaScript, and familiar with techniques such as Fetch and AJAX. The project involves building a comprehensive hotel management system with a SQL server database. Key functionalities required are: * Booking Management - the system will need to handle a volume exceeding 50 bookings a day efficiently. * Inventory and Room Management - keeping track of hotel supplies and managing room distribtution. * Customer and Account Management - managing customer details and accounts in an organized manner. * API Integration - this is necessary for booking from an external website, the API should provide real-time booking updates and show availability and rates. * website must be RTL. * with Code Source If you have pr...

I'm looking for developers to stand-up our events and services platform. The application has already been thoroughly designed in Figma, with extensive prototyping and process write-ups. Besides some edge-case frames, the UI/UX is completed. We...UI/UX. We are not creating a new or ground-breaking technology, we are simply consolidating and simplifying existing mechanisms to create a unique and efficient solution. Integrations and API's: - Stripe - Contacts, Calendar, and Location data - SMS/Email/Push notifications required - AWS Hosting (anti-spam, and security features included via AWS) Expected programming experience: - Python - SQL - Mobile application development - AWS certified would be a plus, but we can out-source the hosting management if needed. If intereste...

I am looking for a Backend Developer with established skills in Node.js, who also had experience in handling both SQL and NoSQL databases. The primary purpose of the project is to fetch Indian market IPO allotment status. What i want is a system where i send users PAN number and it fetches me the data whether IPO is alloted to user or not. I want something similar to narada app Key Responsibilities: - API Integration: Besides strong Node.js skills, experience with API integration is crucial. As most of the data will be served from external sources, fluency in API handling is crucial. - Database Management: The developer should be able to comfortably work with both SQL and NoSQL databases, managing and optimizing data flow as necessary. Ideal candidates will possess a go...

I require a proficient data entry expert focused on database entry and handling. Key Tasks Include: - Handling data input into the database Ideal Skills: - Proficiency in handling large amounts of data - Skill in using various database systems - Attention to detail and high accuracy - Experience with SQL, NoSQL, or cloud-based databases is highly desirable, but not required. Please apply if you can consistently deliver high-quality work on schedule, and you're open to long-term work updates.

...page featuring a *robust search bar:* displaying submitted user details as a table below the search query. - **Database Implementation:** - Efficiently store registration data and allow for easy retrieval during search. - **Skills and Experience Ideal for This Job:** - Proficiency in HTML, CSS, and JavaScript - Backend programming knowledge (PHP, Python, Ruby, etc.) - Database handling (SQL, MongoDB, etc.) - UI/UX design experience - Previous work on similar registration and search functionalities In your application, highlight your experience with examples of past projects that involved form handling and database integration. I value precision and attention to detail, so your ability to demonstrate past success is crucial. Let's create an intuitive and respon...

...business requirements documentation (BRD). Familiarity with data quality issues and Exact, Transform, Load (ETL) processes Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI). Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis. Knowledge and understanding of the applicable tools and practices used in data governance including query and data profiling techniques Proven skills in data analysis – including queries to calculate data quality. Solid written, verbal, and analytical skills Strong research and problem determination and solution skills...

I need a reliable freelancer to extract specific user data from website's database that will enable me to contact users for prom...website's database that will enable me to contact users for promotional activities. Requirements: - Retrieve user names, phone numbers, and email addresses from the database. - Ensure data accuracy and integrity. Purpose: - My goal is to use this user data for promoting our latest offers and services. Ideal Skills: - Experienced in database management and data extraction. - Proficient with SQL queries and data mining. - Understanding of data privacy and protection laws. - Excellent attention to detail. Please provide examples of similar projects you've worked on and explain how you will ensure the security of the extracted data. Look...

I am seeking a skilled freelancer to create a captivating 3D odometer effect animation for my project. Here's what I'm envisioning: - Develop a realistic 3D odometer effect. - Ensure the animation is suitable for promotional purposes. Ideal Skills: - Proficiency in 3D animation Using Html, CSS, JS, SQL - Experience in creating animations for marketing and promotion - Ability to animate realistic mechanics and movements - Strong portfolio showcasing 3D animation expertise The final product should be of high quality and delivered in a format that can be easily integrated into various promotional materials. I'm excited to work with a talented animator who can bring this 3D odometer effect to life.

I have created a Wordpress site and I need you to upload and run my backup file with .sql to ftp. But the content that is on the site needs to stay and just add this extra backup folder to it and make it display just fine.

Project: We are developing a financial product including Europe's largest debt exchange and financial forecasting. Main job: - extending and updating the data set while meeting product targets - creating d...targets - creating data flow diagrams Skills we are looking for: - Data Science, Big Data, Statistics, Business Analysis - Quantitative and qualitative research - Cartography&MapApps, Spatial data analytics. - Programming (Excel macro, Delphi, SPSS, Python (Jupiter Notebook)) - Statistical analysis - SPSS, Python, Excel. - Business analysis - Forecasts, ML, DSS, SEM. - Databases development (SQL, MySql, Access, VBA). - Data flows schemes Nice to have: - work with financial products nice to have - work with registry data nice to have - social and...

I'm looking for an experienced Azure professional with expertise in handling SQL Server Database. The main task includes creating a convenient setup on Azure and migrating both text and numeric data from Excel or table into the newly established SQL Server Database. There's no need for pre-processing the data, it can be directly loaded into the database. High familiarity with Power BI for Azure setup is also crucial for this job. Proficiency in data migration and database administration would be ideal for this project.

I'm seeking an experienced MS SQL database administrator to help with important tasks related to database backup and recovery, with a focus on performance tuning. Key Responsibilities: - Performance tuning to achieve significant improvements. - Administer routine monthly database backup and recovery. Required skills and experience: - In-depth understanding of database structure principles - Experience in MS SQL - Previous experience with database backup, recovery, and performance tuning - Solid understanding of SQL server troubleshooting and problem-solving.

I need a MS Access database designed and developed with for a simple task. The backend will be SQL. Here is a brief of the requirements - 1. Query data from the source SQL DB using the search parameter. The SQL query is ready. The parameter value needs to be displayed prominently in all further screens until saved and closed. 2. Show all available line items in the UI and user can select the ones needed for processing. 3. All the selected items will be shown in the next screen for entering data in a few fields. (This can be a table view for easy processing). 4. The selected and edited items need to be saved in a separate SQL DB. 5. Option to search and edit the saved records is needed. 6. User login is also needed. Possibly with the UserID/PW or auto authentic...

I'm searching for a seasoned expert in Microsoft SQL databases to create a perfect backup of my current database. This is not a data migration project nor will it require any data cleansing or de-identification. The key tasks include: - Copying the entire database with its existing structure intact - Ensuring that the newly created backup of the database is a perfect replica The ideal freelancer for this job would be proficient in handling large Microsoft SQL databases and have a proven track record of creating seamless database backups. Your experience and ability to create a flawless backup without any distortions to the structure or loss of data will be crucial for this task.

I am looking for a software developer proficient in Python, JavaScript, and Java. The primary task for the project will be to create a software that can convert HTML output into downloadable Word files. At the backend we use My SQL. Key Responsibilities: - Design and develop a program that accurately transfers text content, images, and tables from HTML to Word documents - Ensure there is no loss of information or image quality during the conversion - Optimize the process for maximum efficiency Ideal Candidate: - Proficient in Python, JavaScript, and Java - Experience with HTML, Word file generation, and conversion tools - Strong understanding and experience of software development and coding - Capacity to meet the deadlines If you believe you are a perfect fit for this task, kin...

...highly skilled developer with a deep understanding of Bitcoin Ordinals Protocol and a mastery of SQL. The project requires: - Creation of 2 SQL tables (1 for deploys and 1 for mints.) - Each row will extract filtered data relevant to the protocol (eg: "p":"x", "op":"mint", etc) for specific parameters (columns), starting from a specific block #. - Cronjob to add new rows every 10 minutes (new Bitcoin blocks to update tables data - new deploys, new mints or inscriptions ownership change/address owner) - UI with a user address search query, that will reflect the information of the 2 tables related to that address (mints and deploys relevant to the user address.) For the index, you can either use the SQL suggested method above...

I am in need of a skilled developer who can create a React MVC ASP.NET Core application with SQL Server and Entity Framework. The primary purpose of this application will be to import and process cashflow information. Preferred Technology Stack: - React - ASP.NET Core - SQL Server - Entity Framework Specific Features and Functionalities: - Advanced analytics and reporting for cashflow information processing Expected Timeline: - The project is expected to be completed within 4-8 weeks. Skills and Experience Required: - Proficiency in React - Strong knowledge of ASP.NET Core and Entity Framework - Experience working with SQL Server - Familiarity with cashflow information processing and advanced analytics

I have created a Wordpress site and I need you to upload and run my backup file with .sql to ftp. But the content that is on the site needs to stay and just add this extra backup folder to it and make it display just fine.

Project Description: Solve Website Database Connection Error The following errors occurred: SQLSTATE[HY000] [1045] Access denied for user 'root'@'' (using password: NO) (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from where table_schema = 'botble_cms' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)

Fix problem with /tmp in whm "“MySQL” database “mysql”: 1021 (Disk full (/tmp/#);"

He visto que una carpeta esta dañada y hay que renombrarla.

I'm seeking skilled developers for creation of an interactive, blog-oriented website. The main objective is fostering a community of engaged rea...approved/denied by admin) * Admin Account Management – to moderate content and maintain the blog’s integrity. * Interaction Forum – to foster a community of knowledgeable and engaged readers. *Database to retrieve the blogs from and store account information Competence in website development and a keen eye for user-friendly design is necessary. A strong understanding of blog management systems, SQL, Laravel or other relevant programming languages would be of great benefit. Previous experience in constructing dynamic blog platforms would be highly regarded. Please provide examples of previous work that highlights ...

Preciso de um desenvolvedor para criar um pdv para um erp já existem. Para trabalhar neste projeto você precisa ter familiaridade com essa stack: - Asp.net mvc .NET Framework 4.8 - C# - SQL Server - Entity Framework Adicionalmente você precisa ser capaz de trabalhar dentro de uma VM que será disponibilizada por mim, você vai precisa de uma internet boa e estável para consegui trabalhar. Vou deixar a VM configurada com o projeto pronto para você iniciar o trabalho imediatamente sem se preocupar com o setup do projeto. Aqui segue a referência de PDV que vamos seguir: Abaixo segue o escopo do trabalho com base a referência acima: 1. Lista de vendas realizadas via PDV com: a. Opções de filtro (por data, cliente...

For my ongoing SQL projects, I require assistance on a monthly basis. Primarily, the role entails focusing on aspects of database administration. Key tasks that need attention include: - Overseeing optimal backup and recovery processes - Ensuring ongoing performance monitoring - Maintaining the security management of the database The ideal freelancer for this role should have substantial experience in SQL database administration, with a particular emphasis on the areas specified above. Demonstrable skills in managing database security, monitoring database performance and conducting effective database recovery are essential.

I need to create an automated system that efficiently processes Sales Order data. This system should be capable of retrieving PDF files fr...minor variations in layout or design. 3. Data Structuring and Transformation: Transform the extracted data into a structured format that aligns with our MySQL database schema. This process should include data validation to ensure accuracy and integrity. 4. Database Management: Develop the functionality to connect to a MySQL database and insert the structured data. This includes writing efficient SQL queries and handling potential database errors or exceptions. 5. Logging and Error Handling: Implement comprehensive logging for tracking the system's performance and error handling mechanisms to manage and resolve issues proactively. Deliv...

...and experience required: - Expertise in Ruby on Rails, specifically Rails 6 and 7 - Experience maintaining and upgrading RESTful APIs and API integrations - Proficiency in RSpec for testing - Strong SQL skills for database maintenance Responsibilities: - Perform regular maintenance and updates on the Ruby on Rails project as needed - Address any bugs or issues that arise - Upgrade and improve existing features and functionalities Ideal candidate: - Has experience working with Rails 6 and 7 - Familiarity with RESTful APIs and API integrations - Proficient in RSpec for testing - Strong SQL skills for database maintenance - Detail-oriented and able to troubleshoot and debug effectively This is an ongoing project with maintenance and updates required on an as-needed b...

As someone seeking assistance with my Oracle SQL project, my need is precise and task-oriented. I'm grappling with some update operations on tables and would benefit from expert guidance. - Task: The primary help that I need is updating a table. It's not just about changing existing data, but the process is conditional. The condition is slightly more complex than just concerning one column value. It revolves around multiple column values. - Expertise: A suitable candidate would ideally have experience in managing data migration, query optimization, and database design. The task involves sophisticated data handling, so someone with substantial Oracle SQL experience will be an asset. Proficiency in understanding and writing conditional SQL queries is essen...

I'm looking for an experienced Azure Data Engineer who can assist in continuously syncing data from an On-premises SQL Server to Azure SQL Database. The specifics of the data that need to be synced are Tables, Stored Procedures, and Views. Ideally, the freelancer should possess the following: - Proficient in Azure SQL VM operations. - Experience with data migration from on-premises SQL Server to Azure SQL Database. - Understanding of syncing Tables, Stored Procedures, and Views. - Capable of setting up an hourly sync schedule. The end goal is to keep the Azure SQL Database updated hourly to reflect the changes made in the on-premises SQL Server. Ensure seamless, error-free data transfer and verify the integrity of synced data regula...

Project Title: Snowflake, DBT, Dataiku project Support - Urgent I am in need of a data engineer freelancer who can provide urgent support for the project. The ideal candidate should have ex...source and target as snowflake warehouse. - Integration of Dataiku with existing systems and databases. - Experience with data ingestion. - create jobs in octopus, tidal Skills and Experience: - Proven experience in implementing Snowflake, DBT and Dataiku - Strong knowledge of Dataiku features and functionalities - Familiarity with data integration and data management best practices - Proficiency in SQL, Python, and other relevant programming languages - Excellent problem-solving skills and ability to troubleshoot issues Timeline: - This project requires urgent support and requires few month...

...discussed. Features: - Live Bidding functionality is the most important feature that needs to be included on the website. Ideal Skills and Experience: - Experience in working with APIs, specifically the Copart and Iaai APIs, is required. - Strong web development skills and the ability to create a user-friendly and intuitive interface. - Knowledge of user registration/login functionality using SQL or local MongoDB and search/filter options. -User to submit ID for verification. - User most make a minimum Deposit of $400 to get bidding power of $4000 or more to enabling placing bet either proxy bet or live auctions -User place bet on our site and it goes directly to Copart or Iaai through our premium account. -User can see the final price calculator to see services fees a...

I am looking for an experienced Power BI consultant who is well-versed with the ETL process, Synapse, Fabric, DWH, and more. - Data source: As a part of the project, you will be needed to work on the local SQL database, which acts as my current data source. Familiarity with SQL databases is a must. - Data extraction and transformation: The project requires the extraction and transformation of data In conclusion, candidates with a strong understanding of SQL databases, data extraction/ transformation processes, azure, microsoft service awill be the best fit for this role.

Add Logic to C# Wpf Software. - Controllers : Add Json Support (Add / Update / Remove) - Projects List: Add Button to create Dummy Project - Projects List: On Select Row or click "View Button", loads all listings connected to this project - Projects List: On "Delete Button", it will delete the project, all the listings and folders connected to it. - Listing List: Change "Creat...Select Row or click "View Button" loads all the folders connected to the listing - Listing List: On click "Delete Button", deletes this listing and all folders connected to it. - Folders List: Add create button to open "Screen_2" - Screen_2: On close it will save the real data of all fields - Folders Lsiting: On click "Delete Button" removes folders ...

Python Development - Building a Web Application with Django Skills and Experience Required: - Expertise in Django framework - Strong proficiency in Python programming - Experience working with existing Python code - Familiarity with web application development and best practices - Knowledge of front-end technologies such as HTML, CSS, and JavaScript - Understanding of database systems and SQL - Ability to collaborate with a team and communicate effectively Project Scope: - The goal of this project is to build a web application using Django framework. - The project involves working with existing Python code to enhance and add new features to the application. - The ideal candidate should have experience in developing scalable and secure web applications. - Knowledge of front-end dev...

I am looking for someone to create a POC for a chatbot with Microsoft Bot Framework and C# Main objective. 1. It should connect to a SQL server database and get the order details if the customer asks "Get my order detail" and give the order number 2. Login the customer and identity the correct order, Don't pull anyone else order if not belongs to the customer The POC may extend to an actual project

...functioning on existing projects that are built on these technologies, hence having prior hands-on experience would be highly valuable. Regarding the database, you'll need to be skilled in the use of SQL Server since the projects involve maintaining databases that are based on this platform. On the functionality front, the critical aspect is development. Therefore, you will play a prominent role in strategizing, building and maintaining the overall structure of the projects. Skills and Experience Required: - Practical experience in ASP.net Core, ASP.net MVC, and ASP.net WebForms - Profound knowledge in SQL Server database management - Demonstrated experience in end-to-end project development and management. To conclude, if you are well-equipped with these ski...

We are looking for assistance completing a query comparing in stock and on order raw material and match to it's production demand. SQL 2019

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

I'm looking for a freelancer with extensive Node.JS experience to convert a Java-based des...experience to convert a Java-based desktop application into a web app. Key functionalities of the current app include data entry and storage, file management, and reporting/analytics. - Features to Maintain: The web app must retain database integration functionality, besides that the freelancer will also be required for code review and modification. - Database: Our current desktop application uses SQL Lite. The freelancer must have experience working with this database for a seamless transition. This project requires thorough knowledge of Java and Node.JS, database management, and file handling in a web app environment. Additionally, proficiency in executing code review and refactor...

Web development: The system should be web-based (ASP.Net) with SQL database, allowing users to access and interact with it through a web browser with responsive design. The application should be working perfectly in mobiles (both small and big screens), tablets, all sizes laptops and TVs from 32 inch to 84 inch screens. - Photo uploads: Users should be able to upload photos to the system, which will be displayed alongside their family information. Uploading is available for all but will not be effected until final approval - Relationship mapping: The system should have the capability to map and display relationships between family members. - Advance search options using all fields. - Send messages / WhatsApp / emails - Member card : when clicking on member image on the tree, a car...

I'm in need of a C program that will diligently navigate through a folder and all its subfolders to identify and extract given search text from files. The core specifics of the project are as follows: - File Type: The software should be capable to run its search and extract function exclusively on text files formats ( .txt , .sql,.xml ... ) . No need for other formats like Word, PDF etc. - Case Sensitivity: The application must consider "No" case sensitivity while executing text searches. For instance, "Hello" and "hello" should be treated as same. - Output: I am interested in seeing the exact instances of the found text & summary. The output needs to directly display the exact instances where the search text is found. Ideal freelancers for t...

The application is developed using Visual Studio with Blazor (C#) and utilizes a SQL Server database. The server infrastructure is already set up on AWS. Now, I am looking for an experienced professional to host my application on the AWS server and take care of all the necessary configurations. This includes setting up IIS, publishing the application, configuring the domain with SSL, and handling other related tasks.