Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course

Name: A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course
Rating: 4.2 (1544 reviews)

Learn SQL, SQL Server, SSMS, ASP.NET, Visual Studio, C#, HTML and More!

Created byT O

Last updated 8/2022

English

What you'll learn

Learn SQL
Learn SQL Server
Learn the Basics of Microsoft Visual Studio 2017 Community
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 (jQuery is used on the bottom of the course)
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
Understand how to use begin/end/go and ;
Learn how to build a web interface layout that can be dragged, dropped and saved between page loads

Course content

15 sections • 87 lectures • 18h 49m total length

Get SQL Server 2014 Express5:14
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
Get Microsoft Visual Studio5:26
Configure the Layout of Panels in the Management Studio and Visual Studio3:50
Learning Result

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

Create a Table and Write a Simple Query and Display the Results13:58
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
Simple Queries
Write a Query with a Where Restriction4:25
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
Write a Query with a Where and an Order By9: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
Filtering with Where and Between9:05
Learning Results

1) Understand how to use the between clause
Using Between
Aliasing Columns11:03
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
Aliasing Computed Columns10:38
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
Use The Query Designer6:40
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
Make an ASP.NET Web Page with SQL Server19:24
Learning Results

1) Understand how to incorporate basic SQL queries into dynamic web pages
ASP.NET Pages
Summarize Blocks of Records with Group By11:30
Learning Results

1) Understand how to group records

2) Understand how to combine grouping, filtering with where, and ordering
Group By
Having Clause7:10
Learning Results

1) Understand how to filter grouped results
Having Clause
Select Into8:03
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
Add Multiple Parameters to an ASP.NET Page19:26
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

Table Creation and Data Insertion8:18
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
Updating Records6:19
Learning Results

1) Understand how to use the update statement

2) Understand how to use the delete statement
Update Records
ASP.NET Page with Updating and Deleting16:49
Learning Results

1) Understand how to create a realistic application of updates, inserts, deletes,
Updating, Deleting and Inserting Through Web Pages
1st Normal Form12:12
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
Second Normal Form9:57
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
Third Normal Form8:25
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

Inner Join11:49
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
Inner Joins with Editor Window and Where Statements8:12
Learning Results

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

2) Understand how to subset the data
Inner Joins
Left Join10:45
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
Left Joins with Editor and Where Statement15:24
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
Right Join10:14
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
Right Joins with Query Editor and Filtering Conditions10:19
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
Full Joins with The Query Editor6:42
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

Connect Gridview to Tables with C#19:38
Learning Result

1) Generate four new tables using the query designer

2) Save the tables inside the database
Create a Query Editor with C#25:05
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?

Create a Table Suited For XML Output12:41
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
Create a Page With a Control That Connects to the XML Table11:00
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

In Logical Operator8:40
Learning Result

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

2) Understand that this operator returns either true or false
Where with Like10:45
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
Scalar Functions12:20
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
Aggregate Functions12:04
Learning Results

1) Understand how to use aggregate functions

2) Understand that these work with grouped data

3) Understand how to next function calls
Aggregating Functions
Summarzing Records with Over16:58
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

Subqueries in Select Clauses6:30
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
Subqueries in From13:04
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

Write and Execute a Simple Stored Procedure8:22
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
Part 1: Write a Parametrized Procedure17:37
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
Part 2: Asp.NET Page Powered by Parametrized Store Procedure18:05
Run a web page powered by a parametrized stored procedure.
Procedures with Parameters
Add IF/Else Blocks13:11
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
Case and When Statements with Functions16:50
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
While Blocks, Variables13:32
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
Stored Procedures with Output Parameters9:24
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
Try/Catch Error Handling10:24
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
Comparing Values Between Records with the Lag Function15:39
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.
Common Table Expressions9:11
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
Using the Lead Function with Grouped Data and CTE's11:35
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
CTE with Inner Join and Aggregating Functions and CSV Files16:00
Learning Results

1) Understand how to combine CTE's, inner joins, and aggregating functions with while loops and table creation
Nesting Functions and Pivoting Tables11:04
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

