SQL is a standard language used to interact with relational databases. It allows you to retrieve information, update records, and manage database structures. Popular database systems that use SQL include Microsoft SQL Server, Oracle, MySQL, PostgreSQL, and others. While each system may offer its own additional features, the core SQL commands such as Select, Insert, Update, Delete, Create, and Drop work across all major platforms.
Lesson 1: Executing a Simple Query
- Topic A: Connect to a SQL database
- Topic B: Run basic queries to retrieve information
- Topic C: Save queries for reuse
- Topic D: Edit and run previously saved queries
Lesson 2: Performing a Conditional Search
- Topic A: Filter results using one or multiple conditions
- Topic B: Search within ranges and work with NULL values
- Topic C: Find data using pattern matching
Lesson 3: Working with Functions
- Topic A: Use date functions to perform calculations
- Topic B: Apply aggregate functions to summarize data
- Topic C: Modify and format text using string functions
Lesson 4: Organizing Data
- Topic A: Sort query results
- Topic B: Rank data within a result set
- Topic C: Group records for analysis
- Topic D: Filter grouped information
- Topic E: Produce summary results from grouped data
- Topic F: Reshape data using PIVOT and UNPIVOT
