In this SQL training course, expert author Guy Vaccaro teaches you how to use SQL to manage data that is held in relational databases. This training course is designed for beginners who have no previous experience with SQL of any kind. Guy uses Microsoft SQL Server as an example platform, while keeping the SQL query examples applicable to any modern relational database.
You will start by learning how to use SQL (Structured Query Language) to select and filter data from a database, including sorting the data, filtering date columns, and working with null or empty values. Guy then teaches you about common SQL functions, such as text manipulation, and how to group and summarize. This video tutorial also covers topics such as joining tables, data modification, and creating new tables and views. Finally, you will learn about the powerful subquery, and the main variances in SQL between database types.
Once you have completed this computer based training course, you will have a fundamental knowledge of what SQL is and how you can apply it to different database types. Working files are included, allowing you to follow along with the author throughout the lessons.
Table of Contents
- Getting Started With Databases And SQL
- Using SQL To Select And Filter Data
- Functions, Grouping And Summarizing
- Joining Tables
- Data Modification
- Creating And Altering Database Objects
- SQL Summary
- Wrap Up 00:05:14
- Title: Learning SQL
- Release date: March 2014
- Publisher(s): Infinite Skills
- ISBN: 9781771372237