/CourseBundles(68172)/4693636-CLOUD_APP_DEV.jpg)
Course Overview
Schedule of Classes
Course Curriculum
2 Subjects
SKT_PG_Theory_SQL & PL/SQL
40 Learning Materials
Course Road Map
Course Road Map
External Link
Fundamentals of Database
Fundamentals of Database
External Link
Introduction to SQL
Introduction to SQL
External Link
Installation Procedure For Oracle 11g Express Edition
Installation Procedure For Oracle 11g Express Edition
External Link
Data Types in Oracle
Data Types in Oracle
External Link
Numeric Data Types in Oracle
External Link
Date and Time Data Types in Oracle
External Link
Oracle large object Data Types
External Link
Data Definition Language (DDL) Commands
Data Definition Language (DDL) Commands
External Link
Data Manipulation Language(DML) Commands
Data Manipulation Language(DML) Commands
External Link
Data Query Language(DQL) Commands
Data Query Language(DQL) Commands
External Link
Transaction Control Language(TCL) Commands
Transaction Control Language(TCL) Commands
External Link
Data Control Language (DCL) Commands
Data Control Language (DCL) Commands
External Link
Data Integrity Constraints
Data Integrity Constraints
External Link
Operators
Operators
External Link
Comparison Operators
External Link
Bitwise Operators
External Link
Logical Operators
External Link
Set Operators
External Link
JOINS
JOINS
External Link
Types of JOINS
External Link
SUB - QUERIES
SUB - QUERIES
External Link
SQL VIEWS
SQL VIEWS
External Link
Types of SQL Views
External Link
SQL FUNCTIONS
SQL FUNCTIONS
External Link
Aggregate Function
Aggregate Functions
External Link
Single Row Functions
Single Row Functions
External Link
Conversion Functions
External Link
DateTime Functions
External Link
Introduction to PL/SQL
Introduction to PL/SQL
External Link
Data Types in PL/SQL
Data Types in PL/SQL
External Link
Control Structures
Control Structures
External Link
Loops in PL/SQL
Loops in PL/SQL
External Link
Exception Handling
Exception Handling
External Link
Functions Of PL SQL
Functions Of PL SQL
External Link
Procedure In PL/SQL
Procedure In PL/SQL
External Link
Triggers In PL/SQL
Triggers In PL/SQL
External Link
CURSORS
CURSORS
External Link
Cursor Variables
External Link
FOR Loop Cursors
External Link
SKT_DS_Theory_SQL for Data Science
52 Learning Materials
Introduction to Databases & RDBMS
Understanding Databases
External Link
Database Management System
External Link
Relational Database
External Link
Non- Relational Database
External Link
History
External Link
Installing SQL
Setting Up MySQL Environment
External Link
Database Processing Paradigms
OLAP vs. OLTP
External Link
Introduction to SQL
SQL Fundamentals and Introduction
External Link
SQL Syntax & Basic Queries
SQL Syntax & Basic Queries
External Link
SQL Data Types
Introduction to Data Types
External Link
Numeric Data Types
External Link
String Data Type
External Link
Date and Time Data Type
External Link
Binary Data Type
External Link
Miscellaneous Data Type
External Link
SQL Operators
Introduction to Operators
External Link
Arithmetic Operators
External Link
Comparison operators
External Link
Logical operators
External Link
Bitwise Operators
External Link
Compound Operators
External Link
String Operators
External Link
Set Operators
External Link
SQL Basics and Language Components
SQL Commands
External Link
Data Definition Language Commands
CREATE Database
External Link
USE Database
External Link
DROP Database
External Link
ALTER Database
External Link
CREATE Table
External Link
RENAME Table
External Link
DROP Table
External Link
TRUNCATE Table
External Link
Data Manipulation Language Commands
Retrieving data from a table
External Link
Inserting data into a table
External Link
Updating existing data into a table
External Link
Deleting all records from a table
External Link
Data Query Language Commands
Introduction to Clauses
External Link
FROM Clause
External Link
WHERE Clause
External Link
WITH Clause
External Link
ORDER BY Clause
External Link
LIMIT Clause
External Link
SQL Functions
Introduction to MYSQL Functions
External Link
Numeric Functions
External Link
String Functions
External Link
Date Time Functions
External Link
Conversion Functions
External Link
User Defined Functions
External Link
SQL GROUP BY , HAVING & Aggregate Functions
SQL Aggregation
External Link
SQL Grouping - GROUP BY
External Link
SQL Grouping - HAVING
External Link
SQL Indexes
Creating Indexes
External Link
Course Instructor
TBOCWWB
137 Courses • 108145 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy