Microsoft SQL Server Relational Database Design And Querying Fundamentals 2 Days
Applies to all versions from SQL Server 2012 through to SQL Server 2022
DURATION: 2 days
INTRODUCTION
The training will focus on the fundamentals of relational database design to facilitate a better understanding of how data is stored, queried, and manipulated. That said, sufficient material will be covered to enable delegates to create meaningful and usable databases in the workplace. The course will be useful to anyone wanting to know the basics of relational database design concepts and will include coverage of such concepts as primary and foreign keys, constraints, entity relationships, data normalisation, creating databases, creating, and managing tables, and native SQL Server datatypes.
To facilitate the learning process and augment the theory, students will get the opportunity to design a practical working database, with plenty of hands-on exercises to implement the design.
In the latter sections of the course, students will also get the chance to write some basic queries to acquaint them with the foundations of the Structured Query Language (SQL). No previous knowledge of the SQL language is assumed.
This course serves as an ideal precursor to any of following courses.
• SQL Server Introduction to Querying
• SQL Server Programming
• SQL Server Querying Data for Report Developers
PREREQUISITES
Students should be familiar with working in a Microsoft Windows operating system environment. Additionally, knowledge of basic programming concepts would be helpful, but not essential.
COURSE OBJECTIVES
Upon successful completion of this course, students will be able to:
• Know how to Analyse Business Requirements
• Map a Database Design to Business Requirements
• Design and Build a Relational Database
• Understand Entity Relationships
• Understand Primary and Foreign Keys
• Understand and Implement Constraints
• Normalise Data to Improve Data Management
• Understand the purpose of the SQL Server Database Engine
• Work with the SQL Server Management Studio (SSMS) Client Tool
• Create a Database
• Create and Manage Tables and Columns
• Write Basic SELECT Queries to Retrieve Data from a Database
• Write Basic Data Modification Statements
COURSE OUTLINE
1. Course Overview
Defining the Objectives for the Course
The Sample Database Project
2. Analysing the Requirements Analysing Current Business Data
Identifying New Client Requirements
Determine the Required Data Fields G
Group Fields into Tables
Identify Key Fields
3. The Design Process
Create a Preliminary Entity Relationship Diagram
Describe Relationships
Resolving Many-to-Many Relationships Implementing First, Second, and Third Normal
Form Higher Normal Forms
Refining the Design
4. Introduction to SQL Server
Overview of Microsoft SQL Server
Introducing SQL Server Management Studio (SSMS)
Creating the Sample Database
5. Database Design Implementation
Native SQL Server Data Types
Creating Tables and Columns
Implementing Key Fields and Constraints
Examining other Column Properties
Creating a Database Diagram
Managing Tables
Introduction to SQL Server Indexes
6. Querying Data
ANSI and ISO SQL Standards
Categories of SQL Statements
Querying Data with the SELECT Statement
Filtering Rows of Data with a WHERE Clause
Examining Basic Table Joins
7. Modifying Data
Adding Rows of Data with the INSERT Statement
Modifying Rows of Data with the UPDATE Statement
Deleting Rows of Data with the DELETE Statement
Course Objectives
This 2-day course provides a foundation for designing, building, and working with relational databases, enabling students to effectively develop and use relational databases in a business environment.
Microsoft SQL Server Relational Database Design And Querying Fundamentals 2 Days
Applies to all versions from SQL Server 2012 through to SQL Server 2022
DURATION: 2 days
INTRODUCTION
The training will focus on the fundamentals of relational database design to facilitate a better understanding of how data is stored, queried, and manipulated. That said, sufficient material will be covered to enable delegates to create meaningful and usable databases in the workplace. The course will be useful to anyone wanting to know the basics of relational database design concepts and will include coverage of such concepts as primary and foreign keys, constraints, entity relationships, data normalisation, creating databases, creating, and managing tables, and native SQL Server datatypes.
To facilitate the learning process and augment the theory, students will get the opportunity to design a practical working database, with plenty of hands-on exercises to implement the design.
In the latter sections of the course, students will also get the chance to write some basic queries to acquaint them with the foundations of the Structured Query Language (SQL). No previous knowledge of the SQL language is assumed.
This course serves as an ideal precursor to any of following courses.
• SQL Server Introduction to Querying
• SQL Server Programming
• SQL Server Querying Data for Report Developers
PREREQUISITES
Students should be familiar with working in a Microsoft Windows operating system environment. Additionally, knowledge of basic programming concepts would be helpful, but not essential.
COURSE OBJECTIVES
Upon successful completion of this course, students will be able to:
• Know how to Analyse Business Requirements
• Map a Database Design to Business Requirements
• Design and Build a Relational Database
• Understand Entity Relationships
• Understand Primary and Foreign Keys
• Understand and Implement Constraints
• Normalise Data to Improve Data Management
• Understand the purpose of the SQL Server Database Engine
• Work with the SQL Server Management Studio (SSMS) Client Tool
• Create a Database
• Create and Manage Tables and Columns
• Write Basic SELECT Queries to Retrieve Data from a Database
• Write Basic Data Modification Statements
COURSE OUTLINE
1. Course Overview
Defining the Objectives for the Course
The Sample Database Project
2. Analysing the Requirements Analysing Current Business Data
Identifying New Client Requirements
Determine the Required Data Fields G
Group Fields into Tables
Identify Key Fields
3. The Design Process
Create a Preliminary Entity Relationship Diagram
Describe Relationships
Resolving Many-to-Many Relationships Implementing First, Second, and Third Normal
Form Higher Normal Forms
Refining the Design
4. Introduction to SQL Server
Overview of Microsoft SQL Server
Introducing SQL Server Management Studio (SSMS)
Creating the Sample Database
5. Database Design Implementation
Native SQL Server Data Types
Creating Tables and Columns
Implementing Key Fields and Constraints
Examining other Column Properties
Creating a Database Diagram
Managing Tables
Introduction to SQL Server Indexes
6. Querying Data
ANSI and ISO SQL Standards
Categories of SQL Statements
Querying Data with the SELECT Statement
Filtering Rows of Data with a WHERE Clause
Examining Basic Table Joins
7. Modifying Data
Adding Rows of Data with the INSERT Statement
Modifying Rows of Data with the UPDATE Statement
Deleting Rows of Data with the DELETE Statement
Course Objectives
This 2-day course provides a foundation for designing, building, and working with relational databases, enabling students to effectively develop and use relational databases in a business environment.
