1
00:00:00,562 --> 00:00:02,470
Hey, what's up, Gurus?

2
00:00:02,470 --> 00:00:06,020
Welcome to today's lesson on programming,

3
00:00:06,020 --> 00:00:08,650
and specifically, the programming background that you need

4
00:00:08,650 --> 00:00:11,123
in order to pass the DP-203.

5
00:00:12,730 --> 00:00:13,563
So in the lesson,

6
00:00:13,563 --> 00:00:15,979
we are going to be focusing on a few things.

7
00:00:15,979 --> 00:00:19,490
First, programming. Hey, it's in the title.

8
00:00:19,490 --> 00:00:22,520
And you'll see code snippets as we move through the course,

9
00:00:22,520 --> 00:00:24,330
such as the one in orange here.

10
00:00:24,330 --> 00:00:26,510
Now this code snippet is very important.

11
00:00:26,510 --> 00:00:30,080
It's actually the code snippet to make a smiley face.

12
00:00:30,080 --> 00:00:32,600
So not going to be important for the DP-203,

13
00:00:32,600 --> 00:00:33,908
but we're going to be talking about

14
00:00:33,908 --> 00:00:35,183
what you do need to know.

15
00:00:36,270 --> 00:00:40,650
Along those lines, we are only focusing on the DP-203

16
00:00:40,650 --> 00:00:42,890
and what you really need to know,

17
00:00:42,890 --> 00:00:44,640
not necessarily what you need to know

18
00:00:44,640 --> 00:00:46,800
to be a competent data engineer,

19
00:00:46,800 --> 00:00:49,630
but what you need to know to pass the DP-203.

20
00:00:49,630 --> 00:00:51,360
So keep in mind those distinctions.

21
00:00:51,360 --> 00:00:54,180
We're not going to be diving far into the code,

22
00:00:54,180 --> 00:00:55,630
just enough for you to be able

23
00:00:55,630 --> 00:00:57,433
to understand what you need to pass.

24
00:00:59,159 --> 00:01:02,637
For the Microsoft exam, Microsoft actually states,

25
00:01:02,637 --> 00:01:05,440
"A candidate for this exam must have strong knowledge

26
00:01:05,440 --> 00:01:07,031
"of data processing languages,

27
00:01:07,031 --> 00:01:09,414
"such as SQL, Python, or Scala,

28
00:01:09,414 --> 00:01:11,840
"and they need to understand parallel processing

29
00:01:11,840 --> 00:01:14,690
"and data architecture patterns."

30
00:01:14,690 --> 00:01:17,030
So what does that mean really?

31
00:01:17,030 --> 00:01:18,960
How much do I actually need to know

32
00:01:18,960 --> 00:01:21,303
to get through the DP-203?

33
00:01:22,190 --> 00:01:24,560
So the first thing that you need to keep in mind,

34
00:01:24,560 --> 00:01:28,160
you do not need to be an expert in programming

35
00:01:28,160 --> 00:01:30,240
for all of these different languages.

36
00:01:30,240 --> 00:01:33,600
What you need to be able to do is see a piece of code,

37
00:01:33,600 --> 00:01:37,030
and recognize generally what's going on.

38
00:01:37,030 --> 00:01:39,630
I'll say this about a hundred times in this course,

39
00:01:39,630 --> 00:01:42,050
but please don't memorize code.

40
00:01:42,050 --> 00:01:44,970
You are not going to have to recite code from memory

41
00:01:44,970 --> 00:01:46,790
on the DP-203.

42
00:01:46,790 --> 00:01:48,070
What you will need to do though,

43
00:01:48,070 --> 00:01:50,190
and this is true for any Microsoft exam,

44
00:01:50,190 --> 00:01:52,170
you'll need to be able to look at pieces of code

45
00:01:52,170 --> 00:01:54,120
and say, hey, I know what that is.

46
00:01:54,120 --> 00:01:56,270
Oh, wait. That looks like it's out of order.

47
00:01:56,270 --> 00:01:58,130
Those are the kinds of things that you need to do.

48
00:01:58,130 --> 00:02:01,650
Be able to recognize code and recognize what might be wrong

49
00:02:01,650 --> 00:02:04,130
with the code that you're reading.

50
00:02:04,130 --> 00:02:04,963
So I would recommend

51
00:02:04,963 --> 00:02:07,070
if you don't have a background in programming,

52
00:02:07,070 --> 00:02:09,940
taking a few basic courses first.

53
00:02:09,940 --> 00:02:11,230
The first one that I would recommend

54
00:02:11,230 --> 00:02:12,335
is taking a look at

55
00:02:12,335 --> 00:02:14,493
Database Administration and SQL Language Basics

56
00:02:14,493 --> 00:02:16,835
and SQL Deep Dive.

57
00:02:16,835 --> 00:02:18,830
Hey, I recognize that guy.

58
00:02:18,830 --> 00:02:21,960
So Landon actually built our SQL Deep Dive course,

59
00:02:21,960 --> 00:02:24,740
and it is a fantastic entry into SQL

