Ciglobalsolutions sql interview questionsdela

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

Hello All, We are an established IT services provider with 13 years of experience and a team of 25 in-house developers. Currently, we are looking to hire some freelancers because we are at full capacity and do not have sufficient resources to handle some of our work. We are seeki...require an expert Laravel Developer who is well-versed in third-party APIs. The candidate must have experience working on incomplete projects and be able to easily adapt to other developers' code. We will provide you with project details, and one of our developers will guide you through the workflow. You will need to collaborate with our developer to understand the project better. A technical interview will be conducted. A minimum of 6 years of experience is required to handle this job. That’s...

I'm in need of 4 consumers based in Karlsruhe, and visit 8 stores per city. Your task...and diary. -All data will be captured via an App thus good quality photos are needed. --Answer questions related to the product via the APP. -Full training provided. This data is critical to enhancing the product packaging for this brand, and your work will be instrumental in this process. Ideal Freelancer: - Resident in Berlin, Hamburg, Karlshue, or Stuttgart - Detail-oriented and reliable - Replies to emails promptly - Excellent communication -Tech Savvy -Flexibility with time to visit stores. 4 weeks to complete project Project fee €600 There is a second project linked to this brand: the consumer will assess 6 drugstore products (more information and project fee will be provide...

...assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, in...

...or Vendor Central accounts • Uploading new content the team provides on to seller central or vendor central of the client account • Doing regular checks on our Amazon Seller Central accounts for any policy violations or account health warnings • Doing regular audits to our product listings to ensure proper operations • Inventory Forecast and Review Management • Communicate with clients (e.g. questions about shipping, content revisions, etc.) • Staying informed with Amazon’s best practices, new trends and technologies, and platform updates • Inspecting landing pages, product information and all other listings to check if they conform to your checklist Preferred skills • Minimum 3+ years of experience working as an Amazon Account Manag...

I have an iOS app ready to go and an active Apple Developer account. I've managed to set up the app's metadata and assets for the App Store. However, I need someone to assist me with the final step of actually p...actually publishing the app. Ideal skills and experience: - Experience with publishing iOS apps to the App Store - Knowledge of Xcode and the iOS development process - Proficiency in managing and navigating the Apple Developer account interface - Ability to troubleshoot and resolve any publishing issues that may arise - Excellent communication skills to guide me through the process and answer any questions I may have This project is quite straightforward as most of the work has already been done. I just need someone to take the reins and ensure the app gets pub...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

...setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on

...set of lessons to follow. Ideal candidates for this project would have: * Proficiency in video creation and editing * An understanding of art and conveying it through lessons * Experience crafting effective marketing reels for a similar audience * Ability to communicate well and teach the artist basics of recording and editing own videos I attach a sample of works. Please feel free to ask any questions. As this is a trial project, it is on limited budget....

...pads for 2-5-year-olds. Our product is thriving in China, and we're now targeting the U.S. market. Now, we need a talent to take on game card designing. I will send you a video and some materials about our product. The page size is only:244mm*152.5mm DPI: 300 Please let us know if you are interested in this project. We're excited about the potential collaboration. Don’t hesitate to ask any questions....

Vanakkam Editing Enthusiastic, I hope this message finds you well. I'm reaching out because I'm in search of a talented YouTube editor based in Bangalore for a Tamil cooking channel who knows Tamil language both read and write. Here's a brief overview of what I'm looking for: Experienc...I'm looking for: Experience in editing cooking videos, particularly Tamil cuisine. Proficiency in latest video editing software and AI tools. Ability to add subtitles in both Tamil and English. Creativity in enhancing video quality and engagement. If this opportunity interests you, I'd love to discuss further details, including compensation and workflow. Feel free to reach out if you have any questions or if you'd like to see samples of our content. Looking f...

*PLEASE READ THE GOOGLE DOCK BELOW CAREFULLY AND CONTACT US FIRST IF YOU HAVE QUESTIONS* Details of our current project STACK can be seen here -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we

I'm seeking an energetic and engaging actor who can boldly approach people on the street and ask them trivia questions centered around pop culture. - The right candidate would ideally have a background in an interactive and spontaneous form of entertainment such as improv or stand-up comedy. - This job requires a friendly and approachable demeanor to establish quick rapport and get people to participate on camera. - The goal of this project is to create humorous responses from the public - so, a great sense of humor and quick wit would be beneficial. - Additionally, some knowledge of pop culture would be advantageous in facilitating engaging and entertaining exchanges.

I need between 1-2 freelance interviewers to: - Conduct market research interviews in key areas around Vietnam including Hanoi, Ho Chi Minh City, and Da Nang. (Phone/online interview available as well) The ideal candidate should have: - Proven experience in market research interviews, with excellent command of Vietnamese and English languages. - Strong skills in communication, recording, and documentation of research data. Please apply if you fulfill these criteria. I look forward to your bids.

...impactful visual content to make changes to an existing electronic survey I have in Survey Monkey. Here is some insight into the specific tasks you'll be undertaking: - Update and enhance the current survey: This involves infusing fresh content by updating existing questions, introducing new questions, and replacing the current graphics. - Create an entirely new survey: This will include a mix of existing and new questions, along with logos and product images. The goal of this survey will be to gather customer feedback, so creating questions that retrieve valuable customer insights will be essential. - Build a survey flow and link answers for follow up automated EDMS and other forms of communication. - Survey results will then collate into an existi...

I have a PDF file that needs its background changed. I'm looking for a professional who can assist with this task. Your responsibilities would include: - Changing 4 pages the background of a PDF file to a specific color (color to be advised) - Selecting a suitable color to enhance readability and aesthetic appeal It would be helpful if you have: - Expertise in PDF editing - A good unders...responsibilities would include: - Changing 4 pages the background of a PDF file to a specific color (color to be advised) - Selecting a suitable color to enhance readability and aesthetic appeal It would be helpful if you have: - Expertise in PDF editing - A good understanding of color theory and design - The ability to provide guidance on color selection Please let me know if you have any ...

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking

I'm in need of a talented 3D designer who can bring my vision to life. The project involves creating a realistic 3D rendering for mattresses, providing a clear representation of both the internal components and top cover. Key Project Requirements: - Capability to visualize and create the internal components of a...custom artwork into 3D designs - Proficiency in creating realistic 3D artwork for a top cover I'm looking for a freelancer who is skilled in 3D design and rendering, with a keen eye for detail. Experience in the furniture or textile industry would be a plus. Details of the number of mattresses, details and requirements are included in the attached brief. Feel free to reach out if you have any questions or need further clarification before bidding. Look forwa...

Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).

Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto

I'm looking for a talented designer to create a logo for my business. The logo should be unique, visually appealing, and help establish a strong brand identity. All requirements are in the attached. Any questions please DM me. Thank you

Here is the next video for Groups. All the files are here: Let us know if you have any questions.

I'm a student/recent graduate in Mechanical Engineering. I have a few general questions I'd need a competent and knowledgeable mechanical engineer to help me with. I will send you the questions and would require a very prompt response. I'm looking for someone who can assist me with open-ended mechanical engineering questions that might include but not limited to: - Basics of Mechanical Engineering - Understanding and applying engineering principles - Problem-solving in mechanical design - Thermodynamics and heat transfer - Fluid mechanics - Any other relevant topics in mechanical engineering The ideal candidate should: - Be a Mechanical Engineering student or recent graduate. - Have a good grasp of general mechanical engineering concepts and theorie...

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the...

Our Company Trans-Continental Textile Recycling Ltd. is a textile recycling company established in 1990, with 34 years of growth. We are based in Surrey BC with an operation in Calgary. We recycle textiles from the whole of Western Canada and ship finished pro...o Sign Shop o Print Shop o Adobe Illustrator • Knowledge of Roland TrueVIS VG540 would be highly valued. • Quick learner of new printing and finishing equipment • Strong attention to detail and ability to meet deadlines. • Excellent understanding of digital printing principles Please feel free to present your portfolio to support work experience with a cover letter or during an in-person interview. Benefits: • Hybrid position • Part-Time opportunity with flexible schedule weekdays and w...

