hi Saloni, great teaching by you , can you please share all Sql Course from scratch full pdf

Completed all your sql videos. Now I have a perfect understanding of all sql topics. Eagerly waiting to see your upcoming windows functions videos

Your Explanation is crystal clear.

Precise context😀

hey, why we cannot write this query this way, 'select distinct salary from employee order by salary limit 2,1; ' why do we need 'salary is not null' function?

Is we use * with group by ??

your syntax is wrong concept is right

Nice explanation. Thank you so much....

Student 16 • Introduction about your self • Why Capgemini? • About Projects • What is the problem you faced in your project? • Which technology used? • How many members in your team and what is your role in project? • What are the pillars of oops? • What is inheritance? • What is super class and subclass? • What is constructor and deconstructor? • You have any questions? Student 17 • Introduce yourself • About Projects • Explain OOPS Concepts • Explain Polymorphism • Explain Main Method in Java Student 18 • Tell me about yourself? • Explain about your project with detailed • (Some questions are asked on the projects) • Difference between Python and java • Explain about the inheritance • What are your hobbies? • Why Capgemini? • Do you have any questions? Student 19 • Introduction • Project description in detail • Difference between Java and Python • Polymorphism • Inheritance • Array • Main features of java and JVM • Why Capgemini • Aws certification • Linux • Extracurricular activities • Do you have any questions? Student 20 • Self Intro • Projects in detail (Asked me to explain all the mentioned projects on resume and faced more number of questions) • Short term goals and long-term goals • Do you have any questions? Student 21 • Self-introduction • About projects • What is your role in the project • What motivates you when u feel low • Who is your ideal • Short term and long-term goal • What are your recent achievements • Do you have any questions Student 22 • Self-introduction • About project • Different between interface and class • What is an object • Oops concepts • 4 pillars of oops in detail • Polymorphism code • Inheritance code • Even code • What is constructor Student 23 • Self Intro • Projects • SQL Relations One to One and all those relations • MAP in java • Programming factorial and palindrome • Family background • Any other questions Student 24 • Self-introduction • About project • Role of your project • Oops concepts • What is object and class • Stored procedure • What is database • Local variables and global variables • Union and Union all • About your college life Student 25 • Self intro • Projects • How to send data to the backend • Multi-threading • Method overloading and method overriding • Problems faced while working on projects • Family background • Any other questions Student 26 • Introduction • Projects • Any difficulties faced in projects? • What languages do you know? • Constructors and its types • Access specifiers • Method overloading and method overriding • Call by reference and call by value • Difference between ddl and dml • Group by and having in mysql • Exceptions and why we use it • What have you done in your internship? • List, tuple and set • Continue, break and do while • Synchronisation in java • Joins and its types • Primary key and foreign key Student 27 • Self intro • Project explanation in detail • Exception in java • Thread in java • JVM, JDK, JRE • Map in java • Object and class • Method overriding, method overloading • Features of java, python and c • Oops in java • MySQL - joins • Indexing • Group by • Normalisation, Denormalization • Java - Access specifies • Primary key, foreign key • Pointers in c • Any questions Student 28 • Self intro • Projects in detail • Code to check if string is palindrome • Primary key and foreign key • Why Capgemini • Any questions Student 29 • Self-Introduction • What is the recent project you've worked on • Palindrome code • What is primary key • What is unique key • Difference between truncate and delete • What are the difficulties you faced while working on your project Student 30 - MCA • what is arithmetic progression • what is gp • Difference between differentiation and integration Machine learning Io • NLP • Random forest • Cross validation • Decision trees • Ensemble learning • Python Io • Docstring • Basic advantages of python • Lambda functions • Ques on modern tech • ChatGPT with ai • Prompt engineering • Why MTech • Why AI&DS • Do you have questions

