Database design in sql servercông việc

As th...customer data should be directly integrated via APIs. It's crucial that you have the expertise to handle this kind of integration and verify data integrity effectively. - **SQL Databases Interaction:** As the SaaS product's backbone, it's essential for it to interact successfully with SQL databases. You'll be tasked with setting this up to ensure smooth ongoing operations. Ideal skills: - Proven experience with NestJs and full stack development - Strong background in API integration - Solid knowledge of SQL databases - Proficiency in creating SaaS applications I'm looking for someone ready to leverage these skills in order to bring this project to fruition. If you're passionate about creating efficient SaaS...

We're in need of a web developer who can handle both front and back-end development for a college website. The ideal candidate would be proficient in HTML, CSS, JavaScript, React, PHP, SQL, and have experience in integrating APIs. The main goal of this project is to construct an engaging and interactive site offering relevant information about the college. While the client has skipped providing specific design or functionality requirements, we expect the site to be consistent with current best practices, intuitive, and user-friendly in its design. Responsibilities include, but are not limited to: - Creating an attractive front-end that aligns with the college’s brand - Building a robust back-end management system - Handling an...

I'm looking for a meticulous professional to transcribe data and enter it into a database format. Key tasks include: - Transcribing data accurately - Entering transcribed data into a database - Conducting a double check for errors to guarantee the data's accuracy The best candidate for this project would have impeccable attention to detail and competence in data transcription and database management. Prior experience in a similar role is an added advantage.

**Fan Club App Documentation** **1. Introduction:** The Fan Club app is a revolutionary platform designed to cater to the needs of both recruiters and fans worldwide. It offers a professional presentation of players and teams involved in various leagues, providing comprehensive statistics, market values, and an engaging user experience. This documentation serves as a comprehensive guide for developers to understand the business logic, functionalities, and technical specifications of the Fan Club app. **2. Business Logic:** **2.1 Purpose:** The primary goal of the Fan Club app is to serve as a recruiter-friendly platform where users can easily access detailed information about players and teams, including statistics, achievements, and market values. Additionally, the app aims to i...

I'm in need of a freelancer that specifically deals with data entry on a professional level. I have text data that needs to be accurately input into a database. The ideal freelancer for this job: - Easily works with Word Documents. - Has a background in Data Entry, particularly into databases. - Is detail-oriented with excellent accuracy in copying text data. Responsibilities include: - Transferring material from Word Documents to my database. - Ensuring the integrity and accuracy of the data entered. Please, only apply if you have a proven track record in these tasks, and able to provide examples of similar work. I stress, accuracy is most important in this task. Looking forward to your proposals.

I'm in urgent need of a MySQL database providing extensive Vehicle and Spare Parts data, derived from the TecDoc 2024 model. The database needs to: - Incorporate thorough manufacturer information. - Contain detailed part descriptions. - Include high-quality part images. To undertake this project, you must have solid experience in MySQL database creation and manipulation. Familiarity with TecDoc systems and automotive parts is a significant plus. The task requires immediate attention and prompt delivery.

I need an experienced C# developer to update a Windows service to improve email functionality. The task includes: - Updating the existing program to send an email with an attached PDF - Integrating SQL database queries to generate this PDF - Designing a process that converts the results from the SQL database stored procedure into PDF format before emailing The ideal candidate will have strong understanding and experience in C#, .NET framework, Windows services, SQL database management and converting SQL queries to PDF. Knowledge of email systems and attachments will be a significant advantage. While this project focuses on a specific update, there may be potential for continuing collaboration depending on the successful completio...

As an expanding business, I need a WordPress backend specialist to assist with Database management duties, specifically, migrating a medium-sized (1-5 GB) database to a new WordPress installation. The database does not contain sensitive information. The successful freelancer will have demonstrated experience in: - WordPress backend development; - Database management, - WordPress Database migration. Expertise in database management and WordPress backend operations is preferable. Your job will be to ensure a seamless migration with minimal downtime. Being detail-oriented and having good problem-solving skills will be beneficial for this task.

