filmov
tv
Querying and SQL Functions - Full Chapter Explanation | Class 12 Informatics Practices Ch1 (2022-23)
Показать описание
=======================================================
✅ In this video,
✔️ Class: 12th
✔️ Subject: Informatics Practices (Code 065)
✔️ Chapter: Querying and SQL Functions (Chapter 1)
✔️ Topic Name: Querying & SQL Functions - Full Chapter Explanation
✔️ Topics Covered In This Video (By Barkha Mam): Full Chapter Explanation of Chapter Querying & SQL Functions
=======================================================
00:00 Querying & SQL Functions Introduction: Full Chapter Explanation
00:35 Concept of Querying and SQL Functions
08:23 Introduction of Querying and SQL Functions
20:10 Relational Data Model
40:38 Introduction of Querying and SQL Functions
01:49:37 Function in SQL
04:35:47 Introduction of SQL Commands Practical
05:13:31 Function in SQL
06:35:43 Aggregate Functions
07:02:07 Group by in SQL
07:26:23 Operations on Relations
08:32:24 Using Two Relation in a Query (Jain Operation)
09:09:09 Question & Solutions: Exercise : Chapter 1
Que. 1 Answer the following questions:
10:37:00 Question & Solutions: MCQs: Chapter 1
Que. Which of the following is not a text function?
11:32:19 Question & Solutions: Fill in Blanks: Chapter 1
1. The functions that work with one row at a time are called functions.
11:55:30 Question & Solutions: True / False Questions: Chapter 1
1. Truncate() is a text function.
12:31:08 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 🤑🤑
#2022_23 #2022 #2023
✅ In this video,
✔️ Class: 12th
✔️ Subject: Informatics Practices (Code 065)
✔️ Chapter: Querying and SQL Functions (Chapter 1)
✔️ Topic Name: Querying & SQL Functions - Full Chapter Explanation
✔️ Topics Covered In This Video (By Barkha Mam): Full Chapter Explanation of Chapter Querying & SQL Functions
=======================================================
00:00 Querying & SQL Functions Introduction: Full Chapter Explanation
00:35 Concept of Querying and SQL Functions
08:23 Introduction of Querying and SQL Functions
20:10 Relational Data Model
40:38 Introduction of Querying and SQL Functions
01:49:37 Function in SQL
04:35:47 Introduction of SQL Commands Practical
05:13:31 Function in SQL
06:35:43 Aggregate Functions
07:02:07 Group by in SQL
07:26:23 Operations on Relations
08:32:24 Using Two Relation in a Query (Jain Operation)
09:09:09 Question & Solutions: Exercise : Chapter 1
Que. 1 Answer the following questions:
10:37:00 Question & Solutions: MCQs: Chapter 1
Que. Which of the following is not a text function?
11:32:19 Question & Solutions: Fill in Blanks: Chapter 1
1. The functions that work with one row at a time are called functions.
11:55:30 Question & Solutions: True / False Questions: Chapter 1
1. Truncate() is a text function.
12:31:08 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 🤑🤑
#2022_23 #2022 #2023
0:06:00
Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)
0:07:52
SQL Window Functions | Clearly Explained | PARTITION BY, ORDER BY, ROW_NUMBER, RANK, DENSE_RANK
0:17:40
Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3
0:05:44
Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)
0:13:41
15 Minutes Masterclass: Quick Revision of Querying and SQL Functions | Class 12 IP
0:10:55
All SQL Fundamentals Explained in 10 Minutes | Learn SQL Basics for Beginners | SQL Crash Course
1:31:06
Querying and SQL Functions - Chapter Overview & Introduction | Class 12 Informatics Practices Ch...
0:05:57
Secret To Optimizing SQL Queries - Understand The SQL Execution Order
0:10:01
📅 Date Functions in SQL – Part 18 | SQL Tutorial for Beginners 〽️
0:24:55
SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial
0:10:13
SQL Window Functions in 10 Minutes
0:44:57
SQL Tutorial for Beginners
0:09:47
6 SQL Joins you MUST know! (Animated + Practice)
0:00:18
81 Find second highest salary from employee table using SQL? #interviewquestions #javaprogramming
0:49:56
Learn how to write SQL Queries(Practice Complex SQL Queries)
0:40:31
Chapter 1 Class 12 IP Querying and SQL Functions/ Math/String/Date and Time Functions NCERT Book
0:01:00
Data Analysis SQL Interview Questions | Running SUM | Who Hit the Sales Target First
0:06:43
5 Basic SELECT Statement Queries in SQL
0:00:58
Data Analyst SQL Interview Question | Window Functions | Moving Average #sqlinterview #dataanalysis
0:00:23
SQL Query to Calculate The Difference Between Two Dates? SQL Interview Questions And Answers #SQL
1:37:51
Querying & SQL Functions - One Shot Revision | Class 12 Informatics Practices Chapter 1 (2022-23...
0:00:55
Coalesce function in SQL with best examples #sql #shorts #coding #sqlqueries #sqlserver
0:00:37
SQL | Windows Vs Aggregate Functions
0:01:01
🤔 Find Nth Highest Salary sql #sql #sqlinterviewquestionsandanswers
Комментарии