Developer's T-SQL Playbook
Pluralsight
Course Summary
Learn the essential SQL Skills any developer needs.
-
+
Course Description
You've been working with data, but don't know SQL. You have a plane ride to catch up and learn what you need to know - that's the focus of this course.
-
+
Course Syllabus
Introduction- 2m 30s
—Introduction 2m 30sWorking with Tables- 32m 45s
—Creating a Table 3m 42s
—Primary Keys: Integer 2m 52s
—Primary Keys: GUID 1m 47s
—Primary Keys: Auto-incrementing 3m 14s
—Tangent: Choosing a Primary Key 4m 31s
—Composite Keys 3m 23s
—Defining Columns 2m 26s
—Basic Column Constraints 6m 5s
—Column Defaults 1m 49s
—Naming Conventions 2m 51sWorking with Data- 12m 39sQuerying Data- 9m 54sJoining Tables- 10m 25sFiltering, Sifting, and Sorting Data- 8m 28sAggregates and Analysis- 12m 11sMany to Many and Self-referencing Relationships- 16m 51sEssential String and Date Functions- 21m 6s
This course is listed under
Data & Information Management
Community
Related Posts: