Introduction to database concepts - SQL Server

Description

In this course, you will learn:

• Basic database concepts
• Basics of database objects
• Creating a database using SSMS and SQL Script
• Creating Table, View and Stored Procedure using SSMS and SQL Script
• Populating a database using SSMS and SQL Script
• Querying a database using SSMS and SQL Script
• Updating a database using SSMS and SQL Script
• Deleting a database using SSMS and SQL Script
• Basics of database normalization
• How to apply 1st and 2nd normal form
• How to query data from multipe tables

Syllabus:

1. Introduction to SQL Server

• Installing SQL Server
• Navigating SQL Server

2. Basic Database Concepts

• What is Normalization?
• Types of Normalization

3. Prepare the Database

• Create database using SSMS
• Introduction to Database Objects
• Create tables

4. Data manipulation using SQL

• Inserting data into table
• Selecting data from a Table
• Creating views
• Updating data in a Table
• Deleting data from a Table
• Creating Stored Procedures

5. Searching for data in database

• Selecting Top N records
• Sorting selected records from table
• Narrowing down result set with WHERE clause
• Apply 2nd Normal Form
• Select data from multiple tables