SQL Query Design Patterns and Best Practices - A practical guide to writing readable and maintainable SQL queries using its design patterns

Steve Hughes, Chi Zhang, Dennis Neer, Dr. Ram Babu Singh, Shabbir H. Mala, Leslie Andrews

Sinopse

SQL has been the de facto standard when interacting with databases for decades and shows no signs of going away. Through the years, report developers or data wranglers have had to learn SQL on the fly to meet the business needs, so if you are someone who needs to write queries, SQL Query Design and Pattern Best Practices is for you.
This book will guide you through making efficient SQL queries by reducing set sizes for effective results. You’ll learn how to format your results to make them easier to consume at their destination. From there, the book will take you through solving complex business problems using more advanced techniques, such as common table expressions and window functions, and advance to uncovering issues resulting from security in the underlying dataset. Armed with this knowledge, you’ll have a foundation for building queries and be ready to shift focus to using tools, such as query plans and indexes, to optimize those queries. The book will go over the modern data estate, which includes data lakes and JSON data, and wrap up with a brief on how to use Jupyter notebooks in your SQL journey.
By the end of this SQL book, you’ll be able to make efficient SQL queries that will improve your report writing and the overall SQL experience.

Disponível desde: 31/03/2023.

Comprimento de impressão: 270 páginas.

Ciência e Tecnologia

Outros livros que poderiam interessá-lo

ISRO - The Space Leader

Akshat Kesarwani

ISRO: The Space Leader is a powerful and inspiring audiobook that takes you through the extraordinary journey of India’s space agency — the Indian Space Research Organisation. From launching its first rocket from a small church in Kerala to making history with Chandrayaan and Mangalyaan, ISRO’s story is one of determination, innovation, and national pride. 
Written in simple, engaging language, this audiobook dives deep into:The visionary leadership of Dr. Vikram Sarabhai and pioneers like Dr. A.P.J. Abdul KalamISRO’s major milestones — Aryabhata, SLV-3, PSLV, GSLV, Chandrayaan, Mangalyaan, and moreBehind-the-scenes stories of failure, perseverance, and ultimate triumphFuture missions like Gaganyaan, Aditya-L1, and ShukrayaanThe transformation of ISRO into a global leader in affordable and effective space technology 
Whether you’re a space enthusiast, student, or just curious about India’s scientific achievements, this audiobook will not only educate but inspire. Each chapter brings to life the real challenges, the unsung heroes, and the scientific brilliance that placed India among the world’s top spacefaring nations. 
Join author Akshat Kesarwani on a journey through one of the most remarkable success stories in science and space history. Perfect for young minds, curious listeners, and anyone who believes that no dream is too big — not even the sky.

Ver livro

Systemic - How Racism Is Making...

Layal Liverpool

Layal Liverpool spent years bouncing from doctor to doctor, each one failing to diagnose her dermatological complaint. Just when she'd grown used to the idea that she had an extremely rare and untreatable skin condition, one dermatologist, after a quick exam, told her that she had a classic (and common) case of eczema and explained that it often appears differently on darker skin. Her experience stuck with her, making her wonder whether other medical conditions might be going undiagnosed in darker-skinned people and whether racism could, in fact, make people sick. 
 
 
 
The pandemic taught us that diseases like Covid disproportionately affect people of color. Here, Liverpool goes a step further to show that this disparity exists for all types of illness and that it is caused by racism. In Systemic, she shares her journey to show how racism, woven into our societies, as well as into the structures of medicine and science, is harmful to our health. Refuting the false belief that there are biological differences between races, she goes on to show that racism-related stress and trauma can however, lead to biological changes that make people of color more vulnerable to illness, debunking the myth of illness as the great equalizer. Liverpool reveals the fatal stereotypes that keep people of color undiagnosed, untreated, and unsafe, and tells us what we can do about it.

Ver livro

Artificial Intelligence Class 5

Geeta Zunjani

Touchpad Artificial Intelligence series has some salient features such as AI Reboot, AI Deep Thinking,
AI in Life, AI Lab and AI Ready which ensures that NEP 2020 guidelines are followed.

KEY FEATURES
- National Education Policy 2020
- AI Game: It contains an interesting game or activity for the students to try on their own or with their classmates to learn how the game mechanics work while having fun.
- Brainy Fact: It presents an interesting fact relevant to the topic or the chapters.
- AI in Life: It presents questions that promotes the moral growth and experiential learning.
- AI Deep Thinking: It presents a question/scenario in which the students are required to think deeply and apply their knowledge.
- Digital Solutions

DESCRIPTION
Artificial Intelligence is the most talked about subject and we all understand that the future lies in knowing it well. The Touchpad AI series is written for classes I to VII keeping in mind about the future and scope that lies in AI. Classes VIII to XII are strictly based on CBSE curriculum. They have competency-based questions to ensure that students are capable of applying their learning to solve some real-life challenges. The knowledge is spread in a phased manner so that at no age the kid finds it difficult to understand the theory.

