Cover von Advanced SQL for Data Scientists wird in neuem Tab geöffnet
E-Medium

Advanced SQL for Data Scientists

Verfasser: Suche nach diesem Verfasser Sullivan, Dan (Verfasser)
Jahr: 2021
Verlag: LinkedIn
Mediengruppe: EMedien
Vorbestellbar: Ja Nein
Voraussichtlich entliehen bis:
Download Zum Download von externem Anbieter wechseln - wird in neuem Tab geöffnet

Exemplare

StandorteStatusVorbestellungenFrist
Standorte: Status: Verfügbar Vorbestellungen: 0 Frist:

Inhalt

Many data scientists know how to work with SQL-the industry-standard language for data analysis. But as data sizes grow, you need to know how to do more than simply read and write from a database. This course provides a more sophisticated approach to designing data models and optimizing queries in SQL. Instructor Dan Sullivan begins with the logical and physical design of tables-with particular focus on very large databases-and then presents a deep dive review of indexes, including specialized indexes and when to use them. The next section introduces query optimization and shows how to optimize basic, multi-join, and more complex queries. The course also covers SQL extensions, including user-defined functions and specialized data types. The techniques taught here enable more efficient analysis of large data sets using SQL, statistics, and custom business logic.

Rezensionen

Details

Verfasser: Suche nach diesem Verfasser Sullivan, Dan (Verfasser)
Jahr: 2021
Verlag: LinkedIn
E-Medium: content sample opens in new tab
Suche nach dieser Systematik
Suche nach diesem Interessenskreis
Beschreibung: 02:30:38
Suche nach dieser Beteiligten Person
Sprache: Englisch
Mediengruppe: EMedien