How to prepare for sql interviewJobb

Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok

Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer

Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget

Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Stepping Back Through Data I have a table of orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', '...

I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the ability to...

...talented software engineer to construct a minimalist portfolio website for me on a custom domain. I believe the minimalist design will promote simplicity and emphasise my portfolio itself rather than the design aspects of the site. Ideal Skills and Experience: - Proven experience in website creation on custom domains - A strong understanding and appreciation for minimalist design principles - Ability to bring concepts to life, balancing both functionality and aesthetics The final product should be a clean, sleek, and easy-to-navigate website, reflecting the minimalistic style while providing exceptional user experience. My expectation is for a thorough, detailed-oriented professional who can capture my vision and translate it into a ful...

I'm searching for an experienced accountant with a strong understanding of Generally Accepted Accounting Principles (GAAP). The ideal candidate should be able to: - Prepare financial statements including Income statement, Balance sheet, and Cash flow statement. - Produce Auditor reports. - Work on an annual reporting period. Demonstrated experience in stock broking related accounting would be highly beneficial. Efficient, accurate, and dependable individuals, please apply.

...assistant with a strong finance background to manage various tasks. Key Responsibilities: - Budgeting: You'll be responsible for creating and monitoring budgets to ensure financial health. - Expense Tracking: Accurately log and keep track of expenses to maintain a clear financial picture. - Invoicing: Prepare and send invoices to vendors and clients in a timely manner. Your Experience: - Proficiency in Excel: Since I currently handle finance using Excel, it is essential that you are comfortable with this software. - Previous Finance Management: Experience in budgeting, expense tracking, and invoicing is a must. - Strong Communication: Being able to keep me updated and informed on financial matters is key. Please highlight your rel...

I'm seeking an experienced attorney to help prepare and file a civil complaint for a breach of contract case in Saint Louis County, Missouri. Key points of the project include: - I already have physical evidence supporting my claim. - I've identified the specific sections of the contract that were breached. Here's what you'll need for the job: - You should be licensed to practice in Missouri, ideally with experience in Saint Louis County's courts. - This is a dispute over ownership of a business. You should have a solid track record with contract law, especially in dealing with breach of contract cases. - You should be able to draft concise, precise complaints, focusing on where the contract was breached. - Strategizing ...

I am looking for a highly experienced legal virtual assistant who'll help keep my schedule manageable and my important documents organized. I handle mostly contract law, so a solid understanding of this area is paramount. Your Duties: - You will be entrusted with calendar management and appointment scheduling. - Conducting online legal research in the area of contract law is also expected. Requirements: - Proven experience assisting law firms, legal counsels or legal professionals. - Excellent familiarity with Video Conferencing Platforms as this is our primary means of communication. - Thorough understanding of contract law. A COMPREHENSIVE 3 STEP INTERVIEW SHALL BE CONDUCTED. PLEASE BID ONLY IF YOU HAVE EXTENSIVE EXPERIENCE AS A VA. Bids from skilled and dil...

...short-listed we'd conduct a short phone interview. We're looking for assistance in fashion curation, to curate outfits from brands like Shein and Fashion Nova. You’d create themed outfits for men, and women (including plus size), and contribute to our weekly publication. You should have a keen eye for trends, outfit color matching, and the ability to work independently. An example task would be where you’ll be given a headline (Island Chic: 15 Budget-Friendly Tropical Spring Trends) and a fashion brief detailing the desired vision, objectives, and brands for the Curation project. In short - You'll read the brief and based on the headline and details you will copy and paste links, sizes, and pricing (in...

I'm looking for an advanced Python mentor proficient in Websocket and SQL, who can help me with an automation project. Key requirements: - Profound knowledge in Python, including advanced topics and best practices. - Strong understanding of Websocket and SQL. - Experience in automation tasks would be highly beneficial. - Ability to adapt to different mentoring methods, such as video calls, live chat, or in-person sessions. Your tasks: - Mentor me through the automation project, providing guidance and support. - Help me understand and implement Python, Websocket, and SQL concepts effectively. - Adapt to my preferred session mode, whether it be video calls, live chat. Ideal skills and experience: - Proven expertise in Python, particul...

Looking for experienced computer programmers skilled in Python for a web development project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in building and maintaining web applications - Familiarity with front-end and back-end development - Ability to implement responsive design and ensure cross-browser compatibility - Good understanding of database management systems and SQL - Knowledge of version control systems and agile development methodologies Timeline: The project is expected to be completed within 3-4 weeks.

