Sql query interview questions for experienceddela

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'm currently encountering some bugs in my Laravel project that need urgent fixing. I can provide you with more details about the specific issues in a private message, but here's a general overview of the task: - I'm looking for an experienced Laravel developer who can troubleshoot and resolve the bugs in my project as soon as possible. Ideal candidate should: - Have a strong understanding of the Laravel framework - Be proficient in debugging and fixing errors in PHP applications - Be available to start on this task immediately

I'm looking for an experienced professional to enhance the Bing SEO performance of my website. My main aim is to boost its visibility on Bing search results, improve its ranking, and drive more organic traffic from Bing: https://allied-yacht.com. Key Requirements: - The focus of the optimization should be on the product pages of the website. Ideal Skills and Experience: - Demonstrable experience in improving Bing SEO for websites, with a proven record of increasing visibility and ranking. - Expertise in optimizing product pages for search engines, specifically Bing. - Understanding of Bing's search algorithm and how to leverage it for SEO purposes. In your application, please highlight your relevant experience in Bing SEO optimization for...

I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)

Please ONLY apply if you can do the following tasks. I need an experienced freelancer to convert my PDF into Amazon KDP format. The content of the PDF is a mix of text and images. I only have a pdf file already designed into an ebook, so when directly converted into EPUB format, it yields lots or errors, words glued together, transitions between lines kept together (e.g. transfor-mation). All this has to be corrected, and accounted for in your quote. Key requirements: - Convert PDF to Amazon KDP format - Edit and format the text as necessary Ideal skills: - Amazon Kindle Direct Publishing (KDP) expertise - Excellent attention to detail for text formatting - Experience working with mixed text and image content - text editing within the EPUB format

Job Title: Web Designer (Figma Expert) Description: We are seeking a talented web designer with expertise in Figma to join our team for various web design projects. While your primary role will be web design, the ability to create simple banners and other smaller visual elements for websites is a significant plus. Project Details: - First Project: Design a homepage for a casino website, including footer and header. - Content: The homepage will feature a substantial amount of content (approximately 20,000 words). - Visual Requirements: Each H2 heading (around 40 in total) will need a corresponding image. These images can range from banners to other types that visually complement the content. Unique images should be created using Google Translate to fit each heading&...

I am looking for a professional who can help me create a CV and cover letter that will stand out in the UK and Europe recruitment industry. Key information: - Industry: HR - Target roles: Recruitment Specialist, Human Resources Manager, HR Administrator - Essential certifications: SHRM-CP, CIPD, ATS I am looking for a collaborator who can help me secure interviews for these positions. The CV and cover letter will be the first impression employers will have of me, so they need to be outstanding. I prefer someone who is experienced in 1. UK and Europe recruitment 2. Environmental, water resources management, and sustainability field recruitment 3. using HR tools to increase the hiring rate, eg: Applicant Tracking Software ATS The ideal freelancer for ...

...appealing banner for my website. The banner should be a balanced mix of text and images. I have a specific color scheme in mind that will need to be adhered to. Kindly upload the finalized design incorporating our logo for website consideration; any mock-up submissions will be automatically disregarded. You will find the information attached for creating the banner. Key Requirements: - Design a website banner with a mix of text and images - Use a specific color scheme as the banner currently showcased on the website: https://prominencebank.com. - Banner Size: 1903x560 cm Ideal Skills: - Graphic Design - Web Design - Proficient in design software such as Photoshop, Illustrator, or Canva - Excellent understanding of color theory and layout Feel free to ask any...

...- We do not have time for budget negotiations. I'm looking for someone to develop an AI machine learning app that can scan all company Office 365 emails and SharePoint files via Azure API; store the data in long-term memory of the AI; and have autogpt agents, chat gpt and custom gpts with chaacter limits that can aswer questions on company emails and documents and also alert you when you or any staff forget to respond to something important. Ideal Skills and Experience: - Strong background in machine learning and artificial intelligence - Proficient in developing applications that can integrate with Office 365 - Experience with building applications that can scan emails and files - Knowledge of setting up alerts and chat functionalities - Ability to create a...

