on-demand course

SQL Fundamentals LiveLessons

with Arie D. Jones

September 2009

Beginner

8h 1m

English

Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)

Watch now

Unlock full access

Includes

Earns Badge

Course outline

SQL Fundamentals Overview
3m 1s
Learning Objectives
41s
Introduction to the MySQL Interfaces
13m 30s
Learning Objectives
36s
The SELECT statement
12m 4s
DISTINCT
8m 17s
Ordering the results with ORDER clause
10m 9s
Using the WHERE clause to filter data
22m 23s
Using Subqueries to filter data
11m 14s
Learning Objectives
38s
UPDATE
12m 56s
INSERT
14m 16s
DELETE
7m 4s
Managing Transactions
17m 55s
Learning Objectives
49s
COUNT/SUM/MIN/MAX
14m 26s
GROUP BY
14m 50s
Filtering results using the HAVING clause
12m 5s
Learning Objectives
44s
Introduction to the concept of joins
13m 10s
INNER
8m 51s
OUTER
10m 31s
UNION
8m 42s
INTERSECT
10m 25s
MINUS
9m 29s
Learning Objectives
59s
CREATE and DROP
17m 22s
ALTER objects in the table objects
13m 38s
Placing indexes on tables for improved performance
29m 45s
Using keys and constraints to control data entered into tables
17m 56s
Working with temporary table objects
7m 3s
Learning Objectives
43s
Introduction of how security in the database is handled
9m 28s
Working with Users
15m 39s
Assigning rights
16m 53s
Learning Objectives
42s
SQL Functions: String and Numbers
17m 21s
SQL Functions: Date and Time
14m 20s
SQL Functions: Conversions
10m 27s
VIEWS
9m 45s
STORED PROCEDURES
21m 29s
TRIGGERS
23m 2s
CURSORS
16m 9s

Content preview from SQL Fundamentals LiveLessons

VIEWS

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

You might also like

SQL Fundamentals

SQL Fundamentals

Thomas Nield

Database Fundamentals LiveLessons

Database Fundamentals LiveLessons

Eric Johnson

Learning SQL For Oracle

Learning SQL For Oracle

Steve Perry

Getting Started with SQL

Getting Started with SQL

Thomas Nield

Publisher Resources

ISBN: 9780768694765Purchase book