Certificate of Proficiency in SQL for Data Science & AI

Application fee : 33.99 USD

Details

Certification Body: Aegis School of Data Science
Location: Online
GST: 18%
Total course fee: 0 USD
Rating:
No Ratings

Course Details

Brief about Topic:

SQL, or Structured Query Language, is a special-purpose programming language for managing data held in relational database management systems. SQL can be used to store, access and extract massive amounts of data. The data science process requires in depth analysis of the data at hand, which if stored in databases and queried using SQL, simplifies the task. SQL programming can be used to perform multiple actions on data such as querying, inserting, updating, deleting database records. Examples of relational databases that use SQL include MySQL Database, Oracle, etc.

SQL certifications are a kind of credential. Credentials are largely how the traditional education system works. You go to a university and obtain a degree, and then when it's time to get a job, your degree acts as a credential.  Employers use that credential as a proxy for experience when deciding whether to hire you. It’s proof that you’ve learned the things you say you’ve learned.

This certification will test your subject knowledge. Also, this will test your communication skills to convince your findings/results to your clients.

 

Certification Exam topics

Note: The certification will be based on a given curriculum, but certainly not limited only to mentioned subtopics.

Sl. No.

Topic/Subtopics

1.

Introduction To Databases and SQL

MySQL Workbench, DB Definitions & Basic Concepts, SQL: Structured Query Language, Entity-Relationship (ER) Model, Relational Database

2.

DDL and DML

Data Types, Data Definition Language, Data Manipulation Language

3.

DRL

SELECT, WHERE Clause, Logical Operators, Comparison Functions and Operators, String Functions, ALL and DISTINCT Modifiers, SQL Wildcards, ORDER BY Clause, GROUP BY Clause, HAVING Clause, Aggregate Functions, SELECT…INTO, UNION

4.

Subqueries  and Joins

Subqueries, ANY, IN, or SOME clauses, Subqueries with ALL, EXISTS or NOT EXISTS clauses, Correlated Subqueries, Derived Tables, JOINS and its different types

5.

DCL, TCL and Views

DCL, Privileges and Roles, TCL Commands, Views

6.

Triggers, Stored Procedures and Functions

Flow Control Statements , Triggers, Stored Procedures, Cursors, Functions, DECLARE Statement

7.

Normalization and Denormalization

1NF, 2NF, 3NF

8.

Window functions

Window Functions, Over Clause, Named windows, Date and Time Functions, Query Optimization, Pivoting Data