SQL Server Database Fundamentals

Understanding Core Database Concepts

Understand how data is stored in tables
Understanding what a table is
How it relates to the data that is stored in the database
Columns/fields
Rows/records
Understand relational database concepts
Understanding what a relational database is
The need for relational database management systems (RDBMS)
How relations are established
Basic concepts about database engine
About the language SQL
What is T-SQL
Understand data manipulation language (DML)
What is DML
How DML works to deal with data in databases
Building SELECT statement
Displaying result
Exporting result
Understand data definition language (DDL)
Understanding how T-SQL can be used to create database objects
DDL statements
Creating tables with DDL
Creating views with DDL

Creating Database Objects

Choose data types
Understanding what data types are
Why data types are important
How data types affect storage requirements

Understand tables and how to create them

Purpose of tables
Determining tables
Creating tables in a database by graphical interface
Using proper T-SQL statement

Create views

Understanding when to use views
How to create a view using graphical designer
Using T-SQL statement

Create stored procedures and functions

What is a stored procedure
What is a function
Difference between stored procedure and function
Selecting data
Inserting, updating and deleting data

Manipulating Data

Select data with complicated conditions

Utilizing SELECT queries to extract data from one table
Extracting data by using joins on multiple tables
Combining result sets by using UNION/UINON ALL and INTERSECT
Sub-queries

Insert data

Understanding how data is inserted into a database
How to use INSERT statements
Multiple insertions
Insert with select

Update data

Understanding how data is updated in a database
How to write the updated data to the database
Using the appropriate UPDATE statements
Update from another table
Update with select

Delete data

Deleting data from single table
Deleting data from multiple tables
Understanding transaction
Ensuring data and referential integrity by using transactions
Delete with select

Understanding Data Storage

Understand normalization

What is normalization
Understanding the reasons for normalization
The most common levels of normalization
How to normalize a database

Understand primary, foreign, and composite keys

Understanding the reason for keys in a database
Choosing appropriate primary keys
Selecting appropriate data type for keys
Selecting appropriate fields for composite keys
Understanding the relationship between foreign and primary keys

Understand indexes

Understanding indexes
Clustered and non-clustered
Purpose of having indexes in a database
Performance related considerations

Administering a Database

Understand database security concepts

Understanding the need to secure a database
What objects can be secured
What objects should be secured
User accounts
Roles
Permissions on database objects

Understand database backup and restore

Understanding database recovery models and various backup types
Things between database models and backup types
Full and incremental backups
Importance of backups
How to backup a database
How to restore a database

授课教师：Mr. Liu；计算机软件专业毕业，MCITP-DBA 2005/2008，拥有多年大型信息系统设计开发经验。曾经在中国主持设计开发超过1000个用户的大型政府部门办公自动化系统，AT&T全美联机系统的Senior Consultant，加拿大著名金融公司、银行及政府部门的Senior SQL Server DBA Consultant。擅长大型系统的设计，复杂数据结构的应用，企业级数据库系统的维护和开发。对于数据库系统理论及应用有精辟及独到的见解，所教授的SQL Server DBA及Access VBA 课程一直受到众多学员的好评。