SQL for Data Analyst

$500.00

SQL is a standard language for storing, manipulating and retrieving data in databases. Data Analytics is one of the fastest-growing and highest-paying areas of business. Organizations are increasingly relying on data to drive strategic business decisions. SQL Certification for Data Analytics from IDEAS will allow you to become qualified and sought after for competitive business positions.

SKU: DSA-SQL Category: Tag:

Description

Qualifying Participants

Individuals who have a basic data management and analytical background, and anyone want to be SQL developers, database administrators, business analyst, data analyst, marketing analyst. It is best suited for those with the capability of leveraging business analysis with SQL.

Exam Topics

  • Database
    • Relational and Non-relational database
    • Structured Query Language
  • Table Manipulation
    • Data types
    • Creating a table
    • Inserting into a table 
    • Delete from table 
    • Updating a row
    • Changing table structure 
    • Drop tables
  • Indexes and Constraints
    • Index
    • Constraints
  • Basic SQL Query
    • Select
    • Where
    • In
    • Between
    • Logical operators
    • Basic function
    • Order by
    • Group by
    • Having 
  • Join Tables
    • Inner join
    • Left join
    • Right join
  • Advanced SQL Query
    • Subquery
    • Non-correlated subquery
    • correlated subquery
    • Subqueries and joins
    • Transforming subquery into join

*Although SQL is an ANSI (American National Standards Institute) standard, there are different versions of the SQL language. We choose MySQL as our standard.

Online-courses for your reference:

  • Udemy: Introduction to SQL and MySQL
  • Coursera: Introduction to Structured Query Language (SQL)
  • Codecademy: Learn SQL

SQL exercise and interview questions for your reference:

  • Leetcode: Database problems
  • Hackerrank: SQL problems

Grading Standards & Process

  •          This online test consists of a section of 10 multiple-choice questions and 9 SQL coding challenges (easy, medium and hard).
  •          Test will be marked by examiners, and the results will be available one week after the test.
  •          The grading is based on a pass or no pass system. A minimum score of 60% is required to pass the test and receive the verified certificate.