Sql Database administrationKazi

Site-uri web,IT si Softaware limbaje PHP, WEBSITE DESIGN, Graphic Design, HTML, C++, SQL

Web design, poznavanje softwara , Data base arhitecture za travel site

Zdravei Radoslav, Tursq si web developer na Python sus slednite sposobnosti: *Legacy Django (<1.2) project needing brushing up to 1.4/1.5. Deep knowledge of Django/Python best practices. Skills: - Python (4 years) - Django (2 years) - SQL & Django-South (2 years) Dobro zaplashtane. Svurji se ako si zainteresovan. Inna Amesheva

...<image1><image1> <image2><image1> <image3><image1> <image4><image1> <image5><image1> <image6><image1> </category> <category> <name>category 2</name> <image1><image1> <image2><image1> <image3><image1> <image4><image1> <image5><image1> <image6><image1> </category>‏ i will provide 2 tables sql file...

I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!

I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work wit...

I am searching for an experienced app developer who excels in designing and implementing Android-based applications. The main functionality required for this task is the creation of a comprehensive employee database system. Key Functionalities: • Instant tracking of employees' online and offline status • Storing and displaying contact details of each employee • Categorizing employees based on their department The developer should have a strong understanding of database structuring and management for Android systems and a proven track record of delivering similar projects. Familiarity with real-time data sync and user-friendly UI design are also desirable.

I need assistance in compiling a large, extensive database of more than 5,000 working professionals earning a salary under 3 lakhs per annum. The data profile will include: - Name and contact details - Education and qualifications - Current job title and company Interestingly, these professionals should spread across various industry sectors such as Technology and IT, Healthcare and Medicine, as well as Marketing and Advertising. Particular skills and experience that would set freelancers apart for this job include: - Proven experience in data mining and data scraping - Familiarity with the mentioned industry sectors - Ability to accurately cross-reference and verify data - Excellent attention to detail Freelancers with extensive experience in maintaining data integrity and c...

I'm in need of someone with the expertise, resourcefulness and knowledge to draw up an email lead list from public domain databases. The focus of this project is identifying professionals, specifically those with active websites for contact. Key requirements: - Extraction of email leads from public domain databases - Target demographic: Professionals of various walks with active websites - Experience with large-scale data extraction - Proficiency in managing information databases Your past work in email lead generation will be beneficial for the successful completion of this project. Your ability to provide clean, organized, and verified email lists will also be very important. Please only bid if you have the experience and know-how to deliver on the stipulated requirements.

I am in need of a competent data engineer for a small-scale data analysis task. - The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience wi...The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience with data engineering will be a significant advantage. Your role will mainly involve performing data analysis tasks, so a deep understanding of data engineering and analysis is essential for this project. A strong background in Python, R, or SQL is highly preferred, though not mandatory. Please note that the project timeline is quite flexible, so you will have ample time to complete ...

I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project requires strong c...

The objective of this assignment is to develop a comprehensive database system. The Database should support, among others, member registration, subscription tracking, member services management, and trade references. The system should facilitate data import from Excel and accommodate online and offline accessibility based on the user’s capacity to meet online hosting costs. Member Registration: Develop a module for member registration capturing key details such as Name, address, and any other contact information. Village, group, area, district, province, sub-group affiliation (e.g., Study circle, VSLA, commodity association etc.) Demographic information (age, gender, household size, etc.) Implement functionality to adapt and import member data from Excel sheets. Enab...

I need an experienced Laravel developer to integrate and manage the database for my existing project, www.getyourhomes.in. The task is not only basic CRUD operations but also extends to admin panel updates and AJAX call filters. - Database Management: You should be adept at advanced database management with stored procedures, triggers, and optimization. - Language Proficiency: Strong language skills in either Bengali or Hindi is essential. Your role would be crucial in improving the functionalities of my project. Prior experience in similar projects would be a bonus.

Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience i...

...Responsible for handling and resolving tickets. - User: Able to submit tickets and monitor their progress. Ideal skills and experience for the job would be expertise in web development, specifically in creating ticketing systems. Familiarity with user management, role assignment, and priority matrix are essential. Fluent in programming languages like PHP, JavaScript, and proficiency in SQL for a robust database system is a must. Creativity in UX/UI design for an engaging and user-friendly interface should be apparent. It is also required to handle incoming and outgoing E-Mails. I don't want to have further frameworks involved. Core PHP is required and JS like Bootstrap 5, JQuery are ok.I have my own authentication system in place. Based on the role different in...

