Infinite Skills Learning SQL

/01. Getting Started With Databases And SQL/

01_01-Relational Databases And Key Terms Explained.mp4

01_02-About The Author.mp4

01_03-What Are The SQL Commands.mp4

01_04-Select Syntax And Examples.mp4

01_05-Where Can I Use SQL.mp4

01_06-Installing Sample Databases And Working Files.mp4

01_07-How To Access Your Working Files.mp4

/02. Using SQL To Select And Filter Data/

02_01-Using Select To View Data.mp4

02_02-Sorting The Data.mp4

02_03-Adding A Where Clause To Filter Data.mp4

02_04-Filtering Date Columns.mp4

02_05-Working With Null Or Empty Values.mp4

02_06-Using Comments Within SQL.mp4

02_07-Use Of Wildcards In Filtering.mp4

02_08-Multiple Criteria Using And Or In.mp4

/03. Functions, Grouping And Summarizing/

03_01-Add A Calculating Column To A SQL Statement.mp4

03_02-Text Manipulation Functions.mp4

03_03-Differences In Date Functions Within SQL.mp4

03_04-Calculating Age.mp4

03_05-Concatenate Data Columns.mp4

/04. Joining Tables/

04_01-Which Tables Can I Join And How.mp4

04_02-Joining More Than Two Tables.mp4

04_03-Using Different Join Types.mp4

04_04-The Special Cross Or Cartesian Join.mp4

04_05-Group And Summaries Within Joined Table SQL.mp4

/05. Data Modification/

05_01-Amend Data In Tables.mp4

05_02-Adding Data To Tables With Insert.mp4

05_03-Removing Data From Tables.mp4

/06. Creating And Altering Database Objects/

06_01-Create A New Table.mp4

06_02-Changing A Tables Structure.mp4

06_03-What Is A View And How To Create One.mp4

06_04-Alter Or Delete A View.mp4

/07. SQL Summary/

07_01-The Main Variances In SQL Between Databases.mp4

07_02-The Powerful Subquery.mp4

/08. Conclusions/

08_01-Wrap Up.mp4

/Working Files/

Learning_SQL_Working_Files.zip

Total files 36