Sql query interview questions for experienced professionalsdela

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

- 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 have a digital circuit design in PDF format that I need converted into a Proteus Professional circuit diagram. This project only involves the conversion of the existing design into a circuit diagram within Proteus; no simulation or...Proteus Professional circuit diagram. This project only involves the conversion of the existing design into a circuit diagram within Proteus; no simulation or testing is required. Key Requirements: - Convert an existing digital circuit design in PDF format into a Proteus Professional circuit diagram. - Ensure that the circuit diagram accurately represents the original design. Ideal Freelancer: - Experienced with Proteus Professional software. - Proficient in digital circuit design. - Capable of accurately translating circuit design from PDF format t...

I need an experienced logo designer to create a professional, simple, modern, and trustworthy logo for a tech plumbing business website. The logo should incorporate the website name, an abstract image, and a slogan. Imagery and style are entirely up to you as the artist, since I have no preconceived images or symbols to utilize. The key here is to evoke a feeling of professionalism, modernity, and trust in our consumers. Ideal candidates will have experience in logo design and a keen eye for colour schemes.

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 am seeking an experienced music transcriber to provide me with sheet music in MusicXML for "Almost Blue" by Chet Baker - Live in Tokyo (see on YouTube). Exact transcription of the Piano part from original, including improvized solo, and exact base, is required. If this sounds like something you're capable of handling, please bid on a flat-fee complete project basis with turnaround time and relevant sample works.

I'm seeking the expertise of a seasoned digital marketing freelancer to enhance my agency's operations. One who's adept in an array of digital...including: - Search Engine Optimization (SEO) - Social Media Marketing - Content Marketing - Website Design and Development - PPC - Meta Ads - Google Ads - Market Research The crux of this collaboration pivots on the generation of leads and conversions. Furthermore, the successful applicant will concentrate their strategies towards the working professionals demographic aged between 26-50. I strongly encourage enthusiastic digital marketing professionals with a proven track record in the above areas to apply. Your ability to design and implement result-oriented strategies that effectively cater to our target audien...

We are seeking a talented and creative individual to join our team and work on our mobile app designed for medical professionals. We need someone who can think outside the box, develop innovative marketing strategies, and help build and enhance our brand.

We are seeking an experienced packaging professional to create a pouch and box for our dietary supplement product. We already have a comprehensive design in mind, leaning more towards a minimalistic theme. Ideal Experience and Skills: - Meet FDA regulations for dietary supplement packaging - Profound knowledge in pouch packaging - Ability to bring ideas to life while following specific design outlines - Prior experience with dietary supplement packaging will be an advantage Please provide examples of past projects, particularly displaying your capability in designing minimalistic pouch packaging. Thank you.

I am looking for a talented writer to craft a compelling cover letter for an marketing position. Key Requirements: - Experience with writing cover letters for marketing roles. - Understanding of the marketing industry and its latest trends. - Ability to tailor the letter for the job. - Please refer to my attached resume and job requirement. Your main task will be to create a persuasive narrative that highlights my skills, enthusiasm, and potential as a marketing professional. Although not mandatory, experience in the following will be a plus: - Working with fresh graduates or entry-level professionals. - Incorporating industry-specific achievements in cover letters. Prior experience in the marketing field or recruitment will be a significant asset. A ...

I'm in need of a knowledgeable expert to help manage my bookkeeping using FreshBooks. Your tasks will primarily involve: - Maintaining financial records and handling all business transactions - Ensuring accuracy and maintaining systematic order Ideal candidates should be well-versed with FreshBooks and have profound experience in accurate bookkeeping. A strong compre...handling all business transactions - Ensuring accuracy and maintaining systematic order Ideal candidates should be well-versed with FreshBooks and have profound experience in accurate bookkeeping. A strong comprehension of financial statements and the ability to organize large amounts of data are also critical. Previous accounting experience would be a bonus. Prompt, reliable, and detail-oriented professionals...

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

As a growing architectural firm, we are seeking an experienced Revit designer to develop medium-scale models for various types of buildings - residential, commercial, and industrial during the construction phase. Key Responsibilities: - Create Revit models from concept design to construction documentation - Coordinate with our on-site team to ensure accuracy of the model Required Skills: - Proficiency in various types of Revit modeling - Prior experience in residential, commercial, and industrial projects - Detailed understanding of various construction phases - Ability to handle medium-scale projects independently. Your expertise will help us bridge the gap between conception and construction, providing a more realistic and manageable understanding of each project. Ca...

...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'm looking for an experienced PPC marketer who can help me set up Microsoft advertising ppc campaigns.

