SQL Training DVDCareerVision Training
£ 72 - (Rs 5,870)
- Distance learning
What you'll learn on the course
Creating new tables
• Format: Download
• Duration: 3.5 hours (35 lessons)
• Instructor: Guy Vaccaro
• Platform: Windows PC or Mac
• Date Released 2014-04-02
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.
01. Getting Started With Databases And SQL Relational Databases And Key Terms Explained About The Author What Are The SQL Commands Select Syntax And Examples Where Can I Use SQL? Installing Sample Databases And Working Files 0107 How To Access Your Working Files 02. Using SQL To Select And Filter Data 0201 Using Select To View Data 0202 Sorting The Data 0203 Adding A Where Clause To Filter Data 0204 Filtering Date Columns 0205 Working With Null Or Empty Values 0206 Using Comments Within SQL 0207 Use Of Wildcards In Filtering 0208 Multiple Criteria Using And Or In 03. Functions, Grouping And Summarizing 0301 Add A Calculating Column To A SQL Statement 0302 Text Manipulation Functions 0303 Differences In Date Functions Within SQL 0304 Calculating Age 0305 Concatenate Data Columns 04. Joining Tables 0401 Which Tables Can I Join And How? 0402 Joining More Than Two Tables 0403 Using Different Join Types 0404 The Special Cross Or Cartesian Join 0405 Group And Summaries Within Joined Table SQL 05. Data Modification 0501 Amend Data In Tables 0502 Adding Data To Tables With Insert 0503 Removing Data From Tables 06. Creating And Altering Database Objects 0601 Create A New Table 0602 Changing A Tables Structure 0603 What Is A View And How To Create One 0604 Alter Or Delete A View 07. SQL Summary 0701 The Main Variances In SQL Between Databases 0702 The Powerful Subquery 08. Conclusions 0801 Wrap Up