Pathways, Potholes, and the Persistence of Women in Science

Download Pathways, Potholes, and the Persistence of Women in Science PDF Online Free

Author :
Publisher : Lexington Books
ISBN 13 : 1498516378
Total Pages : 279 pages
Book Rating : 4.4/5 (985 download)

DOWNLOAD NOW!


Book Synopsis Pathways, Potholes, and the Persistence of Women in Science by : Enobong Hannah Branch

Download or read book Pathways, Potholes, and the Persistence of Women in Science written by Enobong Hannah Branch and published by Lexington Books. This book was released on 2016-05-16 with total page 279 pages. Available in PDF, EPUB and Kindle. Book excerpt: Training for and pursuing a career in science can be treacherous for women; many more begin than ultimately complete at every stage. Characterizing this as a pipeline problem, however, leads to a focus on individual women instead of structural conditions. The goal of the book is to offer an alternative model that better articulates the ideas of agency, constraint, and variability along the path to scientific careers for women. The chapters in this volume apply the metaphor of the road to a variety of fields and moments that are characterized as exits, pathways, and potholes. The scholars featured in this volume engaged purposefully in translation of sociological scholarship on gender, work, and organizations. They focus on the themes that emerge from their scholarship that add to or build on our existing knowledge of scientific work, while identifying tools as well as challenges to diversifying science. This book contains a multitude of insights about navigating the road while training for and building a career in science. Collectively, the chapters exemplify the utility of this approach, provide useful tools, and suggest areas of exploration for those aiming to broaden the participation of women and minorities. Although this book focuses on gendered constraints, we are attentive to fact that gender intersects with other identities, such as race/ethnicity and nativity, both of which influence participation in science. Several chapters in the volume speak clearly to the experience of underrepresented minorities in science and others consider the circumstances and integration of non-U.S. born scientists, referred to in this volume as international scientists. Disaggregating gender deepens our understanding and illustrates how identity shapes the contours of the scientific road.

Routledge Handbook of the Archaeology of Indigenous-Colonial Interaction in the Americas

Download Routledge Handbook of the Archaeology of Indigenous-Colonial Interaction in the Americas PDF Online Free

Author :
Publisher : Routledge
ISBN 13 : 1000403610
Total Pages : 697 pages
Book Rating : 4.0/5 (4 download)

DOWNLOAD NOW!


Book Synopsis Routledge Handbook of the Archaeology of Indigenous-Colonial Interaction in the Americas by : Lee M. Panich

Download or read book Routledge Handbook of the Archaeology of Indigenous-Colonial Interaction in the Americas written by Lee M. Panich and published by Routledge. This book was released on 2021-07-19 with total page 697 pages. Available in PDF, EPUB and Kindle. Book excerpt: The Routledge Handbook of the Archaeology of Indigenous-Colonial Interaction in the Americas brings together scholars from across the hemisphere to examine how archaeology can highlight the myriad ways that Indigenous people have negotiated colonial systems from the fifteenth century through to today. The contributions offer a comprehensive look at where the archaeology of colonialism has been and where it is heading. Geographically diverse case studies highlight longstanding theoretical and methodological issues as well as emerging topics in the field. The organization of chapters by key issues and topics, rather than by geography, fosters exploration of the commonalities and contrasts between historical contingencies and scholarly interpretations. Throughout the volume, Indigenous and non-Indigenous contributors grapple with the continued colonial nature of archaeology and highlight Native perspectives on the potential of using archaeology to remember and tell colonial histories. This volume is the ideal starting point for students interested in how archaeology can illuminate Indigenous agency in colonial settings. Professionals, including academic and cultural resource management archaeologists, will find it a convenient reference for a range of topics related to the archaeology of colonialism in the Americas.

Retention, Persistence, and Writing Programs

Download Retention, Persistence, and Writing Programs PDF Online Free

Author :
Publisher : University Press of Colorado
ISBN 13 : 1607326027
Total Pages : 287 pages
Book Rating : 4.6/5 (73 download)

DOWNLOAD NOW!


Book Synopsis Retention, Persistence, and Writing Programs by : Todd Ruecker

