top of page
programming-background-with-person-working-with-codes-computer.jpg

SQL-programmering

Denna kurs ger dig en introduktion till Oracle Database 12c databasteknik. Du kommer att lära dig begreppen relationsdatabaser och det kraftfulla SQL-programmeringsspråket. Upptäck viktiga SQL-kunskaper som gör det möjligt för utvecklare att skriva frågor mot enstaka och flera tabeller, manipulera data i tabeller och skapa databasobjekt.

  • Overview of Relational Database Concepts

  • What is a relational database management system?

  • Databases! Why do we need them?

  • Relational Database Structures

  • Brief overview of typical databases: Microsoft Access and SQL Server

  • Database building blocks: Tables, Columns, Primary key, Foreign Keys, Data Types, Indexes

  • Building a database

  • Creating tables and columns

  • Building tables with CREATE TABLE

  • Altering tables with ALTER TABLE

  • How to add columns to existing tables

  • How to add a Primary Key

  • How to add a Foreign Key

  • Adding a Data Type to a Table

  • How to improve performance with Indexes

  • Selecting Data: The SELECT statement

  • Setting Criteria using WHERE Clause

  • Inserting into a Table: The INSERT Statement

  • Updating a Table: The UPDATE Statement

  • Modifying a Table structure with ALTER Statement

  • Deleting from a Table: The DELETE Statement

  • Removing a tables with DROP statement

  • How to add Table Row with INSERT

  • How to change rows with UPDATE

  • How to remove row with DELETE

  • Filtering Data

  • Having Clause

  • Order By

  • Joining Database Tables

  • Overview of Table Joins

  • Inner Joins

  • Outer Joins

  • Self Joins

  • Other Joins

  • Cross Joins

  • Full Outer joins

  • Aggregation and Grouping

  • Summarizing and Grouping Data

  • Overview of SQL Functions

  • Creating Functions

  • Working with Subqueries

  • SUM, AVG, MIN, MAX

  • Ways to count

  • Group By Clause

  • Filtering data using the Having Clause

  • Overview of Subqueries

  • Basic Subqueries

  • String Functions

  • Date and Time Functions

  • Text Functions

  • Creating Stored Procedures

  • Passing Parameters

  • Basic Variables

  • Creating and Understanding Views

  • Understanding Triggers & Cursors

  • Creating Unions

  • Introduction to Transactions

  • Transaction Control

  • Controlling transactions with COMMIT command and ROLLBACK command

  • Using BEGIN TRANSACTION in SQL SERVER

  • Properties of Transactions

  • Locks and Blocking

  • Isolation Levels

  • Deadlocks

  • Variables

  • Cursors

  • Temporary Tables

  • Dynamic SQL

Error Handling

bottom of page