I'm in need of a skilled developer with experience constructing ETL pipelines that extract data from CSV files. Main project tasks: - Extract data from CSV file source - Perform necessary transformations including data cleaning and data enrichment. Required experience and skills: - Proven track record in developing ETL pipelines - Proficiency in handling and processing CSV files - Expertise in performing data cleaning and data enrichment actions. This task requires fine attention to detail and a pragmatic approach to data management. I'm expecting an efficient and error-free pipeline construction. Your responsibility will be to ensure high-quality, cleaned, and enriched data output from the provided CSV files.

...dedicated to delivering exceptional value to our investors. We’ve bought and sold tens of millions of dollars in real estate by leveraging a data-driven approach to identify and capitalize on real estate opportunities. Price is Right Properties believes great people are at the center of every successful business and we’re looking for perfect fit talent. Mission: Make it as easy and enjoyable as possible for someone to sell their raw land. Values: 1. Competitive Greatness - We love to work and we are obsessed with being the best we can be. 2. Sincere Candor - Tell the Truth. State the facts. 3. Unquestionable Integrity Role Overview: The Business Intelligence Analyst will play a critical role in synthesizing data from diverse sources including QuickBooks, Ai...

I'm seeking a cloud professional who can efficiently link an Azure Function App to an Azure SQL DB. This integration will enable the Azure Function to be called directly from an Azure SQL Function and the response returned to the Azure SQL Function too. Specific skills and experience needed: - Proficiency in managing Azure Function Apps - Strong knowledge of Azure SQL DBs - Experience in setting up and managing cloud interactions - Familiarity or background in handling transactional records To note: - The Azure Function App needs to be callable from Azure SQL Functions Your proposal should outline your past experience with similar setups and your approach to the task.

Job Title: Freelance Proxy Server Specialist Project Description: We are seeking a skilled Freelance Proxy Server Specialist to assist us with the creation of a proxy pool consisting of 255 proxies. The ideal candidate will be responsible for setting up and configuring a pool of proxies on our AWS EC2 instance. This project requires expertise in proxy server configuration, networking, and AWS services. Responsibilities: Set up and configure a pool of 255 proxies on our AWS EC2 instance. Ensure the proxies are secure, reliable, and perform well. Implement rotation and load balancing mechanisms to distribute traffic evenly across the proxy pool. Provide documentation and instructions for managing and maintaining the proxy pool. Collaborate with our team to ens...

I am in need of an experienced PL/SQL developer who is efficient in Oracle database management system. The scope of the job would include: - Creating stored procedures: Structuring new procedures for data manipulation, validation, and reporting. - Writing triggers: Implement a triggering system for efficient database management. - Optimizing SQL queries: Ensuring that SQL queries are optimized for best performance. The PL/SQL code will be used for data manipulation, data validation, and reporting & analysis. Experience in Oracle database is a must for this role, along with a strong understanding of PL/SQL development to ensure the efficiency and accuracy of the database management system.

I'm in urgent need of an Apache Server professional who can proficiently troubleshoot and debug to unearth the root cause of server crashes and slow load times on my system. Critical areas of attention are: - Understanding and interpreting error messages displayed during crashes. - Restoring the functionality of an unresponsive website. Skills and Experience: - Expertise in Apache Server troubleshooting and debugging. - Experience in managing server crashes and optimizing load times. - Ability to interpret error messages and restore unresponsive websites. - Knowledge of Microsoft Azure where the server is hosted - Knowledge of Opencart version 2.3.0.2 which is the version of the e-Commerce platform hosted on the server....

I am seeking a proficient freelancer who is experienced in SQL Server to assist with writing a query. Single table. Need to return all rows that fulfill certain specific condition. Also, need help with the 'return type' for passing the query data retrieved. Language I am working on is c#. Amount: $10

Extract text from PDF/Images with Optical Character Recognition(OCR) OCR technology helps scan a document, regardless of whether it is made of text or images, for signs of text. It uses pattern recognition algorithms to recognize whether any part of a document might be an alphabet, number, or character