I'm in need of an experienced developer wh...experienced developer who's well-versed in ASP.NET and VB.NET. The project involves the event pages i need where user can login and acess the event throught calender with specific functionality.. i will share feature to slected one ... Ideal Skills and Experience: - Proficiency in ASP.NET & VB.NET is a must, with a proven track record of projects involving user authentication and database integration. - Strong understanding of SQL Server databases and how to effectively integrate them into a .NET environment. - Experience in implementing user authentication systems that cater to both roles and individual accounts. This project requires a developer who can deliver secure and efficient user auth...

...once I start the trial, people are failing to perform. Also, too many bids from countries I do not desire; Pakistan, Bangladesh, India, etc. I need a freelancer from LATIN AMERICA only. I need close to EST time!! Furthermore, I need a BILINGUAL freelancer!! So READ before biding. I need a fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: PR Outreach Social media Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, with great writing skills....

I require a skilled freelancer with experience in Amazon Web Services (AWS). We have a an ERP Developed on Laravel which is currently on a On-Premise Windows Se...require a skilled freelancer with experience in Amazon Web Services (AWS). We have a an ERP Developed on Laravel which is currently on a On-Premise Windows Server. We would like to move the application to AWS using a windows OS and SQL Server Database. Please guide as to which option would be better. The selected freelancer would have to set up a Windows operating system. Skills and Experience Required: - Proficiency in AWS, - Demonstrated experience deploying Please ensure to include examples of your previous AWS work in your bid. Your ability to efficiently handle tasks i...

We've developed an MS Access database front end with a SQL Server back end. Now we need to install both of these with government agencies in South America whose IT people only speak Spanish. We provide written installation instructions in English. Our clients can only meet the contractor online for server installations during business hours in American time zones. This is periodic work, installing databases whenever clients request them. At present we have six clients in the queue. The applicant must guide and troubleshoot each installation online in fluent Spanish. The successful applicant will have a record of relevant database work. We're a university-based not-for-profit.

I'm in need of a Public Relations Specialist to help enhance my client's speaker bio and prepare speech abstracts. - Speaker Bio: The bio should be styled in an inspirational and motivational tone. It should highlight my client's achievements and contributions in a compelling manner. A critical aspect is the inclusion of my client's list of published books and news articles that they've been featured in. - Speech Abstracts: The aim of the speech abstracts is to inspire action or change among the audience. The PR specialist should craft engaging summaries that not only encapsulate the key messages of the respective speeches but also motivate listeners to take specific actions. Ideal candidates should have a proven track record in publ...

...once I start the trial, people are failing to perform. Also, too many bids from countries I do not desire; Pakistan, Bangladesh, India, etc. I need a freelancer from LATIN AMERICA only. I need close to EST time!! Furthermore, I need a BILINGUAL freelancer!! So READ before biding. I need a fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: PR Outreach Social media Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, with great writing skills....

...Essential to this are two key tasks that require a skilled freelancer: 1. **Video Captioning**: I have 5 40+ minutes interview video with an engineer director that needs to be made more accessible. - Add Chinese captions to increase accessibility for those who are native Chinese speakers. - Add English captions to enhance comprehension for those that prefer reading along. The goal is not only to augment accessibility and comprehension but also to significantly expand the potential audience of my video. 2. **Thumbnail Design**: An eye-catching, bold thumbnail is desired for the above-mentioned video to draw the viewer's attention and attract clicks. The essence of my personal brand is to...

...3 years - Latest version of .NET & SQL Server - At least 1 hour of availability between 6:00PM and 11:00PM EST - Your price is the one that you REALLY want to have with 10% +- NOTE - APIs will be provided (you will not develop APIs) - No development will be done on My Computer. - DO NOT APPLY if your fees can exceed 10% or your bid PROJECT I have C# Blazor Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Make code debuggable. 2- Error message appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from APIs instead of loading from JSON file. (1 API) requ...

I'm looking for a freelancer to help me download a YouTube video for personal use. Requirements: - Download a 1-hour long interview video with the highest available resolution - The video should be delivered in MP4 format - No subtitles are needed Your role would be to: 1. Accept the job and I'll provide you with the YouTube URL. 2. Download the video with the highest resolution available. 3. Send me the video file using WeTransfer. Ideal Skills: - Proficiency in downloading and converting YouTube videos to MP4 - Familiarity with using WeTransfer for file sharing - Attention to detail to ensure the highest resolution is downloaded - Respect for confidentiality, as this is for personal use only

I am looking for a skilled video editor with a deep understanding of soccer. You will put together short videos that highlight the most exciting parts of matches, interview players and provide in-depth analysis for my Instagram account. The goal of my content is to engage with fellow football enthusiasts. Ideal skills for this project include: - Experience in video editing with a focus on sports, especially football. - Understanding of Instagram algorithm and what type of content performs well. - Deep knowledge of football, including key players, strategies and game highlights. - Ability to edit videos quickly and efficiently, often within hours of a match. This is more than just putting clips together - it's about telling a story that foot...

...collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and data-driven - Can effectively translate data into digestible i...

Looking for an experienced data scientist with a strong background in trading or stock market data analysis. Your tasks will revolve around data analysis and visualisation, along with other key data science responsibilities. Contract duration: 3 months to 15 months Position open: 2 Data scientists Key Responsibilities: - Perform data analysis and visualisation on trading or stock market data - Use your data science skills to provide valuable insights - Ensure the accuracy and efficiency of your predictive modeling Ideal Skills and Experience: - Proven experience in trading or stock market data analysis - Proficiency in Python, R, and SQL - Strong analytical and problem-solving skills - Prior experience with predictive modeling and algorithm development - Abi...

Tengo un Insert que proviene de una tabla que esta consumiendo mucho CPU al momento de ejecutarse, es un SP simple pero requiere de índices o validar que los que ya están creados no estén causando conflicto y aumenten el consumo del CPU

We are looking for a Florida Civil Engineer for 2 projects - 1 Mutli Retail Plaza and a Multi-Family Project in Florida, Volusia, and Brevard Counties. Here are samples of similar projects. Please review and quote. Civil engineers typically do the following: Analyze plans, survey reports, maps, and other data related to project design Consider regulations, site selection, and other factors relevant to a project Analyze the results of tests on soil and building materials to determine strength for foundations and other support Prepare cost estimates for equipment, materials, and labor to determine a project’s economic feasibility Use design software to plan transportation systems, hydraulic systems, and structures...

I will prepare a professional resume, cover letter and update his profile as well. I will also make changes if needed.

Google app script expert needed for stock price and data for world wide countries. Basically we have done for few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to...

... 01. If you are looking for a work life balance and work based on your sweet time. pls DO NOT accept this job. 02. Work life balance not for young man. Work hard when we still young 03. we only deal with business owner, if you are agency, sales manager or project manager pls do NOT accept 04. we dont mind if u are just a small team. as long as responsibility, work hard, fast respond and quality. 05. Respond message to your client even after working hour, sat or sun & public holiday 06. we only deal with team with fast respond, quality, friendly, good attitude & responsibility 07. prepare daily update in googlesheet 08. in some discussion will go by zoom & will request permission from freelancer before project start 09. reasonable new features cha...

...Payability Inc., to help with the reconciliation of books and preparation of financials. Key Responsibilities: - Reconcile transactions: The primary goal of this project is the reconciliation of transactions. Your role will involve ensuring that all financial records, particularly those from Amazon Marketplace, are accurately reconciled. - Bookkeeping: You would be responsible for ensuring that all financial transactions are accurately recorded. - Financial statement preparation: You will need to prepare financial statements, ensuring that they are accurate, and in line with generally accepted accounting principles. Ideal Skills: - Proficient in Payability Inc.: It is essential that you have a thorough understanding of Payability Inc., as it is the primary ...

I'm in search of a dynamic individual to take on the role of my brand ambassador. As the face and voice of my business, you will be responsible for brand promotion, social media management, and representing the brand at events. KEY RESPONSIBILITIES: 1. Participate in Beetek Solutions video production ad campaigns, as the on-camera spokesperson promoting our services. 2. Help develop content strategies tailored to Beetek Solutions target audience on YouTube, Instagram, Facebook, TikTok and LinkedIn, highlighting Beetek Solutions services. 3. Create media (videos and photos) of yourself or with other people when required, based on content strategies to create thought provoking, entertaining, informative reels, stories, post, etc. 4. Attend networking events,...

I'm looking for a certified engineer with CFD expertise. I need to simulate a fire scenario in one of the rooms of an 11+ story hotel. The focus will be on understanding how the fire spreads across the hotel and its impact on temperature, pressure, and heat flux in the rooms, hallways, and staircases. Key Requirements: - Conduct a CFD analysis focusing on the mentioned areas - Provide an overview of the fire spread - Analyze temperature distribution, pressure distribution, and heat flux - Prepare a detailed but basic CFD analysis report - Offer some insights into technical aspects of the findings Ideal Freelancer: - Holds a degree in engineering with a specialization in CFD - Has experience in simulating fire spread in large complex structures - Proficie...

Seeking a seasoned professional to guide me through landing entry-level data analyst roles or paid internships, all remotely. Responsibilities include job search, application assistance, interview coaching, and negotiation support. Offering 20% of my monthly salary as compensation upon successful placement. If you're skilled in career coaching and passionate about helping others succeed, let's collaborate!

