Sql server interview questionsงาน

...people I need found. The successful candidate should have a deep understanding for finding and reaching out to the appropriate contacts. The scope of this project includes: - Identifying 50-75 relevant and potential companies who typically use radio (or other mediums) as a means to sponsor and/or advertise operating in the ( the companies do not necessarily have to be in the entertainment or interview relevant sectors but it''ll be preferential) who could act as sponsors or advertisers for my radio show which enjoys a wide listenership of about 33 million and being widely syndicated throughout the country. The information required includes the name of the company, contact information of the decision-maker in charge of advertising or sponsorships, telephone number a...

I am looking for an accomplished expert or team in Lineage 2 server setup to establish a Gracia Final version. Requirements: * Experience with setting up Lineage 2 servers, particularly the Gracia Final version. * Understanding of and experience with the mixed PvP/PvE server settings. * Capability to configure server for players to start at Level 1. * Native donations with auto inventory fills * Custom items, skills, quests, NPCs + This project requires a keen attention to details and exceptional knowledge of the mechanics of Lineage 2. Your expertise will ensure a smooth and efficient setup process.

I'm currently seeking an expert in deep learning and TensorFlow, specifically skilled in the construction and fine-tuning of Convo...learning model predictions. Frontend development skills to create a simple user interface for uploading chest X-ray images and displaying model outputs. The project has significant potential for impact in the field of medical image analysis, and I'm excited to collaborate with a skilled freelancer who can help bring it to completion. If you're interested in taking on this project or have any questions, please feel free to reach out. I'd be happy to provide further details and discuss the scope of work in more detail. Looking forward to hearing from you soon , project link :

I am looking to set up a technology-focused podcast featuring interview-style episodes. It needs to be general and universally accessible, meaning it should be available on platforms like Spotify, Apple Podcasts, and Google Podcasts. The following skills and expertise are desirable: - Experience in podcast production - Proficiency in audio editing and post-production - A tech-savvy mindset to understand and discuss technology topics - Ability to scout and secure guests for interviews Deliverables include the full production of regular episodes, uploading and distribution across platforms, and ensuring smooth running of each interview session. The ultimate goal is to create an engaging and informative podcast for technology enthusiasts. I look forward to working with profess...

Hello Dear Client, I understand your requirements. Please message me so we can discuss any important questions and proceed with the work as per your needs. Kindly message me about the project so we can start the discussion. Thanks:) Best regards Najmul Hasan

****Apply Only if you are Zendesk certified and have done Ai chatbot in zendesk/ have similiar case study **** Hi have 10 gb of past email conversation data.I want to create ai chatbot on zendesk to automated the support. *Note- you previous project of ai zendesk bot and your zendesk certification apply in you are Zendesk certified and have a case study of previous client for Ai zendesk chatbot.

Please give a viral and unique idea for a Minecraft server so that everyone will enjoy it and players will play for a long time

Description: I am in need of a skilled developer who can create a Twitter scraper capable of gathering data from user profiles based on specific keywords present in their bios. The primary keywords of interest ...developing Twitter scrapers or similar web scraping projects, please reach out and let me know your capabilities. I am open to discussing any technical details or specifications to ensure that the scraper meets the requirements effectively. Please provide information on your previous experience with web scraping and any relevant projects you have completed. Also, let me know if you have any questions or suggestions regarding the project scope. Looking forward to collaborating with a skilled developer who can deliver quality results in a timely manner. Thank you for your...

As part of a major overhaul of my WordPress website, I am seeking an experienced web designer proficient in WordPress to do some considerable changes to its layout and features. The key areas of focus include but are not limited to: - Layout Modifications: Alter appearanc...I have no specific preference in terms of the application from the freelancers, but demonstrable competence in WordPress and a keen eye for design, layout, and the user experience will be key factors for success in this job. The completion deadline for the project is flexible at this stage but should be stated upfront along with your proposed plan of action. Please note that skipping all questions does not offer precise information but these are the generic requirements for handling a WordPress customizatio...

I'm seeking an experienced Server Management Specialist, who predominantly manages 35 servers and is skilled in Cassandra, Elastic Search, and MySQL (Jira docs). Comfort with Jenkins and Linux is critical. Ideally, our selected freelancer possesses strong communication skills and exhibits an ability to identify key infrastructure resources rapidly. The scope of tasks includes, but not limited to: - Routine maintenance and updates - Troubleshooting - Problem resolution - Installation and Configuration My project is focused on making frequent updates to resources found in Jira and app-status.ot. It is imperative that the freelancer is able to check emails regularly to stay current with any urgent alerts. Please consider this a long-term project opportunity if found s...

