Sql server practice exercises with solutionsงาน

1.พัฒนานะบบ IOT ดึงข้อมูลจาก PLC แล้วนำมาแสดงผลในรูปแบบ Web Site โดยแสดงข้อมูลเป็น Real Time 2.สามารถใช้อุปกรณ์ของของบริษัท (Embedded PC) มี SIM ออก Internet ได้ หรือสามารถใช้อุปกรณ์ที่ผู้พัฒนาถนัด แต่ต้องเป็นอุปกรณ์ที่ทนต่อสภาพการใช้งานในโรงงานครับ (ความร้อนและฝุ่น) 3.สามารถใช้ Server ของบริษัทได้ สามารถเลือกได้ตามความถนัดแบบ Windows / Linux และ Database SQL , MySQL, MogoDB , InfluxDB เลือกได้ตามความถนัดครับ 4.เก็บข้อมูลไว้ดูย้อนหลังได้ 90 วัน

ทำระบบการเลี้ยงปศุสัตว์ (Livestock Management) นำเสนอเบื้องต้นของ Development Tools: Front-end: Angular JS Language: .Net Core (Web responsive) Database: SQL Server/Azure SQL Database Operation System: Windows Cloud Solution :Hybrid Azure

ติดตั้ง VOIP SERVER เพื่อใช้โทรศัพท์สายในและสายนอกบน Linux

ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login

...เป็นงานระยะยาว ระยะเวลา 6 เดือน – 1 ปี c. การเชื่อมต่อกับระบบเดิม เชื่อมผ่าน MS SQL Server และ REST Api รูปแบบข้อมูล JSON ทั้งหมด d. การแก้ไข ระบบเดิม จะทำโดย programmer คนเดิม ไม่เกี่ยวข้องกับระบบใหม่ e. Source code และสิทธิ์ใน source code ทั้งหมด เป็นของผู้ว่าจ้าง f. ผู้ว่าจ้าง ต้องการเข้าถึง repository ของ source code ด้วย เพื่อประโยชน์ในการ review ป้องกันการสื่อสารผิดพลาด g. Platform NodeJS และ deploy บน Docker หรืออื่นๆ ที่เป็นรูปแบบที่คล้ายกัน h. แยกส่วนแสดงผล (client javascript) และส่วน Api (REST Api อย่างชัดเจน) 2. ระบบเดิม เป็น program บน Windows เป็นภาษา C# .Net framework และ MS SQL server a. เมื่อสั่งซื้อสินค้า จะสร้างข้อมูลการสั่งซื้อใน MS SQL Server และมีใบ PO ออกมา b. เมื่อรับออเดอร์แล้ว จะสร้างข้อมูลใน MS SQL Serve...

ต้องการ programmer สามารถเขียนคิวรี่ SQL และทำ report ระยะเวลาจ้าง 1 เดือน มานั่งทำงานร่วมกับ Programmer ของบริษํท ที่ทำงานตั้งอยู่ที่ปากซอยเพชรเกษม69 Victoria Garden ติดต่อที่ คุณท็อป [Removed by Freelancer.com Admin]

โปรแกรมสามารถแสกนลายนิ้วมือได้ โดยเชื่อต่อกับ SQL Server เมื่อลงเวลาออกสามารถ auto export file เป็น text ออกมาได้ (ต้องมีการคุยรายละเอียดกันอีกที)

Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL

- พัฒนาโปรแกรมโดยใช้ภาษา ASP.NET C# , Microsoft SQL Server - พัฒนาระบบเป็น web base application โดยมีเพียงส่วนของ UI และ Call Method ผ่าน Web Service - ไม่มีส่วนของ database design ,database create , database retrieve, database update , database delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้...

การทำงานตามคลิปที่ส่งให้ดูครับ เรื่องการออกแบบก็ประมาณนี้ -สามารถสมัครสมาชิกได้ (แยกระหว่าง user และ owner / loginด้วยfacebook ได้) -ทำงานเสร็จสามารถส่งไฟล์ทั้งหมดเช่น sql api apk อื่นๆ เพื่อการพัฒนาต่อไป -เพิ่มร้านค้าและเมนูเองได้ทีหลัง

...เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว 7. ระบบปาร์ตี้ ให้สามารถมองเห็นหลอดเลือดของคนในปาร์ตี้ และตำแหน่งปาร์ตี้ในแผนที่ 8. ทำคู่มืออธิบายวิธีการใช้งานสิ่งที่ทำมาคร่าวๆครับ ใครสนใจเสนอราคาค่าจ้าง และประวัติผลงาน มาด้วยนะครับ

ค่าจ้างตามตกลง Programmer C#.Net MS SQL HTML etc.

Build a Easy website with codeigniter+sql. Built it as easy as you can. สร้างเว็บไซต์ด้วย codeigniter+sql.

Software and Application OCR Scan or Take Photo of Document OCR TO SQL

PBX System SIP Server on Cloud สำหรับธุรกิจขนาดกลางและเล็ก โดยไม่ต้องลงทุนอุปกรณ์ Server PABX PBX ต่างๆ ไม่ต้องเตรียม infra ให้ยุ่งอยาก เคลื่อนย้าย ไปตาม Site สะดวก โทรหา site to site ฟรี บริการค่าโทรแบบเหมา แบบรายนาที ทั่วโลก

รับเขียน ออกแบบ แก้ไข software ทุกประเภท ทั้งงานทั่วไป และ ในโรงงานอุตสาหกรรม ประสบการณ์ใน บริษัท และ โรงงานอุตสาหกรรม มากกว่า 10 ปี -VB -Delphi -MS SQL -Oracle -MS Access -Barcode reader, RFID - อุปกรณ์เชื่อมต่อกับระบบคอมพิวเตอร์ I/O Card, Machine controller และ อื่นๆ เรามีความเป็นมืออาชีพ ทำงานเร็ว คุณภาพเยี่ยม คุ้มค่า คุ้มราคาแน่นอน ติดต่อเรา

I'm experiencing an issue where my website isn't loading. Thi...where my website isn't loading. This problem has emerged recently, without me making any recent changes to the website or server configurations. I need a skilled professional to help me quickly troubleshoot this issue and get my website back online. Your role will involve: - Investigating and identifying the root cause of the website's failure to load - Resolving the issue effectively and efficiently - Ensuring the website operates smoothly post-fix Ideal candidates should have extensive experience in troubleshooting websites that run on Apache servers. Strong familiarity with PHP-FPM and Webmin will be a significant advantage. Your ability to identify and remedy server issues swiftl...

I'm looking for a skilled UX Developer who can take my website to a new level. The project's main goals are to enhance user experience, improve site usability, and increase customer engagement. It's a development greenfield, which means creativity and innovative solutions are highly appreciated. The target audience for my website is professionals, so the interface should reflect a high level of professionalism while maintaining user-friendly navigation and design. Skills and Experience Needed: - UX Development - User Interface Design - Creativity and Innovation - Understanding of Professional Audience's Preferences and Requirements - Website Usability Enhancement.

...Presley. It's intended for a radio show, so integration with MP3 is essential. Key Requirements: - Conversational AI: The primary aim of this project is to have an AI that can engage in meaningful and charismatic conversations similar to Elvis Presley. The AI should be able to handle various topics and respond naturally to user input. - Natural Language Processing (NLP): It's crucial that the AI incorporates advanced NLP techniques to ensure its responses are coherent, contextually relevant, and sound like Elvis. Ideal Skills: - Experience with creating conversational AI interfaces. - Proficiency in Natural Language Processing. - Familiarity with integrating AI solutions with MP3 platforms. Please include in your proposal your experience ...

I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are highly appreciated.

I am Building AWX Server on AWS EC2 Here is the method I am using: So far, I have: I have already Created an EC2 instance for this server. Cloned the AWX Repo, I have completed all installations required (installed Docker, Docker-Compose, I have used pipx to install the Ansible package) I need help with the rest of the instructions from that link. I am building this server in VS Code Ideal skills for the job include strong understanding of AWS, proficiency in AWX tasks and familiarity with Ubuntu server.

...YouTube channels, particularly in the lifestyle niche. - Strategy: A well-thought-out plan to boost subscriber numbers is crucial. Your Expertise: - Experience: Prior experience in driving subscriber growth is essential. - Knowledge: An understanding of lifestyle content and its audience would be a significant advantage. - Creativity: Innovative solutions to engage viewers and attract new subscribers are highly desired. Please come forward with your detailed proposal. I'm looking for a viable strategy that doesn't break the bank but can lead to substantial channel growth....

