Learn SQL Queries Part1

 


SQL Queries using MySQL Database Part-1

Part-2



coding-zon--mysql-queries-tutorial

Understanding an RDBMS Relational Database Management System(RDBMs), stores all information/data  in the form of Tables. 

Understanding a Relational Database
A single database can contain many tables, and they can be linked together.
When the tables are linked together, it's said to be a relational database.

 

Understanding Tables, Records and Fields in RDBMS

Table: Collection of rows and columns
Row:  Collection of inter related columns.
Field:  A piece of information of particular entity.

 

coding-zon-mysql-introduction

Menu Top

Table structure/design: 


example:

FieldName             Datatype
Id                            Number
First_Name            Text
Last_Name            Text
Address                 Text


Understanding Primary and Foreign Keys
 

Primary key:Identifies each record in table with unique id.

example:

  • account_no
  • roll_no
  • customer_no
  • emp_no..etc

Foriegnkey:

A foreign key is a field (or fields) that points to the primary key of another table.
A foreign key is a column, or combination of columns, that contain values that are found in the primary key of some table.
 

TopMenu 

Understanding SQL and SQL Queries

 

SQL(Structured Query Language): 

Used to interact with the Databases. There are plenty of SQL Queries that are used to query the data. Basically, they are categorized into 3 groups.

  1. DDL
  2. DML
  3. DCL

1. DDL(Data Definition Language): All the commands in this category are used on table definition(design/structure) such as creating , changing field name, datatype, size, add or remove fields etc, you can also find commands for creating, altering or deleting any database objects such as user,view etc.
  •  Create
  •  Alter
  •  Drop  
2. DML(Data Manipulation Language): These are commands used on table data.
  •  Select
  •  Insert
  •  Update
  •  Delete

3. DCL(Data Control Language):These command are used for securing data.

  • Grant
  • Revoke


In the next blog, we will discuss in detail on the above stated commands. Please follow the Link given below.




Comments

Post a Comment

Popular posts from this blog

Shoppingcart using PHP Sessions - Miniproject

Image
Shopping cart using PHP Sessions, MySQL In this tutorial, you are going to learn how to build a simple shopping cart project using PHP and MySQL. It is a basic project aimed for beginners . This project uses PHP Session to implement shopping cart. Within the session, a cart is created. Sessions allows you managing the products in the cart. Such as… adding product to the cart,  modifying the product quantity,  deleting the product finding the total number of products in the cart. etc.   Download source code from the given link: Note: Scan the code with antivirus and use it. Download Here are steps to accomplish the project. Just follow them. STEP-1   Create a project in a server. Create an image's folder inside the project folder. As given in the picture. Copy some sample products images in that. GO TOP↑   STEP-2: Start server. Open PhpMyAdmin tool in a browser, Create a database, with name shoppingcartdb. Create Table. And insert Data using the given queri...
Read more

Export Data to Excel with PHP and MySQL

Image
How to Export Data to Excel using PHP and MySQL This tutorial demonstrates you how to export MySQL table data to Excel spreadsheet, when a user clicks a button on a webpage. You can achieve this using PHP, MySQL. For this, create the files specified in the below, in some folder in Apache server.   php2excel-tbl .php export.php    Now run the first file in the web server. When button clicked, export.php will be executed at backend and generates the Excel file. php2excel-tbl.php     <?php /*******EDIT DB Details *******/ $DB_Server = "localhost" ; //MySQL Server $DB_Username = "root" ; //MySQL Username $DB_Password = "" ; //MySQL Password $DB_DBName = "usersdb" ; //MySQL Database Name $DB_TBLName = "users" ; //MySQL Table Name $filename = "excel-users-list" ; //File Name /*******YOU DO NOT NEED TO EDIT ANYTHING BELOW THIS LINE*******/   //create MySQL connection...
Read more

Using javascript pass form variables to iframe src

Image
   Open PDF in Bootstrap Modal Window   This tutorial shows How to pass a JavaScript/jQuery variable to bootstrap modal view and sets it to iframe  src attribute. It passes value dynamically to src attribute of the iframe. When the user clicks a link, it opens the URL in a popup window. This  code shows the PDF in a Model without download option by hiding the toolbar.  To show PDF toolbar in modal, just add #toolbar=1   in the above script. index.php <!DOCTYPE html> <html lang= "en" > <head> <title>Bootstrap Model with PDF Example - coding-zon</title> <meta charset= "utf-8" > <meta name= "viewport" content= "width=device-width, initial-scale=1" > <link rel= "stylesheet" href= "https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css" > <script src= "https://cdn.jsdelivr.net/npm/jquery@3.6.1/dist/jquery.slim....
Read more