Sql server interview questions for freshersdela

- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark

Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.

Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

...idea for a mobile app focused on cricket match scheduling. As a cricket enthusiast, I have often faced the challenge of finding available teams to play matches against on short notice. To address this issue, I envision an app that can connect teams and simplify the process of organizing cricket matches. Project Overview: The primary goal of the app is to help cricket teams find and schedule matches with each other. Teams can mark their availability for matches, view other available teams, and communicate directly to arrange matches. Core Features: User Registration and Profiles: Teams and individual players can create profiles. Profile information includes team name, location, contact details, skill level, and availability. Match Availability: Teams can post their ava...

...application from a 2008 server to a dedicated server. Key Requirements: - Migrate ASP.NET 3.5 application: The current application is running on ASP.NET 3.5 and needs to be seamlessly moved to the new dedicated server. - Hosting Environment: The application should be set up on a dedicated server. Experience with dedicated servers is crucial. - Identify Specific Requirements: I'm unsure of any dependencies or specific requirements the application might have, so the ideal candidate will need to assess this and make necessary recommendations. Ideal Skills & Experience: - Proficiency in ASP.NET 3.5: Extensive experience with ASP.NET 3.5 and above is essential. - Server Migration: Proven track record of smoothly migrating applications from one ...

...structure, and update information from web pages, handle large projects, and be accessible via a powerful API. The system should offer user-friendly features for both individuals and businesses and include flexible user management for both customers and employees. Project Requirements 1. Web Crawling and Data Extraction -Develop a system capable of scraping entire websites and extracting data from each page. -The system should divide the scraped information into sections to facilitate easy reading and understanding. -For e-commerce sites, the system should identify and structure the following information: --Product category (including breadcrumbs for hierarchical structure) --Title --Price --Availability --Images (specify the main image) --Review score --Uni...

I am looking for a skilled and creative 3D designer to create a dynamic and futuristic live logo for my brand. The ultimate goal is to enhance brand recognition. Required Logo Specifications: - Style: The style has to be futuristic. Comfort in designing in this genre is important. - Color Scheme: The logo should predominantly use cool colors (Blue, Green, Purple). Ideal Skills and Experience: - Proficiency in 3D design software - Previous experience creating live logos - Familiarity with or interest in futuristic aesthetics Your bid should include a portfolio demonstrating your expertise in creating 3D live logos. Feel free to include any questions you may have about the project in your bid. Looking forward to your creative proposals!

...detailed cricket schedule for the upcoming English summer season. Tasks Include: - Including International, Domestic, and Club tournaments and teams in the schedule - Organizing fixtures based on the date Additional Details: - Each fixture should have comprehensive information about the venue - Match timings should be included - Broadcast details for each match should be provided Ideal Skills: - Proficiency in Google Sheets - Knowledge of cricket and its various tournaments - Attention to detail to ensure that all necessary information is included - Time management skills to complete the project in a timely manner more details--- ### Task Description: Google Sheets Data Entry Expert for Cricket Schedule **Objective:** Create a comprehensive cricket schedule ...

I'm seeking a specialist to locate a VPS/VRoot server that can provide minimized latency to a website origin hidden behind a Cloudflare proxy. The task encompasses: - Identifying the server with the lowest possible ping based in Europe. - The server should run on a Windows operating system. - The ultimate objective is to improve user experience by minimizing latency. Ideal freelancers for this job will have a robust understanding of server locations, operating systems and how they interplay with website latency. Experience with Cloudflare proxies, Windows-based servers, and in-depth knowledge on achieving optimal latency is distinctly beneficial. The website would be and I require the lowest ping when buying an item on the sites trading page. Pin...

I need an experienced Linux admin who can help me set up a CentOS server to function as a web, database, and file server. The ideal candidate will be familiar with CentOS and have experience configuring a server with multiple services. Key Requirements: - Install and configure CentOS on a server - Set up Nginx as the web server - Configure the server to also function as a database and file server - Ensure the server is secure and optimized for performance - Provide documentation of the setup and configuration for future reference.

