Basics of SQL 👇👇
1. SQL (Structured Query Language) is a standard programming language used for managing and manipulating relational databases.
2. SQL operates through simple, declarative statements. These statements are used to perform tasks such as querying data, updating data, inserting data, and deleting data from a database.
3. The basic SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
4. The SELECT statement is used to retrieve data from a database. It allows you to specify the columns you want to retrieve and filter the results using conditions.
5. The INSERT statement is used to add new records to a table in a database.
6. The UPDATE statement is used to modify existing records in a table.
7. The DELETE statement is used to remove records from a table.
8. The CREATE statement is used to create new tables, indexes, or views in a database.
9. The DROP statement is used to remove tables, indexes, or views from a database.
10. SQL also supports various operators such as AND, OR, NOT, LIKE, IN, BETWEEN, and ORDER BY for filtering and sorting data.
11. SQL also allows for the use of functions and aggregate functions like SUM, AVG, COUNT, MIN, and MAX to perform calculations on data.
12. SQL statements are case-insensitive but conventionally written in uppercase for readability.
13. SQL databases are relational databases that store data in tables with rows and columns. Tables can be related to each other through primary and foreign keys.
14. SQL databases use transactions to ensure data integrity and consistency. Transactions can be committed (saved) or rolled back (undone) based on the success of the operations.
15. SQL databases support indexing for faster data retrieval and performance optimization.
16. SQL databases can be queried using tools like MySQL, PostgreSQL, Oracle Database, SQL Server, SQLite, and others.
1. SQL (Structured Query Language) is a standard programming language used for managing and manipulating relational databases.
2. SQL operates through simple, declarative statements. These statements are used to perform tasks such as querying data, updating data, inserting data, and deleting data from a database.
3. The basic SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
4. The SELECT statement is used to retrieve data from a database. It allows you to specify the columns you want to retrieve and filter the results using conditions.
5. The INSERT statement is used to add new records to a table in a database.
6. The UPDATE statement is used to modify existing records in a table.
7. The DELETE statement is used to remove records from a table.
8. The CREATE statement is used to create new tables, indexes, or views in a database.
9. The DROP statement is used to remove tables, indexes, or views from a database.
10. SQL also supports various operators such as AND, OR, NOT, LIKE, IN, BETWEEN, and ORDER BY for filtering and sorting data.
11. SQL also allows for the use of functions and aggregate functions like SUM, AVG, COUNT, MIN, and MAX to perform calculations on data.
12. SQL statements are case-insensitive but conventionally written in uppercase for readability.
13. SQL databases are relational databases that store data in tables with rows and columns. Tables can be related to each other through primary and foreign keys.
14. SQL databases use transactions to ensure data integrity and consistency. Transactions can be committed (saved) or rolled back (undone) based on the success of the operations.
15. SQL databases support indexing for faster data retrieval and performance optimization.
16. SQL databases can be queried using tools like MySQL, PostgreSQL, Oracle Database, SQL Server, SQLite, and others.
👍3🔥3
In Object oriented programming,new class can be defined by extending existing classes .This is an example of :
Anonymous Quiz
63%
A.Inheritance
6%
B.Inference
0%
C.Composition
31%
D.Encapsulation
👍3
Which of these alternatives is correct way of inheriting class shape by class square?
Anonymous Quiz
46%
A.class square extends class shape {}
8%
B.class square inherits class shape {}
46%
C.class square extends shape {}
0%
D.class square + class shape {}
🔥2👍1
SenCH | Tech :)
https://youtu.be/F2IYe2I2GHM?si=f9CfEs_h2ALrfklf
Guys check this podcast out...you would luv it for sure😊
👍6
SenCH | Tech :)
https://youtu.be/F2IYe2I2GHM?si=f9CfEs_h2ALrfklf
It's the best you won't regret investing your time on it.
🤗5
🔥 Developer Roadmaps 2023
ከየት መጀመር እና እንዴት በቀላሉ መማር እንዳለብን የሚረዳን ሮድማፕ/ ፍኖተ ካርታ 😵💫
🚩 Full Stack Developer
🔗 https://roadmap.sh/full-stack
🚩 Node.js Developer
🔗 https://roadmap.sh/nodejs
🚩 Docker Roadmap
🔗 https://roadmap.sh/docker
🚩🚩 Python Developer
🔗 https://roadmap.sh/python
🚩🚩 Go Developer
🔗 https://roadmap.sh/golang
🚩🚩 Java Developer
🔗 https://roadmap.sh/java
🔤🔤 🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩
#frontend #WebDevelopment #practice #skills #roadmap
ከየት መጀመር እና እንዴት በቀላሉ መማር እንዳለብን የሚረዳን ሮድማፕ/ ፍኖተ ካርታ 😵💫
Step by step guides and paths to learn different tools or technologies . ✔️
🚩 Full Stack Developer
🔗 https://roadmap.sh/full-stack
🚩 Node.js Developer
🔗 https://roadmap.sh/nodejs
🚩 Docker Roadmap
🔗 https://roadmap.sh/docker
🚩🚩 Python Developer
🔗 https://roadmap.sh/python
🚩🚩 Go Developer
🔗 https://roadmap.sh/golang
🚩🚩 Java Developer
🔗 https://roadmap.sh/java
🔤🔤 🚩🚩🚩🚩🚩🚩🚩🚩🚩🚩
#frontend #WebDevelopment #practice #skills #roadmap
roadmap.sh
Full Stack Developer Roadmap
Step by step guide to becoming a modern full stack developer in 2026
🫡3⚡1👍1
Which building block of OOP refers to user-defined data types that act as the blueprint for individual objects,attributes and methods ?
Anonymous Quiz
7%
Attributes
67%
Classes
20%
Methods
7%
Object
Which of the following is FALSE about transaction(T) in Database?
Anonymous Quiz
11%
It requires high availability and fast response time for hundreds of concurrent user.
11%
It's a logical unit of database processing that include one or more database access operations
0%
It's maybe embedded within an application
78%
It may not Begin /end transaction Boundary
👍3🔥1