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

Learn MS SQL Server From Scratch

Course Summary

SQL is a standard language for accessing any database


  • +

    Course Syllabus

    • Basic MS Sql Server Data Definition Language
      • Getting Started With Sql Server Management Studio
      • Create A Database
      • Create A Table
      • Data Types In SQL Server
    • Data Manipulation Language - Insert,Update And Delete
      • Insert Statement
      • Update And Delete Statement
      • Delete Vs Truncate
      • OUTPUT clause
    • Data Manipulation Language - Select
      • Select Statement
      • Various Clauses
    • Data Manipulation Language - Built In Functions
      • Built In Functions
      • DateTime Functions
    • Data Manipulation Language - Advance clauses and Joins
      • Group By and Having Clause
      • Understanding Joins
      • Implementing Joins
      • Self Join
    • Data Manipulation Language - Stored Procedures And Functions
      • Creating Stored Procedures With No Input And Output Params
      • Creating Stored Procedures With Input And No Output Params
      • Creating Stored Procedures With Input And Output Params
      • Creating User Defined Functions
    • Control Structures
      • IIF()
      • Case When
      • IF...ELSE
    • Subqueries
      • Scalar SubQueries
      • Multivalued Subqueries
      • EXISTS and not EXISTS
      • Correlated Queries
    • Advanced Operations
      • Views
      • Slowly Changing Dimensions
      • Scope Identity Function
      • Transactions
      • Triggers
    • Advanced Functions And Clauses [Coming Soon]
      • Partitioning
      • Ranking Functions
      • Pivoting
      • Download Queries
      • MS Sql Server Quiz


Course Fee:
USD 75

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management and Networks & IT Infrastructure 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