Database fundamentals tutorial punët
See attachment. hfghjhgfghjhgfdsdgklkjhgfghjklknvbnmnbvcvbnm,.mnbvertyuytrertrghjugfdghjkjhgfdgkjhgfdfgjkjhg
I'm looking for a Kotlin developer with experience in migrating applications from local Realm to MongoDB Realm. The current status of the app is fully developed, and I'm only interested in converting the local Realm database to the MongoDB Realm database, without any additional feature or minor changes. The ideal candidate should: - Be proficient in Kotlin - Have experience with Realm - Have experience with MongoDB Realm - Understand database migration processes and best practices
I'm a self-employed professional looking for hands-on assistance in New York City to set up my business email on Microsoft Outlook. This job requires a tech ex...setup and management. Here are some of the tasks I need assistance with: - Set up my Outlook email account successfully - Simplify the way I organize and manage my emails - Provide step-by-step guidance on how to maintain the setup in the future Preferred Skills: - In-depth knowledge of Microsoft Outlook - Previous experience in email account setup - Excellent communication and tutorial skills - Ability to solve technical issues - Based in, or able to commute to New York City If you can help me streamline my email management in Outlook, I'd love your expert guidance. Please reach out with your...
I am looking to create an engaging Instagram reel in a bid to increase my brand awareness. The reel will require a blend of product demos, tutorial videos, as well as behind-the-scenes footage, all designed to appeal and resonate with a wide age audience ranging from Gen Z (ages 18-24), to Millennials (ages 25-39), and Adults (ages 40+). Key Deliverables: • An engaging, interesting Instagram reel. • A fusion of product demos, tutorials, and behind-the-scenes clips. Ideal Candidate Skills: • Proven experience in social media marketing • Knowledgeable about Instagram reels and trends • Well-versed in video editing • Experience in creating content that appeals to varied demographic ranges. Project Objective: • Increase brand awareness while res...
I'm looking for an experienced freelancer to tackle data entry. The focus is on text data, which needs to be accurately inputted into a structured database. While attention to detail is important, issues checking for spelling or grammar errors will not form part of the job scope. In line with this, the ideal candidate should: - Have a proven track record with data entry projects - Have expertise in structured databases - Be able to work accurately with text data - Have the ability to complete tasks effectively within the given timeline.
I am looking for a database website that serves as a customer form. This form will be used by customers to fill in various fields. Upon submitting the form, they will automatically receive a comprehensive response based on the information they provided. Key Requirements: - The customer form should include fields for Name, Contact information, Address, Location, Product or Service details, Width and Height, Dimensions, and Vertical or Horizontal preference. - The form should have an inbuilt auto-calculation feature that computes the Total cost, based on the area calculated, and any additional amount based on the customer's requirements. Delivery of Reverted Information: - The system should trigger an automated response to the customer. This can be in the form of an Email, a We...
I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...
I urgently require a thorough cleanup of my contact database. The main tasks include: - Verification of the correctness of email addresses - Authenticity check of RUTs - Verification of phone numbers The right candidate for this project should possess excellent attention to detail and experience in database management, particularly in contact cleaning. Familiarity with RUT verification will be highly valued. Please apply only if you can start immediately.
I'm looking for a skilled Unity 2D game developer to create an educational game. - Game Type: The game will be an educational game. - C# Focus: The main goal of this project is to teach users the fundamentals of C#. - Target Age Group: The game is specifically designed for teenagers (13-18+). The ideal candidate should have: - Proficient in Unity 2D game development. - Experience in creating educational games. - Strong understanding of C# programming language. - Familiarity with game design principles and user experience. If you're passionate about game development, education, and have a creative mindset, I'd love to hear from you.
...ATTACHMENTS. Cannot share Code before you accept. I have a Journal App built in PHP/JavaScript/Laravel which allows to enter Journal entries, country, some photos and one video of limited size, different costs etc (see ). The job is to implement the feature of Travel Route Map Creation using Leaflet and OpenStreetMap (both free, opensource). There is a tutorial here Users will be able to search a place in map, create lines of different colors from one place to another, add/tie blog posts, links and pictures with the map, dates, notes and then only map creator can download the map as Image/PDF. Leaflet free plugin is there for this. Each created map should have unique link. Creator
I'm in need of an expert to optimize my WordPress database speed. The current issues I'm facing involve slow loading times and prolonged database queries. The following tasks are essential for fixing the site's speed: - Updating and optimizing plugins: The site is currently slowed down by outdated plugins. An experienced professional should be able to update and optimize these plugins to enhance the site's performance. - Database performance improvement: As my priority lies in improving database performance, the freelancer should focus on database queries and other related optimizations to ensure the site runs smoothly and efficiently. - Site speed score: The ultimate goal is to achieve a site speed score above 95. The hired individua...
I'm currently encountering connectivity issues with my existing Azure Virtual Networks specifically with connecting to the MySQL database. I have a main Vnet with my mysql database in there. I have a virtual machine in there too which can connect to the database I have a second vnet which is peered to the main vnet. I have a virtual machine in this vnet too. It can talk to the virtual machine in the main vnet, but cannot connect to the database. I need it to be able to, and I cannot figure out why. You can tell me how to do it and I can test, this doesn’t need to be a long project!
I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.
I'm in search of a skilled and experienced web designer who specializes in blog website creation. I intend to utilize this platform primarily for sharing resources and tutorials. Key Requirements: - Develop a blog-type website - Professionally designed layout - User-friendly interface Additional Functionality: - Add functionality for user registration and login - Integrate a subscription list feature Ideal candidates would possess high proficiency in creating user-engaging web designs and have a keen understanding of incorporating specified features. Knowledge and experience in website usability and functionality are vital. The main goal is to foster a smooth user experience and promote continuous interactions.
I am in need of a skilled data entry operator to assist with the transfer of input of text data. Your main task is to take text data from an online database and accurately enter it into an Excel spreadsheet. Requirements: - Ability to accurately enter text data - Proficient in Excel - Experience sourcing data from online databases - Diligent and detail-oriented to ensure no errors are made during data transfer - Strong English language skills to ensure effective communication The ideal freelancer for this project is someone with proven data entry experience, excellent Excel skills, and vast familiarity with online databases. Being a detail-oriented person with great concentration skills will be a huge plus.
We are looking for a professional with excellent skills in Lua programming to refine our existing code. This role entails making edits to variables A, B, and C in our Lua codebase, and we expect these changes to bring about an exquisite functionality. Post-editing, we'd need you to create a step-by-step learning draft (PDF) on how you managed the edits along with fundamental tools used. The tutorial should target learners at an intermediate level, ideally incorporating some advanced concepts to provide a more rounded understanding of the editing process. You should have: - Strong proficiency in Lua programming - Ability to explain complex concepts in an understandable way. Your bid should reflect your understanding of these requirements. We're excited to see your propo...
I'm looking for a skilled Unity 2D game developer to create an educational game. - Game Type: The game will be an educational game. - C# Focus: The main goal of this project is to teach users the fundamentals of C#. - Target Age Group: The game is specifically designed for teenagers (13-18+). The ideal candidate should have: - Proficient in Unity 2D game development. - Experience in creating educational games. - Strong understanding of C# programming language. - Familiarity with game design principles and user experience. If you're passionate about game development, education, and have a creative mindset, I'd love to hear from you.
...Oracle 19c database through JDBC. The primary goal of this project is to incorporate essential data operations into the application, mainly including reading, writing, and updating data in the database. Key Responsibilities: - Establishing a secure connection to an Oracle 19c database using JDBC. - Implementing CRUD operations (Create, Read, Update, Delete) features within the application. - Ensuring the application is optimized for efficient data handling and processing. Security Requirement: - The application must be able to securely access the database using username/password authentication. Ideal Candidate: - Proficient in Java and Springboot framework development. - Experienced with Oracle database SQL and JDBC connectivity. - Prior experience...
We are looking for a MILVUS devOps expert who will know how to recommend and install the best Milvus hosting server. We are also looking for someone who has done this before MANY MANY times. The end goal is to 1/ recommend which Milvus install plan is best (K8, simple Docker, etc...) 2/ install Milvus and 3/ write detail documentation on how it was done. Then we may want to give you the chance to support and maintain the install. FOR us to consider your submission (WITHOUT the answers to these questions your submission will be automatically deleted) Question 1: Please let us know how many times you have configured and install Milvus. Question 2: Please describe the best architecture you recommend to install and host Milvus. Question 3: Will you be able to demo at leas...
I need a detailed tutorial that shows how to automatically link Jira tickets to Confluence tags and update Jira tickets when Confluence tags are added. Key Points: - The automation should be based on ticket keywords. I want the process to run smoothly without manual intervention. - The tutorial should focus on including the ticket title in the Confluence tags. This will help in maintaining consistency and clarity across both platforms. Ideal skills and experience for this job: - Proficiency in Jira and Confluence: The freelancer should have a deep understanding of both platforms to effectively demonstrate the automation process. - Automation Expertise: Experience in automating workflows between different tools would be a big plus, especially in the context of project manage...
I am in search of a proficient data entry specialist to integrate data into my online Microsoft Access database. Key Responsibilities: - Entry of a large volume of data accurately and efficiently - Verify the integrity of data before entry into the database Ideal Skills and Experience: - Proficiency with Microsoft Access - High attention to detail, precision and excellent organizational abilities - Prior experience with large database data entry is a plus Please note, the spreadsheet format requirement was skipped and so any standard format is acceptable. Only apply if you are proficient, accurate, diligent, and can meet deadlines.
I'm looking for an experienced PHP developer to work on a new E-commerce website. The project involves: - **Website Development**: You'll be responsibl...E-commerce website. The project involves: - **Website Development**: You'll be responsible for creating a complete E-commerce platform. This includes setting up the necessary pages, product listings, and a user-friendly interface. - **Database Management**: Besides building the site, you'll also be in charge of managing its database. This involves ensuring data integrity, proper storage, and efficient retrieval. Ideal candidates for this project should have: - Proven experience in PHP development, specifically in E-commerce platforms. - Strong database management skills. - Understanding and e...
I'm in need of a professional who can efficiently handle data entry tasks into a database. The source of the data will be a mix of physical documents, digital files, and potentially web sources. Key Requirements: - Experience in online data entry. - Proficiency in database handling. - Strong attention to detail. - Ability to work with a variety of data sources. Your primary responsibilities will be: - Entering data accurately into a database from various sources. - Ensuring the integrity of the data being entered. The ideal candidate should be able to demonstrate a high level of focus and accuracy while working at a reasonable pace.
I am looking for an experienced 2D animator to create a short, up to one-minute, animation. This will guide users on how to conduct an inspection. ...not exceed one minute. - Inspection Guide: The animation will be used as a guide on how to conduct an inspection. The main deliverable is a high-quality animation that is engaging and informational. The animation will be used to demonstrate a step-by-step process. Ideal skills and experience: - Proficient in 2D animation and creating engaging content - Experience in creating instructional or tutorial videos - Strong understanding of visual storytelling and ability to simplify complex concepts. The ideal candidate should be able to understand and visualize the inspection process effectively, creating an engaging and informative sh...
...have less than 10 columns, as I believe this will keep the sheet concise and easy to manage. The level of automation I am looking for is manual data entry with some formulas. This will help reduce manual work and ensure the data input is accurate. Ideal skills and experience for this job would include: - Proficiency in Excel: A deep understanding of Excel and its functionalities is essential. - Database Management: Experience in handling databases will help in setting up the product list and other related data. - Inventory Control Knowledge: Understanding of inventory control principles is a plus. - Report Generation: Experience in creating reports in Excel will be beneficial. Your goal is to create an efficient, user-friendly, and reliable Excel sheet that will help me manage...
I need a step-by-step video created to walk our website visitors through a process. The video's primary purpose is to enhance user experience on our website. It should be engaging, informative, and easy to follow. Key Requirements: - Video Type: Step-by-Step - Platform: Company Website - Goal: Walkthrough a Process Ideal S...The video's primary purpose is to enhance user experience on our website. It should be engaging, informative, and easy to follow. Key Requirements: - Video Type: Step-by-Step - Platform: Company Website - Goal: Walkthrough a Process Ideal Skills: - Video Production - Video Editing - Script Writing - Web Design (for seamless integration) Experience: - Previous experience with explanatory or tutorial videos is a plus - Good understanding of user ex...
...making some changes to the the user interface of my healthcare database website. The primary goal of the changes is to significantly enhance the user experience and make it more userfreindly. This is not a "redesign" task! The staff have learnt how to use the database and I don't want them to have to need to learn their way around a whole new database... not requesting any major changes, but a few points which are mostly related to the way the information is displayed not being user friendly. I need specific changes made. Please see document attached. I'm hoping to work with someone who has experience in both database website development and user interface design. It's important to me that you understand that the way the databa...
I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...
I have a project that involves entering text data from printed documents into a database. Ideal Skills and Experience: - Proficiency in data entry and accuracy in transcription - Experience working with printed documents - Knowledge of database management - Attention to detail to ensure complete and accurate data input Key requirements for the job include: - Efficiently entering text data from printed documents into a database - Ensuring the highest level of accuracy in transcribing the information - Organizing the data in the database in a logical and coherent manner - Completing the task in a timely manner without compromising accuracy. Your understanding of the importance of this task in the overall project and your commitment to quality and efficiency w...
...pandas, numpy, scikit-learn, and matplotlib. Key Topics: - Thorough insight into SQL commands and functions - Comprehensive knowledge on data cleaning with pandas - Expertise in Machine learning with scikit-learn Purpose of The Content: - Strive to educate, serving as a tutorial guide - Adequate for usage in documentation Ideal skills: - Advanced expertise in SQL and Data Science libraries - Exceptional writing skills with the ability to communicate complex ideas simply - Proven experience in creating educational, tutorial, and documentation content. Please ensure your bid reflects your understanding of these requirements and your past experience in these areas....
I'm seeking a skilled developer to help build a dynamic and secure social registry database. The primary purpose of this database will be to store specific categories of user information, making it a critical data backbone for our social business operations. Key features will include: - Storage of Personal Identities: User's demographic and identity-related data. - Interaction Histories: Tracking user interaction data for better service delivery. - Location Data: Storing user location data to improve geographically targeted offerings. Moreover, I envision a flexible data entry process encompassing: - Manual Data Entry by administrators: Option for admins to input data manually, ensuring the correct configuration and verification of user information. - Automated Da...
I have a recent backup from 4/1/24 on a hard drive attached to my new computer. My previous computer died, the motherboard went out and somehow my SQL Server data was not saved on the original hard drive. I need to pull the data from a ".DATA" file, or find the missing SQL Server backup files and copy them into my existing program for use. Can anyone help?
I am looking for an expert in MS Excel and navigating a website. We will provide a list of certain colleges and universities in the United States, 258 of them. Go to and type the name of the school, then type “athletics staff directory” and hit enter/search. The first site listed will be the staff directory for the athletic department. Scroll down to the Football staff. For every member of the Football Staff who has an email address listed, you need to enter that staff member’s information (School Name, First Name, Last Name, Title, Email Address, Twitter) into the spreadsheet. This is a single project that would need to be completed each year. Pay would be made upon completion of the project. Mode of communication is English.
Looking for Social media marketing for tutorial class advertisement class 1 to 10 on what's app and Instagram on local level
I'm looking for a professional to help in setting up an SQLite database which will store and manage moderate data with multiple attributes. Key requirements: - The database should be optimized for storing and retrieving moderate data, such as an inventory system with multiple attributes. - No complex data analysis is necessary, just a user-friendly system for managing and retrieving stored data. - Basic search and filter functionalities are required. Ideal skills for the job include: - Proficiency in SQLite database design and management. - Experience in setting up databases for inventory systems or similar systems. - Ability to implement basic search and filter functionalities.
I'm currently experiencing slow performance from my WordPress database that appears to be most apparent when using Mysql/MariamDB which is affecting my admin and dashboard areas. Ideally, I'm seeking assistance from a professional with substantial experience in WordPress and database optimization. The main skills and experience required include: - Knowledge and skills in MySQL/MariaDB - Expertise in WordPress database management - Experience working with websites having more than 20 plugins. Your task will include performing necessary optimizations to significantly enhance the performance of the website, specifically the admin and dashboard areas. Please, include examples of similar projects you've worked on when bidding.
I am in immediate need of a comprehensive database containing information about IT professionals with 2-3 years of experience. This is crucial for a current initiative, thus I need it ASAP. The database should provide: - Name - Phone Number - Skills - Educational Background - Work Experience - Salary Precision is of utmost importance to me. Therefore, an ideal freelancer for this task should have proven experience in data collection and data entry, with a keen eye for detail to ensure the accuracy of the database. Experience in the IT or HR industries would be a significant advantage.
I am seeking a skilled female tutor for my wife, who can provide basic Quranic recitation and Arabic lessons specifically tailored for beginners and focused on adults. To provide the best instruction possible, the ideal candidate should demonstrate the following qu...knowledge of Quranic recitation principles. - Experience in teaching adults, preferably beginners. - Proficient understanding of teaching techniques and strategies. - Excellent communication skills. These lessons should start from the basics, providing a strong foundation in Quranic recitation for individuals with little or no previous experience. Your key responsibility will be introducing the fundamentals to get the learners started in their Quranic journey. Please propose your monthly rate for 8 lessons a month. ...
...data into a database. While the data entry itself isn't particularly complex, a certain level of basic data cleaning will be required. Key Requirements: - Data Entry: The main task is to accurately input data from PDFs into a database. The data is mostly textual, so typing proficiency and attention to detail are essential. - Database Organization: The entered data needs to be organized in a clear, logical manner to ensure it's easily searchable and can be efficiently used. - Basic Data Cleaning: The data will need to be reviewed and cleaned up to ensure accuracy and integrity. This will involve identifying and removing any duplicate entries. Ideal Skills and Experience: - Proficient in Data Entry: Experience with data entry tasks, particularly those inv...
I'm urgently in need of a skilled professional who can swiftly deploy a database server for me. Key Responsibilities: - Establishing a server primarily intended for databases - Choosing the suitable database management system (DBMS) Ideal Competencies: - Extensive experience with multiple DBMSs as I'm not yet decided on which one to use - Ability to work under pressure and deliver swiftly since the project is urgent - Prior experience with server deployments will be highly advantageous.
I’m experiencing a persistent issue with lagging or delayed replication in my SQL Server database. The primary problem revolves around the replication process not effectively happening in a timely fashion. Ideal Skills-needed: - Solid skills in SQL Server management - Proficient understanding of database replication processes - Excellent problem-solving and diagnostic abilities in the context of database administration The ideal freelancer for this project will be able to not only identify the source of this issue but will provide a solution to improve the replication time. It's crucial that you have managed SQL Server databases before, ideally in a high-transaction environment, and have a deep understanding of data replication.
...an Access database that can primarily handle generating reports and analytics. The main goal is to keep track of internal data for further analysis and reporting. Key Features and Functions: - **Reports & Analytics:** The database should have the capacity to generate comprehensive and insightful reports from the data gathered. It's crucial that these reports are insightful and easy to understand. - **Data Tracking:** The database will be used for tracking internal data. This needs to be done with precision and the ability to link data for comprehensive tracking. - **Data Input & Updates:** The system should allow for easy input of data and updating when needed. This will facilitate the generation of accurate and updated reports. Ideal Skills: - Pro...
I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.
I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS
I'm looking for a proficient person that can go into links and write emails and phone numbers. There are 15,000 Records to revise. Work needs to start asap and be completed with a good team. This is not a one person job. I need all records completed real time from a file on google drive. Must be complete with 24 hours Currently, I'm using Excel spreadsheets, which is proving inefficient. I require an effective solution to input data and offer functionality that makes the information more accessible. Your Tasks: Go into profile and extract email, phone number , link in the bio and also any nics in the bio Required Skills and Experience: - Understanding of search functionalities - Data Entry - Knowledge in data export would be a plus. You should have a strong track recor...
I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp
I am looking for a talented animator to create an entertaining and instructional cricket coaching video for kids. The video must be produced using 3D computer animation. Key Focus: * Batting Technique (The straight drive) The content of the video should be specifically tailored to engage and teach young, novice cricketers on the fundamentals of batting technique. Therefore, an understanding of cricket basics or previous experience creating sports training materials will be advantageous. Can you base the content around a young boy called Hudson, trying to master his cricketing skills. Ideal Skills: - Expansive knowledge of 3D computer animation - Capacity to make complex techniques understandable and engaging for kids - Familiarity with cricket or sports animation specifically. ...
There will be additional $50 for any who completes this project fully. The aim of this project is to compare three types of databases(Any relational database, mongoBD and Neo4J) in terms design approach, implementation, query composition, and performance. The data is about texas hold em poker game The stages of the project are 1. Look at the details of the data 2. Come up with an ER diagram and a relational schema for the data 3. Create a database in any relational db and tables 4. Create a python script to read the txt files and populate the db 5. Test the queries 6. Populate the other(mongodb and neo4j) databases and test the queries Then test the queries below on the databases QUERIES 1. Separate players by their style of play/Group players with a similar style of play ...
I've been experiencing some difficulties with my MS Access database. Error messages appear indicating missing or broken files namely, ‘’ version 7.0 and ‘’ version 1.0. Some occur as soon as I try to open the application. No recent changes have been made to my computer's operating system or the MS Access software. Ideal applicants for this task should be proficient in MS Access, troubleshooting, and database management. You'll need in-depth knowledge of system files and how they might impact the functionality of the application. A knack for solving complex technical problems is also important. In turn, you should be capable of providing a lasting solution to prevent the recurrence of these errors. Cheers!
