Microsoft SQL Database Fundamentals
4.0 (49 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
759 students enrolled

Microsoft SQL Database Fundamentals

Learn the fundamentals of SQL as you build a database for a fictitious hardware store
4.0 (49 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
759 students enrolled
Last updated 8/2013
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 10 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • By the end of this course you will be able to build SQL databases and create Stored Procedures, Foreign Key Relationships, Insert Statements, Joins & Diagrams, Queries With Aggregate Functions, work with Scalar and Inline Table Functions.
Course content
Expand all 9 lectures 01:23:15
+ Getting Started
2 lectures 02:53
This tutorial provides a step by step guide to help you install SQL Express 2008 R2.
Please download the detailed step-by-step lesson guide, which you will need to ideally either print or view on a second device.
Preview 02:53
+ Building Your Database
6 lectures 01:17:22
Learn the fundamentals of SQL as we build a database for a fictitious hardware store. This tutorial includes: creating a new table, setting a primary key, setting an identity column and more.
Please download the detailed step-by-step lesson guide, which you will need to ideally either print or view on a second device.
Preview 05:23
Learn the fundamentals of SQL as we build a database for a fictitious hardware store. This tutorial includes: creating and executing insert, update, delete, select stored procedures and more.
Please download the detailed step-by-step lesson guide, which you will need to ideally either print or view on a second device.
Preview 12:14

Learn the fundamentals of SQL as we build a database for a fictitious hardware store. This tutorial includes: creating relationships between tables, creating a database diagram and more.

Please download the detailed step-by-step lesson guide, which you will need to ideally either print or view on a second device.

Preview 09:40

Learn the fundamentals of SQL as we build a database for a fictitious hardware store. This tutorial includes: sql queries with joins, modifying tables with the database diagram and more.

Please download the detailed step-by-step lesson guide, which you will need to ideally either print or view on a second device.

Preview 14:03

Learn the fundamentals of SQL as we build a database for a fictitious hardware store. This tutorial includes: working with views, creating SQL queries with aggregate functions and more.

Please download the detailed step-by-step lesson guide, which you will need to ideally either print or view on a second device.

Preview 12:38

Learn the fundamentals of SQL as we build a database for a fictitious hardware store. This tutorial includes: creating scaler & inline table functions, using functions in sql queries and more.

Please download the detailed step-by-step lesson guide, which you will need to ideally either print or view on a second device.

Preview 23:24
+ Conclusion
1 lecture 00:00
Testing Your SQL Knowledge
13 questions
Conclusion
1 page
Requirements
  • SQL Server Express 2008 or 2012 available as a free download
Description

Learn the fundamentals of SQL for beginners as you build a database for a fictitious hardware store, covering customers, and stock and orders in this online SQL training course. Follow the real-time videos to see exactly how to build a complex database and the methods used to extract meaningful information via queries, stored procedures, scalar functions and views. 60+ pages of step by step PDF documentation complements the online sql training course, which can be done with either the full or FREE Express version of Microsoft SQL Server 2008 or 2012.

Written by a senior SQL developer at a major global company, the online SQL training course is based on practices used on a daily basis, rather than classroom theory. This is the ideal SQL training course for beginners (with some database experience) or if you need to learn SQL for a job interview in a short space of time, or need practical examples of a SQL database in use.

Who this course is for:
  • Beginner (with some database experience) to Intermediate