SQL Essential Training

SQL Essential Training
SQL Essential Training

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 3h 17m | 348 MB
eLearning | Skill level: All Levels


Whatever database application you create—whether it’s for bookkeeping, sales, inventory, or even the lowly to-do list—it’s all about the data. Completely updated for 2018, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. 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 and complete database application using SQL.

Topics include:

  • Understanding SQL terminology and syntax
  • Creating new tables
  • Inserting and updating data
  • Writing basic SQL queries
  • 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
  • Defining functions in PHP
+ Table of Contents

Introduction
1 Welcome
2 Exercise files
3 Course overview

Installation
4 Installing on Windows – Part I
5 Installing on Windows – Part II
6 Installing on a Mac – Part I
7 Installing on a Mac – Part II

SQL Overview
8 About the overview
9 Database organization
10 The SELECT statement
11 Selecting rows
12 Selecting columns
13 Counting rows
14 Inserting data
15 Updating data
16 Deleting data

Fundamental Concepts
17 Creating a table
18 Deleting a table
19 Inserting rows
20 Deleting rows
21 The NULL value
22 Constraining columns
23 Changing a schema
24 ID columns
25 Filtering data
26 Removing duplicates
27 Ordering output
28 Conditional expressions

Relationships
29 Understanding JOIN
30 Accessing related tables
31 Relating multiple tables

Strings
32 About SQL strings
33 Finding the length of a string
34 Selecting part of a string
35 Removing spaces
36 Folding case

Numbers
37 Numeric types
38 What type is that value
39 Integer division
40 Rounding numbers

Dates and Times
41 Dates and times
42 Date- and time-related functions

Aggregates
43 What are aggregates
44 Using aggregate functions
45 Aggregating DISTINCT values

Transactions
46 What are transactions
47 Data integrity
48 Performance

Triggers
49 Automating data with triggers
50 Preventing updates
51 Example – Timestamps

Views and Subselects
52 Creating a subselect
53 Searching within a result set


Download from Turbobit

Download from DepositFiles

Download from Rapidgator