Duration 3 Days
Who should attend?
This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language.
Learning Outcomes
- Understand Database Fundamentals
- Work with advanced Query techniques
- Understand database development methodology
- Able to work with stored procedures
- Create User-defined Functions
- Effectively perform database tuning
Course Content
- Overview of Database concepts
- SQL, DML and DDL Languages
- Using Column Functions
- Writing Basic SQL Queries
- Advanced Query Techniques
- Manipulate table data using DML
- Building a Logical Data Model
- Enforcing Relationships with foreign Keys
- Creating Custom functions
- Creating Stored Procedures
- Working with Triggers
- Nested and Recursive Triggers