I'm preparing for the Azure AI 102 exam and specifically looking for help with the Natural Language Processing section. I need a comprehensive set of practice questions and answers specifically tailored to this area. Key Requirements: - Development of practice questions and answers: These should cover a broad range of topics within Natural Language Processing, aligning well with the exam's requirements. I need help in some questions and answers with right explanations

...industry through innovative AI solutions. We aim to empower musicians, artists, and producers by providing them with advanced tools to enhance their creativity and productivity. **Job Description:** We are seeking a talented and experienced AI Developer to create an advanced AI Music Lyrics Generator. This bot will be capable of analyzing uploaded instrumentals and generating both the lyrical flow and content to match the music. The lyrics produced must be clean and suitable for audiences aged 18 and above. **Key Responsibilities:** - Develop and implement an AI system capable of generating music lyrics based on uploaded instrumentals. - Ensure the AI-generated lyrics are clean, appropriate for all audiences, and align with the given instrumental. - Collaborate ...

...but you must be clever and eager to learn. No. I am *not* being charitable. I am being 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 $2...

...Frontend: React (JavaScript) - Backend: Node.js - Services: Python - Database: MySQL RESPONSIBILITIES: - Integration of new B2B APIs - New payment gateway integration - - Implementation of bug fixes and performance improvements. - Regular software updates and security patches. - Feature additions and enhancements. Skills and Experience: - Proven experience in maintaining e-commerce solutions. - Proficiency in React, Node.js, Python, and MySQL. - Strong problem-solving skills. - Excellent understanding of software best practices and design patterns. - Ability to work independently and meet deadlines. - .NET and are a plus but not a requirement. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2)

La saisie de données est un aspect crucial de nombreuses opérations commerciales et administratives, impliquant la conversion d'informations analogiques en données numériques. Ce processus peut inclure la transcription de textes à partir de documents scannés, de formulaires manuscrits ou de fichiers PDF, ainsi que l'entrée de données numériques telles que des chiffres, des montants financiers ou des codes dans des feuilles de calcul ou des bases de données. La nature de la tâche nécessite des compétences telles que la rapidité, la précision, une connaissance de base de l'informatique et une grande attention aux détails. La saisie de données trouve des applic...

...detailed incident report - Provide recommendations for enhancing DDoS mitigation capabilities, incident response processes, and overall security posture - Collaborate with client stakeholders, including IT security teams, network administrators, and executive leadership Qualifications: - Minimum 5 years of experience in cybersecurity consulting, with a focus on DDoS protection, incident response, and security assessments - Strong knowledge of industry standards and frameworks, such as NIST, ISO, SAMA CSF, NCA ECC, and GDPR - Hands-on experience with security technologies and tools, including firewalls, IPS/IDS, SIEM solutions, and network analysis tools - Expertise in forensic analysis, malware analysis, and incident response procedures - Excellent communic...

...an Error 500 issue that's occurring when users access my website. The error seems to be an 'Internal Server Error', but I'm not sure what's causing it or how to fix it. Key Tasks: - Identify the root cause of the Error 500 - Implement a solution to resolve the issue - Provide recommendations to prevent similar errors in the future Ideal Skills and Experience: - Extensive experience with WordPress - Proven ability to troubleshoot and fix Error 500 issues - Familiarity with server configurations and potential causes of Internal Server Errors - Strong problem-solving skills to identify and resolve the root cause of the issue - Good communication to explain the issue and recommended solutions in a way that's easy for...

I'm seeking a Python expert to develop a solution for a reso...efficiently solve the classic Knapsack Problem. - You will also be required to incorporate LP models in the solution to enhance the resource allocation process. Skills & Experience: - Proficient in Python for algorithmic problem-solving and have a solid understanding of optimization techniques. - Experience in working with LP models and understanding of how to apply them in real-world resource allocation problems. - Previous experience in developing command-line interfaces for solutions - as this project does not require a GUI. The ideal freelancer for this project is someone who has a deep understanding of the Knapsack Problem, LP models, and has the ability to translate this knowledge into an effici...

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.

