| |The Complete Tsql Programming Course
| |
ID: SQDev | Course Length: 5 |  |
|
| | |
Module 0: Rdbms Essentials |
| | | - About the Relational Database Management System
- The Role of ADO .NET
- SQL Server and the .NET Framework
- 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
|
 |
| | |
Module 1: Database Planning |
| | | - Planning Overview
- Normal Forms
- The Analysis
- The Design
- Er Notation
- Generalizations
- Aggregations
- Putting It Together
|
|
| | |
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
- Using Views
|
|
| | |
Module 5: Tsql Language Elements |
| | | - SQL Data Types
- Error Handling
- Stored Procedures and Metadata Views
- Using Variables
- Type Conversion
- Dealing with Null Values
- Dealing with Dates
- Conditional Constructs
- Looping Constructs
- Useful Functions
|
|
| | |
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: Indexing |
| | | - Index Overview
- Index Architecture
- Clustered Indexes
- Non-clustered Indexes
- Unique Indexes
- Indexes and Keys
- Indexed Views
|
|
| | |
Module 9: 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 10: Practical SQL |
| | | - Planning the Work
- Process Oriented Tasks
- Analysis Related Tasks
- Statistical Tasks
- Data Integrity Checks
- Using Ssis
|
|