| SQL Server Essentials |
ID: DBSQL3 | Course Length:10 | Company Name:Choquette Technology Associates Inc.
|
|
Module 0: Rdbms Essentials |
- About the Relational Database Management System
- SQL Server Terminology: Databases, Tables, Columns, Rows, Keys, Etc
- Application Development and SQL Server
- Oltp: The Transactional Server
- Olap: The Analysis Server
- XML Integration
- Core SQL Server Services
- Other SQL Server Services
- The Role of ADO .NET
|
|
Module 1: Database Planning |
- Planning Overview
- Normal Forms
- The Analysis
- The Design
- Er Notation
- Generalizations
- Aggregations
- The Physical Environment
- Fault Tolerance and Capacity Planning
|
|
Module 2: Creating the Database |
- Planning the Installation
- SQL Server Installation
- Data Storage Architecture
- Creating Database Files
- Using File Groups
- Optimizing Data Storage
|
|
Module 3: Creating Tables |
- Integrity Overview
- Creating Data Types
- Creating Rules and Defaults
- Creating a Table
- Primary and Foreign Keys
- About Constraints: Default and Check
- Creating Triggers
|
|
Module 4: Structured Query Language Basics |
- SQL Overview
- The Select Statement
- Aggregate Values
- The Insert Statement
- The Update Statement
- The Delete Statement
|
|
Module 5: Tsql Language Elements |
- SQL Data Types
- Stored Procedures and Metadata Views
- Using Variables
- Type Conversion
- Dealing with Null Values
- Dealing with Dates
- Conditional Constructs
- Looping Constructs
- Useful Functions
- Error Handling
|
|
Module 6: Advanced Structured Query Language |
- Join Strategies
- Inner, Outer and Cross Joins
- About Self-joins
- Sub-queries
- Using Temporary Objects
|
|
Module 7: Stored Procedures |
- Architectural Overview
- Benefits of Stored Procedures
- Using Built-in Stored Procedures
- Creating Stored Procedures
- Using Input and Output Parameters
- Stored Procedure Optimization.
|
|
Module 8: Other Objects |
- Using Views
- About Indexed Views
- Functions
- Triggers
- Cursors.
|
|
Module 9: Implementing Security |
- SQL Security Overview
- Other Security Considerations
- Planning Security
- Configuring the Server
- Creating Logins
- Creating Users
- Granting Permissions: Grant, Deny and Revoke
- Using Server Roles
- Using Database Roles
- Application Roles.
|
|
Module 10: Indexing |
- Index Overview
- Index Architecture
- Clustered Indexes
- Non-clustered Indexes
- Unique Indexes
- Indexes and Keys
|
|
Module 11: Optimizing Performance |
- Optimization Overview
- Using Query Analyzer
- Gathering Performance Data
- Optimizing for Select
- Optimizing for Insert, Update and Delete
- Query Hints
- Join Strategies
- SQL Server Transactions and Locks
- Deadlocks and Livelocks
|
|
Module 12: Practical SQL |
- Planning the Work
- Process Oriented Tasks
- Analysis Related Tasks
- Statistical Tasks
- Data Integrity Checks
- Using Dts
|
|
Module 13: SQL Server Automation |
- The Need for Automation
- Jobs
- Alerts
- Operators
- Sqlmail Integration
|
|
Module 14: Backup and Recovery |
- Fault Tolerance Vs Backup
- Fault Tolerance: Clustering, Mirroring, Fail-over.
- Planning a Backup Strategy
- Implementing a Backup Strategy
- Automating Backups
- Recovering From Failure
- Recovering the Master Database
|
|
Module 15: Monitoring SQL Server |
- Overview of Monitoring Tools
- Planning To Monitor SQL Server
- Implementing Alerts
- Using Performance Counters
- Query Analyzer
- SQL Server Profiler
|