| The Complete Tsql Programming Course |
ID: SQDev | Course Length:5 | Company Name:Choquette Technology Associates Inc.
|
|
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
|