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

Focused View

T O

18:56:54

20 View

01 - Introduction Get the Needed Software

001 Get SQL Server 2014 Express.mp4

05:14

001 StepByStepInstallationInstructions.pdf

002 Get Microsoft Visual Studio.mp4

05:26

002 StepByStepInstallationInstructions.pdf

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

03:50

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.mp4

13:58

001 Selectonlycertainrecords.pdf

001 Simpleselectquery.pdf

001 Tablestrructuretable.pdf

001 lesson5SQLcode.txt

002 Simpleselectquerywithwhereclause.pdf

002 Write a Query with a Where Restriction.mp4

04:25

003 Selectwithwhereandorderby.pdf

003 Write a Query with a Where and an Order By.mp4

09:08

004 Filtering with Where and Between.mp4

09:05

004 Withbetweenandwhereandorderby.pdf

005 Aliasing Columns.mp4

11:03

005 aliasingcolumns.docx

006 Aliasing Computed Columns.mp4

10:38

006 aliascomputecolumn.pdf

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

007 Queryeditorcode.pdf

007 Use The Query Designer.mp4

06:40

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

008 Lesson12UpdateMay2nd2018.mp4

02:41

008 Make an ASP.NET Web Page with SQL Server.mp4

19:24

008 Parametrizedquetyschematic.pdf

009 Groupbyclause.pdf

009 Groupbyvisualview.pdf

009 Summarize Blocks of Records with Group By.mp4

11:30

010 Having Clause.mp4

07:10

010 havingclause.pdf

011 Select Into.mp4

08:03

011 intoclause.pdf

012 Add Multiple Parameters to an ASP.NET Page.mp4

19:26

012 twoparameterpage.pdf

03 - Table Manipulation

001 Tablecreationandinsertioncode.pdf

001 Table Creation and Data Insertion.mp4

08:18

002 Updating Records.mp4

06:19

002 updatecode.pdf

003 ASP.NET Page with Updating and Deleting.mp4

16:49

004 1st Normal Form.mp4

12:12

004 Normalform1.pdf

005 Second Normal Form.mp4

09:57

006 Normalform3.pdf

006 Third Normal Form.mp4

08:25

04 - Table Joins

001 Inner Join.mp4

11:49

001 customers.xlsx

001 innerjoin.pdf

001 orders.xlsx

002 Inner Joins with Editor Window and Where Statements.mp4

08:12

002 innerjoinqueryeditor.pdf

003 Leftjoincode.pdf

003 Leftjoinconceptpdf.pdf

003 Left Join.mp4

10:45

004 AdventureWorks2014.zip

004 Left Joins with Editor and Where Statement.mp4

15:24

004 leftinnerjoinsonlargetables.pdf

005 Rightjoinschematics.pdf

005 Right Join.mp4

10:14

005 rightjoin.pdf

006 Right Joins with Query Editor and Filtering Conditions.mp4

10:19

006 rightjoinqueryeditor.pdf

007 Fullljoinwithwherestatementandorderby.pdf

007 Fullouterschematic.pdf

007 Full Joins with The Query Editor.mp4

06:42

external-links.txt

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

001 Connect Gridview to Tables with C#.mp4

19:38

001 aspnetcode.pdf

002 Create a Query Editor with C#.mp4

25:05

002 codeandinterface.pdf

06 - Create an XML Powered ASP.NET Page

001 Create a Table Suited For XML Output.mp4

12:41

001 Detailedviewofcolumnnametoxmlmapping.pdf

001 Xmlexplicitcode.pdf

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

11:00

002 Xmlhtmlfile.pdf

07 - Using SQL Server Functions and Operators

001 In Logical Operator.mp4

08:40

001 innotinoperator.pdf

002 Where with Like.mp4

10:45

002 likeoperator.docx

003 Functionnesting.pdf

003 Scalar Functions.mp4

12:20

003 scalarfunction.pdf

003 workerdata.xlsx

004 Aggregate Functions.mp4

12:04

004 aggregatingfunctionswithformatting.docx

005 Summarzing Records with Over.mp4

16:58

005 overclause.docx

08 - Subqueries

001 Schematicforsimpleselectsubquery.pdf

001 Subqueries in Select Clauses.mp4

06:30

001 subquerieswithcolumns.docx

002 Subqueriesinfromblocks.pdf

002 Subqueries in From.mp4

13:04

002 subquerieswithfromclauses.docx

09 - Stored Procedures and Programming Constructs

001 Write and Execute a Simple Stored Procedure.mp4

08:22

001 createalterstoredprocedure.docx

002 Parametrizedstoredprocedure.pdf

002 Part 1 Write a Parametrized Procedure.mp4

17:37

002 storedprocwithparameters.docx

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

18:05

003 interfacecode.pdf

004 Add IFElse Blocks.mp4

13:11