Download or read book Retention, Persistence, and Writing Programs written by Todd Ruecker and published by University Press of Colorado. This book was released on 2017-04-01 with total page 287 pages. Available in PDF, EPUB and Kindle. Book excerpt: From scholars working in a variety of institutional and geographic contexts and with a wide range of student populations, Retention, Persistence, and Writing Programs offers perspectives on how writing programs can support or hinder students’ transitions to college. The contributors present individual and program case studies, student surveys, a wealth of institutional retention data, and critical policy analysis. Rates of student retention in higher education are a widely acknowledged problem: although approximately 66 percent of high school graduates begin college, of those who attend public four-year institutions, only about 80 percent return the following year, with 58 percent graduating within six years. At public two-year institutions, only 60 percent of students return, and fewer than a third graduate within three years. Less commonly known is the crucial effect of writing courses on these statistics. First-year writing is a course that virtually all students have to take; thus, writing programs are well-positioned to contribute to larger institutional conversations regarding retention and persistence and should offer themselves as much-needed sites for advocacy, research, and curricular innovation. Retention, Persistence, and Writing Programs is a timely resource for writing program administrators as well as for new writing teachers, advisors, administrators, and state boards of education. Contributors: Matthew Bridgewater, ​Cristine Busser, Beth Buyserie, Polina Chemishanova, ​Michael Day, ​Bruce Feinstein, ​Patricia Freitag Ericsson, ​Nathan Garrett, ​Joanne Baird Giordano, ​Tawanda Gipson, ​Sarah E. Harris, Mark Hartlaub, ​Holly Hassel, ​Jennifer Heinert, ​Ashley J. Holmes, ​Rita Malenczyk, ​Christopher P. Parker, ​Cassandra Phillips, ​Anna Plemons, ​Pegeen Reichert Powell, ​Marc Scott, Robin Snead, ​Sarah Elizabeth Snyder, ​Sara Webb-Sunderhaus, ​Susan Wolff Murphy

Narratives of Persistence

Download Narratives of Persistence PDF Online Free

Author :
Publisher : University of Arizona Press
ISBN 13 : 0816543224
Total Pages : 241 pages
Book Rating : 4.8/5 (165 download)

DOWNLOAD NOW!


Book Synopsis Narratives of Persistence by : Lee Panich

Download or read book Narratives of Persistence written by Lee Panich and published by University of Arizona Press. This book was released on 2021-04-13 with total page 241 pages. Available in PDF, EPUB and Kindle. Book excerpt: Narratives of Persistence charts the remarkable persistence of California's Ohlone and Paipai people over the past five centuries. Lee M. Panich draws connections between the events and processes of the deeper past and the way the Ohlone and Paipai today understand their own histories and identities.

Redesigning America’s Community Colleges

Download Redesigning America’s Community Colleges PDF Online Free

Author :
Publisher : Harvard University Press
ISBN 13 : 0674368282
Total Pages : 301 pages
Book Rating : 4.6/5 (743 download)

DOWNLOAD NOW!


Book Synopsis Redesigning America’s Community Colleges by : Thomas R. Bailey

Download or read book Redesigning America’s Community Colleges written by Thomas R. Bailey and published by Harvard University Press. This book was released on 2015-04-09 with total page 301 pages. Available in PDF, EPUB and Kindle. Book excerpt: In the United States, 1,200 community colleges enroll over ten million students each year—nearly half of the nation’s undergraduates. Yet fewer than 40 percent of entrants complete an undergraduate degree within six years. This fact has put pressure on community colleges to improve academic outcomes for their students. Redesigning America’s Community Colleges is a concise, evidence-based guide for educational leaders whose institutions typically receive short shrift in academic and policy discussions. It makes a compelling case that two-year colleges can substantially increase their rates of student success, if they are willing to rethink the ways in which they organize programs of study, support services, and instruction. Community colleges were originally designed to expand college enrollments at low cost, not to maximize completion of high-quality programs of study. The result was a cafeteria-style model in which students pick courses from a bewildering array of choices, with little guidance. The authors urge administrators and faculty to reject this traditional model in favor of “guided pathways”—clearer, more educationally coherent programs of study that simplify students’ choices without limiting their options and that enable them to complete credentials and advance to further education and the labor market more quickly and at less cost. Distilling a wealth of data amassed from the Community College Research Center (Teachers College, Columbia University), Redesigning America’s Community Colleges offers a fundamental redesign of the way two-year colleges operate, stressing the integration of services and instruction into more clearly structured programs of study that support every student’s goals.

