Wj2iZ6qd

1SQL - Structured Query Language  
2is a domain-specific language used in programming and designed for managing data held in  
3RDBMS - relational database management system
4
5```sql
6CREATE DATABASE IF NOT EXISTS test;
7
8USE test;
9
10CREATE TABLE books (
11isbn CHAR(20) PRIMARY KEY, 
12title VARCHAR(50),
13author_id INT,
14publisher_id INT,
15year_pub CHAR(4),
16description TEXT );
17
18DESCRIBE books;
19
20INSERT INTO books
21(title, author_id, isbn, year_pub)
22VALUES('The Castle', '1', '0805211063', '1998');
23
24CREATE TABLE authors
25(author_id INT AUTO_INCREMENT PRIMARY KEY,
26name_last VARCHAR(50),
27name_first VARCHAR(50),
28country VARCHAR(50) );
29
30INSERT INTO authors
31(name_last, name_first, country)
32VALUES('Kafka', 'Franz', 'Czech Republic');
33  
34INSERT INTO books
35(title, author_id, isbn, year_pub)
36VALUES('The Trial', '1', '0805210407', '1995'),
37('The Metamorphosis', '2', '0553213695', '1995'),
38('America', '1', '0805210644', '1995');
39
40SHOW TABLES;
41
42SELECT title 
43FROM books
44LIMIT 5;
45
46SELECT title, name_last 
47FROM books 
48JOIN authors USING (author_id);
49
50SELECT title AS 'Kafka Books'
51FROM books 
52JOIN authors USING (author_id)
53WHERE name_last = 'Kafka';
54
55UPDATE books
56SET title = 'Amerika'
57WHERE isbn = '0805210644';
58
59DELETE FROM books
60WHERE author_id = '1';
61```
62
63Use the SELECT statement
64```sql
65SELECT isbn, title
66FROM books
67WHERE author_id = 1
68ORDER BY title ASC
69LIMIT 5;
70
71SELECT isbn, title, 
72CONCAT(name_first, ' ', name_last) AS author
73FROM books
74JOIN authors USING (author_id)
75WHERE name_last = 'Dostoevsky'
76ORDER BY title ASC
77LIMIT 5;
78
79# Use LIKE operator
80SELECT isbn, title, 
81CONCAT(name_first, ' ', name_last) AS author
82FROM books
83JOIN authors USING (author_id)
84WHERE name_last LIKE 'Dostoevsk%'
85ORDER BY title ASC
86LIMIT 5;
87
88# Some Flags
89SELECT DISTINCT HIGH_PRIORITY isbn, title
90FROM books
91JOIN authors USING (author_id)
92WHERE name_last = 'Dostoevsky'
93ORDER BY title;
94```
95Adding and Changing Data
96```sql
97```