Database queries jobs

We need someone that can analyse a database, write SQL queries to get data, define rules and KPIs, etc... Skills needed : SQL & DB management, Python, Data analysis...

I need a PostreSQL 9.6 syntax expert that can produce simple to medium complexity queries. I'll provide DB access and specifications to what fields of which tables are needed to be queried

...make the database on my own. So, if someone could assist me with making my access tables, that would be very welcome. I am looking to copy the logbook into an access form and so to complete the database. Once this is set I will start thinking of making queries on the database. Those queries can be anything as long a s the main database is stable

...injection:- We use parameterized sql queries to avoid this issue. Cross side scripting:- WE use a token to is part of a hidden form and send to the client whenever a post is done the tokens are compared to see if they are valid. Traffic between the components:- Traffic between the client - webserver - database are all encrypted (SSL). Survey API:-

...We specialize in Telemarketing lead management Lead Generation / Qualification of telemarketing lead lists Decision Maker Contacts Appointment Scheduling Product Promotion Database cleansing and updating Third party verification Record verification Fraud detection /prevention Calls Welcome / thank-you calls Continuity sales calls [login to view URL] highlights

Design a database with Oracle. Provide a database schema and SQL script files that will create and populate the tables. Write 10 DQL queries related to that schema that will return result sets.

...based) that should consume Web service and post the result in SQL Server 2014 or above database. Conditions: 1. The Source code has to provided with the project. 2. The Web service and front end will be septate projects/solution. 3. Web services will use the SQL Queries to make JSON without the help of JSON FOR PATH or smiler. 4. Work will be done on

...DateRangePicker ([login to view URL]) for a current app project. I am stuck at the DataTables serverside processing script and I need help to finish it and also add some extra queries to it. The idea is to be able to display statistics per day based on the criteria set by daterangepicker, else display only today stats. Daterangepicker sends date ranges to

...web-form will contain several fields, from 30 to 50 fields. Several fields from the form will use multiple REST queries to web-services like [login to view URL] (requires sign-up and setting the account from scratch). The REST queries should go deep into service to fetch the historical data. Having experience building stock market/trading/brokerage

...DateRangePicker ([login to view URL]) for a current app project. I am stuck at the DataTables serverside processing script and I need help to finish it and also add some extra queries to it. The idea is to be able to display statistics per day based on the criteria set by daterangepicker, else display only today stats. Daterangepicker sends date ranges to

I need someone to make a SQL database together with the necessary tables, queries, forms and reports and ALL PHP OR coldfusion OR other files necessary to run the project on the web by several users. It can be hosted on Amazon Web or Google or other hosting facility The project is to accomplish all as shown on the CARDCHECK PDF sheets attached. FIXED

...the 8-10 tables. Need someone to do the following: -Storage file layout: Create the 8 -10 table designs in PostgreSQL format -Write query codes for insert into PostgreSQL database from MongoDB -Write query codes for insert into PostgreSQL tables from other PostgreSQL tables -There are 7-9 query codes for insert No need to setup anything on the server

...server and shall be accessible by different browsers. A)Forms Authentication to be used. Final Source code to be kept on our server for changes/modifications in future. DataBase design & structure will be maintained by us only. We can change modify DB Tables as per application development requirement on your request. B)Role based users like : Admin(admin)s

...communication skills. The candidate will be responsible for - - Sending Mailers - Responding to queries - Getting nominations for the program - Getting business for inhouse & open house programs - Faculty Empanelment for Behavioral and soft skill programs - Creating database of HR & Training Heads [Removed by Freelancer.com Admin - please see Section 13 of our

I have a data base manged by a system, I want to create some queries to get information from differents tables, in the same queries do some operations and IFs conditions, then download the data in excel, and create a dashboard to manage a special replenishment of requirements as a Distribution Center.

I I have a big procedure in vb 6 which merely deals with queries and loops i feel i can convert the whole code in to Sql Stored procedure as it merely updates database with some calculated values as there are a lot of loops in the procedure i find it difficult for myself to convert as it may requires a lot of cursors may be

I I have a big procedure in vb 6 which merely deals with queries and loops i feel i can convert the whole code in to Sql Stored procedure as it merely updates database with some calculated values as there are a lot of loops in the procedure i find it difficult for myself to convert as it may requires a lot of cursors may be

...communicate using REST and are connected via WIFI connections to the internet. Our database must be able to be used to: - Manage the units, add new units, change configuration settings etc - Store the records from the Units in tables so that the - Run automated queries and send messages to customers when readings are recorded outside paramaters - Provide

...communicate using REST and are connected via WIFI connections to the internet. Our database must be able to be used to: - Manage the units, add new units, change configuration settings etc - Store the records from the Units in tables so that the - Run automated queries and send messages to customers when readings are recorded outside paramaters - Provide

Looking for someone to help me with R-Programming! Please make sure you know what I am talking about before bidding.

We are looking for an SQL Expert to both analyse and optimise our database and code to fix a recurring deadlock and any slow queries. Here is a sample of the deadlock error. Order saving error: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE `catalog_product_entity`

...the platforms used are Microsoft SQL Server database, HTML 5, JavaScript, PHP, leaflet and D3. We have the general website structure and Database and need an applications development programmer to; • Build a login form linked to the database • build web forms using bootstrap for 3 views/tables in the database, • the forms need to act in both a data se...

I am looking for someone to build a database on MS Access that would be utilized as a Daily Log. I am including what I would like it to look like from my previous employment at John Wayne Airport where it was utilized. We would need to be able to generate various Queries and Daily Reports. Please see enclosed. Feel free to contact me for more information

Looking for a dba to optimize our database and find which queries are causing a high load on our server.

...number of other features in it. In the app, we’re overlaying our coordinates (waypoints) data over a Google map, and then processing the data based on hundreds of queries from a database and then processed over various parameters type of icon, hover effects, information overlays, clicks, etc. The app will be developed using objective C for IOS, Java

We are looking for someone that can produce a custom report using Crystal Reports which queries our SQL database (NetInsight ScheduALL).

...that runs using SQL Server, each bussiness location have their own data base. I need to develop some sql queries to download some information from each database to Excel, where I want to compile the information from differents Databases. the Queries will have to comply some "if" criteria subrutines. The in excel I will use the information to sum the

...protocol azure event hub Set 2) Database database design database models database management relational database what is nosql database system relational database management system database server types of database management system application of dbms database examples types of database what is database...