This course is designed for those that are completely new to SQL or would like to brush up on their skills. If you don\'t yet know how you\'ll be using SQL in the future, if you\'ll go into analysis, development or anything else, this course is for you! We\'ll be using v2019 and start at the installation of SQL Server as well as the tools and databases we\'ll be using (SSMS and AdventureWorks, which is Microsoft\'s \"teaching\" database). The course has been designed with efficiency as a prime driver so we\'ll be talking a fair bit about what to do and what not to do as well as some theory on data storage, data types, etc so that you get an understanding of why certain things are the way they are rather than \"just do\". Apart from Section 7, the lectures are designed to be not too technical for beginners\' level, while S7 is a bit more technical but will be very beneficial for your better understanding of what is going on in the background.In terms of style/delivery: UK English, bit of added sarcasm (very minimal), generally cool and avoiding buzz. Also I tend to use \"you\" (\"if you have a look at this/do that\") rather us (\"let us do this/that\") in most cases. It\'s just to say some people prefer one or the other so you know what to expect. Furthermore I don\'t use \"I\'m going to go ahead and...\". Just saying. :)Course structure:1: Intro to SQL and SSMSWhats SQL, Uses, Dialects, Analysis, Development PurposesInstall SQL Server, SSMSQuick intro to SSMS Get AdventureWorksSettings & line numbers2: Data ConceptsData Concepts -- Tables, Views, Temp TablesData Concepts -- KeysData Concepts -- Stored ProcsData Types Short & NULL ValuesIndexes ShortBest Practices Naming, Coding (Tabs, 1=1, Using [], Etc.)3: Basic CommandsSELECT/DISTINCT & TOP ++ Where data goes (onto the screen that is.)WHERE, , =, !=, AND/OR/NOT, text () -- relation to indexesLIKE, %ORDER BY -- when not to use itGROUP BY & HAVINGUNION/UNION ALL/INTERSECT/EXCEPT JOINs4: Basic FunctionsCOUNTSUM, AVGMIN, MAXLENLTRIM/RTRIMUCASE/LCASESUBSTRINGCOALESCE5: Table OperationsCREATE TABLESELECT INTOALTER TABLE (drop col, add col, change data type, add index)  DROP TABLE vs DELETE FROM vs TRUNCATE6: Modifying DataINSERT (gui, manual, insert from elsewhere)UPDATE7: Tech Deep-Divesys tables for finding information   Data storageMore About HeapsMore About Indexes & Fragmentation