Ocean Stack

SQL Fundamentals & C# Integration Course

A practical introduction to SQL and its integration with C#. You’ll learn how to write queries, design databases, and connect them to C# applications. Great for anyone looking to master data-driven apps or add database functionality to their software projects.

🗓️ Course Schedule: SQL Fundamentals & C# Integration

Duration: 2 Days
Time: 10:00 AM – 4:00 PM Daily
Format: Live Query Writing • Schema Design • C# Integration

🔹 Day 1: SQL Essentials & Relational Thinking

10:00 AM – 11:30 AM
🧩 SQL Fundamentals: SELECT, WHERE, ORDER BY

11:45 AM – 1:00 PM
🔍 Filtering, Aggregation & Functions

  • Logical operators (AND, OR, NOT)
  • Filtering with wildcards, BETWEEN, IN
  • Aggregate functions: COUNT, SUM, AVG, MIN, MAX
  • Grouping results using GROUP BY and filtering with HAVING
  • Lab: Sales report queries and statistical insights

1:00 PM – 2:00 PM — Lunch Break

2:00 PM – 4:00 PM
🔗 JOINs & Relationships

  • Understanding relational database concepts
  • Exploring 1-to-1, 1-to-many, and many-to-many relationships
  • Writing INNER, LEFT, RIGHT, and FULL OUTER JOIN queries
  • Lab: Connect related tables (e.g., Customers → Orders → Products)
  • Real-world examples: combining data across entities

🔹 Day 2: Schema Design & SQL in C#

10:00 AM – 11:30 AM
🧱 Database Design: Tables, Keys, Normalisation

  • Creating tables with CREATE TABLE syntax
  • Primary keys, foreign keys, and auto-increment fields
  • Understanding and applying 1NF, 2NF, 3NF
  • Designing an efficient schema from a real-life scenario
  • Hands-on: Build a schema for a small booking or inventory system

11:45 AM – 1:00 PM
⚙️ Using SQL Server/SQLite with C#

  • Setting up SQLite or SQL Server LocalDB in a C# project
  • Using ADO.NET for database connectivity
  • Writing parameterised SQL queries in C#
  • Executing read/write operations with data readers and commands
  • Lab: Build a small form app that reads from and writes to a database

1:00 PM – 2:00 PM — Lunch Break

2:00 PM – 4:00 PM
🛠️ Project: Simple C# Database App

  • Final guided mini-project combining all course concepts
  • Design and build a basic CRUD app (e.g., Task Tracker or Contact List)
  • Includes:
    • Form inputs
    • Database queries
    • Record creation, updates, and display
  • Wrap-up, recap, and Q&A

🧠 What You’ll Learn

  • Practical SQL querying for real-world data analysis
  • Schema and relationship design fundamentals
  • How to integrate SQL databases into C# applications
  • Confidence working with both SQL Server and SQLite
  • Hands-on experience building a functioning data-driven C# app