I need Ecwid expert who can help me to customise shopping form and should be did work on ecwid. Make sure they know ecwid and customizing. If not experienced in ecwid them please don't bid, I I'll simply refuse those bids are blinding loaded.

I'm looking for an experienced and creative video creator who can generate an explainer video to introduce my company/brand. Key responsibilities: - Develop an original, compelling script from scratch. - Deliver an engaging video that effectively communicates our brand message. Ideal Skills: - Strong scripting and storytelling skills. - Experience in creating explainer videos. - Proficient in using video editing software. - Keen eye for details and creativity. - Understanding of branding principles. The ultimate goal of the video is to provide viewers a clear, appealing introduction to our brand. Looking forward to excellent pitches from skilled professionals.

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.

I'm looking for Shopify store owners to install and test two Shopify apps. This project entails the following: - Installing and testing two Shopify apps. - Providing comprehensive feedback on the apps based on usability, performance, features, and overall experience. - The chosen apps should heavily emphasize social media promotion features. The ideal freelancer for this project should: - Have a good understanding of Shopify and its app ecosystem. - Be experienced in using and evaluating marketing apps. - Be able to provide detailed and constructive feedback. - Have a keen eye for user experience and app performance.

I need a resume writer to help me craft a compelling resume for mid-career roles in the Software as a Service (SaaS) industry. Key Requirements: - The resume should be in PDF format. - It should be tailored to the SaaS industry, reflecting my mid-career level of experience. - I'm looking for a professional and engaging resume that highlights my skills and accomplishments in a clear and concise manner. Ideal Skills & Experience: - Proven experience in resume writing, especially for mid-career professionals. - Strong understanding of the Software as a Service (SaaS) industry. - Excellent command over the English language with a keen eye for detail. - Ability to deliver the project in a timely manner.

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

I'm in need of an experienced C# desktop 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 s...

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

I need a professional, sle...It's an informational site, aimed at professionals in the industry, and I want it to primarily showcase our company services. Key requirements include: - Designing a clean, modern and professional looking website - Implementing user-friendly navigation and layout - Showcasing company services as the primary focus - Ensuring the design is appropriate for a professional audience Ideal skills and experience for the job: - Proven experience in designing professional, informational websites - Strong understanding of user experience and user interface design - Experience working with websites aimed at professional audiences - Ability to create visually appealing, modern designs - Excellent communication skills to understand and incor...

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

...with a penchant for crafting people-centered designs. - Task: Your primary assignment will be to develop graphic illustrations that focus significantly on human elements. - Style: The design style isn't strictly defined, multiple styles including minimalist, cartoonish, and hyper-realistic are welcomed, if applied effectively. - Subject Matter: The illustrations must prominently feature people. - Skills & Experience: Ideally, you would have extensive experience creating similar art styles and be capable of infusing a sense of life and character into your illustrations. Understanding how to represent people accurately and attractively in different styles is critical. Showcase your adept hand, creative mind, and keen eye with this project - applications open to all ...

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.

We are seeking an experienced freelance developer to design and develop an online service booking platform targeted at legal professionals. 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-e...

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

I'm in need of an experienced website developer who can create a simple, yet warm and inviting 5-page website. Here are the key requirements: - The website needs to be built on WordPress - I will provide all the text and images required for the website The site will consist of the following pages: 1. About 2. Services 3. Products 4. Design process 5. Contact us For the 'Contact Us' page: - A contact form is essential, with all the necessary fields and a submit button Ideal Skills and Experience: - Proven experience in WordPress website development - Ability to create a warm and inviting design style - Proficiency in integrating forms in WordPress - Strong communication skills to understand and implement provided text and images.

I need an experienced WordPress developer to investigate and resolve an issue with my website's frontend file upload. Key Tasks: - Identify and rectify the problem causing files not to appear after successful upload. Additional Details: - The files are supposed to be visible on the frontend of the website, but currently, they are not showing up after being uploaded. - The uploaded files are intended to be visible only to logged-in users. Ideal Skills: - Proficiency in WordPress development and debugging. - Experience with frontend file upload functionalities. - Understanding of user permissions and visibility settings in WordPress. I am looking for a professional who can efficiently troubleshoot and resolve this frontend upload issue to ensure the system works flawl...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.

We are seeking an experienced Angular Developer to work with us. You will be responsible for developing and maintaining high-quality Web application. The ideal candidate should have a strong understanding of Angular, and mobile development best practices. Skills required: - Angular - HTML/CSS - JavaScript - bootstrap

