How to explain pl sql project in interview 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 ;)

I'm in need of an experienced application developer who can build a robust database application. The application will need to provide the following functionalities: - Data storage and retrieval: The application must be able to store and retrieve data efficiently, ensuring the integrity and security of the data at all times. - Data analysis and reporting: It should have built-in analytics features to generate and visualize reports based on the stored data. Understanding of statistics and data analysis tools is preferred. - User authentication and access control: The application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the typ...

I'm looking to buy a "bag of credit" and pay for it in installments. I'm not sure what the terms of the credit are or what the bag represents, but I want to make payments on it in installments. I'm open to suggestions on what kind of credit to buy, how much to spend, and what kind of bag it is. Ideal Skills: - Financial expertise - Payment processing familiarity - Great communication skills to explain the concept in detail

...NET C# developer to incorporate a digital signature feature into my Crystal Report PDFs within my web application. This will serve the purpose of authenticating the reports. The signed reports should be saved into a SQL Server database. Key Requirements: - Implement a digital signature feature on Crystal Report PDF files. The purpose of this is to ensure the authenticity of the reports. - The digital signing process should be automated after an approval process. - Save the signed reports into a SQL Server database. Ideal Skills and Experience: - Proficiency with ASP.NET Web Forms and C# is a must. - Experience working with Crystal Reports would be a plus. - Familiarity with SQL Server database management. - Understanding of digital signature implemen...

I'm looking for someone to help me enhance my knowledge of cybersecurity, specifically network security. Key Project Requirements: - I'm aiming to get to an advanced level of understanding in cybersecurity, so the ideal freelancer will have strong skills and experience in this area. - In terms of areas of cybersecurity, I'm particularly interested in network security. The ideal candidate should be able to tailor their lessons and practical activities to focus on this niche. - This is a personal learning project, so the freelancer should be patient and able to explain complex concepts in an understandable way. Ideal skills and experience: - Proven expertise in cybersec...

I am in need of an experienced business plan writer to help me craft a detailed business plan with the primary aim of attracting angel investors. The plan should be completed within the span of one month. Key requirements include: In a business plan for bridal jewelry , several key topics should be covered to ensure a comprehensive and effective strategy: Executive Summary: Provide a concise overview of the business concept, target market, competitive advantage, and financial projections. Business Description: Detail the mission, vision, and objectives of the bridal jewelry distribution business. Explain the need for bridal jewelry in the market and how we will fulfill that need. Market Analysis: market research to identify t...

I'm in need of a skilled 3D designer who can create a unique crate for me. The crate will be used to carry food and beverages, specifically uniformly and small-sized items. Key Requirements: - The design should incoporate a honeycomb pattern to allow water to drain. - The design should be 3D printed in panels and capable of being snapped together in a sturdy manner. - It needs to be robust enough to withstand the rigors of transportation while maintaining the integrity of its contents. - The crate will carry a dozen glass containers and needs an internal divider, made of three snap-together panels so they cannot hit each other during transport. Ideal Skills and Experience: - Previous experience in designing 3D printed p...

Currently using .Net Framework 4.5 and looking to upgrade project. The main goal for this upgrade is to ensure compatibility with modern systems. I don't require any specific performance improvements, just upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net pr...

Hogarth is the Global Content Experience Company. Part of WPP, Hogarth partners with one in every two of the world’s top 100 brands including Coca-Cola, Ford, Rolex, Nestlé, Mondelez and Dyson. With a breadth of experience across an extensive range of sectors, Hogarth offers the unrivaled ability to deliver relevant, engaging, and measurable content across all channels and media - both established and emerging. The number of channels at our fingertips; the need for speed; and the drive for mass personalisation, all mean that brands need different solutions. Our global team of over 6,000 craft and technology experts brings together creative, production and innovation to help clients navigate this exciting and ever-changing world of today’s con...

I need a local representative in Basra, Iraq, or nearby to conduct a business verification. Below is the task: 1. Visit the target address 2. Take photos 3. Conduct a mini-interview Requirements: 1. Living in (or nearby) Basra, Iraq 2. Available to do the job during business hours (9 AM - 4 PM) Notes: - 1 project can only be taken by one freelancer (on a first-come, first-served basis) - The milestone will be released the following week (Monday) after the verification to give us time to organize the report and contact you if we need additional clarification.

