SQL Server FAST TRACK for Novices - Tables

Quickly master intelligent table design and management via SSMS, Queries, TSQL, Scripting and Stored Procedures.
4.0 (6 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.
1,203 students enrolled
Instructed by Dave Merton Development / Databases
$25
Take This Course
  • Lectures 37
  • Contents Video: 2 hours
  • 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/2014 English

Course Description

This is an in depth course about using and programming with SQL Server. It assumes that the student has at least a rudimentary understanding of database concepts and architecture and gets right into the meat of the subject.

This course will get you up to speed on proper table design, creation, scripting and management as well as executing simple TSQL statements. The course will also provide real world examples of using Stored Procedures to effectively streamline such functions as INSERT, UPDATE and DELETE. The Stored Procedures are completely downloadable!!

What are the requirements?

  • You should have at least a rudimentary understanding of databases. A beginner's knowledge of MS Access or any other database package will suffice.

What am I going to get from this course?

  • By the end of this course you should have a very clear understanding of how to design, create, manage and maintain the different types of database tables.
  • This course will also whet your appetite for stored procedures. You will learn from real world examples how to create table specific Stored Procedures to facilitate the INSERT, UPDATE and DELETE functions.
  • This course will teach you many different concepts and techniques; however you will also see several code examples of multiple techniques in action at the same time. This will provide you with a real world taste of what you can do in SQL Server and will catapult (fast track) you past your colleagues.

What is the target audience?

  • Any technical person who wants to have an increased understanding of the real world uses of production database development.
  • Any database developer who is ambitious, intelligent and lazy!

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: The Basics
* * * * COURSE INTRODUCTION * * * *
Preview
03:11
* * SECTION DESCRIPTION * *
Preview
00:32
Table Types
Preview
03:03
SECTION 1 - REVIEW QUIZ
4 questions
Section 2: Table Design and Management
* * SECTION DESCRIPTION * *
Preview
02:17
Table Design and Naming Convention
Preview
04:58
How to Create Setup Tables - SSMS
05:52
How to Alter Table Schema - SSMS
03:55
How to Alter Table Schema - Command Line TSQL
03:58
SECTION 2 - REVIEW QUIZ
6 questions
Section 3: INSERT Records
* * SECTION DESCRIPTION * *
03:02
INSERT RECORDS - SSMS
01:13
INSERT RECORDS - SSMS - NOT NULL Fields
01:46
INSERT RECORDS - SSMS - Handling NOT NULL Fields with Default Va
03:13
INSERT RECORDS - TSQL
02:56
INSERT RECORDS - TSQL - Default Values
04:30
INSERT RECORDS - STORED PROCEDURE
02:29
INSERT RECORDS - STORED PROCEDURE AND DEFAULT VALUES
06:42
SECTION 3 - REVIEW QUIZ
8 questions
Section 4: UPDATE Records
* * SECTION DESCRIPTION * *
03:03
UPDATE RECORDS - SSMS GUI
01:17
UPDATE RECORDS - VIA TSQL
02:48
UPDATE RECORDS - TSQL SCRIPT
02:51
UPDATE RECORDS - STORED PROCEDURE
04:14
SECTION 4 - REVIEW QUIZ
6 questions
Section 5: DELETE Records
* * SECTION DESCRIPTION * *
03:01
DELETE RECORDS - SSMS GUI
00:43
DELETE RECORDS - VIA TSQL
01:54
DELETE RECORDS - TSQL SCRIPT
02:18
DELETE RECORDS - STORED PROCEDURE
03:12
SECTION 5 - REVIEW QUIZ
4 questions
Section 6: INSERT & DELETE Advanced
* * SECTION DESCRIPTION * *
03:09
INSERT and DELETE - Part 1 of 5 - SSMS
01:23
INSERT and DELETE - Part 2 of 5 - TSQL
04:16
INSERT and DELETE - Part 3 of 5 - IDENTITY INSERT
05:48
INSERT and DELETE - Part 4 of 5 - SELECT INTO
05:47
INSERT and DELETE - Part 5 of 5 - DBCC CheckIdent
04:12
SECTION 6 - REVIEW QUIZ
5 questions
Section 7: Scripting
* * SECTION DESCRIPTION * *
03:49
Scripting - Part 1 of 4 - Table Creation Script - SSMS
03:25
Scripting - Part 2 of 4 - Data Insertion Script
03:05
Scripting - Part 3 of 4 - Using a Script as a Template
03:11
Scripting - Part 4 of 4 - Specialty Stored Procedure
03:48
SECTION 7 - REVIEW QUIZ
4 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dave Merton, Senior SQL Server Database Developer

Dave Merton is a software developer, troubleshooter, problem solver, software trainer, author and entrepreneur. He has been designing high end custom software for the last 20 years in direct mail, the pharmaceutical industry, oil companies and more.

Over the last eight years Dave has been developing and modifying custom high end software for dozens of testing laboratories throughout the U.S. This specific software discipline is referred to as "LIMS" (Laboratory Information Management System) and can be very intensive during development and deployment. For LIMS development Dave has been using VB.Net & C Sharp for the front end; web, VB.Net and MS Access for custom reporting; and SQL Server for the back end. During this time Dave has personally built over nine separate LIMS and LIMS (LAB) related apps.

In addition to software development Dave has personally instructed hundreds of individuals in programming. He has trained several persons in VB skills, one on one as well as given class room instruction to larger groups in the work place for both VB and SQL Server. Dave has also taught VB, Access and JavaScript in the New Milford public school system in the Adult Education program. Dave loves to teach.

Send Dave an email, he would love to hear from you.

Ready to start learning?
Take This Course