SQLZOO Learn SQL using: SQL Server, Oracle, MySQL, DB2, and PostgreSQL. Reference: how to... How to read the data from a database. 2 CREATE and DROP How to create tables, indexes, views and other things. 3 INSERT and DELETE How to put records into a table, change them and how to take them out again. 4 DATE and TIME How to work with dates; adding, subtracting and formatting. 5 Functions How to use string functions, logical functions and mathematical functions. 6 Users How to create users, GRANT and DENY access, get at other peoples tables. 7 Meta Data How to find out what tables and columns exist. 8 SQL Hacks Some SQL Hacks, taken from "SQL Hacks" published by O'Reilly 9 Using SQL with PHP on Amazon EC2 servers Video tutorials showing how to run MySQL, PHP and Apache on Amazon's EC2 cloud servers. 10 An introduction to transactions Video tutorials showing how sessions can interfere with each other and how to stop it. 11 Using SQL with C# in Visual Studio
What every computer science major should know Portfolio versus resume Having emerged from engineering and mathematics, computer science programs take a resume-based approach to hiring off their graduates. A resume says nothing of a programmer's ability. Every computer science major should build a portfolio. A portfolio could be as simple as a personal blog, with a post for each project or accomplishment. A better portfolio would include per-project pages, and publicly browsable code (hosted perhaps on github or Google code). Contributions to open source should be linked and documented. A code portfolio allows employers to directly judge ability. GPAs and resumes do not. Professors should design course projects to impress on portfolios, and students, at the conclusion of each course, should take time to update them. Examples Technical communication Lone wolves in computer science are an endangered species. Modern computer scientists must practice persuasively and clearly communicating their ideas to non-programmers. Specific recommendations Java
App Inventor Get Started Follow these simple directions to build your first app! Tutorials Step-by-step guides show you how to create even more apps. Teach Find out about curriculum and resources for teachers. Forums Join community forums to get answers to your questions. Algorithmist GitHut - Programming Languages and GitHub newfinancepage.html Scott Burton Financial Software Projects Graduate Division - Computer Science Tuesday 7:10-9:00 WWH Room WWH 3 This course will be taught by a veteran Wall St. technology manager currently employed at a top tier investment bank. The theme of this course will be “applied case study” and will focus on Fixed Income markets. Pre-requisites: It is assumed that the students can code in C++ or C for the server side. No prior experince in the financial sector is required - just a desire to learn it. Reference Materials: Software Engineering: Soul of a New Machine - Tracy Kidder The Mythical Man - Month - Fred Brooks (this is the only text students will need to purchase) Application Domain: (should be available in library): The Handbook of Global Fixed Income Calculations - Dragomir Krgin The Money Markets - Marcia Stigum Security Analysis - Graham and Dodd Handouts Course Objectives: 1. 2. 3. 4. 5. 6. Grading policy: The final project will be a working app built using the library submitted at mid-term.
Stack Overflow Advanced Data Structures (6.851) Prof. Erik Demaine TAs: Tom Morgan, Justin Zhang [Home] [Lectures] [Assignments] [Project] [Problem Session] Data structures play a central role in modern computer science. You interact with data structures even more often than with algorithms (think Google, your mail server, and even your network routers). In addition, data structures are essential building blocks in obtaining efficient algorithms. Specifics Lecture time: Tuesday & Thursday 11–12:30 First lecture: Tuesday, February 7, 2012 Lecture room: 4-163 Units: 3-0-9, H-level & EC credit Registration: Subscribe to 6851-students mailing list on the web. Prerequisites The required prerequisite is 6.046, Design and Analysis of Algorithms or an equivalently thorough undergraduate algorithms class from another school (e.g., covering much of CLRS). Grading There are three requirements, other than attending lectures: Scribing one, maybe two, lectures. LaTeX Help Homework solutions, scribe notes, and final projects must be typeset in LaTeX.
All Sites Stack Overflow Stack Overflow Q&A for professional and enthusiast programmers Server Fault Server Fault Q&A for system and network administrators Super User Super User Q&A for computer enthusiasts and power users Meta Stack Exchange Meta Stack Exchange Q&A for meta-discussion of the Stack Exchange family of Q&A websites Web Applications Stack Exchange Web Applications Stack Exchange Q&A for power users of web applications Arqade Arqade Q&A for passionate videogamers on all platforms Webmasters Stack Exchange Webmasters Stack Exchange Q&A for pro webmasters Seasoned Advice Seasoned Advice Q&A for professional and amateur chefs Game Development Stack Exchange Game Development Stack Exchange Q&A for professional and independent game developers Photography Stack Exchange Photography Stack Exchange Q&A for professional, enthusiast and amateur photographers Cross Validated Cross Validated Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization Mathematics Stack Exchange
CS 61A Home Page Course Resources Contest Results You have selected the winners of the Recursion Exposition! Here they are: The results from the Pig contest are in! Our top finishers out of 34 entries: Other Useful Information Course Schedule About Viewing Documents Course documents available through these Web pages are either plain text files, Postscript files, or PDF (Portable Document Format) files.
Fisher-Price's Cute New Toy Aims to Teach Preschoolers the Basics of Computer Programming This article was updated on Jan. 6, 2015, at 1:08 p.m. ET. Bill Gates was 13 when he started to code. Elon Musk was 12 and Mark Zuckerberg was 10. Today, there’s no shortage of books, toys, classes and camps to nudge the next generation of coders along the path to promising careers in technology. Related: Your Next Vision Exam May Involve Playing Video Games Not to be left out of the tiny tot tech toy trend, news arrived today that Fisher-Price is finally joining the race. The colorful plastic toy -- which features an adorable motorized head, twists and turns from side to side and lights up -- is called the Think & Learn Code-A-Pillar. The interlocking segmented gizmo won’t exactly educate preschool kids on the specific intricate nuances of writing code, but it will expose them to a handful of simple computer coding gateway skills overall. Related: 12 Sites That Will Teach You Coding for Free Related: Meet Dash and Dot, Robot Toys That Teach Kids How to Code Limited Time Offer
MadCode: Escola de Programação e Robótica para Crianças e Adolescentes, de 05 a 17 anos de idade. | MadCode: Escola de Programação e Robótica para Crianças e Adolescentes, de 05 a 17 anos de idade. Learn Python The Hard Way With the help of this book, you will do the incredibly simple things that all programmers do to learn a programming language: Go through each exercise.Type in each sample exactly.Make it run. That's it. This will be very difficult at first, but stick with it. This book's job is to teach you the three most essential skills that a beginning programmer needs to know: reading and writing, attention to detail, and spotting differences. If you have a problem typing, you will have a problem learning to code, and especially if you have a problem typing the fairly odd characters in source code. Typing the code samples and getting them to run will help you learn the names of the symbols, get familiar with typing them, and get you reading the language. The one skill that separates bad programmers from good programmers is attention to detail. By going through this book, and copying each example exactly, you will be training your brain to focus on the details of what you are doing, as you are doing it.