I am a seasoned SQL professional, demonstrating mastery in Structured Query Language and database management systems. Proficient in crafting intricate queries, I am expert in optimizing data retrieval and expertise spans database schema design, normalization, and indexing, ensuring data integrity and system performance. With a keen eye for detail, he adeptly manages stored procedures, triggers, and views, contributing to the creation of robust and scalable database solutions tailored to diverse business requirements.

I'm in search of an adept developer or team to create a bespoke data visualization tool for my business, inspired by Power BI's capabilities but with a focus on specific chart types. This tool is essential for making informed decisions quickly and visually. **Key Requirements:** - Create vertical and horizontal bar graphs, linear charts, and pie charts with great accuracy and visual appeal. - The tool should be able to connect to both SQL and NoSQL databases, as well as RESTful and GraphQL APIs for data sourcing. - It must feature data filtering and sorting to manage large datasets efficiently. - Drill-down capabilities are needed to dissect complex datasets into more understandable parts. - Real-time data updates are crucial for the dynamic nature of our business ...

Looking for a Fullstack Developer who is experienced in building complex web projects and has experience in JavaScript, CSS3, HTML5,MVC, MSSQL, C#,ASP.NET, Stored procedures, Bootstrap, GITHUB, Payment Gateways, API development etc As a Full Stack Developer, you should be comfortable around both front-end and back-end coding languages, development frameworks and third-party libraries and should be able to Modify and test changes to previously developed programs. Possess excellent knowledge of UI/UX and basic prototype design. Develop and manage well-functioning databases and applications. Should be able to host and manage web project on Azure / Azure Storage / Azure Security / Azure SQL db etc or similar in AWS Overseeing the automated testing and providi...

I'm looking for a seasoned PowerBI specialist who can integrate a range of data sources into two neat, insightful dashboards and reports. Here's what I need: - Integration: there are two unrelated datasets, both in .csv file format, the larger dataset is already loaded into PowerBI and few relationships and basic graphs were already created - you would continue on where I ended. Second data set will have to be loaded into PowerBI as well but it is independent from first one and contain small amount of data. - Visualization: I don't have any specific requirements regarding visualizations or charts but I will provide examples and details about what I want to visualize. I expect you to have the expertise to determine and create the most meaningful data presentations for...

...documents to assist in the creation and update of a database. This project requires meticulous attention to detail and a strong commitment to accuracy to ensure all data sourced aligns perfectly with our database's existing structure and future requirements. **Ideal Skills and Experience:** - Proficiency in data entry with a keen eye for details. - Experience with online data entry projects, specifically handling scanned documents. - Familiarity with database software or platforms. - Strong organizational skills to ensure data is entered in a structured, error-free manner. - Ability to work efficiently under tight deadlines. **Project Requirements:** - Convert scanned documents into digital format. - Enter data accurately into the designated ...

...and minimalistic design: Direct navigations, easy-to-read fonts, and a clean layout are essential. • Responsive: Users might access the website from different devices. Therefore, the design must be responsive and compatible with all screen sizes. Ideal skills for this project: • Expertise in web development and designing, ensuring a good user experience and a pleasing aesthetic. • Exceptional command over HTML, CSS, JavaScript, and other related tech stacks. • Database/SQL • Prior experience in crafting similar projects, specifically related to user profiling. • Understanding of user interface design and user-friendly navigation patterns. • Familiarity with the latest web trends to provide a modern a...

...and Experience, Simple and easy project for an experienced person** - Proficiency in WordPress plugin development. - Experience with Website document info gather to secure integrations. - Strong knowledge of PHP, JavaScript, and SQL for custom PDF creation. - Familiarity with WordPress form builder tools and PDF generation libraries. - Ability to work with PDF documents and detailed specifications. This plugin is envisioned to not just enhance the functionality of the website but also offer a unique way for users to interact with the content. It needs to be both robust and user-friendly, ensuring a seamless experience for site visitors while capturing essential information for our database. Having expertise in creating similar plugins or working with form-t...

Seeking a skilled help install the Java Apache Mail Enterprise Server (James) on the IBM Cloud platform. Ideal candidate skills and experience: - Proficient in IBM Cloud - Familiar with Apache James (mass email services) - Familiar with Google's new spam email guidelines - System security Key responsibilities include: - Manage user access privileges - Manage server resources Initial project bid: - Assist with giving you and another developer access privileges to IBM Cloud system Previous experience in similar projects is required. I look forward to seeing your proposals.

...support for their computer and communications systems Ensure data privacy and security measures are in place and compliant with regulations Oversee and execute data imports and exports from critical systems Manage IT department’s budget and provide regular reporting on spend to upper management Implement and manage customer feedback from online customer reviews (Google, Yelp, BBB) Required Skills / Knowledge / Abilities Either: Minimum 2 years' experience with Odoo ERP managing support to backend/frontend troubleshooting Deep Experience with any specific Odoo modules including Sales, CRM, Inventory, Purchase, Website, and Accounting a plus Minimum 3 years’ ERP experience in all supply chain and finance areas Proven experience operat...

Make a proxy manager server for http / https Where we develope a backconnect proxy that connect with other proxy and forward client request through the proxy pool listed in our proxy manager.

...SQLite database. My aim is to establish robust database interactions primarily focusing on performing operations through raw SQL queries. Despite the hiccup, my goal is clear: to create a seamless user experience by ensuring stable database interaction within my app. To streamline the resolution process, I'm on the lookout for a freelancer with a deep understanding of: - React Native and Expo framework intricacies - SQLite integration and manipulation using raw SQL queries within a React Native environment - Debugging and resolving TypeError issues specifically related to database transactions - Experience with database schema design and optimization for mobile applications Ideal Skills and Experience: - Proficiency in...

I have a task to create a simple desktop application from biological databases based on a database that I have initially created, I have no idea at what level the database is made. I would need help with this project quickly because. the database is in SQL and the application does not matter, the most desirable one is in access, java In general, the project is not supposed to be complicated, it is supposed to be a desktop application in which it will be possible to search for information from a database. I just started the topic of astronomical observations, but I had a problem with the relationships between tables in this topic, so later I started a different topic, but it is In general, it doesn't matter w...

...configuration of Linux servers. My primary challenge has been dealing with server performance issues that need immediate troubleshooting. This responsibility is not all-encompassing, but primarily surrounds these key areas: - Linux Server Setup: Your role will involve setting up and configuring Linux servers based on best practices and my specific requirements. Prior experience and success in such setup are highly essential. - Performance Troubleshooting: Your technical expertise will be called upon in identifying and resolving performance-related server issues. A strong troubleshooting background in Linux server management is a necessity. The ideal freelancer for the job would be someone with a robust background in Linux ...

I require the assistance of a skilled professional who is adept at: - Excel - Google Sheets - VBA - SQL - R The main goal of this project is data analysis. The freelancer needs to be well-versed in these programs and must be capable of using them to their full potentials. The tasks include, but aren't limited to, data extraction, data manipulation, and interpretation of result.

...configuration of Linux servers. My primary challenge has been dealing with server performance issues that need immediate troubleshooting. This responsibility is not all-encompassing, but primarily surrounds these key areas: - Linux Server Setup: Your role will involve setting up and configuring Linux servers based on best practices and my specific requirements. Prior experience and success in such setup are highly essential. - Performance Troubleshooting: Your technical expertise will be called upon in identifying and resolving performance-related server issues. A strong troubleshooting background in Linux server management is a necessity. The ideal freelancer for the job would be someone with a robust background in Linux ...

...looking for a proficient developer with a strong background in Yii2 and React.js to bring my project to life. The core of this project involves fetching selective columns from more than seven different tables and displaying these records, which include text and various types of files, on a React-based frontend. The backend is in Yii2. **Key Requirements:** - **Expertise in Yii2:** Must be capable of efficient backend development, specifically with experience in working with multiple tables and extracting specific columns. - **React.js Proficiency:** Should have a strong grip on React.js to create a dynamic and responsive frontend display for the data fetched from the backend. - **Database Skills:** Deep understanding of database management, wi...

