shriagnish2021

1.
agnish@agnish-Inspiron-15-3567:~$ cd ~
agnish@agnish-Inspiron-15-3567:~$ mkdir hello
agnish@agnish-Inspiron-15-3567:~$ cd hello
agnish@agnish-Inspiron-15-3567:~/hello$ mkdir five
agnish@agnish-Inspiron-15-3567:~/hello$ mkdir one
agnish@agnish-Inspiron-15-3567:~/hello$ cd five
agnish@agnish-Inspiron-15-3567:~/hello/five$ mkdir six
agnish@agnish-Inspiron-15-3567:~/hello/five$ cd six
agnish@agnish-Inspiron-15-3567:~/hello/five/six$ touch c.txt

shriagnish2021

Pipes

1.Download the contents of "Harry Potter and the Goblet of fire" using the command line from here

wget https://raw.githubusercontent.com/bobdeng/owlreader/master/ERead/assets/books/Harry%20Potter%20and%20the%20Goblet%20of%20Fire.txt

2.Print the first three lines in the book

head -n 3 'Harry Potter and the Goblet of Fire.txt'

shriagnish2021

Introduction To SQL

What is SQL?

SQL stands for Structured Query Language. It is a language used for storing, accessing and manipulating data stored in databases. Relational Database Management systems(RDBMS) like MS SQL Server, MySQL or Oracle are the basis for SQL.

Basics of SQL

Data is stored in the form of tables which consists of rows and columns.
For example, given below is a table called Pets with the below fields.
Each row is called a record.

shriagnish2021

Resources

1. Command line interface

1. https://learnpythonthehardway.org/book/appendixa.html
2. https://www.youtube.com/watch?v=cBokz0LTizk
3. https://www.youtube.com/playlist?list=PLW5y1tjAOzI2ZYTlMdGzCV8AJuoqW5lKB
4. https://www.learnenough.com/command-line-tutorial

2. GIT

1. https://www.youtube.com/watch?v=NcoBAfJ6l2Q
2. https://git-scm.com/book/en/v2