...developer who can design an adventure-themed mobile game. To bring my vision to life, I would like the game to have a old school pixel art syle style. The ideal candidate should provide: - Experience in adventure game development for mobile platforms. - Proficient in creating and incorporating pixel art graphics. NES ,SNES, GAMEBOY Aesthetic or More in line with the moden pixel art style of Terraria , with charm to it. - Strong understanding of game play-meets-storyline integration. The right freelancer will aid in developing a game that is both visually appealing and engaging with an immersive adventure storyline. I look forward to seeing your portfolios, along with examples of similar works completed in the past. ...

Overview We are in search of an exceptionally talented designer to craft an innovative and intuitive mockup for a web application focused on optimizing the recruitment process for various users. It is crucial that the submitted designs are entirely original. Submissions that utilize pre-existing templates or closely mimic designs from platforms like ThemeForest will be outright rejected and may receive a negative review. The design must adhere to the features specified in our project outline while showcasing a distinct and fresh aesthetic. Design Requirements 1. User Management -User Registration/Login: Separate workflows for candidates and companies. Each form should gather specific information as per the provided documentation. Design should clearly d...

in your Bid, clearly answer this questions: 1. how many years of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how...

I'm looking for an experienced software developer to create an AI recruiting software tailored for the healthcare industry. The ideal candidate should have previous experience with LMS and building recruitment tools. Key features: - Resume Screening: The software should be able to effectively screen resumes for healthcare positions. - Candidate Ranking: Implement a system that ranks potential candidates based on their qualifications and experience. - Interview Scheduling: The tool should also have a built-in feature that enables easy and efficient interview scheduling. Preferred Resume Screening method: - Keyword Matching: A system to match keywords in resumes to job requirements - Machine Learning Algorithms: An algorithm ...

I am looking for a Nepali interpreter for a client's asylum interview tomorrow, May 20th, from 11:00 AM PST. Please let me know your availability since it is something urgent

...expert to help me with configuring and optimizing my AWS server. Key Responsibilities: - Evaluate my existing AWS setup and recommend improvements for performance, security, and cost-effectiveness - Assist in configuring EC2 instances, S3 storage, and RDS databases as needed - Ensure the server is scalable, reliable, and can handle future growth Ideal Skills and Experience: - Proven experience with AWS services, particularly EC2, S3, and RDS - Deep understanding of server optimization, security, and scalability - Excellent troubleshooting skills and an ability to work proactively to prevent issues - Familiarity with best practices for cost-effective AWS usage - Strong communication skills and the ability to explain complex technical concepts ...

I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.

Are you a driven sales professional ready to take control of your income and achieve unparalleled success? Buzz Circuit Media is seeking highly motivated Sales Outreach Specialists to expand our client base for our social media management services. With our commission-only structure and powerful tools, you can unlock your earning potential and enjoy the benefits of recurring passive income. Compensation Structure: 10% commission on the monthly revenue generated by Tier 1 clients (client pays $199/month) 15% commission on the monthly revenue generated by Tier 2 clients (client pays $399/month) 20% commission on the monthly revenue generated by Tier 3 clients (client pays $599/month) Bonus Structure: $250 bonus when a client reaches 3 months $500 bonus at 6 months $1,000 ...

I need a skilled individual to convert my current Laravel website to WordPress. The main reason for this transition is to ensure that I have a user-friendly, easy-to-manage website. Currenlty, the website is built with Laravel, but I would like it to be converted to WordPress to make it easier for me to manage and update the content. Ideal skills and experience: - Proficient in Laravel and WordPress - Strong understanding of website architecture and conversion process - Ability to ensure a seamless transition - Good communication skills and ability to explain technical concepts to non-technical individuals.

...several key components and technologies. Here’s a detailed outline of the project requirements and the ideal skills needed to build the solution: Project Overview The goal is to develop a dashboard for an existing POS and inventory management system that consolidates sales and collection reports, provides inventory management, and includes customer data analysis. The dashboard should be accessible via web browsers and mobile devices. Key Features 1. Sales Reports o Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data Source: Multiple MS SQL databases. 2. Collectio...

