What is Relational Database-Hindi/Urdu | LEC-73 | What is SQL | AWS Database | AWS RDS

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 : [e-mail]
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

[@ayeshanaim5440]

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 .

[@ashupakasma]

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.

[@maimoonamirza5626]

pls take care of ur back pain.felt bad at that point.u r are great human being i can see.....

[@heenasejwal6953]

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

[@Cut_edits-4hk]

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.

[@MonikaArya2008]

Sir hatsoff to you.. How easily you explain everything.. Kash hamare bachelor's and masters time pe b apki videos hoti...

[@admnaidu7040]

#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 🙏🤝

[@monu-ys8lp]

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.

[@najafashah]

You are so good teacher. You made topics so easy to understand. Thank you for your lectures,

[@shamashahbaz3200]

data :piece of information database:collection of related data dat warehouse:used to analyze the data

[@makarandgawade2522]

Thanks a lot for explaining everything in hindi. Thus breaking language barrier. You are doing Fabulous work.

[@mrmarlborian]

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.

[@amarsyadav3443]

Hi Hussain, Have u completed AWS SA CERTIFICATION? PLEASE LET ME KNOW

[@divyesingh4329]

Best Hindi IT teacher pata nahi coaching centre vala asa pdhana kab sikhanga

[@MoizYousaf577]

Great lecture-------------My Favorite lecturer

[@AsmaKhan-qf6gd]

Million times better than my university teachers😀😀😀😀

[@digitalproductsbusiness226]

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

[@sayyedsalman5763]

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..

[@travelbuffshraddha]

Nice sir bhot ache se smjha diya apne tq so much 🤗 ayese hi padhate rahe hame ❤️

[@vaibhavpalve7234]

Finally you uploaded database series and lots of thank you for this sir

[@PawanGupta-rr8wm]

Thank you sir Let me fight with exam and Interview.... definitely you r in my duaaaaa 🙏🙏🙏🙏🙏🙏

[@basantaswain4636]

sir your are best teacher and your videos maters everything for me🙏

[@learngermanmitlovish4891]

Very informative and explanatory videos.

[@KundanKumar-nn7ho]

Thank you so much for back to back upload your videos. You are great teacher. Upload devopps videos please

[@sumitgupta2839]

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

[@diveshvashisth8521]

One of the best computer teacher in youtube 😊

[@sujeetprajapati6876]

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

[@engrfaiznadeem3206]

you are the best sir. tomorrow is my paper and you taught me well I hope i can do well in paper

[@engrfaiznadeem3206]

plz pray for me so i can perform well in paper

[@ashutoshdixit9598]

You are most dedicated lecturaler

[@sachinrajbhar2632]

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

[@cometolife231]

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

[@dhrgaming7160]

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.

[@jayantanath9]

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 .

[@ankitakumari2756]

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.

[@priyach9089]

Awesome Lecture! I love you Sir!

[@MrLuckydilse2007]

Awesome way of explanation and examples in the simplest manner, Thanks a lot for all this stuff.

[@hirabutt2810]

Assalam o alaikum sir i wish i have a teacher like u in my collage u r a great 😇

[@seeshort9564]

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.

[@yogeshzende3952]

database is mainly used for recording and data warehouse is used for analyzing OLAP

[@vrajeshshah9832]

Your skil of explain is good for like me non technical person. Thank u 😊

[@atiyadoll8634]

Masha Allah sir bhot acha smjhate

[@akshayghadge8]

Database : where the customer apps. gets connected. (we get Income here) Data warehouse : where the employee apps. gets connected.(outcome)

[@vishukapoor7414]

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.

[@pavangupta16]

Great sir ji isi ka intezar tha.. Super sir ji..

[@nehajadhav8716]

Take care of your health sir. 🙂

[@anshikachandel3741]

Waaa baiii waaa mza aagya sir😊😊😊😊😊

[@karamjeetdalal3024]

