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

Показать описание
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
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