...aspiring to start a food or cafe franchise in Jaipur, my primary goal is to maximize profit. I'm looking for an investment advisor who can help me make informed decisions. Key Requirements: - **Location Selection**: I'm particularly interested in high foot traffic areas and those close to colleges or universities. Your advice in this area will be crucial. - **Demographic Understanding**: My target market includes students and working professionals. I'll need you to guide me in ensuring the franchise is appealing and accessible to this audience. Ideal Skills and Experience: - **Investment Advisory**: Previous experience in advising on successful food or cafe franchises would be a major plus. - **Marke...

1. Create a chatbot. 2. Use an open-source LLM. 3. Use an iterative method to get a very large response with some custom logic( I will explain it ) . 4. Add a button in the chatbot. When enabled, it can show responses from public sources; otherwise, it must show results from a private source, such as a Pinecone database. Additionally, there should be a page where I can upload my text and PDF files. The response will be displayed like ChatGPT, with a typewriter effect.

I'm in need of an expert who can help me track and interpret analytics data on my e-commerce website. Key Requirements: - Track & Interpret: I need someone who can implement tracking for traffic sources, conversion rates, page views and user interactions on my e-commerce website. You should have a strong background in data analysis and be able to provide actionable insights based on the data. Skills and Experience: - Strong Proficiency in Google Analytics: As I am currently using Google Analytics, you should be experienced with the platform and be able to set up advanced tracking and reporting. - E-commerce Analytics: Experience with e-commerce tracking methodologies, such as tracking of specific sales funnels, cart abandonment rates, and produ...

I'm in need of a WordPress expert with advanced knowledge in both plugin and theme development. The perfect candidate for this project should have a good grasp of PHP, JavaScript and databases. Key Responsibilities: - Develop and customize WordPress plugins - Develop and customize WordPress themes - Ensure all code is high quality and maintainable - Troubleshoot and debug complex technical issues - Collaborate with other teams to create successful project outcomes - Maintain a high level of awareness of industry trends and technologies Ideal Skills and Experience: - Proven work experience as a WordPress Developer - Proficient in PHP, JavaScript, HTML, CSS and SQL - Excellent knowledge of WordPress, plugins and themes - Experience with...

I'm seeking a skilled blockchain developer with expertise in Solidity programming and Ethereum Virtual Machine (EVM) for the development of a decentralized application (dApp) with DeFi functionalities. We want to build this: With some changes: - colors, branding - different EVM blockchain (Base) I have the codebase, and the contract. What I need is: - for you to modify codebase for new contract, and new design. - host it (on Netlify, or something similiar if you think it is better). Or explain me how to host it. - assist me with testing on testnet.

As a business owner with an existing website, I'm searching for an expert in Amazon Web Services (AWS), PHP, MySQL, and server administration. My core objective is to seamlessly migrate my website to AWS. Your role would involve: - Setting up and managing EC2 instances. - Assisting with RDS database and S3 storage. - Implementing Elastic Beanstalk. Necessary Skills include: - Extensive experience with AWS (EC2, S3, RDS, Elastic Beanstalk) - Website migration expertise - Strong background in PHP programming - Familiarity with MySQL - Proven Server administration skills Please bid with relevant credentials and explain how you would ensure a smooth migration.

I'm looking for a DevOps expert to help me with my interview process. My current focus is on Continuous Integration and Delivery, utilizing Jenkins, Docker, and Kubernetes, GCP cloud run. Key Responsibilities: - Setting up and configuring environments: The most crucial aspect of the support I need is in this area. Your expertise in configuring these environments is paramount. Ideal Candidate: - Proficient in Jenkins, Docker, and Kubernetes. - Skilled in Continuous Integration and Delivery. - Experienced in setting up and configuring environments. This is a great opportunity for you to showcase your DevOps skills while helping me with my interview process. Looking forward to hearing from you!

...interested. This is a full-time at least 6 months contract to be renewed. An interview will be required before selecting the right candidate.** I am looking for a marketing specialist with a strong understanding of various marketing strategies and the ability to target specific audiences. The goal of the campaign is to increase brand awareness. Ideal skills for this job include: - Flyers creation - Proficiency in social media marketing, email marketing, and influencer marketing. - Experience in creating and executing multi-channel marketing campaigns. - Strong understanding of the target audience of young adults (18-24), working professionals (25-35), and parents (30-45). - Ability to analyze campaign success and adjust strategies as n...

