SQL Essential Training

SQL Essential Training

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 3 Hours | 454 MB

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.

Topics include:

  • How databases are organized
  • Selecting rows and columns
  • Creating new tables
  • Inserting and updating data
  • Sorting and filtering
  • Accessing related tables with JOIN
  • Working with strings
  • Understanding numeric types
  • Using aggregate functions and transactions
  • Automating data with triggers
  • Creating views
  • Using CRUD functions
Table of Contents

1 Understanding SQL
2 How to use the exercise files
3 Course overview
4 Installing on Windows
5 Installing on a Mac
6 About SQL
7 Database organization
8 The SELECT statement
9 Selecting rows
10 Selecting columns
11 Counting rows
12 Inserting data
13 Updating data
14 Deleting data
15 Creating a table
16 Deleting a table
17 Inserting rows
18 Deleting rows
19 The NULL value
20 Constraining columns
21 Changing a schema
22 ID columns
23 Filtering data
24 Removing duplicates
25 Ordering output
26 Conditional expressions
27 Understanding JOIN
28 Accessing related tables
29 Relating multiple tables
30 About SQL strings
31 Finding the length of a string
32 Selecting part of a string
33 Removing spaces
34 Folding case
35 Numeric types
36 What type is that value
37 Integer division
38 Rounding numbers
39 Dates and times
40 Date- and time-related functions
41 What are aggregates
42 Using aggregate functions
43 Aggregating DISTINCT values
44 What are transactions
45 Data integrity
46 Performance
47 Automating data with triggers
48 Preventing updates
49 Example Timestamps
50 Creating a subselect
51 Searching within a result set
52 Creating a view
53 Creating a joined view
54 Embedding SQL
55 The SELECT functions
56 The INSERT, UPDATE, and DELETE functions
57 Goodbye