(https://i114.fastpic.ru/big/2021/0528/cb/a79596a78e577b41cdd69455fecefacb.jpeg)
Duration: 2h 30m | MP4 | Video: AVC, 1280x720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Size: 321 MB
Skill Level: Advanced | Genre: eLearning | Language: English
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.
(https://i114.fastpic.ru/big/2021/0528/27/81e237b3e08f706fdf032cdebb3c5b27.jpeg)
Download link:
Só visivel para registados e com resposta ao tópico.Only visible to registered and with a reply to the topic.Links are Interchangeable - No Password - Single Extraction