top of page
WeddingtonCoder_center_wide_white_no_tag.png

SQL Server

Master the Power Behind Every App

Every modern application depends on data — and in this class, you'll learn how to design, build, and manage that data using Microsoft SQL Server. From writing your first query to designing normalized relational databases, you'll gain the skills real-world developers use every day to build reliable, efficient, and secure data-driven systems.

​What You’ll Learn

​

Introduction & Tools

  • Understand relational database concepts and how SQL Server works.

  • Navigate and operate within SQL Server Management Studio (SSMS) for database tasks.

  • Essential SQL Techniques

  • Master CRUD operations: retrieving data with SELECT, and modifying data using INSERT, UPDATE, and DELETE.

  • Apply filters, sorting, grouping, and aggregate functions to analyze datasets.

  • Perform complex joins, write summary queries, and use subqueries effectively.


Database Design & Deployment

  • Design relational database schemas with proper normalization and structure.

  • Implement schemas using DDL statements, constraints, and graphical tools.

  • Maintain data integrity through careful schema design and constraint usage.


Advanced SQL Practices

  • Create and use views, scripts, stored procedures, and user-defined functions.

  • Leverage triggers, cursors, and transaction management for automated and safe data operations.

  • Manage security by configuring users, roles, and permissions.


Cloud Integration with Azure

  • Migrate databases to Azure SQL and manage them using Azure Data Studio.

  • Explore the benefits of cloud-hosted SQL Server through real-world, step-by-step examples.
     

bottom of page