Hello, I am looking for a branding expert for a spiritual hypnosis practice. If you have no experiemce in spirituality or this type of design, please dont respond. If so, show relevant portfolip

I'm seeking a skilled developer to bring my Shopify design to life. I'm launching a physical product and have a design crafted for...the website. - eCommerce experience: You must have experience setting up online stores for physical products. - Problem-solving: Able to strategize efficient solutions for any potential technical issues. - Attention to detail: My design is specific. I require someone who can follow instructions closely and realize my vision perfectly. Please note, I didn't specify requirements for Shopify specific features, so the initial development of the website won't need these features. However, the ideal candidate should have the capability to implement such features in the future, should the need arise. Looking forward to collaborating...

I'm in need of a skilled and experienced developer that can assist me in automating several tasks, organizing files and data on Google Drive using Google App Script and Java programming l...organizing files and data on Google Drive using Google App Script and Java programming language. Key Tasks: - Create scripts to automate Folders and files - Improve file organization and management on Google Drive - Develop custom solutions using Java Ideal Skills: - Proficient in Google App Script and Java - Strong background in automating tasks - Proven experience in organizing and managing files - Prior experience with Google Drive is a plus Your expertise and knowledge in these areas are crucial for the success of this project. Looking forward to collaborating with a pro...

I'm seeking a Minecraft expert to help me set up a survival mode Minecraft server. Key Project Details: - **Survival Mode Setup**: The primary focus of this project is to create a distinctive survival mode suitable for a smaller player base. - **Unique Items**: I will need engaging, custom, and unique items for players to discover and utilize in the game. - **Crate Rankups Integration**: I also want to include a crate rankups system to add a layer of progression and reward for players. Ideal Skills and Experience: - **Minecraft Server Administration**: Experience in setting up and maintaining Minecraft servers is a must. - **Plugin Development**: Proficiency in developing Minecraft plugins is highly desired, specifically for creating custom items and integrati...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I'm in need of a skilled developer who can create algorithms and data structures to solve a specific problem related to numerical data analysis. Key Responsibilities: - Develop algorithms to process and ana...structures to solve a specific problem related to numerical data analysis. Key Responsibilities: - Develop algorithms to process and analyze numerical data efficiently. - Implement new functionality to enhance data processing capabilities. - Solve the specific problem we're facing with the data through the algorithms you create. Ideal Candidate: - Proficiency in algorithms and data structures. - Prior experience in creating solutions for numerical data analysis. - Strong analytical and problem-solving skills. - Familiarity with relevant programming la...

We are in the middle of migrating Django to a new server. - Both servers run Ubuntu 20.04, postgres 12, python2.7 - The Django Project is already transferred over - Nginx has been configured - Postgresql has been setup Our struggle is to get the actual application up and running again. Your job will be to: - help to perform a clean export of the postgres database on old server - help to import the postgres database on the new server - ensure the Django application is coming back up smoothly The work will be done using shared tmate ssh sessions.

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

...specific keywords in the Middle Eastern region, primarily in Iran. The main goal is to increase traffic to my website. This project will be focused on keywords related to English learning and test preparation; such as IELTS, TOEFL, English speaking, quick conversation, easy conversation, learning English, fast English, and English speaking practice. Key Requirements: - Proven experience in SEO, particularly in the Middle Eastern region - Familiarity with the Iranian market and search engine habits - Expertise in optimizing websites for increased traffic - Previous success in improving rankings for educational and language learning websites The ideal candidate should be able to understand the nuances of the Middle Eastern market, particularly in Iran, and tailor the SEO ...

...experiencing an issue with my IIS 8 server. Specifically, I'm unable to reflect image updates across the server. Key Requirements: - Troubleshoot IIS : You should be experienced with IIS and capable of identifying and resolving server-related issues. - Server Configuration: The problem may be related to server settings, so a deep understanding of IIS configuration and management is desirable. - File Management: The issue seems to be related to file update. You should have expertise in managing files on Windows servers and diagnosing related issues. - Image Handling: The problem specifically pertains to image updating. You should be well-versed in how servers handle image uploads and updates. Your task will involve: 1. Diagnosing ...

