- Видео 29
- Просмотров 24 921
Learn with RD
Индия
Добавлен 28 июл 2023
This Channel is about sharing the knowledge on different Technologies and Coding Languages.
How to install Python on Windows 10 and configure Python on IntelliJ IDE for code practice.
This video covers step by step process to install Python and Configuration on IntelliJ IDE.
Просмотров: 171
Видео
SQL - Solution to Level 2 Questions
Просмотров 4811 месяцев назад
All doubts will be answered in comment section.
SQL Practice Questions Level-2
Просмотров 4711 месяцев назад
scripts: SQL Practice Session 2 Table Creation CREATE TABLE emp( emp_id INT PRIMARY KEY, name VARCHAR(255), join_date DATE, salary DECIMAL(10,2), department VARCHAR(50) ); Insert Data INSERT INTO emp VALUES(1, 'John Doe', '15-JAN-23', 60000, 'IT'); INSERT INTO emp VALUES(2, 'Jane Smith', '20-FEB-23', 70000, 'HR'); INSERT INTO emp VALUES(3, 'Bob Johnson', '10-MAR-23', 55000, 'Marketing'); INSERT...
SQL - Solution to Practice Level-1 questions
Просмотров 4011 месяцев назад
Any questions related to SQL will be answered in the comment section.
SQL Practice Questions - Level-1
Просмотров 77Год назад
@LearnWithRD0529 Scripts: Create the "employ" table CREATE TABLE employ ( employee_id INT PRIMARY KEY, name VARCHAR(50), age INT, department VARCHAR(50), salary DECIMAL(10, 2), join_date DATE ); Insert sample data into the "employ" table INSERT INTO employ VALUES (101, 'John Smith', 30, 'IT', 60000.00, '01-JAN-22'); INSERT INTO employ VALUES (102, 'Jane Doe', 25, 'Sales', 55000.00, '15-FEB-22')...
SQL - with cte (Common Table Expression) - Day21
Просмотров 142Год назад
@LearnWithRD0529 employee3 scripts Create the Employee3 table CREATE TABLE Employee3 ( EmployeeID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Department VARCHAR(50) ); Insert some sample data into the Employee table INSERT INTO Employee3 (EmployeeID, FirstName, LastName, Department) VALUES (1, 'John', 'Doe', 'HR'); INSERT INTO Employee3 (EmployeeID, FirstName, LastName, Depart...
SQL Self Join - Day20
Просмотров 217Год назад
@LearnWithRD0529 Q1:Suppose you have an employee database with a table named "employees2" that represents a company's hierarchy. Each employee has an ID, a name, and a reference to their manager's ID. You want to find the employees and their managers. Employee2 table scripts - CREATE TABLE employees2 ( employee_id INT PRIMARY KEY, employee_name VARCHAR(50), manager_id INT ); INSERT INTO employe...
SQL Joins - INNER JOIN, LEFT JOIN, RIGHT JOIN - Day19
Просмотров 202Год назад
@LearnWithRD0529 scripts Create the 'accounts' table CREATE TABLE accounts ( account_id INT PRIMARY KEY, customer_id INT, order_id INT, balance INT, company VARCHAR(50) ); Create the 'customers' table CREATE TABLE customers ( customer_id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), email VARCHAR(100) ); Create the 'orders' table CREATE TABLE orders ( order_id INT PRIMARY KEY,...
SQL - RANK, DENSE_RANK, ROW_NUMBER (WINDOW FUNCTIONS) and PARTITION BY CLAUSE -Day18
Просмотров 148Год назад
@LearnWithRD0529 Table and Insert scripts for practice create table students( id number, name varchar(100), subject varchar(100), marks number ); insert into students values(1020,'JOE','SCIENCE','97'); insert into students values(1020,'JOE','MATHS','98'); insert into students values(1020,'JOE','ENGLISH','89'); insert into students values(1021,'MARK','SCIENCE','76'); insert into students values(...
SQL Subqueries - Day17
Просмотров 253Год назад
@LearnWithRD0529 Employee Table script - CREATE TABLE employee ( employee_id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), job_id VARCHAR(20), salary DECIMAL(10, 2), manager_id INT, department_id INT ); Insert statements INSERT INTO employee (employee_id, first_name, last_name, job_id, salary, manager_id, department_id) VALUES (1, 'John', 'Doe', 'HR1', 55000.00, NULL, 1); INSE...
SQL Set Operators - UNION , UNION ALL, INTERSECT, MINUS - Day16
Просмотров 173Год назад
@LearnWithRD0529 TABLE SCRIPTS: CREATE TABLE property1 ( property1_id INT, property1_name VARCHAR(255), property1_type VARCHAR(50), property1_value DECIMAL(10, 2) ); CREATE TABLE property2 ( property2_id INT, property2_name VARCHAR(100), property2_type VARCHAR(50), property2_value DECIMAL(10, 2) ); CREATE TABLE property3 ( id INT, name VARCHAR(200), type VARCHAR(50), value DECIMAL(10, 2) ); CRE...
SQL - STRING MGMT FUNCTIONS - SUBSTR, INSTR, REPLACE, LOWER, UPPER AND MIN, MAX, AVG FUNC - Day15
Просмотров 127Год назад
@LearnWithRD0529 scripts - CREATE TABLE Account ( account_id INT PRIMARY KEY, account_number VARCHAR(20) NOT NULL, account_name VARCHAR(255), balance DECIMAL(10, 2), account_type VARCHAR(50) ); Inserting sample account data INSERT INTO Account (account_id, account_number, account_name, balance, account_type) VALUES(1, 'ACC123456', 'John Doe', 1000.00, 'Savings'); INSERT INTO Account (account_id...
SQL Practice Questions - Day13
Просмотров 120Год назад
@LearnWithRD0529 Create table and insert scripts - CREATE TABLE vehicle ( vehicle_id INT PRIMARY KEY, make VARCHAR(50), model VARCHAR(50), year INT, color VARCHAR(20), vin_number VARCHAR(17) UNIQUE ); Insert 11 sample vehicle records INSERT INTO vehicle (vehicle_id, make, model, year, color, vin_number) VALUES (1, 'Toyota', 'Camry', 2020, 'Silver', '1HGCM82633A123456'); INSERT INTO vehicle (veh...
SQL Clauses - WHERE, GROUP BY, HAVING, ORDER BY | Functions - COUNT() , DISTINCT() - Day12
Просмотров 182Год назад
SQL Clauses - WHERE, GROUP BY, HAVING, ORDER BY | Functions - COUNT() , DISTINCT() - Day12
SQL Basics - SUMMARY OF TOPICS COVERED - Day11
Просмотров 182Год назад
SQL Basics - SUMMARY OF TOPICS COVERED - Day11
SQL ANSWERS to 21 PRACTICE QUESTIONS - Day10
Просмотров 206Год назад
SQL ANSWERS to 21 PRACTICE QUESTIONS - Day10
SQL Basic - 21 Practice questions - Day9
Просмотров 403Год назад
SQL Basic - 21 Practice questions - Day9
SQL operators - Arithmetic, Relational, Concatenation, NULL & NOT NULL - Day8
Просмотров 120Год назад
SQL operators - Arithmetic, Relational, Concatenation, NULL & NOT NULL - Day8
SQL DATE, TIMESTAMP, INTERVAL DATA TYPES | TO_DATE(), TO_CHAR(), TO_NUMBER(), TO_TIMESTAMP() - Day7
Просмотров 469Год назад
SQL DATE, TIMESTAMP, INTERVAL DATA TYPES | TO_DATE(), TO_CHAR(), TO_NUMBER(), TO_TIMESTAMP() - Day7
Uninstall Oracle 19c Database - Step by Step process.
Просмотров 756Год назад
Uninstall Oracle 19c Database - Step by Step process.
Oracle 19c Database installation | Unlock HR User | Configure HR schema to SQL Developer
Просмотров 8 тыс.Год назад
Oracle 19c Database installation | Unlock HR User | Configure HR schema to SQL Developer
SQL Logical Operators and Creating Scripts - Day3
Просмотров 387Год назад
SQL Logical Operators and Creating Scripts - Day3
SQL Create Table and widely used Datatypes - Day2
Просмотров 439Год назад
SQL Create Table and widely used Datatypes - Day2
I m facing problem when the hrdb activation when i create a tns service it shows no rows selected what is the issue
After lsnrctl reload i had this error : tns : no listener what is the problem ?
You need to update the tns file correctly
@@LearnWithRD0529 how ?
After run as administrator its dont shows anything
@@boddanasanthoshkumar2401 you should not have any spaces in folder names where oracle file is saved
Thankx brother ❤️. God bless you. 👍🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻😇
Always welcome
thanks for your tutorial
You are welcome
I have watched many videos about this error but I didn't find any solution but this video 💯 helped me. THANK YOU SIR for sharing your knowledge ❤❤
Excellent video sir. You are explaining everything in very detail . Keep up doing this great job which will help many others also.
Thanks a ton
i tryd this but my screen just gose black and says no signal
Bro I followed each and every step mentioned in the video but ended up facing an error Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor (CONNECTION_ID=Ruv4TK6qRmezOPira3Km9A==). Please help me out Im not able to connect to HR schema due to this error
Some of the Oracle services could be down. Go to run - then type services.msc and check if the required orcl services are up and running.
@@LearnWithRD0529 I got the solution, I just ran > lsnrctl status in the output you should see your service name correctly, in my case it added some more information for example orclpdb.mshome.oc was the name (it's not but you get the point), use that as the service name when connecting, everything else is the same, I didn't change the service name in the TNS config file, maybe I should
Thanks to you for your help...
Welcome
im facing a problem to install oracle 19c .. please help me.. [INS-20802] Oracle Database Configuration Assistant failed.
Check if the listener is up and running. If not check the Oracle services are running or not. To check Oracle services go to run -> services.msc -> here you will find the Oracle services
its running @@LearnWithRD0529
actually before im uninstall a oracle 19c ... now im install progess 71% and then error Oracle Database Configuration Assistant failed.
Thank you very much
Welcome
Nice video.Big help ❤
Glad it helped
Thankk youu soo mucchh.... I was trying soo hard to install this but UT was not happening . Your video helped me alot 🩷🩷🩷☹️
Glad I could help
There is password on my bios and now I can’t go into bios to enable it help me
If you don't know the password, you may need to contact the system administrator or check the documentation that came with your device for instructions on how to reset or recover the BIOS/UEFI password.
I follow all sql questions and practice it...I want more question like this...thank you sir
Sure
python installation completed sir , thank you for valuable share!
You are welcome
Thank you sir
Welcome
Really helpful , provide more question for practice . Thankyou
Sure
Thank you sir
👍
Sir this option is not in my computer windos 10 pro ❤
You can restart your system and keep pressing F2. It will directly take you to boot mode
I dont have system configuration what do i do
Restart your system and keep pressing F2 it will take you to boot mode
@@LearnWithRD0529 ok thanks
thank bro
Welcome
sir..downloaded oracle from your video but facing black screen issue while installing oracle setup.exe
There should be no space in folder names
@@LearnWithRD0529 sir..already tried this..followed your video with step by step instructions but facing the same issue
UEFI setting are not visible. What to do?
Do a core boot. Restart your system and immediately keep pressing F2 key. You will enter into BIOS mode and from there you can follow the video for further settings.
Me too bro
Thank you so much, i was struggling a lot but you helped me a lot. Great video!
Glad! it was helpful
Y WE USE MAKE IN QUESRY NO. 6
Can you exactly tell me the question number. make is a column name in the table
You helped me man thanks again and again
Glad to hear it
Upload angular js react courses
Sure
tried all videos but urs was the best and working!!!\ 😀😀
Glad to hear that
Thank you soo much sir very thankful to you😊
Most welcome
i have no uefi firmware settings.so what should I do for mine
Restart your system and while it is restarting keep pressing F2. You will enter into BIOS mode
@@LearnWithRD0529 there is no BIOS mode just a advance mode ((F7)) And I m daily enabling my virtual mode
VERY CLEAR EXPLAINATION. KEEP IT UP.THANKS
Thank you
your are great man. thanks
Thank you for your kind words
Can you teach online classes
Yes I can.....if we can get atleast 15-20 students who are interested.
Are these functions applicable to all sql rdbms?
These are for Oracle.....syntax might be slight different for other rdbms
@@LearnWithRD0529 thanks for the info..
شكرا جدا نجح معي thank you very much
Glad it was helpful
thanku u so much for the session
Thank u
In fact, you are a very good teacher. Thanks you very much.
Thank you! 😃
That's uefi option not coming to me
The option names will change for different laptop models or laptops with same models but different BIOS. There will be different option name that will take you to BIOS setup
awesome explanation, clear my doubts as well as concepts😄
Thank you
awesome session
Thank you kindly
very helpful 👌👌
Thank u
Please make a video every day, thanks awesome content.
Bcoz of my work schedule it is difficult to make videos everyday, however will try to post atleast 1 or 2 in one week. I mostly get time on weekends only.
Okay, No worries .
For downloading the file need to create account first. 0:52
Yes
Sir, This query is working for question no 12. select to_char(to_timestamp(sysdate),' MM-DD-YYYY HH:MM:SS AM') from dual;
Good....yeah this way can manipulate the sysdate.
Excellent video Sir. You have explained every minute thing in very detail👍
Thank you
капец интересно!
Thanks for your input. Will create separate Playlist for hindi language.
Very Informative.
Thank you
Good question to upskill in sql ,make more videos like this .👍
Sure 👍