...verses in that chapter for selection. ELSE the app prompts the user is incorrect and also prompts the correct chapter answer. C. THEN, IF the user selects the correct verse, then the app prompts that the user is CORRECT and scores an additional point. ELSE, the app prompts the user is incorrect and also prompts the correct verse answer. Repeat until the 10 questions of the questionnaire is complete. 3. At the end of the 10 questions, it displays your total score out of 10. 4. Afterwards, it returns to the home page, to START. The app should meet the following requirements: - Conduct a simple questionnaire based on the provided API - The app should be mobile compatible, as in looks aesthetically sound on mobile. - Should be compatible with all major browsers on PC, Ma...

We are looking for a videographer who can shoot an interview and b-roll for a tech company corporate video, in Oklahoma. Including use of a basic set of lights (in case the location requires it), and sound recording. No editing needed.

We are looking for a videographer who can shoot an interview and b-roll for a tech company corporate video, in San Antonio, TX. Including use of a basic set of lights (in case the location requires it), and sound recording. No editing needed.

...the assigned Digital Strategist and Graphic Designer. Responsible for the publication of content, on time, taking care of spelling aspects. Work hand in hand with the Graphic Designer assigned to the team, for the execution of creative content, proposing and ensuring the fulfillment of goals and objectives. Writing creative blogs and current trends. Ability to communicate clearly with users to interview them to create compelling customer success stories Position requirements/ Skills: 3 to 5 years of experience as a Marketing Content Manager, Community Manager, or related positions. Previous experience working with SaaS B2B Edtech companies is a plus. Bachelor's degree in Communication Sciences, Marketing, or related field is a plus. Experience executing different social me...

Bids cannot be changed once made, so bid accordingly or ask questions before you bid to get a feel for what is required... I am looking for an experienced UX/UI designer to refine and enhance my funnel pages. Although the elements already exist, their arrangement and optimization need attention to significantly increase conversion rates. The optimal candidate should have a solid portfolio of similar past work for review and have strong skills in CSS/HTML along with design skills. I'm interested in seeing examples explicitly demonstrating your skill in effective funnel page design meant for conversion increase. I will primarily measure success through increased conversion rates. I will provide the list of several items I would like improved over my existing site. Skills and...

...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mo...

the workbook consists of the below sections: - Section 1 - Vocational Education & Training - Section 2 - Core & Employability Skills - Section 3 - Learning Design - Section 4 - Learning Delivery - Section 5 - Assessment - Section 6 - Administration - Section 7 - Work Health & Safety each section contains between 15 to 26 questions, i will provide martial to help with finding the answers. the workbook is a training and assessment work book

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...

I am looking for only Indians. I'm in need of a skilled writer for two key tasks: a business report and a blog post. Please note that some details were omitted by the client, so you may need to clarify them as you work. For the business report, I'll provide ...audience is also not clearly defined, so the content should be versatile and appeal to a broad range of readers. The ideal candidate for this project is: - Experienced in business writing and market analysis - Proficient in creating engaging, SEO-friendly blog content - Able to adapt writing style to different target audiences - Comfortable with some degree of ambiguity and able to ask clarifying questions - Able to deliver high-quality work within agreed timelines. Please include samples of your previous wo...

Data Specialist: The Data Specialist is responsible for pr...information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ com...

...has been included in the advice document. All fees have been disclosed, all the correct products have been mentioned, recommendations, and reasons, no incorrect client names have been used (sometimes we cut and paste from other advice documents, so we need to check that the wrong name has not been included) etc. Again, the above is not an exhaustive list, but it is to give you an idea. My questions: 1. Can the above be done? 2. Can it be done with one prompt, or will there need to be several prompts that are ‘layered’. This will be important as I will be asking AI / Technology unsavvy people to use these prompts, so they need to be easy to use. 3. What would be the cost of this project for you to design…something. 4. Do you provide a guarantee? I do no...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...