...Q&A functionality. - **Integration Method**: I intend to use the ChatGPT API where I'll send text and image data for processing. The desired outcome is a response that can be used to engage with users. Ideal Skills: - **Spring Boot**: A strong understanding of Spring Boot is crucial to ensure seamless integration of ChatGPT within my application. - **ChatGPT API**: Experience working with the ChatGPT API or similar natural language processing (NLP) tools is highly desirable. - **Q&A Functionality**: Knowledge of creating Q&A systems or similar chatbot implementations would be beneficial. The end product I'm looking for is an integrated system where users can ask basic questions and receive relevant responses from the ChatGPT engine. The goal ...

Please note that this is not for a particular role, this for representation. We work with all Casting Directors in Australia on all productions. We are seeking talented individuals to play varying roles. We receive briefs for Film, TV, and Commercials. We left the project duration field blank, this means there are opportunities for both short-term and long-term collaboration. Most jobs are between 4-8 hours or can be multiple days on larger productions. As experience is needed for some productions, inexperience actors are also welcome as there are allot of roles you don't need experience for as long as you feel comfortable in front of the camera. Please contact me if you have any questions. Regards Brad Walks Talent Management

...techniques, timing, and quality control measures. Project Goal: The ultimate goal is to create a page that educates consumers on what makes our vanilla truly special and compellingly tells our unique brand story. The page should convey our deep commitment to quality, sustainability, and supporting our farming communities. It should engage viewers' senses and emotions, instilling a greater appreciation for the artistry and care behind our vanilla. Key Project Requirements: 1. Visual Storytelling: - Organize the page's flow to follow our vanilla's journey, guiding users through the process in an intuitive, engaging way - Draw all steps, Incorporate high-quality images, illustrations, and/or animations to richly visualize each step and bring our process to life - D...

I'm in need of a skilled writer for an assignment in project management. The assignment should be done in 3000 words. It is actually 2 questions. Each question should be answered in 1500 words. There will be a sample answer to help you understand the way we should answer the assignment. Kindly write how much your price for 3000 words including references and check the whole written answer in Turnitin, Quillbot and Grammarly. Ideal Skills and Experience: - Proficient in various writing styles (informative, persuasive, descriptive) - Flexibility and adaptability in terms of topic - Experience in writing a variety of word counts - Strong grammar and editing skills Please note that the assignments details will be sent to you after I accept your price.

I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Kn...

I'm looking for a skilled developer to create a user-friendly website for my MMORPG game server. Key elements of the project include: - Designing an engaging and intuitive UX/UI template for the website that resonates with the game's theme and aesthetics - Inclusion of essential features to enhance user experience Your expertise in web development, specifically in the gaming sector, will be crucial to this project's success. A strong understanding of user behavior, and the ability to translate that into a visually appealing and functional website is a must. Please provide a portfolio showcasing your previous work in this area. Experience with MMORPGs or gaming websites will be highly valued.

...a list of all the different things you can do if you want to PERMANENTLY END your hopes for being awarded this project. 1. Place your bid with an auto-bid. Yeah, blind bids with no consideration for what it’s going to take to actually do the project just tick me off. 2. Don’t read this document carefully. After all, I only put a ton of work into it, and it will only answer 99% of your questions. Why should you respect that? Just skim the document and then try to get me to talk about it in detail. That’s a great way to irritate me. 3. Ask me, “So, what is your budget on this?” In case you hadn’t noticed, this is a “bid” project. You place your bid, you also include how long it will take for you to ...

...developer who can build a coaching application for both iOS and Android. The application must be designed with user roles for Admins and Students. Here are the detailed requirements: - Create a platform where Admins can build batches of content for students - The functionality of the administration system should allow for the upload of videos, PDFs, and mock tests - Uploaded videos must be in MP4 format exclusively - Push notification capabilities for updates or notifications The successful freelancer should have: - Strong experience in Android and iOS app development - Understanding of user roles and permissions - Expertise in video content handling, specifically MP4 files - Proven track record in creating education-related applications Thank you ...

