We start learning SQL with the most of basic structures — selecting one or more fields from one or more tables.
Download the class notes for day one.
Computer Programming
Large collection of Free Microsoft eBooks for you
Large collection of Free Microsoft eBooks for you, including: SharePoint, Visual Studio, Windows Phone, Windows 8, Office 365, Office 2010, SQL Server 2012, Azure, and more.
https://blogs.msdn.microsoft.com/mssmallbiz/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more/
Another large collection of Free Microsoft eBooks and Resource Kits for you, including: SharePoint 2013, Office 2013, Office 365, Duet 2.0, Azure, Cloud, Windows Phone, Lync, Dynamics CRM, and more.
https://blogs.msdn.microsoft.com/mssmallbiz/2012/07/30/another-large-collection-of-free-microsoft-ebooks-and-resource-kits-for-you-including-sharepoint-2013-office-2013-office-365-duet-2-0-azure-cloud-windows-phone-lync-dynamics-crm-and-more/
Intro to SQL
Textbook References:
Textbook: Beginning Microsoft SQL Server 2012 Programming
ISBN: 978-1-1181-0228-2
Authors: Paul Atkinson, Robert Vieira
Software Requirements:
SQL Server Express Edition 2014 (free)
https://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx
AdventureWorks Sample Databases and Scripts for SQL Server 2016 CTP3 (free)
http://msftdbprodsamples.codeplex.com/
whoami
Taking a little a joke from Unix, the whoami command (folvera@foo:~/whoami) returns who the user is.
I’ve been a systems programmer at BMCC for 13 years. I’ve also been an computer science instructor for 17 years — starting with DOS, writing batch files and other technologies working with Apache web servers via my personal website. I’ve recently returned to teach at BMCC — mainly SQL (structured query language).
I’m also an open source advocate and Unix enthusiast. My main system currently runs Ubuntu 14.04 LTS (Trusty Tahr).
Hello world!
Welcome to F.Olvera @ CUNY Academic Commons
class HelloWorld
def yourName(name)
@name = name.capitalize
end
def sayHi
puts "Hello #{@name}!"
end
end
helloThere = HelloWorld.new("World")
helloThere.sayHi