Student 16 • Introduction about your self • Why Capgemini? • About Projects • What is the problem you faced in your project? • Which technology used? • How many members in your team and what is your role in project? • What are the pillars of oops? • What is inheritance? • What is super class and subclass? • What is constructor and deconstructor? • You have any questions? Student 17 • Introduce yourself • About Projects • Explain OOPS Concepts • Explain Polymorphism • Explain Main Method in Java Student 18 • Tell me about yourself? • Explain about your project with detailed • (Some questions are asked on the projects) • Difference between Python and java • Explain about the inheritance • What are your hobbies? • Why Capgemini? • Do you have any questions? Student 19 • Introduction • Project description in detail • Difference between Java and Python • Polymorphism • Inheritance • Array • Main features of java and JVM • Why Capgemini • Aws certification • Linux • Extracurricular activities • Do you have any questions? Student 20 • Self Intro • Projects in detail (Asked me to explain all the mentioned projects on resume and faced more number of questions) • Short term goals and long-term goals • Do you have any questions? Student 21 • Self-introduction • About projects • What is your role in the project • What motivates you when u feel low • Who is your ideal • Short term and long-term goal • What are your recent achievements • Do you have any questions Student 22 • Self-introduction • About project • Different between interface and class • What is an object • Oops concepts • 4 pillars of oops in detail • Polymorphism code • Inheritance code • Even code • What is constructor Student 23 • Self Intro • Projects • SQL Relations One to One and all those relations • MAP in java • Programming factorial and palindrome • Family background • Any other questions Student 24 • Self-introduction • About project • Role of your project • Oops concepts • What is object and class • Stored procedure • What is database • Local variables and global variables • Union and Union all • About your college life Student 25 • Self intro • Projects • How to send data to the backend • Multi-threading • Method overloading and method overriding • Problems faced while working on projects • Family background • Any other questions Student 26 • Introduction • Projects • Any difficulties faced in projects? • What languages do you know? • Constructors and its types • Access specifiers • Method overloading and method overriding • Call by reference and call by value • Difference between ddl and dml • Group by and having in mysql • Exceptions and why we use it • What have you done in your internship? • List, tuple and set • Continue, break and do while • Synchronisation in java • Joins and its types • Primary key and foreign key Student 27 • Self intro • Project explanation in detail • Exception in java • Thread in java • JVM, JDK, JRE • Map in java • Object and class • Method overriding, method overloading • Features of java, python and c • Oops in java • MySQL - joins • Indexing • Group by • Normalisation, Denormalization • Java - Access specifies • Primary key, foreign key • Pointers in c • Any questions Student 28 • Self intro • Projects in detail • Code to check if string is palindrome • Primary key and foreign key • Why Capgemini • Any questions Student 29 • Self-Introduction • What is the recent project you've worked on • Palindrome code • What is primary key • What is unique key • Difference between truncate and delete • What are the difficulties you faced while working on your project Student 30 - MCA • what is arithmetic progression • what is gp • Difference between differentiation and integration Machine learning Io • NLP • Random forest • Cross validation • Decision trees • Ensemble learning • Python Io • Docstring • Basic advantages of python • Lambda functions • Ques on modern tech • ChatGPT with ai • Prompt engineering • Why MTech • Why AI&DS • Do you have questions Student 31 • Self intro • Family background • Languages you know • What is jvm, jre, jdk • Different types of constructors • Oops concepts • Types of inheritance • Jit compiler • Factorial code • Wrapper classes • What is SQL • How many relations are there in SQL • Why should we hire you • Different types of data types • What is the default value for a variable • What is string pool • Different types of keys • Do you have any questions Student 32 • Self-introduction • Projects in detail • What challenges are faced how you overcome • What is your role in the project • Joints in sql with examples • Have and clause • Why should you join the cap Gemini • How can you overcome your conflicts in the team • What can you do if there is any miscommunication in the team • Any questions Student 33 • Self intro • About project in detail • Do you face any problems with your team while doing the project • Do you face any problems while doing project • Anyone from the reviewer told any mistakes in your projects • Questions on AWS • Why do you select Capgemini • Exceptional handling • Polymorphism and examples • About oops • Disadvantages of oops • Four pillars of oops • Sub class and superclass • Garbage collector • Constructors • Inheritance and types • Can we use pointers in java • What is an array and types • Which year you are studying • Is your college based on semester wise or yearly wise Student 34 • Oops based concepts • SQL joints • About project • About SQL commands and super key word • Data types in SQL • Map, collections in java • List, Set in java • Any questions Student 35 • Self-introduction • About project • What have you done in project • Palindrome code • Difference between Array & List • What is slicing • Difference between Array & Stack • Any internship? If done what is your role? • What are pause, break & continue statements Student 36 • Intro with family background • Projects and questions • Multi-threading • Exceptions • Sorting • Certifications • Over loading and over riding • Api • Challenges faced • Which Payment gateway used in project • Any queries for me Student 37 • Self-introduction • Final year project • Challenges faced during project • What is the role in the project • How do you implement the feedback from guide in the project • Why Capgemini • Family background • Hobbies and interests

Student 16 • Introduction about your self • Why Capgemini? • About Projects • What is the problem you faced in your project? • Which technology used? • How many members in your team and what is your role in project? • What are the pillars of oops? • What is inheritance? • What is super class and subclass? • What is constructor and deconstructor? • You have any questions? Student 17 • Introduce yourself • About Projects • Explain OOPS Concepts • Explain Polymorphism • Explain Main Method in Java Student 18 • Tell me about yourself? • Explain about your project with detailed • (Some questions are asked on the projects) • Difference between Python and java • Explain about the inheritance • What are your hobbies? • Why Capgemini? • Do you have any questions? Student 19 • Introduction • Project description in detail • Difference between Java and Python • Polymorphism • Inheritance • Array • Main features of java and JVM • Why Capgemini • Aws certification • Linux • Extracurricular activities • Do you have any questions? Student 20 • Self Intro • Projects in detail (Asked me to explain all the mentioned projects on resume and faced more number of questions) • Short term goals and long-term goals • Do you have any questions? Student 21 • Self-introduction • About projects • What is your role in the project • What motivates you when u feel low • Who is your ideal • Short term and long-term goal • What are your recent achievements • Do you have any questions Student 22 • Self-introduction • About project • Different between interface and class • What is an object • Oops concepts • 4 pillars of oops in detail • Polymorphism code • Inheritance code • Even code • What is constructor Student 23 • Self Intro • Projects • SQL Relations One to One and all those relations • MAP in java • Programming factorial and palindrome • Family background • Any other questions Student 24 • Self-introduction • About project • Role of your project • Oops concepts • What is object and class • Stored procedure • What is database • Local variables and global variables • Union and Union all • About your college life Student 25 • Self intro • Projects • How to send data to the backend • Multi-threading • Method overloading and method overriding • Problems faced while working on projects • Family background • Any other questions Student 26 • Introduction • Projects • Any difficulties faced in projects? • What languages do you know? • Constructors and its types • Access specifiers • Method overloading and method overriding • Call by reference and call by value • Difference between ddl and dml • Group by and having in mysql • Exceptions and why we use it • What have you done in your internship? • List, tuple and set • Continue, break and do while • Synchronisation in java • Joins and its types • Primary key and foreign key Student 27 • Self intro • Project explanation in detail • Exception in java • Thread in java • JVM, JDK, JRE • Map in java • Object and class • Method overriding, method overloading • Features of java, python and c • Oops in java • MySQL - joins • Indexing • Group by • Normalisation, Denormalization • Java - Access specifies • Primary key, foreign key • Pointers in c • Any questions Student 28 • Self intro • Projects in detail • Code to check if string is palindrome • Primary key and foreign key • Why Capgemini • Any questions Student 29 • Self-Introduction • What is the recent project you've worked on • Palindrome code • What is primary key • What is unique key • Difference between truncate and delete • What are the difficulties you faced while working on your project Student 30 - MCA • what is arithmetic progression • what is gp • Difference between differentiation and integration Machine learning Io • NLP • Random forest • Cross validation • Decision trees • Ensemble learning • Python Io • Docstring • Basic advantages of python • Lambda functions • Ques on modern tech • ChatGPT with ai • Prompt engineering • Why MTech • Why AI&DS • Do you have questions Student 31 • Self intro • Family background • Languages you know • What is jvm, jre, jdk • Different types of constructors • Oops concepts • Types of inheritance • Jit compiler • Factorial code • Wrapper classes • What is SQL • How many relations are there in SQL • Why should we hire you • Different types of data types • What is the default value for a variable • What is string pool • Different types of keys • Do you have any questions Student 32 • Self-introduction • Projects in detail • What challenges are faced how you overcome • What is your role in the project • Joints in sql with examples • Have and clause • Why should you join the cap Gemini • How can you overcome your conflicts in the team • What can you do if there is any miscommunication in the team • Any questions Student 33 • Self intro • About project in detail • Do you face any problems with your team while doing the project • Do you face any problems while doing project • Anyone from the reviewer told any mistakes in your projects • Questions on AWS • Why do you select Capgemini • Exceptional handling • Polymorphism and examples • About oops • Disadvantages of oops • Four pillars of oops • Sub class and superclass • Garbage collector • Constructors • Inheritance and types • Can we use pointers in java • What is an array and types • Which year you are studying • Is your college based on semester wise or yearly wise Student 34 • Oops based concepts • SQL joints • About project • About SQL commands and super key word • Data types in SQL • Map, collections in java • List, Set in java • Any questions Student 35 • Self-introduction • About project • What have you done in project • Palindrome code • Difference between Array & List • What is slicing • Difference between Array & Stack • Any internship? If done what is your role? • What are pause, break & continue statements Student 36 • Intro with family background • Projects and questions • Multi-threading • Exceptions • Sorting • Certifications • Over loading and over riding • Api • Challenges faced • Which Payment gateway used in project • Any queries for me Student 37 • Self-introduction • Final year project • Challenges faced during project • What is the role in the project • How do you implement the feedback from guide in the project • Why Capgemini • Family background • Hobbies and interests

