Complete Microsoft SQL Server Database Design Masterclass

Offered byUDEMY

Complete Microsoft SQL Server Database Design Masterclass
at
UDEMY
Overview

Duration	9 hours
Total fee	₹389
Mode of learning	Online
Credential	Certificate

Complete Microsoft SQL Server Database Design Masterclass
at
UDEMY
Highlights

Earn a certificate after completion of the course
30-Day Money-Back Guarantee
Full lifetime access

Complete Microsoft SQL Server Database Design Masterclass
at
UDEMY
Course details

Skills you will learn

Excel CRUD

Who should do this course?

This course is for beginners with absolutely no experience
This course is for you if you are already comfortable with fundamental database operations
This course is for you if you feel a bit 'rusty' and need to refresh your knowledge
This course is for you if you want to understand design principles in database development
This course is for you if you are proficient in Microsoft Access and want to learn a new Database Management System

What are the course deliverables?

Basic Database Design (Tables, Columns, Data Types, Primary Keys, Normalization)
Using Microsoft SQL Management Studio
SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping)
DELETE: How to remove data from a database
INSERT INTO: How to insert data into a table
UPDATE: How to update existing data
Filter groups of data using the HAVING clause
Overall Database Development Best Practices
Creating Relationships and Foreign Keys
How to query related data from multiple tables
Using Aggregate Functions in SQL
How to export Query Results to Excel

More about this course

This course on Microsoft SQL Database development and querying techniques
This course provides you with fundamental SQL Server training and is enough to get you started as a Database Developer or Database Administrator

Complete Microsoft SQL Server Database Design Masterclass
at
UDEMY
Curriculum

Introduction

Environment Setup

Understanding The Toolset

Creating And Manipulating Databases

Managing Tables and Data

Normalization, Relationships and Foreign Keys

Group By and Aggregate Functions

Complete Microsoft SQL Server Database Design Masterclass
at
UDEMY
Faculty details

Trevoir Williams

Trevoir Williams is a passionate software and system engineer with a strong drive to share the best of his knowledge with students around the globe His educational achievements include a Master’s degree in Computer Science (major in Software Development) and several Microsoft Azure Certifications