I am in need of a skilled PHP programmer to address an "undefined variable" error within my user authentication system. The system primarily relies on email and password authentication. Key Requirements: - The error lies within the user authentication system - The primary method of user authentication in the system is email and password Ideal Skills and Experience: - Proficiency in PHP, SQL - Experience with user authentication systems - Familiarity with handling undefined variable errors - Understanding of secure email and password authentication Your task is to identify the root cause of this error and implement a solution to rectify it. Please provide specific examples of similar work you have done in the past.

I need to gather emails from: https://alaskabar(.org)/for-lawyers/member-directories/ Need it in CSV

...Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean, maintainable, and well-documented code. Troubleshoot and optimize existing integration solutions. Desired Skills and Qualifications: Strong NodeJs skills Ability to read Python & Go code Abiltiy to write DBT transformations Strong experience with CloudQuery and its features. Proficient in SQL and database management systems. Solid understanding of API integrations and web services (REST, GraphQL, etc.). Experience...

I'm looking for a skilled .NET developer with experience in JSON, MS SQL, AJAX, and HTML to help me migrate my existing website to a new template. The specific features that need to be migrated are the design layout and content pages. To give some context, the primary objective of this migration project is to enhance the functionality of the website. An ideal candidate should be well-versed in enhancing user experience and updating design aesthetics. Your role will be pivotal in ensuring that the new template not only preserves the existing features but also improves the functionality. The key difference I'm aiming for in the new site is faster loading times. This means that you should be able to optimize the site's performance and ensure that the migration process ...

I need a proficient Linux systems administrator to help install and configure LibreNMS on my Linux system primarily for Network Monitoring. Key Requirements: - Install LibreNMS on a Linux platform - Configure LibreNMS for optimal Network Monitoring - Set up monitoring of Virtual Machines Important Skills: - Expertise in Linux system administration - Familiarity with LibreNMS and its Network Monitoring functionality - Experience with monitoring Virtual Machines.

I'm in need of an ASP.NET developer with a strong background in database integration. The primary purpose of the website will be system development, focusing on certain essential features. Key Responsibilities: - Develop the website using ASP.NET - Integrate databases seamlessly System Development Features: - Implement user authentication and authorization - Ensure efficient data management and storage - Set up robust reporting and analytics functionalities Ideal candidates should have experience in ASP.NET development, particularly in integrating databases and building system development projects. Previous work on user authentication, data management, and reporting within ASP.NET is highly desirable. Please provide examples of your work or specific experience in these area...

I'm seeking a skilled server administrator to help w...Backups: Regular monitoring of the server's performance and creating a backup plan. - Software Installations and Updates: Installing necessary software and ensuring that everything is up-to-date. - Migrations - Accounts setup and transfer - Reports: Providing regular reports on the server's health and performance. The ideal candidate should have: - Proficient experience with Linux server administration. - Strong background in server security. - Expertise in monitoring and creating backup plans. - Adept in software installations and updates. - Ability to generate and interpret reports. Your expertise in these areas will be crucial in ensuring the uninterrupted operation and security of my server. Looking forwar...

Project Students are expected to design and...should include: • Web pages, videos, images, banners, menus • Forms • Server-side scripts • Database The following are some sample projects which you may work on one of them: a) Online magazine in health/sport etc. ... b) Online library system c) Online clinical appointment system d) Online houses/apartment rental system e) Online car rental system The final submission should include: 1) Report describing the project that includes: a. Introduction b. Web site design c. Web site development: the main files created: articles, categories, modules, and database. d. Screenshots of the website e. Conclusion f. References 2) One folder that holds all the subfolders of categories, articles, menus, modules, SQL 1...

I work in the Information Technology sector, seeking a professional who can reflect my skills in Software Development and Network Administration fitting for a Senior Level position. Ideal candidate: - Familiar with modern IT practices - Knowledge in Software Development and Network Administration - Experience in crafting resumes for senior roles - Understands how to make a resume stand out Your role: - Review my current resume - Highlight my skills in Software Development and Network Administration - Ensure my resume fits the requirements for a senior level position - Make recommendations for improvements where necessary

I am in immediate need of a Python expert who can extract data from external website and store in an MS SQL database. freelancer with extensive experience in data extraction from varied sources would be highly desirable. The skills and experience required for this job includes: - Extensive knowledge on Python-based data extraction methods - Proven experience with managing and manipulating MS SQL databases - Ability to adapt to multiple and potentially unexpected data sources - willing to work via anydesk for final installation of the project Given the urgent nature of this project, only those who can demonstrate a commitment to quick turnaround times need apply.

I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.

