Structured querry language | SQL | SQL placement course. lecture 1

preview_player
Показать описание
COURSE CONTENT: 17 modules | SQL placement course.
SUBSCRIBE ... to this channel and RING the BELL icon to never miss any video.

Structured querry language ( SQL ) placement course details.
SQL placement course: 17 modules

Basics - Module 1
Introduction

* Introduction to SQL Learnings: -- | You are here. |
* Introduction to Database
* Introduction to Data

Basics - Module 2
All about SQL and its categories

Introduction to SQL
* Data Definition Language – Part 1
* Data Definition Language – Part 2
* Data Definition Language – Part 3

Basics - Module 3
SQL Statements

* Data Manipulation Language – Part 1
* Data Manipulation Language – Part 2
* Data Manipulation Language – Part 3
* Transaction Control Language – Part 1
* Transaction Control Language – Part 2
* Data Control Language – Part 1
* Data Control Language – Part 2
* Data Retrieval Language – Part 1
* Data Retrieval Language – Part 2

Basics - Module 4
Make your statements Efficient

* String Functions – Part 1
* String Functions – Part 2
* Numeric Functions – Part 1
* Numeric Functions – Part 2
* Date Function – Part 1
* Date Function – Part 2
* Conversion Functions – Part 1
* Conversion Functions – Part 2
* Joins – Part 1
* Joins – Part 2

Advanced - Module 1
Introduction

* Introduction to DBMS
* Introduction to RDBMS

Advanced - Module 2
ER Modeling

* ER Modeling – Part 1
* ER Modeling – Part 2'

Advanced - Module 3
Normalization

* Normal Forms

Advanced - Module 4
SQL select variants

* Select Variants – Part 1
* Select Variants – Part 2

Advanced - Module 5
Sorting

* Sorting

Advanced - Module 6
Substitution Variables

* Substitution Variables

Advanced - Module 7
Single Row Function & Conditional Expressions

* Single Row Function
* Conditional Expressions

Advanced - Module 8
Grouping and Filtering

* Grouping and Filtering

Advanced - Module 9
Oracle Joins

* Oracle Joins

Advanced - Module 10
Sub queries

* Sub queries

Advanced - Module 11
Set Operators

* Set Operators

Advanced - Module 12
Read consistency and FOR UPDATE

* Read consistency and FOR UPDATE

Advanced - Module 13
Other schema objects

* Other schema objects – Views
* Other schema objects – Sequence
* Other schema objects – Index
* Other schema objects – Synonym

Advanced - Module 14
Managing Schema Objects

* Managing Schema Objects

Advanced - Module 15
Data Dictionary Views

* Data Dictionary Views

Advanced - Module 16
Manipulating large Data sets

* Manipulating large Data sets – SubQuery
* Manipulating large Data sets – Multitable Insert
* Manipulating large Data sets – Merge & Flashback

Advanced - Module 17
Retrieving Data using Subqueries

* Retrieving Data using Subqueries
END.

I hope you support me by subscribing to this channel.
Please subscribe
Thank you
Рекомендации по теме
join shbcf.ru