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

A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course, available at $94.99, has an average rating of 4.45, with 88 lectures, 42 quizzes, based on 1497 reviews, and has 12349 subscribers.

You will learn about 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 This course is ideal for individuals who are This course is for those who appreciate fine levels of detail. or This course is intended for SQL Server novices or This course is intended for ASP.NET novices or This course is intended for Visual Studio novices or This course is intended for those who are intermediate or above in C# or This course is NOT for those who want to be entertained. or This course is NOT for those who want 5 minutes videos. It is particularly useful for This course is for those who appreciate fine levels of detail. or This course is intended for SQL Server novices or This course is intended for ASP.NET novices or This course is intended for Visual Studio novices or This course is intended for those who are intermediate or above in C# or This course is NOT for those who want to be entertained. or This course is NOT for those who want 5 minutes videos.

Enroll now: A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course

Summary

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

Price: $94.99

Average Rating: 4.45

Number of Lectures: 88

Number of Quizzes: 42

Number of Published Lectures: 87

Number of Published Quizzes: 42

Number of Curriculum Items: 130

Number of Published Curriculum Objects: 129

Original Price: $27.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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.

Target Audiences

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.

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

Course Curriculum

Chapter 1: Introduction: Get the Needed Software

Lecture 1: Get SQL Server 2014 Express

Lecture 2: Get Microsoft Visual Studio

Lecture 3: Configure the Layout of Panels in the Management Studio and Visual Studio

Chapter 2: Querying Basics

Lecture 1: Create a Table and Write a Simple Query and Display the Results

Lecture 2: Write a Query with a Where Restriction

Lecture 3: Write a Query with a Where and an Order By

Lecture 4: Filtering with Where and Between

Lecture 5: Aliasing Columns

Lecture 6: Aliasing Computed Columns

Lecture 7: Use The Query Designer

Lecture 8: Make an ASP.NET Web Page with SQL Server

Lecture 9: Summarize Blocks of Records with Group By

Lecture 10: Having Clause

Lecture 11: Select Into

Lecture 12: Add Multiple Parameters to an ASP.NET Page

Chapter 3: Table Manipulation

Lecture 1: Table Creation and Data Insertion

Lecture 2: Updating Records

Lecture 3: ASP.NET Page with Updating and Deleting

Lecture 4: 1st Normal Form

Lecture 5: Second Normal Form

Lecture 6: Third Normal Form

Chapter 4: Table Joins

Lecture 1: Inner Join

Lecture 2: Inner Joins with Editor Window and Where Statements

Lecture 3: Left Join

Lecture 4: Left Joins with Editor and Where Statement

Lecture 5: Right Join

Lecture 6: Right Joins with Query Editor and Filtering Conditions

Lecture 7: Full Joins with The Query Editor

Chapter 5: Build an ASP.NET Page With Multiple Tables and Controls

Lecture 1: Connect Gridview to Tables with C#

Lecture 2: Create a Query Editor with C#

Chapter 6: Create an XML Powered ASP.NET Page

Lecture 1: Create a Table Suited For XML Output

Lecture 2: Create a Page With a Control That Connects to the XML Table

Chapter 7: Using SQL Server Functions and Operators

Lecture 1: In Logical Operator

Lecture 2: Where with Like

Lecture 3: Scalar Functions

Lecture 4: Aggregate Functions

Lecture 5: Summarzing Records with Over

Chapter 8: Subqueries

Lecture 1: Subqueries in Select Clauses

Lecture 2: Subqueries in From

Chapter 9: Stored Procedures and Programming Constructs

Lecture 1: Write and Execute a Simple Stored Procedure

Lecture 2: Part 1: Write a Parametrized Procedure

Lecture 3: Part 2: Asp.NET Page Powered by Parametrized Store Procedure

Lecture 4: Add IF/Else Blocks

Lecture 5: Case and When Statements with Functions

Lecture 6: While Blocks, Variables

Lecture 7: Stored Procedures with Output Parameters

Lecture 8: Try/Catch Error Handling

Lecture 9: Comparing Values Between Records with the Lag Function

Lecture 10: Common Table Expressions

Lecture 11: Using the Lead Function with Grouped Data and CTE's

Lecture 12: CTE with Inner Join and Aggregating Functions and CSV Files

Lecture 13: Nesting Functions and Pivoting Tables

Chapter 10: User Defined Functions

Lecture 1: Scalar Valued Functions

Lecture 2: Table valued Functions

Instructors

T O
Spreader of Knowledge

Rating Distribution

1 stars: 17 votes
2 stars: 30 votes
3 stars: 193 votes
4 stars: 532 votes
5 stars: 725 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu