SQL for Data Reporting and Analysis Video Training



    Posts : 24575
    Points : 73725
    Reputation : 0
    Join date : 2014-12-24

    SQL for Data Reporting and Analysis Video Training

    Post  wskins on Sun Dec 18, 2016 9:54 pm

    Lynda - SQL for Data Reporting and Analysis Video Training
    Duration: 2h 16m | Video: AVC (.mp4) 1280x800 15&30fps | Audio: AAC 48KHz 2ch | 341 MB
    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
    Title: SQL for Data Reporting and Analysis Video Training
    Size: 301.28 MB | Format: rar


      Current date/time is Wed Mar 21, 2018 12:53 pm