This resource is a video abstract of a research paper created by Research Square on behalf of its authors. It provides a synopsis that's easy to understand, and can be used to introduce the topics it covers to students, researchers, and the general public. The video's transcript is also provided in full, with a portion provided below for preview:

"Genomics research has greatly increased understanding of the human gut microbiome, but the existing reference databases remain insufficient, failing to map up to half of the sequences obtained in human gut studies. To solve this problem, researchers recently created HumGut, a comprehensive global reference database for the genomes of gut microbes in healthy humans. The researchers built the database by comparing nearly half a million publicly available prokaryote genomes with over 3,500 gut metagenomes from healthy humans worldwide, and retaining the prokaryote genomes that closely matched the sequences in healthy human guts. HumGut was approximately the same size as the recently released UHGG collection and half the size of a standard reference database. However, HumGut outperformed both other databases in classifying metagenomic reads from human gut samples, resulting in a lower percentage of unclassified reads..."

The rest of the transcript, along with a link to the research itself, is available on the resource itself.

These exercises are originally part of the KLaSS module developed by King's College London Library Services to provide information literacy e-learning to students across our faculties. They were built and developed with Adobe Captivate 9 and published in HTML5 format, suitable for use with Moodle.This set of exercises is designed to provide information literacy support to students in the Faculty of Natural & Mathematical Sciences, which encompasses subjects like Informatics, Computer Science, Mathematics and Geography. The database used to demonstrate the principles is Web of Science, a broad resource holding literature on a wide variety of STEM subjects.The lessons cover the following topics:Planning an effective literature search - how to focus a research question and identify its key topics and componentsFinding literature - how to use different search techniques like truncation in Web of ScienceFinding full text articles in Web of Science - how to use the SFX system to look up the full texts of search results, and what to do if you don't immediately get accessWeb of Science Search Tips - using slightly more advanced techniques to run better searches, like using phrase searchingCombining searches in Web of Science - how to use AND & OR to broaden and refine seaches in Web of Science to retrieve relevant articles and informationFiltering search results in Web of Science - how to use Web of Science's filtering options to futhere refine results and exclude irrelevant articlesEach topic has a demonstration video, narrated by the author Tom Edge.The exercises have been published in HTML5 format so they should be compatible with any modern LMS. The authors have only used these files in Moodle 3.0, so cannot offer support for another LMS.

These exercises are originally part of the KLaSS module developed by King's College London Library Services to provide information literacy e-learning to students across our faculties. They were built and developed with Adobe Captivate 9 and published in HTML5 format, suitable for use with Moodle.This set of exercises is designed to provide information literacy support to students in King's Health Faculties which incorporates subjects like Medicine, Bioscience, Dentistry, Neuroscience and other health subjects. The lessons cover the following topics:Literature Searching part 1: Introduction to literature searching -Part 2: Choosing and accessing databasesPart 3: Your research question and planning your searchesPart 4: Searching with keywordsPart 5: Searching with Subject Headings (thesaurus searching)Part 6: Combining searches with AND & ORPart 7: Using limits in your searchPart 8: Working with your resultsEach topic has a demonstration video, narrated by the author Karen Poole.The exercises have been published in HTML5 format so they should be compatible with any modern LMS. The authors have only used these files in Moodle 3.0, so cannot offer support for another LMS.

This set of exercises is designed to show students how to use CINAHL, an academic database that holds literature primarily on Nursing, Midwifery and Allied Health subjects.

Whether you realize it or not, when you carry a smart phone, use a navigation system in your car, or look up the nearest coffee shop on your computer, you are using geographic information. Geographic data and technologies are embedded in almost all aspects of our lives. GEOG 160, Mapping Our Changing World, explores what geographic information and data are, what makes them unique, how they are created, and how we use them. You'll explore how geographic technologies like geographic information systems (GIS), remote sensing from satellites, and global positioning systems (GPS) work together to provide us with information we rely on. You'll also become an informed consumer of the geographic content in your life.

The „andut’ website provides up-to-date resources and guidance on foreign language learning in grades PreKĐ8, with the intention that such information will help provide a strong foundation for long-term language instruction. The website offers multiple links to other resources, such as a searchable database for early language learning schools and teaching resources. A listserv is available as well via the website.

