SQL Server FAST TRACK for Novices - Tables
4.3 (10 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,232 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server FAST TRACK for Novices - Tables to your Wishlist.

Add to Wishlist

SQL Server FAST TRACK for Novices - Tables

Quickly master intelligent table design and management via SSMS, Queries, TSQL, Scripting and Stored Procedures.
4.3 (10 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,232 students enrolled
Created by Dave Merton
Last updated 3/2014
English
Current price: $10 Original price: $25 Discount: 60% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
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.
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!!

Who 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!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
02:00:51
+
The Basics
3 Lectures 06:46
+
Table Design and Management
5 Lectures 21:00


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
+
INSERT Records
8 Lectures 25:51
* * 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
+
UPDATE Records
5 Lectures 14:13
* * 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
+
DELETE Records
5 Lectures 11:08
* * 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
+
INSERT & DELETE Advanced
6 Lectures 24:35
* * 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
+
Scripting
5 Lectures 17:18
* * 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
About the Instructor
Dave Merton
3.7 Average rating
14 Reviews
1,696 Students
3 Courses
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.