...Minimum of 10 years' practical experience in cybersecurity, preferably with recognized companies. Proficiency with various cybersecurity tools and programming languages. Expertise in identifying and mitigating risks, threats, and vulnerabilities. Technical Skills: Hands-on experience with Security Information and Event Management (SIEM) tools. Proficiency in Python, Linux, and SQL. Knowledge of CIA Triad, governance, risk analysis, compliance, and business continuity planning. Familiarity with Linux and Windows server configuration, Active Directory, network architecture, operations, and security. Experience in areas such as Wireshark, email security, wireless security, cryptography, port scanning, cloud security, and virtualization. ...

I am seeking a freelancer who can efficiently develop an ER (Entity-Relationship) model for a targeted domain, specifically incorporating the relationships and entities of Customers and Orders. Key requirements include: - Proficient expertise in ER modeling - Ability to capture and incorporate Customers and Orders as specific entities and relationships in the model. - Ensure that the 'Customers' entity accurately stores 'Name and Contact Information'. Ideal candidates should have a solid understanding and experience in designing ER models, with a sharp eye for capturing accurate details in such systems. Timely delivery of the project will be a critical factor to consider. Kindly include your relevant skills and experiences in your bid. Looking forward to working with...

Application code to implement Roomio as a web application in python. You will use the table definition posted at the end of this document.

I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.

I am seeking an experienced software developer with expertise in creating robust web application...analysis for better decision making Needed Functionality: - Inventory management system: The application should keep accurate track of the inventory levels and alert the users when restocking is needed. - Payment management: The application should be capable of processing payments, invoices, and balancing accounts. Ideal Skills: - Proficiency in back-end and front-end development - Knowledge in SQL for database structure - Understanding of payment gateways The successful freelancer should exhibit strong understanding of cloud infrastructures and advanced data security measures. Experience in creating similar systems would be a significant advantage. The simpler the applicatio...

Create a relational database for the following data in a single tables with parts store. You may use alphanumeric to represent store and use surrogate key as primary key. Bring a hard copy in class and answer two quires in class. (points Project creation 20 + two query 20) 1. Vendor 1: Low Hardware, 1200 Harding st, Pine Bluff, AR 71602, Phone 870-535-1000 Supplies screw Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .02 300 Yes 100 .04 6-12 Yes 3/4” .03 300 Yes 200 .06 6-32 Yes 1” .04 400 Yes 200 .08 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes 20 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” ...

FOR MELBOURNE BASED FREELANCERS ONLY I am a finance professional with over 30 years experience in the investment markets. I need an experienced tutor in Microsoft Access to assist me with database creation and query design and optimization. The ideal candidate should be able to help me understand: - How to create a well-structured database in Microsoft Access - The best practices for query design and optimization to enhance the efficiency and speed of the database operations You should also be able to provide guidance on: - How to maintain a clean and minimalist design that is easy to navigate - The creation of a user-friendly interface that is intuitive and easy to interact with - The customization of templates to suit specific requirements The ...

I need an experienced developer with proficiency in both Vue.js and .NET, capable of delivering the pro...applications. - **Project Details** - The developer is expected to create an enterprise application with an interactive UI. - I place a significant emphasis on an engaging, usable and intuitive interface. - **Timeline** - The project needs to be completed ASAP. So, I'm looking for someone who can dedicate sufficient time immediately. -** Vue.js 2 and 3 experience ** with .Net Web API and sql server required on expert level Ideal candidates can demonstrate previous experience working on similar projects and have a strong understanding of UI/UX principles. this a NDA Project and no code will be share and is a remote work, NO PHP folks needed or bid on this proje...

I'm looking for a skilled developer to integrate a database for our congregation into my Squarespace website. I manage a Hindu temple. Requirements: - The primary purpose of this database will be to store our congregation's contact information. This includes details such as name, email address, and phone number. - The integration should be seamless, with the database easily accessible and manageable through the Squarespace platform (maybe, more like contact information collected from our website). - Prior experience with Squarespace and developing client databases is a huge plus. - We should be able to easily send an email to targeted groups within our database. Please provide your portfolio or examples of similar projects you have completed.

...able to identify the root cause and resolve it promptly. - **cPanel Account Missing**: Currently, some cPanel accounts are not showing. The task involves investigating and rectifying the issue. - **Service Stoppage**: Some important services have stopped working. The ideal candidate should have experience with Linux administration and be able to troubleshoot and restart these services effectively. Ideal skills and experience include: - Proficient in Linux server administration, particularly with MySQL and SSH - Strong troubleshooting skills to identify and resolve service stoppages - Experience with cPanel account management - Excellent communication to understand the issues and provide timely updates on progress Please apply if you can start immediately and have a pr...

