Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Relational Database Models
- Relational operators
- Key characteristics of the declarative SQL language
- SQL syntax fundamentals
- Overview of SQL languages: DQL, DML, DDL, and DCL
Data Query Language (DQL)
- Writing SELECT queries
- Creating aliases for table columns
- Working with date data (DATE types, display functions, and formatting)
- Grouping features
- Joining internal and external tables (JOIN clause)
- Using the UNION operator
- Nested subqueries (applying conditions in the WHERE clause, referencing table and column names)
- Understanding correlated subqueries
Data Modification Language (DML)
- Inserting new rows (INSERT clause)
- Inserting rows based on existing requests
- Modifying existing rows (UPDATE)
- Removing rows (DELETE)
Data Definition Language (DDL)
- Managing objects through creation, alteration, and deletion (CREATE, ALTER, DROP)
- Creating tables by leveraging subqueries (CREATE TABLE ... AS SELECT ...)
Constraints
- Understanding NULL and NOT NULL options
- Using the CONSTRAINT clause
- ENUM data type
- SET data type
- Applying the PRIMARY KEY condition
- Applying the UNIQUE condition
- Applying the FOREIGN KEY condition
- Utilizing the DEFAULT clause
Transactions
- Executing commands for COMMIT, ROLLBACK, and SAVEPOINT
Requirements
- Basic computer literacy
- Familiarity with any operating system
14 Hours
Testimonials (1)
The course built lesson to lesson, and the pacing was a big deal for me.
