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

If you need to retrieve data from a SQL Server database then you need to know how to use the SELECT statement. This course starts with the basics of a SELECT statement and its various sub-clauses, and progresses to how to select from multiple data sources


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Course Structure
    ● Setting Up a Transact-SQL Learning Environment
        ◦ Introduction
        ◦ SQL Server 2012 Express with Tools
        ◦ SQL Server 2012 Express Abridged Requirements
        ◦ Demo: Checking Hardware and OS Specifications
        ◦ Demo: Checking .NET 3.5 SP1 Prerequisites
        ◦ Demo: Installing SQL Server 2012 Express with Tools
        ◦ SQL Server Management Studio (SSMS)
        ◦ Demo: Using SSMS
        ◦ SQL Server Data Tools (SSDT)
        ◦ Demo: Installing SSDT
        ◦ AdventureWorks Sample Database
        ◦ Demo: Attaching the AdventureWorks Sample Database
        ◦ Basic Data Retrieval
        ◦ Demo: Execute a Data Retrieval Query in SSMS
        ◦ Demo: Execute a Data Retrieval Query in SSDT
    ● Writing a Basic SELECT Statement
        ◦ Introduction
        ◦ Thinking in 'Sets'
        ◦ Where to Begin?
        ◦ SELECT Clause
        ◦ Demo: SELECT Clause
        ◦ Column Aliases
        ◦ Demo: Column Aliases
        ◦ Identifiers
        ◦ Demo: Regular versus Delimited Identifiers
        ◦ Semicolon Statement Terminator
        ◦ FROM Clause
        ◦ Demo: FROM Clause
        ◦ Table Aliases
        ◦ Demo: Table Aliases
        ◦ Expressions, Operators, Predicates
        ◦ WHERE Clause
        ◦ Demo: WHERE Clause
        ◦ DISTINCT
        ◦ Demo: DISTINCT
        ◦ TOP
        ◦ Demo: TOP
        ◦ GROUP BY Clause
        ◦ Demo: GROUP BY Clause
        ◦ HAVING Clause
        ◦ Demo: HAVING Clause
        ◦ ORDER BY Clause
        ◦ Demo: ORDER BY Clause
        ◦ Query Paging
        ◦ Demo: Query Paging
        ◦ Binding Order
        ◦ Demo: Binding Order
        ◦ Best Practice: Commenting Your Code
        ◦ Demo: Commenting Your Code
    ● Querying Multiple Data Sources
        ◦ Introduction
        ◦ Inner Joins
        ◦ Demo: Inner Joins
        ◦ Outer Joins
        ◦ Outer Joins (2)
        ◦ Demo: Outer Joins
        ◦ Cross Joins
        ◦ Demo: Cross Joins
        ◦ Self Joins
        ◦ Demo: Self Joins
        ◦ Equi vs. Non-Equi Joins
        ◦ Demo: Equi vs. Non-Equi Joins
        ◦ Multi-Attribute Joins
        ◦ Demo: Multi-Attribute Joins
        ◦ Joining More than Two Tables
        ◦ Demo: Joining More than Two Tables
        ◦ CROSS APPLY Operator
        ◦ Demo: CROSS APPLY and OUTER APPLY Operator
        ◦ Joining Sub-Queries
        ◦ Defining the Sub-Query
        ◦ Demo: Using Sub-Queries
        ◦ UNION Operator
        ◦ Demo: UNION Operator
        ◦ INTERSECT and EXCEPT
        ◦ Demo: INTERSECT and EXCEPT Operators
        ◦ Data Types and Joining Tables
        ◦ Introduction to Common Table Expressions
        ◦ Demo: Introduction to Common Table Expressions
    ● Using Functions
        ◦ Introduction
        ◦ Aggregate Functions
        ◦ Demo: Aggregate Functions
        ◦ Aggregate Functions (2)
        ◦ Demo: Aggregate Functions (2)
        ◦ Mathematical Functions
        ◦ Demo: Mathematical Functions
        ◦ OVER Clause
        ◦ Ranking Functions
        ◦ Demo: Ranking Functions
        ◦ Conversion Functions


    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

Back to Top