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 Queries 101

Course Summary

A Beginning SQL Server Guide


  • +

    Course Syllabus

    • Getting Started
      • Course Intro
      • Setting up Your Labs
    • SQL Queries
      • Single Table Queries
      • Using Criteria
      • Finding Patterns in Data
      • Joining Table
      • Outer Joins
      • Table Aliases
      • Unmatched Records Queries
      • Cross Joins
    • Design Definitions
      • LabTips
      • CreatingDatabases
      • CreatingTables
    • Data Manipulation (DML)
      • Inserting Data
      • Updating Data
      • Deleting Data
      • Using Scripts
      • Altering Tables
      • Using BCP
      • Stored Procedures
      • Using Variables
      • Stored Procedure Parameters
    • Transactions
      • Explicit Transactions
      • Table Hints
    • Security
      • SQL Logins
      • Granting Permissions
      • Revoking & Denying Permissions
    • Workplace Tips
      • Code Comments
      • Automatic Script Generation
      • Import Export Wizard
    • Conclusion
      • Conclusion


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