Free Trial

You get to enjoy all premium features and unlimited course access in WingsLive.com for 1 day free trial.

It takes only 30 Seconds! Try now!

Membership

Get unlimited course access, exclusive features and learn on any device with our premium account that helps you to meet all your learning objectives.

Access Code

If you purchased an access code card in any outlet or if you have any of our Discount Code, Gift Code, Promo Code, Please Click here.

Login


Forgot password? Click here

Send us your Feedback

Forgot Password?

Please enter your registered email address to reset your password: you will receive an email with further instructions.

Free Trial Account

Sign up with:

Sign up with Facebook
Sign up with Google

Sign up with Email:

Share this course to your loved one

via Mail ID

Embed Link

Copy this link
www.wingslive.com/index.php/courses/SQL_Server_2005

Quick Links

  •   Buy Gift

    Give a Gift of Knowledge

    "It always remembers, Give a man a fish, and you feed him for a day;
    Show him how to catch fish, and you feed him for a lifetime."

    Three simple processes for ordering it.
    Step 1: Simply decide which subscription plan you would like to give as a gift
    Step 2: Tell us whom you want this to be send
    Step 3: Complete the payment and leave the reset to us!
    We will send our WingsLive Gift Voucher code, in an attractive gift wallet & envelope,
    bearing your individual gift message, to your selected delivery address within 3 working
    days (or) We will send our WingsLive Gift Voucher code, in an attractive E-Greeting card,
    bearing your individual gift message, to the given email address within few minutes of
    time.
      CBT Store   Contact Us
  • Search Result

    SQL Server 2005

    80 Lessons      03:57:54 hrs

    SQL Server 2005 is the next-generation data management and analysis solution which delivers increased security, scalability, and availability to enterprise data and analytical applications.

    Screen Resolution Available On
    CD/DVD-Rom's, Online, Apps

    Searched Keyword:
    << Back

    BM

    Lesson Plans

    Duration

    Status

    ABL

    Notes

    Excersice


    Collapse all Expand all

    • +

      Author Mentoring


       

      Audience for this Course

      01:42

       

      N/A

       

      N/A


       

      Job Opportunities and Roles

      01:48

       

      N/A

       

      N/A


       

      Prerequisite Knowledge and skills

      01:18

       

      N/A

       

      N/A


       

      Inspire with samples

      01:21

       

      N/A

       

      N/A


    • +

      Fundamentals of SQL Server 2005


       

      History of SQL server 2005

      03:51

       

      N/A

       

      N/A


       

      What is SQL server?

      01:46

       

      N/A

       

      N/A


       

      Why We Learn SQL Server 2005

      01:33

       

      N/A

       

      N/A


       

      Course Objective

      01:00

       

      N/A

       

      N/A


    • +

      Setting up Environment


       

      Checklist for Installation – System Requirements

      04:18

       

      N/A

       

      N/A


       

      Step by Step Installation Process

      07:03

       

      N/A

       

      N/A


       

      Testing and troubleshooting

      02:08

       

      N/A

       

      N/A


       

      Opening the application for the first time

      01:53

       

      N/A

       

      N/A


    • +

      Introduction to Database


       

      What is Database?

      01:12

       

      N/A

       

      N/A


       

      What is Normalization?

      02:33

       

      N/A

       

      N/A


       

      Second Normal Form and Third Normal Form

      01:20

       

      N/A

       

      N/A


       

      What is Boyce-Codd Normal Form (BCNF)?

      02:24

       

      N/A

       

      N/A


       

      Creating Database Using SQL Server Management Studio

      02:39

       

      N/A

       

      N/A


       

      Creating a Database in Query Editor

      04:06

       

      N/A

       

      N/A


    • +

      Working with Data Types and Tables


       

      Types of SQL Statements

      03:34

       

      N/A

       

      N/A


       

      Data Types in SQL Server 2005

      07:32

       

      N/A

       

      N/A


       

      Creating Tables

      02:59

       

      N/A

       

      N/A


       

      Inserting Values into a Table

      03:27

       

      N/A

       

      N/A


       

      How to view the Table Data

      02:26

       

      N/A

       

      N/A


       

      Changing the structure of the table

      03:03

       

      N/A

       

      N/A


       

      How to change the existing data in a table

      02:21

       

      N/A

       

      N/A


       

      The DELETE and DROP Command

      02:08

       

      N/A

       

      N/A


    • +

      Data Manipulation Language (DML)


       

      SELECT statement with Different Clauses

      02:12

       

      N/A

       

      N/A


       

      ORDER BY and TOP Clause

      01:33

       

      N/A

       

      N/A


       

      Displaying Data from a table

      04:55

       

      N/A

       

      N/A


       

      Filtering Rows from a Table

      02:08

       

      N/A

       

      N/A


       

      Operators in WHERE Clause

      03:25

       

      N/A

       

      N/A


    • +

      Constraints and Joins


       

      Understanding Constraints

      04:48

       

      N/A

       

      N/A


       

      CHECK constraint

      02:12

       

      N/A

       

      N/A


       

      Referential Integrity Constraint

      02:35

       

      N/A

       

      N/A


       

      Join and its Types

      03:14

       

      N/A

       

      N/A


       

      OUTER JOIN

      04:57

       

      N/A

       

      N/A


       

      SELF JOIN

      01:29

       

      N/A

       

      N/A


    • +

      SQL Built-in Functions and Set Operators


       

      Aggregate Functions

      02:55

       

      N/A

       

      N/A


       

      Scalar Functions

      03:52

       

      N/A

       

      N/A


       

      Numeric Functions

      03:45

       

      N/A

       

      N/A


       

      Date\Time Functions

      04:55

       

      N/A

       

      N/A


       

      Set Operators

      04:59

       

      N/A

       

      N/A


    • +

      Indexes and Database Views


       

      Indexes

      02:44

       

      N/A

       

      N/A


       

      Creating and Using Views

      04:12

       

      N/A

       

      N/A


    • +

      Introduction to T-SQL


       

      An Overview of Transact-SQL

      01:51

       

      N/A

       

      N/A


       

      Programming Structure of T-SQL

      01:20

       

      N/A

       

      N/A


       

      Control Statements

      04:52

       

      N/A

       

      N/A


       

      Looping Statements

      01:58

       

      N/A

       

      N/A


       

      Operators in T- SQL

      05:39

       

      N/A

       

      N/A


    • +

      Cursors


       

      Understanding Cursors

      02:16

       

      N/A

       

      N/A


       

      Opening and Fetching a Cursor

      09:01

       

      N/A

       

      N/A


    • +

      Implementing Stored Procedures and Triggers


       

      Creating and Using Stored Procedure

      05:11

       

      N/A

       

      N/A


       

      System and Extended Stored Procedure

      02:08

       

      N/A

       

      N/A


       

      Overview of Triggers

      02:11

       

      N/A

       

      N/A


       

      Instead of Trigger

      02:29

       

      N/A

       

      N/A


    • +

      Transaction Processing


       

      Transaction Process

      01:48

       

      N/A

       

      N/A


       

      Controlling Transactions

      04:43

       

      N/A

       

      N/A


       

      Security in SQL Server 2005

      03:52

       

      N/A

       

      N/A


       

      Working with REVOKE

      01:24

       

      N/A

       

      N/A


    • +

      Handling Errors


       

      Error Handling in Transact-SQL

      01:40

       

      N/A

       

      N/A


       

      Using the @@ERROR Function

      01:56

       

      N/A

       

      N/A


       

      Using RAISERROR and TRY-CATCH

      02:35

       

      N/A

       

      N/A


       

      Handling Errors with TRY-CATCH

      03:21

       

      N/A

       

      N/A


    • +

      Locking in SQL Server 2005


       

      Introduction to Locking in SQL Server

      02:11

       

      N/A

       

      N/A


       

      Shared and update Locks

      02:18

       

      N/A

       

      N/A


       

      Exclusive Locks

      02:06

       

      N/A

       

      N/A


       

      Dealing with Deadlocks

      03:21

       

      N/A

       

      N/A


    • +

      Logins and Users


       

      Understanding Logins

      02:23

       

      N/A

       

      N/A


       

      Creating, Editing, and Deleting Logins

      03:57

       

      N/A

       

      N/A


       

      Understanding Users and Schemas

      01:38

       

      N/A

       

      N/A


       

      Using Schemas

      03:26

       

      N/A

       

      N/A


       

      Adding Users

      02:52

       

      N/A

       

      N/A


       

      Roles

      01:10

       

      N/A

       

      N/A


       

      Creating a New Role

      02:12

       

      N/A

       

      N/A


    • +

      Advanced Transact - SQL


       

      Introduction to Full text search

      05:36

       

      N/A

       

      N/A


       

      Introduction to APPPLY clause in SQL Server 2005

      02:29

       

      N/A

       

      N/A


       

      Recursive Queries using Common Table Expressions (CTE) in SQL Server

      03:20

       

      N/A

       

      N/A


       

      Creating Pivot Queries

      01:34

       

      N/A

       

      N/A


       

      Ranking Functions I

      02:34

       

      N/A

       

      N/A


       

      Ranking Functions II

      02:17

       

      N/A

       

      N/A


    BM

    Lesson Plans

    Status

    Excersice

    SQL Server - Tips


     

    Encrypting and Decrypting Password using RC4 Algorithm

     

    N/A


     

    Date/Time Conversions Using SQL Server

     

    N/A


     

    Doing a word count in SQL

     

    N/A


     

    How to select hierarchical data from a table?

     

    N/A


     

    How to read notepad text file into a table?

     

    N/A


     

    How to export an entire database into an Excel spreadsheet?

     

    N/A


     

    How to display graphically a disk directory tree?

     

    N/A


     

    How to export a table into a Notepad file?

     

    N/A


     

    How to write a trigger to prevent table drop or alter?

     

    N/A


     

    Synonyms in SQL Server 2005

     

    N/A


    Self Assessment

    Attempts

    Status

    Introduction to Database

    0

     


    Working with Data Types and Tables

    0

     


    Data Manipulation Language

    0

     


    Constraints and Joins

    0

     


    SQL Built-in Functions and Set Operators

    0

     


    Indexes and Database Views

    0

     


    Introduction to T-SQL

    0

     


    Cursors

    0

     


    Implementing Stored Procedures and Triggers

    0

     


    Transaction Processing

    0

     


    Handling Errors

    0

     


    Locking in SQLServer 2005

    0

     


    Logins and Users

    0

     


    Advanced T-SQL

    0

     


    Lesson Plans

    Tips and Tricks

    Glossary

    A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

    Aggregate Function
    A function that returns a result based on values of some attributes in multiple rows.

    Alias
    A temporary intra-query substitute for a table name or column name.

    Alphanumeric
    A data type that will accept a combination of characters as well as numbers.

    Anomaly
    An undesirable consequence of a data modification.

    Attribute
    Column in a table.