Sql server interview questionsงาน

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 และ อื่นๆ เรามีความเป็นมืออาชีพ ทำงานเร็ว คุณภาพเยี่ยม คุ้มค่า คุ้มราคาแน่นอน ติดต่อเรา

...expert with XML -Authorizations -Risk Management -Process Controls I required a chatGTP bot created and data should be extracted and presented in XML format I need a proficient AI chatbot developer with exceptional knowledge of SAP and Risk Management. This AI chatbot is intended to interact with my company's customers and perform the following tasks: - Accurately answer frequently asked questions - Give dynamic product recommendations matching customer preferences or needs - Guide customers through risk management processes Although I am open to suggestions, my preferred platform is Chat. This project calls for a skilled developer, ideally with previous experience in designing AI customer service chatbots. You should be conversant with SAP systems and understand the nu...

I would like to receive a price quote for making phone calls according to the following details: Territory: Netherlands Number of records...stopped purchasing. We have prepared a dedicated link for filling in the results of the conversation. I am attaching the excel file with the records, the script of the conversation. (I translated it into Dutch on Google, it must apparently be proofread) The conversation must not be mechanical, the script is only for illustration. I have prepared several questions and answers in case it comes up in the conversation. For the purpose of the conversation, you work at Vista System Netherlands. Some of the records include several people in the same company, it is enough for us if you talk to only one of them. Thank You

I need assistance to solve three coding tasks using Python, Java, and SQL. The challenge involves - Analytical problem-solving - Implementing quality checks - Code compilation The challenges require proficient skills in the aforementioned languages, while also ensuring code efficiency. Prior experience in problem-solving and understanding how to efficiently check and maintain the quality of code is a big plus.

I'm in need of a skilled professional who can create a Terraform script to build my AWS infrastructure from scratch. Key Components: - The infrastructure should be deployed inside its own VPC in AWS - The infrastructure should deploy an RDS database, specifically MySQL, that is securely accessible from the backend and frontend servers, but not accessible from outside the VPC or ...RDS instances, EC2 instances, VPCs, and Elastic Load Balancers. - A background in MySQL database management is necessary for setting up the RDS. This project demands careful planning, a high level of security implementation, and scalability considerations. I'm looking for someone who can deliver efficiently and effectively and who can walk me through some of the Terraform script and/or answer ques...

Need fulltime laravel developer immediately individual developer only Minimum Experience- 6month to 2 year Database- mysql knowlegde Salary 10000 inr to 25000inr only Remote desktop interview on ruskdesk software mandatory coding interview

Skills -core php, laravel, Codeigniter my sql database Min 1 to 5 year experience location - Mohali,Punjab, India

I am in need of a skilled videographer for an interview-style promotional video, filmed indoors. The project will be focused on story-telling, requiring a cinematic and professional style. Requirements and Skills: - Proven expertise in indoor filming is essential - Exceptional understanding of lighting, sound, and various filming techniques - Ability to create and integrate graphics into filmed content - A strong portfolio with contents related to promotional video production Please include samples of similar projects you've completed in your proposal, particularly those that have incorporated graphics.

AWS to New cloud server migration-Django & Reactjs Server setup Code migration and setup SSL certificate - 1-year plan 50 /year

...Key Deliverables: - Develop courses on Radiation safety, Radiographic positioning techniques, Imaging modalities, Radiopharmaceuticals, and Therapies provided in Nuclear Medicine. - The courses should be designed for continuing education courses according to ASRT/ARRT and SNM self-learning guidelines. The courses should be provide in Word document form, providing references, test of at least 12 questions with answer key. Ideal Skills: - Proven experience in educational content creation, particularly in the field of Radiologic technology and Nuclear Medicine. - Strong knowledge of ASRT/ARRT and SNM guidelines. - Ability to structure content for self-study. - Excellent communication skills to convey complex information in an engaging manner. Please bid with your proposed approach...

I'm looking for someone who has very good experience in Laravel's real world situation. What Queue drivers are available in Laravel? Will ignore any ...Queue drivers are available in Laravel? Will ignore any replies without answering to the above my question. Here is my problem now. We are using Laravel project and it's running on production. It's using Queue heavily and queue driver is database now. We are getting following issue. SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (Connection: mysql, SQL: select * from `jobs` where `id` = 111111 limit 1 for update) Let me know how to fix this then I will hire you immediately and you can be employed in our project. Please don't waste my time if you don't know...

I'm in need of assistance with Codility assessments, specifically focusing on intermediate-level problem-solving tasks. Your work should encompass: - Expertise in SQL or Python. Familiarity with both languages is advantageous. - Proficiency in algorithmic programming, capable of thinking strategically to solve intermediate-level problems. - Ability to assist in solving three different task types in Codility, including: 1. Time complexity problems 2. Sorting and searching problems 3. Counting elements problems Ideal candidates would have experience preparing or mentoring for codility assessments and a strong background in programming. Your intricate knowledge of problem-solving within the realms of algorithmic programming would be highly beneficial. A methodical appro...

