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

Querying Microsoft SQL Server 2012

Course Summary

Learn how to query data from SQL Server tables.     

  • +

    Course Syllabus

       What you should know before viewing this course 
       Using the exercise files 
    1. SQL Query Fundamentals
       A history of SQL and T-SQL 
       An introduction to relational theory 
       To use standards or not 
       Understand processing stages 
    2. Query the Database
       Query a table with SELECT 
       Using aliases in your SELECT statement 
       Using string concatenation 
       Using CASE expressions 
    3. Filtering Results
       Filter duplicates with DISTINCT 
       Introducing the WHERE clause 
       WHERE clause relational operators 
       Filtering text 
       Working with NULL 
    4. Query Multiple Tables
       Understanding normalization 
       Understanding table relationships 
       Understanding JOINs 
       Using JOINs in a query 
    5. Grouping and Sorting
       Understanding order 
       Sorting results with ORDER BY 
       Grouping results with GROUP BY 
       Using the TOP option 
       Using aggregates 
    6. Querying with Data-Type Considerations
       Queries using date and time 
       Queries using character data types 
       Queries using character functions 
    7. Subqueries and Table Expressions
       Writing subqueries 
       Using EXISTS 
       Introducing views 
       Introducing common table expressions 
    8. Programming with T-SQL
       Understanding stored procedures 
       Understanding T-SQL programming elements 
       Implement transactions 
       Handling errors 
    9. Query Performance
       Introducing query execution plans 
       Interpret performance data 

Course Fee:
USD 25

Course Type:


Course Status:



6 - 7 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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