Thankyou so much sir for very detailed lecture.....

[@parvezkhan-ou2fk]

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

[@terameradil5595]

Chaliye achchi bat h

[@sinhaabhyuday]

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.

[@anirbanchakraborty7563]

dadat base uses OLTP(online Transactional Process) but data warehouse use online analytical process

[@AnuragKaushik-up5wz]

great lecture bhupinder sir.

[@nobuddy7951]

amazing lecture .Thank you

[@subhashchandrachaurasia763]

Thanks a lot Sir for giving very good knowledge about data, database and DBMS

[@muhammadzohaib2878]

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.

[@MdShahbaz-hp5vo]

Very Helpful Sir. God Bless you ❤❤

[@prashantmohite5546]

database - is a systematic collection of data datawarehouse - is a collection of databases , used for analytics purpose

[@vedanshkumar2661]

Thank you sir 👌👌👌👌👌

[@archanam.2205]

Thanks sir..Please Take care of yourself.

[@NadeemKhan-po8zc]

amazing guru ji

[@MirzaEbrahimBaig]

Thank you sir...love from London

[@noblesingh9466]

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.

[@RaviGupta-vf2jt]

Awesome video

[@Rohitkumar-np7ss]

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....

[@tarunsingh2353]

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.

[@funandlearn7903]

Great lecture Sir

[@ronakagarwal435]

Sir videos fast upload kijiye.. I am from Bangalore.you are the best teacher in the world.

[@KundanSingh-ql7gt]

Great explanation sir

[@ashishhelgaonkar929]

Sir ek no explain kiya aapane 🙏

[@nathsambu]

very informative as usual. Thanks you for making this video. :)

[@sureshpant3700]

Database is collection of information or data. Warehouse is collection of database.

[@gauravsaini5267]

I enjoyed the session...thxx for nice explanations...

[@ISHANICUTIEPIE]

Nice Lecture..

[@rishikeshkumar6590]

Thank u guru ji for this video 🙏

[@nigamharsh3]

Very nice session sir ..thanks

[@ManojGuptahome]

excellent explanation. Data warehouse sounds like historical data which may or may not be relational. it might just be a dumping ground of archival.

[@udayrajudayraj1575]

Akdam jhakkas sir thank you sir

[@ashishwali3436]

you are too Good Sirji.

[@dhanukumarsingh1884]

Data warehouse is type of database ,it Store and retrieved history of different sources like faxpro,ERP,SAP,tally

[@anilj6399]

Thank you so much well explained about RDS ,🙏🙏🙏🙂

[@mudasir4u]

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.

[@sonusuparna]

OTLP database is in which Transaction are happening. Dataware is used for reporting purpose.

[@shaneyahmad4997]

Love your consistentency and hard work

[@quickandeasy5403]

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.

[@rupakmahto2095]

Database for transactions, Data Warehouse for analysis

[@maheshprasad6989]

yes good understand

[@atuldharwal2198]

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.

[@nikitamagdum5696]

Kash college me apke ke jaisa padhaya hota....hum aaj kis level Pe pahunch jate

[@sandipansarkar9211]

Finished watching

[@khanalam123]

Great sir!

[@pranaybwm]

The explanation is excellent.

[@uzairkhan-sd4kx]

Awesome bro

[@8010312335]

Really great information sir...

[@rishiporwal9193]

Best teacher in it 👍👍

[@vikasnaik3995]

Thankyou Sirji

[@parvejkhancse]

Awasome sir...2 vidoes in a single day.....congratulation sir ...1lakh subscriber is very close...good luk from our end..

[@gauravsaini5267]

Database is use to store the data, datawarehouse is use to analyse the data....

[@nitindarade8033]

superb teaching style

[@imranhabib3736]

Thnk u for this lecture

[@hammadchohan6129]

database use to store related data and data warehouse is used to analyse data collected from multiple sources

[@shahnawazalam8648]

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.