SQL fundamentals for business intelligence

"Many of us know a bit of SQL. But when it comes to answering real-world business questions, our rusty memories of database classes let us down! This video course will take you to an intermediate level of familiarity with SQL in the context of writing maintainable and sophisticated SQL for spec...

Full description

Bibliographic Details
Main Author: James, Jeffrey
Format: eBook
Language:English
Published: [Place of publication not identified] Packt Publishing 2017
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 02396nmm a2200313 u 4500
001 EB001946050
003 EBX01000000000000001108952
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
050 4 |a HD38.7 
100 1 |a James, Jeffrey 
245 0 0 |a SQL fundamentals for business intelligence  |c Jeffrey James 
260 |a [Place of publication not identified]  |b Packt Publishing  |c 2017 
300 |a 1 streaming video file (1 hr., 57 min.) 
653 |a Architecture client-serveur (Informatique) 
653 |a SQL server / fast / (OCoLC)fst01376937 
653 |a Client/server computing / fast / (OCoLC)fst00864205 
653 |a Business intelligence / fast / (OCoLC)fst00842723 
653 |a SQL server / http://id.loc.gov/authorities/names/n90684343 
653 |a Client/server computing / http://id.loc.gov/authorities/subjects/sh93000502 
653 |a Business intelligence / http://id.loc.gov/authorities/subjects/sh85018300 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
500 |a Title from resource description page (viewed December 5, 2017) 
856 4 0 |u https://learning.oreilly.com/videos/~/9781788471176/?ar  |x Verlag  |3 Volltext 
082 0 |a 000 
082 0 |a 330 
520 |a "Many of us know a bit of SQL. But when it comes to answering real-world business questions, our rusty memories of database classes let us down! This video course will take you to an intermediate level of familiarity with SQL in the context of writing maintainable and sophisticated SQL for specific business queries. You will start by importing our first dataset which will be the DVD rental database. We then will explore and put into practice various SQL clauses and Join types. All examples of fundamental concepts are tightly guided by practical and hands-on exercises. No "Foo Bar" allowed anywhere, just problems from the wild, brought into the educational space. You will also learn tricks to get external data into the database, without worrying excessively about DBA functions and considerations. You'll also find out how to take the data into popular BI tools (Excel and Tableau) and refine the analysis further while discussing the interpretation of the data. By the end of the course, you will have developed your SQL skills and learnt how to answer business questions from the set of data."--Resource description page