SQL Tutorial - SQL in Web Development

Pubblicato il: 15 marzo 2022
sul canale di: DataZ
74
1

In this tutorial, you'll learn things about SQL and how to execute queries.
PostgreSQL Database Administration (DBA) for Beginners - Full Course
☞ https://morioh.com/p/065acd2366c1
MySQL Database - Full Course from Zero to Hero
☞ https://morioh.com/p/752aa713e91d
SQL vs NoSQL or MongoDB vs MySQL? Which Database is Better?
☞ https://morioh.com/p/f2eba211e16d

What is SQL?

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987.

What Can SQL do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and v

Using SQL in Your Web Site

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

An RDBMS database program (i.e. MS Access, SQL Server, MySQL)

To use a server-side scripting language, like PHP or ASP

To use SQL to get the data you want

To use HTML / CSS to style the page.

RDBMS

RDBMS stands for Relational Database Management System.

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

The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.

so this was all about sql and other related inofrmation about the sql
What you’ll learn

SQL
Queries in SQL
how to execute queries
how to add data to data base and update data

#SQL #WebDev #Morioh

Note: If you have any copyright issue with the content used in our channel or you find something that belongs to you, before you claim it to Youtube, SEND US A MESSAGE and the respective content will be DELETED right away. Thanks for understanding.


In questa pagina del sito puoi guardare il video online SQL Tutorial - SQL in Web Development della durata di ore minuti seconda in buona qualità , che l'utente ha caricato DataZ 15 marzo 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 74 volte e gli è piaciuto 1 spettatori. Buona visione!