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 SQL from scratch and become a database developer-Part2

Course Summary

Become the next greatest DB Dev, administrator or report developer by learning SQL from scratch, the easy way. Part2


  • +

    Course Syllabus

    • Joining Multiple Tables-Details
      • Introduction
      • UNIONS
      • UNION-UNION ALL
      • EXCEPT-INTERSECT
      • MySQL SYNTAX
      • Advanced Stuff
      • Conclusions
    • Common SQL Functions
      • Introduction
      • GETDATE
      • GETUTCDATE
      • DATEPARTS
      • DATE OPERATIONS
      • STRING FUNCTIONS
      • MATH FUNCTIONS
      • CONCLUSIONS
    • Transactions
      • INTRODUCTION
      • TRANSACTIONS OVERVIEW
      • TRANSACTION EXAMPLE
      • MySQL SYNTAX
      • NESTED TRANSACTIONS
      • CAVEATS
      • CONCLUSIONS
    • Data Definitions
      • INTRODUCTION
      • CREATE TABLE
      • PhPMyAdmin
      • DATA TYPES
      • ALTER-DROP
      • CONCLUSIONS
    • Understanding Relational Data
      • INTRODUCTION
      • RELATIONAL DATA OVERVIEW
      • PRIMARY KEYS
      • FOREIGN KEYS
      • DEFAULT CONSTRAINTS-NOT NULL CONSTRAINTS
      • CHECK CONSTRAINTS
      • INDEX CONSTRAINTS
      • CONCLUSIONS
    • Indexes
      • INTRODUCTION
      • INDEXES OVERVIEW
      • BENEFITS AND CAVEATS
      • MANAGING INDEXES
      • CONCLUSIONS
    • SQL Injection Attacks
      • Tools For Working With SQL
        • INTRODUCTION
        • MS SQL SERVER MANAGEMENT STUDIO
        • CROSS PLATFORM
        • MySQL TOOLS
        • COMMAND LINE
        • CONCLUSIONS
      • Cursors
        • Database Design Principles


        Course Fee:
        USD 39

        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