Starting with SQL Server and Azure SQL Database Your Development Journey in the Relational World

Academy Membership

This is for individual Membership: When you are registering for yourself. if you want to register for a group or team, check out the team membership. Worth more than $10K! 48-hours free trial

  • Access to all video courses.
  • 430+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month with a 2-day free trial
  • EUR: €45.11
  • GBP: £38.39
  • NZD: $79.77
  • CAD: $66.85
  • AUD: $73.65

Academy Membership - for Teams

This is for team Membership: When you have a group of team members registering. if you want to register for one person, check out the individual membership. Worth more than $10K! 48-hours free trial

  • Access to all video courses.
  • 430+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month with a 2-day free trial
  • EUR: €45.11
  • GBP: £38.39
  • NZD: $79.77
  • CAD: $66.85
  • AUD: $73.65
per member

Starting with SQL Server and Azure SQL Database

In this course, you will learn the basics about the relational model, including normalization and constraints. You will start using the language that SQL Server and Azure SQL Database understand, the Transact-SQL (T-SQL) language. You will learn how to write basic and advanced queries. You will see how to create tables and insert, update, and delete data. You will learn how to handle errors and define user transactions. You will also understand the programmatic objects in a SQL database, including views, functions, stored procedures, and triggers.

Length: 4 Hours and 17 Minutes

$259.95
  • EUR: €239.31
  • GBP: £203.67
  • NZD: $423.20
  • CAD: $354.67
  • AUD: $390.70
Or log in to access your purchased courses

No matter how much ado is currently about big data, semi and unstructured data, the appropriate place for the most important data is still the relational database management system (RDBMS). If you need to take care about the data integrity, then you should use the relational model as the logical model for your data and database schema. You have to learn the standard language for working with data in a RDBMS, the Structured Query Language (SQL). 

In this course, you will learn the basics about the relational model, including normalization and constraints. You will start using the language that SQL Server and Azure SQL Database understand, the Transact-SQL (T-SQL) language. You will learn how to write basic and advanced queries. You will see how to create tables and insert, update, and delete data. You will learn how to handle errors and define user transactions. You will also understand the programmatic objects in a SQL database, including views, functions, stored procedures, and triggers. 

Modules

Module 5: Introducing the relational model

In this module, you will learn about the relational model and the mathematical background behind it. This is the only module without and code, only the theory. However, this theory is fundamental for understanding why and how some code written in SQL works. Lessons: Introduction to the relational model and domains Relational operators, algebra, and calculus

Lessons

Module 7: Dimensional modeling

For analytical applications, you typically model your data differently. This module introduces the dimensional model, the most widely used model for centralized and self-service reporting and analyzing your data. Lessons: Star and snowflake schemas and data warehouses Designing dimensions Designing fact tables

Lessons

Module 8: Programming views, functions, stored procedures, and triggers

Going back to practical database development. You will get an initial knowledge about the programmatic objects inside a database, why to use them, and how to create them. Lessons Views User-defined functions Stored procedures Triggers

Lessons