Related Courses
| Unit 01: Course and Instructor Introduction | |||
| Course and Instructor Introduction | 00:05:00 | ||
| Unit 02: Laying out the foundation - Overview & Installation | |||
| Pre-requisites & Different Editions of SQL Server | 00:06:00 | ||
| Downloading Express Edition & sample database | 00:03:00 | ||
| Installing the downloads & Configuration | 00:19:00 | ||
| The sa Login | 00:04:00 | ||
| Wrap up – what we went over! | 00:01:00 | ||
| Unit 03: Core concepts - Taming the RDBMS beast! | |||
| What is RDBMS? | 00:12:00 | ||
| Where does SQL Server fit in? | 00:02:00 | ||
| Basic database objects | 00:16:00 | ||
| Different Files that got installed – MDF & LDF | 00:03:00 | ||
| Wrap up – what we went over! | 00:01:00 | ||
| Unit 04: Tool of the trade - SQL Server Management Studio | |||
| Getting started with SSMS | 00:07:00 | ||
| Getting around Object Explorer | 00:05:00 | ||
| Query Window | 00:06:00 | ||
| Pre-built DB – system database | 00:04:00 | ||
| Wrap up – what we went over! | 00:01:00 | ||
| Unit 05: Simple SELECT | |||
| Bare Minimum: SELECTING a literal | 00:06:00 | ||
| Retrieving / querying data from a table – using FROM clause | 00:06:00 | ||
| Playing with Column Names | 00:03:00 | ||
| Rearranging columns to your liking | 00:01:00 | ||
| Wrap up – what we went over! | 00:01:00 | ||
| Unit 06: Filtering out unwanted data | |||
| Narrowing down and ordering result set – WHERE and ORDER clause | 00:17:00 | ||
| Narrowing down result set – BETWEEN / NOT BETWEEN | 00:09:00 | ||
| Narrowing down result set – IN and NOT IN operator | 00:05:00 | ||
| Narrowing down result set – Pattern Matching: LIKE and Wildcards | 00:11:00 | ||
| Wrap up – what we went over! | 00:01:00 | ||
| Unit 07: Expressions and Functions | |||
| Dealing with nothing: NULL | 00:06:00 | ||
| Working with strings: Concatenation and other string functions | 00:15:00 | ||
| Working with dates: Date Functions | 00:07:00 | ||
| Some System Functions | 00:05:00 | ||
| Wrap up – what we went over! | 00:02:00 | ||
| Unit 08: Getting data out of multiple tables | |||
| Joining multiple tables – INNER JOIN | 00:09:00 | ||
| Join types – OUTER JOIN – LEFT / RIGHT / FULL | 00:08:00 | ||
| Join types – CROSS JOIN | 00:02:00 | ||
| Holy UNION! | 00:03:00 | ||
| Subqueries | 00:04:00 | ||
| Wrap up – what we went over! | 00:02:00 | ||
| Unit 09: Summarizing and Grouping data | |||
| DISTINCT and ALL Predicates | 00:02:00 | ||
| Aggregate Functions | 00:03:00 | ||
| GROUP BY clause / HAVING clause | 00:04:00 | ||
| WHERE and ORDER BY in aggregate queries | 00:04:00 | ||
| Wrap up – what we went over! | 00:01:00 | ||
| Unit 10: Bonus | |||
| Bonus_Section | 00:01:00 | ||
No Reviews found for this course.