Scalar Valued Functions13:00
Learning Results

1) Understand how to create a user defined function

2) Understand how to call a user defined function

3) Understand how to format the results of a user defined function
User Defined Scalar Functions
Table valued Functions15:06
Learning Results

1) Understand how to create a function that returns a whole table

2) Understand how to insert into a table that is going to be returned

3) Understand how to call a tabled valued function
Table valued functions
Table Variables12:26
Learning Results

1) Understand how to declare a table variable

2) Understand how to set the values of a table variable

3) Understand how to use the char function to convert numbers to characters

4) Understand how to copy the results of a table variable
Table Variables
ASP.NET/SQL Server/LINQ22:57
Understand how to use SQL Server, ASP.NET, C# and Linq together.

Requirements

Ability to download and install SQL Server 2014 (100% Free)
Ability to download and install Visual Studio 2017
The SQL begins at the beginner level and progresses through more advanced lessons.
The C# begins at the intermediate level.
If you use previous versions of SQL Server, like 2008 or 2012, you will have problems with the files used. It's best to use 2014 and up.

Description

Who Should Join:

1. Friends, please take the time to review the curriculum carefully before buying so you can see exactly whether this is the right course for you. Please kindly refrain from enrolling until this very important step is complete.

2. Please watch the free preview videos so you can see whether the presentation style works for you. Please remember I am just one person, and I make my videos often after I have been working for many hours already.

3. You are interested in real coding.

4. You enjoy detailed explanations at an introductory level. Please answer the questions in the quizzes based on the course content, and not external knowledge you might already have. This is very important in order for the quizzes to work correctly.

Very important note: this course is a general overview of many topics, so not every topic can be explored in great depth and at every level of subtlety.

5. You can take videos that are 13 minutes on average.

6. You enjoy seeing how different technologies interact.

7. You understand that most of the SQL is done in the Microsoft Management Studio, and not Visual Studio.

9. You're NOT looking for fancy graphics, a talking head, or entertainment.

9. You're looking for practical, carefully explained examples, where the code is written line by line.

10. I made all the code in a fairly big font to be sure it's easy to see.

11. If you use SQL Server versions below 2014, some of the code will not work. You must use versions 2014 and above.

12. This course uses ASP.NET and C# and not MVC.

13. You understand this is a beginners course, and therefore everything is developed over a period of 18 hours, but by the end, assuming you complete the course, you will have many powerful, practical skills.

14. I don't have an intense amount of energy in my videos because they are made after I've been at work for many hours already.

Major benefits of the course:

1) Learn query writing by using the Microsoft Management Studio

2) Learn how to create database connected web pages using SQL and ASP.NET controls

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

5) Get 210 quiz questions so you can feel confident you're making true progress.

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

7) Get exposure to modern SQL language features like Lag/Lead

8) Build a dashboard system with SQL Server, ASP Web Forms, C# and JQuery (bottom of course)

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.

jQuery and related marks are trademarks of the JS Foundation, and this course is not affiliated with or endorsed by the JS Foundation.

Parts of promo background licensed from Presenter Media . com

Who this course is for:

This course is for those who appreciate fine levels of detail.
This course is intended for SQL Server novices
This course is intended for ASP.NET novices
This course is intended for Visual Studio novices
This course is intended for those who are intermediate or above in C#
This course is NOT for those who want to be entertained.
This course is NOT for those who want 5 minutes videos.

A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course

What you'll learn

Explore related topics

Course content

Introduction: Get the Needed Software3 lectures • 15min

Querying Basics12 lectures • 2hr 11min

Table Manipulation6 lectures • 1hr 2min

Table Joins7 lectures • 1hr 13min

Build an ASP.NET Page With Multiple Tables and Controls2 lectures • 45min

Create an XML Powered ASP.NET Page2 lectures • 24min

Using SQL Server Functions and Operators5 lectures • 1hr 1min

Subqueries2 lectures • 20min

Stored Procedures and Programming Constructs13 lectures • 2hr 51min

User Defined Functions4 lectures • 1hr 3min

Requirements

Description

Who this course is for: