SQL

通報

問題一覧

request for data or information from a database

query

standard query format used by many DBMS

Structured Query Language (SQL)

According to the —, SQL is the standard language for DBMS

American National Standards Institute

collection of related objects created by the user

schema

components of statements and queries; WHERE, FROM, GROUP BY, ORDER BY, WITH, SELECT, HAVING

Clauses

produce scalar values or tables; columns and rows of data

Expressions

specifies conditions used to limit the effects of the statement and the queries

Predicate

names of the database objects

Object names

numeric or string values

Values

Operators

Arithmetic Concatenation Comparison Boolean

used to create, alter, drop tables and views

Data Definition Language

used for inserting, updating, modifying, and querying data in the database

Data Manipulation Language (DML)

used by the DBA to control the database such as to grant or revoke privileges for accessing the database

Data Control Language (DCL)

is a tool that presents a GRAPHICAL INTERFACE for managing, configuring, monitoring, and administering instances of SQL Server

SQL Server Management Studio SSMS

default instance of SQL server

Server type

default name or instance of the SQL Server. This name was added as an instance during the installation process.

Server name

is a Windows Authentication to establish a connection sith the SQL Server

Authentication

consists of SQL objects that you can alter or view

Object Explorer

it is a tree-tructured view of all database objects in a server

Object Explorer

consists of components or contects of SQL objects in the LEFT SIDE; LARGEST PORTION of SSMS

Document Window

Database Engines

DSSRM Databases Security Server Objects Replication Management

the facility to create and manipulate databases

Databases

the facility to identify and define database owner users, functions, and roles

Security

the facility that wil let you back-up, restore, triggersl, and link database servers

Server Objects

the facility that will allow you to have LOCAL subscriptions

Replication

the facility that will allow you to manage data tier applications, apply policy management, and determine logs

Management

Table default name

Table_1

May use the — prefix to indicate that the object is a TABLE

tbl-

First character must be a —

letter

Avoid using —3 as first character of the table name; special meaning in SQL Server

underscore (_) at (@) number (#)

Must not be a —- word

Transact-SQL reserved

— are not allowed; use — to separate words

Spaces, Underscore

collection of data elements organized in terms of rows and columns

Table

each single piece of data id a — a ROW is called —

field record

intersection of rows and columns or fields and records

file

indicate the type of dsta a column can contain and maximum number of dicits and characters it can hold

data type

collection of facts

data

in database, — pertains to the raw materials that you will enter in the table

data

KEY TERMS

KEY TERMS

Guillermo, Rizchel Anne B. · 18問 · 2年前

TLE KEY TERMS

TLE KEY TERMS

18問 • 2年前

Guillermo, Rizchel Anne B. · 59問 · 2年前

TLE CLASSIFICATION OF PROGRAMMING LANGUAGE, PROGRAM DEVELOPMENT PROCESS

TLE CLASSIFICATION OF PROGRAMMING LANGUAGE, PROGRAM DEVELOPMENT PROCESS

59問 • 2年前

Guillermo, Rizchel Anne B. · 33問 · 2年前

ALGORITHM/FLOW CHART

ALGORITHM/FLOW CHART

33問 • 2年前

Guillermo, Rizchel Anne B. · 30問 · 2年前

AP ARTICLES. UDHR Universal Declaration Of HumanRights

AP ARTICLES. UDHR Universal Declaration Of HumanRights

30問 • 2年前

1-10 ARTICLES (UDHR)

1-10 ARTICLES (UDHR)

11-20 ARTICLES (UDHR)

11-20 ARTICLES (UDHR)

21-30 ARTICLES (UDHR)

21-30 ARTICLES (UDHR)

LESSON 8

LESSON 8

Guillermo, Rizchel Anne B. · 22問 · 2年前

DDL

DDL

22問 • 2年前

Guillermo, Rizchel Anne B. · 11問 · 2年前

BILL RIGHTS 1-11

BILL RIGHTS 1-11

11問 • 2年前

CREATING, ALTERING AND DELETING DATABASES

CREATING, ALTERING AND DELETING DATABASES

DML

DML

Guillermo, Rizchel Anne B. · 12問 · 2年前

BILL OF RIGHTS 12-22

BILL OF RIGHTS 12-22

12問 • 2年前

BOWC

BOWC

Sektor ng Paglilingkod

Sektor ng Paglilingkod

MERCHANT OF VENICE

MERCHANT OF VENICE

Guillermo, Rizchel Anne B. · 9問 · 2年前

Impormal na sektor

Impormal na sektor

9問 • 2年前

Guillermo, Rizchel Anne B. · 34問 · 2年前

MUSIC

MUSIC

34問 • 2年前

ARTS

ARTS

Guillermo, Rizchel Anne B. · 26問 · 2年前

HEALTH

HEALTH

26問 • 2年前

Guillermo, Rizchel Anne B. · 40問 · 2年前

IMPORMAL NA SEKTOR

IMPORMAL NA SEKTOR

40問 • 2年前

Guillermo, Rizchel Anne B. · 40問 · 2年前

THERMODYNAMICS

THERMODYNAMICS

40問 • 2年前

DRAMATIC ELEMENTS

DRAMATIC ELEMENTS

Work Power Energy

Work Power Energy

Guillermo, Rizchel Anne B. · 41問 · 2年前

A6 - Kalakalang Panlabas

A6 - Kalakalang Panlabas

41問 • 2年前

Guillermo, Rizchel Anne B. · 22問 · 2年前

A6 - APEC and Presidents

A6 - APEC and Presidents

22問 • 2年前

Guillermo, Rizchel Anne B. · 9問 · 2年前

4D - MUSIC

4D - MUSIC

9問 • 2年前

Guillermo, Rizchel Anne B. · 46問 · 2年前

4D - ARTS

4D - ARTS

46問 • 2年前

Guillermo, Rizchel Anne B. · 8問 · 2年前

4D - PE

4D - PE

8問 • 2年前

Guillermo, Rizchel Anne B. · 15問 · 2年前

4D - HEALTH

4D - HEALTH

15問 • 2年前

Guillermo, Rizchel Anne B. · 51問 · 2年前

Electricity and Magnetism

Electricity and Magnetism

51問 • 2年前

William

William

Magnetism

Magnetism

DML COMMANDS

DML COMMANDS

Guillermo, Rizchel Anne B. · 7問 · 2年前

7問 • 2年前

Guillermo, Rizchel Anne B. · 55問 · 2年前

MP1

MP1

55問 • 2年前

Guillermo, Rizchel Anne B. · 32問 · 2年前

1.1 Kontemporaryong Isyu

1.1 Kontemporaryong Isyu

32問 • 2年前

Guillermo, Rizchel Anne B. · 65問 · 2年前

AP1

AP1

65問 • 2年前

PP1 - Health Related

PP1 - Health Related

Guillermo, Rizchel Anne B. · 18問 · 2年前

PP1- Skill Related

PP1- Skill Related

18問 • 2年前

AGENCIES

AGENCIES

MP1

MP1

Guillermo, Rizchel Anne B. · 42問 · 2年前

APD1

APD1

42問 • 2年前

Guillermo, Rizchel Anne B. · 28問 · 2年前

ARGUMENTATIVE ESSAY

ARGUMENTATIVE ESSAY

28問 • 2年前

Guillermo, Rizchel Anne B. · 42問 · 2年前

LOGICAL FALLACIES

LOGICAL FALLACIES

42問 • 2年前

CASE PRONOUNS

CASE PRONOUNS

Guillermo, Rizchel Anne B. · 55問 · 2年前

55問 • 2年前

Guillermo, Rizchel Anne B. · 41問 · 2年前

41問 • 2年前

Guillermo, Rizchel Anne B. · 9問 · 2年前

FALL OF TROY

FALL OF TROY

9問 • 2年前

BASIC SENTENCE PATTERNS

BASIC SENTENCE PATTERNS

Guillermo, Rizchel Anne B. · 24問 · 2年前

PRONOUN-Antecedent

PRONOUN-Antecedent

24問 • 2年前

COLLABORATION!

COLLABORATION!

Guillermo, Rizchel Anne B. · 11問 · 2年前

TEAM STRUCTURE AND DYNAMICS FOR ICT CONTENT

TEAM STRUCTURE AND DYNAMICS FOR ICT CONTENT

11問 • 2年前

ONLINE COLLABORATIVE TOOLS

ONLINE COLLABORATIVE TOOLS

Guillermo, Rizchel Anne B. · 47問 · 2年前

BENEVOLENCE STORIES

BENEVOLENCE STORIES

47問 • 2年前

Guillermo, Rizchel Anne B. · 34問 · 2年前

a def pt 2

a def pt 2

34問 • 2年前

Guillermo, Rizchel Anne B. · 42問 · 2年前

GLOBALISASYON

GLOBALISASYON

42問 • 2年前

KASAYSAYAN

KASAYSAYAN

Guillermo, Rizchel Anne B. · 16問 · 2年前

2ND MIDTERMS

2ND MIDTERMS

16問 • 2年前

TUGON

TUGON

Guillermo, Rizchel Anne B. · 44問 · 2年前

GLOBALISASYON (pt. 2)

GLOBALISASYON (pt. 2)

44問 • 2年前

2ND MASTERY

2ND MASTERY

Guillermo, Rizchel Anne B. · 12問 · 2年前

10TYPES OF PLAGIARIM

10TYPES OF PLAGIARIM

12問 • 2年前

Guillermo, Rizchel Anne B. · 15問 · 2年前

3 TYPES OF WRITING PROCESS

3 TYPES OF WRITING PROCESS

15問 • 2年前

Guillermo, Rizchel Anne B. · 31問 · 2年前

CRITIQUE PAPER

CRITIQUE PAPER

31問 • 2年前

SOIL HORIZON and TYPE OF SOIL

SOIL HORIZON and TYPE OF SOIL

WATER RESOURCES

WATER RESOURCES

INTRO, PROCESS AND FACTORS OF SOUL FORMATION

INTRO, PROCESS AND FACTORS OF SOUL FORMATION

Guillermo, Rizchel Anne B. · 8問 · 2年前

CHARACTERISTICS OF SOIL/ HUMAN ACT IMPACT SOIL QUAL

CHARACTERISTICS OF SOIL/ HUMAN ACT IMPACT SOIL QUAL

8問 • 2年前

soil deg, ways to conserve

soil deg, ways to conserve