Sql parent child tables jobs

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...

I'm seeking an Airtable expert to assist me with a number of tasks, including data entry and organization, building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experien...building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experience working with Airtable, including data entry and organization, workflow creation, and complex formula design - A strong understanding of how to make the most of the tool, including its integrations and automations Please note that while my exact requirements in terms of the number of tables and views in my Airtable base, as well as specific integrations I need, have not been stated, I expect the freelancer to be able to adapt to my needs and work in a...

Data Specialist: The Data Specialist is responsible for pr...information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ com...

Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system seamlessly integrates...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...

I am looking for a knowledgeable and experienced researcher who can delve into the relationship between parenting styles and children's behavioral problems. Key aspects of focus should include: - The three parenting styles - internalising and externalising behaviour - Impac...styles - internalising and externalising behaviour - Impact of parental involvement and monitoring - relationship between parenting styles and children's behavioral problems A substantial understanding of the said topic and expertise in conducting similar research will be greatly advantageous. Speed is of the essence, as I require the project completed ASAP. Prior experience in Psychology, Child Development, or a related field is a plus. An excellent command of English and academic writing skil...

I'm looking for a skilled animator who can bring to life a selection of children's picture books. These videos are intended for children...animations that will captivate young audiences. - Understand the intricacies of children's book illustrations and translate them effectively into animation. - Deliver timely and polished videos that are suitable for online distribution. Ideal skills and experience for this job would include: - Proven experience in animation, particularly in a children's entertainment context. - Strong understanding of child psychology and the ability to create content that resonates with young viewers. - Proficiency in adapting existing material into animated form while preserving its essence and appeal. Feel free to send samples of your pr...

I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...

I have an existing Laravel-based ecommerce application that requires a series of modifications and additions. Key Tasks: - **New Tables & Conditions**: I'm looking to add several new tables and conditions to the application. Skills & Experience: - **Laravel Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience with ecommerce applications. The ideal candidate should be highly proficient in Laravel framework and comfortable creating new tables and conditions within the application. - **Database Management**: A solid grasp on database management is crucial to successfully add and integrate these new tables. Experience with MySQL or other relational databases is desirable.

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

...Where Knowledge meets Innovation near Masjid e Maaz, Millat Nagar Noori Our comprehensive online platform facilitates seamless communication among students, teachers, and parents during and after school hours. IIT and Medical Foundation from Primary classes Special remedial classes struggling students Admissions are open for Nursery to Tenth Indo embassy high school for the bright feature of you child Class rush for Admissions Special remedial classes struggling students Indo embassy high school Where Knowledge meets Innovation near Masjid e Maaz, Millat Nagar Noori Students are encouraged to offer Zuhr namaz in school, fostering a sense of gratitude Deeniyath Compulsory for All students Indo embassy high school school building is purposefully designed to cater to educationa...

...comprehensive tool for tracking attendance, storing documents, and managing information from contact details to medical records. Key components should include: **Attendance Tracking** - The system should enable manual entry by teachers. **Student Profiles** - Each student should have an individual profile displaying personal details, contact information and medical details. - Student details and parent details will be collected using Office 365 Forms and the replies should write directly into the student management system. **Document Storage** - A document storage section is required for maintaining relevant records and resources. Including student documents like passports, reports, etc. **Grid View and Dashboards** - Information should be displayed in a grid view with fil...

... The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clear...

I run a non-profit dedicated to promoting literacy skills in young children. Our main focus is to ensure reading before kindergarten. We're in need of a skilled grant proposal writer who has experience in this field to identify and secure grants for our organization. Key responsibilities include: - Understanding our mission and target of achieving literacy skills before k...compelling grant proposal, specifically designed to secure funds for our unique focus on early reading skills. Ideal candidates will have: - Prior experience in writing grants for non-profits, preferably those related to education or early childhood development. - Strong research skills to identify relevant grant opportunities. - A deep understanding of early literacy practices and their importance in child...

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...

I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: -...considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and maintenance for tracking and managing products. The purpose of this project would be Bug fixing and improvement of the software tool already existing. Required: Experience with ER Models architecture Experience with MS SQL server 2017 express as DBMS Experience with Python 3.8.3 and Tkinter GUI toolkit Experience with Powe...

I'm in need of a skilled PHP developer to implement a table filtering and search feature on an HTML table. - The search functionality is to be based on name, facilitating instant search results as the user types. Ideal candidate should have: - Proficiency in PHP and HTML - Experience with implementing search features on HTML tables - Understanding of optimizing search functionalities for large data sets.

... |ckeckbox| MNOs mobile network operators |ckeckbox| RATs radio access technologies |ckeckbox| COs central offices |ckeckbox| Remark the term will be bolded and if appear above/previous line, in other sentence then will be written bold+italic. After selection by checbox then will save into MySQl DB. MySQL db("db_terms" named)will have some tables: URLs - table which keep the unique URLs with these columns: - pk - primary key; autogenerated - url_content ; unique URL for eg. SENTENCEs:

I need an experienced professional to convert a Google document into a Word document with precise formatting. The document contains important tables and graphs that need to be preserved in the conversion. Key Points: - Conversion: The Google document contains essential tables and graphs that must be accurately transferred to the Word document. - Formatting: It's crucial that the Word document mirrors the original Google Doc in terms of fonts, spacing, and overall layout. - Skills: The ideal freelancer for this task should have experience in document formatting, proficient in using Google Docs and MS Word, and capable of handling tables and graphs. If you believe you can handle this job promptly and with precision, please get in touch with me.

I am in need of a Microsoft Access specialist to create a straightforward database. The main aim of this project is the production of a simple database with a focus on data reporting. Key Points: - The database is intended for data reporting purposes. - There will be 1-5 different types of data entries (tables) in this database. - The final database should be equipped for generating various types of reports from the data it contains. - I am looking for a freelancer who can also document the database effectively. Ideal Skills and Experience: - Experience in designing and building Microsoft Access databases, specifically with a focus on reporting. - Strong knowledge of structuring databases for efficient reporting. - Ability to provide clear and concise documentation of the databas...

...and manage fee structures for different classes, including tuition fees, exam fees, and other charges. Allow for online payment processing with various payment gateways. Generate invoices, receipts, and financial reports. Communication Tools: Facilitate communication between teachers, students, and parents through messaging systems and announcements. Provide event calendars for scheduling exams, parent-teacher meetings, and other activities. Library Management: Catalog and manage library resources. Implement a check-in/check-out system. Provide search functionality for students and staff to find resources. Transportation Management: Manage bus routes, schedules, and transportation assignments. Track bus attendance and maintenance schedules. Inventory Management: Track school ...

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

I need an expert to pull data from my MySQL database, specifically from the Customers and Orders tables, and send it to a Slack channel in a unified message. The data includes text, numeric, and date entries. Key Requirements: - Integrate MySQL data with Slack: I need the freelancer to help me integrate the data entries from the specified tables with a Slack channel. - Collide Entries: The entries from the Customers and Orders tables need to be combined into a single, coherent message. - Include Specific Fields: The message should include specific fields from the MySQL tables. These fields include Customer Name, Order ID, Order Date, Customer Phone Number, Customer User ID, Product Details, and Product Quantity. Ideal Skills and Experience: - Proficient in MyS...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

I'm in need of a sophisticated and luxurious logo design that can effectively represent my brand across various platforms. Key Requirements: - The logo should exude an elegant and luxurious aesthetic, appealing to both adult and child audiences. - It needs to be versatile, working well on both digital and print marketing materials, as well as my website. Ideal Skills: - Strong experience in minimalist design. - Background in creating versatile brand identities. - Previous work with logos that appeal to multi-generational audiences.

I'm in need of a data entry professional who can handle a major project involving over 1000 pages of text data. This material is currently in a non-tabular structure, including paragraphs and sentences, rather than tables or spreadsheets. Key Responsibilities: - Accurate and efficient entry of textual data - Structuring unorganized data in a logical format Ideal Skills: - Proven experience in data entry work, preferably involving textual data - Strong understanding and ability to work with structured and unstructured data - Excellent attention to detail and commitment to error-free work - Proficient in MS Word, Excel, and data management software - Ability to interpret complex written instructions Please ensure you have sufficient time available, as this project will invol...

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...

I need a comprehensive and well-written research paper on Groundwater level prediction using various deep learning techniques and their performance evaluation - A case study of c...paper having less than 15% plagiarism & 0% AI generated Title : Groundwater level forecasting in Raipur, Chhattisgarh (India) region using various Deep learning techniques (e.g. LSTM, Bi-LSTM, RNN) and their performance evaluation Abstract : 250-300 words Introduction with in-text citation Methodology with flow diagram and training and validation graphs Result & discussion : along with tables (including various statistical parameters such as RMSE, MAE, MAPE, R-square, cosine similarity, accuracy comparison of different algorithm) & comparative analysis graph Conclusion References ...

I'm looking for a skilled professional who can convert a provided design into a PDF document using HTML format. The attached format should be replicated in the PDF. I will supply all the necessary content and images for the document. Key Requirements: - The PDF should include a header and footer as per the design. - Proper formatting and tables should be implemented. - Images and logos within the document should be accurately included. Skills and Experience: - Proficiency in HTML and experience in creating PDF documents. - Knowledge of would be advantageous. - Ability to replicate a design accurately in a PDF format. - Attention to detail to ensure all elements are correctly positioned. Budget: The fixed budget for this project is 500 INR. Please bid accordingly.

I'm seeking a talented professional to design a comprehensive business case for my technological solution in child protection. This document will primarily be used for presenting our business to potential investors and stakeholders. Most of the content has already been compiled and available to include. Collaborating with me will be required to build out and contextualise content where necessary. Essential skills and experience for the job include: - Business case design experience - In-depth knowledge of business case requirements and necessary inclusions - Shrewd understanding of investor and stakeholder expectations - Previous work on startup projects is a bonus - Communication Your task will involve developing an investment-ready business case that effectively communicate...

