SQL Advanced Treningskurs

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

Testimonials

★★★★★
★★★★★

Related Categories

Relaterte kurs

Kursrabatter

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