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 declarative SQL
- SQL syntax fundamentals
- Overview of SQL sublanguages: DQL, DML, DDL, and DCL
Data Query Language (DQL)
- Writing SELECT queries.
- Using aliases for table columns
- Handling date data (DATE types, display functions, and formatting)
- Using grouping features
- Combining tables using internal and external joins (JOIN clause)
- Utilizing the UNION operator
- Employing nested subqueries (in the WHERE clause, referencing table and column names)
- Working with correlated subqueries
Data Modification Language (DML)
- Inserting new rows (INSERT clause)
- Inserting rows via a query
- Modifying existing rows (UPDATE)
- Removing rows (DELETE)
Data Definition Language (DDL)
- Managing database objects: creating, altering, and dropping them (CREATE, ALTER, DROP)
- Creating tables based on the result of a query (CREATE TABLE .... AS SELECT...)
Constraints
- Understanding NULL and NOT NULL options
- Using the CONSTRAINT clause
- Utilizing the ENUM type
- Using the SET type
- Applying the PRIMARY KEY constraint
- Applying the UNIQUE constraint
- Applying the FOREIGN KEY constraint
- Setting default values with the DEFAULT clause
Transactions
- Managing transactions using COMMIT, ROLLBACK, and SAVEPOINT commands
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.
