Microsoft SQL Database Fundamentals

Learn the fundamentals of SQL as you build a database for a fictitious hardware store
4.0 (16 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.
635 students enrolled
$20
Take This Course
  • Lectures 9
  • Contents Video: 1.5 hours
    Other: 3 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 3/2013 English

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

What are the requirements?

  • SQL Server Express 2008 or 2012 available as a free download

What am I going to get from this course?

  • 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.

What is the target audience?

  • Beginner (with some database experience) to Intermediate

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

Section 1: Getting Started
Course Overview
Preview
2 pages
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.
Section 2: Building Your Database
05:23
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.
12:14
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.
09:40

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.

14:03

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.

12:38

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.

23:24

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.

Section 3: Conclusion
13 questions
Conclusion
1 page

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Boolean Logical Ltd, Real world software education

Boolean Logical was set up three years ago with the aim to provide software training based on practices used on a daily basis, rather than classroom theory. Nick Ioannou, one of the founding directors has over 20 years IT experience, in multimedia, training and systems support. Nick's IT Tips blog features over 300 posts of free software and advice.

Ready to start learning?
Take This Course