Last updated
Kurskode
ADSQL
Varighet
14 timer (vanligvis 2 dag inkludert pauser)
Krav
SQL: Fundamentals of Querying or equivalent knowledge.
Oversikt
Studentene skal lære avanserte spørsmål og hvordan du legger til, oppdaterer og sletter data, tabeller, visninger og indekser.
Machine Translated
Kursplan
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
