Learn SQL Server 2014, ASP.NET, CSS, C#, JQuery Course

seeders: 26
leechers: 66
Download torrent
Added on February 18, 2015 by penguinein Other > Tutorials
Torrent verified.


Learn SQL Server 2014, ASP.NET, CSS, C#, JQuery Course (Size: 2.36 GB)
 Torrent Downloaded From kickass.to.txt39 bytes
 tracker list.txt510 bytes
 Torrent Downloaded From ExtraTorrent.cc.txt352 bytes
 002 Get Microsoft Visual Studio Express 2013 for Web.mp49.14 MB
 003 Configure the Layout of Panels in the Management Studio and Visual Studio.mp415.77 MB
 004 Update VS with SQL Server Tools.mp44.73 MB
 001 Get SQL Server 2014 Express.mp422.34 MB
 003 Write a Query with a Where and an Order By.mp419.19 MB
 004 Using Between and Not Between.mp422.62 MB
 002 Write a Query with a Where Restriction.mp417.8 MB
 001 Create a Table and Write a Simple Query and Display the Results.mp425.44 MB
 012 Add Multiple Parameters to an ASP.NET Page.mp445.23 MB
 009 Group By.mp420.79 MB
 005 Aliasing Columns.mp416.45 MB
 011 Select Into.mp427.24 MB
 010 Having Clause.mp420.26 MB
 006 Aliasing Computed Columns.mp425.91 MB
 001 Table Creation and Data Insertion.mp426.18 MB
 004 1st Normal Form.mp437.57 MB
 003 ASP.NET Page with Updating and Deleting.mp460.59 MB
 006 Third Normal Form.mp415.18 MB
 002 Updating and Deleting Records.mp415.19 MB
 005 Second Normal Form.mp431.06 MB
 003 Left Join.mp424.07 MB
 002 Inner Joins with Editor Window and Where Statements.mp415.65 MB
 004 Left Joins with Editor and Where Statment.mp49.51 MB
 006 Right Joins with Query Editor and Filtering Conditions.mp416.2 MB
 001 Inner Join.mp425.96 MB
 005 Right Join.mp423.63 MB
 007 Full Joins with The Query Editor.mp419.98 MB
 002 Create the User Interface and Add Logic with C.mp455.74 MB
 001 Generate the Tables in SQL Server with Query Editor and Select Into.mp418.9 MB
 001 Create a Table Suited For XML Output.mp428.93 MB
 002 Create a Page With a Control That Connects to the XML Table.mp417.9 MB
 001 In Logical Operator.mp412.03 MB
 002 Like and And.mp426.44 MB
 003 Scalar Functions.mp433.11 MB
 004 Aggregate Functions.mp431.78 MB
 005 Understanding the Over Clause.mp423.05 MB
 002 Subqueries in From.mp418.63 MB
 001 Subqueries in Select Clauses.mp413.09 MB
 004 Case and When Statements with Functions.mp431.95 MB
 006 Stored Procedures with Output Parameters.mp421.41 MB
 007 TryCatch Error Handling.mp430.59 MB
 005 While Blocks, Variables and Casting.mp433.24 MB
 003 Add IFElse Blocks and BeginEnd.mp431.54 MB
 001 Write and Execute a Simple Stored Procedure.mp425.73 MB
 002 Add Parameters.mp423.6 MB
 008 Call a Stored Procedure from an ASP.NET Page.mp417 MB
 009 Common Table Expressions.mp441.37 MB
 012 CTE with Inner Join and Aggregating Functions.mp446.24 MB
 001 Scalar Valued Functions.mp431.87 MB
 002 Table valued Functions.mp437.4 MB
 003 Table Variables.mp429.32 MB
 002 Write a Trigger.mp460.21 MB
 001 Write a View.mp435.31 MB
 002 Rollback Transaction.mp432.26 MB
 003 Saving Transactions.mp420.04 MB
 001 Begin Transaction and Committ Transcation.mp427.02 MB
 003 Improve the Interface with Ajax, JQuery and CSS.mp456.6 MB
 002 Add C Code and Make a Simple Interface.mp457.56 MB
 004 Make One Small Change.mp44.03 MB
 001 Make the Table, and Write the Stored Procedure.mp438.36 MB
 004 Importing Data From Excel.mp414.02 MB
 001 Adding Logins and Users.mp434.27 MB
 002 Database Roles with Users.mp439.12 MB
 003 Backups, Restores, Detaching and Attaching.mp423.43 MB
 008 Add A Trigger to Delete Records.mp430.42 MB
 007 Make the Panels Stay in Place with AJAX.mp430.94 MB
 009 Add a Panel for Adding New Sales Records.mp442.29 MB
 005 Add A Summary Table and a New Dashboard Control.mp422.15 MB
 006 Add Charting and Centralize Formatting Using a Style Sheet.mp421.84 MB
 001 Make the Names Table, Create a VS Project, Add JQuery and Make a Dashboard Contr.mp438.29 MB
 003 Add a Trigger and a Stored Procedure and Try the Results.mp437.53 MB
 004 Add a Grid View to Synchronize with the Details View.mp428.18 MB
 002 Add a Second Table with Nested While Loops.mp457.05 MB
 015 Sticky with Keyup Function in JQuery.mp415.25 MB


Description

A 13 Hour SQL Server 2014 /ASP.NET/CSS/C#/JQuery Course
Learn the Fundamentals SQL Server 2014, Visual Studio 2013, JQuery, CSS and HTML. Finish with a real dashboard project.

INFO:
English | MP4, AVC, 600 kbps, 1280x720 | AAC, 64 kbps, 2 Ch
Genre: eLearning

What am I going to get from this course?
Over 85 lectures and 13.5 hours of content!
Learn SQL
Learn SQL Server
Learn the Basics of Microsoft Visual Studio 2013 for Web
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'
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


COURSE DESCRIPTION

Why learn SQL, SQL Server, and Visual Studio? To build applications today, a programmer must know how to combine the power of various technologies together to produce software that is powerful and web based. The focus of this course is SQL through Microsoft SQL Server 2014, but along the way, you also see how to use Microsoft Visual Studio 2013 for Web , and you get to build a real dashboard system powered by SQL, C#, AJAX, CSS, HTML and JQuery. Any of these skills alone are valuable, but knowing how to combine these skills makes you immediately standout in the job market. Enroll today, and learn how to give yourself a great competitive advantage in the job world.

1) Learn query writing by using the Microsoft Management Studio

2) Learn query writing by using the Microsoft Visual Studio Query Editor

3) Learn how to create database connected web pages using SQL and XML Data Sources

4) Get color PDF's for many of the lessons for easy reference

5) Get PDF's that depict difficult concepts in pictures for improved understanding

6) All in all, there are about 100 PDF's to accompany the video lectures

7) Get 210 questions so you can feel confident you're making true progress

8) Learn the basics of database connecting code using Microsoft's premier programming language: C#

9) Get exposure to modern language features like Lag/Lead

10) Build a dashboard system with SQL Server, ASP.NET, C# and JQuery

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.


Sharing Widget


Download torrent
2.36 GB
seeders:26
leechers:66
Learn SQL Server 2014, ASP.NET, CSS, C#, JQuery Course

All Comments

TechieAce
Thanks mate, thanks a lot