MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server: Transact-SQL Basic Data Retrieval

Course Summary

Learn how to construct SELECT statements to retrieve data from SQL Server databases, applicable for developers from SQL Server 2005 onwards


  • +

    Course Syllabus

    Introduction
    - 3m 45s

    —Introduction 2m 6s
    —Course Structure 1m 39s
    Setting Up a Transact-SQL Learning Environment
    - 36m 14s

    —Introduction 1m 2s
    —SQL Server 2012 Express with Tools 1m 1s
    —SQL Server 2012 Express Abridged Requirements 1m 47s
    —Demo: Checking Hardware and OS Specifications 0m 59s
    —Demo: Checking .NET 3.5 SP1 Prerequisites 1m 55s
    —Demo: Installing SQL Server 2012 Express with Tools 7m 33s
    —SQL Server Management Studio (SSMS) 0m 53s
    —Demo: Using SSMS 3m 26s
    —SQL Server Data Tools (SSDT) 1m 20s
    —Demo: Installing SSDT 2m 36s
    —AdventureWorks Sample Database 0m 39s
    —Demo: Attaching the AdventureWorks Sample Database 5m 20s
    —Basic Data Retrieval 0m 44s
    —Demo: Execute a Data Retrieval Query in SSMS 3m 35s
    —Demo: Execute a Data Retrieval Query in SSDT 3m 24s
    Writing a Basic SELECT Statement
    - 51m 17s
    Querying Multiple Data Sources
    - 49m 30s
    Using Functions
    - 1h 32m


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url