LYNDA SQL ESSENTIAL TRAINING 2014 視頻教學 英文教學版

　



　
軟體簡介:
　
Whateveradatabaseisbeingusedfor—websites,bookkeeping,salesand
inventory,oreventhelowlyto-dolist—it'sstillallaboutthedata.
Completelyupdatedfor2014,SQLEssentialTrainingisdesignedtohelp
usersunderstandthemostcommonlanguagefordatabasewrangling,SQL.
Beginningwithaquickstartintroductionforthosewhowanttostart
workingwithdataimmediately,instructorBillWeinmanteachesallthe
majorfeaturesofSQL:creatingtables;definingrelationships;manipulating
strings,numbers,anddates;usingtriggerstoautomateactions;and
workingwithsubselectsandviews.Heoffersasolidworkingknowledge
ofthelanguage,andshowshowtoretrieveandmanagedataefficiently.
Thefinalchapterincludesareal-worldexampleofbuildingasimpleCRUD
(Create,Read,Update,andDelete)applicationusingSQL.

Topicsinclude:
‧UnderstandingSQLterminologyandsyntax
‧Creatingnewtablesandrecords
‧Insertingandupdatingdata
‧WritingbasicSQLqueries
‧Sortingandfiltering
‧AccessingrelatedtableswithJOIN
‧Workingwithstrings
‧Findingthenumerictypeofavalue
‧Usingaggregatefunctionsandtransactions
‧Updatingatablewithtriggers
‧Creatingviews