Do you wonder how to get started using PostgreSQL with minimal hassle? This step-by-step video tutorial with plenty of tips delivers immediate ...
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.
- Introduction to databases (06:35)
relational database, database design, one-to-one relationship, one-to-many relationship, many-to-many relationship
- Create table (06:40)
primary key, foreign key, SQL data types, constraints, relationship
- Insert data into table (10:35)
insert into clause
- Select statement (08:10)
order by clause, calculated columns
- Where clause (10:50)
- Joins (15:55)
left outer join, right outer join, full outer join, self join, aliases
- Group by clause (13:40)
having, distinct, aggregate functions: sum, min, max, avg, count
- Union (07:40)
union, union all, intersect, except
- Subqueries (17:25)
some, any, all, exists, nested subqueries
- Useful functions (13:45)
case, round, ceil, floor, year, month, day, substring, left, right, charindex, contatenation, cast, convert, upper, lower, getdate, datediff
- Table modification (12:15)
alter table, drop table, delete from table, update table, truncate table
- Views (10:55)
create view, drop view, update view, alter view, updateable view