最新消息:网盘下载利器JDownloader--|--发布资讯--|--站务--|--解压出错.密码问题--

Lynda – SQL for Data Reporting and Analysis

其他教程 killking 0评论
Lynda - SQL for Data Reporting and Analysis

Lynda - SQL for Data Reporting and Analysis

Size: 341 MB | Duration: 2h 16m | Video: AVC (.mp4) 1280x800 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
Do you rely on IT to get you the data you need? Do you wish you could retrieve it yourself? SQL for Data Reporting and Analysis teaches you how to get the data you want by writing a bit of SQL code. You won't just be able to pull data out of the database; you'll be able to manipulate it: merging it, multiplying it, grouping it, and relabeling it to get just the report you want. Join Emma Saunders as she shows you how to design and write simple SQL queries for data reporting and analysis. Review the different types of SQL, and then learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results. Learn a bit about data types and database design. Discover how to perform more complex queries, such as joining data together from different database tables. Last but not least, Emma shows how to save your queries as views, so you can run them again and again.

Topics include:
* Using different versions of SQL
* Retrieving data with SELECT statements
* Filtering and sorting your results
* Transforming results with built-in SQL functions
* Grouping SQL results
* Merging data from multiple tables
* Identifying data types, and how to make sense of your database design
* Saving SQL queries
Lynda - SQL for Data Reporting and Analysis

您必须 登录 才能发表评论!

网友最新评论 (1)

  1. Lynda - 数据报表和分析中的SQL  你是否依赖于IT获取所需的数据呢?你是否希望可以自动动手获取呢?本教程会为你讲授如何通过编写一点SQL代码就可以获得所需的数据。你不仅可以将数据从数据库中筛选出来;还能够对其操作:合并、复制、组合以及添加标签获得希望得到的报表。与Emma Saunders一起学习如何设计和编写简单的SQL查询用于数据报表和分析。回顾不同的SQL类型,学习如何筛选、组合以及排序,使用内建的SQL函数格式化或计算结果。学习一点数据类型和数据库设计的知识。学习如何执行更复杂的查询,如不同的数据表中的数据组合。最后,Emma还会讲解如何保存查询用于视图,这样你可以多次使用了。 主要内容:使用不同版本的SQL;使用select语句检索数据;筛选和排序;使用内建的SQL函数转换结果;组合sql结果;从多个表格中合并数据;识别数据类型,了解数据库设计;保持sql查询。
    wilde(特殊组-翻译)2个月前 (10-22)