Tutorialspoint

SQL with PHP

person icon Ubaid Ur Rehman

SQL with PHP

Learn SQL with PHP

updated on icon Updated on Oct, 2023

language icon Language - English

person icon Ubaid Ur Rehman

architecture icon Development,Database Design & Development,SQL

Lectures -10

Duration -36 mins

price-loader

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

What is SQL?

Structured Query Language (SQL) is a standardized programming language that is used to manage relational databases and perform various operations on the data in them. Initially created in the 1970s, SQL is regularly used not only by database administrators but also by developers writing data integration scripts and data analysts looking to set up and run analytical queries.

The term SQL is pronounced ess-Kew-ell or sequel.

SQL is used for the following:

  • modifying database table and index structures;

  • adding, updating, and deleting rows of data; and

  • retrieving subsets of information from within relational database management systems (RDBMSes) -- this information can be used for transaction processing, analytics applications, and other applications that require communicating with a relational database.

SQL queries and other operations take the form of commands written as statements and are aggregated into programs that enable users to add, modify or retrieve data from database tables.

A table is the most basic unit of a database and consists of rows and columns of data. A single table holds records, and each record is stored in a row on the table. Tables are the most used type of database objects or structures that hold or reference data in a relational database. Other types of database objects include the following:

  • Views are logical representations of data assembled from one or more database tables.

  • Indexes are lookup tables that help speed up database lookup functions.

  • Reports consist of data retrieved from one or more tables, usually a subset of that data that is selected based on search criteria.

Each column in a table corresponds to a category of data -- for example, customer name or address -- while each row contains a data value for the intersecting column.

Relational databases are relational because they are composed of tables that relate to each other. For example, a SQL database used for customer service can have one table for customer names and addresses and other tables that hold information about specific purchases, product codes, and customer contacts. A table used to track customer contacts usually uses a unique customer identifier called a key or primary key to reference the customer's record in a separate table used to store customer data, such as name and contact information.

SQL became the de facto standard programming language for relational databases after it emerged in the late 1970s and early 1980s.

In Course?

  • In this course, you will learn about SQL and MySQL.
  • You will understand how the database works and store data.
  • You will learn about How to create a database and its table.
  • And How you can store and manage data in a database using MySql.
  • And you will also learn how to connect your PHP with MySQL database to perform SQL Queries.

Who this course is for:

  • Beginner SQL

Goals

What will you learn in this course:

  • Create a Database and Table
  • Store and Retrieve information from the database
  • connect database to PHP
  • perform SQL queries through PHP

Prerequisites

What are the prerequisites for this course?

  • Installation of Xampp

SQL with PHP

Curriculum

Check out the detailed breakdown of what’s inside the course

SQL and PHP
10 Lectures
  • play icon Database and Table creation 04:24 04:24
  • play icon Insert Query in SQL 04:31 04:31
  • play icon Select Query in SQL 03:01 03:01
  • play icon Update Query in SQL 01:50 01:50
  • play icon Delete Query in SQL 01:40 01:40
  • play icon Connect PHP with MySQL 04:21 04:21
  • play icon SQL Insert Query with PHP 06:16 06:16
  • play icon SQL Select Query with PHP 04:16 04:16
  • play icon SQL Update Query with PHP 03:19 03:19
  • play icon SQL Delete Query with PHP 02:48 02:48

Instructor Details

Ubaid Ur Rehman

Ubaid Ur Rehman

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Feedbacks

A

Ankita thakur

nice

T

Teju Rai

great

R

Rajathurai Rajasuresh

I would give Conway my special congratulations to your endeavor efforts with amazing Teaching Art. It's really helpful to know many things from you, not only that I can come to know new ideas from this learning. As a learner I am happy with your lesson. GOOD Luck

K

Kratika Dua

A quick refresh Course

P

Prakhar kumar Khare

Good

N

Nhlamulo Vumane

This coarse makes SQL looks simple and I chose it in order to enhance my coding skills.

A

Ajay Singh

nice course for beginners

A

Abdulaziz Hassan Haider

thankes

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us

1800-202-0515