This is a Fulltime Project for Someone Speaking Excellent English And Spanish. 30-40 Hours A Week Hi, I am looking for a virtua...through Friday for a doctor's office long term (>12 months). Must have reliable internet. Duties include - data entry - translating over the phone - calling people to obtain information - scheduling appointments - responding to emails and voicemails - using a Slack like program You will have weekly meetings to answer any questions with the doctor (who is also bilingual). You will have access to a mentor/support team. You will be given scripts to use and specific questions to ask. You do NOT have to: scribe, create social media, create marketing emails, code, create graphics. You do NOT need to have any previous healthcare experience....

Job Description: Interview with invited users, the time is about 90 minutes Location: Staten Island Time: 16th 17th Compensation: $350

I'm in need of support in the area of employee recruitment. The optimal candidate will have a strong background in ...strong background in human resources, specifically focused on technology industries, and at a mid-level experience range. They must understand all stages of the recruitment process within the tech sector and leverage their experience to effectively screen and source ideal candidates. Tasks would include: - Job posting and promotion - Resume screening - Candidate assessment - Coordination of interview processes This role requires great communication skills and a deep understanding of the tech industry, ensuring we attract the best talents in the field. Fluent English, both written and spoken, is crucial, as well as a proven track record of successful recrui...

I urgently need an expert Laravel developer to collaborate on a web application development project. The specific features and ...an expert Laravel developer to collaborate on a web application development project. The specific features and functionalities of the project are yet to be defined, but a vast knowledge in Laravel is key. Key skills and Experience: - Proficiency in Laravel and PHP - Understanding of MVC design patterns - Knowledge of front-end technologies, such as JavaScript, HTML5, and CSS3 - Familiarity with SQL/NoSQL databases - Excellent problem-solving skills The timeline for this project is ASAP, so the ability to work under pressure is required. If you have experience in web applications, APIs, or both, it will be advantageous. Let's collaborate on this ex...

...project would have a solid understanding of Python, machine learning, NLP, and experience with BERT models. Features of the Python Script: - Process text queries obtained from a CSV file (example CSV attached) - Detect entities such as: - Persons - Places - Events (e.g., weddings) - Dates - Number of individuals visible - Media type (Image, Video, Audio, Text) - Detailed type (Interview, Landscape, Close Up, Group, etc.) - Length - Content - Retraining should be based on a provided CSV file containing Sentence, Entity, and IOB Tagging training data. The model does not need to be trained - only provide the capability. I am looking for a detailed and accurate script that can efficiently process the data and train mobileBert to identify the entities within the...

I need a pro that can explain me how server actions work I have already a boilerplate project and a task to put a user in a user group we will work over screen share as a consultant First trial hour price

I need a pro that can explain me how server actions work I have already a boilerplate project and a task to put a user in a user group we will work over screen share as a consultant

I need a freelancer to analyse three different types of vision transformer models: ViT, DeiT, and CCT. The evaluation must fo...and Diabetic Retinopathy. The key objective of this project is to pinpoint the most efficient model for the task at hand. Skills and Experience: - Proficiency in working with ViT, DeiT, and CCT models. - Strong background in analysing classified images of eye diseases. - Proven record of implementing different vision transformer models for disease classification tasks. These are the research questions I need in my research 1. Which eye diseases may be detected using the primary classification image models? 2. Which datasets are used by vision transformer models, and what are their typical advantages and disadvantages when it comes to diagnosing eye c...

I'm currently facing an issue with high CPU usage affecting my server. This has led to a significant slowdown in my website's performance and I am needing an experienced Laravel developer to assist in resolving this. Key responsibilities will include: - Diagnosing the root of the high CPU usage - Implementing improvements to rectify the issue Regarding server load, I've not been able to identify the precise figures. This project does not involve working with any established caching mechanisms as none are currently being used. Essential skills and experience: - Proficiency in Laravel - In-depth understanding of server operations and CPU usage - Proven record of successful server optimizations - Familiarity with CyberPanel and OpenLiteS...

I'm looking for an expert in Power Apps to enhance my project with additional functionality. As with most Power Apps endeavors, this one aims to automate processes, create a mobile app, and manage data and workflows. The project has a broad scope and I need a detail-oriented professional who can ensure everything runs smoothly. Despite skipping a few questions about the specifics, I will provide complete details once we start our discussion. Ideal Skills: - Extensive experience in Power Apps - Strong understanding of automation processes - Excellent communication skills - Attention to detail - Ability to integrate systems - Experience in mobile application development - Proficiency in data management and workflows

I need a simple form that will look good on a small screen iPhone and also a big screen iPad. The form will collect NAME EMAIL CITY PHONE NUMBER phone number will be a formatted 10 digit max, and email will need validation for properly formatted. This will take the data and post it to our existing base and ...then auto redirect to the form page. The form page will look neat and clean and also contain a couple lines of text and our logo. You will use the existing config file to connect to our base, instead of creating a new one. This project needs completed today and should only take an hour to complete. This is to be written in php 8.2 and connected to sql dbase. You will be paid $30 when it is complete and verified to be working on our server. Ping me if you can co...

