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.
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |