Database Academy
Database Academy
  • 30
  • 51 740
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
Переглядів: 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

КОМЕНТАРІ

  • @yashchaudhary351
    @yashchaudhary351 3 дні тому

    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.

  • @eltacabbasov8850
    @eltacabbasov8850 6 днів тому

    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?

    • @DatabaseAcademyRT
      @DatabaseAcademyRT 5 днів тому

      Have you tried restarting your laptop after installation.

  • @alexandrezart4784
    @alexandrezart4784 Місяць тому

    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!

  • @alexandrezart4784
    @alexandrezart4784 Місяць тому

    Good informations! Congrats!

  • @gauravdevlal2902
    @gauravdevlal2902 Місяць тому

    Nice explanation

  • @kandapoha
    @kandapoha Місяць тому

    👌👌👌

  • @balakrishnad9246
    @balakrishnad9246 2 місяці тому

    Great.

  • @rajchintada-ww7ex
    @rajchintada-ww7ex 2 місяці тому

    Nice sir please continue the full course sir

  • @rajchintada-ww7ex
    @rajchintada-ww7ex 3 місяці тому

    Please send me pdf sir

  • @rajchintada-ww7ex
    @rajchintada-ww7ex 3 місяці тому

    Hi sir please share me pdf

  • @USA_to_Asia_in_2024
    @USA_to_Asia_in_2024 3 місяці тому

    Thank you so much,

  • @BuyantugsLuvsankhuu
    @BuyantugsLuvsankhuu 3 місяці тому

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

    • @DatabaseAcademyRT
      @DatabaseAcademyRT 3 місяці тому

      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.

  • @ilpaolotopleggend6663
    @ilpaolotopleggend6663 3 місяці тому

    you can use subquery in decode if return scalar result

  • @gouthamgoudmangoli2043
    @gouthamgoudmangoli2043 5 місяців тому

    Sir Could you explain more videos on performance tuning

    • @DatabaseAcademyRT
      @DatabaseAcademyRT 5 місяців тому

      Sure I'll create a new video on performance tuning.

  • @AnanyaRaghavT
    @AnanyaRaghavT 6 місяців тому

    👍

  • @StarWorldComedy
    @StarWorldComedy 6 місяців тому

    Nicely explain

  • @madepalliamrita4120
    @madepalliamrita4120 6 місяців тому

    Share it in pdf format

  • @td9051
    @td9051 7 місяців тому

    Please share this in pdf

  • @samugaurimainews2845
    @samugaurimainews2845 7 місяців тому

    I liked this video, bery helpful..both theoritical & practical..

  • @I_AM_VJK
    @I_AM_VJK 7 місяців тому

    Great 👍. Please share the pdf document.

  • @kishorekumar4542
    @kishorekumar4542 8 місяців тому

    Hi bro please share me pdf, we can prepare easily

  • @StarWorldComedy
    @StarWorldComedy 8 місяців тому

    Great collection 👍. Can you please share the pdf format.

  • @StarWorldComedy
    @StarWorldComedy 8 місяців тому

    Great video, need more video on SQL

  • @sriprabavathik7629
    @sriprabavathik7629 8 місяців тому

    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

    • @DatabaseAcademyRT
      @DatabaseAcademyRT 8 місяців тому

      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.

  • @siwaswap
    @siwaswap 8 місяців тому

    first comment... thank you so much. all your sessions are very practical with live example for clear understanding.

    • @DatabaseAcademyRT
      @DatabaseAcademyRT 8 місяців тому

      Glad you like them!

    • @siwaswap
      @siwaswap 8 місяців тому

      @@DatabaseAcademyRT please upload more videos. Your videos are very useful. Before attending any interviews I am checking your videos only :)

    • @DatabaseAcademyRT
      @DatabaseAcademyRT 8 місяців тому

      Surely I'll upload more videos for database interviews.

  • @nikitanamdev9955
    @nikitanamdev9955 8 місяців тому

    Hi, Very informative video and commonly asked question in interview. Great work! Do you have some content for Oracle forms?

    • @DatabaseAcademyRT
      @DatabaseAcademyRT 8 місяців тому

      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.

  • @AkhileshTiwary-qc4vu
    @AkhileshTiwary-qc4vu 9 місяців тому

    Super good information

  • @AkhileshTiwary-qc4vu
    @AkhileshTiwary-qc4vu 9 місяців тому

    Thanks sir

  • @saieswar8209
    @saieswar8209 9 місяців тому

    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.

    • @DatabaseAcademyRT
      @DatabaseAcademyRT 9 місяців тому

      Send me your e-mail I'd . I'll send you practice questions for you.

  • @rajchintada-ww7ex
    @rajchintada-ww7ex 9 місяців тому

    Good information

  • @StarWorldComedy
    @StarWorldComedy 9 місяців тому

    Thanks for sharing

  • @AkhileshTiwary-qc4vu
    @AkhileshTiwary-qc4vu 9 місяців тому

    Thanks ❤🎉

  • @AkhileshTiwary-qc4vu
    @AkhileshTiwary-qc4vu 9 місяців тому

    Thanks for sharing

  • @maksim0933
    @maksim0933 9 місяців тому

    Nice video and topic 👍 what books would you recommend to learn more about writing styles in sql ?

    • @DatabaseAcademyRT
      @DatabaseAcademyRT 9 місяців тому

      I learned these things with my experience and referring to oracle books.

  • @RaghunathanDhananjayan
    @RaghunathanDhananjayan 9 місяців тому

    datapump video link pls

  • @LearnwithPam-n5x
    @LearnwithPam-n5x 9 місяців тому

    Great video. Thanks for sharing

  • @free2idol1
    @free2idol1 9 місяців тому

    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?

    • @DatabaseAcademyRT
      @DatabaseAcademyRT 9 місяців тому

      An "OR" condition typically involves evaluating multiple expressions, and it may result in a full table scan rather than using an index.

  • @trendinghere8425
    @trendinghere8425 10 місяців тому

    Sir How much salary can we expect for a 5 year experienced plsql developer ?

  • @DivyaMahiChennai
    @DivyaMahiChennai 11 місяців тому

    Expecting more plsql video’s

    • @DatabaseAcademyRT
      @DatabaseAcademyRT 6 місяців тому

      ua-cam.com/video/xDWE6n2yDFo/v-deo.htmlsi=DL3WmFzTDNcu8Dsc

  • @saravanakumarnatarajan7756
    @saravanakumarnatarajan7756 11 місяців тому

    All old Mysql features are Oracle 23c new Features

  • @prajwalukey8537
    @prajwalukey8537 Рік тому

    Also i want pdf for this que.

  • @AnanyaRaghavT
    @AnanyaRaghavT Рік тому

    Nice

  • @deepakbisht7195
    @deepakbisht7195 Рік тому

    Informative stuff SIr, Keep it up🙂

  • @pravinkumar-ug8bg
    @pravinkumar-ug8bg Рік тому

    Very nice sir

  • @ManishbihariYT
    @ManishbihariYT Рік тому

    Nice video and tips sir👍

  • @AnanyaRaghavT
    @AnanyaRaghavT Рік тому

    Nicely explain

  • @ManishbihariYT
    @ManishbihariYT Рік тому

    👌👍

  • @AnanyaRaghavT
    @AnanyaRaghavT Рік тому

    Nicely explain Great 👍

  • @santoshkumar-dz1jb
    @santoshkumar-dz1jb Рік тому

    Very nice and great

  • @deepikavarma5609
    @deepikavarma5609 Рік тому

    So the union all is basically for large data sir and for columns which index is not created

    • @DatabaseAcademyRT
      @DatabaseAcademyRT Рік тому

      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.