OpenML is an online machine learning platform where researchers can easily share data, machine learning tasks and experiments as well as organize them online to work and collaborate more efficiently. In this paper, we present an R package to interface with the OpenML platform and illustrate its usage in combination with the machine learning R package mlr (Bischl et al, 2016). We show how the OpenML package allows R users to easily search, download and upload data sets and machine learning tasks. Furthermore, we also show how to upload results of experiments, share them with others and download results from other users. Beyond ensuring reproducibility of results, the OpenML platform automates much of the drudge work, speeds up research, facilitates collaboration and increases the users’ visibility online.

This resource is a video abstract of a research paper created by Research Square on behalf of its authors. It provides a synopsis that's easy to understand, and can be used to introduce the topics it covers to students, researchers, and the general public. The video's transcript is also provided in full, with a portion provided below for preview:

"Phosphorus is essential for life to function. It is a critical component of the energy metabolism molecules, genetic materials, and cell structures of all life. Phosphorus only enters natural ecosystems through the slow weathering of stone. Then microbes help maintain and regulate phosphorus by cycling it between its organic and inorganic forms. Understanding microbial phosphorus cycling is critical to many fields of study, like ecology and agriculture. However, researchers lack a comprehensive understanding of the phosphorus cycling genes microbes use, but the recently developed curated phosphorus cycling database (PCycDB) could help close that gap. PCycDB covers 10 phosphorus metabolic processes and 139 gene families, including several that have been missed elsewhere. Testing PCycDB with simulated datasets revealed high annotation accuracy, positive predictive value, sensitivity, specificity, and negative predictive value..."

The rest of the transcript, along with a link to the research itself, is available on the resource itself.

This resource introduces the structure of relational databases, a critical technology behind dynamic, data-driven websites.

Half a century after they were first described, relational database systems remain by far the most popular choice for the storage of large datasets. The book starts by describing the practical and theoretical reasons why this is so.

It then shows how to analyse a data requirement and use it to design and develop a database. Through a series of practical exercises and prepared scripts, it teaches SQL, using a freely downloadable, fully working database system (SAP SQL Anywhere™ for Windows 7 and above, MacOS 10.9 and above, and Linux)

The author works as an independent consultant. He had a career in database systems, and taught the subject for more than two decades, as a course tutor for the UK Open University. He is a Fellow of the Higher Education Academy.

Students become familiar with the online Renewable Energy Living Lab interface and access its real-world solar energy data to evaluate the potential for solar generation in various U.S. locations. They become familiar with where the most common sources of renewable energy are distributed across the U.S. Through this activity, students and teachers gain familiarity with the living lab's GIS graphic interface and query functions, and are exposed to the available data in renewable energy databases, learning how to query to find specific information for specific purposes. The activity is intended as a "training" activity prior to conducting activities such as The Bright Idea activity, which includes a definitive and extensive end product (a feasibility plan) for students to create.

Welcome to “SQL and Database Management Using Pop Culture,” a GitHub repository that leads a double life as an interactive Database and SQL textbook. Through this innovative approach, we blend the technical world of SQL and database management with the relatable and often thrilling realm of pop culture. This book is designed to make the complex concepts of databases not just understandable but genuinely enjoyable to learn.

Why This Book? Databases are the backbone of the modern data-driven world, yet their intricacies can often seem labyrinthine to learners. This book demystifies these complexities by drawing parallels with popular culture, weaving a narrative that is both informative and relatable. Whether you are a student stepping into the world of databases or a professional seeking to deepen your understanding, this book provides a fresh perspective that is both comprehensive and accessible. The book starts with basic queries in SQLite, and move on to introduce both PostgreSQL and MySQL in later chapters. The content is aligned with the content of the CompTia Data Sys+ and Oracle Database Foundations exams.

The Structure of the Book. Each chapter of this book is crafted like an episode of a TV series, where learning SQL and database management becomes an adventure rather than a routine academic endeavor. Here’s what awaits you in this journey:

Chapter 0: Get started with an interactive introduction to SQL and Python in Colab notebooks.
Chapters 1 to 12: From the deck of the Star Trek Enterprise to the magical corridors of Hogwarts, dive into every aspect of SQL and database management. Each chapter unfolds a new scenario, tying complex database concepts to familiar stories and characters from pop culture.
This repository houses twelve Jupyter notebooks, making the learning experience highly interactive and hands-on. You’ll not just read about SQL queries and database theories but also get to experiment and see the results in real-time.

This handout is your roadmap to understanding the differences between scholarly and popular sources! It includes helpful examples of each source type and tips for how to distinguish between the two within library databases.

A database of and access to journal articles and book chapters found useful by college and university science students; built from student work at Grinnell College, Grinnell, IA, USA. Used in science courses (especially Biology and Psychology courses) at Grinnell College.

