An 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course [Video]
-
Free ChapterIntroduction: Get the Needed Software
-
Querying Basics
- Create a Table and Write a Simple Query and Display the Results
- Write a Query with a Where Restriction
- Write a Query with a Where and an Order By
- Filtering with Where and Between
- Aliasing Columns
- Aliasing Computed Columns
- Use the Query Designer
- Make an ASP.NET Web Page with SQL Server
- Summarize Blocks of Records with Group By
- Having Clause
- Select Into
- Add Multiple Parameters to an ASP.NET Page
-
Table Manipulation
-
Table Joins
-
Build an ASP.NET Page with Multiple Tables and Controls
-
Create an XML Powered ASP.NET Page
-
Using SQL Server Functions and Operators
-
Subqueries
-
Stored Procedures and Programming Constructs
- Write and Execute a Simple Stored Procedure
- Part 1: Write a Parametrized Procedure
- Part 2: Asp.NET Page Powered by Parametrized Store Procedure
- Add IF/Else Blocks
- Case and When Statements with Functions
- While Blocks, Variables
- Stored Procedures with Output Parameters
- Try/Catch Error Handling
- Comparing Values between Records with the Lag Function
- Common Table Expressions
- Using the Lead Function with Grouped Data and CTE's
- CTE with Inner Join and Aggregating Functions and CSV Files
- Nesting Functions and Pivoting Tables
-
User Defined Functions
-
Triggers and Views
-
Transactions
-
Build a Simple, Secure Data Entry System with Validation and Transactions
-
Administration
-
Make a Dashboard Website
- Create a site on IIS and an HTTP page
- Create a table in SQL Server and connect the page with a Detailsview
- Add CSS and jQuery to make elements draggable, droppable and saveable
- Make element expandable and add AJAX
- Add sales table with nested while loops
- Add trigger for adding sales records
- Add foreign key constraint for deleting records
- Synchronize Gridview and Details View
- Add a summary table
- Add theme switching with jQuery
- Add a sticky
- Printing GridViews to printers, Google Drive, and the cloud
- Final Project Review
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.
- Publication date:
- July 2018
- Publisher
- Packt
- Duration
- 18 hours 51 minutes
- ISBN
- 9781789530568