O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Database for Beginners

Video Description

Have you started learning about SQL Databases, only to get stuck while trying to teach yourself? Or are you a developer whose never felt totally at ease with database work? Have you been looking for an easy and comprehensive way to go beyond the basics and start using SQL Databases in a professional and efficient way? Perhaps, you just want to get your SQL queries to work the first time! In this thorough and easy-to-follow course, LearnToProgram's database expert Martin Holzke shows you how to achieve success. From the very first lesson, you'll learn how to correctly structure your database, how to author efficient SQL statesments and clauses, and how to manage your SQL database for scalable growth. This course gives you all the information you need to successfully start working with SQL databases and make use of the database in your applications. Martin will invite you to work along with him as he demonstrates the ins and outs of database management and database for application development. If you're developing web or mobile apps-- or even games-- there is much to be learned about this important facet of development. If you're brand new to SQL Database work, or a professional developer looking to learn the best practices, then SQL Database for Beginners is the perfect course for you!

Table of Contents

  1. Chapter 1: Rational Databases
    1. What are Databases? 00:07:25
    2. What's the Role of Databases in Application Programming? 00:07:57
    3. Tables and Relations 00:14:40
    4. Primary and Foreign Keys and Other Constraints 00:12:00
  2. Chapter 2: SQL Querying
    1. What is Querying? 00:02:41
    2. The ANSI SQL Standard 00:04:00
    3. DML, DDL and More 00:05:08
    4. Common Query Tools 00:08:27
  3. Chapter 3: Your First Queries
    1. The SELECT Statement 00:06:17
    2. Limiting Output Columns 00:04:57
    3. Formatting and Sorting Output 00:15:22
    4. Column Aliases 00:06:20
  4. Chapter 4: Filtering Your Results
    1. The WHERE Clause 00:04:57
    2. Creating a Filter Condition 00:07:20
    3. Applying Multiple Filter Conditions 00:08:14
    4. More Filter Operations 00:11:22
  5. Chapter 5: Consolidating Your Data
    1. Counting Records 00:05:14
    2. Common Aggregate Functions: SUM, AVG, MIN, MAX 00:08:06
    3. Do's and Don'ts When Consolidating 00:08:38
    4. Unions and Other Multiset Consolidations 00:10:57
  6. Chapter 6: Grouping Your Data
    1. The GROUP BY Clause 00:10:00
    2. The HAVING Clause 00:05:36
    3. Do's and Don'ts When Grouping 00:06:09
  7. Chapter 7: Joining Tables
    1. Table Aliases 00:06:55
    2. Inner Joins 00:14:58
    3. Outer Joins 00:14:08
    4. Self Joins 00:08:00
    5. Complex Multi Table Joins 00:19:57
  8. Chapter 8: Subqueries
    1. Filtering Using Subqueries 00:14:09
    2. The EXISTS Clause 00:06:49
    3. Subqueries as Alternative to Joins 00:07:10
    4. Derived Tables 00:05:40
  9. Chapter 9: Manipulating Your Data
    1. The INSERT Statement 00:20:46
    2. The UPDATE Statement 00:12:51
    3. The DELETE Statement 00:06:27
  10. Chapter 10: Transaction Control
    1. What are Transactions? 00:05:24
    2. Initiating a Transaction 00:04:18
    3. The COMMIT and ROLLBACK Commands 00:04:23
  11. Chapter 11: Creating Database Objects and Adding Business Logic
    1. Creating Tables 00:16:39
    2. Creating and Using Views 00:09:16
    3. Developing and Calling Stored Procedures 00:10:42
    4. Implementing Triggers 00:09:26