This semester long subject (11.521) is divided into two halves. The first half focuses on learning spatial database management techniques and methods and the second half focuses on using these skills to address a ‘real world,’ client-oriented planning problem. The first half of the semester may be taken separately using the class number 11.523 and the second half may be taken separately as 11.524.
In order to help shape and utilize the information infrastructure that will support the management and development of our metropolitan areas, planners need a basic understanding of the tools and technology for querying, analyzing, and sharing complex databases and maps. Managing online access to large and constantly-changing spatial datasets can be a powerful aid to planning and can facilitate inter-agency cooperation and collaboration in an increasingly decentralized world. But it requires the use of knowledge representation methods, client-server technologies and access control issues that are quite different from what are needed to model and visualize standalone datasets on a personal computer. Hence, planners should acquire basic skills in database management, digital spatial data analysis, and networking.
The 11.523 portion of the semester addresses these issues while retaining a focus on planning (rather than on computer science). This is an intensive, hands-on class that stresses learning by doing. Exercises and examples involving real-world data, maps, and images are used to develop skills with database query languages and the design development and use of structured databases. Class work utilizes web tools, GIS, and database software with lab exercises primarily on the new high-performance PC computing cluster. Specifically, we will access an Oracle 8i database using SQL (structured query language) and use ArcView for GIS. Each week there are two sixty to ninety-minute classes plus another 90+ minute hands-on lab in electronic classrooms. Class lectures will focus on concepts and case discussion, the scheduled lab time focuses on computer mechanics and skill building. Specific topics during 11.523 include:

finding, understanding and structuring digital spatial data that are available on the Internet using various browsing, visualization, and data management tools;
considerable work with relational database technologies and the Structured Query Language (SQL) to design, construct, query, and update urban planning databases;
some experience with so-called ‘client/server’ and ’enterprise GIS’ technologies for facilitating distributed access to complex spatial data and urban planning applications;
advanced GIS topics such as 3D visualizations and geospatial web services.

The 11.524 portion of the semester will treat the classroom like a professional planning office, working as a team to produce a two deliverables for their client, Lawrence Community Works, Inc. (LCW), a community development corporation located in the City of Lawrence, Massachusetts. LCW and DUSP recently agreed to work together for the next five years to design and implement a multi-tier web-based planning system that promotes democratic involvement and informs community development projects. Your involvement this semester is critical, because the implementation plan that you craft this semester will serve as the road map for both organizations for years to come and the simple web-based planning tool that you design will engage stakeholders by giving them a better sense of how technologies can aid decision-making processes. To assist you with the more technical aspects of the project, we hired Robert Cheetham, President of Azavea, Inc. (http://www.azavea.com/ ), to provide exactly 100 hours of consultancy services. Through their project work, students will enhance important professional skills by:

formulating an implementation plan for a real client;
designing a simple web-based tool for understanding problems;
engaging constituents and stakeholders in a real setting;
integrating theory and practice by evaluating the role of technology in community development;
learning to communicate effectively within a group and with a professional consultant;
working with such tools as the WWW, Access, ArcView, ArcIMS, SDE, etc.

This resource is a video abstract of a research paper created by Research Square on behalf of its authors. It provides a synopsis that's easy to understand, and can be used to introduce the topics it covers to students, researchers, and the general public. The video's transcript is also provided in full, with a portion provided below for preview:

"The composition of our gut microbial community has been linked directly to our health, but researchers are only beginning to study the impact of its functional metabolic behavior, which can shift in response to external factors. Microbial production of H₂S in the gut is one such function, and it may be a colorectal cancer trigger. A recent study used publicly available datasets to examine the sulfur metabolism genes in our gut microbiota. Sulfur metabolism genes were more abundant and diverse than previously thought and were correlated with colorectal cancer. The researchers also examined two key sulfate reductases: dissimilatory sulfite reductases (Dsr) and anaerobic sulfite reductase (asr) and found that genes for asr were twice as abundant as genes for Dsr, suggesting that asr is a more important contributor to sulfate reduction in the human gut and found that genes for asr were twice as abundant as genes for Dsr, suggesting that asr is a more important contributor to sulfate reduction in the human gut..."

The rest of the transcript, along with a link to the research itself, is available on the resource itself.

Test para aplicar a los estudiantes de licenciatura interesados en hacer investigación digital utilizando bibliografía especializada, usar bases de datos bibliográficas, hacer revisiones de literatura o análisis bibliométricos.