Udemy Learn to use SQL for Data Analysis and Reporting Udemy
Price: AED 459

    Course details

    There is a demand for people who can use  data to perform reporting and analysis thus helping businesses and organizations make important and critical decisions.

    SQL stands for Structure Query Language. It is an internationally standard language used to communicate with various databases for data manipulation.  SQL is vital for data analysis and reporting.

    Have you wondered how you get the data you need? Do you wish you could retrieve it yourself?  This course  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.

    You will learn how to design and write simple SQL queries for data reporting and analysis. Also you will learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results.
     Discover how to perform more complex queries, such as joining data together from different database tables. 
     
    Topic you will learn include:

    Setup a Database Environment
    Understand Database Concepts
    Write SQL Syntax
    Understand SQL Data Types
    Retrieve Data using SELECT
    Filter Data search with SQL WHERE clause
    Sort SQL query result search  with ORDER BY
    Transform SQL Search results with string functions
    Use Alias to change query results headings
    Use various functions for data reporting and analysis

    SQL can be used to help solve business problems like :

    Who are the top ten sales-reps in each region?
    How many employees in an organization
    How many employees earn less than 45K in an organization
    How many new employees joined the company in the past 18 months
    What goods are flying off the supermarket shelves and so on..

    Who is the target audience?
    This Course is meant for newbies who are not familiar with using SQL for Data Analysis and Reporting.

    Updated on 14 February, 2018
    Courses you can instantly connect with... Do an online course on Data Science starting now. See all courses