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

Developer's T-SQL Playbook

Course Summary

Learn the essential SQL Skills any developer needs.


  • +

    Course Syllabus

    Introduction
    - 2m 30s

    —Introduction 2m 30s
    Working with Tables
    - 32m 45s

    —Creating a Table 3m 42s
    —Primary Keys: Integer 2m 52s
    —Primary Keys: GUID 1m 47s
    —Primary Keys: Auto-incrementing 3m 14s
    —Tangent: Choosing a Primary Key 4m 31s
    —Composite Keys 3m 23s
    —Defining Columns 2m 26s
    —Basic Column Constraints 6m 5s
    —Column Defaults 1m 49s
    —Naming Conventions 2m 51s
    Working with Data
    - 12m 39s
    Querying Data
    - 9m 54s
    Joining Tables
    - 10m 25s
    Filtering, Sifting, and Sorting Data
    - 8m 28s
    Aggregates and Analysis
    - 12m 11s
    Many to Many and Self-referencing Relationships
    - 16m 51s
    Essential String and Date Functions
    - 21m 6s


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