ENTOPDBA: January 2023

Monday, January 30, 2023

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

Sunday, January 22, 2023

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

Thursday, January 19, 2023

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 .

Sunday, January 15, 2023

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

Saturday, January 14, 2023

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.