Gym project sqlcông việc
<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...
...looking for a talented and dedicated Full Stack Web Developer to join our project. Your responsibilities will be as follows: • Designing the User Interface: Inject your creativity and expertise to assist in creating 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 simil...
I'm crafting an encompassing fitness resource tailored to individuals eager to transform their lifestyles across all levels – from novices to seasoned gym enthusiasts. The guide will offer actionable strategies to shed pounds, sculpt muscles, and boost stamina through a balanced blend of nutrition, effective exercise plans, and motivational insights to aid users in charting a successful fitness journey. Key Aspects: - Comprehensive nutrition advice for a healthy diet - Diverse workout programs to cater varied fitness levels - Inspirational content to sustain motivation Ideal Candidate Profile: - Expert in fitness and personal training - Experienced in crafting nutrition plans - Proficient in creating adaptable workout routines - Skilled in motivational coaching - Abilit...
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 ...
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 posse...
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.
...web developer to create two critical pages for an upcoming web project. Your expertise should align with front-end development and database integration. Here's what I’m looking for: - **Page Design & Functionality:** - First page with a *registration form:* to gather user's personal details, qualifications, and experience. - Second 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.) - ...
...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 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 Marketing Resear...
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 ta...
...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 metho...
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...
...help maintain and upgrade our project. Skills 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 ...
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 i...
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...
...create a static website that is focused on information sharing, particularly around gym education. The intention behind this site is to provide in-depth, engaging learning resources for all those interested in gym education. The ideal candidate should: - Have robust skills in creating visually appealing and easy-to-navigate static websites. - Demonstrate experience in creating education-based platforms beneficial. - Be creative with how information is presented, bearing in mind the target audience. Content to be included: - Extensive educational materials designed for gym enthusiasts. - Advice on workout routines, nutritional guides, and gym equipment handling. - Regular updates featuring the newest trends in gym education. The audience's un...
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 experience and expertise in working with Snowflake, DBT, Dataiku and be able to solve problems Specific Requirements: - Creating Data products in DBT with 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 r...
...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...- 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 "Create Button" to create dummy data for listing - Listing List: 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 But...
Python Development - Building a Web Application with Django Skills and Experience Required: - E...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 development and database systems is essential for this project. - The candidate should be able to work collaboratively with a team and communicate ...
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
Being on a quest for a versatile and experienced ASP.net develope...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 skills and have a strong aptitude for development,...
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
Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.
I'm looking for a freelancer with extensive Node.JS experience to convert a Java-based desktop application into a web app. Key functionalities of the ...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 r...
...ionic website for a GYM booking app. The primary target audience is fitness enthusiasts. The app should contain key features such as: - User registration and login: Users should be able to register an account and login effortlessly. - Class scheduling: Users should be able to schedule gym classes through an intuitive interface. - Gym Listing: Display all available gyms in an easy-to-navigate layout. - Gym Detail Page: Provide in-depth gym details for users' consideration. - Home Page: The landing page should be engaging, easy to navigate, and provide relevant information at a glance. - App Info Page: This page should offer information about the app, its creators, its mission, and other necessary details. - Gym Payment Page: Users should be...
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...
