Make time to be strategic

Consider the future and learn from the past

How to create an informed strategy

Practicality Get real about your strategy

Strategic thinking with your team

Measure your success

Strategic thinking is an ongoing process

The limits of strategy

Make strategic thinking a habit

Subnoscripts

Full pack
All parts individually • GDriveLink

@freeTrainingCourse

SQL Essential Training

01 - Understanding SQL
- Understanding SQL
- How to use the exercise files
- Course overview

02 - Installation
- Installing on Windows
- Installing on a Mac

03 - SQL Overview
- About SQL
- Database organization
- The SELECT statement
- Selecting rows
- Selecting columns
- Counting rows
- Inserting data
- Updating data
- Deleting data

04 - 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

05 - Relationships
- Understanding JOIN
- Accessing related tables
- Relating multiple tables

06 - Strings
- About SQL strings
- Finding the length of a string
- Selecting part of a string
- Removing spaces
- Folding case

07 - Numbers
- Numeric types
- What type is that value
- Integer division
- Rounding numbers

08 - Dates and Times
- Dates and times
- Date- and time-related functions

09 - Aggregates
- What are aggregates
- Using aggregate functions
- Aggregating DISTINCT values

10 - Transactions
- What are transactions
- Data integrity
- Performance

11 - Triggers
- Automating data with triggers
- Preventing updates
- Example Timestamps

12 - Views and Subselects
- Creating a subselect
- Searching within a result set
- Creating a view
- Creating a joined view

13 - A Simple CRUD Application
- Embedding SQL
- The SELECT functions
- The INSERT, UPDATE, and DELETE functions

14 - Conclusion
- Goodbye

—————
Subnoscripts
Full pack

More training courses

@freeTrainingCourse

Understanding SQL

How to use the exercise files

Course overview

Installing on Windows

Installing on a Mac

About SQL

Database organization

The SELECT statement

Selecting rows