Structured Query Language (SQL)- Full Chapter Explanation |Class 12 Computer Science Ch 9 | 2022-23
91👉Previous Video: https://www.youtube.com/watch?v=1rDVJihFMI4
👉Next Video: https://www.youtube.com/watch?v=9lu6lR43iAs
✔️📚👉 Watch Full Free Course: https://www.magnetbrains.com
✔️📚👉 Get Any Class & Subject's Topic Video Here:- https://www.magnetbrains.com/get-topic-wise-video
✔️📚👉 Get All Subjects Playlists: https://www.pabbly.com/out/all-videos-playlist
✔️📚👉 Grab Notes by Expert Teachers Here: https://www.pabbly.com/out/magnet-brains
✔️📚👉 Get E-Books Prepared by Our Expert Teachers: https://www.magnetbrains.com/book_purchase
=======================================================
📢 Full Playlist Link: https://www.youtube.com/playlist?list=PLVLoWQFkZbhXUyrZHmauRtSd0BRjmnWGP
✅ In this video,
✔️ Class: 12th
✔️ Subject: Computer Science (Code 083)
✔️ Chapter: Structured Query Language (SQL) (Chapter 9)
✔️ Topic Name: Structured Query Language (SQL) - Full Chapter Explanation| Class 12 Computer Science (Code 083) Chapter 9 | 2022-23
✔️ Topics Covered In This Video : This video provides full chapter explanation of chapter 9 Structured Query Language (SQL), from Computer Science Class 12. We will learn from our teacher, Vardan Sir, about the concept of SQL, processing capabilities of SQL, SQL elements, data Integrity, constraints and MySQL Set Operations.
=======================================================
00:00 Introduction: Structured Query Language SQL - Full Chapter Explanation
00:10 Chapter Overview: Structured Query Language (SQL): Chapter 9
22:29 SQL
29:35 Story
47:29 Processing Capabilities of SQL
51:53 Data Definition Language (DDL)
53:32 Interactive Data Manipulation Language (DML)
58:09 Embedded Data Manipulation Language
01:00:01 View Definition
01:06:33 Transaction Control
01:10:03 Classification Of SQL Statement
01:20:05 Data Definition Language (DDL) Commands
01:59:22 History of MySQL
02:56:53 MySQL Installation for Windows
04:02:14 Functions of MySQL Workbench
04:49:20 MySQL SQL Elements
04:54:33 Literals
05:12:33 Boolean Literals
05:18:05 Data Types
06:16:19 Arithmetic Operators in MySQL
06:36:05 Single line Comments
06:40:38 Multi line Comments
07:46:35 The Select Command
09:58:31 Using Column Aliases
10:23:37 Handling Nulls
12:39:23 Like Operator
14:10:52 Subquery
14:39:11 MySQL Functions
15:28:06 Lower Case
19:47:27 Second
21:43:46 Aggregate Functions
23:51:09 Opening a Database
24:53:31 Data Integrity
25:00:26 Constraints
25:03:12 Types of Constraints
25:05:17 Different Constraints
25:07:12 Constraints to Be Used for a Particular Data Integrity
25:09:12 Syntax
25:37:48 Unique Constraints
26:06:36 Primary Key Constraint
26:08:32 Primary Key Vs Unique Constraint
26:54:58 Check Constraint
27:18:14 Foreign Key Constraint
27:32:06 Examples
27:37:25 Role of Foreign Key/References Constraint
28:07:55 Assigning Names to Constraints
28:35:58 Creating a Table From an Existing Table
28:39:49 Viewing a Creating a Table
28:51:04 Problem
29:55:00 Points to Note
32:19:25 Removing a Table and a Column
33:52:59 Note
35:46:01 Nested Groups - Grouping on Multiple Columns
36:40:40 Placing Conditions on Groups - HAVING Clause
37:19:35 MySQL Set Operations - UNION
38:05:43 MySQL Set Operations - UNION All
39:05:15 Cartesian Product/Cross Join / Full Outer Join
39:15:42 Ambiguous Columns Problem in MySQL CROSS JOIN
39:47:48 Naturals Joins
41:41:10 Inner Joins
42:41:59 Self Joins
44:07:01 Rights Joins
44:45:57 Natural Join vs Equip Join vs Inner Join
44:53:53 Website Overview
=======================================================
Why study from Magnet Brains?
Magnet Brains is an online education platform that helps gives you NCERT/CBSE curriculum-based free full courses from Kindergarten to Class 12th so that you can perform well in any and all exams you give in your academic career.
👉 Contact us 🤑🤑
➡️ Connect with us : magnetbrainsbhopal@gmail.com
➡️ Website : https://www.magnetbrains.com/
➡️ Subscribe to us on YouTube: https://www.youtube.com/channel/UC3HS6gQ79jjn4xHxogw0HiA?sub_confirmation=1
➡️ Subscribe to Magnet Brains Hindi Medium : https://www.youtube.com/channel/UCwO6AYOIRYgyP1KJ5aPbDlw?sub_confirmation=1
➡️Facebook-: https://www.magnetbrains.com/out/facebook
➡️Telegram-: https://www.magnetbrains.com/out/telegram
➡️Instagram:-https://www.magnetbrains.com/out/instagram_main
#class12computerscience #computerscience #magnetbrains #boardexam2023
mysql class 12 computer science notes pdf
sql class 12 ncert
mysql class 12 ncert pdf
sql class 12 programs
class 12 mysql practical questions with answers
sql class 12 pdf
class 12 sql questions with answers
class 12 computer science sql questions
Disclaimer: "This video is for educational and informational purposes only and is not intended to infringe on any copyrights. If you believe that this video has used any copyrighted material in a way that constitutes copyright infringement, please contact us at contact@magnetbrains.com and we will take appropriate action."