I need a Cloudflare expert to set up and configure my server for a high traffic website. - Tasks: The primary task will be setting up and configuring the server for the website. This includes but is not limited to ensuring the server is set up correctly, testing its performance and functionality, and making any necessary adjustments. - Specific Optimization: Experience in optimizing servers for high traffic websites is a must. - Cloudflare Specifics: While the primary focus is on server setup, knowledge of Cloudflare and its CDN (Content Delivery Network) feature is highly desired. Ideal Freelancer: A Cloudflare expert with experience in server setup and optimization, particularly for high traffic websites. Knowledge of...

Hi, I am looking for expert to connect SQL database togoogle looker studio so we can analise data and creat reports, it is a long term coopartion. Please provide implementation cost and hourly charge. Best.

Greetings, I am looking for a professional both able and creative to deliver our group presence to the web in style. Our project is based in Brazil and should be multilingual (native in Brazilian Portuguese with the ability to include further languages like english, spanish and french in the future) Our idea of the whole website concept and areas are as follow, Home Page: Presentation of Equità Ltda. Links to the main areas of the site (Equita Club Deals, Equità Bio Casa Imobiliária, Equità Construction Products and Services). Equita Club Deals (private P2P functionality): Login/Register Projects page Investor dashboards Access to documents and contracts Equità Bio Casa Imobiliária: Property listings (template creation and eventual API ...

...programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel ...

If you read it start your message with 'REACT'. I'm looking for a React specialist to help me deploy a wallet connect feature on my server. This is a React project that I need to deploy on my server. The project is for a wallet connect feature for crypto. There is already a working example from GitHub and I need it deployed on my server. Experience in the following areas would be ideal: - Proficiency in React - Experience with deploying projects on servers

Give me what you can for 2 hours of transcription to text of oral interview “Gums and Gossip” Interview

...Android application for receiving video streams. Telemetry data transmission and other functionalities are already implemented. Deliverables: A script to be deployed on the processor of the RC plane, optimized for low-latency video streaming. Configuration and integration support to ensure seamless video streaming within the existing React Native application. Documentation detailing the setup, configuration, and any dependencies. Technical Specifications: Video streaming latency should be reduced to 100-200 milliseconds. The solution should be compatible with the existing hardware and software setup. Preferred protocols and technologies: WebRTC, Gstreamer, or any other low-latency streaming technology suitab...

We are in the final stage of migrating an existing Django Project to a new machine in a docker compose stack. The database is already moved over. We are stuck with python dependency issues. You need to have good knowledge in - Django and Python3 - Docker, especially Compose stacks - Postgresql You will be working with a system admin who is in the middle of the migration and take over the dependency part, tmate will be used to work together. If you have read this, please add "HDJX34K" to your bid or it will be considered spam, ignored and removed. Your job: - docker compose build - have a look at the python dependency issues - try to resolve them and rebuild. - eventually adjust Django's accordingly. We want this work done now, and you must be able to start immediately.

App para elaborar presupuestos fuera de la tienda. actualmente tengo un sistema de escritorio elaborado en sql server para facturacion. El sistema Funciona perfecto y tiene la opción de realizar cotizaciones pero quiero incorporar una app para realizar las cotizaciones de los clientes foráneos ya que tengo un empleado que los visita semanalmente y me toca estar transcribiendo los pedidos. Seria una app que permita cargar los inventarios y los clientes al momento de estar en la tienda Y luego poder realizar los pedidos o cotizaciones offline cuando se este fuera. Para luego cuando llegue a la tienda hacer la actualización o descarga de pedidos. que tan dificil es hacer la app para android y para ios.

...The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user interface for three distinct profiles: clients (bailiffs), service providers (drivers, couriers, movers, locksmiths), and administrators. Integrate a real-time booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies (e.g., React, Node.js).Experience with SQL or NoSQL understanding of UX/UI design to

...**Compensation:** Paid Position ? **About the Role:** We are on the lookout for a talented Full Stack Developer with a flair for mobile development and UI/UX design. You'll take charge of designing, coding, and modifying mobile applications to enhance user experience. This role requires collaboration with cross-functional teams to bring new features to life and ensure our applications are both robust and responsive. **Key Responsibilities:** - Design and build advanced applications for both iOS and Android using frameworks like Flutter. - Work alongside other teams to define, design, and deploy exciting new features. - Focus on application performance and user experience. - Maintain high standards of code quality and push for continuous improvement. ...

Hello^^^^. I'm using Amazon AWS and would like to request server maintenance. First of all, I would like to ask you to do as much as possible for server security and privacy, such as SSL installation, automatic backup once a day, DDOS attack prevention, system performance optimization, hacking prevention, encryption between data transmissions, real-time monitoring, data recovery, backdoor checking, backdoor checking and deletion of compromised files, attack root identification and blocking, suspicious process occupation identification and recovery, server hacking analysis, server access history tracking, password recovery and complexity setting, virus and malicious software checking,,data leakage prevention.....etc My current monthly budget is about...

I'm on the lookout for a skilled RHEL Engineer to assist in getting our server on the Certified Hardware List. The role will require expertise in the core language of RHEL. Although I'm unsure if proficiency in C is obligatory, having it would be a welcome advantage. Specifically, the Engineer will: - Understand the requirements for RHEL certification - Prepare the server for the process - Perform the tasks and tweaks necessary to meet certification conditions I anticipate that a strong understanding of programming, RHEL, and Linux-based operating systems will be necessary. Experience with server certification will also be highly beneficial.

...QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode scanning, Face Recognition - API integration with Google services This project will require rigorous testing to ensure quality and functional assurances. I am looking for experts with a keen eye for detail and the ...

I'm currently in need of an Android app developer to assist in a production task app on Google Play Consol Your main tasks will include: - Assisting with finalizing the app for production - Providing insights on submission process I'm unable to provide specifics on the app's features, main purpose or target audience as I have skipped those questions. The project will require someone with experience in Android app development, especially in the deployment and submission process on Google Play Consol

I'm in need of a mid-level recruitment specialist to assist me with recruitment tasks. Key Responsibilities: - Conducting initial screening procedures for potential candidates - Sourcing and identifying suitable candidates for the role - Assisting with the interview processes via email I'm looking for someone who has experience in recruitment, particularly at the mid-level. It's essential that the freelancer is able to handle the recruitment process with minimal supervision. The ideal candidate will be able to provide insights and suggestions on improving our recruitment strategy. The candidate should have a good understanding of recruitment best practices, be organized and have good communication skills. Experience in a similar role is a big...

I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The project I have in mind is a custom web application that will require: - Search Functionality: The ap...content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in these areas. I'm looking for a reliable, communicative individual who can deliver a high-...

...diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQL - Experience with ER diagra...

I need a skilled aerospace engineer who could provide critical assistance for an aerospace design project I'm currently working on. The tasks at hand include: - Answering a set of questions related to the project - Deriving concepts based on the information provided - Using MATLAB to conduct an aerodynamics analysis The main focus of this project is to improve the aerodynamics of the aircraft, which ultimately aims to enhance the overall efficiency and performance. This is a time-sensitive task, so I'm in need of someone who can deliver within the same day. Ideal Skills: - Aerospace engineering background - Proficiency in MATLAB for aerodynamics analysis - Strong problem-solving and concept development skills - Ability to work under tight deadlines Your e...

I have a Windows 2019 Server acting as a Domain controller to which I have administrator privileges. My PC connects to the Domain and there are 3 users who logon to the PC/Domain. They are Michael, John and Peter. I want to set a default username for the PC in the format DomainMichael so that no matter who logged on last, whenever they logout then the logon screen will always show DomainMichael. Ideal skills & experiences: - Proficient with Windows Server 2019 Active Directory and Registry Editing - Experience in creating new user accounts with specific permissions. - Attention to detail to ensure the username is configured correctly. Looking forward to your bids.

I'm currently using a Windows server on-premises. In an effort to optimize my operational costs, I'm looking to migrate my database workloads to Microsoft Azure. Key Requirements: - Migration: The primary objective is to move my database workloads from the on-premises server to Microsoft Azure. This process should be seamless and efficient to avoid any disruption to my operations. - Cost Optimization: The main reason for this migration is to save on costs. The chosen freelancer should be able to demonstrate a clear understanding of cost-saving strategies within Azure. Post-Migration Assistance: - Azure Active Directory Setup: I'll require help in setting up Azure Active Directory to ensure smooth authentication and authorization processes. - Azure Back...

I have a critical Windows Server 2019 running as a database server on-premises, and I am looking for a professional who can efficiently migrate it to Microsoft Azure. Key Requirements: - The current server is Windows Server 2019, so experience with this version is a must. - The server's primary function is as a database server, so experience with database migration and management is crucial. - The uptime of my services is critical and 24/7, so the migration process needs to be planned and executed without causing any significant downtime. Ideal Skills: - Extensive experience with Windows Server 2019 and Microsoft Azure migration. - Proficiency in database management and migration. - Understanding of critical server uptime requi...

We need logo for our fitness product brand "Styfit" which is a fitness brand, which we are going to lanuch in our e-commerce store I have attached a sample logo for your reference. Need source file with all the fonts and elements. if you have any questions, please dm me. Thank you!

...profession, and even Instagram username. - **Purpose**: This database is specifically designed for sales leads generation. It's meant to help businesses and organizations reach out to potential customers and grow their sales. - **Categorization**: The leads are not just categorized by one specific filter. Instead, they're a mix of different categories from various industries, countries, and professions. This eclectic mix provides a wide range of opportunities for potential buyers. - **Delivery Method**: I'm looking to sell this database through a CSV file, online access to the database, and a Google Drive link. This way, buyers can easily access and use the leads without any hassle. Ideal candidates for this project should have: - Experience in ...

I'm looking to construct a unique and professional logo that will effectively represent the identity of my brand. The ideal design should: Brand Name : TATIF - Brand name to sell car accessories (K...and professional logo that will effectively represent the identity of my brand. The ideal design should: Brand Name : TATIF - Brand name to sell car accessories (Kindly avoid specifying as car accessories in logo ) - Reflect a professional, innovative, and trustworthy image - Use two elegant colors of your recommendation - Be versatile enough for marketing and social media usage - Need source file with all fonts and elements If you have any questions please DM me. A successful candidate will have proficiencies in branding and logo design. Your creativity will be the key...

server irraggiungibile per tutti i siti web. errore: Service Unavailable

I'm looking for an experienced NodeJS and JavaScript programmer to help me with a school project focused on exploring cybersecurity concepts. Key Requirements: - The task involves writing a client request to obtain a flag from a vulnerability site with advanced complexity (e.g., bypassing security measures). - The project involves emphasizing on Remote Code Execution (RCE) and pollution while interacting with the vulnerability site, so experience in these areas is a plus. --- Challenge Name: Emu Apothecary Category: Vulnerabilities Description has just opened up their potion brewing website for other Emus to create new potion recipes! However, they are afraid that one of the human hackers will pollute their ingredients. Can you get Remote Code Execution (RCE) on...

...preparation question bank for pharmacy practice. The questions should cover Pharmacology, Biochemistry, and medicinal chemistry, providing moderate detail with references. This is a crucial resource for students aiming to pass their pharmacy practice exams. Key Responsibilities: - Develop a comprehensive question bank for pharmacy practice exams - Ensure the inclusion of questions from Pharmacology, Biochemistry, and medicinal chemistry - Provide moderate detail with references for each question Ideal Skills and Experience: - Proven experience in creating educational content, especially in the field of pharmacy practice - Strong understanding of pharmacology, biochemistry, and medicinal chemistry - Familiarity with the educational standards a...

I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide e...

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

...product, basically a coloring app framework for iOS and Android, but the app would use my own artwork. I’d like to be able to reskin it, update it, and add more images as I wanted - so maybe a template with placeholders that I could reskin? I did some basic coding long ago and I’ve bumped around in Swift a bit, so I think if placeholders were inserted I’d be okay doing the reskinning. Functionality that I’d be looking for: - iOS and Android both (maybe quote for each individually, in case we’d have to do one at a time due to cost?) - splashscreen while itloads, then on to the main screen - thumbnails of images, divided into themes - when the user clicks an image it’d take them to the coloring screen - tools: brush, paint bucket,...