coder_girl SQL Examples

FAQ

Winter Classes 2020 (compressed, being revised)

Class 1:	Project Planning
Class 2:	Project Proposal Guidelines
Class 3:	Data Types, Identity Specification
Class 4:	Database Diagrams in SSMS, Formatting
Class 5:	Allow Table re-creation, Normalization, Restoring Databases
Class 6:	Unnormalized Database, and Normalization Example Explanation
Class 7:	Functions in SQL
Class 8:	Backing Up Databases, Stored Procedures, Interface Design (with Sprocs), HTML/ASP Example, The example login Database
Class 9:	IF statements & Catching Errors with IF
Class 10:	Installing Visual Studio, Error Handling with TRY/CATCH
Class 11:	Building Reports in SSRS, Note on SSRS quirks
Class 12:	Links in SSRS, Images In SSRS (example images), Dropdowns, Note on SSRS quirks
Class 14:	(test database), Putting it All Together, then doing it again
Class 15:	Default Arguments, Graphs and Charts with a (ufo test database)
Class 16:	SQL review, MetaSQL Sprocs with A Brief Explanation of Dynamic Programming
Class 17:	Talking about your Project,
Class 18:	Presenting your Final project, Interview Review, More SQL concepts reviewed
Class 19:	Creating a scheduled job, Using SMTP to send emails, Automating Tasks, Database Example, Ryan's Parting Wisdom, and HackerRank
Class 20:	Final Presentations
Uncovered:
Tasks/Jobs:	Using SMTP to send emails, Automating Tasks, Database Example
Advice:	Improving Existing Code, and Ryan's Debugging Loop

Summer Classes 2019 (compressed, being revised)

Class 1:	Intros, Project Proposal Guidelines, and Project Planning
Class 2:	Database Diagrams in SSMS, Formatting
Class 3:	SQL review, Normalization, Restoring Databases, Unnormalized Database, and Normalization Example Explanation
Class 4:	Backing Up Databases, Stored Procedures, The example login Database, Interface Design, HTML/ASP Example, Building Reports in SSRS
Class 5:	Links in SSRS, Images In SSRS (with samples), Note on SSRS quirks, Dropdowns, IF statements & Catching Errors with IF, Error Handling with TRY/CATCH
Review:	Kathi's SSRS presentations ( Class 1, Class 2, Class 3, Class 4 )
Class 6:	(test database), Putting it All Together, then doing it again
Class 7:	Default Arguments, Functions in SQL, Graphs and Charts with a (ufo test database)
Class 8:	MetaSQL Sprocs with A Brief Explanation of MetaSQL, Presenting your Project
Class 9:	Mini-presentations, Presenting your Final project
Class 10:	Interview Review, Ryan's Parting Wisdom, More SQL concepts reviewed, and HackerRank
Class 11:	Final Presentations
Uncovered:
Tasks/Jobs:	Using SMTP to send emails, Automating Tasks, Database Example
Advice:	Improving Existing Code, and Ryan's Debugging Loop

Winter Classes 2019 (compressed)

Class 1:	Intros, Project Proposal Guidelines, and Project Planning
Class 2:	HackerRank and Normalization, Unnormalized Database, and Normalization Example Explanation, Database Diagrams in SSMS and Formatting
Class 3:	SQL review
Class 4:	Backing Up Databases, Restoring Databases, Stored Procedures, The example login Database, Interface Design, and a HTML/ASP Example
	IF statements & Catching Errors with IF, Error Handling with TRY/CATCH
Class 5:	Building Reports in SSRS, Links in SSRS, Images In SSRS (with samples), Note on SSRS quirks, Dropdowns,
Review:	Kathi's SSRS presentations ( Class 1, Class 2, Class 3, Class 4 )
Class 6:	(test database), Putting it All Together, then doing it again
Class 7:	Functions in SQL, Graphs and Charts with a (ufo test database)
Class 8:	Presenting your Project , MetaSQL with reference
Class 9:	Mini-presentations
Class 10:	Using SMTP to send emails, Automating Tasks, Database Example
Class 11:	Presenting your Final project and Interview Review, Improving Existing Code, Ryan's Parting Wisdom, Ryan's Debugging Loop, More SQL concepts reviewed
Class 12:	Final Presentations

Summer 2018 Classes.