...UNDETECTABLE AI AS WE STILL SEE - DON'T WASTE YOUR OR OUR TIME IF YOU DON'T WRITE MANUALLY !!! What we offer: *Ad-hoc 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 Internat...

...table, but greatly value the creative input from an expert. - Website build - I am starting from scratch, so you will be responsible for the full build of the site. - E-commerce integration - Crucial to this project is the integration of an e-commerce platform. - Customer/Member area - The end user is going to sign up, create effectively a profile from some simple questions we would ask them (This is business profile and questions will be about certain policies they have in place etc). This will be an area that we can upload them purchased documentations and accreditation certificates that we assist them obtain. Obviously I will advise more information to the awarded developer(s). Skills and Experience: - Experienced in website layout and design. - Nice, modern, super cl...

Looking for a SQL Expert who is good with Transact SQL, stored procedure and expert with MS SQL server. Task is related to trigger and XML and should hardly take one day to complete

I run a popular Instagram blog where we I want to start covering Entertainment business topics. It will be a mixture of popular things in Pop Culture and Business. I need someone that can come up with very interesting post ideas for my audience. It can be: -Informative -Questions to the audience -Hypothetical scenarios to get their opinion -Comparisons  It needs to be post ideas that non business lovers will be interested in engaging in.  This is why its important to come up with topics that matter to pop culture fans. Here Are Some Quick Examples Of Post Ideas: -If you had 100k to invest in one of these stars careers, who would it be? - Which do you prefer... Stock X and Goat? - What are some current hot stocks that you would invest in long term? - New Business Ow...

I have a webform developed in HTML5, PHP, SQL, and JavaScript. I'm looking for a developer to make a few key improvements. PRE-BUILT I have currently built a where the user selects a customer from a dropdown and selects the number of products to add to this order. Each customer from an SQL table called 'customers' has its own price class 'customerPriceClass' When the user selects the number of products, the page updates and adds rows for each product with a dropdown menu where the choices are fetched from another table called 'products'. The user selects the product and enters the number of units. NEEDED: STEP1 For each row of products the corresponding price from the table 'prices' should be fetched that is associated with t...

...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...

...servers on Linux systems. The primary goal is to streamline the game server setup process, reducing manual setup and configuration time. The script should handle the entire setup process, from initial server preparation to the final game server launch. Script Requirements: — Automated Deployment: Automatically download, install, and configure game server software. — Configuration Management: Scripts should read from config file — Compatibility: Must run on Ubuntu — Security: Incorporate basic security settings to protect the server. — Efficiency: Minimize resource usage during setup to not impact server performance. Skills Required: — Proficiency in Python or Bash scripting under Linux environments. — U...

I need an experienced C# developer to create an advanced contact form for my existing website and execute its storage function by integrating it with MS SQL Server. Key Requirements: - Development of a contact form with fields for Name, Email, Phone number, and Address. - Form validation should be included to ensure data input integrity. Specifically: * Email format should adhere to standard email format * Phone number input should match a predefined format. Preferred Skills: - Proficiency in C# and MS SQL Server - Experience in form creation and data validation - Attention to detail for error-free functionality.

I am looking for an expert who can aid with the design and development of an SQL database and a coherent PHP framework. The ideal candidate should have extensive experience with: - Designing efficient SQL database structures for small-scale databases (less than 1000 records). - Writing comprehensive SQL queries. - Effectively integrating PHP with SQL databases. The purpose of this project is to utilize SQL and PHP to innovatively design and construct a web application. The applicant should have a strong track record of building successful, high-performing web applications. Emphasis will be placed on the ability to manage and manipulate small-sized databases. Given the nature of this project, a meticulous approach to data management and a keen eye for de...

I am seeking an expert with at least 5 years of experienc...interviews. Your expertise will be pivotal in preparing me for a real tech interview. We will discuss the number of mock interviews needed during our first meeting. Importantly, each mock interview is expected to last for an hour. Key responsibilities are: - Preparing and conducting mock interview sessions covering Spring Boot, RDBMS, Angular and React JS. - Providing useful feedback to improve my response and approach to these technical topics. Ideal candidate would have: - Extensive knowledge and experience in Java Spring Boot, RDBMS, Angular, and React JS. - Some experience in interview coaching or mentorship. - Excellent communication and feedback skills. - Flexibility to adjust the number of m...