Each lesson begins with a short conversation between human characters and one humanoid which tries to explain in simple words about the topics related to Artificial Intelligence. The story is built up in such a way that the curiosity of the reader compels to read the entire lesson. The idea behind introducing humanoid is to touch the hearts of our kids with the existence of friendly robots in the form of humanoids.

Touchpad Artificial Intelligence series has some salient features such as AI Reboot, AI Deep Thinking, AI in Life, AI Lab and AI Ready which ensures that NEP 2020 guidelines are followed.

There are plenty of Video Sessions for students and teachers to go beyond the syllabus and enrich their knowledge. There are some brainstorming questions in the form of AI Task in between the topics to ensure that students give pause to their learning and use their skills to reach to some creative ideas in solving given problems.

I would like to humbly acknowledge the support provided by my family, friends and Orange Education Pvt Ltd team to accomplish this noble task. I am sure that this book will prove to be a tool in making the students future ready for Artificial Intelligence. Wishing learners great success in future endeavours. Enjoy the journey of happy learning!! All your feedbacks and suggestions will always be wholeheartedly welcomed to improve and grow.

WHAT WILL YOU LEARN
You will learn about:
- Human-Machine Interaction
- Introduction to AI
- AI in Apps
- Types of Robots
- Myths and Facts of AI

WHO THIS BOOK IS FOR
Grade 5

TABLE OF CONTENTS

1. Evolution of AI
a) Developments in A

2. AI-Terminologies
a) Artificial Intelligence
b) Aims of AI
c) AI-Terminologies

3. AI in Popular Apps
a) Siri
b) Cortana
c) Google Assistant
d) Alexa
e) Practo
f) Google Maps
g) Swiggy
h) YouTube
i) Netflix
Test Sheet 1

4. Sustainable Development Goals (SDGs)
a) What are Sustainable Development Goals (SDGs)?
b) Role of AI to Achieve SDGs

5. Parts of Robots
a) Difference Between Humans and Robots
b) Essential Parts of Robots
Test Sheet 2

Ver livro

Angel in a Thorn Bush

Rob Fynn

This is a story of a Marungu, as the white tribe is termed by the Shona, who’s ancestry go back in Africa six generations, brought up in Rhodesia, then left in 1964 at 18 yrs old to join the Queen’s Royal Navy. He was asked to leave when UDI was declared, Ian Smith’s Unilateral Declaration of Independence, when all Rhodesians in the British armed forces were now regarded as potential rebels by Harold Wilson’s government of the day. After pursuing his engineering degree at Bristol University, he finally returned driving across the African continent in a Land Rover, which led him into starting up a safari operation on Fothergill Island on Lake Kariba, bringing up his family through those turbulent years of the ‘70’s. His name is Rob Fynn

Ver livro

The Physics of Consciousness -...

Ivan Antic

What if consciousness came first?
Not as an idea inside the brain. Not as a side effect of matter. But as the field in which matter, life, identity, and the soul appear.
The Physics of Consciousness explores one of the deep questions a human being can ask:
Who am I, really?
Are you only a body moving through time—or the awareness in which body, thought, memory, and the world itself are known?
Ivan Antic presents a vision in which consciousness is not the final product of evolution, but the foundation of existence.
From the quantum field to minerals, plants, animals, and human souls, this audiobook follows one insight: consciousness and existence are not separate. They are one reality seen from two sides.
Modern physics has challenged the image of matter as solid and separate. Ancient wisdom traditions have pointed toward a deeper unity behind the visible world.
What if these two paths are not opposed? What if matter does not produce consciousness—but appears within it?
Drawing on quantum physics, metaphysical insight, and decades of Buddhist and Zen practice, Ivan Antic offers an inquiry into consciousness, existence, and the soul—from the physical world to self-awareness and the meaning of life.
This is not a conventional audiobook about the brain.
It is for seekers, thinkers, spiritual listeners, and anyone who feels that life cannot be explained by matter and chance alone.
The Physics of Consciousness invites listeners to reconsider matter and mind, body and soul, science and spirituality.
Listen to The Physics of Consciousness and enter a deeper exploration of reality, nature, and the Self.

Ver livro

The Digital Revolution –...

M. Weber

This audiobook is narrated by an AI Voice. 
Imagine a wave rolling toward us – it can carry us to unimagined heights or hit us with full force. That is the digital revolution. It is changing our society, our economy, our lives. But who is shaping it? We are. 
 
This audiobook takes you on a journey through digital transformation – exciting, vivid, with real-life stories. From the beginnings of the internet to the power of AI to the risks of data protection and the digital divide. 
 
An experienced narrator guides you – factual, captivating, with a focus on opportunities and the responsibility of each individual. 
 
What awaits you: 
• The history of the digital revolution – milestones, innovations, pioneers 
• Opportunities: innovation, education, economic growth 
• Risks: data protection, security, digital divide, job loss 
• Artificial intelligence and automation – ethics, work, future 
• Digital sovereignty, ethics, and personal responsibility 
• Digital education and lifelong learning 
• Future visions: 5G, blockchain, AI, sustainability 
 
For everyone who doesn't just want to experience the digital world, but to understand and shape it. For technology enthusiasts, skeptics, and anyone who knows: The future is digital – and it belongs to us.

Ver livro