Shell Scripting: How to Automate Command Line Tasks Using Bash Scripting and Shell Programming

 Shell Scripting: How to Automate Command Line Tasks Using Bash Scripting and Shell Programming by Jason Cannon.

 

I highly recommend to new and seasoned bash programmers. Notes: http://shine-notes.blogspot.com/2021/09/bash-notes.html

 

SQL in 10 Minutes a Day, Sams Teach Yourself by Ben Forta

 Its a good SQL book for beginners. I primarily was focusing on query commands. And skipped chapters dealing with mutating tables and advanced topics.

Sample query:
SELECT col1, col2, count(*) FROM table_name WHERE <conditions> GROUP BY <col> HAVING <conditions> ORDER BY <col>;
SELECT col1, col2 FROM table_name_1 t1 JOIN table_name_2 t2 ON t1.eniid = t2.eniid WHERE t1.id=‘ID’;

Chapters include Retrieving data, Sorting Retrieved Data, Filtering Data, Advanced Data Filtering, Using Wildcard Filtering, Creating Calculated Fields, Using Data Manipulation Functions, Summarizing Data, Grouping Data, Working with Subqueries, Joining Tables, Creating Advanced Joins, Combining Queries, more changes which deal with create, update and delete and other advance Topics.

Malgudi Days by R K Narayan

 This is a collection of short stories from the renowned storyteller, R K Narayan. The stories were taken place in Malgudy, an imaginary town set in south India. Each story is beautifully told and the characters include astrologer, postman, doctor, gateman, dog, set in train travel, sculptor, snake man and many more. There are around 30+ stories and it will be a good idea to read one story each night.

Installing Magzter app on Amazon Fire 10

Step 1: Install google play store - refer https://www.androidpolice.com/2020/10/03/install-play-store-amazon-fire-tablet/

Step 2: Install Magzter from play store

You are all set to go!!

TCP/IP Illustrated, Volume 1 by Kevin Fall and Richard Stevens

 The book covers layer 2 to layer 4 of networking layer. That is IP, IPv6, ICMP, UDP and TCP. Apart from that, the book also covers ARP, DHCP, DNS, NAT and various security protocols. The main highlight of this work is that it illustrates the protocol using a custom udp/tcp socket program, tcpdump, tcptrace and wire shark.

I skimmed through layer 3 and security protocol sections. UDP and TCP sections are very thorough and gives a good insight into the working of this protocol.

There are 6 chapters dealing with TCP - Preliminaries; Connection Management; time-out and retransmission; data flow and window management; congestion control; and keepalive.

Overall I enjoyed reading this book and would recommend to anyone who want to understand the internals of layer 4 networking protocol!