Learn to Design & Develop Database in Microsoft SQL Server



We will design and develop a complete database for Training Information Management System (Small-sized)

What you will learn

Understand client requirements

Design and develop a database

Apply database constraints

Apply database relationships

Setup Audit triggers

Select list data by joining multiple tables

Select summary data by joining multiple tables and aggregate functions

Description

This course is designed for people who have basic database knowledge and some experience working with some kind of relational database tool. It can be on SQL Server, MySQL, PostgreSQL or Oracle.

I strongly believe in short and simple courses that can get you ready in few hours as opposed to days and that’s why I made sure this course to be less or equal to 2hrs.

This course teaches you how to:

  • Understand client requirements
  • Design and develop a database
  • Apply database constraints
  • Apply database relationships
  • Setup Audit triggers
  • Select list data by joining multiple tables
  • Select summary data by joining multiple tables and aggregate functions

We will not cover basic database operations like insert, update, delete and select data.

This course requires:


  • Basic understanding of database concepts
  • Some level of familiarity with SQL Server would be a plus

Who this course is for:

  • Developers who want to have practical database development knowledge
  • New database developers to have practical experience
  • Any one who want to understand database development process

Who is teaching this course:

My name is Bereket Wolde and I started working database development for more than 15 years. I am also a certified SQL Server developer.

However, if you ever get stuck or need something that I don’t cover in this course then feel free to reach out to me or add a comment on the course we will reach out to you at the earliest.

Join me today and I’ll see you inside!


English
language

Content

Introduction

Introduction

Understanding requirements

Introduction
Explain the problem
Design considerations
Asking for your feedback

Design and develop database

Introduction
Define the tables
Design the tables
Create the tables
Apply relationships
Apply constraints
Setup AuditLog triggers
Asking for your feedback
Practice what you learned in this section

Financial report requests

Introduction
Trainees who paid by pay-period
Trainees who never make a payment
Asking for your feedback
Practice what you learned in this section

Status report requests

Introduction
List of trainees who took atleast one course
List of trainees who took more than 1 course
Asking for your feedback
Practice what you learned in this section

Summary reports

Introduction
Summary of trainees by course
Summary of payment count by course
Summary of payment amount by course
Asking for your feedback
Practice what you learned in this section

Conclusion

Wrap up
Asking for your feedback

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock

Check Today's 30+ Free Courses on Telegram!

X