Description
In this course, you will learn:
- An comprehension of SQL's declarative nature
- The ability to learn to write SQL queries
- Extensive expertise developing SQL queries to find critical information
- Data creation, updating, and deletion
Syllabus :
1. Displaying Results
- Selecting Display Fields and Specifying the Data Source
- Fetching Unique Results
2. Filtering Data
- Specifying the Filter Criteria
- Working with String Data Type
- Logical Operators and Compound Conditions
3. Sorting, Aggregating, and Grouping Data
- Sorting Data
- Data Aggregation and Grouping
- Putting It All Together
4. Building a Database: Creating Tables and Managing Data
- Creating Tables
- Adding New Data to the Database
- Modifying Data