SQL Jobs

We are seeking a skilled and experienced frontend developer to join our team on a freelance basis. The job will involve developing the frontend of our website using Node.js and React. Additionally, we require that the candidate has a good understanding of Amazon Web Services, SQL, and querying. Please note that we already have a team in place for the backend development of the platform, and the successful candidate will be required to work closely with our backend team to create a cohesive and functional platform. The ideal candidate will have: Strong experience with Node.js and React Experience with AWS Knowledge of SQL and querying Good communication skills Strong attention to detail Ability to work independently and meet deadlines Also valueble to have knowledge of webflow (and figm...

Convert your ER diagram to a relational schema. ( ➢ Underline all key attributes in your relations. ➢ Specify all functional dependencies for each relation. (Mapping) - Use Oracle to create the normalized tables. - Populate your tables with 5 rows at least. - Design and implement at least 4 queries. As specified below Data Retrieval Queries with Select (total of 4 Queries) ➢ Where ➢ Order By ➢ Group By ➢ Aggregate functions ➢ Subquery ➢ Join query - Note: ➢ You are free to mix between all those clauses in one or more query, but you have to use them all so the total number of queries for Data Retrieval Queries with Select in the end will be 4. ➢ Using select all (*) is NOT accepted. - Design two stored procedures as the following ➢ Create a PARAMETER based SELECT QUERY stored procedure ...

Convert your ER diagram to a relational schema. ( ➢ Underline all key attributes in your relations. ➢ Specify all functional dependencies for each relation. (Mapping) - Use Oracle to create the normalized tables. - Populate your tables with 5 rows at least. - Design and implement at least 4 queries. As specified below Data Retrieval Queries with Select (total of 4 Queries) ➢ Where ➢ Order By ➢ Group By ➢ Aggregate functions ➢ Subquery ➢ Join query - Note: ➢ You are free to mix between all those clauses in one or more query, but you have to use them all so the total number of queries for Data Retrieval Queries with Select in the end will be 4. ➢ Using select all (*) is NOT accepted. - Design two stored procedures as the following ➢ Create a PARAMETER based SELECT QUERY stored procedure ...

I am looking for an expert to modify a sports betting site, this person will have to add API from and also change design to replicate JavaScript JS, HTML, CSS, PHP, SQL

Hi! We use schematron rulesets to validate XML documents. We want to import these schematron rules into an Database (BaseX) and let validate the XML right there. We hope that way the validation is much more faster than traditional validation. We search for someone who is familar with XQuery and Databases generally. The Documentation how to import is also here to find:

I need the Database Programming coder needed for multiple jobs. Details will be discussed.

The following changes are required to be made to orange hrm system already currently installed, and already full of information. The software has been used by our company for about a year, and as of today we need the addition of these functions: Ability to report for each employee, and for each month and year of : Days Worked; Vacations Used and Remaining; Leave used and remaining; Possibility to do export of hours worked on each project for each employee (report for each month and year); Possibility to Upload pdf files for each employee ( by manager) for payroll and year-end single certification; Travel notes: a section within which the employee can add what travel he/she did and any expenses incurred ( possibility to attach pdf for receipts/receipts) I provide access data from web inter...

Need a developer who can scarp the website and handle captacha in c# project, fetch data and push into sql. 1. Step 1. RUN BELOW LINK IN backend. A. ENTER PAN NUMBER/AADHAAR NUMBER B. ENTER CAPTCHA 2. Step 2. A. Capture details mentioned in table B. Push that data in SQL. Language c# project, webapi required

Quicksight insights project developing dashboard

Please Sign Up or Login to see details.

We need to build an API link between Zoho CRM Plus and an ERP system called MIETrak Pro. Thanks, -Josh

A webapp which takes data as input (a markbook later where teacher can enter marks) shows this to user for the data cleaning and saves this data which is then used to produce the analysis. This is a pupil assessment tracking system which can accommodate any curriculum with some basic subject and assessment criteria setup. some basic info that can be saved is student basic data and teachers should be able to upload multiple files (some based on internal configuration of assessment and other external exam data.) After the upload, there is a report section which picks up this data and shows it in required way (High achievers/low achievers/top 10 per subject/average grades etc) comparison of class marks with either class etc

We require a web based database application for cemservices which will manage various types of construction contracts and labour input.

• Participate in data migration activities • Creation of transformation scripts and tasks • Consult with various stakeholders including subject matter experts to understand the source and target data models • Develop a detailed understanding of data models for projects that are part of current and future migrations • Execute data extraction, cleansing and loading from various systems. • Adhere to company and best practice security standards • Participate in data quality and reconciliation activities Skills and experience • Experience with analyzing data models in both source and target system landscapes and defining appropriate mappings and transformations necessary to successfully migrate the relevant data • First-hand experience working on med...

need fix a qurrent query to verify if data match in other table before update

We have PostgreSQL queries/codes that require to convert to in Snowflake equivalent.

Need SQL Database management (Oracle) Expert to do the project. If any interested apply

I am looking for an expert to take 3 online technical assessment tests (in French) for an interview, Each test will take1 hour Stacks: java, nodejs, angular, sql

Please Sign Up or Login to see details.

Below is the JD of the above. Want a candidate who has less/competitive budget. As a SQL DBA/ Migration Engineer you will be fully engaged in the migration project for Microsoft SQL Server. Our team works with precision and speed. We are looking for a candidate who is ready for this challenge. Job Description What you will be doing as a SQL DBA / Migration Engineer Have some 2008 R2 and majority R12 that needs to be upgraded to R19 § Create Test Database environments to research and solve database upgrades pre-production upgrade § Upgrading current SQL Database to new supported version for Windows Server Migration to 2019 § Migration of existing Databases to new Windows Servers § Restore data and ensure that current databases work as expected § Provide expert l...

Need help with importing CSV files into SQL Server DB. It gives an error message while doing the insert

Note: I do not want a wordpress/php based implementation. I would humbly request that people who are not comfortable with Java, J2ee, GCP should not place a bid. I need a GCP (Google cloud platform) based collection of few simple microservices for : user, auth, storage, frontend, etc. I am particular in getting it deployed on GCP. The web server will have following components: 1. A frontend in the form of a website, where some of its data is dynamic. 2. I would prefer the website written in such a way, that the UI should not break on mobile devices. 3. The server will have a database, which manages user data and their activities. (The amount of data is not much). 4. The system primarily has two types of users. And they both see different data based upon its role. I would prefer that the ...

Description Requirements: · 5+ years of experience with SQL · Expert in working in a Data Lake Environment · Experience with AWS · Strong experience in Data Warehousing, ETL and ELT, Data Modeling · Exposure to CI/CD and version control · Strong database knowledge (Oracle, Postres, and/or SQL Server) Preferred skills (Plusses): · Experience with Snowflake – HUGE plus · Experience with Java and/or Python · Experience with Azure Daily responsibilities: In this role, you’d be joining the business unit focused on the Data and Advanced Analytics platform. The team is in the process of decommissioning and converting their platforms into the datalake, and looking for someone with strong knowledge in data wareh...

Hello , I need some one with high experience in the field Of SQL injection To test our website is it vulnerable for SQL injection or not start your bid with "hello "

I need an expert who is good at working at SQlite

combine multiple sqlite dbs into one sqlite db

I am looking for an assistant who can help me with a variety of tasks throughout the week. (This could be an ongoing arrangement into the future) The kind of tasks involved would include: - Data Analysis in Excel - Power BI - Power Automate / Logic Apps - SQL. Experience with queries and database. - Business analysis / requirements Tasks would be managed via Trello or some other task management system Would be nice to see some examples of previous work or if you could explain some projects you're worked on that include the tasks I mentioned above

***Please Message Me for the Password for the Document if your reading this.*** There is no source code , no data, FROM SCRATCH , I have purchase the PWA Theme for this project. Hello, I'm looking for an honest and trustworthy full stack developer that can handle this small project. English is Required , Can start rite away or within the next few days. This project is Phase 1 . There is a total of 3 Phases for this Project . In this document is ONLY PHASE 1 If winning bid for phase 1 is approved and finished on timely manner , then that developer will have first bid to give to win over phase 2 and same goes for phase 3. Only best price and winning bid with good time frame will be picked. I have attached Phase 1 of this Project only ***Please Message Me for the Password for the Docu...

I want you to write me a SQL script with the following: Dimensions: 1) Date 2) Breadcrumb (this is a hit level custom dimension) 3) Device 4) Channel Metrics: 1) Entrances 2) Bounces 3) Total session Duration (s) 3) Add To Cart Completions (This is a custom goal) 4) Reached Basket page (based on URL) 4) Transactions 5) Revenue Filters: 1) Only show date for sessions where the landing pages, had Page Type = PDP (Page Type is a custom dimension) 2) Date range = 1st Dec 2022 - 31st Dec 2022 This is a quite basic script - I expect it to take 2hrs maximum. Do not reply if you are not confident with SQL. Do not reply if you can't do the job in 24 hours.

This application on a Data that you must specified to manipulted with Create, Read, Update, Delete With style and structure you want

Need to collect streaming data from S3 using Kafka and do some analytics using Spark sql and dump into a database

I need an expert who is good at azure database

Hi there , I am looking for a professional who can teach me SQL withing 2 months . I am ready to give my 4-5 hrs daily if possible to learn that. I am new to this field thus need excelent teacher for beginner like me. mentione your exp. along with price skills needed- sql and python

I'm looking for someone to help me draw the fact table (with Pentaho or some other tool) from the following database: This fact table will be used later for the implementation of the data warehouse. (You don't have to implement the data warehouse, just generate the fact table using star or snowflake.) The fact table must be designed so that the company can know how its sales are evolving over time and what type of demand is associated with each of the products. I also need help answering the following theoretical questions (no code or implementation needed). 1. Specifies the steps the company must follow to implement its data warehouse for the sales department. 2. As a business intelligence expert, what guidelines would you give the company to implement its business intelli...

Looking for Full Time Power BI Expert

we need developer who can perform below steps. Step 1 API key authentication. Basic authentication. OAuth 2.0 Client Credentials Grant. Session-based authentication. step 1.2 sample attach. 1. xml c# class file c# class file step 2 converted class push into sql database step 3 want to export class file again in xml or json in same format with same sequence. Step 4 Verify/check exported xml/json working or not Want to authenticate from different menthods mentioned in step 1.1. Then convert xml and json file request/response into class mentioned in step 1.2. In step 2. class response push into sql database table. 3. export the xml/json from sql db table into same format at step no. 1.2. But with the mapped data in same sequence. Step 4 run the exported xml /json the responsr are...

Looking to create a real estate of property developers and investor. You job would be to source sites like linkedin, youtube and facebook. Compile phone number address occupation annual income etc. integrate this information in to site. verify mailing system is working. etc. PHP SITE

I need an experienced database administrator to help extrat data from a database that got corrupted but was recovered using a database recovery tool.

For my .Net application, some of the vulnerability fixes are needed. Please reach out to me for further details to discuss on this.

Hello ! I am looking for someone to keep improving a dashboard on Retool. Everything is already all set but I need someone with good experience in JS to improve the dashboard. Having experience with Retool will be cool so please when you answer give me your experience : - JS and Framework - Confortable with SQL ? - Retool : How many projects ? - Time slot of availability - Monthly salary expectation - Front experience This is for at least one year cooperation because after Retool we will probably integrate all the internal dashboard to another platform. Please use the world GOLD at the beginning of your text to make sure that you read, if you didn't I won't reply :)

I want to learn Python, Hive and Pyspark and to solve complex sql queries personally from a expert level developer. Need a expert data engineer to help with different king of data engineering work.

Project: Create a single PowerBi file with multiple pages. > Data will be sourced from a single SQL view. > Parameter required to specific Year and Company > Ability to export reports to EXCEL > Ability to use data and update existing excel templates.

Hello ! I am looking for someone to keep improving a dashboard on Retool. Everything is already all set but I need someone with good experience in JS to improve the dashboard. Having experience with Retool will be cool so please when you answer give me your experience : - JS and Framework - Confortable with SQL ? - Retool : How many projects ? - Time slot of availability - Monthly salary expectation - Front experience This is for at least one year cooperation because after Retool we will probably integrate all the internal dashboard to another platform. Please use the world GOLD at the beginning of your text to make sure that you read, if you didn't I won't reply :)

Our business receives a large amount of data in different formats (EDI, excel, CSV, pdf etc.). This data is sent to us by suppliers and members so we can perform a number of services. We use a tool called Magma which transports and transforms these files into standard formats that can be accepted by downstream systems. The Magma tool has configurable runsets which use XSLT to test and translate the file received. We are currently focused on a project to upgrade several of our systems and there is a number of challenges with the existing Stylesheets that need correcting. We require someone who has strong XSLT skills and experience of SQL queries would also be advantageous. The bulk of the work will be updating and testing the XSLT’s ensuring they are correctly testing the data r...

Recruit Overseas is seeking a Snowflake Developer, based in Texas. We have a full-time, hybrid role for a global business based in Texas. Snowflake Developer Job Description As the Snowflake Developer, you will work with the development team to create technical designs, write code, and unit test new features. You will also be responsible for enterprise ETL jobs using Informatica PowerCenter. In order to be successful in this role, you should have experience in data warehousing, dimensional modelling, and writing SQL queries. Snowflake Developer Job Profile A Snowflake Developer is responsible for the construction and maintenance of enterprise-level applications using the Snowflake platform. The developer must be able to work with a variety of stakeholders to understand r...

Hi, We need someone to solve this issue: we can not complete the transfer as the wpr4_braapf_term_taxonomy_hierarchical table is too large to be imported on our shared servers. We already have consulted on the case with our system administrators and with our Supervisors for the problem and the only solution is for you or your developer to optimise the database and decrease the table significantly. The SQL query, which imports the table, has 44 350 586 characters: and the import operation times out due to the significant length of the query. We can not increase the limitations on the shared server for the import to be completed as such actions might affect the other clients' websites on the server, which we can not allow. Also, any operation on the database afterwards might timeout...

We have an older website created using .Net 4.5 and MS SQL server that we need ongoing assistance with. Updates and changes will include back end coding, html, css, sql server updates and other web related technologies. Experience with newer versions of .Net is a plus. If you place a bid include the words "i like purple" in the text of your proposal. Otherwise you proposal will be ignored.

We have a short R script that reads and writes to MS SQL Server. We need to trigger it every day in a Windows server. This micro-project is more about server configuration and less about development. If you have experience on how to schedule and run an R script in Windows automatically, we want to talk to you. We are happy to share details once we consider that you have the right experience to accomplish this.

Hello, we want to build our company with a dynamic solution, today it is very static on Wix. We are open to hearing from you, we want it very modern, and dynamic with an open-source CMS solution if possible that is easy to upload jobs, news, new pages, and context. You could help us with our brandings such as new logos, colors and all. Currently, the website looks like this: Before contacting me you should answer these. 1# What CMS you will use? 2# where we will host the site? 3# How long it will take you to develop this?

Description: Please note. The developer I am looking for must know what he is doing. I just had a developer who has spent 2 days on a simple api that should take 4 hours. And... Do not take me for a fool. I check the code. I ask you to make comments in the code when you work and also ask you to push code to git. There will be NO access to the server. If you ask for payment outside I will report you immediately. Please give cost and timeline for EACH task. Phase 1: Bug 193, 161 (only finding path), 230, 229, 231, 245 Phase 2: Bug 190, 188 Phase 3: Bug 189 Work via git only. Not on the sever Priority: 1. BUG 193 change api 118 "Separate the parts in the banners so the app can link to skus properly API 118 reworked response which contains - banner image url - promotional text ...