This course will assess the relationships among sequence, structure, and function in complex biological networks as well as progress in realistic modeling of quantitative, comprehensive, functional genomics analyses. Exercises will include algorithmic, statistical, database, and simulation approaches and practical applications to medicine, biotechnology, drug discovery, and genetic engineering. Future opportunities and current limitations will be critically addressed. In addition to the regular lecture sessions, supplementary sections are scheduled to address issues related to Perl, Mathematica and biology.

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 spread of antibiotic resistance is one of the most pressing threats facing global health. Every year, approximately 700,000 deaths worldwide can be traced to antibiotic resistance. That makes it crucial to identify antibiotic resistance genes (ARGs) and their transmission between humans and the environment. Unfortunately, because they rely on curated databases and are not sensitive to certain mutations, many methods can overlook novel ARGs. Now, a new machine learning method called HMD-ARG could provide researchers with a more powerful alternative. Taking sequence encoding as input, it determines whether an input sequence is an ARG, what antibiotic family the ARG is resistant to, its mechanism of resistance, and whether it is intrinsic or acquired, and even the sub-class of antibiotic the ARG resists, if it happens to be a beta-lactamase, all without querying against existing sequence databases. The HMD-ARG database is the largest of its kind..."

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

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.

Information Technology I helps students understand technical concepts underlying current and future developments in information technology. There will be a special emphasis on networks and distributed computing. Students will also gain some hands-on exposure to powerful, high-level tools for making computers do amazing things, without the need for conventional programming languages. Since 15.564 is an introductory course, no knowledge of how computers work or are programmed is assumed.

In virtually every industry and every firm, information technology is driving change, creating opportunities and challenges. Leaders who don't understand at least the fundamentals of information systems will be at a strategic disadvantage. This course provides broad coverage of technology concepts and trends underlying current and future developments in information technology, and fundamental principles for the effective use of computer-based information systems. There will be a special emphasis on manufacturing. Information Systems topics that will be covered include networks and distributed computing, including the World Wide Web, hardware and operating systems, software development tools and processes, relational databases, security and cryptography, enterprise applications, B2B, the semantic web and electronic commerce. Sloan LFM students with an interest in Information Systems are encouraged to register for this course.

The strategic importance of information technology is now widely accepted. It has also become increasingly clear that the identification of strategic applications alone does not result in success for an organization. A careful coordination of strategic applications, information technologies, and organizational structures must be made to attain success. This course addresses strategic, technological, and organizational connectivity issues to support effective and meaningful integration of information and systems. This course is especially relevant to those who wish to effectively exploit information technology and create new business processes and opportunities.

Databases are all over the place and we interact with them in various ways. Consider the banking services, supermarkets, mobile operators, airline reservation systems, medical records, student records and even employment records. This course will provide students with a general overview of databases, introducing you to database history, modern database systems, the different models used to design a database, and Structured Query Language (SQL), which is the standard language used to access and manipulate databases. The course is taught as a Topic within the Computer Science degree.

Databases are all over the place and we interact with them in various ways. Consider the banking services, supermarkets, mobile operators, airline reservation systems, medical records, student records and even employment records. This course will provide students with a general overview of databases, introducing you to database history, modern database systems, the different models used to design a database, and Structured Query Language (SQL), which is the standard language used to access and manipulate databases. The course is taught as a Topic within the Computer Science degree.

Databases are all over the place and we interact with them in various ways. Consider the banking services, supermarkets, mobile operators, airline reservation systems, medical records, student records and even employment records. This course will provide students with a general overview of databases, introducing you to database history, modern database systems, the different models used to design a database, and Structured Query Language (SQL), which is the standard language used to access and manipulate databases. The course is taught as a Topic within the Computer Science degree.

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.

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

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.

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.

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 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

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).