SQL Jobs

SQLserver is used. Want to extract elements in array of a json column in SQL

i have 7 weeks of work and need help regarding bda and sql

- Strong Banking Domain (Commercial Lending & Mortgage) knowledge required (Black knight/Empower ) - Requirements gathering, documenting BRD & FRD, business process flow, workflow /swim lane diagrams using Visio - Knowledge of Jira, Confluence - Liaison with multiple stakeholders (business & technology & PMO office - Strong Datawarehouse knowledge (OLAP, OLTP, Star/ snowflake schema, 3NF Denormalization, Dimensional modeling) - Identify data elements for Loan Origination source systems to loan servicing & underwriting systems - Ability to create custom & canned reports - Data Analysis using SQL queries (strong) - Data mapping skills (source to target) - Data quality & metadata management - Data Governance & Data Management skills Environment: - Teradata

Looking for someone to create a database to Record and Manage the Daily booked Man Hours. The required database must have the following as a minimum - A form for employee registration - A form for project registration - A form for daily man-hours and Work progress registration - A report showing the employee list, used man-hours, and progress contributed - A report showing the project list, used man-hours and progress achieved - A time report of each the employee for every month - A dynamic report showing used man-hours and progress for each of the employee Further to that (if possible) - Looking for a secured way to register man-hours by each of the employees without accessing the whole database - Reports could be scheduled to be emailed automatically at the given addresses.

I am looking for an Power Platform with competency on below tools: - Power Apps - Power Automate - Share Point - Data Verse - SQL Kindly bid!!

need a basic simple pos software for restaurant

We need one oracle view with join based on three tables and few filter condition

A curious Power BI developer with sound knowledge Power BI Reporting and development. Confident in querying in SQL and DAX languages. Seeking a career opportunity to bring detail and precision into data analysis

Hi, i'm looking create an online Event Venue Searcher and Booking. Even types include but not limited to: Corporate gatherings, Parties, Weddings, Photography/Video production project Venue types can be: Restaurants, Bars, Production Studio, Commercial Space The site should have a basic functionality good enough for a demo and/POC. Basic features would include: - Browse venues by location, event type date -map point search - venue reservation, request to reserve and request acceptance by host - payment simulation -email/sms notification to user - calendar blocked as venue availability - offline chat guest and host we expect full implementation however we will be doing the architecture, we will provide the datamodel as well, the layers of the site will be: UI: React Web API: Pyt...

hi i want our printing application development which will have 5 data entry pages , with masters entry page , reports

Merhaba ek de belirtmiş olduğum görsellerin aynısı olacak şekilde bir resimli masaüstü uygulaması bilgi yarışması yapılması ihtiyacım ve Kullanıcı paneli olarak 2 giriş ekranına tc ve admin tarafından ooluşturulacak şifre ilegiriş yapı form projesi olarak yapılması gereken uygulamada her soru 25 saniye süreli ve toplam da 50 adet görüntü sorusundan oluşmalı.50 sorunun ilk 25 i 3 secenekli (a,b,c) geri kalanı 25 soru ise 6 seçenekten (a,b,c,d,e,f) oluşacak sekilde ayarlanmalı.Kullanıcı sınav bitiminde sonuclarını göre bilmeli ve sonuçlar veri tabanında kayıt altına alı Birde veri tabanında soruları random usülü almalı.Veri tabanında sorular kolay,orta,zor, tablolarına kayıt cevap seceneklerı işaretlendikten snra gör&uu...

Want to find someone who has a great deal of experience with Fox Pro

I need make a simple subquery for mysql

reservation module plane parts for a school

HARDWARES: 16X2 LCD, 6 DIGIT SEVEN SEGMENT LED DISPLAY, USB KEY BOAD, USB PRINTER(LASER+DOT MATRIX), PEN DRIVE, RS232 PORT, 1/2 GB DATA MEMORY, ANALOG & DIGITAL LOAD CELL INPUT, POWER SUPPLY ETC. SOFTWARE: AS PER MANUAL + SOME EXTRA FUNCTIONS, KEY BOAD DATA ENTRY, REFERENCE CODES, TICKET & REPORTS, DUMP DATA TO PEN DRIVE, SMS+E-MAIL THROUGH EXTERNAL GSM MODEM, SQL SERVER CONNECTIVITY(MULTIPLE CLIENTS), DIGITAL LOAD CELL FUNCTIONS, WEIGHING MACHINE SETUP+FUNCTIONS, LOAD+PRINT DEFAULT SETUPS ETC.

Looking for someone on some on demand work for long term. I need someone with good python knowledge. Our jobs run from ozzie scheduler from cloudera cluster and connects to SQL server databases. So i need help with troubleshooting job failures or enhancements on python code.

I need one SQL DBA for one month period to, 1. Manage SQL Server databases across all environment 2. Configure and maintain database servers and processes 3. Monitor system's health and performance 4. Ensure high levels of performance, availability, sustainability and security 5. Assist developers with query tuning and schema refinement 6. Provide 24x7 support for critical production systems It is a one month period on site project and location is in Dubai.

Requirement - Zoom Developer (DB Specialty) training wish list PAX – 15 – 20 ( Both Freshers & Laterals) Technologies to be covered 1. SQL Server Integration Services (SSIS) 2. SQL Server Analysis Services (SSAS) 3. DAX 4. Advanced TSQL – Emphasis on Stored Procedure development Expectaions: Should have some familiarity with coding in general of course. Frontend UI Developers should have the following general skillset: Net Core, ASP.NET, Web API, Microservices, C#, TSQL, AngularJS, Java Script, Linux, Azure Power Apps, Bots, RPA, Python.

There is an issue with the database of my ASP.net website, it suddenly went down, I need it up. Fix the issue.

We already have a asp.net 4.0 project running successfully, with MS SQL , Now we need a Web API project for integration with other applications. Note: Security of the Web APIs should be the top most priority. No bugs at all. Deploy the Project on our developer's Machine. A good technical support require to understand the project and make changes at our end

Looking for professional Freelancer that will create and CorrectGIF fik=le with some action. And implement this file to web page. PLEASE NOTE THAT THIS PROJECT IS MAXIMUM $30 Canadian Dollars.

i want to create binary tree in asp.net and ms sql i'm using currently

Need help for SQL Installation on MAC

Experiencia en POO avanzada Dominio de .Net 6 o .Net Core, Visual Studio, VS Code, Postman Dominio de Azure DevOps Dominio en MS SQL Server 2008/2016, bases de datos Oracle/MySQL Experiencia en el uso de JQuery, CSS, MVC, JSON y Java Script Experiencia en todos los aspectos del ciclo de vida del desarrollo de software Conocimientos en comprensión y modelado de diagramas de flujo y diagramas UML Manejo de herramientas de versionamiento de código Conocimiento en Patrones de diseño Conocimiento en automatización de pruebas unitarias y documentación de código Conocimientos en la creación y consumo de API's Conocimiento de los procesos involucrados durante el ciclo de vida de desarrollo de software Deseable contar con conocimientos en ...

The backend is implemented with Odoo API and must stay that way. Brief list of tasks - Must optimize database and website operations - PDF documents take too long to download. Possibly rewrite this part from scratch - Adjustments to generated PDF contents - Fix UI formatting on iPad, iPhone and other mobile devices - Arrange the layout of the deals and offers segment on the website - Modify orders’ dashboard on Odoo backend to include additional columns Languages used in original code: Python, JavaScript, CSS, XML, HTML, SQL Existing code will be provided upon awarding. No hourly work, it is a pay-per-milestone agreement ONLY. Please review the document as we will strictly abide by its contents. To be considered for interview, state the payment policy we outlined in ...

I Installed fresh Huawei U2000 to a new VM, need help to import Data Base from previous system to the new VM. Might need to connect to old system, backup then import to the new VM.

Develop A Desktop App with Database, Scraping, Automation & Online Forms Filler Back end and front end needed - very simple UI.

1. Gather Biz & Data Requirements for Mortgage bank biz 2. Data Acquisition & transformation 3. Data mapping 4. Analyze different data sets by running complex SQL queries 5. Teradata database knowledge required 6. Jira reporting & project management 7. Strong datawarehousing knowledge, star, snowflake schema 8. Knowledge of OLAP, OLTP & Data Quality , Data Governance 9. Knowledge of Mortgage biz process flow (Loan origination, servicing & underwriting) & various data elements/schemas

I need to schedule a backup for SQL SERVER database and send files by email. Schedule next friday 7 P.M. (GMT -3) and delivery until next 24 hours (saturday 7 P.M.)

I have some projects and require some developer who can work 8-10 hours on weekly basis for fixes for the same. Need to work on remote system for the same. This is long term opportunity. My hourly rate is Rs 125-150 per hour Please let me know your experience with different framework and timeline in which you are available to work for the same.

We have one base table and just need to filter some records based on few conditions to join another table.

We are looking for developer who know these all skills : Azure SQL Server DBA Experiences need 7-15 Years

We are a Data Insights business looking to automate some of our report generation. We are looking for a Python developer to help us consolidate all Python code written from different data journalists into a single format, merge our different styles into one, and implement a more efficient system for writing new reports. Finally we want the developer to introduce a style guide to the way we write Python code so that we can all use the same conventions and achieve more uniform and easy to understand code across our members. * Consolidate python code from various writers * Convert inline code to object oriented and map out all classes * Schedule scripts using VMs * Implement a Python style guide and clearly convey to data journalists

Se requiere realizar una reporte en PHP que permita crear usuarios con contraseña tomando información de una base de datos de SQL

i need some who is very good in MySQL to help me out with some queries

We are currently looking for someone that can help us design actionable reporting and dashboards for our subscription-based e-commerce company. Responsibilities will include: Mining data from primary and secondary sources (SQL database, Google Analytics, Social Media Platforms, Email Marketing, etc.), then reorganizing said data in a format that can be easily read by either human or machine. Connecting our SQL data source to reporting applications such as Power BI to create visual reports that can show us KPIs and Business Drivers, Customer Analytics, and more that effectively communicate trends, patterns, and predictions using relevant data. Collaborating with programmers and organizational leaders to identify opportunities for process improvements, recommend system modifications, and ...

احتاج الى مصمم مواقع ليكون الموقع يقراءة من الة البيع ويخرج QR CODE وبرنامج يكون قادر على قراءة ال QR CODE ويكون قادر على شحن من خلاله للدفع وتحويل النقود لشخص اخر

احتاج الى مصمم مواقع ليكون الموقع يقراءة من الة البيع ويخرج QR CODE وبرنامج يكون قادر على قراءة ال QR CODE ويكون قادر على شحن من خلاله للدفع وتحويل النقود لشخص اخر

We are seeking a Data professional who can support establishing/monitoring ETL/ELT processes within Azure Data Factory to support the buildout of an analytics data warehouse for an Ecommerce company. Ideal Freelancer will have: 1. Azure experience, specifically ADF. 2. E-commerce experience, and familiarity with Google Analytics/Ads, Facebook Ads, etc. 3. Strong SQL experience 4. Experience using API / ODBC connections.

Bonjour J'ai besoin de quelqu'un qui parle le français et qui a une bonne maîtrise en SQL pour un travail facile. Je vous prie de répondre aux questions suivantes pour que votre candidature soit considérée Quel est votre niveau de connaissance en SQL de 1 à 10? Dans quel cadre vous avez utilisé SQL? Quelle est votre activité professionnelle en dehors du freelancing? Quel est votre dernier diplôme? Je vous remercie

I have an embedded device that can communicate from TCP/IP with a special protocol. I need an app that will : 1. send a query and responses to/from our embedded device or devices in specific time periods. 2. log these answers on a local database(SQLite) 3. Can send this data to a remote database (MS SQL/PostgresSQL) 4. Show the actual status of data (level temperature etc...) on a dashboard 5. Show logs with filter search options based on date periods or id of devices. 6. Searched logs can be saved as pdf output 7. entering the application will require a password and username. This user will be checked from a local or remote database

A web application to learn SQL. In this project, you need to build a SQL editor from scratch which will be used by users to practice and learn SQL. for reference

Transaction, notation structure of sql and writing sqls

Need a freelancer for developing a PLC and SCADA program Program will consist of Application Logic Data Logging Recipe creation upload and download Preferable candidates from mumbai only

Need to create a simple full-stack application (round about 4-5 dynamic webpages) that gets the data from excel files or json and imports to the db. The tool should be implemented in Kotlin using KTor and Typescript. Detailed information will be sent upon discussion with freelancer.

hi i need true caller alike android app, the lowest bidder will get this contact, new freelancers are welcome if cheapest. your bid amount will be considered final proposal

We are looking for Minimum 4-5 Years Experience Full stack Developers. JD:- who have the below mention all skills Skills ASP .Net, MVC ,Web API ,SQL Server

Location: Remote Time: 10:30am – 7:30pm Contract: 6months SSIS Developer Skills / Experience: Required skills: • Must have 6+ yrs of experience in Business Intelligence development/integration or with SQL server development. • Min 2yrs hands-on experience in developing SSIS packages. • Capable and willingness to work single handedly on implementing SSIS solutions. • Must have exposure to at least 1 end-end solution design using SSIS. • Should have experience working with PL/SQL procedures and commands. • Should have a strong experience in SQL Server. • Should have excellent understanding of MS SQL Server & Data Warehousing architecture. • Should have good understanding of business processes and functional programming. • Good communic...

I am new to oracle and I need help to create cron tab jobs that will query the oracle database and upload the result to the SFTP site every month.

السلام عليكم ، العرب فقط مطلوب مشروع تخرج موقع لمنظومة حجز طيران