SQL Server Essentials

This course is designed as an introduction to the important features of relational databases and specifically Microsoft SQL Server, and it is suitable for all versions of SQL Server.

You Will Learn How To:

• Understand entity relationship diagrams
• Write basic Transact SQL queries
• Create databases and tables
• Understand the role of transaction logs
• Use primary and foreign keys

Course Content:

• Relational Database Concepts
• What is a Database?
• Logical and Physical Design
• The Relational Database
• Primary Keys & Foreign Keys
• Entity Relationship Diagrams
• Design Normalisation
• Relational Database Architecture
• The RDBMS
• Structured Query Language - SQL
• Stored Queries
• Indexes
• Transactions and Log Files
• Client-Server and Middleware Architectures
• SQL Server and Architecture
• Overview of SQL Server
• Server Fundamentals
• Users and Security
• Networked Architecture
• SQL Server Tools
• SQL Management Studio
• SQL Server Configuration Tool
• SQL Server Documentation
• SQL Server Profiler
• Database Engine Tuning Advisor
• Performance Monitor
• Viewing Data
• Accessing Data within Database Tables
• The SELECT Statement
• Manipulating Data
• Selecting Rows
• Sorting Data
• Aggregate Functions
• Querying Multiple Tables Using Joins
• Database and Table Structures
• Creating Databases using SQL Server and T-SQL
• Creating Tables in SQL Server
• Entering and Editing Data
• Creating Tables and Columns in T-SQL
• Modifying Tables and Columns
• Computed Columns
• Database Diagrams
• Creating Database Diagrams
• Manipulating Data
• Modifying Data in Tables
• INSERT Statement
• The DELETE Statement
• The UPDATE Statement
• Enforcing Data Integrity
• Types of Data Integrity
• Constraints
• Ensuring Integrity with Triggers
• Improving Data Access
• Using Views
• Speeding up Data Access with Indexes
• Application Development Environment