SQL Development Bootcamp Treningskurs

Last updated

Kurskode

sqldevbootcamp

Varighet

35 timer (vanligvis 5 dag inkludert pauser)

Krav

  • Familiarity with database management and database management systems

Audience

  • Beginners
  • Programmers
  • Database admins

Oversikt

The SQL Development Bootcamp gir omfattende leksjoner for SQL utvikling. Temaene dekket inkluderer databasesign teknikker, data manipulasjon, og enkle og komplekse spørreundersøkelsesmetoder.

Denne instruktørledede, live opplæring (online eller online) er rettet mot nybegynnere, programmerere og databaseadministratorer som ønsker å lære eller forbedre sine utviklingsferdigheter og kunnskap.

Ved slutten av denne opplæringen, vil deltakerne være i stand til å installere, lage, administrere, manipulere og overvåke databaser ved hjelp av SQL og database management systemer.

Format av kurset

    Interaktiv forelesning og diskusjon. Mange øvelser og praksis. Hands-on implementering i et live-lab miljø.

Kurs tilpassingsalternativer

    For å be om en tilpasset opplæring for dette kurset, vennligst kontakt oss for å arrangere.

Machine Translated

Kursplan

Introduction to SQL Development Bootcamp

Overview of SQL Development

  • Data and databases
  • Database management systems (DBMS)
  • SQL key concepts

Getting Started with SQL Databases

  • Installing DBMS software
  • Initial configuration
  • Connecting existing databases
  • Database development methodology

Exploring SQL Statement Fundamentals

  • Data definition language statements
  • Transaction control statements
  • Session and system control statements
  • Embedded SQL statements

Working with SQL Data

  • Filtering data
  • Comparison and logical operators
  • Sorting data
  • Row limiting clause
  • Substitution variables
  • Define and verify commands

Using Single Row, Group, Conversion, and General Functions

  • Character functions
  • Numeric and date functions
  • Conversion functions
  • Case and decode functions
  • Distinct and null values
  • Group by clauses
  • Having clauses

Working with SQL Join Clauses

  • Inner join
  • Non-equijoin
  • Outer join
  • Cross join

Using Subqueries and SET Operators

  • Single row subqueries
  • Multi row and multi column subqueries
  • SET operators
  • Correlated subquery
  • Data manipulation with subqueries

Creating Databases and Tables

  • Data types
  • Primary and foreign keys
  • Constraints
  • Table actions (create, insert, update, delete)
  • Data dictionary views
  • Conditional expressions

Working with Views, Sequences, Synonyms, and Indexes

  • Creating and querying views
  • Creating and modifying sequences
  • Creating synonyms
  • Creating indexes

Managing Schema Objects

  • Constraints management
  • Temporary tables
  • External tables

Controlling User Access

  • System privileges
  • Object privileges
  • Roles
  • Revoking privileges

Managing Data in Different Time Zones

  • Interval data types
  • Time functions

Troubleshooting

Summary and Conclusion

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