๐ฐ ๐ฃ๐ผ๐๐ฒ๐ฟ๐ณ๐๐น ๐๐ฟ๐ฒ๐ฒ ๐ฅ๐ผ๐ฎ๐ฑ๐บ๐ฎ๐ฝ๐ ๐๐ผ ๐ ๐ฎ๐๐๐ฒ๐ฟ ๐๐ฎ๐๐ฎ๐ฆ๐ฐ๐ฟ๐ถ๐ฝ๐, ๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ, ๐๐/๐ ๐ & ๐๐ฟ๐ผ๐ป๐๐ฒ๐ป๐ฑ ๐๐ฒ๐๐ฒ๐น๐ผ๐ฝ๐บ๐ฒ๐ป๐ ๐
Learn Tech the Smart Way: Step-by-Step Roadmaps for Beginners๐
Learning tech doesnโt have to be overwhelmingโespecially when you have a roadmap to guide you!๐๐
๐๐ข๐ง๐ค๐:-
https://pdlink.in/45wfx2V
Enjoy Learning โ ๏ธ
Learn Tech the Smart Way: Step-by-Step Roadmaps for Beginners๐
Learning tech doesnโt have to be overwhelmingโespecially when you have a roadmap to guide you!๐๐
๐๐ข๐ง๐ค๐:-
https://pdlink.in/45wfx2V
Enjoy Learning โ ๏ธ
๐1
Data Science Interview Questions
1. What are the different subsets of SQL?
Data Definition Language (DDL) โ It allows you to perform various operations on the database such as CREATE, ALTER, and DELETE objects.
Data Manipulation Language(DML) โ It allows you to access and manipulate data. It helps you to insert, update, delete and retrieve data from the database.
Data Control Language(DCL) โ It allows you to control access to the database. Example โ Grant, Revoke access permissions.
2. List the different types of relationships in SQL.
There are different types of relations in the database:
One-to-One โ This is a connection between two tables in which each record in one table corresponds to the maximum of one record in the other.
One-to-Many and Many-to-One โ This is the most frequent connection, in which a record in one table is linked to several records in another.
Many-to-Many โ This is used when defining a relationship that requires several instances on each sides.
Self-Referencing Relationships โ When a table has to declare a connection with itself, this is the method to employ.
3. How to create empty tables with the same structure as another table?
To create empty tables:
Using the INTO operator to fetch the records of one table into a new table while setting a WHERE clause to false for all entries, it is possible to create empty tables with the same structure. As a result, SQL creates a new table with a duplicate structure to accept the fetched entries, but nothing is stored into the new table since the WHERE clause is active.
4. What is Normalization and what are the advantages of it?
Normalization in SQL is the process of organizing data to avoid duplication and redundancy. Some of the advantages are:
Better Database organization
More Tables with smaller rows
Efficient data access
Greater Flexibility for Queries
Quickly find the information
Easier to implement Security
1. What are the different subsets of SQL?
Data Definition Language (DDL) โ It allows you to perform various operations on the database such as CREATE, ALTER, and DELETE objects.
Data Manipulation Language(DML) โ It allows you to access and manipulate data. It helps you to insert, update, delete and retrieve data from the database.
Data Control Language(DCL) โ It allows you to control access to the database. Example โ Grant, Revoke access permissions.
2. List the different types of relationships in SQL.
There are different types of relations in the database:
One-to-One โ This is a connection between two tables in which each record in one table corresponds to the maximum of one record in the other.
One-to-Many and Many-to-One โ This is the most frequent connection, in which a record in one table is linked to several records in another.
Many-to-Many โ This is used when defining a relationship that requires several instances on each sides.
Self-Referencing Relationships โ When a table has to declare a connection with itself, this is the method to employ.
3. How to create empty tables with the same structure as another table?
To create empty tables:
Using the INTO operator to fetch the records of one table into a new table while setting a WHERE clause to false for all entries, it is possible to create empty tables with the same structure. As a result, SQL creates a new table with a duplicate structure to accept the fetched entries, but nothing is stored into the new table since the WHERE clause is active.
4. What is Normalization and what are the advantages of it?
Normalization in SQL is the process of organizing data to avoid duplication and redundancy. Some of the advantages are:
Better Database organization
More Tables with smaller rows
Efficient data access
Greater Flexibility for Queries
Quickly find the information
Easier to implement Security
๐2
๐ด ๐๐ฒ๐๐ ๐๐ฟ๐ฒ๐ฒ ๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ ๐๐ผ๐๐ฟ๐๐ฒ๐ ๐ณ๐ฟ๐ผ๐บ ๐๐ฎ๐ฟ๐๐ฎ๐ฟ๐ฑ, ๐ ๐๐ง & ๐ฆ๐๐ฎ๐ป๐ณ๐ผ๐ฟ๐ฑ๐
๐ Learn Data Science for Free from the Worldโs Best Universities๐
Top institutions like Harvard, MIT, and Stanford are offering world-class data science courses online โ and theyโre 100% free. ๐ฏ๐
๐๐ข๐ง๐ค๐:-
https://pdlink.in/3Hfpwjc
All The Best ๐
๐ Learn Data Science for Free from the Worldโs Best Universities๐
Top institutions like Harvard, MIT, and Stanford are offering world-class data science courses online โ and theyโre 100% free. ๐ฏ๐
๐๐ข๐ง๐ค๐:-
https://pdlink.in/3Hfpwjc
All The Best ๐
Forwarded from Python Projects & Resources
๐๐ฒ๐ฎ๐ฟ๐ป ๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ ๐ถ๐ป ๐๐๐๐ ๐ฏ ๐ ๐ผ๐ป๐๐ต๐ ๐๐ถ๐๐ต ๐ง๐ต๐ถ๐ ๐๐ฟ๐ฒ๐ฒ ๐๐ถ๐๐๐๐ฏ ๐ฅ๐ผ๐ฎ๐ฑ๐บ๐ฎ๐ฝ๐
๐ฏ Want to Master Data Science in Just 3 Months?๐
Feeling overwhelmed by the sheer volume of resources and donโt know where to start? Youโre not alone๐
๐๐ข๐ง๐ค๐:-
https://pdlink.in/43uHPrX
This FREE GitHub roadmap is a game-changer for anyoneโ ๏ธ
๐ฏ Want to Master Data Science in Just 3 Months?๐
Feeling overwhelmed by the sheer volume of resources and donโt know where to start? Youโre not alone๐
๐๐ข๐ง๐ค๐:-
https://pdlink.in/43uHPrX
This FREE GitHub roadmap is a game-changer for anyoneโ ๏ธ
Forwarded from Artificial Intelligence
๐ง๐ผ๐ฝ ๐๐ผ๐บ๐ฝ๐ฎ๐ป๐ถ๐ฒ๐ ๐๐ถ๐ฟ๐ถ๐ป๐ด ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐๐๐
๐๐ฝ๐ฝ๐น๐ ๐๐ถ๐ป๐ธ๐:-๐
S&P Global :- https://pdlink.in/3ZddwVz
IBM :- https://pdlink.in/4kDmMKE
TVS Credit :- https://pdlink.in/4mI0JVc
Sutherland :- https://pdlink.in/4mGYBgg
Other Jobs :- https://pdlink.in/44qEIDu
Apply before the link expires ๐ซ
๐๐ฝ๐ฝ๐น๐ ๐๐ถ๐ป๐ธ๐:-๐
S&P Global :- https://pdlink.in/3ZddwVz
IBM :- https://pdlink.in/4kDmMKE
TVS Credit :- https://pdlink.in/4mI0JVc
Sutherland :- https://pdlink.in/4mGYBgg
Other Jobs :- https://pdlink.in/44qEIDu
Apply before the link expires ๐ซ