- 35
- 58 596
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
Mastering Table Functions in SQL | Database Academy | Table Function | Interview Question
Unlock the power of Table Functions in SQL! 🎯
In this video, you'll learn:
What are table functions?
Why and when to use them.
Step-by-step examples to create and utilize table functions effectively.
📌 Perfect for SQL developers, database enthusiasts, and anyone looking to enhance their SQL skills.
💡 Don’t forget to subscribe to Database Academy for more insightful database tutorials and tips!
Tags:
#sql #TableFunctions #DatabaseAcademy #sqltutorial #learnsql #databasedevelopment #sqltraining #sqlqueryinterviewquestionsandanswers #oracle
Join my WhatsApp group for updates and discussions: chat.whatsapp.com/CoSN4PO09UtEldIZ8E0eL3
In this video, you'll learn:
What are table functions?
Why and when to use them.
Step-by-step examples to create and utilize table functions effectively.
📌 Perfect for SQL developers, database enthusiasts, and anyone looking to enhance their SQL skills.
💡 Don’t forget to subscribe to Database Academy for more insightful database tutorials and tips!
Tags:
#sql #TableFunctions #DatabaseAcademy #sqltutorial #learnsql #databasedevelopment #sqltraining #sqlqueryinterviewquestionsandanswers #oracle
Join my WhatsApp group for updates and discussions: chat.whatsapp.com/CoSN4PO09UtEldIZ8E0eL3
Переглядів: 256
Відео
SQL Fundamentals Day 6: SQL Command DML||SQL||Beginners|#sql #education #interview #plsqlDMLComman
Переглядів 91Місяць тому
Welcome to Day 6 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 DML? 🔍 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 subscribe an...
SQL Fundamentals Day 5: SQL Command DDL||SQL||Beginners|#sql #education #interview #plsql
Переглядів 1272 місяці тому
Welcome to Day 5 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 DDL? 🔍 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 subscribe an...
SQL Tuning Tips: Boost Your Database Performance Part 2 | How to optimize SQL Queries | SQL Tuning
Переглядів 3814 місяці тому
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...
SQL Fundamentals Day 4: What is SQL Datatype ? ||SQL||Beginners|#sql #education #interview #plsql
Переглядів 594 місяці тому
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
Переглядів 655 місяців тому
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
Переглядів 995 місяців тому
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
Переглядів 1475 місяців тому
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
Переглядів 9086 місяців тому
How to install SQL Developer 23.1 on Windows 10/11. #oracledatabase #plsql #oracle
Install Oracle 21c Database Express Edition (XE) on Windows [2024] | How to install Oracle 21c
Переглядів 3378 місяців тому
Install Oracle 21c Database Express Edition (XE) on Windows [2024] | How to install Oracle 21c
PL/SQL Interview Questions and Answers || Beginners|| Intermediate || 2024 ||#sqlinterviewquestions
Переглядів 1,6 тис.9 місяців тому
PL/SQL Interview Questions and Answers || Beginners|| Intermediate || 2024 ||#sqlinterviewquestions
SQL Interview Questions and Answers || Updated Q&A 2024 for Beginners and Intermediate #interview
Переглядів 88611 місяців тому
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,7 тис.Рік тому
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
Переглядів 827Рік тому
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
Переглядів 712Рік тому
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
Переглядів 757Рік тому
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
Переглядів 11 тис.Рік тому
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,6 тис.Рік тому
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
Переглядів 23 тис.Рік тому
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
Переглядів 651Рік тому
Oracle Difference between Case and Decode || 19C & 21C Oracle Case Vs Decode || Database academy
Learn #SQL with ChatGPT || Sql || ChatGPT|| Database academy
Переглядів 839Рік тому
Learn #SQL with ChatGPT || Sql || ChatGPT|| Database academy
Oracle Difference between Delete and Truncate || 19c & 21c Oracle Delete Vs Truncate || Database
Переглядів 616Рік тому
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
Переглядів 958Рік тому
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Database Academy
Please suggest me anyone 🙏
Both you need to learn sql and plsql
Only sql and PLSQL is enough to get a fresher job ?
Yes, that's enough to start your journey in the database, You can get the Job as fresher
Can you please share interview questions for a SQL, PL/SQL developer with 1-2 years of experience?
Send me your email address
Hello , Will you provide support for cracking an interview for Oracle developer position?
I can provide training on sql and plsql which will help you to clear the interview.
Hi sir , Just wanted to clear one thing here, if you define any procedure in specification but not defined in the package body. This will lead to an error when you try to use the package, as the procedure is not implemented.
Yes, That's correct when we use that procedure we will get error but compiling specification will not give any error at the time of compilation,
Very useful
Thanks a lot
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