by | Released July 2015 | ISBN: 0134193709

Almost 3 Hours of Video InstructionYour complete SQL video course: Master hands-on, real-world skills for working with data, tables, queries, and much more!DescriptionIn Learning SQL LiveLessons Ben Forta, the world's favorite SQL teacher, helps you master the core real-world skills you need to succeed with SQL. Drawing on his experience helping thousands of developers and other IT pros at all levels, Forta guides you from the absolute basics all the way to advanced queries, joins, and beyond. One step at a time, you'll learn how to retrieve data with SELECT; sort, filter, group, and summarize data; create calculated fields; manipulate data with string and date functions; build queries and subqueries; create basic and advanced table joins; combine queries with UNION; sort your queries; insert, update, and delete data; and even discover what you can do with triggers and stored procedures. Everything's organized into bite-sized, self-contained lessons, so you can learn key SQL skills quickly and easily.Skill LevelBeginnerIntermediateWhat You Will LearnRetrieve data using the SQL SELECT statementSort, filter, and manipulate dataCreate calculated fieldsGroup and summarize dataWork with subqueries and WHERE statementsUse basic and advanced table joinsCombine queries with UNION statementsInsert, update, and delete dataGet started with advanced SQL featuresWho Should Take This CourseEveryone who wants to master SQL to manage data, write queries, and/or build database applications with any modern relational databaseProfessional and casual developers at all levelsCourse RequirementsBasic experience using databases; no SQL experience necessaryLesson 1: Introducing SQLReview database basics such as tables, rows, columns, and keys; understand what relational databases are; choose a DBMS; and learn what SQL is and what it does.Lesson 2: Retrieving DataWork with SELECT, the most used SQL statement. Retrieve individual, multiple, or all columns; retrieve specific rows; and limit the data you retrieve. Master and refine some important SQL skills and best practices.Lesson 3: Sorting Retrieved DataUse SELECT ORDER BY, sort by one or multiple columns, and specify the direction of your sort.Lesson 4: Filtering DataUse SELECT WHERE and its clause operators, use BETWEEN to filter for a range of values, and use NULL to filter for no value.Lesson 5: Advanced Data FilteringCombine WHERE filters using AND and OR; correctly manage “order of evaluation”; use IN to filter by a defined set of matches; and negate clauses with NOT.Lesson 6: Using Wildcard FilteringCreate wildcard filters with the LIKE keyword, and learn three wildcards you can use to search for any character combinations.Lesson 7: Creating Calculated FieldsUse concatenation and aliases, and perform on-the-fly mathematical calculations using calculate fields and mathematical operators.Lesson 8: Using Data Manipulation FunctionsManipulate data with string and date functions.Lesson 9: Summarizing DataUse the aggregate functions AVG, COUNT, MAX, MIN, and SUM to summarize data, totals, averages, and more.Lesson 10: Grouping DataGroup data with the GROUP BY clause, and use the HAVING clause to filter by group rather than row.Lesson 11: Working with SubqueriesCreate powerful subqueries (queries passed to other queries) to filter rows in conjunction with WHERE and to return values to calculated fields.Lesson 12: Joining TablesMaster and compare two ways to create simple joins with keys. Then, learn how to join multiple tables.Lesson 13: Creating Advanced JoinsUse table aliases, self-joins, and outer joins, and combine joins with aggregate functions.Lesson 14: Combining QueriesUse UNION to combine query result sets from multiple SELECT statements, include or exclude duplicate rows, and use ORDER BY to sort the queries you've combined.Lesson 15: Inserting DataInsert rows or retrieved data, avoid unsafe ways to use the INSERT statement, master best practices to prevent accidental data changes or deletion, and copy data to another table.Lesson 16: Updating and Deleting DataUpdate and delete table rows. Master UPDATE and DELETE best practices to make sure you don't inadvertently change or delete data that should remain intact.Lesson 17: Where to Go from HereDiscover what can be done with advanced features such as views, stored procedures, triggers, constraints, and transactions.About LiveLessons Video TrainingLiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at http://www.informit.com/livelessons. Show and hide more

1. Introduction
   • Learning SQL LiveLessons: Introduction 00:02:10
2. Lesson 1: Introducing SQL
   • Learning Objectives 00:00:44
   • 1.1 Review database basics 00:06:58
   • 1.2 Choose a DBMS 00:03:03
   • 1.3 Get ready to learn SQL 00:00:35
