SQL for Data Analyst

$199.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: IDEAS-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.

Steps to take exam

Purchasing Exam

  1. Visit our certification page: https://www.ideassn.org/certificate/
  2. Register at ideas for purchasing certification. (If you already have an account, you can skip this step)
  3. Purchase the certification test you want to take.
  4. During your purchasing process, please clarify the time at which you want to take the exam in ADDITIONAL INFORMATION BOX. (the duration should no longer than 1 MONTH)
    1. For example, you can write: 2/2/2019-3/2/2019, then you will receive a link which is continuously activated during this time, and you can pick any time to start your exam.
  5. The system will send you a confirmation mail once you finish the order
  6. After the order confirmation, you will get the link via email to access the test (the link is activated during your preferred test duration.)
  7. This certification test could be taken anytime and anywhere, but you may only take it once, and the time duration for the exam is 2hr.

Pass the Test and Get Certification

  1. You will receive your grade via email within 1 week of submitting your test.
  2. You need to get at least 90% to pass this test.
  3. Congratulations! You will get our certification if you pass the test.

Exam duration – 2 hour

Exam Format

  • 1 hour technical questions
  • 1 hour project challenge

 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