SQL Database for Beginners

Master SQL Database Creation and Development with Guru Martin Holzke. Use Your DB Skills to Create Mobile or Web Apps
4.2 (95 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
3,845 students enrolled
$20
Take This Course
  • Lectures 56
  • Contents Video: 6.5 hours
    Other: 18 mins
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2013 English

Course 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! 

What are the requirements?

  • PC or Mac

What am I going to get from this course?

  • 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

What is the target audience?

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Course Introduction
Preview
01:35
Section 1: Relational Databases
07:24
In this video, Martin introduces you to databases and their functions, as well as explaining the relationships of data.
07:56
Martin will show you the purpose of having databases in application programming and how to properly set them up. 
14:40
This video will give you a closer look on database tables and database relationships.
12:00
In this video, instructor Martin will cover primary and foreign keys and other constraints, along with why they are important and how to work with them.
2 pages
Complete this exercise after viewing the videos from this chapter.
Section 2: SQL Querying
02:40
This video will cover what exactly database querying is, and how to pull information together.
03:59
This video will go over the ANSI SQL standard and the role it plays in SQL query.
05:07
Instructor Martin will show you the main commands in SQL, including DML and DDL, amongst others.
08:27
This video will show you great query tools such as MySQL Workbench and phpMyAdmin.
2 pages
Complete this exercise after viewing the videos from this chapter.
Section 3: Your First Queries
06:17
This video will show you how you can use the SELECT statement to recall information from your tables.
04:57
In this video, you will be shown how to filter out specific information found within your tables.
15:22
This video will further demonstrate many different ways in which you can filter the information within your tables.
06:19
Martin will show you how to re-name the columns which display your information, potentially making it easier for you and others to read the information.
1 page
Complete this exercise after viewing the videos from this chapter.
Section 4: Filtering Your Results
04:57
This video will show you how to use the WHERE clause and reduce the number of results you get from a query.
07:19
Your instructor will demonstrate how to filter numbers, dates, and strings in this video.
08:13
You will be shown how to apply multiple filter conditions in this video in order to organize your query information to your liking.
11:21
This video will show you even more filter options, such as how to filter out specific information within your query.
1 page
Complete this exercise after viewing the videos from this chapter.
Section 5: Consolidating Your Data
05:14

In this video, Martin will show you how to use the count attribute.

08:06
This video will show you how to use the most common aggregate functions and how to properly execute them.
08:38
Martin will demonstrate what you can and can't do when it comes to aggregate functions.
10:57
This video will show you how to consolidate multiple queries into one large result set.
1 page
Complete this exercise after viewing the videos from this chapter.
Section 6: Grouping Your Data
09:59
The GROUP BY clause allows you to consolidate your data by one or more criteria. This video will show you how to do this.
05:36
This video will show you how to use the HAVING clause within the GROUP BY clause.
06:09
This video will show you what you can and can't do when using the grouping clause.
1 page
Complete this exercise after viewing the videos from this chapter.
Section 7: Joining Tables
06:54
Table aliases are important in joining multiple tables if needed. This video will show you how to properly execute doing this.
14:58
This video will show you how to get started in joining your tables.
14:08
This video will show you how to get started in joining your tables.
08:00
In this video, Martin will discuss the purpose of self joins and why they are important.
19:57
This video will explain how to complete much more complex joints between your tables.
2 pages
Complete this exercise after viewing the videos from this chapter.
Section 8: Subqueries
14:09
This video will explain what subqueries are and how to use them as a filter condition.
06:49
Martin will explain how to use the EXISTS clause within your subqueries in this video, which will further allow you to filter your records.
07:09
This video will demonstrate what alternative joins are and when you should use them.
05:39
Derived tables can be used within subqueries and Martin will show you when and how they can be used.
2 pages
Complete this exercise after viewing the videos from this chapter.
Section 9: Manipulating Your Data
20:46
The INSERT statement belongs to the data manipulation part of SQL. Martin will instruct you how to add new records to your database tables in this video.
12:50
This video will show you how to modify existing records within a table using the UPDATE statement. 
06:26
Martin will demonstrate how to delete records in full in this video, by using the DELETE statement.
2 pages
Complete this exercise after viewing the videos from this chapter.
Section 10: Transaction Control
05:24
Transactions allow you to build brackets around multiple statements and is used in INSERTs, UPDATEs, and DELETEs. Martin will show you how to execute this properly in this video.
04:17
This video will show you how to initiate and execute a transaction and also how to see the transaction. 
04:22
In this video, you will be instructed how to complete a transaction using the COMMIT and ROLLBACK commands.
1 page
Complete this exercise after viewing the videos from this chapter.
Section 11: Creating Database Objects and Adding Business Logic
16:39
This video will show you the most important tool in SQL: how to create new tables.
09:15
In this video you will learn how to create views for your tables, data, and queries.
10:41
As one of the advanced features in SQL, you will learn the basics of stored procedures in this video. 
09:25
Similar to stored procedures, triggers are an advanced feature. Martin will briefly go over how to use this aspect. 
2 pages
Complete this exercise after viewing the videos from this chapter.
Section 12: Lab Solutions
Lab Solutions
8.2 MB
Section 13: Bonus Lecture
Article

Here's some bonus material to help you continue learning. 

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

LearnToProgram, Inc., Learn Web, Mobile and Game Development

LearnToProgram Media is a leading publisher of web, mobile, and game development courses that are used by over 500,000 people in 65 countries. LearnToProgram's valuable network of technical resources includes content on YouTube, iTunes, and Roku, as well as books, free tutorials, and online courses.

With a mission of “teaching the world to code" LearnToProgram instructors are teachers first and technical experts second. Their primary skill is relating complex technical information to nontechnical people learning web, mobile and game development. The entirely online, self-paced sales model allows students to learn at their own pace.

With over 40 courses on the market, LearnToProgram offers students flexible programs in web development, mobile application development and game development. Currently the company's most popular online courses include Become a Certified Web Developer and 10 Apps in 10 Weeks.

The company is based outside of Hartford, Connecticut.

Instructor Biography

Martin Holzke, Senior IT, Security and Training Generalist @ SoftQualM

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.

In due course, Martin’s programming expertise has always been followed by training others, whether junior team members and colleagues or on behalf of commercial training providers. Just as his other skills, his training portfolio is evolving all the time into new subjects and delivery formats. His services are highly appreciated around the globe.

Aside from programming and training, Martin has in recent years been hugely involved in IT and Information Security, compliance and auditing and since 2013 he also is Technical Assessor for Information Security to the United Kingdom Accreditation Service (UKAS); needless to say he is now also teaching subjects like CISSP, Comptia Security+ and ISO27001.

Ready to start learning?
Take This Course