MP4 | Video: AVC 1280x720 | Audio: AAC 48KHz 2ch | Duration: 4 Hours | Lec: 38 | 1.78 GBGenre: eLearning | Language: EnglishLearn how to use SQL to generate reports that can be helpful to a business.

SQL can be used to generate reports and present information on websites.

This course covers SQL features in helping you answer more interesting questions about your data.

The most popular business problems can be solved with SQL .

What is the revenue growth month over month and running total revenue? Can we trust the metric, or does the data have some accidental duplicates that affect it? What are the top N orders for every month? What is the repeat purchase behaviour? All these questions can bee translated from the database using SQL into useful reports for the business.

Topics covered includes:Installing Oracle databaseInstalling TOADInstalling SQL developerConnecting TOAD and SQL Developer to Oracle DatabaseOrdering and Limiting resultsFiltering data using the WHERE clauseUsing multiple operators with the WHERE clauseHow to use Views and Dual TablesUsing Like operators with wild cards to achieve search patternsRemoving duplicates recordsUsing sub-queriesUsing character functionsUsing conversion functionsUsing numeric functionsUsing date functionsGrouping resultsAggregate functionsSome real world SQL reporting