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

سرفصل های دوره

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

01 - Introduction Get the Needed Software

001 Get SQL Server 2014 Express

001 StepByStepInstallationInstructions.pdf

002 Get Microsoft Visual Studio

002 StepByStepInstallationInstructions.pdf

003 Configure the Layout of Panels in the Management Studio and Visual Studio

003 course-coupon-for-sql-server-2017-course.docx

external-links.txt

02 - Querying Basics

001 Create a Table and Write a Simple Query and Display the Results

001 Selectonlycertainrecords.pdf

001 Simpleselectquery.pdf

001 Tablestrructuretable.pdf

001 lesson5SQLcode.txt

002 Simpleselectquerywithwhereclause.pdf

002 Write a Query with a Where Restriction

003 Selectwithwhereandorderby.pdf

003 Write a Query with a Where and an Order By

004 Filtering with Where and Between

004 Withbetweenandwhereandorderby.pdf

005 Aliasing Columns

005 aliasingcolumns.docx

006 Aliasing Computed Columns

006 aliascomputecolumn.pdf

006 free-course-lesson-9-resources.docx

007 Queryeditorcode.pdf

007 Use The Query Designer

008 ASPNET-Page-Creation-Updated-2-12-2019.pdf

008 Lesson12UpdateMay2nd2018

008 Make an ASP.NET Web Page with SQL Server

008 Parametrizedquetyschematic.pdf

009 Groupbyclause.pdf

009 Groupbyvisualview.pdf

009 Summarize Blocks of Records with Group By

010 Having Clause

010 havingclause.pdf

011 Select Into

011 intoclause.pdf

012 Add Multiple Parameters to an ASP.NET Page

012 twoparameterpage.pdf

03 - Table Manipulation

001 Tablecreationandinsertioncode.pdf

001 Table Creation and Data Insertion

002 Updating Records

002 updatecode.pdf

003 ASP.NET Page with Updating and Deleting

004 1st Normal Form

004 Normalform1.pdf

005 Second Normal Form

006 Normalform3.pdf

006 Third Normal Form

04 - Table Joins

001 Inner Join

001 customers.xlsx

001 innerjoin.pdf

001 orders.xlsx

002 Inner Joins with Editor Window and Where Statements

002 innerjoinqueryeditor.pdf

003 Leftjoincode.pdf

003 Leftjoinconceptpdf.pdf

003 Left Join

004 AdventureWorks2014.zip

004 Left Joins with Editor and Where Statement

004 leftinnerjoinsonlargetables.pdf

005 Rightjoinschematics.pdf

005 Right Join

005 rightjoin.pdf

006 Right Joins with Query Editor and Filtering Conditions

006 rightjoinqueryeditor.pdf

007 Fullljoinwithwherestatementandorderby.pdf

007 Fullouterschematic.pdf

007 Full Joins with The Query Editor

external-links.txt

05 - Build an ASP.NET Page With Multiple Tables and Controls

001 Connect Gridview to Tables with C#

001 aspnetcode.pdf

002 Create a Query Editor with C#

002 codeandinterface.pdf

06 - Create an XML Powered ASP.NET Page

001 Create a Table Suited For XML Output

001 Detailedviewofcolumnnametoxmlmapping.pdf

001 Xmlexplicitcode.pdf

002 Create a Page With a Control That Connects to the XML Table

002 Xmlhtmlfile.pdf

07 - Using SQL Server Functions and Operators

001 In Logical Operator

001 innotinoperator.pdf

002 Where with Like

002 likeoperator.docx

003 Functionnesting.pdf

003 Scalar Functions

003 scalarfunction.pdf

003 workerdata.xlsx

004 Aggregate Functions

004 aggregatingfunctionswithformatting.docx

005 Summarzing Records with Over

005 overclause.docx

08 - Subqueries

001 Schematicforsimpleselectsubquery.pdf

001 Subqueries in Select Clauses

001 subquerieswithcolumns.docx

002 Subqueriesinfromblocks.pdf

002 Subqueries in From

002 subquerieswithfromclauses.docx

09 - Stored Procedures and Programming Constructs

001 Write and Execute a Simple Stored Procedure

