Start Learning for 100% Free – SQL Essential Training, Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for 2021, 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 Essential Training.
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.
This course was created by Bill Weinman. We are pleased to offer this training in our library.
Introduction
Understanding SQL
How to use the exercise files
Course overview
- Installation
Installing on Windows
Installing on a Mac - SQL Overview
About SQL
Database organization
The SELECT statement
Selecting rows
Selecting columns
Counting rows
Inserting data
Updating data
Deleting data - 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 - Relationships
Understanding JOIN
Accessing related tables
Relating multiple tables - Strings
About SQL strings
Finding the length of a string
Selecting part of a string
Removing spaces
Folding case - Numbers
Numeric types
What type is that value?
Integer division
Rounding numbers - Dates and Times
Dates and times
Date- and time-related functions - Aggregates
What are aggregates?
Using aggregate functions
Aggregating DISTINCT values - Transactions
What are transactions?
Data integrity
Performance - Triggers
Automating data with triggers
Preventing updates
Example: Timestamps - Views and Subselects
Creating a subselect
Searching within a result set
Creating a view
Creating a joined view - A Simple CRUD Application
Embedding SQL
The SELECT functions
The INSERT, UPDATE and DELETE functions
Free