I need an experienced WordPress developer to work on specific page updates with Elementor and ensure they're completed by Monday morning. Key Requirements: - Implement design changes: The primary goal is to refresh the brand image, ensuring it's consistent with our current branding. - Efficient and quick: This is an urgent task, I need someone who can start today and complete it by Monday morning. Ideal Skills and Experience: - Proficient in WordPress: You should be well-versed in WordPress, particularly in working with Elementor. - Strong design sense: Experience with design and branding is crucial to ensure the updated pages align with our brand image. - Time management: The ability to work under tight deadlines and deliver high-quality results promptly is extremely im...

...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 am currently in search of an innovative video editor experienced in creating engaging and aesthetically pleasing YouTube Shorts for my clothing brand. The editor should be well-versed with: - Utilizing Windows operating system for video editing. - Adding profession-level Transitions/Effects to the videos to keep the viewers glued. - Color Correction to ensure the video colors align perfectly with the brand theme and make the visuals pop. - Inserting Text/Graphic overlays adding an extra depth and details to the video content. The involved content revolves around lifestyle and fashion branding, thus a touch of elegance and a deep understanding of the fashion industry would definitely be a plus. The final result should smoothly narrate the brand story, excite th...

I'm looking for an experienced designer who can create a classic and elegant logo for my cigar club. The logo must incorporate a cigar, a gift box, and moving smoke. The color scheme for the logo should be primarily red and black. The ideal freelancer for this project should have: - Strong graphic design skills - Experience in creating elegant and classic logos - A good understanding of branding and visual identity - Proficiency in using graphic design software

We are looking for an experienced marketer who specializes in marketing campaigns that rely on data analysis. You as a digital marketer must be able to handle the data analysis that we will provide you with to target the right target audience. You as a digital marketer, you must be able to implement advertising campaigns based on the data analysis that we provided to you. You as a digital marketer, you must be able to implement advertising campaigns on Facebook, Instagram, Snapchat, TikTok, and Twitter. Ideal Skills and Experience: - You must have the ability to handle the data analysis that we will provide you to target the right target audience. - To have proven experience in marketing campaigns that rely on data analysis. - To have proven experience in paid advertisin...

I'm in need of a minimalist and clean infographic that conveys a step-by-step guide for industry professionals. Key Points: - The visual should be easy to understand and navigate, making complex information accessible. - The design should be minimalist and clean, avoiding clutter and overdesign. - The end result should be professional and suitable for an audience of industry professionals. Ideal Skills: - Proven experience in creating infographics, with particular experience in step-by-step formats. - A strong sense of minimalist and clean design principles. - An understanding of the needs and preferences of industry professionals.

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 am looking for someone experienced in building tool websites with an emphasis on monitoring changes on various websites. The primary function is to detect and report on content changes, with users receiving notification of these adjustments via email & sms alerts. Ideal Requirements: - Proficiency in building tool websites for monitoring purposes. - Knowledge in setting up a system to detect website content changes. - Experience in integrating email alert notifications for users. - Loading Capacity 500+ Websites Searching per Hour - Foresight in creating an interface user-friendly even for non-technical users. This project will require strong analytical skills and a sharp eye for detail. I'm excited to work with someone who underst...

I'm seeking a skilled professional to help me leverage AI in the educational sector. - Ideal candidate is experienced with integrating AI - Must be knowledgeable in educational technology - Proven track record in enhancing educational quality Your role will be to assist in creating a more engaging and effective learning environment for students and faculty. We are looking to improve student performance, enhance teacher support, and streamline administrative tasks. Your expertise in AI and educational technology will be crucial in helping us achieve these objectives.

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

...SCREEN SAVED FOR THE PURPOSE OF KPI AND PROJECT EFFICIENCY. I am in need of an experienced project manager who can help me streamline our construction and marketing projects, ensure effective team communication, manage the budget, and deliver the projects to our clients on time. Key Responsibilities: - Planning and scheduling: Develop project timelines, set milestones, and allocate resources efficiently. - Team coordination and communication: Maintain clear communication channels among team members, contractors, and clients. - Budget management: Responsible for ensuring projects stay within budget, and identifying cost-saving opportunities. - Fulfill client projects: Deliver projects in a timely manner that meets or exceeds client expectations. I'm particu...

We are looking for candidate from Hyderabad City only. I'm in need of a skilled system administrator who can manage a small infrastructure across Windows, macOS and Linux operating systems. The key tasks include server maintenance, network troubleshooting, software installation and updates, and configuring our server. Key aspects of the project include: - Supporting multiple operating systems: You should be experienced in working with Windows, macOS, and Linux. - System maintenance: Regular maintenance of our servers is essential for smooth operations. This includes updates and ensuring all systems are secure. - Network troubleshooting: You'll be responsible for keeping our network up and running. Troubleshooting issues as they arise is crucial. - Sof...