Learn SQL from Stanfords Free Online “Introduction to Databases” Course
Want to learn something new? Stanford’s world-renowned School of Engineering is offering a free “Introduction to Databases” online course, available to anyone worldwide. The class will cover relational databases, XML data, relational algebra, SQL, and database design with UML, here’s the full course description:
This course covers database design and the use of database management systems for applications. It includes extensive coverage of the relational model, relational algebra, and SQL. It also covers XML data including DTDs and XML Schema for validation, and the query and transformation languages XPath, XQuery, and XSLT. The course includes database design in UML, and relational design principles based on dependencies and normal forms. Many additional key database topics from the design and application-building perspective are also covered: indexes, views, transactions, authorization, integrity constraints, triggers, on-line analytical processing (OLAP), and emerging “NoSQL” systems.
Sign up for Stanford Universities free “Introduction to Databases” class here
The course assumes no prior knowledge in SQL or database structures, but obviously a fair amount of computer aptitude is recommended. The program runs from October 10 to December 12, and students have full access to lecture videos and are given assignments and exams. This isn’t a hands off course though, you’ll actually receive regular feedback on your progress, and there’s also a discussion forum for students to engage in. You won’t be getting any Stanford or college credit, but if you pass the class you will get a ‘statement of accomplishment’ from the Stanford instructor.
If databases aren’t your thing, don’t forget that Stanford also offers a variety of excellent free iOS development classes online too.
Any idea when are then going to offer it next time
Here’s a couple more if you like.
Artificial Intelligence
http://www.ai-class.com/
iTunes U
http://www.apple.com/education/itunes-u/
Same program is offering a Intro to Machine Learning course
http://www.ml-class.org/course/auth/welcome
“This course provides a broad introduction to machine learning, datamining, and statistical pattern recognition. Topics include: (i) Supervised learning (parametric/non-parametric algorithms, support vector machines, kernels, neural networks). (ii) Unsupervised learning (clustering, dimensionality reduction, recommender systems, deep learning). (iii) Best practices in machine learning (bias/variance theory; innovation process in machine learning and AI). (iv) Reinforcement learning. The course will also draw from numerous case studies and applications, so that you’ll also learn how to apply learning algorithms to building smart robots (perception, control), text understanding (web search, anti-spam), computer vision, medical informatics, audio, database mining, and other areas.”