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

MySQL Fundamentals Part 2

Course Summary

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. In this course, which is part 2 of the Fundamentals of MySQL series, we explore more advanced


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
    ● Joins, Unions and Subqueries
        ◦ Introduction
        ◦ Prerequisites
        ◦ Beginning Joins
        ◦ Inner Join
        ◦ Visual Explanation of Inner Join
        ◦ Demo: Inner Join
        ◦ Outer Join
        ◦ Visual Explanation of Left Outer Join
        ◦ Demo: Left Outer Join
        ◦ Visual Explanation of Right Outer Join
        ◦ Demo: Right Outer Join
        ◦ Visual Explanation of Full Outer Join
        ◦ Demo: Full Outer Join
        ◦ Visual Explanation of Cross Join
        ◦ Demo: Cross Join
        ◦ Pop Quiz
        ◦ Equi Join
        ◦ Self Join
        ◦ Demo: Self Join
        ◦ Natural Join
        ◦ Demo: Natural Join
        ◦ Joins with Using Keyword
        ◦ Demo: Joins with Using Keyword
        ◦ Union Operators
        ◦ Demo: Union Operators
        ◦ Subqueries
        ◦ Demo: Subqueries
        ◦ Joins vs Subqueries
        ◦ Demo: Subqueries with Aggregation Function
        ◦ Correlated Subqueries
        ◦ Demo: Correlated Subqueries
        ◦ Puzzle
        ◦ Solution of Puzzle
        ◦ Summary in Sixty Seconds
    ● MySQL Functions
        ◦ Introduction
        ◦ Scalar Functions
        ◦ String Functions
        ◦ Demo: String Functions
        ◦ Numeric Functions
        ◦ Demo: Numeric Functions
        ◦ Date/Time Functions
        ◦ Demo: Date/Time Functions
        ◦ Control Flow Functions
        ◦ Demo: Control Flow Functions
        ◦ Cast Functions
        ◦ Demo: Cast Functions
        ◦ Information Functions
        ◦ Demo: Information Functions
        ◦ Miscellaneous Functions
        ◦ Demo: Miscellaneous Functions
        ◦ Aggregate Functions
        ◦ Demo: Aggregate Functions
        ◦ Summary in Sixty Seconds
    ● MySQL Views
        ◦ MySQL Views
        ◦ Introduction
        ◦ Demo: Views
        ◦ Advantages of Views
        ◦ Demo: Simplified Queries
        ◦ Demo: Data Security
        ◦ Demo: DML Operations
        ◦ With Check Option
        ◦ Demo: With Check Option
        ◦ Summary in Sixty Seconds
    ● Stored Procedures and Stored Functions
        ◦ Introduction
        ◦ Stored Procedures
        ◦ Advantages of Stored Procedure
        ◦ Demo: Beginning Stored Procedures
        ◦ Demo: Stored Procedures with Multiple Resultset
        ◦ Demo: Stored Procedures with Parameters - Functions
        ◦ Demo: Stored Procedures with Parameters - DML Operation
        ◦ Demo: Stored Procedures with Parameters - Input and Output
        ◦ Demo: Stored Procedures - Drop and Create
        ◦ Stored Functions
        ◦ Demo: Stored Functions - 1
        ◦ Demo: Stored Functions - 2
        ◦ Stored Procedure vs Stored Function
        ◦ Summary in Sixty Seconds
    ● Triggers and Events
        ◦ Introduction
        ◦ Triggers
        ◦ Demo: Before Trigger
        ◦ Demo: After Trigger
        ◦ Events
        ◦ Demo: Single Time Event
        ◦ Demo: Recurring Event
        ◦ Summary in Sixty Seconds
    ● Summary and Resources
        ◦ Summary and Resources

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Related Posts:

MySQL

 

Web application (Web app)

 

Stored procedure

 

Open source

 

LAMP (Linux, Apache, MySQL, PHP)

 

Data Security

 

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