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

—————
Subtitles
Full pack

More training courses

@freeTrainingCourse