An 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course [Video] [2018, ENG]
movies, software, shows...
Files
| 1 - Introduction - Get the Needed Software | |||
| Configure the Layout of Panels in the Management Studio and Visual Studio.mp4 | 16.09 MB | ||
| Get Microsoft Visual Studio.mp4 | 16.78 MB | ||
| Get SQL Server 2014 Express.mp4 | 13.39 MB | ||
| Update VS with SQL Server Tools.mp4 | 3.72 MB | ||
| 10 - User Defined Functions | |||
| ASP.NET_SQL Server_LINQ.mp4 | 88.08 MB | ||
| Scalar Valued Functions.mp4 | 50.37 MB | ||
| Table Variables.mp4 | 41.46 MB | ||
| Table valued Functions.mp4 | 54.67 MB | ||
| 11 - Triggers and Views | |||
| Write a Trigger.mp4 | 50.67 MB | ||
| Write a View.mp4 | 45.76 MB | ||
| 12 - Transactions | |||
| Begin Transaction and Commit Transaction.mp4 | 51.07 MB | ||
| Save and Rollback Transactions.mp4 | 28.07 MB | ||
| 13 - Build a Simple, Secure Data Entry System with Validation and Transactions | |||
| Add AJAX and a Check Box.mp4 | 82.85 MB | ||
| Add JQuery, Basic Example.mp4 | 72.23 MB | ||
| Improve Interface with CSS.mp4 | 56.3 MB | ||
| Make a Simple Interface.mp4 | 64.07 MB | ||
| Make the Table, and Write the Stored Procedure.mp4 | 63.31 MB | ||
| Port to IIS.mp4 | 47.44 MB | ||
| Refine the JQuery and Understand IIS Express.mp4 | 109.06 MB | ||
| Use jQuery To Make Interface Draggable, Droppable and Saveable.mp4 | 70.39 MB | ||
| Write the C#.mp4 | 111.11 MB | ||
| 14 - Administration | |||
| Adding Logins and Users.mp4 | 25.37 MB | ||
| Backup Device and SQL Server Log.mp4 | 36.25 MB | ||
| Backups, Restores, Excel.mp4 | 30.77 MB | ||
| Database Roles with Users.mp4 | 30.18 MB | ||
| 15 - Make a Dashboard Website | |||
| Add CSS and jQuery to make elements draggable, droppable and saveable.mp4 | 63.26 MB | ||
| Add a sticky.mp4 | 54.58 MB | ||
| Add a summary table.mp4 | 66.53 MB | ||
| Add foreign key constraint for deleting records.mp4 | 27 MB | ||
| Add sales table with nested while loops.mp4 | 75.81 MB | ||
| Add theme switching with jQuery.mp4 | 37.99 MB | ||
| Add trigger for adding sales records.mp4 | 31.16 MB | ||
| Create a site on IIS and an HTTP page.mp4 | 17.53 MB | ||
| Create a table in SQL Server and connect the page with a Detailsview.mp4 | 41.06 MB | ||
| Final Project Review.mp4 | 90.94 MB | ||
| Make element expandable and add AJAX.mp4 | 77.91 MB | ||
| Printing GridViews to printers, Google Drive, and the cloud.mp4 | 97.38 MB | ||
| Synchronize Gridview and Details View.mp4 | 78.29 MB | ||
| 2 - Querying Basics | |||
| Add Multiple Parameters to an ASP.NET Page.mp4 | 66.65 MB | ||
| Aliasing Columns.mp4 | 41.13 MB | ||
| Aliasing Computed Columns.mp4 | 40.95 MB | ||
| Create a Table and Write a Simple Query and Display the Results.mp4 | 39.55 MB | ||
| Filtering with Where and Between.mp4 | 29.96 MB | ||
| Having Clause.mp4 | 24.73 MB | ||
| Make an ASP.NET Web Page with SQL Server.mp4 | 70 MB | ||
| Select Into.mp4 | 26.78 MB | ||
| Summarize Blocks of Records with Group By.mp4 | 36.28 MB | ||
| Use the Query Designer.mp4 | 18.98 MB | ||
| Write a Query with a Where Restriction.mp4 | 12.89 MB | ||
| Write a Query with a Where and an Order By.mp4 | 30.88 MB | ||
| 3 - Table Manipulation | |||
| 1st Normal Form.mp4 | 36.94 MB | ||
| ASP.NET Page with Updating and Deleting.mp4 | 67.27 MB | ||
| Second Normal Form.mp4 | 37.1 MB | ||
| Table Creation and Data Insertion.mp4 | 27.13 MB | ||
| Third Normal Form.mp4 | 32.21 MB | ||
| Updating Records.mp4 | 20.62 MB | ||
| 4 - Table Joins | |||
| Full Joins with the Query Editor.mp4 | 24.78 MB | ||
| Inner Join.mp4 | 32.92 MB | ||
| Inner Joins with Editor Window and Where Statements.mp4 | 24.9 MB | ||
| Left Join.mp4 | 32.17 MB | ||
| Left Joins with Editor and Where Statement.mp4 | 59.03 MB | ||
| Right Join.mp4 | 34.82 MB | ||
| Right Joins with Query Editor and Filtering Conditions.mp4 | 39.64 MB | ||
| 5 - Build an ASP.NET Page with Multiple Tables and Controls | |||
| Connect Gridview to Tables with C#.mp4 | 64.48 MB | ||
| Create a Query Editor with C#.mp4 | 80.23 MB | ||
| 6 - Create an XML Powered ASP.NET Page | |||
| Create a Page with a Control That Connects to the XML Table.mp4 | 35.31 MB | ||
| Create a Table Suited For XML Output.mp4 | 36.4 MB | ||
| 7 - Using SQL Server Functions and Operators | |||
| Aggregate Functions.mp4 | 47.9 MB | ||
| In Logical Operator.mp4 | 32.4 MB | ||
| Scalar Functions.mp4 | 45.18 MB | ||
| Summarizing Records with Over.mp4 | 67.51 MB | ||
| Where with Like.mp4 | 41.28 MB | ||
| 8 - Subqueries | |||
| Subqueries in From.mp4 | 47.02 MB | ||
| Subqueries in Select Clauses.mp4 | 25.47 MB | ||
| 9 - Stored Procedures and Programming Constructs | |||
| Add IF_Else Blocks.mp4 | 45.59 MB | ||
| CTE with Inner Join and Aggregating Functions and CSV Files.mp4 | 54.37 MB | ||
| Case and When Statements with Functions.mp4 | 59.43 MB | ||
| Common Table Expressions.mp4 | 35.08 MB | ||
| Comparing Values between Records with the Lag Function.mp4 | 60.43 MB | ||
| Nesting Functions and Pivoting Tables.mp4 | 35.79 MB | ||
| Part 1 - Write a Parametrized Procedure.mp4 | 71.45 MB | ||
| Part 2 - Asp.NET Page Powered by Parametrized Store Procedure.mp4 | 57.85 MB | ||
| Stored Procedures with Output Parameters.mp4 | 31.23 MB | ||
| Try_Catch Error Handling.mp4 | 32.52 MB | ||
| Using the Lead Function with Grouped Data and CTE's.mp4 | 42.59 MB | ||
| While Blocks, Variables.mp4 | 43.5 MB | ||
| Write and Execute a Simple Stored Procedure.mp4 | 30.23 MB | ||
| V11713_Codes_0.zip | 160 B | ||
| ▲ 88 total files | |||
Description
Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)
An 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course [Video]
Learn SQL, SQL Server, SSMS, ASP.NET, Visual Studio, C#, HTML and More!
Год выпуска: 07/2018
Производитель: Packtpub
Сайт производителя: packtpub.com/application-development/cisco-icnd2-200-105-ccna-bootcamp-video
Автор: Tom O.
Продолжительность: 18:51
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: 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.
Файлы примеров: есть
Формат видео: MP4
Видео: AVC, 1920x1080, 16:9, 25fps, 337kbps
Аудио: AAC, 44.1kHz, 75kbps, mono
[spoiler="Скриншоты"]
[/spoiler]
All Comments