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


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.
 

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 categorised 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 secuing 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

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

Creating a new PDF by Merging PDF documents using TCPDF

Image
Merging two PDFs in PHP What is PDF? The Portable Document Format. PDF stands for "Portable Document Format". Essentially, the format is used when you need to save files that cannot be modified but still need to be easily shared and printed. PDF is one of the most commonly used file types around. PDFs generally contain shareable data, such as text or photo documents etc., and are accessible to anyone who has a computer or smartphone. Unlike a Word file, which requires Microsoft Word to view or edit, most browsers will open a PDF. How to merge PDFs? You can merge several documents into one. In PHP, you have a library called TCPDF which allows you to combine one or more PDF documents to one single document. In this article, we will create a new PDF by Merging PDF documents using TCPDF. Download the PDFMerger-tcpdf.zip here. Unzip it and copy it to the PHP server. Copy the PDF files into the same folder that you want to combine. Open the file: merge-pdf-example.php Provide
Read more

Import excel file into mysql in PHP

Image
  Upload Excel file and Import  it into MySQL in PHP  Create a table in some database with given code.   Download Library - extract it, rename the folder to library . Create index.php file with given code in a server. Create excelUpload.php with given code. Create db_config.php . Create one Excel file with some sample data as shown in the below image of Excel file. Create ' uploads ' folder in the same directory. Now start server, run the index.php. Upload a .xls file. If Everything is fine, Excel data inserted in the above created MySQL table - tbl_products . PHP Version:   5.5.11 Folder Structure      Query: CREATE TABLE IF NOT EXISTS `tbl_products` ( `id` int ( 11 ) NOT NULL AUTO_INCREMENT, `productname` varchar ( 100 ) DEFAULT NULL , `description` varchar ( 100 ) DEFAULT NULL , PRIMARY KEY (`id`) )     Top index.php <!DOCTYPE html> <html> <head> <title> coding-zon Demo - Upload Excel to MySQL in PHP </title> <lin
Read more