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
- 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
ashar hafeez
0
62
Students
About Instructor
Pak
Course Events
[wplms_eventon_events]