004 ifelseblocks.docx

005 Case and When Statements with Functions.mp4

16:50

005 casewhenthen.pdf

006 While Blocks, Variables.mp4

13:32

006 whileloopcode.pdf

007 Stored Procedures with Output Parameters.mp4

09:24

007 storedprocoutputparameters.pdf

008 TryCatch Error Handling.mp4

10:24

008 trycatch.pdf

009 Comparing Values Between Records with the Lag Function.mp4

15:39

009 johnssales.xlsx

009 lagfunction.pdf

010 Common Table Expressions.mp4

09:11

010 commontableexpression.pdf

011 Using the Lead Function with Grouped Data and CTEs.mp4

11:35

011 leadfunctionwithcte.pdf

012 CTE with Inner Join and Aggregating Functions and CSV Files.mp4

16:00

012 SalesAmounts.csv

012 SalesAmounts.xlsx

012 SalesPeople.csv

012 SalesPeople.xlsx

012 fileimportcsvcte.pdf

013 Nestingfunctionsstepbystepcode.pdf

013 Nesting Functions and Pivoting Tables.mp4

11:04

013 Pivotingtablesandunderstandingfunctionnesting.pdf

10 - User Defined Functions

001 Scalar Valued Functions.mp4

13:00

001 scalarvaluedfunctions.pdf

002 Table valued Functions.mp4

15:06

002 tablevaluedfunctions.pdf

003 Table Variables.mp4

12:26

003 tablevariables.pdf

004 ASP.NETSQL ServerLINQ.mp4

22:57

004 linqwithsqlserver.pdf

11 - Triggers and Views

001 Write a View.mp4

12:38

001 views.pdf

002 Write a Trigger.mp4

13:19

002 triggers.pdf

12 - Transactions

001 Begin Transaction and Committ Transcation.mp4

14:45

001 basictransaction.pdf

002 Save and Rollback Transactions.mp4

08:30

002 saverollbacktransactions.pdf

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

001 Make the Table, and Write the Stored Procedure.mp4

19:41

001 storedproctablestruct.pdf

002 Make a Simple Interface.mp4

19:57

002 htmlwebconfig.pdf

003 Write the C#.mp4

30:15

003 lesson63addsharpfiles.zip

004 Improve Interface with CSS.mp4

14:24

005 Add JQuery, Basic Example.mp4

14:24

006 Refine the JQuery and Understand IIS Express.mp4

20:57

006 lesson66allcode.zip

007 Add AJAX and a Check Box.mp4

23:56

007 lesson67finalprojectfiles.zip

008 Port To IIS.mp4

15:48

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.mp4

19:14

009 lesson69completecodefiles.zip

009 updated-c-sharp-code.pdf

14 - Administration

001 Adding Logins and Users.mp4

08:18

002 Database Roles with Users.mp4

09:58

002 Loginswithroles.pdf

003 Backups, Restores, Excel.mp4

10:11

004 Backup Device and SQL Server Log.mp4

10:43

15 - Make a Dashboard Website

001 Create a site on IIS and an HTTP page.mp4

06:41

001 Lesson75UpdateToVS201715151.mp4

04:29

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

13:33

002 lesson75completecodefiles.zip

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

15:52

003 lesson76completeprojectfiles.zip

004 Make element expandable and add aJAX.mp4

18:35

004 lesson77completeprojectfiles.zip

005 Add sales table with nested while loops.mp4

21:06

005 cursorcode.pdf

006 Add trigger for adding sales records.mp4

09:53

006 lesson79sqlcode.txt

007 Add foreign key constraint for deleting records.mp4

07:53

007 lesson80sqlcode.txt

008 Synchronize Gridview and Details View.mp4

16:34

008 lesson81completeprojectfiles.zip

009 Add a summary table.mp4

18:01

009 lesson82completeprojectfiles.zip

010 Add theme switching with jQuery.mp4

10:32

010 lesson83completeprojectfiles.zip

011 Add a sticky.mp4

16:03

011 lesson84completeprojectfiles.zip

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

23:24

012 lesson85completeprojectfiles.zip

013 Final Project Review.mp4

21:06

013 lesson86completeprojectfileswithdatabase.zip

014 What to do next.html

Description

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

What You'll Learn?

