Basic SQL With SQL Server 2016
4.1 (29 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.
192 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Basic SQL With SQL Server 2016 to your Wishlist.

Add to Wishlist

Basic SQL With SQL Server 2016

With Intros. to Visual Studio, IIS Web Server and ASP.NET
4.1 (29 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.
192 students enrolled
Last updated 5/2017
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 4 hours on-demand video
  • 17 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Download and install SQL Server 2016
  • Import CSV files into SQL Server 2016
  • Write queries that control how much data is dispalyed
  • Write queries that summarize large quantities of data
  • Understand how to choose different data types
  • Create a table to represent an entity
  • Import files from EXCEL into SQL Server
  • Insert records into tables
  • Create indexes to ensure data integrity
  • Add IIS Web Server and configure it to work with SQL Server
  • Learn how to display information in web pages using Visual Studio
  • Make web pages to update, delete and edit records in SQL Server
  • Learn how to create and execute stored procedures
  • Learn how to restore databases
  • Learn how to combine tables with inner joins
  • Learn how to combine table with left outer joins
  • Learn how to use joins to make new tables
  • Learn how to add data input validation to web sites
  • and more!
View Curriculum
  • Must be able to download and install SQL Server 2016
  • Must be able to download and instal SQL Server Management Console
  • Must be able to download and install Visual Studio Community 2015

SQL is the most popular database programming language on the market today, and has been for many years. In this course, you learn the fundamentals of writing SQL to perform a variety of data manipulations. The course consists of HD videos, code, and quizzes so you can check your understanding. The whole course takes only 3 hours to complete and you even learn about ASP.NET, IIS and Visual Studio. and, by the end, you'll have a solid grasp of the fundamentals of programming in SQL. SQL is an essential skill for programmers, so it's highly recommended to have at least a passing familiarity with it. Thanks for reading, and let's get coding!

Who is the target audience?
  • This is a course for beginners
  • This is NOT a course for intermediate or advanced SQL programmers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
35 Lectures
1 Lecture 01:06

Learning Objective:

1. Familiarize yourself with the course

Preview 01:06
Getting the necessary tools
2 Lectures 08:55

Lesson Objectives:

  1. Find and download SQL Server 2016 Express
  2. Ensure computer can handle SQL Server 
Preview 04:07

Lesson Objectives:

  1. Install SQL Server
  2. Install SQL Server Management Console
Preview 04:48
Learning the fundamentals
11 Lectures 01:19:24

Lesson Objectives:

  1. Log in
  2. Make a database
  3. Import a table
Make a database and add a table from Excel

Lesson Objectives:

  1. Select all columns
  2. Select only certain columns
  3. Select columns with aliases
Select a variety of columns and displays the results

Summary quiz on lectures 4 and 5
3 questions

Lesson Objectives:

  1. Understand the purpose of using where to control the number of displayed records
Conceptual introduction to "where"

Lesson Objectives:

  1. Add a table 
  2. Understand how to map fields
  3. Write queries with simple where clauses
Filter records with simple "where"

Lesson Objectives:

  1. Use where with multiple conditions
  2. Use where with functions
Filter records with more sophisticated "where"

Using "where" quiz
2 questions

Lesson Objectives:

  1. Create simple data sorts
  2. Combine where with data sorts
Sort data with "order by"

Lesson Objectives:

  1. Understand the purpose of group by
  2. Understand the purpose of over
Conceptual introduction to using "group by" and "over"

Lesson Objectives:

  1. Write code to summarize results with group by
  2. Write code to combine group by and previous concepts
Summarize data with "group by"

Lesson Objectives:

  1. Understand how to use the over clause
  2. Understand how to use computed columns
Summarize data with "over"

Lesson Objectives:

  1. Understand how to format dates
  2. Understand how to format money values
Format output to make it look more professional

Lesson Objectives: 

  1. Understand how a query is written
  2. Understand how a query runs logically
Understand order of execution of queries

Where, over and execution order quiz
3 questions
Creating and changing tables
7 Lectures 47:19

Lesson Objectives:

  1. Look at an object and design a table to represent it
  2. Understand the concept of a data type
  3. Understand the purpose of a primary field
Make a table to represent an entity

Lesson Objectves:

  1. Import a CSV table
  2. Confirm characters are imported correctly
Add records from a csv file to fill the table

Lesson Objectives:

  1. Understand how to insert records
  2. Understand how to insert multiple records and records with different field orders

Insert records into a table using SQL

Summary quiz on lessons 15,16, 17
4 questions

Lesson Objectives:

  1. Learn how to copy a table
  2. Learn how to delete records from a table
Delete existing records

Learning Objectives:

  1. Update records
  2. Copy records from one table to another
Update existing records

Learning Objectives:

  1. Learn how to create an index
  2. Learn how to make practical use of an index
Create an index to prevent the insertion of duplicate records

Lesson Objectives: Understand the different between varchar and nvarchar

Understanding varchar and nvarchar in more detail
Making SQL Server work with Asp.Net
7 Lectures 01:03:47

Lesson Objectives: Add Internet Information Services web server to computer

Add IIS Web Server and configure SQL Server

Lesson Objectives: Learn how to get IIS Web Server working with SQL Server through Visual Studio

Get Visual Studio and get IIS working with SQL Server

Lesson Objectives: Learn how to create a dynamic web page with search features

Create a dynamic web page

Lesson Objectives: Learn how to add the ability to create, delete and update records from a web page

Edit, Create and Delete records

Lesson Objectives: Learn how to add ability to search records and use the details view control

Search and view restricted results

Lesson Objectives: Learn how to work with the grid view control and item templates

Work with the grid view control to sort and edit templates

Lesson Objective: Learn how to create and execute a stored procedure

Create and run a stored procedure from a web page
Joining tables
5 Lectures 37:18

Lesson Objectives: Restore the database to be used over the next several lessons

Restore Adventure Works 2014 From Backup

Lesson Objectives: Learn how to combine two tables using inner joins

Finding matching records using inner joins

Lesson Objectives: Understand how to join two tables using a left outer join

Find matching records using left outer joins

Lesson Objectives: Learn how to join two tables using the right outer join

Add a new website to IIS and copy out records with an inner join

Lesson Objectives: Learn how to perform validation on fields before information is submitted to SQL Server

Create an Asp.Net site and add validation
1 Lecture 04:52

Lesson Objectives: Understand why normalization of tables produces benefits

Understanding a table with several problems
Final Thoughts
1 Lecture 01:07

Lesson Objectives:

  1. Learn about a couple resources that will help you further your studies
Next possible steps
About the Instructor
Tom O.
4.4 Average rating
1,649 Reviews
17,721 Students
19 Courses
Web, Math, Stats., and Physics Expert
  • I have nine years experience as a teacher of mathematics, physics, statistics, and programming. I worked for five years as a database programmer using various technologies such as .NET, Clipper, SQL, SQL Server, SAS, Excel, and others. I'm the publisher of one of the most successful programming courses on udemy, called "Learn C# With Visual Studio 2013". Currently, I work as a mathematics and computer science teacher at a college in NY.
  • Related Education:
  • Master of Science in Applied Statistical Computing, Kennesaw State University
  • Bachelor of Arts, Pure Mathematics, Queens College
  • Associates of Science in Computer Programming
  • Creator of more than 1620 math, physics, statistics and programming videos
  • Programmer of more than 500 educational simulations

Miles Turnbull
4.1 Average rating
53 Reviews
344 Students
4 Courses

My principal interests lie in the automation of scientific instrumentation and analysis of collected data, along with the integration of disparate systems.  Recently developed some expertise in customising a major CRM deployment and developed a bunch of custom database queries to derive critical management information and user dashboards.
Qualified in Computer Studies, Electronic Engineering and Chemistry, I work in the support of significant scientific computer applications.  I have lectured in Computer Studies at a community college in the United Kingdom.