An 18 Hour SQL_SQL Server 2014_Visual Studio 2017 Course Video

1. 13 - Build a Simple, Secure Data Entry System with Validation and Transactions/Write the C#.mp4111.11MB
2. 1 - Introduction - Get the Needed Software/Configure the Layout of Panels in the Management Studio and Visual Studio.mp416.09MB
3. 1 - Introduction - Get the Needed Software/Get Microsoft Visual Studio.mp416.78MB
4. 1 - Introduction - Get the Needed Software/Get SQL Server 2014 Express.mp413.39MB
5. 1 - Introduction - Get the Needed Software/Update VS with SQL Server Tools.mp43.72MB
6. 2 - Querying Basics/Add Multiple Parameters to an ASP.NET Page.mp466.65MB
7. 2 - Querying Basics/Aliasing Columns.mp441.13MB
8. 2 - Querying Basics/Aliasing Computed Columns.mp440.95MB
9. 2 - Querying Basics/Create a Table and Write a Simple Query and Display the Results.mp439.55MB
10. 2 - Querying Basics/Filtering with Where and Between.mp429.96MB
11. 2 - Querying Basics/Having Clause.mp424.73MB
12. 2 - Querying Basics/Make an ASP.NET Web Page with SQL Server.mp470MB
13. 2 - Querying Basics/Select Into.mp426.78MB
14. 2 - Querying Basics/Summarize Blocks of Records with Group By.mp436.28MB
15. 2 - Querying Basics/Use the Query Designer.mp418.98MB
16. 2 - Querying Basics/Write a Query with a Where and an Order By.mp430.88MB
17. 2 - Querying Basics/Write a Query with a Where Restriction.mp412.89MB
18. 3 - Table Manipulation/1st Normal Form.mp436.94MB
19. 3 - Table Manipulation/ASP.NET Page with Updating and Deleting.mp467.27MB
20. 3 - Table Manipulation/Second Normal Form.mp437.1MB
21. 3 - Table Manipulation/Table Creation and Data Insertion.mp427.13MB
22. 3 - Table Manipulation/Third Normal Form.mp432.21MB
23. 3 - Table Manipulation/Updating Records.mp420.62MB
24. 4 - Table Joins/Full Joins with the Query Editor.mp424.78MB
25. 4 - Table Joins/Inner Join.mp432.92MB
26. 4 - Table Joins/Inner Joins with Editor Window and Where Statements.mp424.9MB
27. 4 - Table Joins/Left Join.mp432.17MB
28. 4 - Table Joins/Left Joins with Editor and Where Statement.mp459.03MB
29. 4 - Table Joins/Right Join.mp434.82MB
30. 4 - Table Joins/Right Joins with Query Editor and Filtering Conditions.mp439.64MB
31. 5 - Build an ASP.NET Page with Multiple Tables and Controls/Connect Gridview to Tables with C#.mp464.48MB
32. 5 - Build an ASP.NET Page with Multiple Tables and Controls/Create a Query Editor with C#.mp480.23MB
33. 6 - Create an XML Powered ASP.NET Page/Create a Page with a Control That Connects to the XML Table.mp435.31MB
34. 6 - Create an XML Powered ASP.NET Page/Create a Table Suited For XML Output.mp436.4MB
35. 7 - Using SQL Server Functions and Operators/Aggregate Functions.mp447.9MB
36. 7 - Using SQL Server Functions and Operators/In Logical Operator.mp432.4MB
37. 7 - Using SQL Server Functions and Operators/Scalar Functions.mp445.18MB
38. 7 - Using SQL Server Functions and Operators/Summarizing Records with Over.mp467.51MB
39. 7 - Using SQL Server Functions and Operators/Where with Like.mp441.28MB
40. 8 - Subqueries/Subqueries in From.mp447.02MB
41. 8 - Subqueries/Subqueries in Select Clauses.mp425.47MB
42. 9 - Stored Procedures and Programming Constructs/Add IF_Else Blocks.mp445.59MB
43. 9 - Stored Procedures and Programming Constructs/Case and When Statements with Functions.mp459.43MB
44. 9 - Stored Procedures and Programming Constructs/Common Table Expressions.mp435.08MB
45. 9 - Stored Procedures and Programming Constructs/Comparing Values between Records with the Lag Function.mp460.43MB
46. 9 - Stored Procedures and Programming Constructs/CTE with Inner Join and Aggregating Functions and CSV Files.mp454.37MB
47. 9 - Stored Procedures and Programming Constructs/Nesting Functions and Pivoting Tables.mp435.79MB
48. 9 - Stored Procedures and Programming Constructs/Part 1 - Write a Parametrized Procedure.mp471.45MB
49. 9 - Stored Procedures and Programming Constructs/Part 2 - Asp.NET Page Powered by Parametrized Store Procedure.mp457.85MB
50. 9 - Stored Procedures and Programming Constructs/Stored Procedures with Output Parameters.mp431.23MB
51. 9 - Stored Procedures and Programming Constructs/Try_Catch Error Handling.mp432.52MB
52. 9 - Stored Procedures and Programming Constructs/Using the Lead Function with Grouped Data and CTE's.mp442.59MB
53. 9 - Stored Procedures and Programming Constructs/While Blocks, Variables.mp443.5MB
54. 9 - Stored Procedures and Programming Constructs/Write and Execute a Simple Stored Procedure.mp430.23MB
55. 10 - User Defined Functions/ASP.NET_SQL Server_LINQ.mp488.08MB
56. 10 - User Defined Functions/Scalar Valued Functions.mp450.37MB
57. 10 - User Defined Functions/Table valued Functions.mp454.67MB
58. 10 - User Defined Functions/Table Variables.mp441.46MB
59. 11 - Triggers and Views/Write a Trigger.mp450.67MB
60. 11 - Triggers and Views/Write a View.mp445.76MB
61. 12 - Transactions/Begin Transaction and Commit Transaction.mp451.07MB
62. 12 - Transactions/Save and Rollback Transactions.mp428.07MB
63. 13 - Build a Simple, Secure Data Entry System with Validation and Transactions/Add AJAX and a Check Box.mp482.85MB
64. 13 - Build a Simple, Secure Data Entry System with Validation and Transactions/Add JQuery, Basic Example.mp472.23MB
65. 13 - Build a Simple, Secure Data Entry System with Validation and Transactions/Improve Interface with CSS.mp456.3MB
66. 13 - Build a Simple, Secure Data Entry System with Validation and Transactions/Make a Simple Interface.mp464.07MB
67. 13 - Build a Simple, Secure Data Entry System with Validation and Transactions/Make the Table, and Write the Stored Procedure.mp463.31MB
68. 13 - Build a Simple, Secure Data Entry System with Validation and Transactions/Port to IIS.mp447.44MB
69. 13 - Build a Simple, Secure Data Entry System with Validation and Transactions/Refine the JQuery and Understand IIS Express.mp4109.06MB
70. 13 - Build a Simple, Secure Data Entry System with Validation and Transactions/Use jQuery To Make Interface Draggable, Droppable and Saveable.mp470.39MB
71. 14 - Administration/Adding Logins and Users.mp425.37MB
72. 14 - Administration/Backup Device and SQL Server Log.mp436.25MB
73. 14 - Administration/Backups, Restores, Excel.mp430.77MB
74. 14 - Administration/Database Roles with Users.mp430.18MB
75. 15 - Make a Dashboard Website/Add a sticky.mp454.58MB
76. 15 - Make a Dashboard Website/Add a summary table.mp466.53MB
77. 15 - Make a Dashboard Website/Add CSS and jQuery to make elements draggable, droppable and saveable.mp463.26MB
78. 15 - Make a Dashboard Website/Add foreign key constraint for deleting records.mp427MB
79. 15 - Make a Dashboard Website/Add sales table with nested while loops.mp475.81MB
80. 15 - Make a Dashboard Website/Add theme switching with jQuery.mp437.99MB
81. 15 - Make a Dashboard Website/Add trigger for adding sales records.mp431.16MB
82. 15 - Make a Dashboard Website/Create a site on IIS and an HTTP page.mp417.53MB
83. 15 - Make a Dashboard Website/Create a table in SQL Server and connect the page with a Detailsview.mp441.06MB
84. 15 - Make a Dashboard Website/Final Project Review.mp490.94MB
85. 15 - Make a Dashboard Website/Make element expandable and add AJAX.mp477.91MB
86. 15 - Make a Dashboard Website/Printing GridViews to printers, Google Drive, and the cloud.mp497.38MB
87. 15 - Make a Dashboard Website/Synchronize Gridview and Details View.mp478.29MB