教程-SQLite for beginners
Video:.MP4,1280x720|Audio:AAC,44100Hz,2ch|Duration:4h
Genre:eLearning|Language:English+Sub| 
Whatyou’lllearn
LearnhowtoDownloadandInstallSQLite
LearnhowtoattachasampledatabasetoSQLite
HowtoconnecttoSQLiteDatabase
LearnhowtoexecuteSomecommonlyusedsqlite3commands
HowtobackupentiredatabaseandtablesusingSQLiteDumpcommand
LearntofetchdatafromdatabaseusingSQLiteSELECTstatement
Learntoqueryandfetchalldatafromadatabasetable
Learntoqueryandfetchspecificdatafromadatabasetable
LearntosortdatareturnedfromadatabaseusingORDERBYclause
LearntofilterdatareturnedfromadatabaseusingWHEREclause
LearnhowtoremoveduplicaterecordsusingSQLITEDISTINCT
LearnhowtoidentifyNULLvaluesinadatabasetable
LearnaboutvariousSQLiteDataTypes
LearnhowSQLiteConstraintsworks
Learnhowtocreatenewtable
Learnhowtoaddnewrecordsintoatable
LearnhowtoUpdateexistingrecordsinsideadatabasetable
LearnhowtoDeleteexistingrecordsinadatabase
LearnhowtoDropatable
LearnhowtousevariousSQLiteoperatorstomanipulatedata
Learnhowtoextractdatafrommultipletablesusingtablejoins
LearnhowtouseAliases
LearnhowtousevarioustypesofAggregatefunctionstoperformcalculationsonrecordsinadatabasetable
LearnhowtogroupdatawithGROUPBYclause
LearnhowtoFiltergroupeddatausingHAVINGclause

Arethereanycourserequirementsorprerequisites?
Basicknowledgeofacomputer
Basicinternetnavigationskills
Basicunderstandingofdatabaseconceptswillhelpbutnotmandatory
BasicworkingknowledgeofStandardSQLwillhelpbutnotmandatory

Whothiscourseisfor:
BeginnerSQLDevelopers
BeginnerDataAnalyst
BeginnerstoSQLite
BeginnerDBA's(DatabaseAdministrators)