Class 1:	Intros, Project Proposal Guidelines, and Project Planning
Class 2:	HackerRank and Normalization, Unnormalized Database, and Notes
Class 3:	Database Diagrams in SSMS and Formatting
Class 4:	SQL review
Class 5:	Backing Up Databases, Restoring Databases, Stored Procedures, The Class 5 Database, Interface Design, and a HTML/ASP Example
Class 6:	Building Reports in SSRS, Links in SSRS, Kathi's SSRS Review: ( Class 1, Class 2, Class 3, Class 4 )
Class 7:	IF statements & Catching Errors with IF, Widget Database, Advanced Procedures, HTML/ASP example
Class 8:	Functions, Error Handling with TRY/CATCH, Note on SSRS quirks, MetaSQL with reference
Class 9:	More SSRS, including: Images In SSRS, (example images), Links in SSRS (review) and Dropdowns
Class 10:	(test database), Putting it All Together, then doing it again!
Class 11:	Graphs and Charts with a (ufo test database)
Class 12:	Presenting your Project
Class 13:	Presentations
Class 14:	Using SMTP to send emails, Automating Tasks, Database Example
Class 15:	Triggers and Cursors with a Database Example
Class 16:	Presenting your Final project and Interview Review
Class 17:	Improving Existing Code and Indexes
Class 18:	Ryan's Parting Wisdom, Ryan's Debugging Loop, More SQL concepts reviewed

Winter 2018 Classes.

Class 1:	Intros and Project Proposal Guidelines
Class 2:	Project Planning
Class 3:	Database Diagrams in SSMS
Class 4:	SQL review
Class 5:	Backing Up Databases, Restoring Databases, The Class 5 Database, Interface Design, and a HTML/ASP Example
Class 6:	IF statements & Error Handling, Widget Database, Advanced Procedures, HTML/ASP example
Class 7:	Building Reports in SSRS, Kathi's SSRS Review: ( Class 1, Class 2, Class 3, Class 4 )
Class 8:	Functions, IF statements & Error Handling (Review from Class 6), MetaSQL with reference
Class 9:	More SSRS, including: Images (with samples), Links, and Dropdowns
Class 10:	(test database), Putting it All Together, then doing it again!
Class 11:	Graphs and Charts with a (ufo test database)
Class 12:	Review, HackerRank, Reminder
Class 13:	Presenting your Project
Class 14:	Ryan Slacks Off
Class 15:	Formatting and Normalization
Class 16:	Creating a scheduled job (with backups), Improving Existing Code, and Indexes
Class 17:	More SQL concepts reviewed and Presenting your project

Summer 2017 Classes.

Class 1:	Intros and Project Proposal Guidelines
Class 2:	Project Planning
Class 3:	Database Diagrams in SSMS
Class 4:	SQL review
Class 5:	Stored Procedures, MetaSQL, and Restoring Databases
Class 6:	Interface Design, SSRS, and an HTML/ASP Example	(Class 6 Database & Source Code)
Class 7:	Error Handling, Source Code, Kathi's SSRS lessons, Improved MetaSQL
Class 8:	Simple Automated Backup, Interviewing with Launch_Code
Class 9:	SSRS Review - With SQL Reference Database
Class 10:	Scheduling, Getting ready for presentations Learning HTML & CSS,
Class 11:	Notepad++ - make sure to hit the right Download link!
Class 12:	Example HTML, Files
Class 13:	Getting Started with Bootstrap, List of Bootstrap Classes	Simple example
Class 14:	Installing Visual Studio, Example ASP page	Source code
Class 15:	Running a Local Website, Example ASP site	Source code
Class 16:	Template Source code
Class 17:	Connecting To Remote Databases, Scripting Databases

Winter 2017 lessons - Will not exactly match lessons for Summer 2017. Course is being revised!:

https://docs.google.com/presentation/d/1r-cj-YqxHTxJVVHlvgAxOVzaueKxSJieYFjKsscqBSY/edit?usp=sharing

Lesson 1:	Example HTML files
Lesson 2:	Database Design in SSMS
Lesson 3:	ASP code example	Click here to see the .asp page in action!
Lesson 4:	Stored Procedures	Source Code
Lesson 5:	ASP.NET Intro	Source Code
Lesson 6:	Interface Design	Source Code	Test
Lesson 7:	Error Handling	Source Code
Lesson 8:	Review	Source Code
Lesson 9:	Web Site Files	Learning HTML & CSS
Lesson 10:	Web Site Files	See examples in action!
Lesson 11:	Ryan's Debugging Loop	Advice for new developers	More tips
Lesson 12:	Input Example Files	See input examples in action!
Lesson 13:	Interview Tips
Lesson 14:	Using SMTP to send emails		Source Code Examples
Lesson 15:	Automating Tasks		Database Example
Lesson 16:	Connecting To Remote Databases
Lesson 17:	Scripting Databases	Manually Copying Data	Changing Connection Strings
Backup 7/23/20:	backup_7_2020.zip