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

An 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course
An 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course
English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 18h 51m | 4.75 GB

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

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 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. You are interested in real coding. You enjoy detailed explanations. You can take videos that are 13 minutes on average. You enjoy seeing how different technologies interact. You understand that most of the SQL is done in the Microsoft Management Studio, and not Visual Studio. You’re not looking for fancy graphics, a talking head, or entertainment. You’re looking for practical, carefully explained examples, where the code is written line by line. If you use SQL Server versions below 2014, some of the code will not work. You must use versions 2014 and above. This course uses ASP.NET, and not MVC.

Style and Approach
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.

What You Will Learn

  • Learn SQL and SQL Server.
  • Learn the basics of Microsoft Visual Studio 2017 Community, Microsoft ASP.NET with SQL Server, enough C# to connect to databases.
  • Learn enough JQuery to make database controls interactive, the fundamentals of SQL Server administration.
  • Learn how to work with built-in functions, how to write joins, how to make web pages for collecting and storing information, how to format data in web pages and tables, how to represent queries with pictures for easier understanding.
  • Learn how to use program flow control features like if/else and more, how to write stored procedures, how to write user-defined functions, how to write views and triggers, how to use the SQL Server debugger.
  • Learn how to create, save, commit and rollback transactions.
  • Learn how to create users, database roles, logins, and work with securables, how to backup, restore, attach and detach databases.
  • Learn how to use and save Table variables, how to create and use common table expressions, how to work with string functions like char, and substring, 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, how to build a dashboard with C#/CSS/HTML/SQL and JQuery, how to perform data validation, how to print to printers, PDF’s, Google Drive, and the Cloud.
  • Learn how to build a web interface layout that can be dragged, dropped and saved between page loads.
Table of Contents

01 Get SQL Server 2014 Express
02 Get Microsoft Visual Studio
03 Configure the Layout of Panels in the Management Studio and Visual Studio
04 Update VS with SQL Server Tools
05 Create a Table and Write a Simple Query and Display the Results
06 Write a Query with a Where Restriction
07 Write a Query with a Where and an Order By
08 Filtering with Where and Between
09 Aliasing Columns
10 Aliasing Computed Columns
11 Use the Query Designer
12 Make an ASP.NET Web Page with SQL Server
13 Summarize Blocks of Records with Group By
14 Having Clause
15 Select Into
16 Add Multiple Parameters to an ASP.NET Page
17 Table Creation and Data Insertion
18 Updating Records
19 ASP.NET Page with Updating and Deleting
20 1st Normal Form
21 Second Normal Form
22 Third Normal Form
23 Inner Join
24 Inner Joins with Editor Window and Where Statements
25 Left Join
26 Left Joins with Editor and Where Statement
27 Right Join
28 Right Joins with Query Editor and Filtering Conditions
29 Full Joins with the Query Editor
30 Connect Gridview to Tables with C#
31 Create a Query Editor with C#
32 Create a Table Suited For XML Output
33 Create a Page with a Control That Connects to the XML Table
34 In Logical Operator
35 Where with Like
36 Scalar Functions
37 Aggregate Functions
38 Summarizing Records with Over
39 Subqueries in Select Clauses
40 Subqueries in From
41 Write and Execute a Simple Stored Procedure
42 Part 1 – Write a Parametrized Procedure
43 Part 2 – Asp.NET Page Powered by Parametrized Store Procedure
44 Add IF_Else Blocks
45 Case and When Statements with Functions
46 While Blocks, Variables
47 Stored Procedures with Output Parameters
48 Try_Catch Error Handling
49 Comparing Values between Records with the Lag Function
50 Common Table Expressions
51 Using the Lead Function with Grouped Data and CTE’s
52 CTE with Inner Join and Aggregating Functions and CSV Files
53 Nesting Functions and Pivoting Tables
54 Scalar Valued Functions
55 Table valued Functions
56 Table Variables
58 Write a View
59 Write a Trigger
60 Begin Transaction and Commit Transaction
61 Save and Rollback Transactions
62 Make the Table, and Write the Stored Procedure
63 Make a Simple Interface
64 Write the C#
65 Improve Interface with CSS
66 Add JQuery, Basic Example
67 Refine the JQuery and Understand IIS Express
68 Add AJAX and a Check Box
69 Port to IIS
70 Use jQuery To Make Interface Draggable, Droppable and Saveable
71 Adding Logins and Users
72 Database Roles with Users
73 Backups, Restores, Excel
74 Backup Device and SQL Server Log
75 Create a site on IIS and an HTTP page
76 Create a table in SQL Server and connect the page with a Detailsview
77 Add CSS and jQuery to make elements draggable, droppable and saveable
78 Make element expandable and add AJAX
79 Add sales table with nested while loops
80 Add trigger for adding sales records
81 Add foreign key constraint for deleting records
82 Synchronize Gridview and Details View
83 Add a summary table
84 Add theme switching with jQuery
85 Add a sticky
86 Printing GridViews to printers, Google Drive, and the cloud
87 Final Project Review