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

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