Media is too big
VIEW IN TELEGRAM
Strategic thinking is an ongoing process
This media is not supported in your browser
VIEW IN TELEGRAM
Make strategic thinking a habit
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
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
Telegram
Free Training Courses
Understanding SQL
This media is not supported in your browser
VIEW IN TELEGRAM
How to use the exercise files
This media is not supported in your browser
VIEW IN TELEGRAM
Course overview
This media is not supported in your browser
VIEW IN TELEGRAM
Database organization
This media is not supported in your browser
VIEW IN TELEGRAM
The SELECT statement
This media is not supported in your browser
VIEW IN TELEGRAM
Selecting rows
This media is not supported in your browser
VIEW IN TELEGRAM
Selecting columns
This media is not supported in your browser
VIEW IN TELEGRAM
Inserting data
This media is not supported in your browser
VIEW IN TELEGRAM
Creating a table