SQL_PPT_lecture1

1. Introduction to Databases with SQL Querying

3. Song of Solomon Pat Conroy Goodnight Moon Prince of Tides Antoine de Saint-Exupéry Le Petit Prince The Overstory F. Scott Fitzgerald Toni Morrison The Great Gatsby Richard Powers Frankenstein Margaret Wise Brown Mary Shelley

4. title author Toni Morrison Song of Solomon Margaret Wise Brown Goodnight Moon Richard Powers The Overstory The Great Gatsby F. Scott Fitzgerald Frankenstein Mary Shelley Le Petit Prince Antoine de Saint-Exupéry Prince of Tides Pat Conroy

5. Apple Numbers Google Sheets Microsoft Excel …

6. Scale

7. Scale Frequency

8. Scale Frequency Speed

9. Database A collection of data organized for creating, reading, updating, and deleting.

10. Database Management System Software via which you can interact with a database.

11. MySQL Oracle PostgreSQL SQLite …

12. SQL A language via which you can create, read, update, and delete data in a database.

13. Structured Query Language A language via which you can create, read, update, and delete data in a database.

14. SQL A language via which you can create, read, update, and delete data in a database.

15. Querying

16. What's the most-liked post on our platform?

17. Is our number of daily users growing or shrinking?

18. Which songs are most like the song a user just played?

20. Visual Studio Code SQLite …

21. VS Code SQLite …

22. Phones

23. Desktop

24. Websites

25. sqlite3 FILENAME

26. What data is in our database?

27. SELECT

28. LIMIT

29. OFFSET

30. WHERE

31. = != <>

32. NOT

33. Style

34. SELECT "title" FROM "longlist" WHERE "author" = 'Fernanda Melchor';

35. SELECT "title" FROM "longlist" WHERE "author" = 'Fernanda Melchor';

36. SELECT "title" FROM "longlist" WHERE "author" = 'Fernanda Melchor';

37. NULL

38. IS NULL IS NOT NULL

39. LIKE

40. % _

41. AND OR ()

42. > < >= <=

43. BETWEEN … AND …

44. ORDER BY

45. ORDER BY … ASC ORDER BY … DESC

46. COUNT AVG MIN MAX SUM

47. ROUND

48. DISTINCT

49. .quit

50. SELECT column FROM table;