Task Description: We are seeking an experienced Notion expert to assist in creating a customized project management solution within Notion for our agency. The primary objective is to develop a centralized Notion database or a set of interconnected databases that can host tasks and projects for our various clients. Each client should be able to access the system but only view and interact with tasks specifically assigned to them, ensuring a high level of privacy and focus. Key Requirements: Proficient in setting up and managing databases within Notion, with a strong understanding of advanced features like linked databases, filters, and access permissions. Demonstrated experience in configuring Notion environments to provide user-specific views or content, ensu...

Seeking Excel proficient in SQL, R, Excel VBA, and Google Spreadsheets for data analysis, complex formula building, and reporting on a large dataset. If skilled in SQL, R, Excel VBA, and Google Spreadsheets with experience in handling large datasets, eager to see your solutions for complex problems at scale!

As a project owner, I'm looking for an experienced PHP developer to create a server-to-server script update system. SKILLS AND QUALIFICATIONS: - Proficient in PHP - Strong understanding of CURL or equivalent system - Past experience building server-to-server communication scripts TASKS: * Implement a script update system using PHP and CURL or a similar system as proposed by the freelancer. * Ensure a high level of security is incorporated into the system. Knowledge of cybersecurity best practices is advantageous. The system must actually synchronize two scripts which have an identical base. For example, a so-called “master” script is in version 4.3 and the other in version 3.9. On version 3.9, you must be able to indicate...

I am looking for an expert in data scraping or collection, who can efficiently generate a database of international student contact information across US colleges and universities. This is not limited to just undergraduates but also those on a graduate level. The purpose of gathering this data is for marketing outreach. The database should include the following details: - Name of international student - Country of origin - School name where they are attending - Major or field of study Contact information required: - Email addresses - Phone numbers - Social media profiles Ideal candidates for this project would have experience in both data collection and understanding of privacy laws to ensure the information is collected legally. A knowledge in educa...

I'm in need of a skilled programmer proficient in Google BigQuery, specifically its Standard SQL version. Recently, I encountered an error while working with a partitioned table, stating: "The query cannot be executed because the table involuted-alpha-377603:cargoaim_main_db.agent_basic requires partition filter and contains unapplied upsert data that is stale based on the max_staleness setting." Here's what I'm aiming for: - *Resolve the current error*: To continue our operations without disruptions. - *Enable new data analysis capabilities*: After fixing the error, I want to explore and utilize more advanced data analysis features that BigQuery offers.

I am in need of a proficient server administrator, specifically with experience in managing Ubuntu mail servers. The core task is to update the SSL certificate, ensuring continuous secure email communication without downtime or security risks.

looking for a linux dev to make some scripts, example at a set time every day i want my custom commands ran to shut down the server at a set time, i then after restart at set time, i want two commands ran to start the server up, I seen someone to spend 10 or 15 mins with me, to show them, if the do sevrer one well i have other servers needing this scripts so i dont have to do it manually every day, on windows they call it a bat files, im not sure what it called with linux, thanks

We are looking to add a Senior Digital Analytics Consultant to our team! The work location is in Atlanta, GA and we are looking for candidates who are local to Atlanta or someone who can relocate. Skill Set: • Strong Digital Analytics / Marketing Analytics skills. • Expert level experience in Adobe Analytics is mandatory. • Strong Ecommerce/Travel and Digital Marketing background. • Experience with Analytics Reporting and Deeper Dive Analysis. • B2C direct channel Measurement and Optimization. • Ecommerce product development experience a plus. • Advanced Analytics Skills (SQL / Python) a nice to have. • Experience with Adobe Target a plus. • Experience working with senior management teams. • Experience developing and g...

I'm in need of a professional to set up multiple Dockers on an Ubuntu Server. We have a dedicated server (hardware) that is installed with Ubuntu server. We want to create and configure some Dockers using official repos as below. We also need some IPs whitelisted to be able to access Ubuntu/ Dockers. 1) Jasmin SMS () 2) RabbitMQ 3) Redisub 4) MySQL 5) PHP (Laravel). Jasmin needs RabbitMQ and Redis connectivity. PHP Docker needs - HTTP access to Jasmin via domain/ local IP - PHP needs to have a domain configured for public access (it will host a web app) - connectivity to MySQL docker. Other than setup, we also need the process and configurations documented in case we need to make changes later as well for maintenance. Document

