(SQL) SQL Server Database Event, 13.Jan.2025

(SQL) SQL Server Database Event, 13.Jan.2025

Introduction

This course provides an overview of relational database design principles it does not cover the teaching of formal database design processes and database/table creation.
The course assumes no previous knowledge of SQL and SELECT statements, and takes delegates from simple queries, through to complex queries involving multiple tables, introducing the vast collection of built-in functions along the way.

 

Target Audience:

  • IT Administrators
  • Database Administrators
  • Application Developers
  • Cloud Computing Professionals
  • Configuration Specialists
  • Migration & Deployment Specialists
  • Data Migration Specialists
  • Deployment Specialists
  • Infrastructure Specialists
  • IT Security Professionals

 

Course Outlines

Day 1

Relational Database Overview

  • Basic Relational Database Terminology
  • Relational Database
  • Tables and Columns
  • Rows and Records
  • Connecting Tables
  • Primary Keys
  • Foreign Keys
  • Relationship Types

Day 2 

The SELECT Statement      

  • SELECT list
  • Columns
  • ALL or DISTINCT
  • String Expressions
  • Arithmetic Expressions
  • Column Aliases

Relational Operators

  • BETWEEN AND
  • IS NULL Example
  • IN Example
  • LIKE Examples
  • Working With Dates
  • NOT

Day 3 

Aggregate Functions         

  • COUNT
  • SUM
  • MAX
  • MIN
  • AVG
  • NULL Values and Aggregates
  • Aggregate Expressions
  • Mathematical Functions    
  • SQUARE
  • POWER
  • SQRT
  • RADIANS, SIN, COS, TAN
  • ABS
  • ROUND
  • CEILING & FLOOR

Day 4

Conversion Functions    

  • CAST and CONVERT
  • Converting Dates To Strings
  • Converting Money Values To Strings
  • ISNULL Function

String Functions    

  • UPPER & LOWER
  • STR
  • LEFT & RIGHT
  • CHARINDEX
  • SUBSTRING
  • REVERSE, REPLACE and SPACE
  • RTRIM & LTRIM
  • REPLICATE
  • Using REPLICATE To Pad Strings
  • ASCII & CHAR

Day 5 

Date Functions              

  • GETDATE
  • YEAR, MONTH & DAY
  • DATEPART & DATENAME
  • Date Arithmetic
  • DATEADD & DATEDIFF

INNER Join                          

  • Legacy Style Joins
  • ANSI Style Joins
  • Simple Joins
  • Two Tables
  • Three Tables
  • Four Tables
  • INNER JOIN Theory

IT & IT Engineering
(SQL) SQL Server Database (321700_144249)

Course Code: 321700_144249    Course Date: 13 - 17 Jan 2025    Course Price: 5700  Euro

COURSE DETAILS

City : Los Angeles (USA)

Code : 321700_144249

Course Date: 13 - 17 Jan 2025

The Fess : 5700 Euro

Register
Inquiry
All Dates And Location
Download Brochure