I collect all these questions from my college during Capgemini Interview (28 Dec 2024) Student 1 • Intro • Projects • Code Explanation: Printing even numbers from 50-4 • Differences of If and if-else • Break and continue, • primary super candidate keys • Why Capgemini and why did you apply for this? • How did you suit for this? • Extracurricular activities? • How to resolve any problem you face? • Have you worked in any team and what's your role? • Any questions for me? Student 2 • Intro • About Projects? • About AIMI internship? • What is RDBMs? • What is indexing? • Triggers in SQL? • Exception handling in java and its types? • Lambda. In python? • How to remove file in python? • Advantages of python language? • Advantages of java language? • Features of java? • JDBC? • API? • Which Subjects studied in b tech? • Which subjects studies in intermediate? • About Java full stack development? • About Python full stack development? • Any questions for me? Student 3 • Self-introduction • About project? • What is diode and how many types? • What is SER? • Why do we use hash symbols in python? • What is mutable and immutable data type? • Why we use slash and double slash in division rule? • How you delete a file in python • What is and JIT? • Explain oops concept? • How many types in inheritance what are they? • Any questions for me? • What is RDBMs? • What is indexing? • Triggers in SQL? • Exception handling in java and its types? • Lambda. In python Student 4 • Intro • projects • Explanation: How do you face and manage any technical issues while done your project time • Explain about certifications • What technical skills would you capable • Keywords used in java • Sorting technics • Explain in Quick sort in single sentence, • How do we connect database, Implementation of projects, • Which algorithms used in your project and explain on it. • Explain in Back-End and Front-End and difference. • Non-Technical: Why you choose Capgemini? • How do you know about Capgemini? • Can you ask any questions for me? Student 5 • Tell me about yourself • Project explanation (in detail) • Code: if given string is vowel • Delete and drop • Primary key and foreign key Student 6 • Tell me about yourself • Project explanation ( in detail) • Html tags & linking css to html • How to connect python to the database • Primary key • Foreign key • Join • Explain oops concepts • Types of inheritance • Advantages of java • Disadvantages of java • What is your aim Student 7 • WHAT IS FULL FORM OF KLU • RPA FULL FORM • AWS CLOUD PRACTITIONER • PROJECT RELATED QUESTIONS (NON-TECHNICAL) • HOW DO YOU WRITE SQL QUERIES • PRIMARY KEY AND FOREIGN KEY • INDEXING • DATA TYPES IN SQL • WHAT IS SYNONYM IN SQL • WHAT IS TRIGGER • WHAT IS DATABASE SCHEMA • WHAT IS EXCEPTIONAL HANDLING • WHAT IS FULL FORM OF HTML, CSS Student 8 • Tell me about yourself • Which language comfortable with • Projects • Questions on projects • java or python • Inheritance • Polymorphism • Abstraction • What is public static void main • Role in project • Hobbies • Interests apart from academics • Why Cap Gemini • Any questions Student 9 • Tell me about yourself • Project Explanation (in detail) • If you were a team leader, how would you manage your team • What is your ambition • Why Capgemini • Hobbies • Any questions Student 10 • Self intro • Project explanation • Advantages and disadvantages of projects • Oops concepts? • Polymorphism code? • what is method? • Public static? • Extends keyword? • Constructor? • Instance method? • Non static and static members? • Override in java? • Access modifiers? Student 11 • Tell me about yourself? • About internships? • In detail about projects? • What are the problems faced doing project? • Reverse a String? (code) • Joins In SQL? • you do have any question on me? Student 12 • Introduction • Why Capgemini • Project • Challenges faced • Questions on Backend • Technical Skills • Sorting techniques • About Quick sort • Exception handling • Multi-threading • Overloading and overriding • Examples on overloading and overriding • Any questions for me? Student 13 • Introduce yourself? • What are the projects you did? • Show the project document? • Tell me about the services you used? • What is lambda you used project? • Explain the code through API? • Can you write the sample code for the API? • What is your favourite technology? • Do you know Data Structures? • What is your favourite Data Structure? • Write a sample code on Stack? • Any questions for me? Student 14 • Tell me about your self • Project explanation • Slicing • Difference between lists and arrays • Continue, break, pass • What are packages in java • Oops concept and detailed • About the internship and what we have done in internship • With how many members did do the project • With is your role in project • Codes: • Palindrome number • Pattern printing Student 15 • Introduce yourself • About project • What is Oops Concept? • What are the Main pillars of Oops? • What is polymorphism and types? • Write example code for polymorphism? • what is constructor? • what is object? • what is a class? • Feedback

