1.1 File Management System - LearnKartS

Home » 1.1 File Management System

SQL for Beginners Lesson-01 – Database Fundamentals 1.1 File Management System

In Progress

In Progress

← Previous Next→

Course Content

Expand All

Lesson-01 - Database Fundamentals 10 Topics Sample Lesson

Expand

Lesson Content

0% Complete 0/10 Steps

Learning Objectives

1.1 File Management System

1.2 Database Management System

1.3 File System vs DBMS

1.4 DBMS Classification

1.5 DBMS Architecture

1.7 Oracle Versions

1.8 Normalization

Lesson-02 - Data Models 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Learning Objectives

2.1 Data Models

2.2 Entity-Relationship (ER) Model

2.3 Cardinality Mapping

2.4 ER Diagram - Case Study

Lesson-03 - SQL Introduction 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

Learning Objectives

3.1 SQL Introduction

3.3 Types of SQL Commands

3.4 Compare Delete and Truncate

3.5 SQL Data Types

Demo - Oracle Client Server Installation

Demo - Basic Commands and Built-in Data Types

Demo - Built in Datatypes - BLOB, CLOB

Demo - Built in Datatypes - DATE

Lesson-04 - Integrity Constraints 13 Topics

Expand

Lesson Content

0% Complete 0/13 Steps

Learning Objectives

4.1 Database Integrity

4.2 Constraint Types

4.3 Unique vs Primary Key vs Foreign Key

4.4 Defining Constraints

Demo- Implement Integrity Constraints and Referential Integrity

4.5 Self Referential Integrity

Demo- Implement Self-Referential Integrity

Demo - 1 NF Normalization

Demo - 2 NF Normalization

Demo - 3 NF Normalization

Demo - 4 NF Normalization

Lesson-05 - Operators and Select Command 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Learning Objectives

Demo - Usage of Operators

5.2 Select Command

Demo- 'Select' Query Options

Lesson-06 - Built-in Functions 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Learning Objectives

6.1 Built in Functions

Demo - Built-in Functions

Demo - “GROUP BY” Clause

Lesson-07 - Set Operators and Joins 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Learning Objectives

7.1 Set Operators

Demo - Set Operators

Demo - Join operations

Lesson-08 - Subqueries 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Learning Objectives

8.1 Introduction to Subqueries

Demo - Subqueries

8.2 Subqueries Operators

Demo - Special Operators

Lesson-09 - TCL Commands and Views 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

Learning Objectives

9.1 TCL Commands

Demo - TCL Commands

9.2 DCL Commands

Demo - DCL Commands

9.3 Pseudo Columns

Demo - Pseudo Columns

Demo - Normal and Materialized Views

Lesson-10 - Synonyms, Sequences and Indexes 12 Topics

Expand

Lesson Content

0% Complete 0/12 Steps

Learning Objectives

Demo - Synonyms – Public and Private

10.3 Materialized Views and Synonyms

Demo - Sequence

10.6 How Indexing Works

10.7 Index Types

Expand

Lesson Content

0% Complete 0/1 Steps

SQL for Beginners - Course-end Quiz

0% Complete