Learn SQL
Learn SQL Server
Learn the Basics of Microsoft Visual Studio 2017 Community
Learn the Basics of Microsoft ASP.NET with SQL Server
Learn Enough C# To Connect to Databases
Learn Enough JQuery to Make Database Controls Interctive (jQuery is used on the bottom of the course)
Learn the Fundamentals of SQL Server Administration
Learn how to work with built in functions
Learn how to write joins
Learn how to make web pages for collecting and storing information
Learn how to format data in web pages and tables
Learn how to represent queries with pictures for easier understanding
Learn how to use program flow control features like if/else and more
Learn how to write stored procedures
Learn how to write user defined functions
Learn how to write views and triggers
Learn how to use the SQL Server debugger
Learn how to create, save, commit and roll back transactions
Learn how to create users, database roles, logins, and work with securables
Learn how to backup, restore, attach and detach databases
Learn how to import data into SQL Server from other programs
Learn how to bring tables into first, second and third normal form
Learn how to work with XML in SQL Server and ASP.NET Controls
Learn how to use and save Table variables
Learn how to create and use Common Table Expressions
Learn how to work with string functions like char, and substring
Learn how to use the Lag/Lead Functions and the Over Clause
Learn how to work with date functions like Datename, Datepart, getDate and more
Learn how to build dynamic theme switching with JQuery
Learn how to build dashboard with C#/CSS/HTML/SQL and JQuery
Learn how to perform data validation
Learn how to print to printers, PDF's, Google Drive, and the Cloud
Build a web based data entry system with C#/SQL, CSS and VS
Understand how to use begin/end/go and ;
Learn how to build a web interface layout that can be dragged, dropped and saved between page loads

Who is this for?

This course is for those who appreciate fine levels of detail.

This course is intended for SQL Server novices

This course is intended for ASP.NET novices

This course is intended for Visual Studio novices

This course is intended for those who are intermediate or above in C#

This course is NOT for those who want to be entertained.

This course is NOT for those who want 5 minutes videos.

What You Need to Know?

Ability to download and install SQL Server 2014 (100% Free)

Ability to download and install Visual Studio 2017

The SQL begins at the beginner level and progresses through more advanced lessons.

The C# begins at the intermediate level.

If you use previous versions of SQL Server, like 2008 or 2012, you will have problems with the files used. It's best to use 2014 and up.

More details

Description
Who Should Join:Â
1. 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 kindly refrain from enrolling until this very important step is complete.
2. 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.Â
3. You are interested in real coding.
4. You enjoy detailed explanations at an introductory level. Please answer the questions in the quizzes based on the course content, and not external knowledge you might already have. This is very important in order for the quizzes to work correctly.
Â Â Very important note:Â this course is a general overview of many topics, so not every topic can be explored in great depth and atÂ Â Â Â Â every level of subtlety.
5. You can take videos that are 13 minutes on average.
6. You enjoy seeing how different technologies interact.
7. You understand that most of the SQLÂ is done in the Microsoft Management Studio, and not Visual Studio.
9. You're NOTÂ looking for fancy graphics, a talking head, or entertainment.Â
9. You're looking for practical, carefully explained examples, where the code is written line by line.
10. IÂ made all the code in a fairly big font to be sure it's easy to see.
11. If you use SQLÂ Server versions below 2014, some of the code will not work. You must use versions 2014 and above.Â
12. This course uses ASP.NET and C# and not MVC.Â
13. 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.Â
14. IÂ don't have an intense amountÂ of energy in my videosÂ because they areÂ made after I've been at work for many hours already.Â
Major benefits of the course:Â
1) Learn query writing by using the Microsoft Management Studio
2) Learn how to create database connected web pages using SQL and ASP.NETÂ controls
4) Get PDF's that depict difficult concepts in pictures for improved understanding
5) Get 210 quiz questions so you can feel confident you're making true progress.
6) Learn the basics of database connecting code using Microsoft'sÂ premierÂ programming language: C#Â
7) Get exposure to modern SQLÂ language features like Lag/LeadÂ
8) Build a dashboard system with SQL Server, ASP Web Forms, C# and JQuery (bottom of course)
Given the number of videos, PDF's, variety of teaching methods, quizzes, and a project that is designed to give you a feeling of what to expect in the real world, we're confident this is by far the best deal on this site. Join today, and learn truly valuable skills.Â
jQuery and related marks are trademarks of the JS Foundation, and this course is not affiliated with or endorsed by the JS Foundation.
Parts of promo background licensed from Presenter Media . com
Who this course is for:
This course is for those who appreciate fine levels of detail.
This course is intended for SQL Server novices
This course is intended for ASP.NET novices
This course is intended for Visual Studio novices
This course is intended for those who are intermediate or above in C#
This course is NOT for those who want to be entertained.
This course is NOT for those who want 5 minutes videos.

User Reviews

Rating

average 0

Total votes0

Focused display

I love computers , math and programming. I teach because it gives me great joy to understand things deeply and to share that knowledge with others.My education: 1. Master's degree in Statistical Computing2. BA in mathematics3. Professional development certificates from Microsoft in each area below: 1. Deep learning with Python 2. Introduction to Artificial intelligence 3. Data science with Python 4. Math for machine learning 5. Data science research methods with Python 4. Professional certificates from other schools: 1. Columbia university certificate in introduction to corporate finance 2. MIT certificate in introductory economics

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.