...time series forecast for my Twitter dataset. The forecast should be for 1, 3, and 7 days ahead. The key deliverable is 3 dynamic dashboards that display this forecast in real-time. Key Points to Note: - **Programming Language**: Python - **Time Series Forecasting**: The freelancer is expected to have a solid understanding of time series forecasting methods. The deliverables should include 2 Neural Network and 2 autoregressive models (ARIMA, SARIMA etc…). The validation should demonstrate each model performance. - **Dynamic Dashboard**: I'm looking for a dashboard that's dynamic and interactive. It should display the forecast for the Twitter data using a visually appealing interface. - **Real-time Data Updates**: The dashboard s...

Seeking a compelling new mobile app icon for a public transit app. The design should integrate our primary colors which are blue and white. Old app icon provided for reference. The new design, which cannot simply be the letter M, might possibly incorporate the rail line colors on the system map file provided. Simple is better. Final deliverable should be in Adobe Illustrator Artwork file (AI) format. • Designer should have a solid grasp of iconography, color theory and commercial design principles. • Understanding of local symbols or cues associated with public transit would be useful. • Needs to be visually appealing and instantly recognizable as a transit tool. Prepare to share similar past projects in your portfolio when applying.

Se debe mantener un sistema hecho en .Net el cual esta vinculado a una base de datos SQL Server de Microsoft. El postulante debe manejar a la perfeccion el idioma Español.

Need to prepare dashboard, i have dataset and clear instructions

I'm searching for an expert in Visual Studio 2022, MS SQL, and VB.net, for the main objective of maintaining and updating an existing software application. Key tasks: - Primarily, the project will involve optimizing the application's performance. Skills and experience: - Experience with Visual Studio 2022, MS SQL, and VB.net is a must. - Proven expertise in software optimization. - Knowledge of system maintenance and updating.

We are looking for a highly organized and proactive Virtual Assistant to support our upper management team. As a Virtual Assistant, you will be responsible for providing administrative support, managing schedules, handling communication, and assisting with various tasks to help our executives operate more efficiently. Responsibilities: * Manage and maintain executives' schedules and appointments * Coordinate meetings, conferences, and travel arrangements * Screen and direct emails * Prepare reports, presentations, and documents * Conduct research and compile data as needed * Assist with project management tasks * Handle confidential information with discretion * Provide general administrative support to the upper management team Requirements...

...in Automate for Android from LlamaLab to streamline our app registration process. The ideal candidate will have extensive experience in automating tasks on Android devices using Automate from LlamaLab. The project involves the following steps: - Receive HTTP POST Request: Automate will receive HTTP POST requests from our website containing JSON data. - Data Preparation: The received data's strings and parameters will be prepared for further processing. - Open App and Navigate to Registration: Automate will open the designated app and navigate to its new user registration activity. - Fill Registration Form: Automate will insert the data's strings and parameters into the registration form fields. - Submit Registration: Automate will press the...

I am in search of seasoned mobile application developers who can help to design and publish a variety of small utility apps on Android and iOS. The apps required include, but not limited to: - To Do list - Stopwatch - Expense Tracker - Gallery Lock - Truth Or Dare Developers with competence in creating intuitive and user-friendly apps would be preferred. Your experience in developing utility apps will elevate your portfolio. Specific functions will be discussed in greater detail during the interview process. Ideal Skills: -Proficiency in Android & iOS application development -Demonstrated experience in creating utility-based mobile applications -Strong understanding of modern app design principles.

...am looking for a skilled and experienced researcher who can prepare a series of 5 comprehensive research proposals on Product Management. These proposals should specifically focus on important emerging areas in this field, including Design Thinking, Gen AI, and Responsible AI. The completed proposals should adhere to APA style guidelines. You need to share me the list of topics to choose from for top 5 ones. Key Requirements: - The proposals should reflect a PhD level of academic rigor and depth. - The content should be rich in insights and details, offering fresh perspectives on Product Lifecycle Management, Design Thinking, Gen AI, and Responsible AI. - The proposals should capture not just the current landscape of Product Management, but als...

I have a 500MB XML file that I need loaded into SQL across approximately 20 tables. I'm in need of a Python script to handle the transformation. The script will need to handle normalization of the data. Key requirements: - Develop a Python script to read the XML file and transform the data into a normalized structure across 20 tables. - You will need to create the SQL tables as part of the normalization process. - Experience with large data transformations and SQL is vital.

I'm in need of a talented script writer to craft a comedy rap script for an all-ages audience. The main theme of the rap is about overcoming adversity. Good afternoon I hope you are having great day, Thank you for applying for this freelance opportunity! Your portfolio looks very impressive and we would like to invite you to complete a short trail task as part of the recruitment process Firstly, a little bit about Crealon Media. We are a dynamic, innovative, and ever-evolving company that operates primarily in the social media landscape. Over the past few years, we have established several incredible brands and continue to grow at an accelerated pace. We aim to produce varied content to delight and engage millions of vi...