Andrian Christian Paul Gadin BSEMC2B ACTIVITY TASK MODULE 3 INFMNGT LECTURE 1. what are the basic sql expression? a sql query is an expression that defines the set of data to be retrieved from the database 2. what is the difference between simple equijoin and natural join? an equi join matches rows where values in both tables are equal. in a natural join, however, data is matched based on column names that are common between tables. 3. what are the different types of join? there are four main types of joins in sql: inner join outer join cross join self join. 4. what are the different components of sql structure? there are four different components of sql structure: the data manipulation language (dml) the data definition language (ddl) the d...
Posts
Showing posts from October, 2023