...take part in my ongoing web development projects. The main goal of the project is to enhance an existing application. Requirements: - Proficiency in .NET for backend development - Strong experience with Angular for frontend development - Excellent understanding of SQL Server and MongoDB databases - Previous work with DevExpress is essential Your responsibilities will include: - Developing APIs using .NET for enhancing the application - Integrating Angular for improving the frontend - Ensuring seamless operation with SQL Server and potentially MongoDB Ideal candidates should have a strong understanding of web development and be able to contribute effectively to enhancing the current state of the application. The ability to work with a team, meet deadline...

...professional that is done very fast. Right now I have 37 short clips that need to be converted from 16:9 format to YouTube shorts format (9:16, 1920x1080px) In these videos you can see interview clips of two people sitting at a table. There are a total of three camera perspectives: - Presenter - Interview guest - Both at one table This task is about adapting the scenes by recutting the image in which both people can be seen at the table so that - the person speaking is always shown and - the reaction of the interviewee is briefly shown in the case of special reactions The overall result is that these interview sequences should be prepared for YouTube Shorts/TikTok in a high quality, in which the conversation has a high entertainment value and the images ...

I'm looking for a skilled Odoo developer who can help me seamlessly integrate Magento 1.9's user authentication with my existing Odoo 16 installation. Key Requirements: - Allow Magento users to log in to Odoo using th...efficient and secure solutions. If you have the necessary skills and experience to undertake this project, we encourage you to submit your proposal outlining your approach, relevant experience, and estimated timeline for completion. We are committed to finding a reliable and competent developer who can deliver a high-quality solution that meets our requirements. Please reach out if you have any questions or need further clarification about the project. We look forward to working with you to achieve a successful integration between Magento and Odoo for ou...

I'm looking for a creative graphic designer to help me craft a logo for my soon-to-launch our brand, "HIZLIODAN". This logo is crucial to establishing my brand identity and setting the ...attached a sample logo for your reference, which should give you a sense of the style I'm aiming for. However, please note that I'm looking for a unique design, not a replica of the attached file. Deliverables: - I'll need the source file of the final logo, and it should include all the fonts and elements used. This will be important for future branding and marketing efforts. If you have any questions or need further clarifications, please don't hesitate to message me directly. I'm looking for a designer who can bring my vision to life and help me make a st...

I'm looking to have a Python API built to generate a multiple-choice question bank for schoolchildren in various subjects (such as Mathematics and English) using AI APIs like ChatGPT. The API should allow for different difficulty levels for the questions. Key Requirements: Development in Python. The API should possess the following functionalities: Input Parameters: a. Users will specify the number of questions needed in one set. b. Users will indicate the topic of the questions. For example, if they want a question bank on Mathematics focusing on BODMAS, they will provide keywords like "BODMAS." Users can provide multiple keywords such as "BODMAS," "Ratio," "Percentage," etc. Similarly, for English, keywords could includ...

I have a PDF file containing a combination of scanned images and text. I need a Word file that mirrors the content of specific pages/sections of this PDF. This job requires the freelancer to: - Convert specific sections or pages from a PDF document into a Word file - Ensure that the Word file is formatted as a standard document, without any additional customiza...the Word file is formatted as a standard document, without any additional customization. Ideal candidates will have experience in: - PDF to Word conversion - Handling a combination of scanned images and text - Understanding and following instructions accurately Your work should be thorough and accurate, as the converted Word file will be used for further processing. Feel free to ask any questions if you need further in...

I need a pro that can explain me how server actions work I have already a boilerplate project and a task to put a user in a user group we will work over screen share as a consultant

I'm looking for a professional to convert 1000 + questions I have in Word format into Ailken format. The main reason for this is that I'm creating a quiz and need the questions in a specific format that I can easily work with. Your job is not only to convert them but also to find the answers for all the questions. This can be done using Chat GPT or any other suitable tool you're comfortable with. To ensure the correctness of the answers, I prefer a combination of manual review by experts and automated checks. Key Responsibilities: - Convert 1000 questions from Word to Ailken format - Source answers for all questions using Chat GPT or similar tools - Verify the correctness of the answers through a combination of manual review and automated ...

Hi, Job Title: Senior Developer - SQL Server Analysis Services Experience : 5+ Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, exce...

I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.

Hi, We are an educational service provider. We are looking for a freelancer who can create unit wise multiple choice questions and share in Google docs. The syllabus of the NTET is attached. Please share your proposal with at least 5 MCQs on any topic of the attached syllabus. The best submission will be awarded the project. Language - English or Hindi Min MCQs per unit - 500 Total units - 8 Total MCQs - 4,000 Deadline - 7 days

...on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you 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 y...