Sql crash course 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 looking for a skilled Flutter developer to transform my custom UI design into a functional page within my educational application. Key project details: - The UI is specifically tailored for educational content, particularly course listings. - I'll require the course listings to be displayed uniquely, including incorporating course levels. Ideal skills and experience: - Proficient in Flutter development, with a strong portfolio of successful projects. - Prior experience with educational app design will be a big plus. - Ability to create custom UI elements and layouts. - Good understanding of user experience principles, particularly in educational contexts. - Strong communication skills to understand and implement my specific design requirements.
...undo / redo states - save image (to their photos library) - option to save or pick from some predefined palettes??? - option to save current works in progress??? - does not need to support ads, it’ll be a one-time purchase app I’ve attached a sample copy that just sort of outlines the idea, just an AI generated sample cobbled together in photoshop, but for functionality I’m open to changes of course! If you could provide a quote and also a timeline for completion that would be great. If you have any questions, let me know. -------------------------------------------------------------- Skills and Experience: - Expertise in both iOS and Android app development - Understanding of UX/UI design principles - Prior experience in developing art or lifestyle apps ...
I'm in need of a skilled circuit board designer that can create the and design the Greber file for me, I need to send the files to the manufacturing compony. My project contains few components only. SAM D11C 14-pin chip, 3 LEDS, Battery hol...design the Greber file for me, I need to send the files to the manufacturing compony. My project contains few components only. SAM D11C 14-pin chip, 3 LEDS, Battery holder, and a reset switch. The "j2" pads are for programming the chip, Gnd, power, and clock. The 2 antennas traces are connected to analog pins A2 and A4. LEDs are connected to digital pins 24,25,31. the reset button to RST pin of course. For the 4 programming pads. Gnd and Power goes to Gnd and VDD pins in the chip, For the clock, I'm not shire which pins. l...
...practical. ✻ PAYING YOU TO LEARN ✻ No. You aren't dreaming. I value intelligence and problem-solving ability over experience. I'd prefer to work with someone who is clever and learns quickly rather than someone experienced but is not very intelligent and/or does not solve problems scientifically. Would I hire an Isaac Newton or an Albert Einstein even if he had no programming experience? Of course I would. ✻ TESTS ✻ You must pass several difficult logic tests to work with me. The first logic test you complete for me will be an unpaid logic test. In other words, I would not pay you any money whatsoever if you were to pass the first logic test. However, I would pay you $25 (Twenty-Five Dollars) if you were to pass the second logic test, and $50 (Fifty Dollars) if y...
I'm in need of an expert in Facebook advertising. My intention is to sell a yoga fitness course designed for both men and women aged 20-50, who are job professionals. The hired freelancer should: - Have a deep understanding of Facebook ads targeting - Be able to write compelling ad copy to engage potential participants - Have experience in crafting high conversion ads specifically for fitness or health-related courses Ideal Skills: - Facebook Advertising - Copywriting - Marketing Strategy - Experience in fitness industry (preferably yoga) marketing. Looking forward to your proposals!
I am looking for an experienced web developer to create a professional and informative website for my business. The main purpose of this website is to provide an online course registration feature for potential customers. Key Requirements: - Design: The ideal candidate should be able to create a professional and informative website design that aligns with our brand. - Development: The website must have a user-friendly interface that allows customers to easily navigate and register for courses. - Functionality: Customers should be able to complete course registrations through an online form. Ideal Skills: - Proficiency in web development, particularly in creating user-friendly interfaces - Experience in e-commerce or online registration systems - Strong understanding of mode...
More details: What specific bug or issue are you experiencing in your app? App crashing Under what conditions does the app crash? On startup What is the primary function of your app? dating app
Looking for someone with experience and track record in developing and managing e-learning systems for course delivery systems (Similar to Cousera/Udemy) . Having ready made and customizable solutions are welcomed. Users should be able to take short online courses in text, ppt or videos and earn certifications.
I am seeking a proficient course builder to design a fundamental, text and image-based online course. This will be self-hosted on my website. Key requirements: - Develop an engaging and informative course using text and images as main tools of delivery - Have extensive experience and expertise in creating online courses - Experience in self-hosting online courses is a plus - Provide innovative ideas to make the course more attractive and compelling The perfect candidate will have a strong understanding of how to create effective, engaging text-and-image-based educational content and possess excellent skills in course design. Previous experience in building and hosting courses on a client's website is preferred.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
As a client, I am looking for a skilled Pyth...project requires: - The creation of a test cases for existing website crucial requirement is expertise in writing unit test cases for Flask applications. The developer should know how to write effective test cases to ensure that all components of the website work individually as expected. This is important for seamless user interaction and overall functionality. The ideal candidate would of course have proven experience with back-end development, particularly with Python, and preferably with Flask. Knowledge and application of best practices in web security, particularly with user authentication, is highly valuable for this project. The chosen freelancer is anticipated to have strong skills in testing, able to devise comprehensive u...
...intuitive and easy-to-navigate interface, allowing users to find and enroll in courses effortlessly for physical classes. - Extensive Course Catalog: Our platform offers a wide range of courses across various disciplines, including technology, business, arts, science, and more. Each course is meticulously crafted to meet the highest educational standards, ensuring that learners receive the best possible education. - Detailed Teacher Profiles: EduConnect showcases comprehensive profiles of all our instructors. - Course Institute Centers: We only provide information on physical institute centers where certain courses may be available for in-person attendance. The course material and website content should be bilingual, in both English and Hindi. Proven exp...
I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar projects will be ...
I am looking for a skilled professional who can revamp our existing WP MasterStudy LMS. Course Management Features Enhancements: - Course allocation and tracking - Course registration, billing and confirmation Performance Improvements: - Prioritize improving the loading times of the LMS. UI/UX Enhancements: - Make the LMS easier to navigate. Users should be able to find what they need quickly. - Enhance the aesthetic appeal of the LMS with a modern and engaging color scheme. - Simplified user interface: Streamline the user interface to make it more intuitive and user-friendly. 5-6 other things needed to make site fully functional.
...skilled WIX developer to assist me in creating a sophisticated website with E-commerce functionality. Key Requirements: 1. Wix online course setup 2. Membership site setup on Wix 3. Wix full website creation 4. Course Landing page design 5. Membership restriction page 6. Course upload 7. Course thumbnails design 8. Section and step setup properly 9. Course booking 10. Wix sales funnel 11. Check out page customization 12. Email design, email series, workflow, and automation 13. Setup public, Private, and secret course 14. Form, survey, Quiz, Poll, and Questionnaire 15. Design 4 Badge for each Course to assign to student base on the course they attend 16. Wix course drip 17. Payment Gateway integration 18. Domain integratio...
A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...
I'm looking for an expert in Microsoft Power Apps to develop...the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quality, functional solution w...
I'm in need of someone skilled in creating simple woodworking projects. I'd like to produce an easy-to-assemble wooden reindeer kit that is small in size, around 1-2 feet when fully assembled. - Skills & Experien... - Knowledge of safe, light, and durable wood types for DIY crafts Your task will be to design, prototype, and provide assembly instructions for this DIY wooden reindeer kit. The final product must be something that even a woodworking beginner can assemble with ease. Please ensure that the finished reindeer should not exceed 2 feet in height. The design should be unique, creative and, of course, appearing like a lovely reindeer. This project might require revisions based on feedback. I expect high-quality work, so only expert freelancers in this fiel...
...assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, in...
I'm looking for a freelancer who can create an elegant company card for me. I've a company logo that needs to be incorporated into the design. This is a straightforward project, but I do value attention to detail, creativity and of course, the ability to create a design that's elegant. Ideal skills and experience for the job: - Proficient in graphic design and print design - Prior experience in creating business cards - Strong sense of aesthetics and attention to detail. Name UK Phone Number Other Phone Number Email Address Company Website UK Address Other Address
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...
...Android apps. Specifically, I'm encountering a problem where one of my fragments is causing the app to crash. Key Project Details: - The problematic fragment is failing to display correctly, leading to an app crash. The fragment is crucial for data retrieval from a database. - The data being retrieved is user profiles, which may be where the issue lies. Your Responsibilities: - Identify and resolve the issue causing the crash. - Ensure the fragment correctly displays user profiles retrieved from the database. Ideal Candidate: - Proven experience in Android app development, especially with fragments and database interaction. - Strong debugging skills to identify the source of the crash. - Familiarity with user profile data handling in Android apps. Pl...
...setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on
I require an easy-to-follow online watercolor painting course video, along with a captivating marketing reel, chiefly aimed at beginners with no prior knowledge of painting with Chinese watercolours. The principal goals are as follows: • for the reel - create a captivating reel that will drive engagement - Highlight the instructor's skillset - the reel will drive engagement on various social media platforms • for the videos - create easy-to-follow paint-along lessons with a theory block at the beginning and follow-along video of a lesson - ensure brushwork is captured with sufficient focus and detail - ensure video colours are true to life • for the day - give the artist sufficient advice on future filming (tools and their use) Assume a day’s fil...
...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product s...
I'm in need of a talented course designer to create a comprehensive program aimed at nurturing public speaking skills and language development in children aged 7-14. The course should focus on three main areas: speech and pronunciation, vocabulary building, and confidence building. Key course requirements: - Duration: It's desired for the course to run over 1 year, with a total of 30 lessons or sessions throughout the program. The ideal candidate for this project should have a strong background in both public speaking and education, with a focus on children's development. Experience in curriculum design, particularly for online learning, is a strong advantage. Effective communication and the ability to engage with children are also crucial. ...
We are an online english school looking for Native english teachers for individual courses. The courses will be starting immediately. Online individual conversation lessons. Each course will last 15 hours, 1 hour per week per student. Please get back to me for more information. thank you
...looking for a skilled developer to add a small module to my existing app built with PHP. The main functionality of the module will be user registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The ...
...folders Guidelines - As per Australian medical guidelines Ideas - List of ongoing topic ideas - Video Editing Needs: I require advanced video editing services, focusing on tasks like color correction and incorporating some special effects. Slight background music and some subtitles. - Timeline: The work will be ongoing and required on a weekly basis. - Weekly output example: 5 x reels, a 30 min course module & 2 x 3 min funnel videos - Deliverables: You will be responsible for delivering polished, professional-looking videos ready for social media posting. - Creative Input: While I will provide the raw footage and general direction, I am also open to creative input and suggestions for improving the videos. Ideal Skills and Experience: - Prior experience in advanced vide...
Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking
...students specifically preparing for the NEET exam. The primary goal of this course is to equip students with the necessary knowledge and skills to successfully pass the NEET exam. Key requirements for this project include: - Experience in developing educational content for college-level students, preferably in the field of Biology. - A thorough understanding of the NEET exam and its requirements. - Ability to break down complex concepts into easy-to-understand and engaging video lectures. - Good speaking and presentation skills. - Previous experience in creating video lectures, especially for online educational platforms, would be a great advantage. If you think you have what it takes to create a top-notch Biology course aimed at helping college students excel in their N...
Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).
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
...to develop a comprehensive golf course review platform that is akin to IMDb but dedicated exclusively to reviewing golf courses in depth. Key Functionalities: - User registration and login: Enabling members to create and access personal accounts. - Course search and filtering: Letting users perform refined searches based on different criteria. - Course rating and reviews: Providing users an outlet to leave their feedback and ratings on various golfing courses. - Live world and regional leaderboards: Offering up-to-the-minute rankings of the best golf courses worldwide and by regions. - User profiles: Granting users a personal space where they can view and manage their reviews, handicap, location, and golf club membership. Extra Features: - Personalized course...
I need to create full screen map using nextjs and map...full screen map using nextjs and mapbox The map have to cover full screen When a user click on a point on the map, the application will request a GeoJson dataset of points. Although the GeoJSON requested will be a whole dataset, the application should only display the pins within a 1km radius of the clicked point. Of course, the 1km is not fixed. I need a slider component that the user can change the radius of the circle, instead of 1km fixed. In project, don't use any other material library. You need to use Radix UI for further integration. Because my prev guy said he used headless (I'm not sure) UI. Also, It should be responsive for mobile and tablet.
I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the...
Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionali...did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you ...
I'm looking to create a WordPress website that will serve as a platform for listing both academic and professional courses. Courses will be paid, offering a revenue stream for the website. Key Requirements: - Wordpress Expertise: I need ...Courses will be paid, offering a revenue stream for the website. Key Requirements: - Wordpress Expertise: I need a professional who is well-versed in WordPress, and can ensure the development of a user-friendly and engaging website that is easy to navigate. - E-commerce Experience: As this website will be offering paid courses, knowledge of e-commerce integration and payment gateways is crucial. - Course Management: The platform needs to support the categorization and easy management of courses, both academic and professional. Similar :
...Your primary responsibility will be to carry out intensive product research, which will position my e-commerce business to take full advantage of market trends and competitive landscape. Your tasks will include: - Intensive product research on Amazon Even though you won't be analysing pricing trends, competitor analysis and customer reviews, you may need to delve into these aspects during the course of your work. Therefore, familiarity with these areas will be an added advantage. I anticipate that I'll need your services for more than 20 hours per week, therefore the ability to dedicate that amount of time weekly is crucial. Successful candidate should have excellent research abilities and a comprehensive understanding of the Amazon platform. If you are detail-or...
...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mo...