We are in need of a skilled software contractor to provide a comprehensive 2-week review of our existing C# and PHP code. This project involves reviewing the existing code and it's performance, efficiency, and quality. Ultimately, we need a detailed documentation on the code's state and recommendations on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is preferred) - Extensive experie...

I'm looking for a proficient video editor who can cut three video tracks of an interview from into a 20-40 minute video podcast. The major tasks include: - Add existing opening and closing graphic - Edit between 2-shot and two single recordings of interviewer and interviewee - Add intro/ outro music - Removing unwelcome background noise - Adjusting the overall mix to yield a clearer sound If compatible, this could be a recurring job 1-2x per month.

I need a data structure and algorithm expert to help me solve some beginner level problem sets mostly revolving around arrays and strings. Ideal candidates should: - Have a strong grasp of fundamental data structures & algorithms. - Be proficient in problem-solving using arrays and strings. - Be able to explain solutions clearly and concisely. Looking for a freelancer who can help me understand the basics while getting through the problem sets.

Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto

I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has ...

Project Title: AI Image Processing for User Face Image with Clothing Overlay I am looking for a freelancer who can utilize AI technology and image processing to create a single image that combines a user's face image with clothing overlay. The specific requirements for this project are as follows: AI Technology: - The freelancer should have expertise in image processing techniques to achieve the desired result. API Preferences: - There are no specific API preferences, and the freelancer can use their discretion in selecting the most suitable API for the task. Final Output: - The final output should be a single image that contains the user's face image with clothing overlay. - The clothing overlay should include a t-shirt from a second...

...looking for an experienced PowerBI solution architect to provide expert guidance on setting up and creating PowerBI reports for our customers. Our goal is to develop a robust reporting strategy that ensures our clients can easily consume and utilize these reports. We need a professional who can help us understand the requirements, best practices, and strategic approach to initiate this project. Objective: To gain insights and guidance on starting with PowerBI reporting, understanding the necessary requirements, and developing a strategic plan for implementation. Duration: 30-minute consultation call Experience: Proven experience with PowerBI report creation and strategy development is required. A clear understanding of the steps required to st...

I'm in need of a developer proficient in Python who can create a video tutorial. The tutorial should showcase the process of building a user authentication login page for a web application using the Microsoft Graph API. The loging should just allow pre-registered users (from azure dashboard) to enter the app. Ideally the should build a little login page using streamlit! Key Requirements: - Expertise in Python: Comprehensive proficiency in Python is a must, as the tutorial is centered around this language. - Familiarity with Microsoft Graph API: The ability to leverage the Microsoft Graph API for user authentication is essential. - Video Creation: While I'm not looking for a professional video maker, the candidate should be able to...

I'm in need of a mechanism design expert who can assist me in creating a small mechanism. The purpose of this mechanism is to move objects, and it will be operated manually. Key Responsibilities: - Detailed force analysis: An important aspect of this project is a comprehensive force analysis to ensure the mechanism functions as intended. Hand calculations to be included. - CAD Model: The CAD model should be of intermediate complexity with multiple components and moderate detailing. - Concept Sketches: Creating detailed concept sketches which will guide the design process. - Materials & BOM: Selection of materials suitable for the mechanism and creating a Bill of Materials. - FEA: Performing Finite Element Analysis to evaluate the p...

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page

...(I will interview in English via video) to do some tasks for my agency, such as: Social media Content editing or creating CRM management Email marketing Writing an ebook Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes over and over. Attention to detail. Common sense. This job will part-time as a test period, after that it will be full-time. First, there is a task I’ll give as a test. Payment for part-time during trial period: Fee: 250 USD Perform...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I am looking for an independent contractor to create and manage Facebook ads for my agency. My Agency, Millionix, works only with plastic and cosmetic surgeons. So i need an experienced Media Buyer that can generate leads steadily through Facebook ads. The Media Buyer also needs to be able to create landing pages for Lead Reactivation. A good level of English is a must. And i need proof of work. Everything else will be discussed on an Interview, at the third phase of this hiring process. Looking forward to your applications.