SQL Function | single row and multi row functions in sql Lesson 11 | Part 02

 In this Video we will learn SQL Functions: SQL functions are built into Oracle Database and are available for use in various appropriate SQL statements. Do not confuse SQL functions with user-defined functions written in PL/SQL.

👋 Additional resources - Download & install Oracle 19C database : https://www.oracle.com/database/techn... - Download & install SQL Developer 12C: https://www.oracle.com/database/sqlde... 🚩 Connect with me on social Facebook: https://www.facebook.com/afgblog Website: https://afgdba.blogspot.com/ 🔔 Subscribe to my YouTube channel https://www.youtube.com/@entopdba501

SQL Function | single row and multi row functions in sql Lesson 10

 SQL Function single row and multiple row function.

Lesson 10 uploaded in YouTube.

YouTube: https://www.youtube.com/@entopdba501

Website: https://afgdba.blogspot.com/

👋 Additional resources - Download & install Oracle 19C database : https://www.oracle.com/database/techn... - Download & install SQL Developer 12C: https://www.oracle.com/database/sqlde... 🚩 Connect with me on social Facebook: https://www.facebook.com/afgblog Website: https://afgdba.blogspot.com/ 🔔 Subscribe to my YouTube channel https://www.youtube.com/@entopdba501

ORDER BY Clause in SQL | Sorting|#database| #oracle | Lesson 07

he ORDER BY clause is used to sort the data from a table in ascending or descending order. The ORDER BY clause sorts the data in ascending order by default. In this video, we will check the ORDER BY Clause in a simple application. Please subscribe my channel. 👋 Additional resources - Download & install Oracle 19C database : https://www.oracle.com/database/techn... - Download & install SQL Developer 12C: https://www.oracle.com/database/sqlde... 🚩 Connect with me on social Facebook: https://www.facebook.com/afgblog Website: https://afgdba.blogspot.com/ 🔔 Subscribe to my YouTube channel https://www.youtube.com/@entopdba501

Restricting and Sorting Data | #Oracle #Database #SQL #Fundamentals | Lesson 05 | Part 1

 Hello everyone Ahmad from ENTOPDBA here today I am going to talk about SQL Restricting and Sorting Data .

Please subscribe the channel and hit the like thanks. 👋 Additional resources - Download & install Oracle 19C database : https://www.oracle.com/database/techn... - Download & install SQL Developer 12C: https://www.oracle.com/database/sqlde... 🚩 Connect with me on social Facebook: https://www.facebook.com/afgblog Website: https://afgdba.blogspot.com/ 🔔 Subscribe to my YouTube channel https://www.youtube.com/@entopdba501

SQL Duplicate Rows and alternative Quote (q) | for beginners Lesson 04

 Hello everyone Ahmad from ENTOPDBA here today I am going to talk about SQL alternative quote (q) and Duplicate Rows .

Please subscribe the channel and hit the like thanks. 👋 Additional resources - Download & install Oracle 19C database : https://www.oracle.com/database/techn... - Download & install SQL Developer 12C: https://www.oracle.com/database/sqlde... 🚩 Connect with me on social Facebook: https://www.facebook.com/afgblog Website: https://afgdba.blogspot.com/ 🔔 Subscribe to my YouTube channel https://www.youtube.com/@entopdba501

SQL select statement for beginners tutorial Lesson 02

Hello everyone Ahmad from ENTOPDBA here today we are going to talk about SQL select statement . in the previous video we talked about SQL introduction, how to make SQL Developer connection and how to use SQL*Plus. please follow and subscribe my Channel I promise you to teach all Oracle 12C courses such as SQL ,PL/SQL, DBA1 and DBA2 as you all know Oracle DBA has big scope and marketing today.

right now I am working as Oracle database administrator in the United States and I remember I started learning SQL like you from basic when I was in India and today i am working as DBA in a big company.

👋 Additional resources - Download & install Oracle 19C database : https://www.oracle.com/database/technologies/oracle-database-software-downloads.html - Download & install SQL Developer 12C: https://www.oracle.com/database/sqldeveloper/technologies/download/ 🚩 Connect with me on social Facebook: https://www.facebook.com/afgblog Website: https://afgdba.blogspot.com/ 🔔 Subscribe to my YouTube channel https://www.youtube.com/@entopdba501

SQL for Beginner tutorial Lesson 01

 In this step-by-step tutorial, learn how you can write your own SQL queries. we're going to use all free tools. By the end of this video, you'll know how to retrieve data from databases. At the end, I'll show you a neat trick to write some of the most complex queries with very little effort in the lesson 02.

SQL stands for structured query language. It's a language that you can use to talk to your database. You can also use it to retrieve, filter, sort, combine, add, update, and delete data in a database. It's basically a language you can use to interact with the database. The great thing is that anyone can learn how to write SQL queries. You definitely don't need a degree in computer science. And once you know it, you'll have another superpower that you can use at work.

👋 Additional resources - Download & install Oracle 19C database : https://www.oracle.com/database/technologies/oracle-database-software-downloads.html - Download & install SQL Developer 12C: https://www.oracle.com/database/sqldeveloper/technologies/download/ 🚩 Connect with me on social Facebook: https://www.facebook.com/afgblog Website: https://afgdba.blogspot.com/ 🔔 Subscribe to my YouTube channel https://www.youtube.com/@entopdba501