Basic SQL With SQL Server 2016
4.2 (28 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.
181 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.2 (28 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.
181 students enrolled
Last updated 5/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • 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
Description

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
04:03:48
+
Introduction
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
07:52

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
08:51

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"
06:30

Lesson Objectives:

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

Lesson Objectives:

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

Using "where" quiz
2 questions

Lesson Objectives:

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

Lesson Objectives:

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

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"
08:04

Lesson Objectives:

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

Lesson Objectives:

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

Lesson Objectives: 

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

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
06:20

Lesson Objectves:

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

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
08:41

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
05:58

Learning Objectives:

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

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
06:15

Lesson Objectives: Understand the different between varchar and nvarchar


Understanding varchar and nvarchar in more detail
04:07
+
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
05:28

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
15:14

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

Create a dynamic web page
07:14

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

Edit, Create and Delete records
11:04

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

Search and view restricted results
05:11

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
07:56

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

Create and run a stored procedure from a web page
11:40
+
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
01:56

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

Finding matching records using inner joins
09:53

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

Find matching records using left outer joins
06:52

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
07:48

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

Create an Asp.Net site and add validation
10:49
+
Normalization
1 Lecture 04:52

Lesson Objectives: Understand why normalization of tables produces benefits

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

Lesson Objectives:

  1. Learn about a couple resources that will help you further your studies
Next possible steps
01:07
About the Instructor
Tom O.
4.5 Average rating
1,542 Reviews
17,315 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.3 Average rating
50 Reviews
317 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.