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

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

by Tom O. | Released July 2018 | ISBN: 9781789530568

https://www.oreilly.com/library/view/an-18-hour/9781789530568/

Learn SQL, SQL Server, SSMS, ASP.NET, Visual Studio, C#, HTML and More!About This VideoLearn how to import data into SQL Server from other programs, how to bring tables into first, second and third normal form, how to work with XML in SQL Server and ASP.NET Controls.Build a web-based data entry system with C#/SQL, CSS and VS, understand how to use begin/end/go.In DetailFriends, 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. Show and hide more Publisher Resources Download Example Code

Chapter 1 : Introduction: Get the Needed Software
- Get SQL Server 2014 Express 00:05:14
- Get Microsoft Visual Studio 00:05:26
- Configure the Layout of Panels in the Management Studio and Visual Studio 00:03:50
- Update VS with SQL Server Tools 00:01:46
Chapter 2 : Querying Basics
- Create a Table and Write a Simple Query and Display the Results 00:13:58
- Write a Query with a Where Restriction 00:04:25
- Write a Query with a Where and an Order By 00:09:08
- Filtering with Where and Between 00:09:05
- Aliasing Columns 00:11:03
- Aliasing Computed Columns 00:10:38
- Use the Query Designer 00:06:40
- Make an ASP.NET Web Page with SQL Server 00:19:23
- Summarize Blocks of Records with Group By 00:11:30
- Having Clause 00:07:10
- Select Into 00:08:03
- Add Multiple Parameters to an ASP.NET Page 00:19:26
Chapter 3 : Table Manipulation
- Table Creation and Data Insertion 00:08:18
- Updating Records 00:06:19
- ASP.NET Page with Updating and Deleting 00:16:49
- 1st Normal Form 00:12:12
- Second Normal Form 00:09:57
- Third Normal Form 00:08:25
Chapter 4 : Table Joins
- Inner Join 00:11:49
- Inner Joins with Editor Window and Where Statements 00:08:12
- Left Join 00:10:45
- Left Joins with Editor and Where Statement 00:15:24
- Right Join 00:10:14
- Right Joins with Query Editor and Filtering Conditions 00:10:19
- Full Joins with the Query Editor 00:06:42
Chapter 5 : Build an ASP.NET Page with Multiple Tables and Controls
- Connect Gridview to Tables with C# 00:19:38
- Create a Query Editor with C# 00:25:05
Chapter 6 : Create an XML Powered ASP.NET Page
- Create a Table Suited For XML Output 00:12:41
- Create a Page with a Control That Connects to the XML Table 00:11:00
Chapter 7 : Using SQL Server Functions and Operators
- In Logical Operator 00:08:40
- Where with Like 00:10:45
- Scalar Functions 00:12:20
- Aggregate Functions 00:12:04
- Summarizing Records with Over 00:16:58
Chapter 8 : Subqueries
- Subqueries in Select Clauses 00:06:30
- Subqueries in From 00:13:04
Chapter 9 : Stored Procedures and Programming Constructs
- Write and Execute a Simple Stored Procedure 00:08:22
- Part 1: Write a Parametrized Procedure 00:17:37
- Part 2: Asp.NET Page Powered by Parametrized Store Procedure 00:18:05
- Add IF/Else Blocks 00:13:11
- Case and When Statements with Functions 00:16:50
- While Blocks, Variables 00:13:32
- Stored Procedures with Output Parameters 00:09:24
- Try/Catch Error Handling 00:10:24
- Comparing Values between Records with the Lag Function 00:15:39
- Common Table Expressions 00:09:11
- Using the Lead Function with Grouped Data and CTE's 00:11:35
- CTE with Inner Join and Aggregating Functions and CSV Files 00:16:00
- Nesting Functions and Pivoting Tables 00:11:04
Chapter 10 : User Defined Functions
- Scalar Valued Functions 00:13:00
- Table valued Functions 00:15:06
- Table Variables 00:12:26
- ASP.NET/SQL Server/LINQ 00:22:57
Chapter 11 : Triggers and Views
- Write a View 00:12:38
- Write a Trigger 00:13:19
Chapter 12 : Transactions
- Begin Transaction and Commit Transaction 00:14:45
- Save and Rollback Transactions 00:08:30
Chapter 13 : Build a Simple, Secure Data Entry System with Validation and Transactions
- Make the Table, and Write the Stored Procedure 00:19:41
- Make a Simple Interface 00:19:57
- Write the C# 00:30:15
- Improve Interface with CSS 00:14:24
- Add JQuery, Basic Example 00:14:24
- Refine the JQuery and Understand IIS Express 00:20:57
- Add AJAX and a Check Box 00:23:56
- Port to IIS 00:15:48
- Use jQuery To Make Interface Draggable, Droppable and Saveable 00:19:14
Chapter 14 : Administration
- Adding Logins and Users 00:08:18
- Database Roles with Users 00:09:58
- Backups, Restores, Excel 00:10:11
- Backup Device and SQL Server Log 00:10:43
Chapter 15 : Make a Dashboard Website
- Create a site on IIS and an HTTP page 00:06:40
- Create a table in SQL Server and connect the page with a Detailsview 00:13:33
- Add CSS and jQuery to make elements draggable, droppable and saveable 00:15:52
- Make element expandable and add AJAX 00:18:35
- Add sales table with nested while loops 00:21:06
- Add trigger for adding sales records 00:09:53
- Add foreign key constraint for deleting records 00:07:53
- Synchronize Gridview and Details View 00:16:34
- Add a summary table 00:18:01
- Add theme switching with jQuery 00:10:32
- Add a sticky 00:16:03
- Printing GridViews to printers, Google Drive, and the cloud 00:23:24
- Final Project Review 00:21:06