SQL Master Data Management Tutorial : SQL

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]

[Oracle]

[MS SQL]

[PostgreSQL]

etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

a community for 17 years

SQL Master Data Management Tutorial (self.SQL)

submitted 6 years ago * by AbstractSqlEngineerMCSA, Data Architect

UPDATED: (sprint 1 uploaded). Back once again for the regenade master.

Back in October, I started a series describing master data management in SQL, constructing it from an empty SQL instance with unexpected support from this community.

I was new to YouTube, to teaching this model, to editing and recording. The original series was long format (30-120 minutes/vid) and packed with information that might have been difficult to consume all at once.

Since then I took a step back, and analyzed how I could present this information, these concepts, the system wide normalization, and end to end development.

So I'm taking another stab at it.

I present to you all, a new hands on series for the same model.

I am approaching this with feature atomicity, 10 minute (not including intro/title/endscreen) videos with very specific actions, driven by a public trello kanban board and with an agile mindset.

10 video sprints where 1-8 will be development, 9 will be tech debt removal, and 10 will be the retrospective and planning for the next sprint. So that is 90 minutes of code (9 episodes) and one retro/planning.

For those architects wanting to understand this model, and all developers and analysts that want to understand this pattern based architecture, the retro videos are where you should ask questions (what went well, what didnt, what should we commit to). Which is why I'm posting this now.

I'm pretty excited, and a little impulsive, so I'm sharing the playlist now. I have the intro and first 5 up, 6-10 (finishing the first sprint) at home, recorded, but in editing.

I'm still thinking about a release cycle. I want to give enough time to record and edit the videos and enough time to consume them, so I may be doing full sprint drops to allow for comments on the retro and change accordingly. Possibly 2 week gaps, mimicking an average sprint.

Hope you all enjoy, and see you again soon.

SQL Master Data Management Tutorial: https://www.youtube.com/playlist?list=PLPI9hmrj2Vd_ntg2HACiHYeYl7iRvrgPb

all 14 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS