computer
is a request for data or information from a database table or a combination of tables
query
is the standard query format used by many database management system (DBMS)
structured query language (SQL)
is collection of related objects created by the user,such as tables,views,domains,constrainst and triggers among others.
schema
they are components of statements and queries
clauses
they produce scalar values or tables which consist of columns and rows of data
expression
they are the names of the database object like tables,views and columns.
object names
they coulb be numeric or string values
values
are reserve word or character used to perform operation as arithmetic and comparison
operators
it defines the database schema and is used to create and modify the structures of database objects in the database by creating,altering and dropping tables and views.
data definition language(DDL) commands
it is used to perform database maintenance,such as inserting,updaring,modifying,and querying data in the database.
Data manipulation language(DML)commands
it is used by the database administrator (DBA)to protect the database from corruption and security by controlling the rights and permission such as to grant or to revoke previleges for accessing the database
Data control language(DCL)commands
is a tool that presents a graphical interface for managing,configuring,monitoring and administering instances of the SQL server.
SQL SERVER MANAGEMENT SUDIO(SSMS)
is a microsoft product that is free and does not require an SQL server licens to install and use
SSMS
is the default instance of the SQL server
server type
is the default name or instance of the SQL server
server name
is a windows authentication to establish a connection with the SQL server
authentication
you can alter or view
object explorer
SQL objects in the left side
Document window
is a collection of facts such as numbers,words,measurements, observation or just a description of things.
data
is a mechanism to access a computer system that is secured
login or logon
is a unique code which is entered and only known by the authorized user
password
for values where the precision a nd scale need to be preserved
exact numerics
allow you to specify precision or the total number of digits allowable
approximate numerics
allows you to store date
datetime or samll datetime
any number or letter that will not have a math
character strings
variable-length non-unicode data
text
store binary data
binary strings
prevents/detects/deters improper disclosure of information
confidentiality
prevents/detects/deters improper modification on information
integrity
prevents/detects/deters improper denial of access to services
availability
it is a way to translate data into a coded form,making it readable only to those who have a passkey or password
data encryption
it is the ability to uniquely identify a user of a system on an application that is running in system
user identification
it is a mechanism that verifies a user or application claiming who or what they really are
authentication
it is a mechanism that limits access only to those authorized individual or application to protect critical resources in a system
authorization
it is the ability of the system to record all activities and have a process in place to review them to check
auditing
it is the mechanism that allows you to back up or save a copy of the database in another offline storage media location
backup solutions
SQL LANGGUAGE ELEMENTS
clauses
expression
predicates
object names
values
operators
TYPES OF SQL COMMANDS
DDL-Data definition language command.
DML-Data manipulation language command.
DCL-Data Control language command.
WINDOW IS DIVIDED INTO TWO PARTS:
Object explorer
Document window
GENERAL DATA TYPES USED IN SQL
-Exact numeric
-approximate numerics
-Datetime or small datetime
-Character strings
-text
-binary strings
BASIC DATABASE SECURITY OBJECTIVES:
Confidentiality
Integrity
Availability
SOME MECHANISM OF PROVIDING DATA SECURITY:
Data encryption
User identification
Authentication
Authorization
Auditing
Back up solutions
4 BASIC DDL COMMANDS:
Create
Use
Alter
Drop
| Quiz |
|---|
| gs so 2.2,3,5 |
| Geo glaciersHehe |
| Mandarin |
| hge |
| KOTOBA PM LEMBAR 4(hal 12,13,14,15) |
| Anglais S5 Voc 1 |
| kap 6 |
| Animal physiology |
| Forensic Ballistics (2) |
| GEOGRAFIA |
| FÍSICA |
| sistema oseosistema oseo |
| moment 1 |
| FILOSOFIA |
| musculosmusculos de la cabeza |
| Léna |
| Sociology |
| Relgion prov 1 |
| Test 1 |
| BIOLOGIA 2.0 |
| lite randoms |
| frågor |
| färger |
| kläder |
| veckodagarna |
| Jag är... |
| Food accessories |
| Food |
| Djur |
| math |
| مکتب ها |
| scheikunde se1 |
| Gender and Society |
| KOTOBA PM LEMBAR 3(hal 8,9,10,11,12) |
| AP 10 |
| Chapter 20 Cardiac |
| Java 2 chapter 10 review study |
| Java 2 Chapter 8 review study |
| Vegetaciona kupa stabla |
| Java 2 chapter 9 review study |
| LED fakta |
| Suffixes Forming AdjectivesSuffixes which transform any parts of speech into adjective |
| voc 4 (america's gun culture) |
| Ljustekniska storheter och enheterklar |
| 16 LERNWORTSCHATS |
| VerbChoose the correct answer and earn points! Good luck!! |
| Suffixes Forming NounsSuffixes which transform any parts of speech into noun |
| intro to transpo L1 |
| Kapitel 2 |
| Ljusfördelning och avbländning |
| Art and power : the power of music |
| its PL1 |
| svt 2 |
| Mossor |
| H1 zinnen |
| inflation |
| Duits schritt 41 (3vwo) |
| herman vocab 28 |
| نکاتی که سختن |
| نکاتی که سختن |
| voc 2 |
| biologia |
| USCP FINAL |
| HOPE 1 |
| gastrulacion |
| social |
| vicios de lenguajeestudiar |
| psychology approaches |
| tora |
| glosor v.39 |
| engels woordjes h1 |
| wush |
| TRIP |
| sooo |
| KOTOBA PM LEMBAR 2(hal 7,8) |
| Purcomm |
| Frans E1 (3 vwo a) |
| Glosor v.39Glosor till kapitel 3 i texboken |
| Frans B1 (3 vwo a) |
| Frans A1(3 vwo a) |
| HISTORY OF TRAVEL & TOURISM EARLY TOURISM TWO FORMS: 1. Travel for Business. |
| strategic business analysis |
| Science Exam_ |
| NGO SO periode 1 |
| English Exam_ |
| CLE Exam_ |
| EARTH AND LIFE SCIENCE |
| PR2tf tdrf |
| math |
| CPHN 1 |
| Ergonomi¨bra |
| Purposive Communication - 1st Year College BSTM |
| Övningstenta |
| خانواده ویولن |
| 9th |
| Nutri Lec - copy |
| TÁCTICACAPÍTULO III
ORGANIZACIÓN |
| TÁCTICACAPÍTULO II
LA INFANTERÍA |
| tisular |
| Nutri Lec |
| analgésicos, antiarritmicos y diuréticosfármaco |
| groep 6,7,8,9 |
| pcn deporte |
| correspondances trigo |
| Kapitel 1 |
| Pop Quiz |
| Marvin |
| etude art |
| Engelska förhör |
| linguistic 2 |
| THE BIOCHEMICAL CYCLEquiz september 26, 2024 |
| prelim |
| Methods of Philosophizing |
| ps1 |
| beggreppslista |
| Atención primaria |
| Definitions of Philosophy |
| adverbes de frequence |
| civil society quiz make it easy |
| civil society for sustainable development |
| Islam åk 8 del 5 Islam och samhället - i historien och nutid . |
| Introduction to Financial Management |
| mapeh |
| adjectifs |
| wh questions |
| Spanish words part 1 |
| Nask SO periode 1 |
| 1st |
| arts |
| music |
| نمایش معاصر |
| michael jordan |
| PE |
| litr - copy |
| acts |
| bh budtgdrcyrt |
| IT112 M2L1,2,3 |
| Psychology Key Terms Midterm |
| Psychology Midterm |
| Lab Blood |
| litr |
| Writing Critique Paper |
| cellular biology quiz |
| AtomfysikAtomfysik |
| hh |
| atomai molekules |
| spanska åk9 1 |
| Spanska v. 39 |
| Science Ions Polyatomique |
| Java 2 chapter 10 |
| Java 2 chapter 9 |
| revision mind map KA1 |
| Mapeh (Arts) (1st Exam)study!!! |
| AP |
| Mapeh (Music) (1st exam)study!!! |
| Espagne |
| Science |
| Araling Panlipunan |
| Science (1st exam)study!!! |
| Utvecklingspsykologi |
| Reading Texts CriticallyLesson 1 for 1st Semester (Grade 12) |
| 1 |
| physicskakak |
| additional |
| NEC 2023 Chapter and Article Titles - copy |
| subjects or arts |
| Grade 9 Mapeh Lesson |
| Engelska medical word |
| Nederlands H2 |
| Week 5 Particulieren |
| CHAPTER 2: COGNITIVE NEUROSCIENCE |
| موسیقی جهانیساز های بادی |
| scie rev |
| OralCom |
| Islam åk 8 del 4 Sharia & Fester . |
| history lesson 4 |
| STS |
| parcial 1 y 2 |
| Nematology (Prelims)IDENTIFICATION |
| voc pg 36 37 38 |
| identificstion of carbohydrates |
| BIO900 Plastider del 1 |
| Kemi E-provKemiska beteckningen på grundämnen i periodiska systemet 1-20 |
| Samhällsvetenskapliga begrepp till vecka 38 |
| So |
| BIO900 Fotosyntes del 1 |
| engelska läxa v.39 |
| química |
| BIO900 Begrepp del 1 |
| Frans tweede klas voca b |
| ap |
| arithmetic sequence solvings |
| 3 Flips on alien on earth |
| Tal 1 |
| oralcom |
| Parts of speech |
| CSS REVIEWER 0.1css reviewer |
| Compa |
| Kalagayan, suliranin at pagtugon sa isyung pangkapaligiran ng pilipinas |
| ENGLISHPERIODICAL TEST ENGLISH PRACTICE |
| Kontemporaryong Isyuito ay mga napapanahong isyu |
| vecka 39 |
| Monetary - Midterm |
| filipino |
| english and speech |
| BIO900 Instuderingsfrågor del 1 |
| EMS Olympiad (A=OE+L) |
| EMS Olympiad (general ledger) |
| Geschiedenis begrippen par. 1.1 & 1.2 |
| proteins |
| lipids (fats) |
| statistics |
| contemporary |
| artd |
| Sociology Midterm 1 |
| Psychology Midterm 1 |
| Bioquimica continuacion |
| nucleic acids |
| tandvård anatomi |
| Lesson 4 - Dimensional Analysis |
| Lesson 3 - Separation Techniques |
| concepts of entrepreneurships |
| pe |
| Lesson 2 - Matter and Properties |
| LITERATURA |
| arte y literaturaLOS CONCEPTOS INICIALES EN TORNO A LA APRECIACIÓN
DEL ARTE Y LA LITERATURA Y SU INTERACCIÓN CON SU
CONTEXTO SOCIOCULTURAL
¿Qué es el arte?
Se encuentran diferentes definiciones para el arte, algun... |
| Svamp |
| italiano zahlen |
| English (1st exam)study!!! |
| groep 3-4-5 |
| Foundation of Dance |
| Chapitre 1B semaine 39 (del 1) |
| 2 |
| Lesson 1 - Introduction to Chemistry |
| philo |
| QUÍMICA |
| filkom aklat |
| filkom akdksjd |
| stage 1 |
| Chapter 3 (পদার্থের গঠন) |
| mineral and their properties + types of rocks |
| es |
| GENCHEM |
| taekwondo |
| Waterbuck |
| ethics |
| MEDIA |
| 39 |
| Haws Kiping (Qwez) |
| History |
| Spelling Errors For Sindh University - copy |
| linguistic 1 |
| priciples of design |
| static GK |
| jessel cola |
| Histologia Cap. Nucleo Celular |
| Poems |
| Você é mais Inteligente do que um boneco dos anos 2000? - O joguinho de questõesVocê vai responder as questões de Raciocínio Lógico para concorrer a 12 mil reais em barras de ouro que vale mais do que dinheiro. |
| HISTÓRIA DO BRASIL 2.0 |
| HISTÓRIA DO BRASIL 1.0 |
| Nature of Dimensions |
| HISTÓRIA GERAL |
| Indian States & Capitals |
| Chemical compounds - copy |
| Economic |
| nucleic acids |
| läxa v.39 - skriva själv. |
| läxa v.39 |
| muskler |
| ben |
| 4.1 je fais du français french |
| drinks |
| Clubes do Brasil |
| PaísesUm quiz sobre os países |
| 21st reviewer module 2reviewer |
| spanish vocab |
| EARTH HISTORY |
| Endogenic and Exogenic |
| Así se diceSpanska glosor 24/9
Svenska - spanska |
