Aegis School of Business, Data Science, Cyber Security & Telecommunication
Application fee: | 2500 * INR |
GST: | 18 % |
Certification Body: | Aegis School of Data Science |
---|---|
Location: | Online |
GST: | 18% |
Total course fee: | 0 * INR |
Rating: |
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 |