Wikipedia sql työt
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.
I am looking for an expert with Power BI who is adept at connecting to SQL server databases. The requirement is to clearly compile the user data from these servers into a simple, singular table that reflects an view of all identified sources. What the job entails: - Connect to multiple SQL Server databases - Aggregate the users data into one simple table, it should entail server name, database name, user, role, and user type. Skills and Experience: - Comprehensive experience with SQL Server databases - Proficient in the use of Power BI - Familiarity in compiling data into user-friendly tables - Strong data aggregation skills - Attention to detail, particularly with columns and user information.
...copilot, users of our application should have the ability to ask general questions (e.g., when was the first moon landing), which will ultimately be answered by chatGPT. On the other hand, application-specific questions that require access to our MSSQL database should also be answered. The database has over a million entries. Therefore, the copilot should be able to convert textual questions into SQL queries, send the query, and present the answer from the database in textual form for the user. An example question for this would be: What is the dataset with the biggest total amount? As a third requirement for the Copilot, it should also be able to answer questions by extracting information from provided text documents. The copilot should be able to understand inputs in German l...
As part of my team, I'm looking to onboard a proficient competitive programmer with expertise in C++ and Java. The selected individual will participate actively in bi-weekly coding rounds, solving problems across a diverse range of topics: - Data Structures and Algorithms - Database related and SQL query problems - Graph theory problems Ideal candidates should have demonstrated experience in these subjects, and a proven track record in coding competitions would be beneficial. Strong command over C++ and Java is mandatory for this role. It's supremely important to have solid problem-solving skills and the ability to work under time constraints. If you can thrive in a competition scenario, I'm eager to bring you on board.
I've uploaded some basic data. It has 2 columns. Column 1 is a Publication Index and column 2 is an authors name. I need a T-SQL query that will create a pivot table that will put the authors names into columns and the PMID's into rows. The xls sheet has the data and the output that I need. I'm posting the question here because I need a faster answer than posting on StackOverFlow. The data will have over 8,000 rows of data and the columns or names will be over 100. My current T-SQL is SELECT TOP (100) PERCENT PMID, AuthoringName FROM dbo.[] GROUP BY PMID, AuthoringName ORDER BY PMID, AuthoringName I'm using MS SQL 2019
...szerkesztésével lehet további egyéni lekérdezésekkel bővíteni a válsztható sablonokat. Ezen lekérdezések megírásához keresünk SQL-ben jártas szakértőt, aki segítene közösen elkészíteni további sablonokat, pl. Teams-es konzultáció keretein belül. Magyar nyelvű kommunikációt preferálunk az egyszerűség és a félreértések elkerülése kedvéért. "You can also modify or add new queries to Data Chart Dashboard components by creating the appropriate SQL Server Script. This can give you more flexibility to control the data th...
Buongiorno, ho necessità di creare un database personalizzato, con interfaccia molto semplice, per raccogliere le ore di produzione del sito industriale in cui lavoro su tablet, molto semplice (i dati da raccogliere sono ad esempio "Ditta, nome lavoratore, commessa, lavorazione, n°ore"). Servono poi una serie di query altrettanto semplici per estrapolare le ore mensili o per commessa. Valutare assieme l'interazione con il nostro software gestionale Business per il caricamento/Estrapolazione di alcuni dati. Per favore, avrei bisogno di interlocutori Italiani per problemi linguistici.
Project Description: I am looking for a freelancer who can help me copy my SQL Database using the Azure SDK. The ideal candidate should have experience with Azure and be proficient in using the Azure SDK. Requirements: - Copy SQL Database using Azure SDK - No data migration across different Azure subscriptions required Skills and Experience: - Proficient in using Azure SDK - Experience with SQL Database - Familiarity with Azure - Proficient in TDD must write test code along with it
I am looking for a skilled freelancer who can help me replicate data from our CRM system in Dataverse to Azure SQL in near real time. Here are the specific requirements for the project: Source of the Data: - The data in our Dataverse comes from our CRM system. Data Replication Method: - We prefer to use transactional replication for the data replication process. Data Update Frequency: - We need the data to be updated in Azure SQL in real-time. Required Skills and Experience: - Strong experience with CRM systems and data replication processes. - Proficiency in setting up and configuring transactional replication. - Knowledge of Azure SQL and the ability to seamlessly integrate it with Dataverse. - Experience in working with real-time data updates and ensuring data i...
...Studio 2019) OF THE SCREEN DESIGN. The project consists of programming a desktop screen in C# and WPF code from Visual Studio 2019 .NET 6 framework for Windows 10/11 and tables in SQL design fully compatible with SQL Server management studio v 18.7.1. The WPF screen need some minor changes of titles, buttons and position of text boxes. I am going to deliver instructions, changes on design and general details in PowerPoint. Also, images of the SQL tables with their columns fields and descriptions will be sent in the PowerPoint. The deliverable must include the following: 1.- C# and WPF source code 2.- The SQL tables used in the program have to be generated automatically when running the executable for the first time. We need to test source codes working 1...
The following is a list of code written in DAX and needs to be converted into Power Query. The problem: we are trying to use DataMart and build report in powerBi service. To create calculated column, we can only use PowerQury or SQL in the DataMart transformation section. The following code was written in PowerBI desktop using DAX. I need someone who knows very well PowerQuery (M), who can quickly convert the following code from DAX to PowerQuey and be able to copy and paste in PowerBI Service DataMart transformation section my using custom column in Query section of the DataMart. To get paid, the code must work without any problem. Anything between ‘ ’ is the table name, and anything between is the field name. If you are an expert in PowerQuery and you have c...
I am looking for a skilled professional to help us with our database backup project. Our sql database is hosted on a physical server in our office, and we need to make backups on specific dates: 1/19, 3/1, and 5/31. Key requirements and ideal skills for this project include: Database Size: - The database is medium-sized, ranging from 1-10 GB. Preferred Backup Method: - We would like to use an external hard drive for the backup. Server Access: - We have physical access to the server. If you have experience with database backups, specifically with medium-sized databases and using external hard drives, we would love to hear from you. Please provide examples of similar projects you have worked on in the past.
We have a working ex...different server. Requires knowledge of Azure SQL, Azure Permissions and PowerShell. All that should be required is to adjust the permissions so it works between instances and change the script for us for the new server. Ongoing part time contract work available for assistance in maintaining our Azure virtual private cloud if this first quick task is completed successfully and you have the additional skills required. Key responsibilities include adjusting permissions within Azure to facilitate seamless communication between instances and modifying the existing PowerShell script to ensure efficient replication on the new server. The successful candidate will be adept at navigating Azure environments, possessing a deep understanding of Azure SQL and Powe...
I'm in need of an experienced GLPI developer who can create a plugin specifically targeted at improving workflow automation. Important features for the plugin: - Automated ticket creation: this should be efficient and without lapses. - Task assignment: the plugin should be capable of assigning tasks a...without lapses. - Task assignment: the plugin should be capable of assigning tasks automatically. - Status updates: regular and automatic updates on the status of tickets and tasks. The ideal freelancer should have solid experience creating plugins for GLPI, a strong understanding of workflow automation, and the ability to translate these requirements into practical solutions. Proficiency in PHP, SQL, and JavaScript is highly desired. Demonstrated experience with similar proj...
I am looking for an experienced ansible developer who can support Windows, Linux, and ESXi hosts. The project involves implementing ansible for these operating systems, but the complexity of the implementation is not yet determined. The timeline for the project is more than 1 month. Ideal skills and experience: - Strong knowledge and experience with ansible,oracle,sql - Proficiency in working with Windows, Linux, and ESXi hosts - Ability to handle both simple and complex implementations - Excellent problem-solving skills - Good communication and collaboration skills If you have the expertise and experience in ansible development for Windows, Linux, and ESXi hosts, and can handle a project with an undetermined complexity within a timeline of more than 1 month, please reach out to d...
I am looking for an experienced freelancer to resolve a 500 error on my aws Plesk server. The error is caused by a SQL connection issue, resulting in too many connections. Project Details: - This project is for an existing business. - The resolution of this issue is of immediate urgency, and I need it resolved within 24 hours. - My budget for this project is $10. Skills and Experience: - Proficient in AWS and Plesk server management. - Strong knowledge of SQL and troubleshooting SQL connection issues. - Ability to quickly identify and resolve server errors. - Excellent communication skills to ensure timely updates and resolution. If you have the necessary skills and experience, please provide your proposal for resolving this issue. Thank you.
We want to use an own GPT-model for first level support. What we provide: - virtual server (you tell us about the requirements) - SQL-database with >10.000 support tickets (customer email and our answer) for additional training - FAQ for additional training What you should do: - install a GPT, e.g. LLaMA on our server - provide a script with which we can feed the GPT with our given databases to fine-tune it - provide an API with which we can connect to the GPT and chat What the result should be: - We receive an email from a customer - We send it to the GPT and ask for pre-qualification the department (is it spam, support request, billing issue, ...) - if it is a support case, GPT should provide an answer and/or a matching FAQ-article (based on the knowledge we provided for fi...
I need to develop pdf scrapping in django which cN connect to sql database for website
...Incorta? What are schema objects in Incorta, and how are they used in data modeling? Materialized Views: What are materialized views in Incorta, and why are they important? How do you create and refresh materialized views? Data Integration: How does Incorta integrate with different data sources? Have you worked on connecting Incorta with non-relational data sources? SQL and Query Optimization: How comfortable are you with writing SQL queries in Incorta? What strategies would you use to optimize a slow-performing Incorta query? Security and Governance: How does Incorta handle data security and governance? Can you explain the role of access controls in Incorta? Real-Time Analytics: How does Incorta support real-time analytics, and why is it important for certain busines...
Angular Developer with .Net Core and SQL Experience Needed I need monthly hiring on a daily 8-hour basis. Project Overview: - I am seeking an experienced Angular developer with knowledge in .Net and SQL to assist in the development of my application. - The specific functionalities required for the application include user registration and login, data visualization and reporting, as well as e-commerce functionality. - The application should have a modern and sleek look and feel, with clean and minimalist design elements. - The project timeline is flexible, as it depends on the complexity of the requirements and the availability of the developer.
...protection measures. Participate in the entire application lifecycle, focusing on coding and debugging. Contribute to all phases of the development lifecycle. Requirements: Minimum of 5 years of experience in PHP development. In-depth knowledge of object-oriented PHP. Understanding of MVC design patterns. Knowledge of front-end technologies including CSS3, JavaScript, and HTML5. Experience with SQL/NoSQL databases and their declarative query languages. Excellent problem-solving skills and ability to work under pressure. What We Offer: Opportunity to work on exciting and challenging projects. A supportive and collaborative work environment. Competitive compensation. Flexible work hours and 100% remote work. How to Apply: Please send your resume, a cover letter, and a portfolio ...
I am in need of assistance with exporting a MySQL database from SQL Server in a Windows environment. I am looking for a skilled freelancer who has experience with database management and SQL Server. Skills and experience required for this project: - Proficiency in SQL Server and MySQL - Knowledge of database export and import processes - Familiarity with Windows operating system - Experience with SQL Dump file format Project requirements: - Export the entire MySQL database from SQL Server - Ensure all tables and data are included in the export - Use the SQL Dump file format for the exported database Please note that I do not have any specific tables or data that need to be included in the export. The freelancer will be responsible for exportin...
PeopleCode Development / SQL Project Tasks: - Assistance with PeopleCode development and SQL queries - Intermediate level complexity Skills and Experience: - Strong knowledge and experience in PeopleCode development - Proficiency in writing SQL queries - Ability to handle intermediate level tasks efficiently I want to create some loops and conditions to iterate through tables and queries. Deadline: - The tasks need to be completed within 1 day.
I am in immediate need of a proficient API specialist well versed in UKG Pro API for an upcoming project. I need to extract data to an MS SQL database from a customer's UKG Pro system and need some expertise in this area. The specific functionality details are not ironed out, allowing for flexibility in the role - however, the project's main use of UKG Pro API may involve activities such as retrieving employee data, managing time-off requests or generating payroll reports. Ideal Skills: - Exceptional understanding of UKG Pro API - Relevant experience in managing API integrations Availability: I aim to have the project completed within a month, so freelancers who can dedicate significant time over the coming weeks would be ideal. This project is a fantastic opportun...
I have an ASP.NET MVC application that I built 6 years ago and I would like to continue building it but I somehow forgot how ASP.NET and SQL Server things work exactly so I need some help. I have the following: -The full folder of the project that I built 6 years ago with all the source files -The MDF and Log files of the DB I need the following: -Attach the DB -Setup a website in IIS and link it with the web application -Test one page in the application to make sure it is working
I'm in need of a developer with intermediate level expertise in DAX development for Power BI. Your tasks would involve: - Creating complex DAX formulas - Optimizing existing DAX formulas It's necessary that you know how to connect to SQL databases in Power BI, as this will be our primary data source. Ideal candidates would already be accustomed to these tasks and would have sufficient experience in similar projects. Let's optimize and enhance our reporting with your DAX skillset!
My Microsoft SQL Server has been giving me syntax errors when I try to execute certain queries. I'm unclear on what exactly the issue might be, but I'm in desperate need of assistance. Hence, I'm looking for someone experienced with SQL and particularly with Microsoft SQL Server. Please note, this assistance is quite urgent: - You should be proficient in Microsoft SQL Server syntax. - You should be able to identify and rectify syntax errors quickly. - If possible, I also wish to understand the cause of these errors to prevent them in the future. - The project needs to be completed as soon as possible.
I am looking for a .Net Developer who has experience in EMV Card Processing with Fiserv. Please do not apply if you do not have experience in this arena Skills and Experience: - Strong proficiency in Node.js and SQL Server - .Net Winform - Card Processing The objective is to be able to process payments via Card Present Transactions (EMV) or swipe. Also be able to create a void to cancel a transaction and To Batch Close. The project needs to be completed within 1 week, so the ideal candidate should be able to work efficiently and meet deadlines.
...Technical Overview: 1. Platform Language: Python or similar language, a powerful programming language, ensuring rapid development, long-term maintenance, and a robust foundation for the service. 2. Mobile Platform Language: Flutter, a versatile programming language that allows for the development and distribution of apps to both iOS and Android using the same code base. 3. Database Management: Utilizing SQL database to ensure structured data management, reliability, and strong data integrity, which are crucial for handling sensitive healthcare information. 4. System Architecture: • Cloud-based infrastructure for scalability and reliability. • RESTful API for seamless interaction between the web and mobile applications, ensuring a cohesive user experience. 5. Security &a...
...application currently have local database for 2 modules (1) hotels inventory module, (2) agents and subagents module and live API connection with a third party provider). Full stack developer scope of work and future requirement (hourly cost or fixed cost per job) - Maintains current codes, regular checks and fixes of any future bugs - Optimize server/hosting capacity (currently using digital ocean) MY SQL - Support future clients with API connection to the current application - Integrate new modules (transfer module, cruise module, flight module etc..) - Develop API connection with channel managers or third party providers - Update website with up to date features - Access to database will be given and handover will be organized before hand If you have similar work experien...
I am looking for a skilled developer to create a Help Desk Ticketing System using Angular and MVC, with an MS SQL database. The system should be able to handle less than 100 users and needs to be completed within 1 day. Skills and experience required for this project include: - Strong proficiency in Angular and MVC frameworks - Experience in creating ticketing systems or similar applications - Knowledge of MS SQL database management and integration - Ability to work quickly and efficiently to meet the tight deadline
I am looking for a skilled SQL developer who can create a query in Google BigQuery to manipulate data from JSON format. The desired output of the query is to manipulate the data from JSON. Specifically, the data manipulation required is to transform data types. The ideal candidate for this project should have experience with SQL and Google BigQuery. They should be proficient in extracting specific fields and transforming data types from JSON format.
Looking for sql expert who can help me optimise queries.
I am in search of an experienced Oracle Developer to solve beginner level exercises focused on SQL queries and PL/SQL programming. These exercises should foster a solid foundation in these Oracle topics. Requirements: - solve 10-20 exercises each for both SQL queries and PL/SQL programming, totaling in 20-40 exercises - Tailor the exercises towards absolute beginners, ensuring a progressive learning curve - Each exercise should challenge me to think, solve, and code effectively Ideal Skills: - Proficient in Oracle database management - Solid foundation in SQL queries and PL/SQL programming - Experience in creating effective educational materials - Able to explain complex concepts in a simple manner. With the right skills and knowledge, you can...
Your mission : 1. Comprehensive Web Application Security Assessment 2. Thorough Vulnerability Identification 3. Exploit Simulation and Risk Mitigation 4. Detailed Security Assessment Reports 5. Customized Recommendations for Strengthening Defenses Your abilities : - Bypass Authentication, Code Execution - SQL injection - Security monitoring - XSS (Cross-site scripting) - HTML injection - LFI (Local Life Inclusion) attack - CSRF - Network Security, Backdoors - URL Redirection attack - Host header injection - No Re-direct attack - Brute force attack etc. Certified Ethical Hacker (CEH), Offensive Security Certified Professional (OSCP), or Certified Information Systems Security Professional (CISSP) would be an advantage.
Hello there! I'm searching for a skilled full-stack freelancer, ideally with 8+ years of experience. Key Responsibilities: • You should have experience in full-stack development. • Expertise in React, Node or Java, Javascript, Vue.JS, and SQL/NOSQL is crucial for this position. • Familiarity with managing a project from conception to final product, developing detailed project scopes and drafting technical documents will be beneficial. Additional Requirements: • As the time is of the essence, we need support ASAP. • You have proven experience working remotely, effectively and efficiently. • Ability to work within tight timelines and collaborate with a team is important. Please, submit your project examples and proof of work alongside your bid...
I am looking for a Python expert developer who can assist me with web development tasks. I do not have any specific frameworks or libraries that need to be used for this project. The desired timeline for this project is 3-7 days. Skills and Experience: - Strong proficiency in Python - Experience with web development using Python - Knowledge of HT...for a Python expert developer who can assist me with web development tasks. I do not have any specific frameworks or libraries that need to be used for this project. The desired timeline for this project is 3-7 days. Skills and Experience: - Strong proficiency in Python - Experience with web development using Python - Knowledge of HTML, CSS, and JavaScript - Familiarity with database systems and SQL - Ability to work within a specifie...
I am seeking a skilled Data Analyst for a project involving Descriptive Analysis of vital Operational Data. Your responsibilities in this role would include: - Understanding and interpreting operational data from multiple sources. - Utilizing SQL as the main tool to perform comprehensive descriptive analysis. - Deriving actionable insights from the data to provide strategic recommendations. Experience in SQL is essential, and a strong background working with Operational Data is crucial. Suitable candidates will be able to demonstrate a history of similar projects where Descriptive Analysis was used to drive improvements and process optimization in a business context. I look forward to discussing how your skills can support these project objectives.
Hi, I am seeking a skilled .NET developer to assist me with an ASP.NET project. This project involves working with existing code and requires someone with experience in ASP.NET. The ideal candidate should have a strong understanding of the ASP.NET framework and be able to work with ADO.NET. The project is expected to be long term and having knowledge of SQL Server. Freelancer and Team both are welcome. Looking forward. Dipak
Draw a dependency diagram to show the functional dependencies in the relation. Decompose the relations into a set of 2NF. Then produce the final 3NF relations. For each step discuss your reasoning and why you have chosen the 2FN/3FN relations. Manually drawing the dependency diagram, or the set of 3NF relations is NOT acceptable.
Looking for an expert Azure Data Engineer to assist with multiple tasks. Your responsibilities will include: - Implementing and managing Azure Data Lake and Data Ingestion. - Developing ...utilize these platforms to achieve three main objectives: - Perform sophisticated data analysis and visualization. - Enable advanced data integration and transformation. - Build custom applications to meet specific needs. Candidates should have an advanced understanding of Azure Data Lake, Power BI, and Powerapps, bringing a minimum of 6 years experience as Databricks. Proficiency in Python, SQL, PostGre SQL, and Pyspark is also required. Knowledge of GitHub and the CI/CD Process will be beneficial for this role. If you have the skills and expertise needed for this project, I'd ...
I am in need of a skilled freelancer who can help me with my personal SQL database project. The main task involves editing a syntax. In order to perform this task effectively, you should: - Have extensive knowledge and experience working with SQL databases. - Be proficient in storing, retrieving, and analyzing data. - Provide an effective solution to the specified problem related to syntax editing. Only those who are experts in database administration and adept at problem solving are encouraged to bid. Being able to address this issue promptly is vital. Looking forward to hearing from you.
...for hosting the application. • Understanding of cloud storage, computing, and networking services. • Knowledge of deploying and managing applications in a cloud environment. Web Security: • Strong understanding of web application security practices. • Experience with implementing SSL/TLS, data encryption, and secure user authentication. • Familiarity with common security vulnerabilities (e.g., SQL injection, XSS) and their prevention methods. Ideal Candidate Profile: • At least 3-5 years of experience in full-stack development, particularly in SaaS platform development. • A strong portfolio demonstrating relevant projects, with a focus on SaaS and marketing tools. • Ability to translate complex requirements into functional, user-friendly...
...maintainable code and resolve software defects and issues up-to-date with the latest .NET technologies and best practices Requirements: 1. Proven experience as a .NET developer 2. Strong proficiency in C# and the .NET framework 3. Experience with ASP.NET, MVC, Web API, and other related technologies with front-end technologies such as HTML, CSS, and JavaScript 5. Knowledge of SQL Server or other relational databases 6. Excellent problem-solving and communication skills How to Apply: Please submit your proposal with the following information: relevant experience as a .NET developer. of previous projects showcasing your skills. hourly rate or project-based pricing. 4. Your availability and estimated time to complete the project. Note: We are looking
I am looking for a nutritionist app built in Laravel that includes the following features: - Client management: ability to add and assign clients to nutritionists - Calendar integration: syncing with external calendars and the ability to schedule appointments - Financial tracking: keeping track of payments and expenses...schedule appointments - Financial tracking: keeping track of payments and expenses For the calendar integration, I have specific requirements, including: - Reminders controlers for the apointments and notifications. Ideal skills and experience for this project include: - Proficiency in Laravel framework - Experience in building and integrating calendar features - Knowledge of financial tracking - SQL The App i already in development and we need to add some new...
I am looking for a PHP web developer who can quickly complete a project within a week. Skills and Experience: - Proficiency in PHP - Familiarity with Laravel, Symfony, or CodeIgniter frameworks - Strong understanding of web development principles and best practices - Experience working with databases and SQL - Ability to work efficiently and meet deadlines The project may involve working with existing code or starting from scratch, depending on the client's requirements. If you are a skilled PHP web developer who can deliver high-quality work within a tight deadline, please apply for this project.
I am looking for a skilled .NET developer to work on my defined project for a duration of 1-3 months. The project requires expertise in C#, ASP.NET, and SQL Server. Specific requirements for the project include: - Developing and implementing ASP.NET web applications using C# - Integrating SQL Server for database management and data retrieval - Collaborating with the team to design and develop efficient and scalable solutions - Testing and debugging code to ensure functionality and performance - Providing ongoing support and maintenance as needed Ideal skills and experience for this job include: - Proficiency in C#, ASP.NET, and SQL Server - Strong knowledge of web development principles and best practices - Experience with front-end technologies such as HTML, CSS, a...
...Administration, Cloud Architecture, and Cybersecurity. I'm seeking a qualified Python and SQL instructor who can teach me how to use these languages for practical applications in my current role. - You will help me learn how to use Python and SQL for: - Data analysis and reporting - Automation of repetitive tasks - Database management - Training should specifically cover applications of Python and SQL in: - Network monitoring and analysis - Configuration management - Log Analysis and reporting Please, note that I'm a beginner. Therefore, the course needs to start from the basics and gradually ramp up to more advanced concepts. Ideal candidates will have a strong background in Python, SQL, and IT, as well as experience...
