Closed

SQL Queries in Python

My website is a big data analytics tool, scanning over 100 Million lines of data for every query.

Now I want you to refine my search by adding further SQL commands.

The search is written in Python and based on Elastic Search.

The website is built on Symfony.

THE JOB IN DETAIL:

1. add premade navigation bar and link content

at page bottom, fixed, z-index above all website content link content of search bar

2. add pagination

10 search results per page. Enough pages to show all results. “<” and “>” jump two pages.

3. revise search process

Country Selection

If a country is selected, only show search results of shipments which list that country in

the column “Country”. If USA is selected, show all search results.

words from multiple columns

When searching for multiple words, like for example: “the north face” + “tent”, show all search results that have all words in the columns “Consignee Name”, “Shipper Name” and “Product Desc”. Allow the words to be found in different columns. In the example above “the north face” could be found in “Consignee Name”, and “tent” in “Product Desc”.

4. revise website

delete previous search field. Scale down the height of the top navigation’s background to just underlay the links.

Taidot: Elasticsearch, Python, SQL, Symfony PHP

Näytä lisää: Optimize 2 SQL queries to avoid nested select statements, http slanso com index php controller authentication&back my account&idlang 2, delimiter sql queries python, python database, python sql select, python sql server query, python database tutorial, python sql library, python sql pandas, python 3 sql, python sql connection, sample sql queries cricket tournament, sql queries oracle date last friday, sql queries linux, wordpress sql queries category, sql queries airline reservation system, fetch sql queries thru loadrunner script, sql queries check total bulk sms day, money optimizing sql queries, wordpress custom sql queries

Tietoa työnantajasta:
( 31 arvostelua ) faridabad, India

Projektin tunnus: #17343408

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

DarkKnight2206

Hello! I am a python developer. I looked at your project and it seems interesting. I have all necessary skills required for this project. Ping me to discuss in detail.

$50 AUD 2 päivässä
(15 arvostelua)
4.3
$200 AUD 10 päivässä
(0 arvostelua)
0.0
$61 AUD 10 päivässä
(0 arvostelua)
0.0
sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . Relevant Skills and Experience 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle ( Lisää

$61 AUD 10 päivässä
(0 arvostelua)
0.0