MYSQL Fundamentals

 Hello Dear Readers

Today I am sharing some basics of MYSQL which might be helpful for the readers.

SQL is the standard language for dealing with Relational Databases.

SQL inserts, searches, updates, and deletes database records.

MySQL is a widely used relational database management system (RDBMS).

MySQL is free and open-source.

MySQL is ideal for both small and large applications.

MySQL is a very popular open-source relational database management system (RDBMS).

What is MySQL?

  • MySQL is a relational database management system
  • MySQL is open-source
  • MySQL is free
  • MySQL is ideal for both small and large applications
  • MySQL is very fast, reliable, scalable, and easy to use
  • MySQL is cross-platform
  • MySQL is compliant with the ANSI SQL standard
  • MySQL was first released in 1995
  • MySQL is developed, distributed, and supported by Oracle Corporation


Who Uses MySQL?

  • Huge websites like Facebook, Twitter, Airbnb, Booking.com, Uber, GitHub, YouTube, etc.
  • Content Management Systems like WordPress, Drupal, Joomla!, Contao, etc.
  • A vast number of web developers around the world


Show Data On Your Web Site

To build a website that shows data from a database, you will need:

  • An RDBMS database program (like MySQL)
  • A server-side scripting language, like PHP
  • To use SQL to get the data you want
  • To use HTML / CSS to style the page



What is RDBMS?

RDBMS stands for Relational Database Management System.

RDBMS is a program used to maintain a relational database.

RDBMS is the basis for all modern database systems such as MySQL, Microsoft SQL Server, Oracle, and Microsoft Access.

RDBMS uses SQL queries to access the data in the database.

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-1349259147465486"
     crossorigin="anonymous"></script>

What is a Database Table?

A table is a collection of related data entries, and it consists of columns and rows.

A column holds specific information about every record in the table.

A record (or row) is each individual entry that exists in a table.

Look at a selection from the Northwind "Customers" table:

CustomerIDCustomerNameContactNameAddressCityPostalCodeCountry
1

Alfreds FutterkisteMaria AndersObere Str. 57Berlin12209Germany
2Ana Trujillo Emparedados y heladosAna TrujilloAvda. de la Constitución 2222México D.F.05021Mexico
3Antonio Moreno TaqueríaAntonio MorenoMataderos 2312México D.F.05023Mexico
4

Around the HornThomas Hardy120 Hanover Sq.LondonWA1 1DPUK
5Berglunds snabbköpChristina BerglundBerguvsvägen 8LuleåS-958 22Sweden

The columns in the "Customers" table above are: CustomerID, CustomerName, ContactName, Address, City, PostalCode, and Country. The table has 5 records (rows).


What is a Relational Database?

A relational database defines database relationships in the form of tables. The tables are related to each other - based on data common to each.

Look at the following three tables "Customers", "Orders", and "Shippers" from the Northwind database:

Customers Table

CustomerIDCustomerNameContactNameAddressCityPostalCodeCountry
1

Alfreds FutterkisteMaria AndersObere Str. 57Berlin12209Germany
2Ana Trujillo Emparedados y heladosAna TrujilloAvda. de la Constitución 2222México D.F.05021Mexico
3Antonio Moreno TaqueríaAntonio MorenoMataderos 2312México D.F.05023Mexico
4

Around the HornThomas Hardy120 Hanover Sq.LondonWA1 1DPUK
5Berglunds snabbköpChristina BerglundBerguvsvägen 8LuleåS-958 22Sweden

The relationship between the "Customers" table and the "Orders" table is the CustomerID column:

Orders Table

OrderIDCustomerIDEmployeeIDOrderDateShipperID
10278

581996-08-122
10280521996-08-141
10308271996-09-183
10355

461996-11-151
10365331996-11-272
10383481996-12-163
10384531996-12-163

The relationship between the "Orders" table and the "Shippers" table is the ShipperID column:

Shippers Table

ShipperIDShipperNamePhone
1Speedy Express(503) 555-9831
2United Package(503) 555-3199
3Federal Shipping(503) 555-9931
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-1349259147465486"
     crossorigin="anonymous"></script>

Some of The Most Important SQL Commands

  • SELECT - extracts data from a database
  • UPDATE - updates data in a database
  • DELETE - deletes data from a database
  • INSERT INTO - inserts new data into a database
  • CREATE DATABASE - creates a new database
  • ALTER DATABASE - modifies a database
  • CREATE TABLE - creates a new table
  • ALTER TABLE - modifies a table
  • DROP TABLE - deletes a table
  • CREATE INDEX - creates an index (search key)
  • DROP INDEX - deletes an index

    #google_responsive_slot_preview 

Comments

Post a Comment

Popular posts from this blog

VASTU SHASTRA - AN ESSENCE OF HOUSE CONSTRUCTION

Image
  Understanding Vastu Shastra Vastu Shastra is an ancient Indian architectural guide based on natural laws and energies. Following its principles is believed to bring prosperity, peace, and harmony into your living space. Below is an ideal diagram for a Vastu-compatible house Key Vastu Categories: Bhoomi (Land Selection): Choose plots with regular shapes (square or rectangular). Avoid sites near hospitals or graveyards to minimize negative energy. A plot sloping from south to north or west to east is considered auspicious. Prasada (Buildings and Structures): Main Entrance: It should face east or north to invite positive energy. Living Room: Place it in the northeast direction to attract calmness. Kitchen: Ideal in the southeast corner; the cooking person should face east. Bedroom: The southwest corner promotes restful sleep and stability. Bathrooms: Preferably in the northwest or west to avoid negative influence. Yana (Vehicles, Carts & Ships): Park vehicles in the northw...
Read more

A Short Trip To Tamil Nadu, India

Image
Hello Friends  Last Year I visited Vellore Tamil Nadu via road trip and managed to capture a few pictures that were allowed to click. Hope readers will like it Tamil Nadu is the southernmost state of India.  The tenth largest Indian state by area and the sixth largest by population, Tamil Nadu is the home of the Tamil people, who speak the Tamil language—the state's official language and one of the longest-surviving classical languages of the world. The capital and largest city is Chennai. While returning towards Pune from Vellore, en routing windmills at Karnataka-Maharashtra NH 48 Highway <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-1349259147465486" crossorigin="anonymous"></script> Katraj Tunnel <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-1349259147465486" crossorigin="anonymous"></script> Enrouting Kola...
Read more