Hello TFQ.. Really loved the way you teach SQL concepts. It would be great if you could make videos on Trigger, Cursor, Function, Index, Record, Exception Handling, Package and Partitions. It would be of immense help for every aspiring data scientists.
Hey dear, god bless your efforts in this channel. I have a general enquiry as a new sql learner. How could i create a pipeline to extract and load data from existing accounting program into our SQL server instances. How can i know if the export mechanism in the software permits me to undertake this extraction process, and how can i know if an application have an api? Thanks for taking care of my enquires. Looking forward to gain more knowledge from you.
Good summary. Two important items. 1) The materialized view is essentially a normal table under the hood with query logic for populating it thus you can index it, etc. 2) The data is basically static until you refresh it at which time it's flushed and the data is replaced by the result of the query at the new run time. They're particularly good when the performance to run the query is poor but the data doesn't have to be exact or up to the last second. For example, if you wanted to run a query that generates a report for the previous day you could create the materialized view to get the data from yesterday and run it on a schedule after midnight. Then the user can query the materialized view with a select * in the morning and get quick results without waiting on the query to execute against the base data. Sometimes it makes sense to have the materialized view to contain most of the result set and then some optimized query to just pull data from the current day, hour, etc. and union the results together.
Hi techTFQ, thanks for uploading amazing video, I learned a lot from you. And now I have a question. I am confused about these syntax: - create view - create materialized view - create temporary table - with clause These syntax can store a subset data to reuse then, but when to use it? I knew we can use With clause when using specific subqueries many times but how are other syntax? Thank you so much.
Learnt from you previous video instead of generate_series() function we can use Recursive . CREATE TABLE random_for_matvw ( id INT PRIMARY KEY, value INT ); WITH RECURSIVE rand(id, value) as ( SELECT 1 as id, 1 as value UNION ALL SELECT id + 1, value + 1 from rand where id < 100000 ) INSERT INTO random_for_matvw(id,value) SELECT id, value FROM rand;
Thank you! So, as I understood, matetrialized view is a kind of cache. It store query and it's result. Menwhile a just view stores query only. Nevermind, just my synopsis 😅
Hello Toufiq, I hope you are doing good. I'm learning PL/SQL for almost last 6 months now but i have struggled to hold grasp on PLSQL concepts but after watching your videos and how clearly you explain i was able to understand very good. Like your video on Materialized View i knew how it work but after watching your video i understood the concept fully. I would really thank you for your work. Same goes with Procedure, Joins. I have a request if you could make PLSQL videos on Trigger, Cursor,Function,Index,Record,Exception Handling,Package and other if you could. Thanks for the awesome work you are doing.
@@techTFQ my request also same sir please make videos for all the important components your explanation is very good iam from telugu I don't know English very well but i understand your English it is very simple and understandable
Hello Brother, Awesome explanation with clarity.Please do video for mviews on oracle DB with many types of refreshes as you said and also can we have a view or mview on DML's instead of sql queries?
I like the way you explain each and every concept in detail.If I don't understand any concept in SQL, I immediately switch to your channel and it really helps.
Bro, I don't have complete knowledge in mv views, only a little bit, if possible make a video for oracle mviews refresh method and auto refresh features how it's working. Thanks in advance.
Some database systems, like SQL Server with indexed views, maintain the materialized view in real-time. Any changes to the base tables are immediately reflected in the materialized view. This means the view is always up-to-date,
Hello TFQ , Thanks a lot for all the knowledge you share. can you create a list using SQL for data engineering purposes pls, it would be great to see how you address this topic. Regards from Mexico !!!
Took a while to figure out what you were saying when you're saying view - sounds like veev... LOL I can see a number of usual uses of materialized views.
What’s the difference between a materialized view and a simple table structural?? Obviously you don’t have to create a table in data base instead you create a materialized view
Hi sir, Great work 👍 Really it's very helpful for learners like me... Expecting video by explaining Oracle materialized view concepts and refreshing methods too
Hi , i remember oraclr offering free entperse edition of oracle 21c (non-commercial use only), but i cant find the same equivalent for 23c since the 23c develop edition haa 12gb ram limit.
It the the best tutorial for understanding. I'm really glad that I can recognize English speech because in my native language I didn't find any information about. Author, thank you!
Thanks a lot🙏 u are doing unique work... please add more information integration and application videos in ur playlist...it will be great help...I am phd cse in IIIT Delhi...ur videos are helping 🙂add data warehousing view, virtual view etc if u will add more IIA videos I will suggest this channel to no of my classmates🙏
You will need to enable international payment on your card.. you can call you bank to do it. If that also does not work then Please msg me in discord , I will share other payment link..
Yes you can schedule auto refresh of MV.. One as Swapnil said above and also we have create a function or procedure to do the refresh and execute function inside the trigger and schedule the trigger when base table updates .. And there are other ways too..
At the time of creating mv views we can give auto refresh, we have used the below query CREATE MATERIALIZED VIEW mv_name REFRESH COMPLETE ON DEMAND START WITH TO_DATE('specific date with time', 'Date format') NEXT (Next refresh time) AS "select statement "; It is oracle sql based, i don't know how about postgresql, If any in postgresql kindly share. CREATE MATERIALIZED VIEW mv_name REFRESH COMPLETE ON DEMAND START WITH TO_DATE('09-07-2022 13:00:00', 'DD-MM-YYYY HH24:MI:SS') NEXT (SYSDATE+6/24) AS SELECT EMPLOYEE.NAME FROM EMPLOYEE; It will refresh data every six hours. Thanks in advance..
all your videos are very simple and helpful. Thank you. Can you please create a video on oracle performance tuning tips and also on how to partition oracle tables to improve sql performance
awesome Tafaq .. thanks alot .. please continue sessions on Materialized views .. with all refresh methods .. it is very nice of you. Thanks once again
Hi there! in this query has not worked in Microsoft sql server Database insert into random_tab select 1,rand() from GENERATE_SERIES(START = 1, STOP = 10) please try to explain on Ms SQL server
Extremely helpful video, I didn't know nothing about views, and now I feel like an expert. THANK YOU SO MUCH
Hi Tfq, your explanation about the concept is very good. Could you please upload the separate video for Oracle materialized view and view? Thanks
Thank you and noted bro
Hello TFQ.. Really loved the way you teach SQL concepts. It would be great if you could make videos on Trigger, Cursor, Function, Index, Record, Exception Handling, Package and Partitions. It would be of immense help for every aspiring data scientists.
very nice. Even though I am a PM and do not work technically on SQL , I could understand the concepts. Keep up the good work
The way you have explained it is amazing and thanks for this incredible content.
Short, simple & easy to understand. Thanks Taufiq!
In my work area we refresh the materialized view twice a day. One in the morning and one in the evening.
Pls do the video on materialized view covering oracle
This was a great video to watch, thank you! Please do make a video on how Oracle materialized views have more functionalities than Postgres :)
Your welcome and sure wil do
Excellent Sir.I really appreciate your effort
Bro, you're awesome. Very clearly explained
👌🏻👌🏻👌🏻👌🏻👌🏻on point
Thank you 🙏🏼
Hello TFQ - what's the difference between Materialized Views and TEMP tables?
Hello , your videos are really helpful, please do a video on MS SQL materialized views
Noted bro
Plz make a video on Oracle materialized view
Thanks for making video.....
Please make video for Oracle on both the views in detail
Noted bro
Sir, Kindly make a video on Materialized views in Oracle also.! Thanks for explanation!
Sure will do it, thank you
Thanks for the explanation...please make video on oracle as well.
your welcome and sure will do
Explained Very well,Thanks
Yes, Please cover materialized view in Oracle.
Noted Kavi
Hey dear, god bless your efforts in this channel.
I have a general enquiry as a new sql learner.
How could i create a pipeline to extract and load data from existing accounting program into our SQL server instances.
How can i know if the export mechanism in the software permits me to undertake this extraction process, and how can i know if an application have an api?
Thanks for taking care of my enquires.
Looking forward to gain more knowledge from you.
Can you make a video on registered servers and stored procedures creation and execution
please make a video of materialized view for Oracle. thank you.
Hi pls create a materialized view video on Oracle database as well
Just Wow.. Thank you.
Great explanation. When are you going to conduct live sessions again?
Thank you, can you kindly make one for Oracle? had problem refreshing mv in Oracle
Very well explained 👍
Please make a video on temp table on Oracle
Really awesome 😎😎
Please Cover Materealized view with Oracle
Hi I would be interested in Materialized Views in Oracle and which options are at hand there.
hello toufiq,
can you please cover this video in oracle sql
This video is nice
thanks
can we update the views ?
Nice Bro
do the video in SQL SERVER, please
Can I pay through net banking?
Card is not allowing me to pay for August 3rd cohort?
You will need to enable international payment on your card.. you can call your bank to enable it ..
Many have done it and it got fixed immediately
@@techTFQ i will check that to pay
Thank you 👍
Ok bro
@@techTFQ i will join on Saturday bro.
Cool buddy
why you say 'viv'? and not view?
no shot 2 minutes in im still listening to a scam offering
yes need materialized view in oracle
Please make a video on oracle materialised view.
Noted bro will do
@@techTFQ thanks brother
Good summary. Two important items.
1) The materialized view is essentially a normal table under the hood with query logic for populating it thus you can index it, etc.
2) The data is basically static until you refresh it at which time it's flushed and the data is replaced by the result of the query at the new run time.
They're particularly good when the performance to run the query is poor but the data doesn't have to be exact or up to the last second. For example, if you wanted to run a query that generates a report for the previous day you could create the materialized view to get the data from yesterday and run it on a schedule after midnight. Then the user can query the materialized view with a select * in the morning and get quick results without waiting on the query to execute against the base data. Sometimes it makes sense to have the materialized view to contain most of the result set and then some optimized query to just pull data from the current day, hour, etc. and union the results together.
you can also refresh the MV using a function and run that function from a trigger based on some conditions.
pls post a video on materialized view in oracle
Hi techTFQ, thanks for uploading amazing video, I learned a lot from you. And now I have a question.
I am confused about these syntax:
- create view
- create materialized view
- create temporary table
- with clause
These syntax can store a subset data to reuse then, but when to use it?
I knew we can use With clause when using specific subqueries many times but how are other syntax?
Thank you so much.
Hi Pham,
I understand your confusion but difficult to explain it in comment here.. perhaps will do in a video
@@techTFQ Happy to wait and thank you so much ^^
Learnt from you previous video instead of generate_series() function we can use Recursive .
CREATE TABLE random_for_matvw (
id INT PRIMARY KEY,
value INT
);
WITH RECURSIVE rand(id, value) as (
SELECT 1 as id, 1 as value
UNION ALL
SELECT id + 1, value + 1 from rand where id < 100000
)
INSERT INTO random_for_matvw(id,value) SELECT id, value FROM rand;
Thank you! So, as I understood, matetrialized view is a kind of cache.
It store query and it's result. Menwhile a just view stores query only.
Nevermind, just my synopsis 😅
Nicely explained. Thanks
Hello Toufiq, I hope you are doing good. I'm learning PL/SQL for almost last 6 months now but i have struggled to hold grasp on PLSQL concepts but after watching your videos and how clearly you explain i was able to understand very good. Like your video on Materialized View i knew how it work but after watching your video i understood the concept fully. I would really thank you for your work. Same goes with Procedure, Joins. I have a request if you could make PLSQL videos on Trigger, Cursor,Function,Index,Record,Exception Handling,Package and other if you could. Thanks for the awesome work you are doing.
Hi Achal, I am fine and thank you 🙏🏼
Noted on the request, I’ll plan it
@@techTFQ my request also same sir please make videos for all the important components your explanation is very good iam from telugu I don't know English very well but i understand your English it is very simple and understandable
Thank you Nirmala 🙏🏼
I will plan it
Hello Brother,
Awesome explanation with clarity.Please do video for mviews on oracle DB with many types of refreshes as you said and also can we have a view or mview on DML's instead of sql queries?
I like the way you explain each and every concept in detail.If I don't understand any concept in SQL, I immediately switch to your channel and it really helps.
Great Explanation, also Pronunciation for View is "vu" 😊
Thanks & noted
Bro, I don't have complete knowledge in mv views, only a little bit, if possible make a video for oracle mviews refresh method and auto refresh features how it's working.
Thanks in advance.
Noted bro and will do
beautiful explained, fundamentals of MV & how it can be really powerful in analytics use cases :)
Great video.. Pls consider making video for materialised view in oracle and it's different functionality.. Cheers!!
Thank you and noted bro
@@techTFQ Thanks Sir. Please make video for materialized view in Oracle.
Thanks for this wonderful video. Please do create video on Oracle materialized view and it's refresh types.
Thanks in advance.
Noted and will do
Spell it correctly bro, it view not weave _/\_
Some database systems, like SQL Server with indexed views, maintain the materialized view in real-time. Any changes to the base tables are immediately reflected in the materialized view. This means the view is always up-to-date,
Hi tfq, worth watching . It was great and clear. Thanks for the video.
Glad this helped
Thanks for explaining concepts so clearly and simplifying complexed ones!
Also can you make videos on Group by extensions (rollup, grouping sets.cube)
Hello TFQ , Thanks a lot for all the knowledge you share.
can you create a list using SQL for data engineering purposes pls, it would be great to see how you address this topic.
Regards from Mexico !!!
One doubt is , i have heard somewhere that materialized view can be created only for single table in sql query is it true?
Took a while to figure out what you were saying when you're saying view - sounds like veev... LOL
I can see a number of usual uses of materialized views.
What’s the difference between a materialized view and a simple table structural?? Obviously you don’t have to create a table in data base instead you create a materialized view
But why would I create a materialized view rather than create a table? What's the difference? It seems like they do quite similar things.
Hi sir, Great work 👍 Really it's very helpful for learners like me... Expecting video by explaining Oracle materialized view concepts and refreshing methods too
Thank you Nalini and will do that soon
Hi , i remember oraclr offering free entperse edition of oracle 21c (non-commercial use only), but i cant find the same equivalent for 23c since the 23c develop edition haa 12gb ram limit.
Please make a video how to execute materialized view in oracle, Microsoft sql server, mysql workbench
how the temp table is different from them, I mean it also stores the data for a particular session, and materialized view does the same thing..
If an employee implements materialized view...
In general what can i expect the experience of that employee...?
Depends.. generally 2+ yrs
Can we create a Materialized view over normal view, how does this internally work. How would be the performance.
It the the best tutorial for understanding. I'm really glad that I can recognize English speech because in my native language I didn't find any information about. Author, thank you!
Thanks a lot🙏 u are doing unique work... please add more information integration and application videos in ur playlist...it will be great help...I am phd cse in IIIT Delhi...ur videos are helping 🙂add data warehousing view, virtual view etc if u will add more IIA videos I will suggest this channel to no of my classmates🙏
sir your class videos are awesome ,i used to watch often sir if possible plz provide one or two classes on TRIGGERS AND JOB creation in postgresql
Please create a full course on SQL on the udemy platform. It will be beneficial for learners
Probably in the future bro
Hi TFQ...what about materialised views in MSSQL...
bro can you explain about array and struct plz i waiting for the videos
In Qlik we use qvd the same way, and incremental load if need.
This video helpfull but not that much, so please make new video MV and refresh in Oracle. Thanks 🙏🙏🙏
Noted Vishal
Your videos are really helpful and clear the concepts. Please make a series on pl/sql
Noted Bindiya
If possible can you please make separate video of oracle views.
It was really nice explanation. Yaa could you please create video for oracle
Hi Tofiq! I wanted to know how it works in SQL SERVER?
What is the difference between a materialized view and a temporary table?
A materialized table isn't temporary.
I’ll make separate video about it
Can you please make a video on Indexed Views in Sql server
Materialise table using select*into ?? what does it means plss help me !
The BEST Training for SQL learners, the teaching concepts are "JUST AMAZING"
Pls post a video about execution plan cardinality optimization
THERE IS ANY OTHER WAY TO PAY YOU IN COURSE FOR SQL QUIRES BECAUSE I HAVE PAPPAK CARD ONLY AVAILABLE IN PAKISTAN
You will need to enable international payment on your card.. you can call you bank to do it.
If that also does not work then Please msg me in discord , I will share other payment link..
Hi Thoufiq. May I know if the materialized view applicable to MS SQL and My SQL?
Yes Tony, it is present in both these DB’s
Could you please explain Oracle MV in detail ?
Hi can u please do video on materialized views in Oracle
Very clear video ... Please show us materialized view in Oracle
Thank you so much Toufig
Your welcome buddy and sure will do
Hey, can we write some line of code to automatically refresh like on each day the mv gets updated. Thanks in advance
You can create a cron job to refresh MV at specific interval of time each day
Yes you can schedule auto refresh of MV..
One as Swapnil said above and also we have create a function or procedure to do the refresh and execute function inside the trigger and schedule the trigger when base table updates ..
And there are other ways too..
@@swapnilsolanki8595 Thank you
@@techTFQ Thank you
At the time of creating mv views we can give auto refresh, we have used the below query
CREATE MATERIALIZED VIEW mv_name REFRESH COMPLETE ON DEMAND START WITH TO_DATE('specific date with time', 'Date format') NEXT (Next refresh time) AS "select statement ";
It is oracle sql based, i don't know how about postgresql, If any in postgresql kindly share.
CREATE MATERIALIZED VIEW mv_name REFRESH COMPLETE ON DEMAND START WITH TO_DATE('09-07-2022 13:00:00', 'DD-MM-YYYY HH24:MI:SS') NEXT (SYSDATE+6/24) AS SELECT EMPLOYEE.NAME FROM EMPLOYEE;
It will refresh data every six hours.
Thanks in advance..
all your videos are very simple and helpful. Thank you. Can you please create a video on oracle performance tuning tips and also on how to partition oracle tables to improve sql performance
thank you and noted on the request bro
Hi pls create videos on indexes and constraints in SQL
awesome Tafaq .. thanks alot .. please continue sessions on Materialized views .. with all refresh methods .. it is very nice of you. Thanks once again
Thank you and noted bro
please the text editor / IDU u are using sir... or someone else, please tell..!!
Its PostgreSQL database and PgAdmin IDEA
Hi there!
in this query has not worked in Microsoft sql server Database
insert into random_tab
select 1,rand() from GENERATE_SERIES(START = 1, STOP = 10)
please try to explain on Ms SQL server
Hello, Please make video on oracle database also...