- 174
- 110 393
dbOS Talks
Singapore
Приєднався 26 лип 2021
videos about databases, SQL(Oracle, SQL Server, MySQL, Sybase, Postgresql) & operating systems (Microsoft Windows, UNIX, Linux & DOS)
Display full name using SQL | Concatenate names in SQL
This video is in the playlist called "Derive data in SQL", and in this video, we will learn how to use put together name column values to display a person's full name in a number of ways. To do this, we will do a technique called concatenation, which I have used in some other videos.
// Windows Tips & Tricks
ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html
// Microsoft Excel Tutorial
ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html
// Excel for Data Analysis
ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html
// SQL Tutorial
ua-cam.com/play/PL0fAqYdWDpmhT0tCalNs1wlw4DWltoSOL.html
// Serious Fun with SQL
ua-cam.com/play/PL0fAqYdWDpmhSI_qWpZnKWjE0c-W7zWiO.html
// Notepad++ Tips & Tricks
ua-cam.com/play/PL0fAqYdWDpmjTXtT01-JZ7JujlnJgnukp.html
// Channel URL
ua-cam.com/users/dbostalks
// Windows Tips & Tricks
ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html
// Microsoft Excel Tutorial
ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html
// Excel for Data Analysis
ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html
// SQL Tutorial
ua-cam.com/play/PL0fAqYdWDpmhT0tCalNs1wlw4DWltoSOL.html
// Serious Fun with SQL
ua-cam.com/play/PL0fAqYdWDpmhSI_qWpZnKWjE0c-W7zWiO.html
// Notepad++ Tips & Tricks
ua-cam.com/play/PL0fAqYdWDpmjTXtT01-JZ7JujlnJgnukp.html
// Channel URL
ua-cam.com/users/dbostalks
Переглядів: 11
Відео
Redundant WHERE condition
Переглядів 21День тому
This video is part of the playlist called "SQL mistakes to avoid", and here we will learn about redundant WHERE condition. This type of mistake will not cause an error. However, it is an incorrect way of using a WHERE condition because you are adding something extra, which is not needed. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial...
Derive salutation in SQL
Переглядів 2514 днів тому
This video is in the playlist called "Derive data in SQL", and in this video, we will learn how to derive a person's salutation, whether Mr., Miss or Mrs. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso...
Determine if adult or minor using SQL
Переглядів 2121 день тому
This video is in the playlist called "Derive data in SQL", and in this video, we will learn how to determine if a person is an adult or minor in SQL. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html...
Derive gender in SQL
Переглядів 21Місяць тому
This video is in the playlist called "Derive data in SQL", and in this video, we will learn how to derive a person's gender in SQL. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html // SQL Tutorial u...
Derive age in SQL
Переглядів 33Місяць тому
This video is in the playlist called "Derive data in SQL", and in this video, we will learn how to derive a person's age in SQL. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html // SQL Tutorial ua-c...
COUNT in SQL | COUNT Function in SQL
Переглядів 13Місяць тому
This video is in the playlist called "Serious fun with SQL", and here we'll learn about the different usages of the COUNT function in SQL. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html // SQL Tut...
Null vs. zero in SQL | Null AND zero in SQL
Переглядів 41Місяць тому
This video is in the playlist called "SQL concepts clarified", and here we'll learn the difference between null and zero. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html // SQL Tutorial ua-cam.com/...
Table vs. View in SQL | Table and View in SQL
Переглядів 59Місяць тому
This video is in the playlist called "SQL concepts clarified", and here we'll learn the difference between a table and a view. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html // SQL Tutorial ua-cam...
NOT EQUAL in SQL
Переглядів 362 місяці тому
This video is in the playlist called "SQL concepts clarified", and here we''ll learn how to use not equal in our WHERE clause. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html // SQL Tutorial ua-cam...
XML Using Notepad++ | Using Notepad++ for XML
Переглядів 1232 місяці тому
In this video, we'll learn how Notepad can be used to handle XML files. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html // SQL Tutorial ua-cam.com/play/PL0fAqYdWDpmhT0tCalNs1wlw4DWltoSOL.html // Se...
Table alias vs column alias
Переглядів 542 місяці тому
This video is in the playlist called "SQL concepts clarified", and here we'll learn the difference of table alias and column alias. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html // SQL Tutorial u...
SQL rownum vs. rowid | rownum and rowid
Переглядів 322 місяці тому
This is the 1st video in a playlist called "SQL concepts clarified", and here we'll learn the difference of rownum & rowid in Oracle SQL. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html // SQL Tuto...
FLOOR function in SQL | SQL FLOOR function
Переглядів 273 місяці тому
This video is in the playlist called "Math using SQL", and here we'll learn about the FLOOR function. In a previous video, we talked about the CEIL function. In this one, we'll talk about its counterpart. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ...
CEIL function in SQL | SQL CEIL function
Переглядів 303 місяці тому
This video is in the playlist called "Math using SQL", and here we'll learn about the CEIL function in SQL. // Windows Tips & Tricks ua-cam.com/play/PL0fAqYdWDpmjXGe3IUQRoLBRyGHE3BM0I.html // Microsoft Excel Tutorial ua-cam.com/play/PL0fAqYdWDpmhzi5Sow38-W7rew8WTcyXA.html // Excel for Data Analysis ua-cam.com/play/PL0fAqYdWDpmjP2hRBitkfWOIvNDisRNso.html // SQL Tutorial ua-cam.com/play/PL0fAqYdW...
MIN & MAX in SQL | MIN, MAX functions in SQL
Переглядів 353 місяці тому
MIN & MAX in SQL | MIN, MAX functions in SQL
Division Techniques in Excel formulas | Division in Excel
Переглядів 133 місяці тому
Division Techniques in Excel formulas | Division in Excel
Multiplication Techniques in Excel formulas | Multiplication in Excel
Переглядів 284 місяці тому
Multiplication Techniques in Excel formulas | Multiplication in Excel
Concatenate in Excel | Concatenation in Excel
Переглядів 174 місяці тому
Concatenate in Excel | Concatenation in Excel
Addition and Subtraction of dates | Addition and subtraction in Excel
Переглядів 154 місяці тому
Addition and Subtraction of dates | Addition and subtraction in Excel
Addition Techniques in Excel formulas | Addition in Excel
Переглядів 134 місяці тому
Addition Techniques in Excel formulas | Addition in Excel
Using TRUNC on dates in SQL | TRUNC in SQL
Переглядів 1555 місяців тому
Using TRUNC on dates in SQL | TRUNC in SQL
Wildcard in SQL | Wildcard characters in SQL
Переглядів 345 місяців тому
Wildcard in SQL | Wildcard characters in SQL
Knowing the day in SQL | calendar day in SQL
Переглядів 485 місяців тому
Knowing the day in SQL | calendar day in SQL
Opposite of greater than in SQL | danger of using greater than
Переглядів 196 місяців тому
Opposite of greater than in SQL | danger of using greater than
months_between in SQL | Subtract months in SQL
Переглядів 306 місяців тому
months_between in SQL | Subtract months in SQL
Convert year to words | Year to words in SQL
Переглядів 86 місяців тому
Convert year to words | Year to words in SQL
Add months in SQL | ADD_MONTHS in SQL
Переглядів 506 місяців тому
Add months in SQL | ADD_MONTHS in SQL
Hi sir Im sowmiya from tamilnadu Im having one assignment about er diagram Can you send me your mail id so that I can send you my questions
Hi Sowmiya, Thanks for dropping by. Sorry 'cause I currently have no bandwidth to answer your questions via email due to my other personal/work commitments. You can post a question in this comment, and I will try to answer it. Otherwise, I do believe a web search can help you, too.
ok sir ,i finished all the question.now i want to confirm whether my er diagram correct or not -verification only@@dbOSTalks
i cant attach output here@dbOSTalks
thank you
You're welcome. Please consider subscribing.
it helped
Thanks. Pls consider subscribing to the channel.
Good👍
Thanks
How to on sir
You can press Ctrl+Space
Thanks
Welcome
Good video. When I export my animations as a GIF it dose not play when I open it. GIFs I have downloaded from online play when I open it in windows photo viewers. GIFs don't require any special app to open. Any photo viewer should play it. Something is wrong with LibreOffice
Hi, Maybe you're right. My LibreOffice knowledge is quite basic. I'm sure there are blogs/vlogs that could help you on that
Love it! ❤️
Thank you!!
How do you record vocals on here? I know how to on the mobile app but not on windows 10
Hi I haven't tried doing that on this app. Sorry about that.
How to unmerge the document
Hi, Sorry, I don't quite understand the question. The video is about what to do when: 1) you have no keyboard 2) you have no mouse
Thanks man
Thanks Ambika. Shukriya/Nandri.
That worked for me -- Thanks!
Hi James Glad to be able to help
WOW! Great tip
Thanks very much!
How can we convert declimal number like 9876.56 using select '9876',(to_char(to_date('9876','j'),'jsp')) from dual ?
Hi Sujatha, You can try this workaround...although others might have a better way: with qry as ( select 9876.56 num from dual) select upper(to_char(to_date(trunc(num),'j'),'jsp')) || ' point '|| upper(to_char(to_date((num-trunc(num))*100,'j'),'jsp')) num_in_words from qry;
How can we apply '9867 'code to the Entire Column?
Hi Yogesh, You can use INSTR function to find a digit's location/position in the string. However, INSTR returns the position from the left. The below can be one workaround approach. Example: 87654 If we want to know the position of '7' from the right, we can use this: pos_r = <length_of_string> - <INSTR value> + 1 = 5-2+1 = 4 And then, we can have logic like this, where pos_r is the variable for the position from the right... IF pos_r = 4, append with 'THOUSAND' for that digit/character. IF pos_r = 7, append with 'MILLION' for that digit/character.
It might be my phone but is there a way to make the sound louder. I see other videos with louder/clearer sounds. I do not know how they make that. Might with the mike/sound equipment/voice. Thanks brod.
Duly noted, brod Thanks
thanks kuya,ingat po
Most welcome!
This is the 1st video in a playlist called "Beginner Office Skills". This series is aimed at equipping a beginner with useful skills involving short but important office tasks. Please feel free to subscribe. Thanks.
Thanks bro. Great job
You're welcome, bro.
You're welcome, Dotman.
SQL (used in Oracle, SQL Server, Sybase, MySQL, Postgresql, DB2, etc.) is the language used to communicate with a database. This video is part of an SQL tutorial series. Here below is the link to the 1st video of that series: ua-cam.com/video/7zkGZj1Pylo/v-deo.html?sub_confirmation=1
SQL (used in Oracle, SQL Server, Sybase, MySQL, Postgresql, DB2, etc.) is the language used to communicate with a database. This video is part of an SQL tutorial series. Here below is the link to the 1st video of that series: ua-cam.com/video/7zkGZj1Pylo/v-deo.html?sub_confirmation=1
Here sir sending my support good sharing very informative content..
Hi boygahi tv, thanks for your support.
Thank you the information sending full support Ana Liza
Thanks Ana Liza (Rated B) for your support.
Sending support.... Tnx for sharing this video.
Thanks Leslie Fashionista girl.
Sending fullsupport from Ana Liza
Thanks MIND Gaming TV
I think I should start watching the first video so that I can can fully understand how or what to do.Your video itself will help me learn .
Thanks a lot. Much appreciated.
Hi friends, please note that the video you should watch after this intro is this: m.ua-cam.com/video/dr242wq7M88/v-deo.html
SQL (used in Oracle, SQL Server, Sybase, MySQL, Postgresql, etc.) is the language used to communicate with a database. This video is the first one in my SQL tutorial series.
SQL (used in Oracle, SQL Server, Sybase, MySQL, Postgresql, etc.) is the language used to communicate with a database. This video is part of an SQL tutorial series. Here below is the link to the 1st video of that series: ua-cam.com/video/7zkGZj1Pylo/v-deo.html?sub_confirmation=1
SQL (used in Oracle, SQL Server, Sybase, MySQL, Postgresql, etc.) is the language used to communicate with a database. This video is part of an SQL tutorial series. Here below is the link to the 1st video of that series: ua-cam.com/video/7zkGZj1Pylo/v-deo.html?sub_confirmation=1
SQL (used in Oracle, SQL Server, Sybase, MySQL, Postgresql, etc.) is the language used to communicate with a database. This video is part of an SQL tutorial series. Here below is the link to the 1st video of that series: ua-cam.com/video/7zkGZj1Pylo/v-deo.html?sub_confirmation=1
Congratulations for your great channel!
Thanks much Jona !