SQL Database for Beginners [Video]

SQL Database for Beginners [Video]

Martin Holzke

Master SQL Database Creation and Development with Guru Martin Holzke.
Mapt Subscription
FREE
$29.99/m after trial
Video
$85.00
RRP $99.99
Save 14%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$85.00
$29.99p/m after trial
RRP $99.99
Subscription
Video
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Video Details

ISBN 139781786469298
Course Length7 hours 33 minutes

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 statements 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

Rational Databases
What are Databases?
What's the Role of Databases in Application Programming?
Tables and Relations
Primary and Foreign Keys and Other Constraints
SQL Querying
What is Querying?
The ANSI SQL Standard
DML, DDL and More
Common Query Tools
Your First Queries
The SELECT Statement
Limiting Output Columns
Formatting and Sorting Output
Column Aliases
Filtering Your Results
The WHERE Clause
Creating a Filter Condition
Applying Multiple Filter Conditions
More Filter Options
Consolidating Your Data
Counting Records
Common Aggregate Functions: SUM, AVG, MIN, MAX
Do's and Don'ts When Consolidating
Unions and Other Multiset Consolidations
Grouping Your Data
The GROUP BY Clause
The HAVING Clause
Do's and Don'ts When Grouping
Joining Tables
Table Aliases
Inner Joins
Outer Joins
Self Joins
Complex Multi Table Joins
Subqueries
Filtering Using Subqueries
The EXISTS Clause
Subqueries as Alternative to Joins
Derived Tables
Manipulating Your Data
The INSERT Statement
The UPDATE Statement
The DELETE Statement
Transaction Control
What are Transactions?
Initiating a Transaction
The COMMIT and ROLLBACK Commands
Creating Database Objects and Adding Business Logic
Creating Tables
Creating and Using Views
Developing and Calling Stored Procedures
Implementing Triggers

What You Will Learn

  • Understand Databases
  • Create Tables
  • Understand Database Relationships
  • Write Queries
  • Use Common Query Tools
  • Work with the Select Statement
  • Limit Output
  • Format and Sort Output
  • Create Column Aliases
  • Use the WHERE clause
  • Create Filters
  • Work with multiple Filters
  • Count Records
  • Use Common SQL Functions
  • Apply Unions and other Consolidations
  • Use the GROUP BY clause
  • Use the HAVING clause
  • Create Inner Joins
  • Create Outer Joins
  • Create Self Joins
  • Create Comple, Multi-Table Joins
  • Filter with Subqueries
  • Use INSERT, UPDATE and DELETE
  • Understanding Transactions
  • Create Tables and Views
  • Create and Execute Stored Procedures

Authors

Table of Contents

Rational Databases
What are Databases?
What's the Role of Databases in Application Programming?
Tables and Relations
Primary and Foreign Keys and Other Constraints
SQL Querying
What is Querying?
The ANSI SQL Standard
DML, DDL and More
Common Query Tools
Your First Queries
The SELECT Statement
Limiting Output Columns
Formatting and Sorting Output
Column Aliases
Filtering Your Results
The WHERE Clause
Creating a Filter Condition
Applying Multiple Filter Conditions
More Filter Options
Consolidating Your Data
Counting Records
Common Aggregate Functions: SUM, AVG, MIN, MAX
Do's and Don'ts When Consolidating
Unions and Other Multiset Consolidations
Grouping Your Data
The GROUP BY Clause
The HAVING Clause
Do's and Don'ts When Grouping
Joining Tables
Table Aliases
Inner Joins
Outer Joins
Self Joins
Complex Multi Table Joins
Subqueries
Filtering Using Subqueries
The EXISTS Clause
Subqueries as Alternative to Joins
Derived Tables
Manipulating Your Data
The INSERT Statement
The UPDATE Statement
The DELETE Statement
Transaction Control
What are Transactions?
Initiating a Transaction
The COMMIT and ROLLBACK Commands
Creating Database Objects and Adding Business Logic
Creating Tables
Creating and Using Views
Developing and Calling Stored Procedures
Implementing Triggers

Video Details

ISBN 139781786469298
Course Length7 hours 33 minutes
Read More

Read More Reviews

Recommended for You

Getting Started with Ansible 2 Security Automation [Video] Book Cover
Getting Started with Ansible 2 Security Automation [Video]
$ 124.99
$ 106.25
Laravel Foundations: Basics to Every App [Video] Book Cover
Laravel Foundations: Basics to Every App [Video]
$ 124.99
$ 106.25
Haskell Cookbook Book Cover
Haskell Cookbook
$ 39.99
$ 28.00
ServiceNow Application Development Book Cover
ServiceNow Application Development
$ 39.99
$ 28.00
Identifying Behaviour Patterns using Machine Learning Techniques [Video] Book Cover
Identifying Behaviour Patterns using Machine Learning Techniques [Video]
$ 124.99
$ 106.25
Architectural Patterns and Best Practices with Python [Video] Book Cover
Architectural Patterns and Best Practices with Python [Video]
$ 124.99
$ 106.25