Get in Touch
 Duration 10 hours

Course Outline

Introduction to SQL and Relational Databases

  • Grasping database architectures
  • Overview of SQL syntax
  • Interacting with tables and schemas

Fundamental Querying Methods

  • Selecting and projecting data
  • Filtering rows using the WHERE clause
  • Ordering results with the ORDER BY clause

Combining Multiple Tables

  • Inner, left, right, and full outer joins
  • Merging datasets from various sources
  • Defining join conditions

Aggregations and Grouping

  • Utilizing COUNT, SUM, AVG, MIN, and MAX
  • Effectively applying the GROUP BY clause
  • Filtering grouped data with the HAVING clause

Subqueries and Nested Statements

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

Data Manipulation and Modification

  • Inserting new data
  • Modifying existing records
  • Safely deleting data

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 optimization basics

Recap and Future Steps

Requirements

  • A grasp of fundamental data concepts
  • Familiarity with spreadsheets or tabular data formats
  • Knowledge of general business applications

Target Audience

  • Data analysts
  • IT professionals
  • Individuals requiring the ability to manage, query, and analyze data

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories