T-SQL Fundamentals with SQL Server Training Course Treningskurs

Last updated

Kurskode

SQL100

Varighet

14 timer (vanligvis 2 dag inkludert pauser)

Krav

Basic Computer Skills.

Oversikt

Dette SQL kurset er for folk som ønsker å tilegne seg grunnleggende ferdigheter for å takle SQL Server Database s. Kurs vil hjelpe medlemmene til å lære:

  • Slik jobber du med SQL Server og SQL Server Management Studio.
  • Betydning av Database , SQL og RDBMS etc.
  • Hvordan lage tabeller, bruk DDL, DML og DAL.
  • Hvilke er de forskjellige RDBMS-pakkene i markedet, og hvordan de sammenligner seg med hverandre.
  • En introduksjon til Ingen SQL og hvordan de er organisasjoner, endres til hybriddatabaser.

Machine Translated

Kursplan

Course Outline:

  • What is the meaning of Databases. Comparison of RDBMS and DBMS
  • Different RDBMS available in the market.
  • What is SQL Server? Working with SQL Server Management Studio
  • Working with sublanguages like DDL, DML, DAL.
  • Creation of Tables, data types, Constraints and their definition.
  • Using Insert, Delete and Update statements.
  • Using Select Query and its various operators.
  • Use of Null, Not Null, And, OR, Between, Exists, Order by, Group by, Having clause
  • What are inbuilt functions? Math, String and Datetime functions.
  • Working with Views. How they are used for data access.
  • Working with Joins. Joins types and getting data from multiple tables.
  • Working with Sub Queries. What is a correlated subquery. Difference between Sub Query and Joins.
  • What are Common Table Expressions. Using Recursive Common Table expressions.

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