Ravindra BagaleCourses & study guides

10. MySQL Part 1: Install, Create, Insert and SELECT

By Last updated:

Chala mitrano, aata database! Pratyek app – Instagram, bank, college portal – cha khara maal database madhe asto: users, passwords che hashes, posts, payments. Attackers la shevti hech hava asta. SQL injection samjun ghyaycha asel tar aadhi SQL swatah lihita aala pahije – SELECT, WHERE, UNION, JOIN. Aaj aapan MySQL install karun database aani tables banvnar, data takanar aani SELECT che sagle prakar shiknar aahot. Pratyek query MySQL prompt var type kara – copy-paste nako.

What you will learn in this chapter

  • Installing MySQL/MariaDB on Amazon Linux 2023 and Ubuntu and securing it
  • Creating, listing, using and dropping databases
  • Creating tables with the right data types, and inserting rows
  • SELECT with WHERE, ORDER BY, LIMIT, DISTINCT and aliases
  • LIKE, IN, BETWEEN and NULL checks
  • Aggregate functions, GROUP BY and HAVING
  • INNER, LEFT, RIGHT and self JOINs, and subqueries

Concepts in this chapter

  1. 10.1Installing MySQL or MariaDB
  2. 10.2Working with Databases
  3. 10.3Creating Tables and Choosing Data Types
  4. 10.4Inserting Data
  5. 10.5SELECT Basics and WHERE
  6. 10.6ORDER BY, LIMIT, DISTINCT and Aliases
  7. 10.7LIKE, IN, BETWEEN and NULL
  8. 10.8Aggregate Functions, GROUP BY and HAVING
  9. 10.9JOINs
  10. 10.10Subqueries

The chapter recap is at the end of the last concept page.