60
00:02:24,740 --> 00:02:27,440
if you really don't understand all that much about it.

61
00:02:28,810 --> 00:02:31,460
I would also take a look at Python,

62
00:02:31,460 --> 00:02:34,720
specifically the Introduction to Python Scripting course.

63
00:02:34,720 --> 00:02:35,910
Again, this is going to give you

64
00:02:35,910 --> 00:02:37,830
just a little bit of background in Python

65
00:02:37,830 --> 00:02:40,920
so that you could start to recognize code structure

66
00:02:40,920 --> 00:02:43,490
and start to see what may or may not be happening,

67
00:02:43,490 --> 00:02:46,453
as we move through the course with Python scripts.

68
00:02:48,110 --> 00:02:51,240
What if I can't find those courses?

69
00:02:51,240 --> 00:02:53,160
Courses change from time to time,

70
00:02:53,160 --> 00:02:56,020
and what I would recommend if you can't find those courses,

71
00:02:56,020 --> 00:02:58,700
just hop on and do a quick search

72
00:02:59,680 --> 00:03:03,310
for SQL or Python in A Cloud Guru and I bet you,

73
00:03:03,310 --> 00:03:06,230
you will come up with quite a few different resources.

74
00:03:06,230 --> 00:03:07,580
Pick one of the basics.

75
00:03:07,580 --> 00:03:09,960
Again, you don't need to understand everything there is.

76
00:03:09,960 --> 00:03:13,050
You just need to understand the basics of the syntax,

77
00:03:13,050 --> 00:03:15,700
and how the code is actually being structured

78
00:03:15,700 --> 00:03:17,270
so that you can kind of start to look through

79
00:03:17,270 --> 00:03:19,920
as we talk about data engineering concepts,

80
00:03:19,920 --> 00:03:21,470
and understand what's going on.

81
00:03:23,103 --> 00:03:23,936
Lastly, you will notice

82
00:03:23,936 --> 00:03:26,140
that we did not focus on Scala yet.

83
00:03:26,140 --> 00:03:28,990
I actually wouldn't recommend focusing on Scala.

84
00:03:28,990 --> 00:03:30,750
I think the bulk of what you need to know

85
00:03:30,750 --> 00:03:32,970
is going to be in SQL and Python.

86
00:03:32,970 --> 00:03:35,310
And I think if you understand the basic syntax

87
00:03:35,310 --> 00:03:37,520
of those 2 different languages,

88
00:03:37,520 --> 00:03:40,040
you should be just fine for the DP-203.

89
00:03:40,040 --> 00:03:42,380
However, that also follows true for Scala.

90
00:03:42,380 --> 00:03:45,300
If you decided you wanted to do SQL and Scala,

91
00:03:45,300 --> 00:03:47,060
hey, that'd be just fine too.

92
00:03:47,060 --> 00:03:49,710
Just pick 2 of those, I definitely recommend SQL,

93
00:03:49,710 --> 00:03:51,320
and then pick either Python or Scala

94
00:03:51,320 --> 00:03:52,970
and I think you'll be good to go.

95
00:03:54,570 --> 00:03:56,740
So, in summary,

96
00:03:56,740 --> 00:03:59,660
yes, you do need some programming background,

97
00:03:59,660 --> 00:04:03,120
especially in Python or Scala, and SQL.

98
00:04:03,120 --> 00:04:06,750
No, you don't need to be a master of the code.

99
00:04:06,750 --> 00:04:08,700
Grab a couple of those quick review courses

100
00:04:08,700 --> 00:04:11,920
to understand the basics. That's all you need.

101
00:04:11,920 --> 00:04:13,410
And keep in mind,

102
00:04:13,410 --> 00:04:15,650
hey, you're going to need this for your career too.

103
00:04:15,650 --> 00:04:17,970
Python, SQL, PowerShell,

104
00:04:17,970 --> 00:04:20,760
these are staples for a data engineer.

105
00:04:20,760 --> 00:04:23,230
If you don't understand how to do those things,

106
00:04:23,230 --> 00:04:25,230
you're going to find it hard to get a job

107
00:04:25,230 --> 00:04:27,180
and pass those entrance exams,

108
00:04:27,180 --> 00:04:29,220
and you're probably going to find it hard

109
00:04:29,220 --> 00:04:32,270
to actually do data engineering at scale.

110
00:04:32,270 --> 00:04:34,990
So, don't just focus on the 203.

111
00:04:34,990 --> 00:04:37,260
You're also going to need to know this for your career.

112
00:04:37,260 --> 00:04:41,030
But we, in this course, we'll be focusing on the 203.

113
00:04:41,030 --> 00:04:42,540
I hope this has been helpful.

114
00:04:42,540 --> 00:04:44,410
I will see you in the next section

115
00:04:44,410 --> 00:04:46,956
where we start talking about data engineering

116
00:04:46,956 --> 00:04:49,380
from the 20,000 foot view.

117
00:04:49,380 --> 00:04:50,330
I'll see you there.