Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »
Item number: 106750835

Introduction to SQL Training

Item number: 106750835

Introduction to SQL Training

159,00 192,39 Incl. tax

Order this unique E-Learning course Introduction to SQL Training online, 1 year 24/7 access to rich interactive videos and tests.

Read more
Discounts:
  • Buy 2 for €155,82 each and save 2%
  • Buy 3 for €154,23 each and save 3%
  • Buy 4 for €152,64 each and save 4%
  • Buy 5 for €151,05 each and save 5%
  • Buy 10 for €143,10 each and save 10%
  • Buy 25 for €135,15 each and save 15%
  • Buy 50 for €127,20 each and save 20%
Availability:
In stock
Delivery time:
Ordered before 5 p.m.! Start today.
  • Award Winning E-learning
  • Lowest price guarantee
  • Personalized service by our expert team
  • Pay safely online or by invoice
  • Order and start within 24 hours

Introduction to SQL E-Learning

Order this unique E-Learning course Introduction to SQL online, 1 year 24/7 access to rich interactive videos, speech, progress monitoring through reports and tests per chapter to test the knowledge directly.

Welcome to database development using one of the most powerful database management systems – Structured Query Language (SQL). Many database management system (DBMS) tools run on a variety of hardware architecture. The differences among the tools can be great, but all serious products have one main thing in common: they provision SQL data access and manipulation. If you know SQL, you can build relational databases and get useful information from them. This series of courses will guide you through each step of the SQL architecture, how to create effective SQL databases, and how to effectively manage them. You will gain knowledge of database theory, concepts, and design so that you're equipped to create an effective database.

Course content

SQL Database in a Nutshell

Course: 1 Hour

  • Course Introduction
  • Introduction to the Database Concept
  • The Relation of Data and the Various Databases
  • Variations of Query
  • Dissecting the Code behind Structured Query Language
  • Introduction to the SQL Syntax
  • Understanding Data Types
  • Ready to Create a Database

Playing with Tables

Course: 59 Minutes

  • How to Create a Table
  • Tables by Example
  • Adding Data Using INSERT Statement
  • Creating More Complex Tables
  • Changing an Existing Table
  • Deleting an Existing Table
  • Quick Peek Using SELECT Statement
  • Learning the NULL Statement
  • Why use DEFAULT?

Managing Data the SQL Way

Course: 49 Minutes

  • SELECT in More Detail
  • Selecting Data from More Than One Table
  • Query Your Data Types in SQL
  • Deleting a Record Using a DELETE Query
  • Introduction to Using UPDATE
  • Ordering Results with ORDER BY
  • Filter Results with WHERE Clause
  • Use Case Example Using Data Management Components

Practice: Basics of SQL

Course: 5 Minutes

  • Exercise: SQL Main Components and Why They're Used

Creating Tables

Course: 18 Minutes

  • Course Introduction
  • The PRIMARY KEY Rules
  • Using CREATE TABLE with PRIMARY KEY Constraint
  • Using ALTER TABLE with a PRIMARY KEY Constraint

Using ALTER to Rewrite Data

Course: 18 Minutes

  • Table Altering
  • ALTER and CHANGE
  • DROP COLUMN Introduction
  • Using DROP COLUMN, ALTER, and CHANGE in SQL

Manipulating Data Using SQL Arithmetic

Course: 8 Minutes

  • Basic Math Operators and Functions
  • Understanding Rounding Numbers in SQL

Grouping and Aggregating Data Using SQL

Course: 31 Minutes

  • Using MIN and MAX in SQL
  • AVG and GROUP BY
  • Limit Results Using LIMIT and SELECT DISTINCT
  • Use Case Example Using SQL Arithmetic and Grouping

Introducing String Functions

Course: 33 Minutes

  • Introduction to SUBSTRING() Function
  • LENGTH() Function
  • REVERSE() Function
  • TRIM() Function
  • Date Functions
  • SOUNDEX() and DIFFERENCE() Functions
  • Putting String Functions Together

Practice: Managing Data with SQL

Course: 7 Minutes

  • Exercise: Recognizing SQL Data Processes

