After completing this course, students will be able to:
- Introduce the entire SQL Server platform and its major tools.
It will cover editions, versions, basics of network listeners, and
concepts of services and service accounts.
- Determine appropriate data types to be used when designing
tables, convert data between data types, and create alias data
- Be aware of good design practices regarding SQL Server tables
and be able to create tables using T-SQL. (Note: partitioned tables
are not covered).
- Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE
constraints, and investigate cascading FOREIGN KEY
- Determine appropriate single column and composite indexes
- Create tables as heaps and tables with clustered indexes. Also
consider the design of a table and suggest an appropriate
- Read and interpret details of common elements from execution
- Design effective non-clustered indexes.
- Design and implement views
- Design and implement stored procedures.
- Work with table types, table valued parameters and use the
MERGE statement to create stored procedures that update data
- Design and implement functions, both scalar and table-valued.
(Also describe where they can lead to performance issues).
- Perform basic investigation of a deadlock situation and learn
how transaction isolation levels affect application
- Use both traditional T-SQL error handling code and structured
- Design and implement DML triggers
- Learn appropriate uses for SQL CLR integration and implement an
existing .NET assembly within SQL Server.
- Store XML data and schemas in SQL Server.
- Perform basic queries on XML data in SQL Server.
- Work with the GEOGRAPHY and GEOMETRY data types
- Implement and query a full-text index.
The primary audience for this course is IT Professionals
who want to become skilled on SQL Server 2014 product features and
technologies for implementing a database.
This course requires that you meet the following
- Knowledge of writing T-SQL queries.
- Knowledge of basic relational database concepts.