Lynda Sql

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.

Learn how to query data from SQL Server tables. Microsoft Certified Trainer Gerry O'Brien reviews the history of SQL and relational theory, so you'll understand exactly where this data manipulation language, and Microsoft's seminal database program, got their starts.

SQL Server is Microsoft's de facto relational database software.

Discover how to use Structured Query Language (SQL) to tackle the often highly complex task of working with databases.

At one point Access was adequate. But what happens when your database grows and you need more powerful tools? You can move it! Migration allows you to take advantage of SQL Server's advanced features, and maintain a link to the data in Access. Watch this course to learn how to leverage what you already know to take that next step. Adam Wilbert reviews the basics of SQL Server Management Studio (SSMS) and introduces two workflows for migrating Access data: one using a simple export/import process and the other using the free SQL Server Migration Assistant (SSMA).

SQL Server is the database used with Azure and many on-premises environments and is quickly becoming a very popular RDBMS.

SQL Server can be intimidating, especially for people who have never worked with databases before.

SQL Server supports mission-critical applications and big data solutions—without having to buy expensive add-ons or high-end appliances.

There is an increasing need for data scientists and analysts to understand relational data stores.