I'm in need of an experienced developer to create a single-page website for me using WordPress. The primary goal of this website is to provide information about the services that I offer. Kindly upload the finalized design incorporating our logo for website consideration; any mock-up submissions will be automatically disregarded. Key Requirements: - Development of a single-page WordPress website - Theme selection and customization to match a neutral and professional color scheme - Use a specific color scheme as the pages currently showcased on the website: https://prominencebank.com. - Inclusion of a 'Services' section The ideal candidate should have: - Proven experience in WordPress website development - A good eye for design, with the abilit...

exactly similar to this f-system

Need and experienced developer who is experienced in all aspects of ethical hacking and cyber security I need to test the security of our sites once built as well.

...are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract the required data and compile it into an Excel file with separate sheets for doctors' information

...`11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game. ----------------------------------------------------------------------------------------------------------------------------------------------------------------- Ideal skills for this project: - Strong experience with WordP...

I'm looking for drafters experienced in both civil and telecommunications projects to join my team. You will need to be proficient in AutoCAD and Civil 3D, as these are the primary software we use. Key requirements include: - Proficiency in both Civil and Telecommunications drafting - Extensive experience using AutoCAD and Civil 3D This is an ongoing project with varying deadlines, so being able to manage your time efficiently is a must. Please highlight your experience in both fields and your software proficiency in your proposal.

I'm looking for an experienced social media manager to increase the engagement and followers of my personal Instagram account. This account mainly focuses on my love for cars and travels. Key responsibilities: - Increase followers and engagement: Your primary goal is to enhance both the quantity and quality of interactions with my followers. Content creation: - Daily posts: Consistent daily posts are essential to maintain an active presence on the platform. - Photo posts: You will be required to capture visually appealing shots of my cars and travel experiences. - Videos or reels: I also need engaging video content, showcasing my cars and travel destinations. Ideal skills and experience: - Proven track record of managing and growing personal Instagram accoun...

I'm seeking an experienced Shopify developer to help me set up my online store. The following are the requirements for the project: - Implement key features: While I didn't specify which specific features I want, I will need you to be well-versed in Shopify's various functionalities and features. I may need assistance with product customization options, abandoned cart recovery, social media integration, or any other features that can enhance the user experience and increase conversions. - Product Volume: The number of products I'm planning to sell is unspecified. You should be comfortable working with a range of products, from small to large inventories. - Design: While I haven't decided on a theme or design for the store yet, it would be a...

I'm in need of a seasoned Sales Manager with a proven track record in the security and facility management industry. You'll be mainly responsible for closing deals and building robust client relationships. Your tasks will include: -Generate & Converting leads into sales - Maintaining long-lasting relationships with clients Ideal Skills & Experience: - Experience: More than 3 years in the security and facility management industry - Key Skills: Strong knowledge of customer service practices is essential. Familiarity with CRM systems will also be a great plus. Your dedication to customer service and ability to close deals will pave the way for our company's continued growth and success. Looking forward to working with a results-orientated Sales Manage...

I am an experienced Pick Basic software programmer with many years of experience in the field. I am passionate about expanding my skill set and delving into new technologies. Currently, I am eager to learn Salesforce and gain practical experience in this area. I am seeking a mentor or a client who is willing to guide me through a Salesforce project, providing me with the opportunity to learn and grow while contributing to their project's success. While I may have limited experience with Salesforce at the moment, I am dedicated, motivated, and quick to learn. Here's what I bring to the table: Extensive experience in Pick Basic programming and software development. Strong problem-solving skills and attention to detail. A proactive and enthusiastic attitude towards learnin...

We are looking for a skilled CFD & FEA expert to conduct simulations for our boat design project. Our goal is to optimize the hull design for two specific configurations: 1. Twin-Engine/Surface Drive Design: We anticipate using twin engines and a surface drive for optimal performance. The primary focus here is on optimizing the hull for handling, speed, and efficiency. We also aim to identify the performance sweet spot for this configuration. 2. Single Engine/Jet Design: We also want to explore the possibility of using a single engine with a jet propulsion system. The goal here is to optimize the hull for maneuverability and handling, rather than top speed. We want to determine if any drastic changes, such as a smaller hull, are needed...

I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.

I'm looking for an experienced design engineer to finalize the design of a functional metallic safe. This 10cm diameter round product is intended to function as a mini safe for storing small objects. It's not complex, design is on the last phase, we need a pro to complete the design to be ready to manufacture. The safe resembles a medal, consisting on a top and bottom part that screws together closing the safe. 3 main screws are needed to be designed, plus some other technical details to be defined, such has best thread sizes, materials, finishing and aesthetics. Also a small locking design is needed to be implemented. To complete this project, you'll need: - Proficient knowledge in mechanical design - Expertise in working on metallic surfaces intended ...

I am in need of an experienced developer to create a project management web application that's colorful and vibrant. My vision is to have: - Task allocation and tracking: An integrated functionality that gives us the ability to multi-task and keep track of on-going projects. - Time tracking: Time management is crucial for us, we need a system that keeps things timely and organized. Ideal candidates should have experience in developing project management software or any relevant web applications. Familiarity with a vibrant and colourful user interface is also a key requirement. Show me your relevant portfolio so we can collaborate effectively to bring this vision to life.

I'm looking for an experienced back and front end web developer who specializes in WordPress. The tasks involve handling back end functionalities and resolving front end issues on a WooCommerce based site. Back End Developer Responsibilities: - Manage and optimize the WordPress database - Integrate necessary APIs for smooth operation - Configure and optimize the server for best performance Front End Developer Responsibilities: - Fix WooCommerce related issues - Resolve theme errors and ensure smooth functioning - Correct responsive design issues and CSS conflicts - Undertake necessary programming tasks related to the theme Ideal candidates should: - Have a strong understanding of WordPress - Be proficient in WooCommerce and its ecosystem - Be skilled at...

I'm looking for an experienced professional to create a visually appealing email template. The template will be used on my domain-based email account for an email campaign aimed at increasing product sales. Key requirements: - Creation of a visually appealing, professional and engaging email template. - Ensuring the template is compatible. - A well-designed layout that can effectively deliver our sales-focused message. - Understanding of email marketing best practices, i.e., user-friendly design, call-to-action placement, etc. Targeted Customers: Entrepreneurs, Company Owners, Founders, Investors, Rich People, Executives and Directors, Research Professors Message to be delivered: We are offering Product Design & Development Service. Now, we need to send ema...

I'm seeking an experienced video editor who can breathe cinematic and dramatic life into my YouTube videos. To better cater to my viewers' preferences, I need an expert who can: - Edit raw YouTube video footage artistically - Incorporate professional motion graphics Your creative approach should focus on storytelling while offering a polished, professional touch. Experience in cinema-level editing is highly recommended. Proficiency in motion graphics software, such as Adobe After Effects, is crucial to this role. Demonstrated experience in similar past projects will be highly viewed. Be ready to show me a portfolio that demonstrates these skills effectively. Bring my YouTube videos to the forefront with your editing prowess.

I'm seeking an experienced and professional scout that can efficiently identify and recruit adult talent including models, performers and adult content creators. The talents you discover will be promoted across adult websites and dedicated adult content creator platforms. - Scout Requirements: - Exceptional eye for talent that fits within the adult industry. - Excellent communication skills to confidently discuss potential opportunities with new talents. - Having prior experience and connections in the adult content creator industry is highly desirable - you will need to have an understanding of the networks and content options available. The ultimate aim is to build a diverse talent pool that will invigorate our adult content platforms with fresh and enga...

I'm in need of experienced social media and search engine advertising specialists. My goal is to launch a comprehensive campaign that will increase brand awareness, bring in sales, drive traffic to my website, and generate leads. To achieve this, the ideal candidate will have a thorough understanding of: - Facebook advertising - Instagram advertising - Google advertising My target audience is across multiple demographics, specifically focusing on individuals aged 18-44. I'm looking for a professional who can tailor campaigns to these audiences, ensuring maximum impact and engagement.

...skilled freelancer to implement Continuous Integration and Continuous Deployment (CI/CD) using GitHub Actions, set up logging for each service, and configure an HTTPS domain for our web application hosted on Google Cloud Platform (GCP). The ideal candidate should have extensive experience with GCP, CI/CD pipelines, and HTTPS configuration. Scope of Work: 1. CI/CD Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. ...

...chapter summary!) while you're at it. We need your help creating short, clear summaries of existing gynaecology chapters. Think of it as the ultimate study guide - for you and your classmates! Bonus: Summarizing this stuff will actually solidify your own understanding of the material. Double win! Sound good? Here's what we're looking for: A fellow med student with a good grasp of gynaecology Someone who can take complex info and turn it into clear, easy-to-understand gold ? (think bullet points, key takeaways) Strong writing and editing skills (grammar police welcome!) ‍♀️ The process is super quick: Answer a few questions to show us your gynaecology knowledge. Summarize a short excerpt from a chapter. Easy peasy! Ready to ditch the textbook...

Conquer Gynecology Exams: Create Short, Clear Chapter Notes (Medical Students Only!) Need a study edge in Gynecology but short on time? We're looking for medical students to create concise, high-impact chapter summaries on gynecological topics. This is a fantastic opportunity to solidify your understanding while earning money! Fast Track Your Learning: Help Fellow Students: Create clear, informative chapter summaries for struggling students. Reinforce Your Knowledge: Condensing information strengthens your grasp of key concepts. Flexible Schedule: Work on summaries at your own pace. Competitive Pay: Earn 3 dollars per completed chapter summary. Ideal Candidate: Medical student with a solid foundation in gynecology. Strong reading comprehension and summarizing skills....

I'm looking for a skilled Facebook Ads expert to help me promote my anime clothing brand to a young adult audience. The primary goal of the campaign is to boost sales . since its a startup looking for someone who can generate good sales in the limited budget in the starting phase Key Tasks: - Create and manage Facebook Ads: You should be experienced with setting up and managing successful Facebook ads campaigns. - Tailor the content for young adults: You need to understand the preferences and behaviour of the young adult demographic and create content that resonates with them. - Optimize for sales: Your main focus should be on increasing our sales conversion rate. Ideal Skills and Experience: - Proven track record in running successful Facebook ads...

I'm looking to boost sales through a dedicated social media marketing strategy. Key Goals: - The primary goal of this project is to increase my sales figures. Therefore, I'm looking for an experienced professional who can design and implement an effective social media marketing strategy to achieve this. Key Requirements: - The target audience for this project is the general public. As my products are aimed at a wide audience, the strategy should be able to engage with a broad range of individuals. Ideal Skills: - Experience in social media marketing is a must. The candidate should have a successful track record in increasing sales through social media platforms. - Understanding and familiarity with general public demographics will be an advantage. Please...

I'm seeking an experienced street artist to transform an outdoor wall into a realistic masterpiece for beautification purposes. The project details include: Mural Objective: - To enhance the aesthetics of our local area. Art Style: - The artwork should follow a realistic approach. A deep understanding of realism in street art is key and previous work samples are appreciated. Design Theme: - 3D elements should be incorporated into the mural design to add depth and interest. Skill in 3D mural painting is essential. If you're passionate about enhancing public places with your realistic artwork, incorporating 3D elements, I invite you to place a bid. Sharing a portfolio of your previous projects is appreciated.

I am in need of a coder well-versed in Lua and experienced with IceSL. The task involves: - Developing a Lua script that can generate a 3D model. - The 3D model in question is a cycloidal gear and pinion element, generally employed In clock gears. Skills and Experience Required: Mechanical Engineer - Proficient in Lua scripting language. - Experience with IceSL for 3D modelling. This task requires an understanding of code as well as a foundational knowledge of mechanical engineering principles. If you possess these skills and experience, I'd love to hear from you. Please include any relevant work in your proposal.

...which delves into the connection between ESG scores and real estate company performance. The main questions I'm looking to address in the study are; - Are real estate companies with high ESG scores more profitable? - Does having a high ESG score increase investor interest in real estate companies? - What is the correlation between ESG scores and stock performance of real estate companies? The data for this analysis should be sourced from the past 5 years, and the report should be comprehensive and well-structured, with clear methodology and results. The study should be global in scope, encompassing a range of real estate companies and markets worldwide. This project would be best suited for someone with a background in finance, real estate, and/or sustainab...

I'm looking for an experienced Java developer to help me with my test cases. The primary focus of these tests is Integration testing for multiple components. Ideal skills and experiences: - Java programming - Expertise in Mockito/Power Mockito - Experience in integration testing - Ability to work with existing test cases and refactor them.

I’m looking for an experienced system programmer who can create a batch file or script that performs a specific set of tasks on a local W10/11computer. The tasks I need accomplished are: - Connect to the remote QNX computer via SSH (Secure Shell)( login/ password in config file.) -send some command (must be configurable - Run certain commands via batch file on windows 10/11 computer. (Configurable) - Run local bat comands on Windows computer (configurable) - Send key combinations on Windows computer (configurable) Managing errors if they occurs. Keep CMD open for manually entering other commands ( in feature can be automated as another project or add-on) Prior experience with batch file creation and QNX systems is necessary. Proficiency in SSH connections is a...

PiipAi is actively seeking a dedicated and experienced QA (SOFTWARE TESTER) to join our dynamic team. About Us: PiipAi is a forward-thinking software company committed to delivering innovative solutions that empower businesses. Our flagship product is a comprehensive Human Resource management suite designed to streamline operations and optimize people management. We envision this suite as a specialized CRM, tailored specifically to people-centric management. Role and Responsibilities: As a QA (Software Tester) at PiipAi, your role is pivotal in ensuring the quality and reliability of our software. You will work closely with our development team to meticulously test and validate our applications, identifying and rectifying any issues that may arise. Key responsibilities include: - Co...

I'm looking for an experienced data entry specialist who can efficiently and accurately convert English handwritten documents into digital text format. Key Requirements: - Data Entry Skills: Proficient in entering handwritten English text with a high level of accuracy. - Language Proficiency: Fluent in English for understanding and translating handwritten content. - Patience and Attention to Detail: Meticulous and careful when transcribing the text to prevent errors. It's important that the freelancer has a good quality keyboard, as well as a quiet work space to avoid any errors in transcription.

I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for...

I'm in need of a skille...platforms. Programming Language: - While I have no specific preferences for the programming language, developing the AI agent using Google App Script is preferred for the first version. However, feel free to propose alternative languages that can efficiently meet the project requirements. Ideal Skills: - Proficiency in AI development, with a focus on chatbots, automated responses, and data retrieval. - Bilingual proficiency in English and Hebrew would be an advantage. - Experience in creating and deploying AI agents for web and mobile platforms. - Competency in Google App Script development would be highly appreciated. - Abilety to show samples of similar projects you did. Feel free to ask any further questions for clarif...

We are looking for a talented and experienced SEO copywriter to join our team. This role requires a deep understanding of SEO best practices, excellent writing skills, and the ability to produce engaging, informative, and high-quality content. Responsibilities: Write and edit blog articles that are informative, engaging, and optimized for search engines. Conduct keyword research to identify high-potential keywords and topics. Optimize existing blog articles to improve their search engine rankings. Develop content strategies to increase organic traffic and improve user engagement. Collaborate with the marketing team to ensure content aligns with overall brand strategy and goals. Stay up-to-date with the latest SEO trends, tools, and best practices. Requirements: Pr...

I am seeking an experienced web designer to create a platform that caters to professionals, sharing information in a user-friendly manner. Key Requirements: - Design a user-friendly platform: The website should be easily navigable, ensuring that professionals can access the information they need without hassle. - Optimize for information sharing: The primary goal of the website is to provide a seamless experience for professionals seeking knowledge. The design should reflect this purpose. Ideal Skills and Experience: - Proven track record in web design: I'm looking for a professional who has a portfolio demonstrating their ability to create sleek and functional websites. - Understanding of user experience: Experience in creating websites that prioritize ...

I'm a venture capitalist seeking an experienced consultant to help create financial model for a fund . The perfect candidate should have: - Proven experience in seed growth-stage investments - Deep understanding of the financial model of venture caoital - Ability to adhere to our specific investment criteria Your responsibilities will include: create the financial moddel Ideal candidates should have a strong track record of success in the startup investment landscape. Your ability to identify promising startups and contribute to their growth will be key to the success of this project.

I'm in need of an English-Portuguese interpreter in Elvas, Portalegre, Portugal for an important in-person marriage interview. Key Requirements: - The interview is expected to last for less than 1 hour. This is a crucial detail to bear in mind. - The interpreter must be able to translate Portuguese to English and vice versa. It's essential that they are proficient in both languages. - Knowledge of legal terms is a must, as the interview will involve legal discussions related to marriage. Ideal Skills and Experience: - Fluency in both English and Portuguese is a prerequisite. - Prior experience with legal terminology and processes will be highly beneficial. - Previous experience in translating during marriage interviews or similar situations w...