...similar to but tailored to our specific needs, including custom graphics and a unique logo that represents our brand identity. KEY REQUIREMENTS Languages and Frameworks: - Frontend: Expertise in HTML5, CSS3, JavaScript, and experience with frameworks like React.js or AngularJS. - Backend: Proficiency in server-side languages such as PHP, Python, or Node.js, with database management using SQL or MongoDB. - CMS Experience: Capability to integrate and customize content management systems (CMS), preferably WordPress or Drupal. Design and Graphics: - Creation of a unique logo and custom graphics that reflect our brand and the services we offer. - Design a responsive and accessible website that adjusts smoothly to different screen sizes and devices. - Clear and intuitive n...

I'm in need of a skilled Nginx expert to help me configure a server for my application. Some key details about the project are as follows: - I'm looking to implement Load Balancing and SSL termination for my TCP traf...the UDP side, I would like to have the server configured for Streaming Media and DNS Resolving. In addition, the Nginx should be set up on a Linux-based operating system. Ideal skills for this project include: - Proficiency in Nginx configuration and management - Strong understanding of TCP and UDP protocols - Experience with Load Balancing, SSL, Streaming Media and DNS - Linux server administration I'm open to suggestions for the best approach in setting up these features, so good communication and problem-solving skills are a plus. Looking ...

I'm urgently in need of a qualified developer or data engineer to create a pipeline utilizing D...appropriate error logging and handling mechanisms Ideal Skills and Experience: - Strong proficiency in DBT and SQLLITE - Experience with data pipelines, specifically involving text file processing - Familiarity with data transformation techniques - Quality assurance and bug fixing capabilities Deliverables: ● A DBT project containing models for company_analytics and skills_analytics tables. ● SQL scripts or DBT models to process JSON files and populate the analytics tables. ● Instructions for running the DBT command to process the data and execute data quality checks. ● Documentation on adapting the pipeline for continuous file deliveries and suggested additional data quality me...

...provide straightforward and intuitive navigation. Qualifications: Demonstrable experience in web design with a portfolio of work on WordPress and WooCommerce. Ability to craft an attractive, user-friendly website interface that aligns with our branding. Knowledge of current web design trends and an understanding of the best practices in e-commerce website aesthetics. System Administration: All system administration tasks have been handled; we have hosting in place, WordPress and WooCommerce are installed, and the Porto theme is purchased and set up. Application Instructions: Interested designers should send in their portfolio highlighting previous work, particularly with WordPress themes and WooCommerce integration. The ideal candidate will show a proven track record...

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data includin...production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column in Excel.

I am looking for a skilled developer to create a Window...skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, M...

I'm facing an issue with my Laravel admin panel, specifically a database table owner error that's occurring when uploading a zip file. - The error seems to be centered around the database table ownership. - The error happens during the process of uploading a zip file. - I can provide more details on the issue if required. I'm looking for a professional with experience in Laravel, database management, and debugging to help resolve this issue. The ideal candidate should be familiar with Laravel's database interactions and be able to navigate and troubleshoot these types of issues efficiently.

As a business utilizing Salesforce, I am seeking admins and developers with deep understanding of the platform to craft insightful blogs focusing on: - Salesforce Administration - Salesforce Development This is not general content writing project instead need content creators who have base understanding of platform. The key requirements are as follows: - Deliver around 10 - 15 blogs per week - Each blog should contain approximately 1000 words with pictures and target keywords provided by me on the topic - Emphasize practical use-cases, tips and tricks, and best practices within Salesforce administration and development Each write-up should be affordably digestible, ideally geared towards a mid-level audience with a desire to improve their Salesforce skills. Prior experi...

...etc. Activity Logging: Implement an activity logging system that records all interactions performed through the application, including message sending, delivery status, etc. Technologies Used: PHP: Primary programming language for backend development of the application. MySQL: Database for storing user information, contacts, and activity logs. WhatsApp Business API: Official API provided by WhatsApp for sending messages from business applications. HTML/CSS/JavaScript: For frontend development of the administration and configuration web application. Deliverables: Complete source code of the PHP application. Detailed documentation on installation, configuration, and usage of the application. User manual to guide administrators in using the application. Considerations: It i...

I'm in need of legal research focusing on probate, trusts and trust administration within Colorado, to support a forthcoming filing. The research will require identification of the relevant probate laws and legal codes in Colorado, specifically in the area of some specific aspects I will share in private. This summary should encompass the most current laws - so an update on recent changes in laws is important. The goal is to provide me with supportive applicable laws to my filing Ideal candidates for this project should be well-versed in probate law, specifically related to trust administration. A background in legal research and a familiarity with the Colorado legal system will be highly advantageous. Accuracy, attention to detail, and the ability to convey complex ...

I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring hostin...

As a business user, I need assistance with the configuration of SS...WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the call since this is a secured environment. Also, this needs to be executed...

... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicate...