SQL Jobs

Looking for Full Time Power BI Expert

Looking for a SQL Server Query Guru to help me write a very complex query

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

Microsoft SQL Command to search in Freetext 3 or more words with distance 2 or 3 between them. Example: To find documents that contains WORD1, WORD2, WORD3 (and WORD4 if possible) with distance 1 or 2 between them

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 :)

ODBC table convert it to csv using php with header and downloadable via web.

Just need to create and link database to everypage

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.

Solucionar el error: "ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘‘ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by" Causa: Hasta la versión 5.6 de MySQL 5.6 el modo de SQL era NO_ENGINE_SUBSTITUTION. En la versión 8 de MySQL los modos de SQL por defecto son ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION Por motivos de seguridad, compatibilidad y mantenimiento en hosting compartidos no se modifica el modo de SQL por defecto en el servidor, y hay que modificarlo en el inicio de sesión dentro de la programación. O bien mod...

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

I need several hours of Tableau lessons to remember how it is used and how to use Tableau in ordinary job as a Data Analyst. We need to go from scratch to an intermediate level.

All products located at the address must have the information on the product detail page.

i have to add simple features in my already builded website which is in php

Long Term need for experienced SQL developer to assist development team with BI product development. Best Candidate will have a minimum of five years of experience and the following skills: • Experience working with large scale relational database & Data Modelling experiences. • Should have experience in data analysis & improvise Microsoft SQL queries/views/complex stored procedures. • Experience in migrating data from other data sources to SQL Server database • Performance optimization. • Should have knowledge in ETL Process (SSIS) to perform load & extract operations. • Ensuring improvisations in quality of data & no data slippage. • Embraces teamwork & possesses ability to effectively work cross functionally • Work with the Da...

Needed a person who can take interview on sql DBA

We need a skilled SQL server database programmer who has worked in developing on complex views and stored procedures. Please only apply if you have worked on Time and Attendance software like Sage or similar before.

We have a role for a leading global company based in Texas. We are looking for a HVR Developer based in Texas to work a hybrid role. You must be able to commute to Houston at least 2 days per week. Previous experience is required, a strong SQL understanding and Matillion experience in preferred.

We are an online software company supporting the gaming industry. Most notably virtual and real-life sports leagues. We have an Asana that breaks down our requirements and project needs. It is being built in Umbraco CMS and Umbraco knowledge is a MUST! You MUST also be a full-stack developer otherwise your application will be denied. We use several technology stacks. We also wrote a custom discord bot service that allows League commissioners to send messages to whatever discord server the bot resides within. The bot will need to be extended to include new features. You will not be given access to the site prior to accepting the position so please don't bother asking.

We have a already built the dataset with all the relationships. We need to convert the sql query to dax formula for an AR ageing report which the user can choose at a specific time

I have database, Need to get data from database and show the data in table and apply few mathematics on that data. I have four tables to show the data with calculation

Python Code will run parametrise SQL query to create customize views, which can be exported to CSV and excel file

Need to create SQL plsql queries and needed support in forms reports etc in oracle development. It is regular monthly support not hourly.

I require a database to collect cost and other information about construction projects, I then need to be able to take averages from the cost data based on the other information recorded.

We have a 3 linked databases running on Access 2010 one need a few report errors fixing and then converting to run on Access 365

i want to have a sql query in php prepare statement that the user id start with "300" can only log in with corresponding password.

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) changes will be made on an env...

connect sql server with woocommerce wordpress and after that synchronize items, price and purchase order

ciao mi servirebbe completare una query sql di prestashop una select sulla tabella image-lang e ricavare anche nome prodotto, descrizione e nome attributo combinazione

need websites as well as Andriod IOS app for online Pharmacy demo link

To extract specific fields from multiple .sql file in to one single excel file

A booking system has been designed from the following framework - Database is on Azure SQL, All SQL Stored PRocedures will be provided. Currently need the following pages to be developed and linked to SQL - Login - Dashboard - Create Booking - Bookings - Booking Detail - Invoice - Calendar

We are migrating from MSSQL to MySQL and need help connecting to the servers

this is initial project. If you can get this going we are pitching for about 200 hrs of work for a larger SSIS package

보다 자세한 내용을 확인하시려면, 회원 가입 또는 로그인 절차가 필요합니다.

Hi there, I'm looking for an expert datascientist / product analyst with some experience interviewing candidates, and vast experience with: 1. SQL queries 2. Mongo queries 3. Product analytics - user churn calculation, moving averages, cohort analysis - if you have not done any of these, this job is not for you :) In your bid please elaborate on: 1. Your experience with hands-on datascience. 2. If you read this start your answer 23 with this number. 3. Your experience as an interviewer. I'll hire after a quick 20 min call - no games. thanks

Suche einen Ghostwriter für eine Online Klausur am 27.01.2023 gegen 16:20 Uhr Thema: Grundlagen Datenbanken, SQL Datenbanktheorie: -Transaktionen -Index -Normalisierung SQL (Structured Query Language): -Datenselektion -Datenmanipulation -Datendefinition -Trigger

i have a school management erp developed in delphi xe8. i use sql server database. I want a web based vesion of the system to allow students to check balances, examinations results, register for new semesters e.t.c.

i have a school management software now in use my many school. a few of them have bought xkteco biometric attendance system. I would like to integrate with my system so that only students who have cleared their fees are allowed in.