Home » Databases » SQL tutorial video

 
 

SQL tutorial video

 

This SQL video tutorial presents how to write SQL query step by step with practical examples. Find out how the SQL statements are executed and how to write effective queries.

Structured Query Language is the most popular language used to create and manage databases. Almost all modern relational database management systems like Oracle, MS SQL Server, DB2, Sybase, MySQL, Postgres, Informix and even Microsoft Access use SQL as a standard database language. Our SQL video training will teach you how to use commonly used commands and you will be able to apply most of the knowledge gathered from this video course to any database.

The best way of learning is watching video lessons.
Learning SQL can be fast, easy and enjoyable! Learn by examples!

This unique database video tutorial not only provides easy-to-understand instructions, but it pays attention to key issues. This SQL video course is the best way to get started. 12 lessons, total length 2 h 15 min.

  1. Introduction to databases (06:35)
    relational database, database design, one-to-one relationship, one-to-many relationship, many-to-many relationship
  2. Create table (06:40)
    primary key, foreign key, SQL data types, constraints, relationship
  3. Insert data into table (10:35)
    insert into clause
  4. Select statement (08:10)
    order by clause, calculated columns
  5. Where clause (10:50)
    SQL operators
  6. Joins (15:55)
    left outer join, right outer join, full outer join, self join, aliases
  7. Group by clause (13:40)
    having, distinct, aggregate functions: sum, min, max, avg, count
  8. Union (07:40)
    union, union all, intersect, except
  9. Subqueries (17:25)
    some, any, all, exists, nested subqueries
  10. Useful functions (13:45)
    case, round, ceil, floor, year, month, day, substring, left, right, charindex, contatenation, cast, convert, upper, lower, getdate, datediff
  11. Table modification (12:15)
    alter table, drop table, delete from table, update table, truncate table
  12. Views (10:55)
    create view, drop view, update view, alter view, updateable view

Price 27.00 USD

Frequently Asked Questions

Free lesson:

Tags: ,