SQL Advanced Certificate for Katarzyna Sapalska
Certificate ID:
737775
Authentication Code:
21a9c
Certified Person Name:
Katarzyna Sapalska
Trainer Name:
Łukasz Sokołowski
Duration Days:
2
Duration Hours:
14
Course Name:
SQL Advanced
Course Date:
11 October 2023 09:00 to 12 October 2023 16:00
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