Sharing Is Caring:

SQL in web development

  • SQL for beginners
  • Free tutorial
  • Rating: 3.6 out of 53.6 (39 ratings)
  • 3,517 students
  • 34min of on-demand video
  • Created by Web Warrior
  • English

What you’ll learn

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

Requirements

  • No Prerequiesites

Description

hello guys welcome to the course of sql in which u will learn things about sql and how to execute queries.

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.
Read Also -->   Selenium WebDriver Coding Exercises for Interviews

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

Who this course is for:

  • this course is for students in web development

Show less

Course content

1 section • 6 lectures • 34m total length

Introduction6 lectures • 34min

  • 1 SQL INTRO07:04
  • 2 SQL SYNTAX06:38
  • 3 SQL SELECT02:57
  • 4 SQL SELECT DISTINCT06:51
  • 5 SQL WHERE09:24
  • REFERANCE01:11

👇👇👇👇 Click Below to Enroll in Free Udemy Course 👇👇👇👇

Go to Course

👇👇 See Also 👇👇

Join Us Join Us Join Us
Sharing Is Caring:

Leave a Comment

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO