About
LearnDesk
Learn  
Topics
Topics
Topics
Topics
Topics
Topics
Topics
Teach
  Teach Online
  Schedule
  Items
  Billing
  Users
  Marketing
  Analytics
  Settings
  Change School
Account
 

Learn SQL in a Simplified Manner

Introduction to SQL
Introduction to SQL
Preview
Database Used in Examples
Role of Database in Modern World
Performing Basic Operations with SQL
Preview
Reading Material - 1
Reading Material -2
Reading Material - 3
Reading Material - 4
Week 2
Need of Constraints and Its Types
Preview
Role of Constraints
Syntax of Create Table
Not Null, Unique and Primary Key Constraint
Preview
Not Null, Unique and Primary Key Constraint
Check Constraint
Preview
Check Constraint
FOREIGN KEY Constraint
Preview
Demonstration of Foreign Key Constraint
Preview
FOREIGN KEY Constraint
DEFAULT Constraint and Accessing Constraint Information
Preview
DEFAULT Constraint
Week 3
Alter Table Add Option
Preview
Alter Table Add Option
Alter Table: Modify and Drop Option
Preview
Alter Table: Modify and Drop Option
Joining of Tables
Joining of Tables and Its Types (Week 4)
Preview
Types of Joins Cartesian Product and Inner Joins
Concept of Joining Tables
OUTER Join
Preview
OUTER Join
SELF Join
Preview
SELF Join
Week 5
GROUP BY Clause
Preview
Grouping Data with GROUP BY Clause
Grouping on More Than One Column
Preview
Grouping by More Than One Column
Having Clause
Preview
Restricting Group Results with Having Clause
Inbuilt Functions of SQL
Single Row Numeric Functions

SELF Join

Learn SQL in a Simplified Manner Joining of Tables
By: Parteek Bhatia
10 minutes
Share the link to this page
Copied
  Twitter
  Email
Add the class to your calendar
Print
  Completed
Previous
Next
Home
Search
Saved
Trending Classes
Filter
The latest and the best classes on LearnDesk
Filter by Interest
Close
All Topics
Academics
Business
Creative
Health and Fitness
LifeStyle
Personal Development
Software
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Other
Pharma
Research
Science
Social Science
Teaching
Test Preparation
K-12
School
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
Internet of Things
Digital Transformation
Human Resources
Industry
Management
Marketing
Media
Operations
Other
Project Management
Public Relations
Real Estate
Sales
Strategy
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
Self Defense
Sports
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
Travel
Career Development
Learning
Religion and Spirituality
Self-Improvement
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
Content Management System
Customer Relationship Management
Database
Data Mining
E-Commerce
Enterprise Asset Management
Enterprise Resource Planning
Game Development
Google Cloud
Linux
Artificial Intelligence
Machine Learning
Master Data Management
Microsoft
Music Software
Network and Security
Open Source
Operating System
Other
Process Management
Productivity Software
Programming Languages
Robotics
Supply Chain Management
Testing
Teaching
Web Development

Sign Up

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.