Skip to content

README.md

Latest commit

 

History

History
85 lines (70 loc) · 2.85 KB

README.md

File metadata and controls

85 lines (70 loc) · 2.85 KB
Raw

GDSC

GDSC Database Learning Path

Chapter 1 - Prerequisite

  1. What is Database ?
    • SQL (Sequel)
    • NoSQL
  2. What is MySQL ?
  3. What is Xampp ?
  4. Installing MySQL. (Two Options, XAMPP or Straight thru MySQL Website)
  5. Creating our first Database
  6. Creating our first Table

Chapter 2 – CRUD Implementation | Longest one by far.

  1. What is CRUD ?
  2. CRUD Example in other application
  3. CRUD in SQL
  4. Inserting Data to our Table
  5. SELECT(Reading Data) in our Table
    • Adding parameters to or SELECT args
    • WHERE parameter
    • AND, or, NOT parameter
    • IN parameter
    • BETWEEN parameter
    • LIKE parameter
    • REGEXP parameter
    • IS NULL parameter
    • ORDER BY parameter
    • LIMIT parameter
  6. Updating Data in our table
  7. Deleting Data in our Table

Chapter 3 – Table Join

Chapter 3 Part One

  1. Joining Table
    • INNER JOIN
    • Joining Across Databases
    • SELF JOIN
    • Joining Multiple Tables
    • COMPOUND JOIN – Implicit Join
    • OUTER JOIN
    • Between Multiple Table
    • SELF OUTER JOIN
    • USING Clause
    • NATURAL JOIN
    • CROSS JOIN
    • UNION

Chapter 3 Part Two - Column Attributes.

  1. Column Attributes
  2. Inserting Single Row
  3. Inserting Multiple Rows
  4. Inserting Hierarchical Rows
  5. Copying table
  6. Updating Single Row
  7. Updating Multiple Rows
  8. Using Subqueries in Updates
  9. Deleting Rows

Installing MySQL

There are two ways to install MySQL Database, first is to use XAMPP Installer, or Second is to use the Official MySQL Community Server Installer from MySQL Page

XAMPP

Getting Started

First you need to download XAMPP installation files from the official XAMPP Download Page, then run the Installer.

XAMPP

Do note that XAMPP needs write permission if you want to use XAMPP MySQL, the installer SHOULD prompt you that it's better to not put XAMPP files in the C: Directory so install it elsewhere to avoid unecessary problems.

After it's done, you should be prompted if you wanna open XAMPP Control Panel, Check the box and click finish

in the Control Panel, Start the apache and MySQL module

XAMPP_Control_Panel

Then open PHPMyAdmin or type localhost/phpmyadmin in your browser.

Installation is Done!

MySQL Community Server Installer

Getting Started

First you need to download MySQL Community Server Edition from MySQL Download Page

The Installer should guide you through the installation, choose all default option. When it's done, you can access it using MySQL Workbench