SQL Server Database Fundamentals


SQL Server Database Fundamentals

1. 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

2. 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

3. 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

4. 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

5. 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 DBAAccess VBA 课程一直受到众多学员的好评。



本页最后更新: | -- | 网站设计和虚拟主机服务 WECAN.ca CMS