SQL Database for Beginners [Video]

More Information
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
About

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!

Features

Programmers, Software Developers, Students in Programming Classes, Developers who need to learn some SQL, Anyone who wants to improve their SQL Programming skills.

Course Length 7 hours 33 minutes
ISBN 9781786469298
Date Of Publication 29 Jun 2016

Authors

Martin Holzke

Martin Holzke’s programming career started while studying Physics in the late 1980’s when he took on an offer to learn to program at Philips instead of the more common student jobs. Once graduated, he started his own business developing applications and systems as a freelance IT Consultant which he does to this day. His 25+ years’ journey continues to take him through a vast array of technologies, methodologies and languages like OOP, UML, C++, .NET, ADF, PHP, Zend, Oracle and SQL to name just a few.