Multi-table Database Architecture in SQL

Course: 48 Minutes

  • Course Introduction
  • Introduction to Multi-Table Architecture
  • Connecting Tables Together
  • Creating Tables with a FOREIGN KEY
  • Patterns of Data in SQL
  • SQL Composite Keys Using Multiple Values
  • Functional Dependencies
  • Use Case Example Using Functional Dependencies

SQL Joins and Multi-table Operations

Course: 31 Minutes

  • INNER JOINs – An Introduction
  • EQUI JOINs and NON-EQUI JOINs
  • OUTER JOINs
  • Multiple Conditions Using Multiple JOINs
  • UNION Operator and Combining Results

Subquery – Queries Inside of More Queries

Course: 57 Minutes

  • Introduction to Subquery
  • Using query as a SELECT Column
  • Correlated and Noncorrelated Queries
  • Example of a Query with a Natural Join
  • Using IN, NOT IN in SQL
  • Correlated Query with EXISTS and NOT EXISTS
  • Using HAVING Clause with Queries
  • Using Queries with the UPDATE Statement
  • Using Queries with INSERT Statement
  • Using Queries with DELETE FROM Statement

Look at Advanced Queries in SQL

Course: 17 Minutes

  • Working with Difficult Queries
  • Tips for Efficient Queries

Practice: Multi-tables, Joins, and Advanced Queries

Course: 6 Minutes

  • Exercise: Multilevel Architecture with a Twist

The Big Picture

Course: 39 Minutes

  • Course Introduction
  • Introduction to Views
  • Creating a View
  • Types of Views in SQL
  • Updating Views in SQL
  • Dropping Views

Grouping Statements Using Transactions

Course: 58 Minutes

  • Introducing Transactions
  • Describing ACID Transactions
  • Use Case Transactional Data
  • Defining ROLLBACK Statement
  • Defining COMMIT Statement
  • Using ROLLBACK and COMMIT Statements in SQL
  • Introduction to Transact-SQL
  • Operational Transaction Logs

Implementing Transactions with Locks

Course: 40 Minutes

  • Concept of Locks
  • Various Levels of Locking
  • Setting Modes for Locks
  • Levels of Locking
  • Example of Implementing Locks on Transactions

Restricting Access of Data

Course: 44 Minutes

  • Introduction to SQL Security Concepts
  • User IDs
  • Creating and Managing Users in SQL
  • Group IDs and the Use of Roles
  • Privileges and Access Rights
  • Use Case Example of the Use of Access Rights

Practice: Transactions & SQL Security Architecture

Course: 8 Minutes

  • Exercise: SQL Views, Transactions, & Security Model
Language English
Qualifications of the Instructor Certified
Course Format and Length Teaching videos with subtitles, interactive elements and assignments and tests
Lesson duration 10:36 Hours
Progress monitoring Yes
Access to Material 365 days
Technical Requirements Computer or mobile device, Stable internet connections Web browsersuch as Chrome, Firefox, Safari or Edge.
Support or Assistance Helpdesk and online knowledge base 24/7
Certification Certificate of participation in PDF format
Price and costs Course price at no extra cost
Cancellation policy and money-back guarantee We assess this on a case-by-case basis
Award Winning E-learning Yes
Tip! Provide a quiet learning environment, time and motivation, audio equipment such as headphones or speakers for audio, account information such as login details to access the e-learning platform.

There are no reviews written yet about this product.

Loading...

OEM Office Elearning Menu Genomineerd voor 'Beste Opleider van Nederland'

OEM Office Elearning Menu is trots genomineerd te zijn voor de titel 'Beste Opleider van Nederland' door Springest, een onderdeel van Archipel. Deze erkenning bevestigt onze kwaliteit en toewijding. Hartelijk dank aan al onze cursisten.

Reviews

There are no reviews written yet about this product.

25.000+

Deelnemers getrained

Springest: 9.1 - Edubookers 8.9

Gemiddeld cijfer

3500+

Aantal getrainde bedrijven

20+

Jaren ervaring

Even more knowledge

Read our most recent articles

View blog