【實用教育app】SQL Free Guide|最夯免費app

【實用教育app】SQL Free Guide|最夯免費app

分享好友

【免費教育App】SQL Free Guide-APP點子

Structured Query Language (SQL) is a language for describing and operating on relational databases. A relational database is a database that is capable of representing relationships between different sets of data.

SQL can be used to access and manipulate data in: MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems.

SQL is commonly used in one of two ways:

【免費教育App】SQL Free Guide-APP點子

1. Directly operate on the database management system (DBMS), or

2. Operate on the database management system as part of a larger application

【免費教育App】SQL Free Guide-APP點子

What Can SQL do?

SQL can perform a variety of database related operations, including:

【免費教育App】SQL Free Guide-APP點子

- Executing queries (finding data)

- Retrieving data

【免費教育App】SQL Free Guide-APP點子

- Inserting records

- Updating records

【免費教育App】SQL Free Guide-APP點子

- Deleting records

- Creating new databases

【免費教育App】SQL Free Guide-APP點子

- Creating new tables

- Creating stored procedures

【免費教育App】SQL Free Guide-APP點子

- Creating views

- Setting permissions

【免費教育App】SQL Free Guide-APP點子

What is a Database?

In general, a database consists of one or more tables. Each table is identified by a name and contain rows (also called records) and columns containing data.

SQL is an ANSI (American National Standards Institute) standard

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

【免費教育App】SQL Free Guide-APP點子

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

- Using a server-side scripting language, like PHP or ASP

【免費教育App】SQL Free Guide-APP點子

- Using SQL to get the data you want

- Using HTMLand or CSS

【免費教育App】SQL Free Guide-APP點子

Web Sites and SQL

Most modern websites make use of a RDBMS (Relational Database Management System) to manage their data. The data in the RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of rows and columns.

In general, these websites need the following components:

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

- A server-side scripting language, like PHP or ASP

- SQL

- HTML

- CSS

免費玩SQL Free Guide APP玩免費

免費玩SQL Free Guide App

SQL Free Guide APP LOGO

SQL Free Guide LOGO-APP點子

SQL Free Guide APP QRCode

SQL Free Guide QRCode-APP點子
熱門國家系統支援版本費用APP評分上架日期更新日期
未知Android
Google Play
3
App下載
免費
1970-01-012015-04-08
分享app
上一個APP
下一個APP

高評價教育App推薦