Objective ID Topic Objective
SQL-O01 SQL-T01 Describe DBMS and its types
SQL-O02 SQL-T01 Define SQL and its purpose
SQL-O03 SQL-T01 Describe 3 datatypes stored in database
SQL-O04 SQL-T01 Explain CREATE statement with unique and not
null constraints
SQL-O05 SQL-T01 Write valid INSERT statement to add data into a
table
SQL-O06 SQL-T01 Write valid UPDATE & DELETE statement
SQL-O07 SQL-T02 Explain ALTER and DROP statements in SQL
SQL-O08 SQL-T02 Write valid SELECT statement to query, filter data
and sort data from a table
SQL-O09 SQL-T03 Use arithmetic operators to compute values from
multiple columns
SQL-O10 SQL-T03 Use logical operators to filter data based on single
and multiple criteria
SQL-O11 SQL-T03 Define SQL Built-in functions
SQL-O12 SQL-T03 Use aggregate functions with GROUP BY and
HAVING clause
SQL-O13 SQL-T04 Explain Normalization and its forms
SQL-O14 SQL-T04 Explain create table with referential integrity
SQL-015 SQL-T04 Write sub queries returning single value
SQL-O16 SQL-T04 Write valid SELECT statement with INNER JOIN and
OUTER JOIN
SQL-O17 SQL-T05 Create database design for a given business requirement.
Learn Duration Practice Duration
Key Topics (min) (min)
DBMS, Types of data models 30
SQL , ANSI SQL 15
numeric, char, date 15
Create, Unique, Check and NOT NULL 30
INSERT INTO, Multiple row insert 15 60
UPDATE, DELETE 15 45
ALTER statement, DROP statement 15
Select statement, Select using where clause, order by 30 180
Arithmetic operator +,-,*,/ 15 30
Comparison Operator (=, >, <, <=, >=,!=, IN, NOT 20 45
IN, BETWEEN, NOT BETWEEN, LIKE, NOT
LIKE, NULL, NOT NULL)
Logical Operator (ADD, NOT, OR)
Functions, Classification (Aggregate - SUM, MIN, 20 45
MAX, AVG, COUNT, DISTINCT; Scalar - current
date, SUBSTR, DATEDIFF)
GROUP BY, HAVING, ORDER BY 20 30
Database Normalization, Normal Forms (1st, 2nd, 3rd, 30
Boyce codd)
Primary, Foreign key 25
Nesting queries within DML (SELECT, INSERT, 20 30
UPDATE, DELETE), Sub query returning single value
Cartesian Product, INNER JOIN, OUTER JOIN 30 90
Database, Relational Database Management System, Data 120 120
Modelling, Entity Relationship DIagram
Content
RIO_01_Understanding_SQL.pptx - slide numbers 6-14
RIO_01_Understanding_SQL.pptx - slide numbers 27-31
RIO_01_Understanding_SQL.pptx - slide numbers 32 - 36
RIO_02_DDL, DCL Session 1.pptx - all slides except 27-30
RIO_03_Understanding_Constraints_and_their_Types - Slides 19-24
RIO_02_DML Session 2.pptx - Entire ppt - Slides 13-18
RIO_02_DML Session 2.pptx - Entire ppt - Slides 19-23
RIO_02_DDL, DCL Session 1 - Slides 14-16, 23-24
RIO_02_DML Session 2.pptx - Slides 8 -12
RIO_04_ANSI_SQL_Operators.pptx - slides 4-9
RIO_04_ANSI_SQL_Operators.pptx - slides 10-15, 16-18
RIO_05_ANSI_SQL_Functions.pptx - Slides - All sllides
RIO_06_ANSI_SQL_Clauses_in_SQL.pptx - Slides - All slides
RIO_01_Understanding_SQL.pptx - slides 15-26
RIO_03_Understanding_Constraints_and_their_Types.pptx - slides 4-17
https://www.dofactory.com/sql/subquery
RIO_07_ANSI_SQL_Joins_and_Their_Types.pptx - Slides - All slides,
Hands On Comments
02_RIO_DDL_DML_DQL_DCL_TCL_Hands_on_Exercise_1.docx
02_RIO_DDL_DML_DQL_DCL_TCL_Hands_on_Exercise_1.doc
02_RIO_DDL_DML_DQL_DCL_TCL_Hands_on_Exercise_1.do
cx and
02_RIO_DDL_DML_DQL_DCL_TCL_Hands_on_Exercise_2.do
cx - except exercises on TCL
RIO_04_ANSI_SQL_Operators - Practice Check.pptx and
RIO_04_ANSI_SQL_Operators - Lend a Hand.pptx
RIO_04_ANSI_SQL_Operators - Practice Check.pptx and
RIO_04_ANSI_SQL_Operators - Lend a Hand.pptx
RIO_05_ANSI_SQL_Functions - Practice Check.pptx and
RIO_05_ANSI_SQL_Functions - Lend a Hand.pptx
RIO_06_ANSI_SQL_Clauses_in_SQL - Lend a Hand.pptx
RIO_03_Constraints - Practice Check.pptx and
RIO_03_Constraints - Lend a Hand.pptx
RIO_07_ANSI_SQL_Joins_and_Their_Types - Lend a Hand.pptx
Topic ID Description
SQL-T01 Introduction, CREATE, INSERT, UPDATE, DELETE Statements
SQL-T02 ALTER, DROP, SELECT Statements
SQL-T03 Operators & Functions
SQL-T04 Normalization, INNER JOIN, OUTER JOIN, Sub Queries
SQL-T05 Database design
