A 13 Hour SQL Server 2014 /ASP.NET/CSS/C#/JQuery Course

Push Yourself And Your Skills Hard To Get To The Next Level!
4.3 (174 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.
3,812 students enrolled
$19
$35
46% off
Take This Course
  • Lectures 86
  • Length 14 hours
  • Skill Level Intermediate 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 10/2014 English

Course Description

Why learn SQL, SQL Server, and Visual Studio? To build applications today, a programmer must know how to combine the power of various technologies together to produce software that is powerful and web based. The focus of this course is SQL through Microsoft SQL Server 2014, but along the way, you also see how to use Microsoft Visual Studio 2013 for Web , and you get to build a real dashboard system powered by SQL, C#, AJAX, CSS, HTML and JQuery. This course uses Web Forms rather than MVC. Any of these skills alone are valuable, but knowing how to combine these skills makes you immediately standout in the job market. Enroll today, and learn how to give yourself a great competitive advantage in the job world.

1) Learn query writing by using the Microsoft Management Studio

2) Learn query writing by using the Microsoft Visual Studio Query Editor

3) Learn how to create database connected web pages using SQL and XML Data Sources

4) Get color PDF's for many of the lessons for easy reference

5) Get PDF's that depict difficult concepts in pictures for improved understanding

6) All in all, there are about 100 PDF's to accompany the video lectures

7) Get 210 questions so you can feel confident you're making true progress

8) Learn the basics of database connecting code using Microsoft's premier programming language: C#

9) Get exposure to modern language features like Lag/Lead

10) Build a dashboard system with SQL Server, ASP Web Forms, C# and JQuery

Given the number of videos, PDF's, variety of teaching methods, quizzes, and a project that is designed to give you a feeling of what to expect in the real world, we're confident this is by far the best deal on this site. Join today, and learn truly valuable skills.

What are the requirements?

  • Ability to download and install SQL Server 2014 (100% Free)
  • Ability to download and install Visual Studio 2013 for Web (100% Free)

What am I going to get from this course?

  • Learn SQL
  • Learn SQL Server
  • Learn the Basics of Microsoft Visual Studio 2013 for Web
  • Learn the Basics of Microsoft ASP.NET with SQL Server
  • Learn Enough C# To Connect to Databases
  • Learn Enough JQuery to Make Database Controls Interctive'
  • Learn the Fundamentals of SQL Server Administration
  • Learn how to work with built in functions
  • Learn how to write joins
  • Learn how to make web pages for collecting and storing information
  • Learn how to format data in web pages and tables
  • Learn how to represent queries with pictures for easier understanding
  • Learn how to use program flow control features like if/else and more
  • Learn how to write stored procedures
  • Learn how to write user defined functions
  • Learn how to write views and triggers
  • Learn how to use the SQL Server debugger
  • Learn how to create, save, commit and roll back transactions
  • Learn how to create users, database roles, logins, and work with securables
  • Learn how to backup, restore, attach and detach databases
  • Learn how to import data into SQL Server from other programs
  • Learn how to bring tables into first, second and third normal form
  • Learn how to work with XML in SQL Server and ASP.NET Controls
  • Learn how to use and save Table variables
  • Learn how to create and use Common Table Expressions
  • Learn how to work with string functions like char, and substring
  • Learn how to use the Lag/Lead Functions and the Over Clause
  • Learn how to work with date functions like Datename, Datepart, getDate and more
  • Learn how to build dynamic theme switching with JQuery
  • Learn how to build dashboard with C#/CSS/HTML/SQL and JQuery
  • Learn how to perform data validation
  • Learn how to print to printers, PDF's, Google Drive, and the Cloud
  • Build a web based data entry system with C#/SQL, CSS and VS

What is the target audience?

  • This course is intended for SQL Server novices
  • This course is intended for ASP.NET novices
  • This course is intended for Visual Studio novices

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: Introduction: Get the Needed Software
07:53

Note: Please watch the videos in HD in full screen mode. All the videos are made in 720p HD resolution.

Learning Results

1) Understand how to find, download and install SQL Server Express 2014

2) Understand how to find, download and install SQL Server Management Studio

3) Install SQL Server using "Windows Authentication"

4) Install the correct version of SQL Server by looking at system information in a command prompt window

SQL Server Download
6 questions
02:59

Learning Results

1) Understand how to find and download Microsoft Visual Studio 2013 for Web Express

2) Understand that Microsoft Visual Studio 2013 for Web is a powerful programming for developing applications

3) Get the SQL Data Tools for Visual Studio
05:30

Learning Result

1) Understand how to control the position and layout of the panels inside the management studio and Visual Studio

01:46

Learning Results

1) Understand how to update Visual Studio

Section 2: Querying Basics
11:13

Learning Results

1) Understand how to create a table

2) Understand how to select records from a table

