SQL Advanced Treningskurs

Last updated




14 timer (vanligvis 2 dag inkludert pauser)


SQL: Fundamentals of Querying or equivalent knowledge.


Studentene skal lære avanserte spørsmål og hvordan du legger til, oppdaterer og sletter data, tabeller, visninger og indekser.

Machine Translated


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

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



Related Categories

Relaterte kurs


Kursrabatter Nyhetsbrev

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Norway!

As a Business Development Manager you will:

  • expand business in Norway
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions