• No products in the cart.

ratings 

A company’s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals.

PRIVATE
Course Access

Unlimited Duration

Last Updated

March 4, 2021

Students Enrolled

Total Reviews

Posted by
Certification

This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.In this course you will learn about:

· Advanced Query Techniques

· Manipulating Table Data Using SQL's Data Manipulation Language (DML)

· User-Defined Functions

· Stored Procedures

· Triggers

Course Curriculum

    • Inner Joins 00:00:00
    • Outer Joins (Left, Right, Full) 00:00:00
    • Performing Self-Joins 00:00:00
    • Subqueries 00:00:00
    • Using the EXISTS Operator 00:00:00
    • Tips for Developing Complex SQL Queries 00:00:00
    • Using Aggregate Functions 00:00:00
    • Performing Set Operations 00:00:00
    • Aggregating Results Using GROUP BY 00:00:00
    • Restricting Groups with the HAVING Clause 00:00:00
    • Creating Temporary Tables 00:00:00
    • Inserting Data into Tables 00:00:00
    • Updating Existing Data 00:00:00
    • Deleting Records 00:00:00
    • Truncating Tables 00:00:00
    • Implementing Data Integrity with Transactions 00:00:00
    • Definition and Benefits of Use 00:00:00
    • CREATE FUNCTION 00:00:00
    • Comparison with Stored Procedures 00:00:00
    • Returning Scalar Values and Tables 00:00:00
    • ALTER and DROP FUNCTION 00:00:00
    • Definition and Benefits of Use 00:00:00
    • CREATE PROCEDURE 00:00:00
    • Control of Program Flow 00:00:00
    • ALTER and DROP PROCEDURE 00:00:00
    • Implementation Differences 00:00:00
    • Definition and Benefits of Use 00:00:00
    • Alternatives (e.g., Constraints) 00:00:00
    • CREATE TRIGGER 00:00:00
    • “Inserted” (or “NEW”) and “Deleted” (or “OLD”) Tables 00:00:00
    • Event Handling and Trigger Execution 00:00:00
    • ALTER and DROP TRIGGER 00:00:00

Course Reviews

Profile Photo
ashar hafeez
0
61

Students

About Instructor

Pak

Course Events

[wplms_eventon_events]

More Courses by Insturctor

© 2021 Ernesto.  All rights reserved.  
X