A 18 Hour SQLSQL Server 2014Visual Studio 2017 Course
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
Requirements
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.
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 Studio2) Learn how to create database connected web pages using SQL and ASP.NET controls4) Get PDF’s that depict difficult concepts in pictures for improved understanding5) 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
Overview
Section 1: Introduction: Get the Needed Software
Lecture 1 Get SQL Server 2014 Express
Lecture 2 Get Microsoft Visual Studio
Lecture 3 Configure the Layout of Panels in the Management Studio and Visual Studio
Section 2: Querying Basics
Lecture 4 Create a Table and Write a Simple Query and Display the Results
Lecture 5 Write a Query with a Where Restriction
Lecture 6 Write a Query with a Where and an Order By
Lecture 7 Filtering with Where and Between
Lecture 8 Aliasing Columns
Lecture 9 Aliasing Computed Columns
Lecture 10 Use The Query Designer
Lecture 11 Make an ASP.NET Web Page with SQL Server
Lecture 12 Summarize Blocks of Records with Group By
Lecture 13 Having Clause
Lecture 14 Select Into
Lecture 15 Add Multiple Parameters to an ASP.NET Page
Section 3: Table Manipulation
Lecture 16 Table Creation and Data Insertion
Lecture 17 Updating Records
Lecture 18 ASP.NET Page with Updating and Deleting
Lecture 19 1st Normal Form
Lecture 20 Second Normal Form
Lecture 21 Third Normal Form
Section 4: Table Joins
Lecture 22 Inner Join
Lecture 23 Inner Joins with Editor Window and Where Statements
Lecture 24 Left Join
Lecture 25 Left Joins with Editor and Where Statement
Lecture 26 Right Join
Lecture 27 Right Joins with Query Editor and Filtering Conditions
Lecture 28 Full Joins with The Query Editor
Section 5: Build an ASP.NET Page With Multiple Tables and Controls
Lecture 29 Connect Gridview to Tables with C#
Lecture 30 Create a Query Editor with C#
Section 6: Create an XML Powered ASP.NET Page
Lecture 31 Create a Table Suited For XML Output
Lecture 32 Create a Page With a Control That Connects to the XML Table
Section 7: Using SQL Server Functions and Operators
Lecture 33 In Logical Operator
Lecture 34 Where with Like
Lecture 35 Scalar Functions
Lecture 36 Aggregate Functions
Lecture 37 Summarzing Records with Over
Section 8: Subqueries
Lecture 38 Subqueries in Select Clauses
Lecture 39 Subqueries in From
Section 9: Stored Procedures and Programming Constructs
Lecture 40 Write and Execute a Simple Stored Procedure
Lecture 41 Part 1: Write a Parametrized Procedure
Lecture 42 Part 2: Asp.NET Page Powered by Parametrized Store Procedure
Lecture 43 Add IF/Else Blocks
Lecture 44 Case and When Statements with Functions
Lecture 45 While Blocks, Variables
Lecture 46 Stored Procedures with Output Parameters
Lecture 47 Try/Catch Error Handling
Lecture 48 Comparing Values Between Records with the Lag Function
Lecture 49 Common Table Expressions
Lecture 50 Using the Lead Function with Grouped Data and CTE’s
Lecture 51 CTE with Inner Join and Aggregating Functions and CSV Files
Lecture 52 Nesting Functions and Pivoting Tables
Section 10: User Defined Functions
Lecture 53 Scalar Valued Functions
Lecture 54 Table valued Functions
Lecture 55 Table Variables
Lecture 56 ASP.NET/SQL Server/LINQ
Section 11: Triggers and Views
Lecture 57 Write a View
Lecture 58 Write a Trigger
Section 12: Transactions
Lecture 59 Begin Transaction and Committ Transcation
Lecture 60 Save and Rollback Transactions
Section 13: Build a Simple, Secure Data Entry System with Validation and Trasactions
Lecture 61 Make the Table, and Write the Stored Procedure
Lecture 62 Make a Simple Interface
Lecture 63 Write the C#
Lecture 64 Improve Interface with CSS
Lecture 65 Add JQuery, Basic Example
Lecture 66 Refine the JQuery and Understand IIS Express
Lecture 67 Add AJAX and a Check Box
Lecture 68 Port To IIS
Lecture 69 Use jQuery To Make Interface Draggable, Droppable and Saveable
Section 14: Administration
Lecture 70 Adding Logins and Users
Lecture 71 Database Roles with Users
Lecture 72 Backups, Restores, Excel
Lecture 73 Backup Device and SQL Server Log
Section 15: Make a Dashboard Website
Lecture 74 Create a site on IIS and an HTTP page
Lecture 75 Create a table in SQL Server and connect the page with a Detailsview
Lecture 76 Add CSS and jQuery to make elements draggable, droppable and saveable
Lecture 77 Make element expandable and add aJAX
Lecture 78 Add sales table with nested while loops
Lecture 79 Add trigger for adding sales records
Lecture 80 Add foreign key constraint for deleting records
Lecture 81 Synchronize Gridview and Details View
Lecture 82 Add a summary table
Lecture 83 Add theme switching with jQuery
Lecture 84 Add a sticky
Lecture 85 Printing GridViews to printers, Google Drive, and the cloud
Lecture 86 Final Project Review
Lecture 87 What to do next
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.
Course Information:
Udemy | English | 18h 49m | 9.09 GB
Created by: T O
You Can See More Courses in the Developer >> Greetings from CourseDown.com