The State of College Access and Completion

Download The State of College Access and Completion PDF Online Free

Author :
Publisher : Routledge
ISBN 13 : 1135106703
Total Pages : 253 pages
Book Rating : 4.1/5 (351 download)

DOWNLOAD NOW!


Book Synopsis The State of College Access and Completion by : Laura W. Perna

Download or read book The State of College Access and Completion written by Laura W. Perna and published by Routledge. This book was released on 2013-07-18 with total page 253 pages. Available in PDF, EPUB and Kindle. Book excerpt: Despite decades of substantial investments by the federal government, state governments, colleges and universities, and private foundations, students from low-income families as well as racial and ethnic minority groups continue to have substantially lower levels of postsecondary educational attainment than individuals from other groups. The State of College Access and Completion draws together leading researchers nationwide to summarize the state of college access and success and to provide recommendations for how institutional leaders and policymakers can effectively improve the entire spectrum of college access and completion. Springboarding from a seminar series organized by the Advisory Committee on Student Financial Assistance, chapter authors explore what is known and not known from existing research about how to improve student success. This much-needed book calls explicit attention to the state of college access and success not only for traditional college-age students, but also for the substantial and growing number of "nontraditional" students. Describing trends in various outcomes along the pathway from college access to completion, this volume documents persisting gaps in outcomes based on students’ demographic characteristics and offers recommendations for strategies to raise student attainment. Graduate students, scholars, and researchers in higher education will find The State of College Access and Completion to be an important and timely resource.

Pathways for Peace

Download Pathways for Peace PDF Online Free

Author :
Publisher : World Bank Publications
ISBN 13 : 1464811865
Total Pages : 415 pages
Book Rating : 4.4/5 (648 download)

DOWNLOAD NOW!


Book Synopsis Pathways for Peace by : United Nations;World Bank

Download or read book Pathways for Peace written by United Nations;World Bank and published by World Bank Publications. This book was released on 2018-04-13 with total page 415 pages. Available in PDF, EPUB and Kindle. Book excerpt: Violent conflicts today are complex and increasingly protracted, involving more nonstate groups and regional and international actors. It is estimated that by 2030—the horizon set by the international community for achieving the Sustainable Development Goals—more than half of the world’s poor will be living in countries affected by high levels of violence. Information and communication technology, population movements, and climate change are also creating shared risks that must be managed at both national and international levels. Pathways for Peace is a joint United Nations†“World Bank Group study that originates from the conviction that the international community’s attention must urgently be refocused on prevention. A scaled-up system for preventive action would save between US$5 billion and US$70 billion per year, which could be reinvested in reducing poverty and improving the well-being of populations. The study aims to improve the way in which domestic development processes interact with security, diplomacy, mediation, and other efforts to prevent conflicts from becoming violent. It stresses the importance of grievances related to exclusion—from access to power, natural resources, security and justice, for example—that are at the root of many violent conflicts today. Based on a review of cases in which prevention has been successful, the study makes recommendations for countries facing emerging risks of violent conflict as well as for the international community. Development policies and programs must be a core part of preventive efforts; when risks are high or building up, inclusive solutions through dialogue, adapted macroeconomic policies, institutional reform, and redistributive policies are required. Inclusion is key, and preventive action needs to adopt a more people-centered approach that includes mainstreaming citizen engagement. Enhancing the participation of women and youth in decision making is fundamental to sustaining peace, as well as long-term policies to address the aspirations of women and young people.

Desistance from Crime

Download Desistance from Crime PDF Online Free

Author :
Publisher : Springer
ISBN 13 : 1137572345
Total Pages : 279 pages
Book Rating : 4.1/5 (375 download)

DOWNLOAD NOW!


Book Synopsis Desistance from Crime by : Michael Rocque

Download or read book Desistance from Crime written by Michael Rocque and published by Springer. This book was released on 2017-04-25 with total page 279 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book represents a brief treatise on the theory and research behind the concept of desistance from crime. This ever-growing field has become increasingly relevant as questions of serious issues regarding sentencing, probation and the penal system continue to go unanswered. Rocque covers the history of research on desistance from crime and provides a discussion of research and theories on the topic before looking towards the future of the application of desistance to policy. The focus of the volume is to provide an overview of the practical and theoretical developments to better understand desistance. In addition, a multidisciplinary, integrative theoretical perspective is presented, ensuring that it will be of particular interest for students and scholars of criminology and the criminal justice system.

