教程-Introduction to using SQL for Reporting
MP4|Video:AVC1280x720|Audio:AAC48KHz2ch|Duration:4Hours|Lec:38|1.78GB
Genre:eLearning|Language:English

LearnhowtouseSQLtogeneratereportsthatcanbehelpfultoabusiness.

SQLcanbeusedtogeneratereportsandpresentinformationonwebsites.ThiscoursecoversSQLfeaturesinhelpingyouanswermoreinterestingquestionsaboutyourdata.

ThemostpopularbusinessproblemscanbesolvedwithSQL.Whatistherevenuegrowthmonthovermonthandrunningtotalrevenue?Canwetrustthemetric,ordoesthedatahavesomeaccidentalduplicatesthataffectit?WhatarethetopNordersforeverymonth?Whatistherepeatpurchasebehaviour?AllthesequestionscanbeetranslatedfromthedatabaseusingSQLintousefulreportsforthebusiness.

Topicscoveredincludes:

InstallingOracledatabase
InstallingTOAD
InstallingSQLdeveloper
ConnectingTOADandSQLDevelopertoOracleDatabase
OrderingandLimitingresults
FilteringdatausingtheWHEREclause
UsingmultipleoperatorswiththeWHEREclause
HowtouseViewsandDualTables
UsingLikeoperatorswithwildcardstoachievesearchpatterns
Removingduplicatesrecords
Usingsub-queries
Usingcharacterfunctions
Usingconversionfunctions
Usingnumericfunctions
Usingdatefunctions
Groupingresults
Aggregatefunctions
SomerealworldSQLreporting