Updating search results...

Search Resources

33 Results

View
Selected filters:
  • database
Mapping our Changing World
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating
0.0 stars

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.

Subject:
Physical Geography
Physical Science
Material Type:
Full Course
Provider:
Penn State College of Earth and Mineral Sciences
Author:
Jennifer Smith Mason
Joshua Stevens
Raechel Bianchetti White
Ryan Baxter
Date Added:
10/07/2019
Online databases for molecular biology
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating
0.0 stars

A network of online databases provides essential information for researchers in molecular biology. These databases give researchers quick access to current information on genes, proteins, model organisms and publications. This module introduces students to the basic structure of databases and the process for submitting information to databases. Students use several of these databases to collect information on a yeast gene of their choice. This module is part on a semester-long introductory lab course, Investigations in Molecular Biology, at Boston College

Subject:
Biology
Computer Science
Genetics
Material Type:
Module
Author:
Clare OConnor
Date Added:
08/26/2018
PCycDB: a comprehensive and accurate database for fast analysis of phosphorus cycling genes
Unrestricted Use
CC BY
Rating
0.0 stars

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.

Subject:
Biology
Life Science
Material Type:
Diagram/Illustration
Reading
Provider:
Research Square
Provider Set:
Video Bytes
Date Added:
04/14/2023
Rebika Rai_OER_ResourceBuilder
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating
0.0 stars

With the expansion of huge and complex real time data that is wandering across the internet today, the dimensions of data transmitted are escalating exponentially with each passing years. This makes working with standard database systems or on personal computers difficult because of its inability to handle outsized, unstructured and complicated data. Various institutes stores and uses massive amounts of data which are further utilized for generating reports to guarantee stability regarding the services they proposes. However, the challenge is how to analyze, capture, share, store, transfer, visualize, query, update and finally manipulate an impressive volume of data that has to be delivered through the internet to reach its destination intact maintaining its information privacy. Almost all the applications developed using any programming languages requires some external component to store and access data. The components for the same could be a local network, a cloud file or even a database. While sources like the network and cloud file systems store the unstructured data, the structured data is usually stored in a typical Relational Database Management System or RDBMS. The RDBMS operates with relational data model using schema for storing data into tables and is usually queried with SQL (Structured Query Language) for data operations. Usually it’s a time consuming process to define, structure, distribute and access data from RDBMS through SQL and hence, an alternative was developed for this called the NoSQL ("Non SQL", "Non relational" or "Not only SQL") database. This edited book chapter provides NoSQL databases hands on and attention has been paid to various types of NoSQL databases focusing on the details such as installation, creation, modification and various updation of one database belonging to each type.

Subject:
Applied Science
Computer Science
Material Type:
Lecture Notes
Date Added:
02/14/2019
Relational Database Systems - Why and How
Only Sharing Permitted
CC BY-NC-ND
Rating
0.0 stars

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.

Subject:
Applied Science
Computer Science
Material Type:
Activity/Lab
Data Set
Full Course
Textbook
Author:
Ron Rogerson
Date Added:
04/01/2020
Renewable Energy Living Lab: Exploring Regional and Local Resources
Read the Fine Print
Educational Use
Rating
0.0 stars

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.

Subject:
Applied Science
Ecology
Engineering
Life Science
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
Jessica Noffsinger
Jonathan Knudtsen
Karen Johnson
Mike Mooney
Minal Parekh
Scott Schankweiler
Date Added:
09/18/2014
SQL and Database Management Using Pop Culture
Conditional Remix & Share Permitted
CC BY-NC
Rating
0.0 stars

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.

Subject:
Applied Science
Computer Science
Material Type:
Activity/Lab
Assessment
Full Course
Lecture
Textbook
Author:
Brendan P. Shea
Date Added:
11/22/2023
Scholarly vs. Popular Sources
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating
0.0 stars

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.

Subject:
Arts and Humanities
Life Science
Physical Science
Social Science
Material Type:
Reading
Author:
Simon Lee
Salma Abumeeiz
Date Added:
11/09/2020
Science Primary Literature
Conditional Remix & Share Permitted
CC BY-NC
Rating
0.0 stars

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.

Subject:
Applied Science
Biology
Botany
Chemistry
Ecology
Environmental Science
Forestry and Agriculture
Life Science
Nutrition
Physical Science
Material Type:
Primary Source
Author:
Griffin Engel
Kevin R. Engel
Date Added:
03/23/2022
Senior Research Kick-Off
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating
0.0 stars

This lesson plan was created by Stefanie Green as part of the 2020 NDE ELA OER Project. This Research Kick-Off lesson plan is designed for senior-level students and would most effectively be taught in collaboration between an English teacher and a school librarian. The lesson will take approximately 80 minutes. View the Google Slides presentation here: https://tinyurl.com/y5nvtbfu

Subject:
English Language Arts
Reading Informational Text
Material Type:
Activity/Lab
Author:
Stefanie Green
Date Added:
07/24/2020
State Research
Unrestricted Use
CC BY
Rating
0.0 stars

This project encourages students to delve into database research (this lesson plan uses CultureGrams and TrueFlix, but any database could be substituted).  Students will research a state, find facts and pay attention to syllables and rhythm so that their words fit into the song 12 Days of Christmas written by Frederic Austin.  Students will also search for images with Creative Common licenses as well as learn how to copy, paste, and format images (bring to front, etc).  

Subject:
Social Science
Material Type:
Lesson
Author:
Jenni Egstad
Date Added:
02/11/2021
Sulfur metabolic genes in the human gut microbiome are diverse and associated with colorectal cancer
Unrestricted Use
CC BY
Rating
0.0 stars

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.

Subject:
Biology
Life Science
Material Type:
Diagram/Illustration
Reading
Provider:
Research Square
Provider Set:
Video Bytes
Date Added:
05/18/2022