3) Understand that a database is a complex construct consisting of multiple objects

8 questions

Check Your Understanding of This Lecture

06:35

Learning Results

1) Understand how to write a query

2) Understand how to restrict the columns chosen

3) Understand how to restrict the rows chosen

Adding a Simple Where Restriction
3 questions
07:08

Learning Results

1) Understand how to use the order by clause

2) Understand how to select a row in which two cells match a given condition

Order By Clauses
4 questions
07:51

Learning Results

1) Understand how to use the between clause

2) Understand how to use the not between clause

Using Between and Not Between
2 questions
05:15

Learning Results

1) Understand how to write a query with column aliasing

2) Understand how to order by multiple columns

If there are issues with ordering by multiple columns, the link below gives additional detail.

http://stackoverflow.com/questions/2051162/sql-multiple-column-ordering

Aliasing Columns
3 questions
07:58

Learning Results

1) Understand how to add computed columns

2) Understand how to alias computed columns

3) Understand how to use computed columns in various statement types

Computed Values
4 questions
06:09

Learning Results

1) Understand how to use the query designer to build queries fast

2) Understand how to modify queries using the designer

3) Understand that the designer has its own way of formatting queries

Query Designer
3 questions
15:15

Learning Results

1) Understand how to incorporate basic SQL queries into dynamic web pages

ASP.NET Pages
6 questions
08:54

Learning Results

1) Understand how to group records

2) Understand how to combine grouping, filtering with where, and ordering

Group By
4 questions
07:48

Learning Results

1) Understand how to filter grouped results

Having Statement
4 questions
09:16

Learning Results

1) Understand how to copy one table into another

2) Understand how to copy existing columns

3) Understand how to copy computed columns into another table

Select Into
7 questions
18:17

Learning Results

1) Understand how to add and use multiple parameters

2) Understand how to make, design and modify databases from within Visual Studio

Multiple Parameters
5 questions
Section 3: Table Manipulation
07:49

Learning Results

1) Understand how to create a table manually

2) Understand how to insert data into a table

3) Understand how the system formats some types of data automatically

Table creation and Data Insertion
6 questions
05:17

Learning Results

1) Understand how to use the update statement

2) Understand how to use the delete statement

Update and Delete
2 questions
20:49

Learning Results

1) Understand how to create a realistic application of updates, inserts, deletes,

2) Understand how to configure the details view control

Question: Can you draw a schematic that clearly illustrates how a details view, the queries, and the database function together to produce a database connected page?

Updating, Deleting and Inserting Through Web Pages
4 questions
12:20

Learning Results

1) Understand how to bring a table into 1st normal form

2) Understand how to remove duplicates

3) Understand how to make a composite key

4) Understand how to make an index and how the index helps in speeding up access to data

5) Understand what happens when you try to make a key using information that repeats across records

First Normal Form
4 questions
09:44

Learning Results

1) Understand how to bring a table from 1st normal form to second normal form

2) Understand that in 2nd normal form, the columns must be such that each nonkey field depends on all the components of the key

Second Normal Form
3 questions
06:38

Learning Results

1) Understand how to produce the third normal form

2) Understand that in this form, each nonkey field must depend on the key, the whole, and nothing but the key

Section 4: Table Joins
09:13

Learning Result

1) Understand inner joins as the intersections of tables

2) Understand how to visualize the concept of an inner join

3) Understand how to implement an inner join in code

05:50

Learning Results

1) Understand how to form an inner join using the editor window

2) Understand how to subset the data

Inner Joins
5 questions
08:27

Learning Results

1) Understand the concept of a left join

2) Understand how to implement a left join in code

3) Understand the execution plan and actual behavior of a left join

5) Understand how the nonmatching records from the table on the right are dropped.

6) Understand how records from the left are null extended

04:16

Learning Results

1) Understand how to write a left join with the editor window

2) Understand how to filter the results of a left join with a where

Left Joins
6 questions
08:21

Learning Results

1) Understand the concept of a right join

2) Understand how to implement a right join in code

3) Understand how nulls are added during this process

4) Understand how nonmatching records from the table on the left are dropped

06:15

Learning Results

1) Understand how to code a right join with the query editor

2) Understand how to filter data using a where statement

Right Joins
3 questions
08:02

Learning Result

1) Understand how to construct a full outer join

2) Understand how to add where statements

3) Understand the full join graphically

Full Joins
4 questions
Section 5: Build an ASP.NET Page With Multiple Tables and Controls
05:57

Learning Result

1) Generate four new tables using the query designer

2) Save the tables inside the database

19:40

Learning Results

1) Create a website

2) Connect the databases to the grid views

3) Connect a database to a gridview programmatically

4) Display all the results

Question: After watching this video, can you draw a schematic of the process illustrated?

Multiple Tables
3 questions
Section 6: Create an XML Powered ASP.NET Page
11:43

Learning Results

1) Understand how to build a table for XML usage

2) Understand how the columns from a table designed for XML map to the names of elements

2) Understand how the columns from a table designed for XML map to the attributes of an element

07:50

Learning Results

1) Understand how to save the XML output

2) Understand how to configure a web page to use an XML file as a source for controls

3) Understand that ASP.NET controls are sent to a browser as HTML

XML Tables
5 questions
Section 7: Using SQL Server Functions and Operators
04:34

Learning Result

1) Understand how to use the 'IN' logical operator

2) Understand that this operator returns either true or false

09:34

Learning Result

1) Understand how to use the Like operator

2) Understand how to use the and operator in more detail

3) Understand how to use the getdate() function

Like, And and In
5 questions
11:35

Learning Results

1) Understand the concept of a function

2) Understand how functions operate

3) Understand how to nest functions

4) Understand how to apply functions to do something practical

Scalar Functions
7 questions
09:48

Learning Results

1) Understand how to use aggregate functions

2) Understand that these work with grouped data

3) Understand how to next function calls

Aggregate Functions
4 questions
07:38

Learning Result

1) Understand how to call functions on partitioned data using the over statement

2) Understand how to embed over statements in function calls

Question: Can you draw a picture to illustrate the functionoity of an over statement?

Student Observation: Paul Staley observed that you can also just write "order by 'Total'" at end

Over Statement
2 questions
Section 8: Subqueries
04:41

Learning Result

1) Understand how to write a subquery as part of a select statement

2) Understand how to apply a function inside a subquery

Subqueries in Selects
3 questions
06:22

Learning Results

1) Understand how to place a subquery inside a from

2) Under the process of the query visually

3) Understand how to use aggregate functions inside subqueries

Section 9: Stored Procedures and Programming Constructs
08:15

Learning Results

1) Understand how to create a stored procedure

2) Understand how to call a stored procedure

3) Understand how to alter a stored procedure

Simple Stored Procedures
4 questions
07:46

Learning Results

1) Understand how to add parameters to a stored procedure header

2) Understand how use parameters inside the body of a query

3) Understand how to call a stored procedure with parameters

Procedures with Parameters
4 questions
10:07

Learning Result

1) Understand how to construct an if/else block

2) Understand the logic of an if/else blocks

3) Understand how to express logically equivalent ideas in different ways

4) Understand how to use the debugger to trace the execution of a query

Question: Can you draw a schematic to represent the logic of an if/else block?

If/Else Blocks
5 questions
10:08

Learning Result

1) Understand how to incorporate case/when into a stored procedure

2) Understand how to incorporate function calls into case/when

3) Understand how to use the floor function

Case and When
3 questions
10:29

Learning Result

1) Understand how to declare and use variables

2) Understand how to cast from one data type to another

3) Understand how to incorporate if/else blocks into while blocks

Note: Please put the variable increment line after the if/else block

While, Variables, Casting
6 questions
07:16

Learning Results

1) Understand how to fill a table

2) Understand how to return values from a stored procedures

3) Understand how to use values returned from a stored procedure

09:29

Learning Results

1) Understand how to construct a try/catch construct

2) understand how the try/catch behaves

3) Understand how to decrement variables

4) Understand that try/catch is a general construct that exists in most modern programming languages

5) Understand how to create and delete temporary tables

Try/Catch
4 questions
06:15

Learning Results

1) Understand how to connect a web page to a stored procedure

12:31

Learning Results

1) Understand how to create and use a temporary named resultset

2) Understand how to increment a date by adding a counter variable to getdate()

3) Understand how to extract the month from a date

4) Understand how to formata name field by using substring and upper and lower functions

10:23

Learning Results

1) Understand how to use the lag function to compare values between records

2) This function works in SQL Server 2012 and up.

12:06

Learning Results

1) Understand how to use the Lead function with data from a CTE

2) This function works in SQL Server 2012 and up

Lead and Lag Functions
5 questions
15:17

Learning Results

1) Understand how to combine CTE's, inner joins, and aggregating functions with while loops and table creation

12:08

Learning Results

1) understand how to nest functions correctly and understand the results

2) Understand how to pivot tables to get a different view of the same data

Nesting Functions and Pivoting Tables
4 questions
Section 10: User Defined Functions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Tom Owsiak, 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


Instructor Biography

Jess Nault, Coauthor

Related experience:

12 years supporting top level management with Excel, VBA, MS Access, SQL, Crystal Reports, and contract administration.

2 years IT support.

1 year Computer Lab management, including classes on HTML.

Education:

BA in Business Administration from the University of Washington.

Associates Arts & Science

MS SQL Server 2008 DBA

Business Intelligence Developer training (MS SQL 2008)

VBA for Excel & Access

Chinese (Mandarin) Level III

TESOL

Ready to start learning?
Take This Course