PISA Pathways to Success How Knowledge and Skills at Age 15 Shape Future Lives in Canada

Download PISA Pathways to Success How Knowledge and Skills at Age 15 Shape Future Lives in Canada PDF Online Free

Author :
Publisher : OECD Publishing
ISBN 13 : 9264081925
Total Pages : 130 pages
Book Rating : 4.2/5 (64 download)

DOWNLOAD NOW!


Book Synopsis PISA Pathways to Success How Knowledge and Skills at Age 15 Shape Future Lives in Canada by : OECD

Download or read book PISA Pathways to Success How Knowledge and Skills at Age 15 Shape Future Lives in Canada written by OECD and published by OECD Publishing. This book was released on 2010-03-01 with total page 130 pages. Available in PDF, EPUB and Kindle. Book excerpt: Presents the findings of Canada's Youth in Transition Survey, which complements OECD's PISA survey and offers significant new policy insights in understanding students’ choices at different ages and the impact of these decisions on consequent education and labour market outcomes.

Educating a Diverse Nation

Download Educating a Diverse Nation PDF Online Free

Author :
Publisher : Harvard University Press
ISBN 13 : 0674425499
Total Pages : 312 pages
Book Rating : 4.6/5 (744 download)

DOWNLOAD NOW!


Book Synopsis Educating a Diverse Nation by : Clifton Conrad

Download or read book Educating a Diverse Nation written by Clifton Conrad and published by Harvard University Press. This book was released on 2015-03-09 with total page 312 pages. Available in PDF, EPUB and Kindle. Book excerpt: In an increasingly diverse United States, minority and low-income students of all ages struggle to fit into mainstream colleges and universities that cater predominantly to middle-income and affluent white students fresh out of high school. Anchored in a study conducted at twelve minority-serving institutions (MSIs), Educating a Diverse Nation turns a spotlight on the challenges facing nontraditional college students and highlights innovative programs and practices that are advancing students’ persistence and learning. Clifton Conrad and Marybeth Gasman offer an on-the-ground perspective of life at MSIs. Speaking for themselves, some students describe the stress of balancing tuition with the need to support families. Others express their concerns about not being adequately prepared for college-level work. And more than a few reveal doubts about the relevance of college for their future. The authors visited the four main types of MSIs—historically black colleges and universities, tribal colleges and universities, Hispanic-serving institutions, and Asian American and Native American Pacific Islander–serving institutions—to identify strategies for empowering nontraditional students to succeed in college despite these obstacles. Educating a Diverse Nation illuminates such initiatives as collaborative learning, culturally relevant educational programs, blurring the roles of faculty, staff, and students, peer-led team learning, and real-world problem solving. It shows how these innovations engage students and foster the knowledge, skills, and habits they need to become self-sustaining in college and beyond, as well as valuable contributors to society.

Terrestrial Ecosystems in a Changing World

Download Terrestrial Ecosystems in a Changing World PDF Online Free

Author :
Publisher : Springer Science & Business Media
ISBN 13 : 3540327304
Total Pages : 344 pages
Book Rating : 4.5/5 (43 download)

DOWNLOAD NOW!


Book Synopsis Terrestrial Ecosystems in a Changing World by : Josep G. Canadell

Download or read book Terrestrial Ecosystems in a Changing World written by Josep G. Canadell and published by Springer Science & Business Media. This book was released on 2007-01-10 with total page 344 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book examines the impacts of global change on terrestrial ecosystems. Emphasis is placed on impacts of atmospheric, climate and land use change, and the book discusses the future challenges and the scientific frameworks to address them. Finally, the book explores fundamental new research developments and the need for stronger integration of natural and human dimensions in addressing the challenge of global change.

Communities in Action

Download Communities in Action PDF Online Free

Author :
Publisher : National Academies Press
ISBN 13 : 0309452961
Total Pages : 583 pages
Book Rating : 4.3/5 (94 download)

DOWNLOAD NOW!


Book Synopsis Communities in Action by : National Academies of Sciences, Engineering, and Medicine

Download or read book Communities in Action written by National Academies of Sciences, Engineering, and Medicine and published by National Academies Press. This book was released on 2017-04-27 with total page 583 pages. Available in PDF, EPUB and Kindle. Book excerpt: In the United States, some populations suffer from far greater disparities in health than others. Those disparities are caused not only by fundamental differences in health status across segments of the population, but also because of inequities in factors that impact health status, so-called determinants of health. Only part of an individual's health status depends on his or her behavior and choice; community-wide problems like poverty, unemployment, poor education, inadequate housing, poor public transportation, interpersonal violence, and decaying neighborhoods also contribute to health inequities, as well as the historic and ongoing interplay of structures, policies, and norms that shape lives. When these factors are not optimal in a community, it does not mean they are intractable: such inequities can be mitigated by social policies that can shape health in powerful ways. Communities in Action: Pathways to Health Equity seeks to delineate the causes of and the solutions to health inequities in the United States. This report focuses on what communities can do to promote health equity, what actions are needed by the many and varied stakeholders that are part of communities or support them, as well as the root causes and structural barriers that need to be overcome.

Biodegradation and Persistence

Download Biodegradation and Persistence PDF Online Free

Author :
Publisher : Springer
ISBN 13 : 3540680969
Total Pages : 338 pages
Book Rating : 4.5/5 (46 download)

DOWNLOAD NOW!


Book Synopsis Biodegradation and Persistence by : B. Beek

Download or read book Biodegradation and Persistence written by B. Beek and published by Springer. This book was released on 2005-09-06 with total page 338 pages. Available in PDF, EPUB and Kindle. Book excerpt: Biodegradation is a key phenomen among environmental processes. Low degradation rates lead to the persistence of chemicals in the environment and, as a consequence, to delayed or long-term effects, which may be even unknown by now. In this volume the editor has pulled together the newest results of research in biodegradation and persistence of potential environmentally harmful substances and the complex process involved. The main focus is on the microbial degradation, the evolution and predictability of the respective pathways and their impact on bioremediation. Additional chapters deal with sewage treatment plants, the impact of toxicants on impaired biodegradation, and with the need of a more realistic view on fate and behaviour of chemicals in the environment.

New Developments in Pathways Towards Diversity and Inclusion in STEM: A United States Perspective

Download New Developments in Pathways Towards Diversity and Inclusion in STEM: A United States Perspective PDF Online Free

Author :
Publisher : Frontiers Media SA
ISBN 13 : 2832505813
Total Pages : 273 pages
Book Rating : 4.8/5 (325 download)

DOWNLOAD NOW!


Book Synopsis New Developments in Pathways Towards Diversity and Inclusion in STEM: A United States Perspective by : Alexander Gates

Download or read book New Developments in Pathways Towards Diversity and Inclusion in STEM: A United States Perspective written by Alexander Gates and published by Frontiers Media SA. This book was released on 2022-10-17 with total page 273 pages. Available in PDF, EPUB and Kindle. Book excerpt: The Louis Stokes Alliances for Minority Participation (LSAMP) program of the US National Science Foundation has been a primary force for raising the success and graduation of minority students in STEM for 30 years. Increasing the number of underrepresented students earning baccalaureate degrees, and entering graduate school in STEM is the goal of LSAMP. This goal has been nearly achieved through the formation of alliances of degree granting institutions of higher learning, varying from community colleges to major research institutions. Currently there are 59 alliances including more than 400 institutions. LSAMP is responsible for more than 650,000 bachelor’s degrees earned by minority students in STEM. The papers for this Research Topic should focus on the use of LSAMP activities, programs and collaborations to develop pathways to success and graduation of STEM majors from minority groups that underrepresented in STEM. These pathways can include any segment from pre-college through graduate school. Areas of special interest include mentoring, research experiences, transitions between levels and novel approaches for retention. The studies should be research based and rigorous. They can be pure research studies, curriculum and design or literature reviews but they must be at a cutting edge level and be subject to detailed review and assessment.

Learning with Others

Download Learning with Others PDF Online Free

Author :
Publisher : JHU Press
ISBN 13 : 142144352X
Total Pages : 143 pages
Book Rating : 4.4/5 (214 download)

DOWNLOAD NOW!


Book Synopsis Learning with Others by : Clifton Conrad