My project involves the precise and strategic usage of OpenAI API for a particular functionality - natural language processing (NLP). Hence, I am looking for an expert in Jmete...testing - Solid understanding of OpenAI API - Experience in Natural Language Processing (NLP) testing - Expertise in testing Voice to Text systems Please include in your proposal your approach to this task, previous experiences, and how you can use these to contribute to the success of this project. If you have any questions, feel free to ask. My approach (tentative) 1. local PC setup using jmeter 5.5 with Bash script for logging and Python script for WER 2. Configure the AWS server already running for API endpoints 3. Create JMeter config file to conduct 4. Conduct the steps to conduct the perform...

Hi we need a professional linux server administrator I need a series of tasks regarding setting up a linux server and configuring it's security. Analytical details will be given in a doc in chat. Every step needs to be reported in a doc according to the requirements, including the screenshots of the system and the commands used. Deadline is in 12 hours from now, we need to do as much as possible Budget: $70 USD (fixed)

Hi we need a professional linux server administrator I need a series of tasks regarding setting up a linux server and configuring it's security. Analytical details will be given in a doc in chat. Every step needs to be reported in a doc according to the requirements, including the screenshots of the system and the commands used. Deadline is in 12 hours from now, we need to do as much as possible Budget: $70 USD (fixed)

...screen sharing) Resource must have Knowledgeable of the ASP.NET framework, Microsoft SQL Server and design/architectural patterns (e.g., Model View-Controller (MVC)). Knowledge of web development languages, such as HTML, XML, CSS, JavaScript and AJAX. Experience with database servers, particularly Microsoft SQL Server 2016 or newer/ In-depth knowledge of the .NET infrastructure Experience with architecture styles/APIs (REST, RPC). Understanding of the Agile methodology. Knowledge of REST and RPC APIs. Strong communication and interpersonal skills with an ability to work well in a team setting. Advanced proficiency in C#, F#, or VB.NET; preferably all three. Highly experienced using Microsoft SQL. Outstanding analytical, problem-so...

Have a custom WP theme built on ACF. This is a blog so it is all about making content and presently it is a pain as have to reformat paste content (if paste as text). I need to have ability to paste content from a site/excel/word etc and the content to ...[Real3dflipbook pdf=url] IMPLEMENTATION Tell me how you will do? Can be done in? - .PHP file, or - Plugin SUPPORT Will clarify anything you need. TIMELINE Would love to be done ASAP, but no crazy deadline to stress you out! YOU Don’t care about location/timezone etc. We communicate on message, so speak enough English to chat. APPLICATION Tell me briefly how you solve. A dev will ask you a few questions and you start. Tell me ball park price to complete for fixed price (if unexpected work to improve, then I pay fair...

...hospital usage, I need a proficient developer to create a secure server that is cloud based. The server should be crafted in a way that integrates HL7, placing a strong focus on data security, as we will be storing confidential patient information. Key tasks to undertake include: - Implementing encrypted data storage and retrieval, ensuring integrity and confidentiality of patient data. - Setting up HL7 message parsing and processing, enhancing data interoperability. - Facilitating user authentication and access control via role-based access control, limiting system access to authorized personnel only. To meet these tasks, you should bring a proven familiarity with encryption methods and SSL/TLS certificates to secure server connections. It's critical to o...

****Apply Only if you are Zendesk certified and have done Ai chatbot in zendesk/ have similiar case study **** Hi have 10 gb of past email conversation data.I want to create ai chatbot on zendesk to automated the support. *Note- you previous project of ai zendesk bot and your zendesk certification apply in you are Zendesk certified and have a case study of previous client for Ai zendesk chatbot.

This project requires building a robust flight booking system that will function as the primary focus of the software. Ideal freelancers should have a strong background in this area. Key Details: - Essential components of the system will include flight booking capabilities along with...book or cancel reservations. - Ability to review and rate hotels is a mandatory feature to incorporate. Payment Details: - The software system should integrate a secure payment gateway for the booking procedure. - I prefer to accept payments using Credit/Debit cards and Bank Transfers. Previous experience in developing booking systems and payment gateways will be a plus. Skills: - Python, C#, SQL or other relevant languages - Payment gateway integration - UX/UI - Database Management - Project M...

...creation of a dummy server for a hospital with HL7 integration. A pay portal is already in place and will be connected to the server. The server must include the following functionalities: - Patient Registration - Displaying Laboratory Results - Storing and Accessing Medical Records The ideal freelancer would have experience in server development and healthcare-specific technology integration. Please include detailed project proposals in your application. This should illustrate your understanding of the project, your approach to fulfilling the requirements, and outline any relevant past work or experiences that would make you an excellent fit for this project. As for programming languages, while I didn't specify a preference, knowledge in languages ...

I need to transition all my quiz questions and answers from Tutor LMS to Moodle. This needs to be done accurately. The skillset required is: - An understanding of Tutor LMS and Moodle - Proficient in data transfer between different learning management systems You need to transfer all the questions and answers. from the 5 quizzes that I will give you on Tutor LMS to the corresponding quizzes on Moodle. Please see word document for more details on the requirements. We will set up a 4 hour milestone to begin with. If a good job is done we will give you more courses and quizzes to work on and will keep adding new milestones. Once you finish each quiz send me a message on freelancer. I look forward to working with you.

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

I'm looking to gather insights into ESG (Environmental, Social, and Governance) issues from industry professionals specifically in the PPE (Personal Protective Equipment) sector. Key aspects of the project: - Organizing a detailed questionnaire of 14 questions related to various ESG topics. - Conduct the survey with 20 selected industry professionals. - Goal is to assess the understanding and awareness of ESG concepts and identify the factors influencing ESG decision-making within the PPE industry. Ideal candidate: The perfect fit for this task will have experience with strategic survey deployment, knowledge of the PPE industry, and a working understanding of ESG concepts. A background in Market Research or Sociology will be beneficial. Strong analytical capabilities will b...

Necesito terminar un proyecto que ya empezamos, el profesional debe tener pricipalmente conocimientos en Framework Laravel y Bases de Datos SQL

Looking for a virtual assistant to help call leads, and qualify them. Phone & Number provided via Zoom Phone. You will be: 1. Calling leads provided to you 2. Ask them several questions 3. Record their answers in our CRM (Podio) **MUST SEND A RECORDING OF YOUR VOICE This is a part-time/as-needed job.

I'm in need of a professional to conduct an online survey centered around gathering customer feedback on various questions about sustainability (ESG). This process is crucial to my project's overall success as it will allow me to identify disposable glove market trends based on the responses received. Essential skills for this job include: - Experience in conducting online surveys. - A good understanding of market research methodologies. - Familiarity or interest in sustainability (ESG). - Ability to translate raw data into actionable insights. Your role will be to find potential participants, in glove industry, execute the survey, and then translate the feedback into clear and structured data that can inform our customer satisfaction strategy. The information to be re...

I'm searching for a talented videographer who can produce a 60-minute, interview-style video portraying the most compelling moments from my 82-year-old mother's life. Primary Focus Areas: - Childhood memories - Career journey - Personal accomplishments Ideal Setting: - A local park that holds significant value for us. Skills and Experience: - Expertise in Interview-style documentary making - Strong understanding of storytelling through visuals - Ability to capture authentic emotions and expressions - Proficient in video editing to create a seamless storyline Together, let's create a timeless keepsake that beautifully encapsulates my mother's life journey.

The local MySQL server engine suddenly shut down due to a power failure. This caused an error in storage or a memory error that led to corruption when the storage engine is writing data to the table. Attempting to fix it, I manipulated the LOGS files (transaction logs, etc.) and managed to connect to the database, query data, and export some of it, and the data was exported perfectly. That's why I know the data is intact. Unfortunately, I didn't think to export all the data because I thought the error had been fixed. However, the next day, the error returned, and I couldn't fix it. Here is a link that explains that it is a common problem in my situation: We are using, XAMPP, MYSQL and Maria

Hello I just purchased new Rapid SSL certificate but I didn't generated it so I don't mess anything up I will need someone to generate my newcert. and install it on Ubuntu server - So NO CPANNEL And I need this 5-10min job to be done today please

you will use a cache simulator to analyze the performance (hit rate) of three cache designs. You will do this in an analysis paper which should answer the following questions: How does the performance of a cache change with its associativity? (e.g. direct mapped vs n-way associative vs fully associative) How does the performance of a cache change with cache size? How does the performance change with replacement policy? How does the performance change with the line size? Important Information The format of the memory trace file is the following: The first field is “l” or “s” depending on whether the processor is loading from or storing to memory. You don't need to do anything differently for load or store. The second field is a 32-bit memory address. T...

I am currently on the lookout for a highly experienced and creative designer that can design a 2D strategy game for PC. The game is sports-focused, predominantly revolving around football and basketball scenarios. Ideally, you should have the following: - A lot of experience in 2D ga...accurately. Given the nature of the game, the project will be best suited to designers who are not just experienced in their field, but also have a deep understanding and passion for these sports. This knowledge will be crucial in ensuring the design reflects an accurate and engaging representation of the sports. Further details will be provided for the contractor who stands out and asks the right questions. Looking forward to hearing from talented designers ready to embark on this interestin...

I'm on the lookout for an experienced Bubble developer. Even though I skipped a few questions, I have a vision for this application that we can align with. The ideal freelancer should have: - Experience in Bubble development - Strong problem-solving skills - The ability to take initiative Since I have skipped discussing specific features, I am eager to see what innovative solutions you can provide. In your application, please include: - Your past work experiences - Particular expertise within Bubble development - A detailed project proposal. I am excited to see how your skills and creativity will bring my project to life.

Please create car dealership/boutique renderings using a variety of our products! Details and symbols are uploaded in files. Please let me know if you have any questions. Thanks!

I need a fully bilingual professional (I will interview in English) to do some tasks for my agency such as: PR Outreach Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Wordpress And others You must be a fast learner, attentive, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes. This job will start part-time as a test period, after that it will be full-time. Payment for part-time during trial period: Fee: 250 USD Performance bonus: 50 USD Results bonus: 50 USD If your work complies with my quality requirements and you give more than asked, you’ll get performance and results bonuses each month. After a two-month...

...development and potential future scaling. End Goal To create a functional MVP that effectively demonstrates the capability of the platform to support businesses in developing and analyzing their visions, leveraging the robust foundation of the Full Stack FastAPI template. ⚡ FastAPI for the Python backend API. ? SQLModel for the Python SQL database interactions (ORM). ? Pydantic, used by FastAPI, for the data validation and settings management. ? PostgreSQL as the SQL database. ? React for the frontend. ? Using TypeScript, hooks, Vite, and other parts of a modern frontend stack. ? Chakra UI for the frontend components. ? An automatically generated frontend client. ? Dark mode support. ? Docker Compose for development and production. ? Secure password hashing by default. ? ...

As your dietary monitor, I will provide personalized support and guidance to help you stay on track and achieve your desired outcomes. Customized Meal Plans Weekly Check-Ins Nutritional Analysis Accountability and Support Throughout our partnership, I will provide ongoing support and motivation to help you stay committed to your strict hard diet. I will be available to answer any questions you may have, provide encouragement during challenging times, and celebrate your successes along the way. Benefits: Personalized support tailored to your unique dietary needs and goals. Regular monitoring and adjustments to ensure optimal results. Accountability and motivation to help you stay on track. Access to expert guidance and support throughout your journey.

I am seeking a professional to develop a Lead-Generation form submission web page, which includes end-to-end API integration, csv download & reporting capabilities. Key Project Details: - The required API is HTTP-based (HTTPS POST) - The form should collect multiple information, including name, email, phone number, addresses, and option for additional custom questions - In addition to API integration, the solution should include download capabilities in csv and comprehensive reporting functions Ideal Candidate: - Proficient in API integration, preferably with HTTPS POST - Experienced in CSV handling and reporting features development - Strong understanding of user experience to design an efficient and user-friendly form

I'm looking for a detail-oriented professional to help enter a mixture of text, numbers, and images into a Microsoft SQL Server database. This should be completed in an organized and efficient manner. Key skills and Experience: - Proficient in Data Entry - Familiar with Microsoft SQL Server - Ability to accurately enter a mix of text, numbers, and images - Good organizational skills and attention to detail - Understanding of database organization and management This project requires someone with data entry experience and a solid understanding of how to utilize Microsoft SQL Server. Efficient and meticulous data organization is crucial to this project's success.

I'm in need of a skilful database expert to restore a MySQL database. The database size is less than 1GB, hence would not pose a heavy workload. Our backup file is conveniently located on the server at hand. Key Skills Required: - MySQL Database Management. - Proficiency in SQL commands. - Experience in restoring databases, preferably MySQL. Your expertise should assure a minor downtime and safe recovery without data loss. Looking forward to connect with the right professional.

I'm currently running a Python script on a server on Digital Ocean and I need a highly experienced individual with solid knowledge of to set up my panel on the platform. Specifically: - The main task involves configuring server access, ensuring the transition is smooth and does not interfere with my running Python script. Ideal Skills & Experience: - Proficient in server access configuration - Strong experience with - Solid Python knowledge - Significant experience working with Digital Ocean. By applying for this project, you are affirming your competence in the stated areas, and your ability to setup the panel carefully while retaining the functionality of my Python script.

We are a small indie game that wants to create short clips for existing pro wrestling moves, and we're set...Chokeslam We want an emphasis on the animation itself more than on the characters. For characters you can use generic rigging mannequins, or real characters as long as they fit the theme. The scene is set in a Pro Wrestling ring, and the camera shot should be close but should show both wrestlers full body. Each clip should be 2 to 4 seconds in length, and in normal play speed. If you have any questions, feel free to ask them. P.S: For reference check this video: : For the wrestlers characters, you can use any generic rigging mannequin/skeleton that's in high definition and looks proportionate (Similar to the videos). Thank you