Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

SQL Essential Training

via LinkedIn Learning

Overview

Learn how to use SQL to manage your database. Explore beginner-level tutorials on creating tables, defining relationships, and manipulating strings with SQL and SQLiteStudio.

Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for 2019, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. All the lessons have been recorded in SQLiteStudio, an intuitive and easy-to-install database manager. Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple application using SQL.

This course was created by Bill Weinman. We are pleased to offer this training in our library.

Syllabus

Introduction
  • Understanding SQL
  • How to use the exercise files
  • Course overview
1. Installation
  • Installing on Windows
  • Installing on a Mac
2. SQL Overview
  • About SQL
  • Database organization
  • The SELECT statement
  • Selecting rows
  • Selecting columns
  • Counting rows
  • Inserting data
  • Updating data
  • Deleting data
3. Fundamental Concepts
  • Creating a table
  • Deleting a table
  • Inserting rows
  • Deleting rows
  • The NULL value
  • Constraining columns
  • Changing a schema
  • ID columns
  • Filtering data
  • Removing duplicates
  • Ordering output
  • Conditional expressions
4. Relationships
  • Understanding JOIN
  • Accessing related tables
  • Relating multiple tables
5. Strings
  • About SQL strings
  • Finding the length of a string
  • Selecting part of a string
  • Removing spaces
  • Folding case
6. Numbers
  • Numeric types
  • What type is that value?
  • Integer division
  • Rounding numbers
7. Dates and Times
  • Dates and times
  • Date- and time-related functions
8. Aggregates
  • What are aggregates?
  • Using aggregate functions
  • Aggregating DISTINCT values
9. Transactions
  • What are transactions?
  • Data integrity
  • Performance
10. Triggers
  • Automating data with triggers
  • Preventing updates
  • Example: Timestamps
11. Views and Subselects
  • Creating a subselect
  • Searching within a result set
  • Creating a view
  • Creating a joined view
12. A Simple CRUD Application
  • Embedding SQL
  • The SELECT functions
  • The INSERT, UPDATE, and DELETE functions
Conclusion
  • Goodbye

Taught by

Bill Weinman

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of SQL Essential Training

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free