Đề cương khóa học

Introduction to SQL and Relational Databases

  • Understanding database structures
  • Overview of SQL syntax
  • Working with tables and schemas

Basic Querying Techniques

  • Selecting and projecting data
  • Filtering rows with WHERE
  • Sorting results using ORDER BY

Joining Multiple Tables

  • Inner, left, right, and full joins
  • Combining datasets from multiple sources
  • Resolving join conditions

Aggregations and Grouping

  • Using COUNT, SUM, AVG, MIN, MAX
  • Applying GROUP BY effectively
  • Filtering grouped data with HAVING

Subqueries and Nested Statements

  • Scalar subqueries
  • Correlated subqueries
  • Using subqueries for filtering and calculations

Data Manipulation and Modification

  • Inserting new data
  • Updating existing records
  • Deleting data safely

Database Objects and Constraints

  • Understanding primary and foreign keys
  • Working with views
  • Implementing constraints and rules

Advanced SQL Techniques

  • Window functions
  • Common Table Expressions (CTEs)
  • Performance considerations and query tuning basics

Summary and Next Steps

Yêu cầu

  • An understanding of basic data concepts
  • Experience with spreadsheets or tabular data
  • Familiarity with general business applications

Audience

  • Data analysts
  • IT professionals
  • Users who need to manage, query, and analyze data
 10 Giờ học

Số người tham gia


Giá cho mỗi người tham gia

Đánh giá (5)

Các khóa học sắp tới

Các danh mục liên quan