1. Data Definition (DDL)
This is all about creating, changing, and removing the parts of a database.
Challenges: Many students find it hard to understand the rules (syntax) and concepts like primary keys and foreign keys.
Tips: To get better, try hands-on practice and use visual tools. They can help you see how things work more clearly.
2. Data Manipulation (DML)
This is about asking questions and changing the information inside the database.
Challenges: Some students feel confused when dealing with complex queries or trying to understand how joins work.
Tips: Start with simple queries first. Once you're comfortable, try more complicated ones. Use helpful resources like tutorials and talk with your classmates to learn more.
1. Data Definition (DDL)
This is all about creating, changing, and removing the parts of a database.
Challenges: Many students find it hard to understand the rules (syntax) and concepts like primary keys and foreign keys.
Tips: To get better, try hands-on practice and use visual tools. They can help you see how things work more clearly.
2. Data Manipulation (DML)
This is about asking questions and changing the information inside the database.
Challenges: Some students feel confused when dealing with complex queries or trying to understand how joins work.
Tips: Start with simple queries first. Once you're comfortable, try more complicated ones. Use helpful resources like tutorials and talk with your classmates to learn more.