I'm in search of a developer to create a web application for a compliance system I have created in google sheets. This project must be completed within the next month. It needs to have tables that can be filled out by certain people and only viewed by others. Different tables need to be able to link together. It needs to send email notifications.

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and ...

I'm looking for a freelancer who can help me shape my large, 535,000-word document into a book format (aprox 500 pages). It is a collection of the 22...page number for each essay. - I did the first 8 manually, and you can take them as an example model. Doing this manually will take me forever and I am sure someone pro like you can do this fast and easily. Ideal freelancer would have: - Prior experience in book formatting - Strong grasp of English language - Knowledge of Word's advanced formatting options It is just simple Text, no images, tables, or charts. (attached you can find the document itself). I seek a simple and neat result from someone with attention to detail and ability to organize a large document. Your bid should include any necessary revisions to ...

Our ex...script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need thi...

...Development: Use HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Version Control: Git for source code management and collaboration. Submission Requirements: Code: Source code with comprehensive comments detailing the functionality of each part of the system. Documentation: A detailed documentation covering the system design, implementation details, and instructions for setti...

...warehousing, ad hoc reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills,...

...Functionality: Dashboard Interface: Display a list of IoT devices. Device Selection: Ability to select a device to load its statistics via API. Graphs and Data Tables: Around 10 different graphs and several data tables with pagination. Time Ranges and Filtering: Options to select time ranges and apply filters from the UI. API Integration: Fetch device statistics from a backend API. Modern UI: Clean, intuitive, and well-designed user interface. Key Features: Device List Display: A dashboard-like interface showing all IoT devices. Dynamic Graphs: Display statistics and data in a graphical format (around 10 different graphs). Data Tables: Tables with pagination to display detailed data. Filtering and Time Ranges: UI elements to filter data by different criteria...

...file. The PDF does not contain any complex formatting, images, or tables, so it should be a straightforward copy typing job. Ideal Skills: - Excellent English language skills - Proficient in typing and data entry - Familiarity with Google Docs or similar word processing software Your work should be meticulous and error-free, with a focus on maintaining the original document's formatting and structure. If you have previous experience with similar projects, that would be a plus. need a freelancer to copy type an English PDF document into a Google Docs document for me. The PDF contains text that needs to be accurately transcribed into a formatted Google Docs file. The PDF does not contain any complex formatting, images, or tables, so it should be a straightforward cop...

...up-to-date with the latest trends and technologies in database management and architecture. Skills and Qualifications  Bachelor's degree in Computer Science, Information Technology, or a related field. Master's degree preferred.  8+ years of total experience.  Minimum of 5 years of experience in database architecture and development, with a focus on Netezza and Oracle.  Proficiency in SQL and PL/SQL programming languages.  Strong understanding of database design principles and data modeling techniques.  Experience with database performance tuning and optimization.  Excellent communication and leadership skills.  Ability to work effectively in a fast-paced environment and manage multiple priorities.  Relevant certifications in Netezza and Oracle te...

I have to transfer data and tables from oracle to postgres.

I'm in need of a desktop software that can analyze a specific type of data within a PDF table. The software should: - Read and extract data from a PDF table - Compare this data against another table - Identify and save matching data in the form of an Excel file. The tables in question will contain numerical data only. Ideal Skills and Experience: - Proficiency in developing software for Windows - Experience with data extraction from PDFs - Strong capabilities in data comparison and analysis - Knowledge in Excel formatting - Understanding of numerical data handling.

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

Need to 2 single and separate webpages to display data from tables in MSSQL database

I'm in need of a talented UI/UX designer who can create a layout similar to the CDC Milestone app for both iOS and Android platforms. Key Requirements: - Proven experience in designing engaging and interactive user experiences - Strong understanding of Apple's and Google's design principles and ...high-level requirements into beautiful, intuitive, and functional designs - Excellent communication and collaboration skills to work with the development team - Experience in designing educational apps is a plus, but not required Please note that the focus here is on creating a similar layout to the CDC Milestone app. This project does not involve the creation of any content or features specific to child development. The goal is to replicate the app's layout and stru...

As you know, Magento displays the lowest priced simple product associated with configurable products. we want the price of a specific child product to be shown. There are modules designed for this, known as configurable preselect, but I couldn't get it to work. Although there are settings in the module for category or listing display, the preselect feature that works on the product detail page does not work on the category page. Can you solve this problem?

I would like to update this theme in Hugo to make a website look like the one below. The homepage would list all folders in the parent directory under content and then click into the subdirectories showing the md files of each respective category. It’s a very well done website and I’m having a hard time making the theme work exactly as they have it. I believe the theme is out-dated and needs to be update. Here is the theme I want to implement: Website I want to mimic:

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription