[go: up one dir, main page]
Scribd
Upload
255 views2 pages

Certified Data Analyst With SQL Course Curriculum

The document outlines the curriculum for a Certified Data Analyst with SQL course. The course covers key SQL topics like data types, operators, queries, aggregation, subqueries, functions, DML and DDL statements, constraints, joins, and views over 12 modules. Students will learn concepts and syntax through explanations and exercises for each topic.

Uploaded by

kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
255 views2 pages

Certified Data Analyst With SQL Course Curriculum

The document outlines the curriculum for a Certified Data Analyst with SQL course. The course covers key SQL topics like data types, operators, queries, aggregation, subqueries, functions, DML and DDL statements, constraints, joins, and views over 12 modules. Students will learn concepts and syntax through explanations and exercises for each topic.

Uploaded by

kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Certified Data Analyst with SQL course curriculum

Sr No. Module Details


What is SQL

Why SQL

What are relational databases?


1 Introduction To SQL
SQL command group

MS SQL Server installation

Exercises

SQL Data Types

Filtering Data

Arithmetic Operators
2 SQL Data Types & Operators
Comparison operators

Logical Operators

Exercises

Distinct Operation

Top N Operation

Sorting results

3 Useful Operations in SQL Combine results using Union

Null comparison

Alias

Exercises

Aggregate functions

Group By clause

4 Aggregating Data in SQL Having clause

Over clause

Exercises

What are sub-queries?

Sub-query rules
5 Writing Sub-Queries in SQL
Writing sub-queries

Exercises

Ranking functions

Date & time functions


6 Common function in SQL
Logical functions

String functions
Conversion functions

Mathematical functions

Exercises

What are analytic functions?

Various analytic functions


7 Analytic Functions in SQL
SQL syntax for analytic functions

Exercises

What are DML Statements?

Insert statement

8 Writing DML Statements Update statement

Delete statement

Exercises

What are DDL Statements?

Create statement

9 Writing DDL Statements Alter statement

Drop statement

Exercises

What are constraints?

Not Null Constraint

Unique constraint

Primary key constraint


10 Using Constraints in SQL
Foreign key constraint

Check constraint

Default Constraint

Exercises

What are joins?

Cartesian Join

Inner Join

11 SQL Joins Left & Right Join

Full Join

Self Join

Exercises

What are views?

Create View
12 Views in SQL
Drop view

Update view

You might also like