Need someone sql skills työt
Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.
Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...
Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
...Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project requires strong communication skills, attention to detail, and a robust understanding of data systems and automation. Ideal candidates are those with pr...
Hello, I have 200 forms, each container with around 20 fields of information. I need each form typed out. I cannot make any mistakes. Empty forms are attached below. I just have about 200 forms of handwritten information, some which I can read and some which I can't so I want it all typed. No using AI or anything for this. To be approved say "Banana"
...FIRST TO BE SELECTED I need someone to create videos on English Grammar on the topics given here in the attachment. It can be discussed in Chat. You should have a good, professional grade Mic. An electronic Pen is desirable. Topics for which you need to create the videos are Narration , voice change, parts of speech, sequence of tense, gerund, creating wh questions etc. Each topic should be minimum of 60 minutes length. You first need to explain the main concept, use examples and use some questions and then its answers with explanation.. also create 10 MCQ questions on each topic. Instructions to be in ENGLISH only. Use Screen recording Software and/or Whiteboard. VOICE MUST BE LOUD & CLEAR. NO BACKGROUND NOISE/SHAKY VIDEOS NOT ALLOWED. See my attached sa...
Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrabl...
...ticketing system should incorporate three crucial user roles: Admin, Agent, and User. - Admin: Full control over the entire system. - Agent: Responsible for handling and resolving tickets. - User: Able to submit tickets and monitor their progress. Ideal skills and experience for the job would be expertise in web development, specifically in creating ticketing systems. Familiarity with user management, role assignment, and priority matrix are essential. Fluent in programming languages like PHP, JavaScript, and proficiency in SQL for a robust database system is a must. Creativity in UX/UI design for an engaging and user-friendly interface should be apparent. It is also required to handle incoming and outgoing E-Mails. I don't want to have further framewo...
I am in need of a skilled PHP programmer to address an "undefined variable" error within my user authentication system. The system primarily relies on email and password authentication. Key Requirements: - The error lies within the user authentication system - The primary method of user authentication in the system is email and password Ideal Skills and Experience: - Proficiency in PHP, SQL - Experience with user authentication systems - Familiarity with handling undefined variable errors - Understanding of secure email and password authentication Your task is to identify the root cause of this error and implement a solution to rectify it. Please provide specific examples of similar work you have done in the past.
...and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean, maintainable, and well-documented code. Troubleshoot and optimize existing integration solutions. Desired Skills and Qualifications: Strong NodeJs skills Ability to read Python & Go code Abiltiy to write DBT transformations Strong experience with CloudQuery and its features. Proficient in SQL and database management systems. Solid understanding of API integrations and web services (REST, GraphQL, etc.). Experience with cloud platforms (AWS, GCP, Azure, etc.) is a plus. Strong problem-solving skills a...
...with experience in JSON, MS SQL, AJAX, and HTML to help me migrate my existing website to a new template. The specific features that need to be migrated are the design layout and content pages. To give some context, the primary objective of this migration project is to enhance the functionality of the website. An ideal candidate should be well-versed in enhancing user experience and updating design aesthetics. Your role will be pivotal in ensuring that the new template not only preserves the existing features but also improves the functionality. The key difference I'm aiming for in the new site is faster loading times. This means that you should be able to optimize the site's performance and ensure that the migration process doesn't compromise its speed. ...
...rental system e) Online car rental system The final submission should include: 1) Report describing the project that includes: a. Introduction b. Web site design c. Web site development: the main files created: articles, categories, modules, and database. d. Screenshots of the website e. Conclusion f. References 2) One folder that holds all the subfolders of categories, articles, menus, modules, SQL 1 files, videos, banners, and images....
I am searching for an individual interested in a shar...individual interested in a shared ownership of an exciting company. This potential long-term business partnership will transform our vision into reality. Key Responsibilities: * Spearhead technical aspects of the company * Offer expertise in software development Ideal Partner Skills and Experience: * Proven experience in software development * Excellent problem solving and tech-analysis skills * Open-minded, entrepreneurial spirit * Willingness to commit long-term Your role as a partner isn't just about tech skills; it's about taking ownership, bringing strategic insights to the table and steering our business towards growth. If you're innovative, driven and ready to make a real impact, let'...
I am in immediate need of a Python expert who can extract data from external website and store in an MS SQL database. freelancer with extensive experience in data extraction from varied sources would be highly desirable. The skills and experience required for this job includes: - Extensive knowledge on Python-based data extraction methods - Proven experience with managing and manipulating MS SQL databases - Ability to adapt to multiple and potentially unexpected data sources - willing to work via anydesk for final installation of the project Given the urgent nature of this project, only those who can demonstrate a commitment to quick turnaround times need apply.
...Security+, CISSP, GSEC, SSCP, etc. - Outstanding communication skills and proficiency in English. - Strong teaching and mentoring experience. - Advanced knowledge in Network Security, Cryptography, and Ethical Hacking - Cybersecurity certification as mentioned below. - Outstanding communication abilities. - Teaching or training experience preferred but not essential - Ability to break down complex cyber security concepts. Experience: Minimum of 10 years' practical experience in cybersecurity, preferably with recognized companies. Proficiency with various cybersecurity tools and programming languages. Expertise in identifying and mitigating risks, threats, and vulnerabilities. Technical Skills: Hands-on experience with Secur...
I am seeking an experienced software developer with expert...internal communication - Enhance data analysis for better decision making Needed Functionality: - Inventory management system: The application should keep accurate track of the inventory levels and alert the users when restocking is needed. - Payment management: The application should be capable of processing payments, invoices, and balancing accounts. Ideal Skills: - Proficiency in back-end and front-end development - Knowledge in SQL for database structure - Understanding of payment gateways The successful freelancer should exhibit strong understanding of cloud infrastructures and advanced data security measures. Experience in creating similar systems would be a significant advantage. The simpler the applicatio...
Looking for someone that can write a book about the negative effects of sugar on the human body. Preferably someone in the medical field. 20,000 - 30,000 words.
I need an experienced developer with proficiency in both Vue.js and .NET, capable of delivering the project in a short time frame. - **Role Requirements** - Vue.js and .NET expertise, preferably in developing enterprise applications. - **Project Details** - The developer is expected to create an enterprise application with an interactive UI. - I place a significant emphasis on an engaging, usable and intuitive interface. - **Timeline** - The project needs to be completed ASAP. So, I'm looking for someone who can dedicate sufficient time immediately. -** Vue.js 2 and 3 experience ** with .Net Web API and sql server required on expert level Ideal candidates can demonstrate previous experience working on similar projects and have a strong understandi...
... but tailored to our specific needs, including custom graphics and a unique logo that represents our brand identity. KEY REQUIREMENTS Languages and Frameworks: - Frontend: Expertise in HTML5, CSS3, JavaScript, and experience with frameworks like React.js or AngularJS. - Backend: Proficiency in server-side languages such as PHP, Python, or Node.js, with database management using SQL or MongoDB. - CMS Experience: Capability to integrate and customize content management systems (CMS), preferably WordPress or Drupal. Design and Graphics: - Creation of a unique logo and custom graphics that reflect our brand and the services we offer. - Design a responsive and accessible website that adjusts smoothly to different screen sizes and devices. - Clear and intuitive navigation system
I'm urgently in need of a qualified developer or data engineer to create a pipeline utilizing DBT and SQLITE. The goal is to process a multitude of json files housed in a particular folder. Please refer to the assignment document for detailed instructions Step 1. Initial Setup: ● Use DBT and SQLite to create a pipeline that processes files from a folder structure. You can access the folder here Step2: Adaptation for Continuous File Deliveries: ● Adjust the pipeline to handle continuous file deliveries, where new folders with JSON files are added over time. For example: Step 3: Data Quality Assurance: ● Create a suite of data checks to ensure the data is clean and add a DBT command to run these checks. ● Suggest additional information or metrics that could be used to further ...
I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the ye...
I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows appli...have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, M...
I want to get more followers on this account for business proposes at least should be done before three days
I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring...
As a business user, I need assistance with the configuration of SSRS Reporting Service on a staging environment. I have configured the WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above ov...
... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a d...
I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like i...
...Snipepay as a payment gateway in WooCommerce. Our hosting company currently sets up client accounts manually through a control panel that supports API integration. The successful development of this project requires extensive knowledge of this API to enable full automation of the account setup, hosting package ordering, and management processes directly from our WordPress site. The developer will need to ensure seamless communication between our WordPress interface and the control panel's API, enabling users to perform all actions in an automated, user-friendly manner without manual intervention. This includes the ability to manage domains, select hosting packages, and complete purchases with full integration of the payment systems we plan to use. Requirements for the...
It’s Urgent! We need to write a shell script It’s too simple and not more than 2-3 hours job if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and bdomain
I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.
I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criter...
It’s Urgent! We need to write a shell script It’s too simple and not more than 2-3 hours job if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and bdomain
We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mappi...
I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience fo...
I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience fo...
I seek a professional with contacts in the Prime Minister's Office, ideally, someone who can arrange a meeting. The purpose is to request assistance on a specific issue related to a community development project. Unfortunately, there's no additional information regarding the focus area of the project at this moment. Desired skills and experiences are: - Networking & lobbying - Experience in government relations - Excellent communication - Understanding of community development projects Please note: your application won't be considered if no proven experience dealing with government offices is shown.
...into accounting to import customers orders and convert to invoices. We also link / interface to Ideal skills for this project would include: - Proficiency in Opencart system development - Strong UI/UX design capabilities, especially in mobile responsiveness - Experience in developing and implementing referral programs in e-commerce systems - A good understanding of security features to ensure customers' data is protected - Excellent communication skills to understand and deliver on the specific requirements Please note that I'm open to any suggestions or proposals that you may have to enhance this project further. I look forward to seeing how your skills and expertise can bring these ideas to life. I have prepared a document I can send with work we...
Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.
I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.
I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.
I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.
...established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions. 1. What type of Software you have done in Laravel+Vue? 2. How many years of Industry experience do you have in Laravel software development? 3. How many years of Industry experience do you have in Vue software development? 4. How many years of Industry experience do you have in Laravel + Vue software development? 5....
I need a focus-driven developer to build a web application for my travel agency. The purpose of the application is to implement a backoffice system for managing bookings. The functionalities I'm aiming are: - User needs to enter details like Agency name, pax name, mobile number, pick up location, pick up time, date of flight travel, flight departure time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Profici...