INDEXPage-SqlTutorial-1: Microsoft SQL Server Training: Free Tutorials and Online-Learning Classes (OLCs)

Microsoft SQL Server Training:

Free On-line Tutorials
And
On-line Learning Classes(OLCs)

Tutorial-1:

Database Development Using T-SQL

W elcome to T-SQL training course. Finally you got right place to learn T-Sql in easy, efficient, task-oriented and well-organized manner. The training process categorized into THREE(3)-Effective tutotrials and each one delievers a task- oriented valuable material organized into Online-Learning Classes (OLCs). Each OLC has its scope and vision. However, first tutorial classes, provides you with maximum stuff and satisfaction to learn and implement Sql Query. The Tutorial-2 taught you how you can do Db-Programming using T-SQL; this includes writing Stored Procedures, Functions (UDF), Triggers, Cursors and Transaction using T-SQL constructs; The final Tutorial-3, explains how can you do database modeling using E-R diagrams and following predefined RDBMS rules.

INDEX

1. Lesson-1: Learning DB-Table Operations

   • Class-1 : Creating, Finding, Droping, and Renaming Tables
   • Class-2 : Altering Tables and Adding Identity Column To Table

2. Lesson-2: Learning Integrity Constraints

   • Class-1: Overview of Integrity Constraints
   • Class-2: Primary Key and Unique Key Constraint
   • Class-3: Default Value  and Not Null Constraints
   • Class-4: Foreign Key Constraints with ON-UPDATE and DELETE options
   • Class-5: CHECK Constraints (custom business requirement)

3. Lesson-3: Learning Basic DML / CRUD Operations

   • Class-1: Basic INSERT | DELETES | UPDATES | TRUNCATES
   • Class-2: Basic SELECTs

4. Lesson-4: Learning Advanced - DML /CRUD operations

   • Class-1: Advanced-DML with Top(n),CASE Clause, OUPUT-Clause

5. Lesson-5: Learning Advance SELECT

   • Class-1 Part-1: CTE- Common Table Expression
   • Class-1: Part-2: Pivot / Unpivot Operators
   • Class-2: Advance Grouping: COMPUTE,CUBE|ROLLUP,GROUPING,NTILE and PARTIION

6. Lesson-6: Learning JOIN-operation (with All DML- CRUD operations)

   • Class-1: All-Types of Joins with multiple examples

7. Lesson-7: Learning Sub-Queries

   • Class-1: Sub-Queries : Co-related and Nested Sub-Queries

8. Lesson-8: Learning Temp-Tables:

   • Class-1 Local & Global Temporary Tables"

9. Lesson-9: Learning INDEXes

   • Class-1: Overview of INDEXes and their optimizations types etc.
   • Class-2: HowDoI CREATION,ALTER, DELETION and OPTIMIZATION etc"

10. Lesson-10: Learning VIEWS

    • Class-1: Overview and Operations of VIEWS

11. Lesson-11: Learning Built-in functions

    • Class-1: Introduction and examples of Scalar and Aggregate functions
    • Class-2: String functions
    • Class-3: TypeConversiions & Null Checking functions
    • Class-4: Date Functions
    • Class-5: Mathematical functions
    • Class-6:Ranking fucntions

12. Lesson-12: Learning Database Operations

    • Class-1: Creating Databases, Altering Databases, Using, finding and droping
    • Class-2: Attaching & DeAttaching Databases
    • Class-3: BackUP and Resoting Databases

        I hope you would like and enjoy reading all OLCs (Online Learning Classes) that I have try to explain the concept precisely. I will do my best to write and update the posts as well on time to ensure you people get all stuff at single place.

       The approach I follow here will help you to quickly locate the appropriate token, associated sections with bunch of examples to ensure your completeness. I thing, you will find this would be substitutable to reading books or class-room teaching approaches. I hope so, happy learning.

Audience

• The targeted audience could be beginners to help them understand the basic of Transact-Sql.
• The targeted audience could be intermediate-level & expertise professional to take reference while implementing database objects.

Feature tutorials:

1. Tutorial-2: Database Programming using T-SQL
2. Tutorial-3: Database Designing