My Account Log in

1 option

SQL and NoSQL interview questions : your essential guide to acing SQL and NoSQL job interviews / Vishwanathan Narayanan.

Ebook Central College Complete Available online

Ebook Central College Complete
Format:
Book
Author/Creator:
Narayanan, Vishwanathan, author.
Language:
English
Subjects (All):
Databases.
Information technology.
SQL (Computer program language).
Physical Description:
1 online resource (180 pages)
Edition:
First edition, English edition.
Place of Publication:
London, England : BPB Online, [2023]
Summary:
This book, authored by Vishwanathan Narayanan, is a comprehensive guide designed to prepare individuals for SQL and NoSQL job interviews. It covers a wide range of interview questions related to both relational databases and various NoSQL technologies such as MongoDB, Cassandra, Redis, HBase, Elasticsearch, and Neo4j. The book aims to provide candidates with a last-minute revision resource, catering to individuals with varying levels of experience. By addressing fundamental concepts, differences, and practical applications of these technologies, the book serves as a valuable tool for those seeking careers in software development and database management. Generated by AI.
Contents:
Book title
Copyright
Dedicated
About the Authors
About the Reviewer
Acknowledgements
Preface
Code Bundle and Coloured Images
Piracy
Table of Contents
Chapter 1: Relational Database
Introduction
Structure
Objectives
Basic questions on a Database system
Structured Query Language (SQL) questions
Oracle interview questions
MYSQL DB Questions
Conclusion
Chapter 2: NoSQL
Introduction to NoSQL
Types of NoSQL databases
Databases for NoSQL
NoSQL working basics
Chapter 3: MongoDB
Introduction to MongoDB
Mongo architecture
Shards
Config servers
Query Routers
Data model
Database
Collection
Document
Index
Embedded
Normalized
Datatypes and query language support
Replication
Object ID and advanced queries
Advanced MongoDB tools
Chapter 4: Cassandra
History of Cassandra
Architecture and design principle
What is Cassandra?
Features offered by Cassandra
The physical architecture of Cassandra
Logical architecture of Cassandra
Important terms in Cassandra
Design questions in Cassandra
Partitioning and tokens
Keyspace and tables
Protocols used in Cassandra/internal working
Chapter 5: Redis
Introduction to Redis
Data types and working
Commands in Redis
Chapter 6: HBase
Introduction to HBase
Tombstone
HBase configuration and consistency
Data operations
Debugging
Difference between HBase and other technologies
Chapter 7: Elasticsearch
Objectives.
Introduction to Elasticsearch
Elasticsearch Logstash and Kibana
Operations
Query support
Connectors and indices
Chapter 8: Neo4j
Introduction to Neo4j
Neo4j commands
Applications and internal working
Advanced working
Back title.
Notes:
Description based on publisher supplied metadata and other sources.
Part of the metadata in this record was created by AI, based on the text of the resource.
Description based on print version record.
ISBN:
9789355518583
9355518587
9789355518606
9355518609
OCLC:
1389610909

The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.

We want your feedback!

Thanks for using the Penn Libraries new search tool. We encourage you to submit feedback as we continue to improve the site.

My Account

Shelf Request an item Bookmarks Fines and fees Settings

Guides

Using the Library Catalog Using Articles+ Library Account