- 30
- 51 740
Database Academy
India
Приєднався 3 бер 2020
Thanks for watching my channel. Please do subscribe and comment your experience.
High quality tutorials that are fun, educational, and easy to follow. Teaching programming is my passion! I find joy in making complex material easy to understand. I have 15 years of experience in Oracle, Postgres and Sql server database. I have decided that it is only right to upload videos of great quality and value. Here you will find videos on database design, SQL,PL/SQL, Postgres, Oracle Forms & Reports and more!
For those interested in personalized training, whether individual, group, or corporate, feel free to reach out. I offer training in SQL & PL/SQL, Forms & Reports, and Postgres. Let's elevate our programming skills together!
🚀💻 #programming #databasetutorials #sql #plsql #postgres #oracleforms
Mobile/WhatsApp : +91-9220970607
Email : ram5393@gmail.com
Thanks
Ram T
High quality tutorials that are fun, educational, and easy to follow. Teaching programming is my passion! I find joy in making complex material easy to understand. I have 15 years of experience in Oracle, Postgres and Sql server database. I have decided that it is only right to upload videos of great quality and value. Here you will find videos on database design, SQL,PL/SQL, Postgres, Oracle Forms & Reports and more!
For those interested in personalized training, whether individual, group, or corporate, feel free to reach out. I offer training in SQL & PL/SQL, Forms & Reports, and Postgres. Let's elevate our programming skills together!
🚀💻 #programming #databasetutorials #sql #plsql #postgres #oracleforms
Mobile/WhatsApp : +91-9220970607
Email : ram5393@gmail.com
Thanks
Ram T
SQL Tuning Tips: Boost Your Database Performance Part 2 | How to optimize SQL Queries | SQL Tuning
Unlock the secrets to faster queries and optimal database performance with these top SQL tuning tips. Whether you're a beginner or an experienced developer, these techniques will help you fine-tune your SQL queries for speed and efficiency. Subscribe to Database Academy for more essential database insights and tutorials!
#coding #oraclesql #sql #interview #sqltutorial #tuning
If you enjoyed the video, please give a thumbs up, comment, share.
Do not forget to SUBSCRIBE to this channel to get our new SQL and PL/SQL tutorials delivered straight to you each week!
Thank You :)
❤️ Let’s connect on social ❤️
LinkedIn:
lnkd.in/duvhWDuw
Facebook:
DatabaseAcademyRT
#coding #oraclesql #sql #interview #sqltutorial #tuning
If you enjoyed the video, please give a thumbs up, comment, share.
Do not forget to SUBSCRIBE to this channel to get our new SQL and PL/SQL tutorials delivered straight to you each week!
Thank You :)
❤️ Let’s connect on social ❤️
LinkedIn:
lnkd.in/duvhWDuw
Facebook:
DatabaseAcademyRT
Переглядів: 272
Відео
SQL Fundamentals Day 4: What is SQL Datatype ? ||SQL||Beginners|#sql #education #interview #plsql
Переглядів 44Місяць тому
Welcome to Day 4 of SQL Fundamentals on Database Academy! In this video, we kick off our journey into the world of databases. We start with the basics by answering the fundamental question: What is SQL Datatype? 🔍 In this video, you'll learn: Data Type define the value that column is going to store 📘 Resources: SQL Fundamentals Playlist Database Academy Website 📅 Stay Tuned: Don't forget to sub...
SQL Fundamentals Day 3: What is a Normalization? ||SQL||Beginners|#sql #education #interview #plsql
Переглядів 562 місяці тому
Welcome to Day 3 of SQL Fundamentals on Database Academy! In this video, we kick off our journey into the world of databases. We start with the basics by answering the fundamental question: What is a Normalization? 🔍 In this video, you'll learn: Normalization is a process used in database design to organize data in a way that reduces redundancy and improves data integrity. The main objective of...
SQL Fundamentals Day 2: What is a RDBMS? ||SQL||Beginners|| RDBMS||#sqlforbeginners ||#sql
Переглядів 892 місяці тому
Welcome to Day 2 of SQL Fundamentals on Database Academy! In this video, we kick off our journey into the world of databases. We start with the basics by answering the fundamental question: What is a database? 🔍 In this video, you'll learn: The definition and purpose of a database Key concepts and components of a database Different types of databases (relational, NoSQL, etc.) Real-world example...
SQL Fundamentals Day 1: What is a Database? ||SQL||Beginners|| Database Academy
Переглядів 1312 місяці тому
Welcome to Day 1 of SQL Fundamentals on Database Academy! In this video, we kick off our journey into the world of databases. We start with the basics by answering the fundamental question: What is a database? 🔍 In this video, you'll learn: The definition and purpose of a database Key concepts and components of a database Different types of databases (relational, NoSQL, etc.) Real-world example...
How to install SQL Developer 23.1 on Windows 10/11. #oracledatabase #plsql #oracle
Переглядів 4263 місяці тому
Oracle SQL Developer Downloads 23.1 URL - www.oracle.com/database/sqldeveloper/technologies/download/ Oracle SQL Developer install 23.1 You will also learn how to connect with Oracle Database
Install Oracle 21c Database Express Edition (XE) on Windows [2024] | How to install Oracle 21c
Переглядів 2084 місяці тому
How to install Oracle Database 21c on Windows 10/11. A detailed Oracle DB tutorial explaining the process of oracle 21c installation. Learn how to install Oracle Database Express Edition (XE) release 21c on Windows, the free edition of Oracle Database. We also show how to connect to the database using SQL Plus. Finally, we show how to use the enterprise manager through the web. XE Home Page: ww...
PL/SQL Interview Questions and Answers || Beginners|| Intermediate || 2024 ||#sqlinterviewquestions
Переглядів 1,3 тис.6 місяців тому
Top Most Asked PL/SQL Interview Questions and Answers for Beginners and Intermediate . I have collected these PL/SQL Interview Questions based on extensive research so that you can include this in your PL/SQL interview preparation. I have tried to cover all the concepts so that you clear the interview with ease. @DatabaseAcademyRT @Oracle #sql #oracledatabase #interview #plsql #plsqlinterviewqu...
SQL Interview Questions and Answers || Updated Q&A 2024 for Beginners and Intermediate #interview
Переглядів 8198 місяців тому
SQL Interview Questions and Answers || Updated Q&A 2024 for Beginners and Intermediate #interview
PL/SQL Interview Questions and Answers || Latest Q&A 2024 for Beginners and Intermediate
Переглядів 4,1 тис.9 місяців тому
PL/SQL Interview Questions and Answers || Latest Q&A 2024 for Beginners and Intermediate
Global Temp Table Vs Private Temp Table || Global Temp Table || Private Temp Table
Переглядів 739Рік тому
Global Temp Table Vs Private Temp Table || Global Temp Table || Private Temp Table
Read CSV File||Read Txt File || Inline External Table || How to load Data from Dump File
Переглядів 683Рік тому
Read CSV File||Read Txt File || Inline External Table || How to load Data from Dump File
External Table || Inline External Table || How to load Data from File
Переглядів 658Рік тому
External Table || Inline External Table || How to load Data from File
SQL Query Optimization and performance tuning | How to optimize SQL Queries | SQL Query tune
Переглядів 10 тис.Рік тому
SQL Query Optimization and performance tuning | How to optimize SQL Queries | SQL Query tune
PL/SQL Interview Questions and Answers || Beginners|| Intermediate || Top PL/SQL Interview Questions
Переглядів 6 тис.Рік тому
PL/SQL Interview Questions and Answers || Beginners|| Intermediate || Top PL/SQL Interview Questions
What’s new in Oracle Database 23c : Best New Features || Oracle 23c New Features
Переглядів 1,5 тис.Рік тому
What’s new in Oracle Database 23c : Best New Features || Oracle 23c New Features
PL/SQL Interview Questions and Answers || Beginners|| Intermediate || Top PL/SQL Interview Questions
Переглядів 20 тис.Рік тому
PL/SQL Interview Questions and Answers || Beginners|| Intermediate || Top PL/SQL Interview Questions
Oracle Difference between Case and Decode || 19C & 21C Oracle Case Vs Decode || Database academy
Переглядів 599Рік тому
Oracle Difference between Case and Decode || 19C & 21C Oracle Case Vs Decode || Database academy
Learn #SQL with ChatGPT || Sql || ChatGPT|| Database academy
Переглядів 809Рік тому
Learn #SQL with ChatGPT || Sql || ChatGPT|| Database academy
Oracle Difference between Delete and Truncate || 19c & 21c Oracle Delete Vs Truncate || Database
Переглядів 572Рік тому
Oracle Difference between Delete and Truncate || 19c & 21c Oracle Delete Vs Truncate || Database
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Database Academy
Переглядів 923Рік тому
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Database Academy
Hii sir , Very nice video you have made with proper practical examples, please continue the series and try to teach PLSQL INTERMEDIATE and ADVANCED concepts also, Requesting you to continue the PLSQL series on behalf of everybody whether it is student or working professional.
Sure I will
Hi.I have a problem that i download sql developer but in cmd there is error like "Connect to an idle instance".What can i do? Please help me about that?
Have you tried restarting your laptop after installation.
I believe that would be good to have a small explanation about the "mutating" trigger error, since this is a very common mistake, and the ways to avoid it. But it's a great work, congrats!
Good point!
Good informations! Congrats!
Thanks!
Nice explanation
👌👌👌
Great.
Nice sir please continue the full course sir
Yes, sure
Please send me pdf sir
Please share your email address
@@DatabaseAcademyRT sir please send me pdf sir
Hi sir please share me pdf
Share your email address
Thank you so much,
You are welcome!
#12 difference between count(1) and count(*)? There are not difference when I execute in Oracle 19c BUT you mentioned that it should provide different result. I'm confused.
When you use the column name inside the () then only you will find the difference check column name having few null values. Count (1) and count(*) have no difference.
you can use subquery in decode if return scalar result
Sir Could you explain more videos on performance tuning
Sure I'll create a new video on performance tuning.
👍
Nicely explain
Thanks and welcome
Share it in pdf format
Please share your email address
Please share this in pdf
Please share your e-mail id
I liked this video, bery helpful..both theoritical & practical..
Thanks
Great 👍. Please share the pdf document.
Share your email. I'll share with you
Hi bro please share me pdf, we can prepare easily
Share me your e-mail I'd.
Great collection 👍. Can you please share the pdf format.
Yes Sure, let me know your e-mail I'd.
Great video, need more video on SQL
More to come!
Thank you so much for this excellent video. I have one doubt. Yoi have explained for select statement same like what are all the possible things we will perform for an update statement for performance tuning. Plz reply
Thanks for your comment. 1. While updating records you should take care about where conditions the same way as mentioned in the video. 2.You can use Bulk collect and FORALL to update records in bulk.
first comment... thank you so much. all your sessions are very practical with live example for clear understanding.
Glad you like them!
@@DatabaseAcademyRT please upload more videos. Your videos are very useful. Before attending any interviews I am checking your videos only :)
Surely I'll upload more videos for database interviews.
Hi, Very informative video and commonly asked question in interview. Great work! Do you have some content for Oracle forms?
Not yet but surely I make videos on forms and reports also. Send me your e-mail I'd I'll send commonly used forms and report questions and answers in pdf format.
Super good information
Thank you so much 🙂
Thanks sir
Welcome
hi sir, If you don't mind can you give me some examples to practice i.e. some examples to use in real time it will help me a little. And also i want improve my my oracle skills thats why im asking sir.
Send me your e-mail I'd . I'll send you practice questions for you.
Good information
Thanks
Thanks for sharing
Thanks for watching!
Thanks ❤🎉
You're welcome 😊
Thanks for sharing
Thanks for watching!
@@DatabaseAcademyRT well come
Nice video and topic 👍 what books would you recommend to learn more about writing styles in sql ?
I learned these things with my experience and referring to oracle books.
datapump video link pls
Sorry don't have any link for this
Great video. Thanks for sharing
Thanks for watching!
thanks for great video. I have question: at 2:03 if I set index on n2 column too, then will it be used in OR query?
An "OR" condition typically involves evaluating multiple expressions, and it may result in a full table scan rather than using an index.
Sir How much salary can we expect for a 5 year experienced plsql developer ?
Depend on your skill and current CTC
Expecting more plsql video’s
ua-cam.com/video/xDWE6n2yDFo/v-deo.htmlsi=DL3WmFzTDNcu8Dsc
All old Mysql features are Oracle 23c new Features
Also i want pdf for this que.
Nice
Thanks
Informative stuff SIr, Keep it up🙂
Very nice sir
Nice video and tips sir👍
Nicely explain
👌👍
Nicely explain Great 👍
Thank you
Very nice and great
Thanks a lot
So the union all is basically for large data sir and for columns which index is not created
If we use OR in where condition then index will not be used if we have index on filter column. To use index we can use union so that index will be used and query performance will be improved.