Hello, this is a simple task. One of my friend got french nationality after 7 years live in France. All he want write a simple and nice text for post all of his social media profile to tell his story.. little bit motivations will appreciate on the text. 500 words maximum. If possible give a photo with textes. But no obligation.. ask all the questions need to ask in private. Small budget. Thanks.

I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...

I'm in need of a skilled Python developer with knowledge of RAG and Chainlit to create an AI-powered chatbot. - Specific Tasks: - Develop an interactive chatbot to be used by customers - Implement RAG and Chain...interactions and provide accurate information - Integrate the chatbot seamlessly into our systems and platforms - Desired Qualifications: - Proficiency in Python, particularly in relation to chatbot development - Expertise in RAG and Chainlit - Experience in creating chatbots with strong interactive capabilities The primary functionality for this chatbot will be answering frequently asked questions. The successful developer will need to be able to create a user-friendly interface and ensure the bot is able to provide clear, concise answers to a vari...

Basic hello world sketch project for screen. Connect to Xiao_ESP32S3 sense via screen. No time wasters please, questions welcome. Immediate start preferred, follow up opportunity for successful completion.

I'm looking for a Google Sheets expert to help me automate a process involving day by day data input process I'm seeking a freelancer who can streamline and automate the repetitive task of data import and export in Google Sheets. The ideal candidate should possess the following skills and experience: - Proficient in Google...streamline and automate the repetitive task of data import and export in Google Sheets. The ideal candidate should possess the following skills and experience: - Proficient in Google Sheets: You should have in-depth knowledge of Google Sheets and be able to manipulate data effectively. - Automation Skills: Experience in automating processes in Google Sheets is essential. Feel free to ask any questions, and please provide relevant examples of your p...

...our employees. They will be the primary users and beneficiaries of the program. Content Categorization: The training content should be organized by product type. This will allow our employees to easily find and engage with relevant training materials and resources. Training Process: Each employee will access pre-recorded training videos. I will personally upload the videos as well as the quiz questions with their respective selection options. Successful completion of the quiz should generate a PDF diploma. Additional Requirements: The platform must be responsive and developed using technologies such as PHP and HTML5, allowing full customization from the control panel. It must include a panel or dashboard from which I can upload more information, options, or videos in a personaliz...

...in analyzing and interpreting the testing results. Make necessary adjustments and optimizations based on the testing outcomes. Documentation and Support: Provide clear and comprehensive documentation of the converted strategy, including code comments and explanations. Offer guidance and support to our team in understanding and maintaining the converted strategy. Be available for follow-up questions and provide timely responses to any issues or concerns. Requirements: Strong proficiency in Java programming language. Experience with the Bookmap API and integrating custom strategies. Familiarity with Pinescript and ability to understand and convert Pinescript code to Java. Knowledge of trading concepts, indicators, and strategies. Excellent problem-solving and debugging skill...

... The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clear...

I need a creative and skilled video editor to transform raw footage into a polished, 5-10 minutes interview-styled video. Requirements: - Edit video and audio for clarity, smooth transitions, and optimal viewer engagement. - Implement a documentary-style editing approach. - Overview of key discussion points or narratives to be highlighted in the video will be provided. Ideal Skills and Experience: - Proven experience in video editing (particularly documentary-style). - Proficiency in video editing software such as Adobe Premiere Pro or Final Cut Pro. - Strong attention to detail. - Ability to work independently and meet strict deadlines. - Creative mindset with a knack for storytelling.

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...

NO AUTO BIDS - ONLY ZENDESK PRO! 'm in search of an experienced developer skilled in Z...API integration for a project related to airline claim forms. I will provide you parts of the template and you will add the form, calculations, API integration and ticket creations. The website should be built in Laravel or secure platform. If you know about EC261 claims it makes it way easier to choose you. You will do the following: - Create a form which is predefined through parameters and questions. - Add airline and airport database and organize the data with live search preview. - Calculations based on airport distance and claim form. - Zendesk ticket creation along with correct ticket numer and relevant information. - Multilingual form and site (Swedish and English). Need someone...