SQL Advance - Bespoke TNW Certificate for Stephen Botha
Certificate ID:
720695
Authentication Code:
fe3e8
Certified Person Name:
Stephen Botha
Trainer Name:
Philip Isham
Duration Days:
2
Duration Hours:
14
Course Name:
SQL Advance - Bespoke TNW
Course Date:
2023-05-30 09:30 to 2023-05-31 16:30
Course Outline:
Lesson 1: Querying with unions and advanced joins
- Querying multiple tables with unions
- Advanced Joins
- Calculating with COMPUTE
Lesson 2: Querying with subqueries
- Subqueries
Lesson 3: Adding data
- Inserting data
- SELECT INTO
Lesson 4: Updating and removing data
- Updating records
- Deleting records
- Deleting the contents of tables
Lesson 5: Manipulating tables and views
- Creating tables
- Modifying tables
- Deleting tables
- Adding and removing views
Lesson 6: Manipulating indexes
- Adding and removing indexes
Lesson 7: Ensuring data integrity with transactions
- Transactions
Lesson 8: Creating databases
- Creating a database with SQL
- Deleting a database
Course Name Eng:
SQL Advanced