Setup a new linux server: NGINX, Angular, node.js Install ssl certificate Deploy angular app as per instructions. To prove you have read the requirements, please explain in your application how you would install a ssl certificate on a linux machine.

I'm in need of a skilled programmer proficient in Google BigQuery, specifically its Standard SQL version. Recently, I encountered an error while working with a partitioned table, stating: "The query cannot be executed because the table involuted-alpha-377603:cargoaim_main_db.agent_basic requires partition filter and contains unapplied upsert data that is stale based on the max_staleness setting." Here's what I'm aiming for: - **Resolve the current error**: To continue our operations without disruptions. - **Enable new data analysis capabilities**: After fixing the error, I want to explore and utilize more advanced data analysis features that BigQuery offers. **Required Skills and Experience**: - Proficiency in Google BigQuery (Standard...

I am seeking a skilled Oracle and SQL database specialist who can efficiently assist me with database management tasks. This will include database design, data modeling, and query optimization. Ideal skills and experience you should bring include: - Expertise in Oracle and SQL database - Knowledge in data modeling and database design - Troubleshooting and performance optimization skills - Proven ability to deliver high-quality work under deadlines The main purpose of the project is to enhance database proficiency that encompasses data storage and management, application development, and optimization of performance. The end goal will be to achieve a streamlined, fully-optimized, user-friendly database...

Looking for a proficient SQL expert to contribute to our ongoing project. The successful freelancer will be experienced in database programming and will exhibit a deep understanding of SQL-based platforms. - Ideal Skills: Extensive SQL knowledge. - Experience: Oracle Database 2 days deadline

...news website and store the data directly into a database. My project requires precise and timely completion, ensuring the integrity and readability of the scraped content. **Requirements:** - Experience with web scraping tools and techniques, especially as applied to news websites. - Proven track record with database management and integration. - Ability to identify and extract relevant article data without including advertisements or unrelated content. - Knowledge of handling dynamic content and pagination within the targeted news website. **Ideal Skills and Experience:** - Proficiency in programming languages commonly used for web scraping, such as Python, particularly with libraries like Beautiful Soup or Scrapy. - Experience with database technologies (...

I'm in need of a database expect with a particular expertise in Oracle. The main purpose of this project involves SQL and oracel. The professional should be ready for a flexible project scope that may require various Oracle-based data analytical techniques. Ideally, the hired specialist will have experience in a range of data analysis strategies. Deadline: 2 days I would like to make it fix price

In need of a detailed-oriented freelancer who can swiftly input textual data into a custom database. This task mainly involves simple typing. Key Responsibilities: - Data entry of textual information - Double-check accuracy of entries - Adhere to timeframe Ideal Skills: - Proficient in typing text - Previous experience with a custom database - Attention to detail - Excellent time management skills Please note that familiarity with data entry and custom databases is vital. Punctuality and accuracy are paramount for this project.

We are looking for a skilled SAP S/4HANA Developer with expertise in creating Core Data Services (CDS) views for analytics consumption in Power BI. The role involves developing and optimizing CDS views to facilitate effective data extraction and visualization, supporting informed decision-making processes. Prior experience with Retail S/4HANA modules is mandatory. 1. Experience with SAP GUI and navigating SAP systems for data 2. Experience with handling Transport Requests 3. Experience in developing Calculation Views 4. SAP certification in relevant domains. 5. Experience handling large datasets and complex data structures. 6. Knowledge of other BI tools and technologies. Key Responsibilities: Design and develop CDS views in SAP S/4HANA for effect...

...professionals to bring my personal mobile app and server vision to life. This project requires a colorful and user-friendly Android application coupled with a robust server backend. The app is aimed at personal use, and I envision a platform that's not only practical but also visually engaging. **Key App Features:** - **User Registration:** A simple, yet attractive registration page where users can input their mobile number, name, and specific bug information to be sent to the server. - **Design:** Need a colorful interface that's both inviting and easy to navigate. I'm looking for creativity to make the app stand out. - **Functionality:** Basic logic for handling the data inputted on the registration page and effective communication with the...