just the recomendation , you can specify the column or row , so it will be complicated data , and people will learn it in complex way

Ye to sir k upar se gaya

Nice video. Very much helpful. Thank you very much.....

Excellent , i was facing issue in Row_number() function , now got it it is working fine , thank oytu soc much code Era

Using limit clause can we find 4th and 5th salary ? Pls confirm

SELECT * FROM `employee` e1 WHERE 3 - 1 = ( SELECT COUNT(DISTINCT e2.salary) FROM `employee` e2 WHERE e2.salary > e1.salary );

The answer of 1st question is not correct the correct answer is as following Select dept_name,count(emp_id) From department Inner join employee On department.dept_id=employee . Dept_id Group by dept_name Having count(emp_id)>2; You can alise if you want 😊

definitely, I will come back to say special thank to YOU medam.

sb smjh a gya

mam mere me to jab mai order by salary desc ka use kar raha hu to null value top par aa rahe ha

Thank you ma'am helpful video

Is there any other topics in this playlist mam?

SELECT ID, NAME, DOB, DATE_SUB(DOB, INTERVAL 3 YEAR) AS UPDATED_DATE_OF_BIRTH FROM EMPLOYEE

PLEASE WHEN WILL YOU TREAT WINDOWS FUNCTIONS I DO CHECK YOUR VIDEOES EVERY DAY VERY EASY TO UNDERSTAND THANK YOU

DONE

Mam videos are usefull, upload videos continuously mam and upload practice questions for "Subquery" and "Joins" in your "codeera netlify app" website Mam.

for the second question the right answer is: SELECT DISTINCT salary FROM employeeinfo e1 WHERE(SELECT COUNT(DISTINCT salary) FROM employeeinfo e2 WHERE (e2.salary>e1.salary)=N-1;

Mam your videos are very useful & understandable. Upload videos continuously.

Nice Session, It will help for interview

we can find even no also like this id%2=0; for odd no: id%2!=0;

select * from employee where progress LIKE '%\%%';

wat abt the resume do they ask it again?

Veru good video

Thank you Ma'am :)

Correction at 9:59 you can not have such query as you can have only 1 column as primary key column in DB tables so if you want combination of two columns as primary key your previous example was perfect !!! Cheers great explanation!!

Nice explanation mam !! excited to watch your upcoming videos !!

thanks

Veri good

In My SQL how to delete duplicate rows inside the table without unique identifier...? My table name: accounts My column names: username and firstname

finally

Normalization present in DBMS.

Thanks

Welcome welcome

I got all the queries but why and how only left join we have used why not other joins??

Mam, Thankyou .... After so many years .... Finally uploaded !!! yeah !!!!

Nice explanation👌👌

Thanks for everything. With love Mike

Select id,name, date_sub(dob,interval 3, Year) as updated_date_of_birth from employee;