Dr. Soper gives a lecture on using the structured query language (SQL) to work with databases. Topics include CREATE, ALTER, and DROP statements, SELECT, INSERT INTO, UPDATE, and DELETE FROM statements, subqueries, and inner and outer joins.
Dr. Soper gives a lecture on data modeling and the entity-relationship (ER) model. Topics include the components of ER models, depicting entities, attributes, r
Dr. Soper gives a lecture on the relational model and its role in the database world. Topics include relations, primary keys, composite keys, foreign keys, norm
Dr. Soper gives a lecture on database design. Topics include transforming ER data models into physical database designs, denormalization, implementing one-to-on
Dr. Soper gives a lecture on database administration. Topics covered include concurrent access / concurrency control, database security, database backup and rec
This SQL tutorial introduces the basic elements of SQL. By the end of this tutorial, you will be able to write simple queries to retrieve data out of a relatio
Datafun is a new language exploring the question: What's the simplest way to bring our general-purpose languages closer to our database query languages? At its
SQL Server MVPs Aaron Bertrand and Kevin Kline begin their series on query tuning best practices. They go over some tips and tricks for writing queries. First,
Donate!: http://bit.ly/DonateCTVM2. This video will be an introduction to structured query language (SQL). SQL is a language used to talk to any relational da
Learn database testing concepts, database testing basics and how to perform database testing manually with this database testing tutorial with examples in SQL S
Dr. Soper gives an introductory lecture on database technologies. Topics covered include the reasons for using a database, the components of a database system,
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 t
A crash course in SQL. How to write SQL from scratch in 1 hour. In this video I show you how to write SQL using SQL Server and SQL Server Management Studio.
This SQL Server tutorial explores the basics of modeling a strong and error-free database. Watch more at http://www.lynda.com/SQL-Server-2008-tutorials/essentia
In this course we will cover all of the fundamentals of the SQL (Structured Query Language). This course is great for beginners and also intermediates. We will
Data modeling in Visio 2013 is very different from data modeling in Visio 2010. In this video, Dr. Soper provides a brief tutorial on how to create entity-relat
Database Design Tutorial utilizing Visio and Microsoft SQL Server Express 2014. This is an introduction to database design through the first three normal form
From chapter 3 of Volume 2 of SQL Queries Joes 2 Pros. This shows how to put calculations as new fields in your queries. You can follow along for free even if y
http://www.LittleWebHut.com This series of videos demonstrates how to write HTML code that is compliant with the new HTML5 standards. These videos are good for