[frontendmasters.com] Sql Fundamentals

Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop.

In SQL Server 2008 Essential Training, Simon Allardice explores all the major features of SQL Server 2008 R2, beginning with core concepts: installing, planning, and building a first database. Explore how Transact-SQL is used to retrieve, update, and insert information, and gain insight into how to effectively administer databases. The course also covers features outside SQL Server’s database engine, including technologies that have grown up around it: SQL Server Reporting Services and Integration Services. Exercise files are included with the course.

In this course, author James Williamson offers a high-level overview of Cascading Style Sheets. This course explores the basic concepts, terminology, and tools of the language. Beginning with an exploration of CSS syntax, James explains how CSS modifies text, borders, backgrounds, and color; demonstrates CSS and HTML integration; and contextualizes the current state of CSS. The course also tours some of the most popular CSS editors and frameworks and lists online tools and resources for further study. This course is for people who want a big-picture overview before taking hands-on courses.

Gain an advanced understanding of difficult JavaScript concepts like closure, new, “this”, prototypical inheritance, type comparators, coercion, and delete.