Download or read book Learning with Others written by Clifton Conrad and published by JHU Press. This book was released on 2022-03-15 with total page 143 pages. Available in PDF, EPUB and Kindle. Book excerpt: How can colleges and universities engage students in ways that prepare them to solve problems in our rapidly changing world? Most American colleges and universities assimilate students into highly competitive undergraduate experiences. By placing achievement for personal and material gain as the bedrock of a college education, these institutions fail to educate students to become collaborative learners: people who are committed and prepared to join with others in developing promising solutions to problems that they share with others. Drawing on a three-year study of student persistence and learning at Minority-Serving Institutions, Clifton Conrad and Todd Lundberg argue that student success in college should be redefined by focusing on the importance of collaborative learning over individual achievement. Engaging students in shared, real-world problem-solving, Conrad and Lundberg assert, will encourage them to embrace interdependence and to value and draw on diverse perspectives. Learning with Others presents a set of core practices to empower students to enter, nourish, and sustain collaborative learning and outlines how to blend the roles and responsibilities of faculty, staff, and students; how to adopt best practices for receiving and giving feedback on problem-solving; and how to anchor a curriculum in shared problem-solving. Bringing together lessons learned from more than 300 interviews, along with notes from 14 campus visits, 3 national convenings, and examples from across our nation's colleges and universities, Conrad and Lundberg explore ways in which successful antiracist networks of problem-solvers are learning to contribute to the flourishing of their communities on campus and far beyond. Outlining strategies for identifying and dismantling barriers to participation, Learning with Others will pique interest among faculty, students, and administrators in higher education and a wide range of external stakeholders—from families and communities to policymakers and funders.

Science Teaching Reconsidered

Download Science Teaching Reconsidered PDF Online Free

Author :
Publisher : National Academies Press
ISBN 13 : 0309175445
Total Pages : 102 pages
Book Rating : 4.3/5 (91 download)

DOWNLOAD NOW!


Book Synopsis Science Teaching Reconsidered by : National Research Council

Download or read book Science Teaching Reconsidered written by National Research Council and published by National Academies Press. This book was released on 1997-03-12 with total page 102 pages. Available in PDF, EPUB and Kindle. Book excerpt: Effective science teaching requires creativity, imagination, and innovation. In light of concerns about American science literacy, scientists and educators have struggled to teach this discipline more effectively. Science Teaching Reconsidered provides undergraduate science educators with a path to understanding students, accommodating their individual differences, and helping them grasp the methodsâ€"and the wonderâ€"of science. What impact does teaching style have? How do I plan a course curriculum? How do I make lectures, classes, and laboratories more effective? How can I tell what students are thinking? Why don't they understand? This handbook provides productive approaches to these and other questions. Written by scientists who are also educators, the handbook offers suggestions for having a greater impact in the classroom and provides resources for further research.

High-Performance Java Persistence

Download High-Performance Java Persistence PDF Online Free

Author :
Publisher : Vlad Mihalcea
ISBN 13 : 9789730228236
Total Pages : pages
Book Rating : 4.2/5 (282 download)

DOWNLOAD NOW!


Book Synopsis High-Performance Java Persistence by : Vlad Mihalcea

Download or read book High-Performance Java Persistence written by Vlad Mihalcea and published by Vlad Mihalcea. This book was released on 2016-10-12 with total page pages. Available in PDF, EPUB and Kindle. Book excerpt: A high-performance data access layer must resonate with the underlying database system. Knowing the inner workings of a relational database and the data access frameworks in use can make the difference between a high-performance enterprise application and one that barely crawls. This book is a journey into Java data access performance tuning. From connection management, to batch updates, fetch sizes and concurrency control mechanisms, it unravels the inner workings of the most common Java data access frameworks. The first part aims to reduce the gap between application developers and database administrators. For this reason, it covers both JDBC and the database fundamentals that are of paramount importance when reducing transaction response times. In this first part, you'll learn about connection management, batch updates, statement caching, result set fetching and database transactions. The second part demonstrates how you can take advantage of JPA and Hibernate without compromising application performance. In this second part, you'll learn about the most efficient Hibernate mappings (basic types, associations, inheritance), fetching best practices, caching and concurrency control mechanisms. The third part is dedicated to jOOQ and its powerful type-safe querying capabilities, like window functions, common table expressions, upsert, stored procedures and database functions.