3. Lesson 2: Retrieving Data
   • Learning Objectives 00:00:40
   • 2.1 Use the SELECT statement 00:01:14
   • 2.2 Retrieve individual columns 00:02:24
   • 2.3 Retrieve multiple columns 00:01:11
   • 2.4 Retrieve all columns 00:01:55
   • 2.5 Retrieve distinct rows 00:01:06
   • 2.6 Limit retrieved data 00:01:53
   • 2.7 Refine your SQL skills 00:05:25
   • Summary 00:00:50
4. Lesson 3: Sorting Retrieved Data
   • Learning Objectives 00:00:20
   • 3.1 Use ORDER BY 00:01:49
   • 3.2 Sort by one column 00:01:28
   • 3.3 Sort by multiple columns 00:02:39
   • 3.4 Specify sort direction 00:01:38
   • Summary 00:00:42
5. Lesson 4: Filtering Data
   • Learning Objectives 00:00:27
   • 4.1 Use WHERE 00:01:21
   • 4.2 Use WHERE clause operators 00:04:28
   • 4.3 Filter using a range 00:01:05
   • 4.4 Filter for no value 00:01:59
   • Summary 00:01:16
6. Lesson 5: Advanced Data Filtering
   • Learning Objectives 00:00:30
   • 5.1 Combine WHERE clauses 00:03:01
   • 5.2 Understand order of evaluation 00:03:37
   • 5.3 Filter using IN 00:02:02
   • 5.4 Negate using NOT 00:01:19
   • Summary 00:00:48
7. Lesson 6: Using Wildcard Filtering
   • Learning Objectives 00:00:21
   • 6.1 Filter using LIKE 00:07:38
   • Summary 00:00:47
8. Lesson 7: Creating Calculated Fields
   • Learning Objectives 00:00:34
   • 7.1 Use concatenation 00:03:41
   • 7.2 Use aliases 00:02:18
   • 7.3 Perform mathematical calculations 00:02:01
   • Summary 00:00:39
9. Lesson 8: Using Data Manipulation Functions
   • Learning Objectives 00:00:33
   • 8.1 Use string functions 00:04:03
   • 8.2 Use date functions 00:03:10
   • Summary 00:00:51
10. Lesson 9: Summarizing Data
    • Learning Objectives 00:00:28
    • 9.1 Use aggregate functions 00:05:50
    • Summary 00:00:38
11. Lesson 10: Grouping Data
    • Learning Objectives 00:00:28
    • 10.1 Use GROUP BY 00:02:57
    • 10.2 Use HAVING 00:03:34
    • Summary 00:00:46
12. Lesson 11: Working with Subqueries
    • Learning Objectives 00:00:35
    • 11.1 Use subqueries with WHERE 00:04:52
    • 11.2 Use subqueries as calculated fields 00:02:47
    • Summary 00:00:47
13. Lesson 12: Joining Tables
    • Learning Objectives 00:00:29
    • 12.1 Create a basic join 00:05:38
    • 12.2 Join multiple tables 00:02:32
    • Summary 00:00:40
14. Lesson 13: Creating Advanced Joins
    • Learning Objectives 00:00:33
    • 13.1 Use table aliases 00:02:33
    • 13.2 Create a self-join 00:03:08
    • 13.3 Create an outer join 00:02:53
    • 13.4 Use joins with aggregate functions 00:01:47
    • Summary 00:00:45
15. Lesson 14: Combining Queries
    • Learning Objectives 00:00:31
    • 14.1 Use a UNION 00:02:58
    • 14.2 Include/exclude duplicates 00:01:17
    • 14.3 Sort combined queries 00:01:20
    • Summary 00:00:46
16. Lesson 15: Inserting Data
    • Learning Objectives 00:00:34
    • 15.1 Insert a row 00:02:49
    • 15.2 Insert retrieved data 00:01:19
    • 15.3 Copy to another table 00:01:04
    • Summary 00:00:50
17. Lesson 16: Updating and Deleting Data
    • Learning Objectives 00:00:27
    • 16.1 Update a row 00:02:39
    • 16.2 Delete a row 00:01:06
    • Summary 00:01:37
18. Lesson 17: Where to Go from Here
    • Learning Objectives 00:00:36
    • 17.1 Understand table manipulation 00:03:34
    • 17.2 Understand views 00:01:51
    • 17.3 Understand stored procedures 00:01:34
    • 17.4 Be familiar with a few more 00:04:42
    • Summary 00:00:20
19. Summary
    • Learning SQL LiveLessons: Summary 00:00:56
Show and hide more