001 createalterstoredprocedure.docx

002 Parametrizedstoredprocedure.pdf

002 Part 1 Write a Parametrized Procedure

002 storedprocwithparameters.docx

003 Part 2 Asp.NET Page Powered by Parametrized Store Procedure

003 interfacecode.pdf

004 Add IFElse Blocks

004 ifelseblocks.docx

005 Case and When Statements with Functions

005 casewhenthen.pdf

006 While Blocks, Variables

006 whileloopcode.pdf

007 Stored Procedures with Output Parameters

007 storedprocoutputparameters.pdf

008 TryCatch Error Handling

008 trycatch.pdf

009 Comparing Values Between Records with the Lag Function

009 johnssales.xlsx

009 lagfunction.pdf

010 Common Table Expressions

010 commontableexpression.pdf

011 Using the Lead Function with Grouped Data and CTEs

011 leadfunctionwithcte.pdf

012 CTE with Inner Join and Aggregating Functions and CSV Files

012 SalesAmounts.csv

012 SalesAmounts.xlsx

012 SalesPeople.csv

012 SalesPeople.xlsx

012 fileimportcsvcte.pdf

013 Nestingfunctionsstepbystepcode.pdf

013 Nesting Functions and Pivoting Tables

013 Pivotingtablesandunderstandingfunctionnesting.pdf

10 - User Defined Functions

001 Scalar Valued Functions

001 scalarvaluedfunctions.pdf

002 Table valued Functions

002 tablevaluedfunctions.pdf

003 Table Variables

003 tablevariables.pdf

004 ASP.NETSQL ServerLINQ

004 linqwithsqlserver.pdf

11 - Triggers and Views

001 Write a View

001 views.pdf

002 Write a Trigger

002 triggers.pdf

12 - Transactions

001 Begin Transaction and Committ Transcation

001 basictransaction.pdf

002 Save and Rollback Transactions

002 saverollbacktransactions.pdf

13 - Build a Simple, Secure Data Entry System with Validation and Trasactions

001 Make the Table, and Write the Stored Procedure

001 storedproctablestruct.pdf

002 Make a Simple Interface

002 htmlwebconfig.pdf

003 Write the C#

003 lesson63addsharpfiles.zip

004 Improve Interface with CSS

005 Add JQuery, Basic Example

006 Refine the JQuery and Understand IIS Express

006 lesson66allcode.zip

007 Add AJAX and a Check Box

007 lesson67finalprojectfiles.zip

008 Port To IIS

008 sqlservertoiissteps.pdf

009 Updated-default.aspx-markup-with-very-important-comments-and-improvements.pdf

009 Use jQuery To Make Interface Draggable, Droppable and Saveable

009 lesson69completecodefiles.zip

009 updated-c-sharp-code.pdf

14 - Administration

001 Adding Logins and Users

002 Database Roles with Users

002 Loginswithroles.pdf

003 Backups, Restores, Excel

004 Backup Device and SQL Server Log

15 - Make a Dashboard Website

001 Create a site on IIS and an HTTP page

001 Lesson75UpdateToVS201715151

002 Create a table in SQL Server and connect the page with a Detailsview

002 lesson75completecodefiles.zip

003 Add CSS and jQuery to make elements draggable, droppable and saveable

003 lesson76completeprojectfiles.zip

004 Make element expandable and add aJAX

004 lesson77completeprojectfiles.zip

005 Add sales table with nested while loops

005 cursorcode.pdf

006 Add trigger for adding sales records

006 lesson79sqlcode.txt

007 Add foreign key constraint for deleting records

007 lesson80sqlcode.txt

008 Synchronize Gridview and Details View

008 lesson81completeprojectfiles.zip

009 Add a summary table

009 lesson82completeprojectfiles.zip

010 Add theme switching with jQuery

010 lesson83completeprojectfiles.zip

011 Add a sticky

011 lesson84completeprojectfiles.zip

012 Printing GridViews to printers, Google Drive, and the cloud

012 lesson85completeprojectfiles.zip

013 Final Project Review

013 lesson86completeprojectfileswithdatabase.zip

014 What to do next.html

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy