What is Relational Database-Hindi/Urdu | LEC-73 | What is SQL | AWS Database | AWS RDS
HTML-код
- Опубликовано: 26 авг 2024
- AWS DATABASE FUNDAMENTALS LEC-73
This lecture is important to build your concepts and a better understanding on database.
Relational databases are at the heart of your most critical applications, but they can become difficult to manage and operate with high availability as you scale your app. Database administration is resource-intensive, taking time away from building your application. Amazon Relational Database Service (RDS) simplifies database management by automating time-consuming administration tasks. Amazon RDS gives you the freedom to use your relational database of choice, Including the most popular commercial and open source engines, and Amazon’s relational database built for the cloud: Amazon Aurora. Aurora is MySQL and PostgreSQL-compatible, and offers the performance and availability of traditional commercial databases at a fraction of the cost. Amazon DynamoDB is a fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale. It is a fully managed cloud database and supports both document and key-value store models. Its flexible data model and reliable performance make it a great fit for mobile, web, gaming, ad tech, IoT, and many other applications. Amazon DynamoDB Accelerator (DAX) is a fully managed, highly available, in-memory cache that can reduce Amazon DynamoDB response times from milliseconds to microseconds, even at millions of requests per second.
Do subscribe to TECHNICAL GUFTGU channel and Press Bell icon & get regular updates on videos, DIRECT LINK TO CHANNEL : / technicalguftgu
Here are direct links of My All the Playlist: MUST CHECK
IPv6 Complete Tutorial for beginners Link : • IP Version 6 Tutorials...
Microsoft Azure Tutorial for beginners in Hindi/Urdu AZ-103 and AZ-900 LINK : • Microsoft Azure Tutori...
Cloud computing tutorials For beginners Link : • Cloud Computing Tutori...
AWS Solution Architect-Associate complete Tutorials Link : • AWS Solution Architect...
CCNA Complete Tutorials /Computer Networking Link : • CCNA Full course in Hi...
This is the best channel for AWS Tutorials, Microsoft Azure tutorials, 2G,3G, LTE, CCNA, Cloud computing and for others topics related to cloud and computer networking. Technical Guftgu is the only platform, which provides you entire training on white board, so that you feels that, you are taking real time training.
Bhupinder Rajput Sir is having 8 Years of Experience in the field of technical trainings in entire india.
NOTE : If you would like to organise Bhupinder Rajput Sir workshop in your College or University, write mail to us.
For More Information:
Please write us at : technicalguftgu99@gmail.com
Connect with us on facebook page-Technical Guftgu for his upcoming 5 Days workshops on cloud in india and Nepal. If you would like to donate and give support to our Channel, write mail to us.
Thanks For giving Your Valuable time.
Regards,
Technical Guftgu Team
Very Worthwhile material .EXCELLENT. Thank you . Database is (OLPT) Transactional whereas Data Warehouse is (OLAP) Histtorical. This is main diffrence between DATABASE and DATA WAREHOUSE. Ayesha .
Again great lecture on Database. Thanks..
Database is a collection of related data that represents some elements of the real world whereas Data warehouse is an information system that stores historical and commutative data from single or multiple sources.
Database is designed to record data whereas the Data warehouse is designed to analyze data.
Database is application-oriented-collection of data whereas Data Warehouse is the subject-oriented collection of data.
Database uses Online Transactional Processing (OLTP) whereas Data warehouse uses Online Analytical Processing (OLAP).
Database tables and joins are complicated because they are normalized whereas Data Warehouse tables and joins are easy because they are denormalized.
ER modeling techniques are used for designing Database whereas data modeling techniques are used for designing Data Warehouse.
pls take care of ur back pain.felt bad at that point.u r are great human being i can see.....
Sir hatsoff to you.. How easily you explain everything.. Kash hamare bachelor's and masters time pe b apki videos hoti...
Thank you Dear Sir, very useful lecture for me specially when I am preparing for Public Service Commission test for Lecturer in PAKISTAN. GREAT GREAT GREAT JOB. I really appreciate you by my heart.
Database is Systematic collection of data designed to record for an application
Data Warehouse is Collection of all data that is used for analysis of business and subject oriented
Hi there, Amazing way of teaching . I am coming back to refresh my knowledge and nothing better than your lectures. So much thanks for the great work available for us. I am preparing for AWS SA and always come to your channel before studying any topic. Thanks once again and stay blessed.
Hi Hussain,
Have u completed AWS SA CERTIFICATION?
PLEASE LET ME KNOW
#Database:-Are organization collection of stroted data.
#data warehouse:-Are information system built from multiple data sources used to analyze data.
#thanks 🙏 for sharing this knowledge on free.love 😍 a lot. I'm learning✍️ more and more day by day from your class during this pandemic 🙏🤝
Database- Used for storing data from one or a limited number of applications or sources.
Data wrehouse- Used for aggregating data from many different data sources, and make that data available for visualization, reporting, and analysis
and what i read in this tutorial is..
Horizontally scale-In/Out- Increse/decrease the no. of servers.
Vertically Scale-In/Out- Increase/decrese memory in already existing servers.
and the main perpose in this tutorial is.. we can not perform horizontally scale-In/Out for database.
and last you are the my best teacher in my life sir ji. please complete AWS tutorial for associate level soon as possible and after that please upload some scenerio based real time project on AWS so that we become fully confident for the inetrview and we could proudly say.. yes I'm am learned from Bhupinder sir a great tutor.
Great lecture-------------My Favorite lecturer
You are so good teacher. You made topics so easy to understand. Thank you for your lectures,
Nice sir bhot ache se smjha diya apne tq so much 🤗 ayese hi padhate rahe hame ❤️
Sir your all lectures are awesome and i request you to make lecture videos on Web application and SSL/TLS
You are the best and your explaination is too good
data :piece of information
database:collection of related data
dat warehouse:used to analyze the data
AMAZING LECTURE .....SIR YOUR METHOD OF TEACHING IS FABOLUS YOU KNOW VERY WELL HOW TO TEACH A STUDENTS BASICALLY I AM FROM PAKISTAN BUT REGULARLY I SEEN YOUR LECTURS
Jazakallahu khair.. Bhupinder bhai..
Meri dua hai apke liye.. That You get what you desire and what you deserve..
Thank you very much for your selfless efforts..
Thanks a lot for explaining everything in hindi. Thus breaking language barrier. You are doing Fabulous work.
Thank you sir
Let me fight with exam and Interview.... definitely you r in my duaaaaa 🙏🙏🙏🙏🙏🙏
Million times better than my university teachers😀😀😀😀
Best Hindi IT teacher pata nahi coaching centre vala asa pdhana kab sikhanga
sir your are best teacher and your videos maters everything for me🙏
Finally you uploaded database series and lots of thank you for this sir
Very informative and explanatory videos.
Thank you so much for back to back upload your videos. You are great teacher. Upload devopps videos please
Assalam o alaikum sir i wish i have a teacher like u in my collage u r a great 😇
in simple words database generally recording of data in a systematic manner . and data warehouse generally mean keeping of all the data in a large store room for further use . . as for example . suppose we produce different types potato and kept in different bins in order to identify its different types . which can understood as database . and keeping the entire collection of stored potato of different bins in to the large store house or cold storage can be understood as data ware house .
dadat base uses OLTP(online Transactional Process) but data warehouse use online analytical process
database is mainly used for recording and data warehouse is used for analyzing OLAP
Database System is used in the traditional way of storing and retrieving data.
Data Warehouse is a place where a huge amount of data is stored. It is meant for users or knowledge workers in the role of data analysis and decision making. Sujeet
you are the best sir. tomorrow is my paper and you taught me well I hope i can do well in paper
plz pray for me so i can perform well in paper
One of the best computer teacher in youtube 😊
Waaa baiii waaa mza aagya sir😊😊😊😊😊
You are most dedicated lecturaler
Amazing content delivery sir - Easy to understand, I'm not from technical background but still can understand. God bless - Will continue to learn from you
Database is an organised collection of stored data used for manipulation ,retrival as per use.
Dataware house is also a database system in which data stored is historic and used for analysis.
database is a collection of data that represents some element or object, data base is designed to record data, processing method of database - OLPT.
Whereas data warehouse stores historical and commutative data from sinhle or multiple sources , processing method of database - OLAP
Major Differences Between Databases and Data Warehouses Explained. The main difference is that databases are organized collections of stored data. Data warehouses are information systems built from multiple data sources - they are used to analyze data.
Awesome Lecture! I love you Sir!
great lecture bhupinder sir.
data base are mainly used for recording the data and in warehouse we can analyzing data,, data base used for read and write purpose in warehouse we can run in query on the basis data
Database is a collection of related data that represents some elements of the real world whereas Data warehouse is an information system that stores historical and commutative data from single or multiple sources.
Masha Allah sir bhot acha smjhate
amazing lecture .Thank you
Your skil of explain is good for like me non technical person. Thank u 😊
Take care of your health sir. 🙂
Database vs Data Warehouse:
Database is a systematic collection of data. But Data Warehouse is the place where huge amount of data is stored. It is used for dicision making for specific purpose.
A database is any collection of data organized for storage, accessibility, and retrieval. A data warehouse is a type of database the integrates copies of transaction data from disparate source systems and provisions them for analytical use.
walekum aslam, please finish the course as soon as posible .dont worry about views who are sincere to learn aws they definetly waiting for your lecture.
Thank you sir...love from London
Thankyou so much sir for very detailed lecture.....
Awesome way of explanation and examples in the simplest manner, Thanks a lot for all this stuff.
Thanks sir..Please Take care of yourself.
amazing guru ji
excellent explanation. Data warehouse sounds like historical data which may or may not be relational. it might just be a dumping ground of archival.
Well, data warehouse is also a type of database - but it has a specific use that separates it from normal databases.
It is used for logical decision making, instead of simple retrieving of information from a row in a table.
This means it’s a bit complicated and involves multiple queries to arrive at a logical result.
This makes data warehousing an extremely important thing in practical business sense.
As an example, Databases enable McDonald to figure out annual sales, but data warehousing tells them what areas are in vegetarian dominated areas.
Very nice session sir ..thanks
Great lecture Sir
Great explanation sir
Awesome video
Nice Lecture..
Great sir ji isi ka intezar tha..
Super sir ji..
Database is collection of information or data.
Warehouse is collection of database.
Chaliye achchi bat h
Thank you sir 👌👌👌👌👌
database - is a systematic collection of data
datawarehouse - is a collection of databases , used for analytics purpose
Thank u guru ji for this video 🙏
Sir videos fast upload kijiye.. I am from Bangalore.you are the best teacher in the world.
Akdam jhakkas sir thank you sir
Thanks a lot for Uploading these videos Sir...I was waiting eagerly for your lectures....Sir please...one Request ..after completing complete series of AWS ..Make some videos on AWS also...That would be very grateful sir..love u Sir....and we are always with u Sir....
you are too Good Sirji.
Database : where the customer apps. gets connected. (we get Income here)
Data warehouse : where the employee apps. gets connected.(outcome)
Very Helpful Sir. God Bless you ❤❤
Data warehouse is type of database ,it Store and retrieved history of different sources like faxpro,ERP,SAP,tally
Awesome bro
OTLP database is in which Transaction are happening. Dataware is used for reporting purpose.
Great sir!
Thanks a lot Sir for giving very good knowledge about data, database and DBMS
A database is a collection of data that is used by applications in real-time to store data and perform queries to get information. We can say a Database is leaner to real-time programming. However, a Data warehouse is also a Database but it is huge in size, and various sources are connected for storing data. Data Warehouse is primarily used for Business intelligence and decision making.
The main difference is that databases are organized collections of stored data. Data warehouses are information systems built from multiple data sources - they are used to analyze data.
sir please give a video on AWS ElasticBeanstalk. we learn lots of think in aws from your channel. thanks
I enjoyed the session...thxx for nice explanations...
Kash college me apke ke jaisa padhaya hota....hum aaj kis level Pe pahunch jate
Finished watching
Awasome sir...2 vidoes in a single day.....congratulation sir ...1lakh subscriber is very close...good luk from our end..
Sir ek no explain kiya aapane 🙏
very informative as usual. Thanks you for making this video. :)
database use to store related data and data warehouse is used to analyse data collected from multiple sources
Data warehouse is design to analyze data .. and Database is a collection of related data
Thnk u for this lecture
Database is a collection of related data that represents some elements of the real world whereas Data warehouse is an information system that stores historical and commutative data from single or multiple sources. Database is designed to record data whereas the Data warehouse is designed to analyze data.
A database stores the current data required to power an application whereas a data warehouse stores current and historical data for one or more systems in a predefined and fixed schema for the purpose of analyzing the data.
Database is use to store the data, datawarehouse is use to analyse the data....
yes good understand
superb teaching style
Thank you so much Sir❤❤❤
Hi.. Database is the current data stored by application and data warehouse is the one were the current and historical data available
Nice video
Database for transactions, Data Warehouse for analysis
In Database we keep current data and in Datawarehouse we keep old data. It is used for analytics purpose also.
A Database is Systematic Collections of Data, Whereas Data Warehouse is built to store large quantities of historical data and enable fast, complex queries across all the data.