I'm on a quest to flatten my company's efficiency curve and reduce the hours we spend on manual tasks. I need a savant familiar with Power Apps to help me achieve this. Skills Required: - Proficient in Power Apps, preferably with experience in teaching others. - Able to develop advanced, customized solutions tailored to my business. - Expertise in leveraging Office 365 integrations within these solutions. - Proficiency in constructing complex, efficient databases. The ideal candidate should have a comprehensive grasp of Power Apps and a passion for education. Seeking to build a one-on-one relationship that will deliver measurable results on the path to automation.

...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 advantageous. I value clean, user-friendly interfaces that can handle the detailed tasks required. Be ready to suggest the best...

I'm looking for an expert ...system. Key Responsibilities: - Develop a system for order processing and tracking to ensure smooth operations - Implement inventory management solutions to prevent stockouts or overstocking - Enable price monitoring and adjustment features to stay competitive Ideal Skills and Experience: - Previous experience in setting up Amazon dropshipping businesses - Proficiency in automation tools and software - Solid understanding of ecommerce and dropshipping best practices - Strong analytical skills for monitoring and adjusting prices - Excellent problem-solving abilities to manage inventory effectively If you're a proactive, detail-oriented freelancer with a talent for automation and a strong grasp of the Amazon dropshipping business model,...

...YOU DON'T WRITE MANUALLY !!! What we offer: *Writing work at the entry rate of $20/1000 words with room for growth. *Flexibility: No Skyping, no phone calls, accept projects when you have the time to complete them, take time off when you need (letting us know in advance is good practice). *Easy to work with: We reply to questions fast, will provide valuable input and feedback on every single task you complete. *We've been in the content writing and marketing business for 15 years and have worked with more than 2000 clients. As part of our team, you'll have the opportunity to learn from experienced team members on a daily basis. What we expect: *You'll be part of an International team with a base in Serbia that works for m...

I am in search of a skilled .NET Core developer to work on a project for me. As the client, I'm looking for someone who can bring the following to the table: - Proficiency in .NET Core: Given that my project is based on this technology, familiarity and experience with it is a must. - Application Development Experience: Previous experience in developing web applications would be particularly beneficial. - Strong Problem-Solving Skills: The ability to troubleshoot issues and devise solutions is key. - Attention to Detail: It's important that our project is implemented correctly and accurately. The ideal candidate for this project would be someone who understands the nuances of .NET Core, has a good track record in application development, and can work efficiently to...

I am looking for a proficient full stack developer to help with a personal project. Using NodeJs and NextJs with MYSQL DB, your skills will include: - Expertise in utilizing NodeJs and NextJs - Develop a user-friendly platform - The ability to brainstorm and bring creative digital solutions - Strong problem-solving skills - Understand project requirements and deliver high-quality work - Should be proficient in using Github with AWS and coordinate with infra team member for coordinated push - Understands and knows the importance of proactive communication Expectations: - Your primary responsibility will be to design and develop the application, and to coordinate with the rest of the team working on different layers of the project. - Daily co...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

I'm currently in need of an AI Engineer, specifically experienced with Python, to resolve some issues related to our RAG architecture and vector similarity search. Here's a general overview of the project: - Troubleshoot and resolve issues in the RAG architecture - Enhance the efficiency of the existing vector similarity search - Implement suitable solutions for seamless integration with other systems Ideal candidates should have: - Strong background in AI and experience with Python - Prior experience with RAG architecture and vector similarity search - Excellent problem-solving and troubleshooting skills - Good communication and ability to work in a team Your contribution will be crucial to the overall performance and functionality of our sys...

As the main user of a system integrated with Google Sheets and Zapier, I'm currently grappling with some performance issues. Concretely, there's a challenge with incorrect data output from our automated data and workflow program. I'm seeking an expert to: • Conduct a thorough audit and maintenance of our data-entry automation and workflows • Identify the root cause of the inconsistent output, and provide tailored solutions • Enhance the reliability of the system overall to prevent any future issues. Presenting a solid proficiency in Google Sheets, Zapier, and workflow optimization, your skills will indeed come in handy for the successful troubleshooting, rectification and enhancement of the system. Efficiency and a keen eye to det...