SQL Tutorials

https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw



http://www.dofactory.com/sql/sample-database

wiseowl

https://www.youtube.com/channel/UCB-St4JsTaZMulPNr8j9OeA
http://www.wiseowl.co.uk/videos/sql2016/movies-database.htm

Tutorial : SSIS, SSRS

https://www.youtube.com/watch?v=BsZCzeRKYcs
https://www.youtube.com/user/LearnItFirst/videos


c# tutorials

Lamda

https://www.youtube.com/watch?v=8o0O-vBS8W0

Advanced SQL: Logical Query Processing, Part 1

 

https://www.linkedin.com/learning/advanced-sql-logical-query-processing-part-1/dual-source-query-processing

SqlLite

http://objection-framework.org/

http://blog.tigrangasparian.com/2012/02/09/getting-started-with-sqlite-in-c-part-one/

Install-Package System.Data.SQLite

Moving asp.net applications to AWS

S3 Performance considerations

1. http://stackoverflow.com/questions/394198/max-files-per-directory-in-s3
2. http://docs.aws.amazon.com/AmazonS3/latest/dev/request-rate-perf-considerations.html

• Use snowball for large amounts of data  https://aws.amazon.com/importexport/
• http://s3tools.org/s3cmd  (command line tools for S3)  http://www.s3express.com/

http://www.s3express.com/help/help.html?vv_auth.html  http://www.s3express.com/help/S3Express.pdf

AWS Setup

1. create  windows 2012 R2 with Sql Server t2 medium
2. In server manager add IIS and .NET 4.5
3. install web-platform install
4. install web-deploy 2.6
5. add design website
6. webpublish

http://martinbuberl.com/blog/deploy-aspnet-mvc-on-amazon-ec2-with-web-deploy/

Completed course on AWS RDS