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 language divisions: DQL, DML, DDL, and DCL
Data Query Language
- Utilizing SELECT statements.
- Assigning aliases to table columns
- Handling date data (DATE types, display functions, and formatting techniques)
- Grouping features
- Merging internal and external tables using the JOIN clause
- Employing the UNION operator
- Implementing nested subqueries (involving the WHERE clause, table names, and column names)
- Working with correlated subqueries
Data Modification Language
- Inserting new rows (using the INSERT clause)
- Inserting rows via queries
- Updating existing rows (using the UPDATE clause)
- Removing rows (using the DELETE clause)
Data Definition Language
- Managing objects through creation, alteration, and deletion (CREATE, ALTER, DROP)
- Creating tables based on subqueries (CREATE TABLE .... AS SELECT...)
CONSTRAINTS
- Understanding NULL and NOT NULL options
- Applying the CONSTRAINT clause
- Utilizing the ENUM type
- Utilizing the SET type
- Defining PRIMARY KEY conditions
- Defining UNIQUE conditions
- Defining FOREIGN KEY conditions
- Setting DEFAULT values
Transactions
- Executing COMMIT, ROLLBACK, and SAVEPOINT commands
Requirements
- General computer literacy
- Familiarity with at least one operating system
14 Hours
Testimonials (1)
The course built lesson to lesson, and the pacing was a big deal for me.
