1
00:00:01,030 --> 00:00:03,429
hi there my name is Christopher Harrison
and this

2
00:00:03,429 --> 00:00:06,839
is going to be querying Siebel Server
2012

3
00:00:06,839 --> 00:00:11,849
as a ten-second background myself I've
been doing single server since 2001

4
00:00:11,849 --> 00:00:15,759
done a development at the same time and
SharePoint

5
00:00:15,759 --> 00:00:18,880
for a good handle on I've years now

6
00:00:18,880 --> 00:00:25,099
all I want to do in this lesson is talk
a little bit about the intended audience

7
00:00:25,100 --> 00:00:26,390
for this course

8
00:00:26,390 --> 00:00:30,630
to also talk a bit out how to best use
this course

9
00:00:30,630 --> 00:00:33,660
to get the most out of it

10
00:00:33,660 --> 00:00:36,519
to the first big question task is well

11
00:00:36,520 --> 00:00:39,730
who are you who is the intended audience
for this

12
00:00:39,730 --> 00:00:45,260
and who can pick up the most from it
this course

13
00:00:45,260 --> 00:00:49,280
well the first couple people they're
gonna be able to pick up

14
00:00:49,280 --> 00:00:54,320
quite a bit are gonna be report writers
now under the earned huge umbrella

15
00:00:54,320 --> 00:00:58,820
I report writers I'm including people
who might be creating reports in 10

16
00:00:58,820 --> 00:01:00,070
Reporting Services

17
00:01:00,070 --> 00:01:04,010
or for Crystal Reports may be using
performance point with SharePoint

18
00:01:04,010 --> 00:01:07,150
or maybe just simply creating charts
inside

19
00:01:07,150 --> 00:01:11,479
I have excelled and may need to Paul
their information from

20
00:01:11,479 --> 00:01:15,610
a database now I would mention that the
vast majority were going to talk about

21
00:01:15,610 --> 00:01:16,690
but actually work with

22
00:01:16,690 --> 00:01:20,289
almost any database doesn't necessarily
have to be Siebel Server

23
00:01:20,290 --> 00:01:23,970
so even if you're going to be pulling
information from say MySQL

24
00:01:23,970 --> 00:01:28,750
a lot only be learning a query reading
section would apply to

25
00:01:28,750 --> 00:01:32,159
that database product as well

26
00:01:32,159 --> 00:01:36,140
the next to the people iOS developers
that are going to be using Siebel Server

27
00:01:36,140 --> 00:01:40,159
basically every application you create
these days is nothing but a friend

28
00:01:40,159 --> 00:01:45,780
and for a database and so developers
need to be able to query in work with

29
00:01:45,780 --> 00:01:48,630
data inside other a database

30
00:01:48,630 --> 00:01:52,060
this can also be very helpful for
developers that are going to be using

31
00:01:52,060 --> 00:01:52,729
sequel

32
00:01:52,729 --> 00:01:56,840
as a stepping stone is a first step into
deeper knowledge

33
00:01:56,840 --> 00:02:01,299
a sequel a lot of girls are shops one of
the things that you'll notice

34
00:02:01,299 --> 00:02:05,149
is that the developers are also
responsible for creating and

35
00:02:05,149 --> 00:02:09,299
potentially even maintaining the the
database the latter being a bit more

36
00:02:09,299 --> 00:02:09,869
rare

37
00:02:09,869 --> 00:02:13,930
but the former definitely being very
common so developers these days do you

38
00:02:13,930 --> 00:02:15,870
need a pretty solid understanding

39
00:02:15,870 --> 00:02:19,629
a sequel server in this conservative as
those first steps

40
00:02:19,629 --> 00:02:24,149
into getting into Siebel Server last but
not least

41
00:02:24,150 --> 00:02:28,530
is anybody looking to becoming a
database administrator

42
00:02:28,530 --> 00:02:32,290
and you're going to be a database
administrator your job is to support you

43
00:02:32,290 --> 00:02:32,950
users

44
00:02:32,950 --> 00:02:37,200
as they go often find the data that they
need well in order to best support our

45
00:02:37,200 --> 00:02:37,858
users

46
00:02:37,859 --> 00:02:41,109
we need to figure out how it is there
going to be grabbing their data

47
00:02:41,109 --> 00:02:44,269
and we need a starting point this

48
00:02:44,269 --> 00:02:48,510
is that perfect starting point this is
going to be that perfect spot where we

49
00:02:48,510 --> 00:02:48,989
eat

50
00:02:48,989 --> 00:02:52,090
and take a look at how to query

51
00:02:52,090 --> 00:02:56,250
and work with their data and all other
basics on how to work with objects

52
00:02:56,250 --> 00:02:58,849
as well

53
00:02:58,849 --> 00:03:01,579
as far as the course itself goatse you
can

54
00:03:01,580 --> 00:03:05,239
absolutely what's this thing from my
last start to finish

55
00:03:05,239 --> 00:03:10,060
or you didn't bounce around as needed
the one thing that I want to highlight

56
00:03:10,060 --> 00:03:13,640
is that really this course breaks down
into three

57
00:03:13,640 --> 00:03:17,268
main sections working with Siebel data

58
00:03:17,269 --> 00:03:21,800
working with XML data and then working
with sequel objects

59
00:03:21,800 --> 00:03:28,230
let's talk a little bit about who each
section is going to be targeted at

60
00:03:28,230 --> 00:03:32,560
the first section will be on writing
queries now you'll notice if you take a

61
00:03:32,560 --> 00:03:33,480
look at the outline

62
00:03:33,480 --> 00:03:36,980
that in upper section where to spend the
vast majority of our time

63
00:03:36,980 --> 00:03:40,349
focusing in on the SELECT statement
that's by design

64
00:03:40,349 --> 00:03:43,268
because you're gonna notice that the
vast majority of your time in working

65
00:03:43,269 --> 00:03:43,989
with Siebel

66
00:03:43,989 --> 00:03:48,310
is going to be focused on the SELECT
statement

67
00:03:48,310 --> 00:03:51,380
neither will the section on actually
work which means actions

68
00:03:51,380 --> 00:03:55,340
might find it out the main focus their
is gonna be on retrieving data

69
00:03:55,340 --> 00:03:59,250
as a result the target audience here is
going to be people that are new to

70
00:03:59,250 --> 00:04:00,170
Siebel Server

71
00:04:00,170 --> 00:04:03,660
that maybe you had a a database thrust
upon you

72
00:04:03,660 --> 00:04:06,970
awesome somebody came up to you and said
hey I needed to start creating reports

73
00:04:06,970 --> 00:04:10,500
and you're not quite sure exactly where
to start

74
00:04:10,500 --> 00:04:14,550
and here's a concern but or maybe

75
00:04:14,550 --> 00:04:17,590
what you decided to do easy to send are
you know I'm gonna go

76
00:04:17,589 --> 00:04:21,409
headlong into this on a figure all this
out and there's something going you know

77
00:04:21,410 --> 00:04:24,490
I feel like this more I feel like

78
00:04:24,490 --> 00:04:27,820
you know my life to be easy I need to
learn some different tips tricks another

79
00:04:27,820 --> 00:04:28,330
what's

80
00:04:28,330 --> 00:04:33,340
so those 12 mean target audiences here's
people in need a sequel

81
00:04:33,340 --> 00:04:36,549
and people there may be looking to fill
in gaps

82
00:04:36,550 --> 00:04:39,920
now the one thing that I do a highlight
about a lesson

83
00:04:39,920 --> 00:04:44,200
is that this is prerequisite knowledge
for every single person

84
00:04:44,200 --> 00:04:47,510
it's going to be working in it a
database

85
00:04:47,510 --> 00:04:50,849
so even if you may be saying well i'm
only ever gonna be a DNA

86
00:04:50,850 --> 00:04:54,620
I'm only ever gonna be you know backing
up my data base things like that

87
00:04:54,620 --> 00:04:57,710
being able to rank SELECT statements
being able right UPDATE statement is

88
00:04:57,710 --> 00:04:59,760
really still required knowledge

89
00:04:59,760 --> 00:05:03,380
4db aces while so this is gonna be
required knowledge for

90
00:05:03,380 --> 00:05:05,750
everyone

91
00:05:05,750 --> 00:05:09,690
the second section is XML and we're
gonna take a look

92
00:05:09,690 --> 00:05:14,150
at a relatively high level overview on
how XML works

93
00:05:14,150 --> 00:05:17,239
inside a sequel server now

94
00:05:17,240 --> 00:05:21,710
XML in my experience is something that
people use quite extensively

95
00:05:21,710 --> 00:05:25,270
or not at all and there doesn't seem to
be a whole lot

96
00:05:25,270 --> 00:05:29,280
middle-ground and I would also say that
the people are not using XML inside a

97
00:05:29,280 --> 00:05:30,900
sequel far outnumber

98
00:05:30,900 --> 00:05:34,960
the people that are using XML inside a
sequel server

99
00:05:34,960 --> 00:05:39,239
so as a result for our real-world
application

100
00:05:39,240 --> 00:05:42,400
the actual section quite frankly is
probably going to have a relatively

101
00:05:42,400 --> 00:05:43,500
limited

102
00:05:43,500 --> 00:05:46,510
target audience that being said however

103
00:05:46,510 --> 00:05:51,030
if you are a developer and you're gonna
be passing XML to and from sequel

104
00:05:51,030 --> 00:05:54,419
this is obviously going to be very
important for you all our

105
00:05:54,420 --> 00:05:59,990
if you are looking to take the 7461 the
sequels are requiring exam

106
00:05:59,990 --> 00:06:03,620
you will need to understand how to
retrieve

107
00:06:03,620 --> 00:06:07,190
and how to parse XML inside a sequel
server

108
00:06:07,190 --> 00:06:10,480
the last section

109
00:06:10,480 --> 00:06:13,870
is going to be on creating an altering
single server objects

110
00:06:13,870 --> 00:06:17,280
now there's quite a bit of time that
could be spent

111
00:06:17,280 --> 00:06:20,780
on all in this that we could do an
entire course on

112
00:06:20,780 --> 00:06:24,280
our database design naked last you know
weeks and weeks and weeks

113
00:06:24,280 --> 00:06:27,869
I there's still quite a bit and it could
be covered on creating

114
00:06:27,870 --> 00:06:31,260
all the individual objects inside of
their mine all

115
00:06:31,260 --> 00:06:34,820
in this lesson is really do focus in on
a high-level overview

116
00:06:34,820 --> 00:06:38,300
love working with sequel objects to my
target audience

117
00:06:38,300 --> 00:06:42,260
is for people who need to get a little
more in single server

118
00:06:42,260 --> 00:06:46,770
developers who may be needed to create
basic programming objects

119
00:06:46,770 --> 00:06:50,400
people that are looking to take that
7461 exam

120
00:06:50,400 --> 00:06:54,700
all art people that maybe just one own
little bit more information about this

121
00:06:54,700 --> 00:06:58,229
view that they're using about the stored
procedure that they're using exactly

122
00:06:58,230 --> 00:06:59,780
what is this what goes on

123
00:06:59,780 --> 00:07:03,090
behind the scenes in side effects

124
00:07:03,090 --> 00:07:05,719
now before we get started I do highlight

125
00:07:05,720 --> 00:07:09,520
that when I goes through this course I
saw kiss a lot

126
00:07:09,520 --> 00:07:13,740
on syntax in fact you're gonna known as
that I spend very little time

127
00:07:13,740 --> 00:07:17,360
if any at all using the true designer
that

128
00:07:17,360 --> 00:07:20,979
everything going to be doing is inside I
SELECT statement

129
00:07:20,979 --> 00:07:24,690
and I do that on purpose because I find
that people who can

130
00:07:24,690 --> 00:07:27,810
right the queries pan a very easy time

131
00:07:27,810 --> 00:07:31,310
going in using a tool in Iran the
reverse isn't always true

132
00:07:31,310 --> 00:07:34,690
site always focus in on how to do it
inside

133
00:07:34,690 --> 00:07:38,780
I the query you'll also notice by the
white

134
00:07:38,780 --> 00:07:42,099
when you gonna take the exam that's also
going to be their focus

135
00:07:42,099 --> 00:07:46,419
as a result we've got a lotta syntax and
I want to highlight a couple real quick

136
00:07:46,419 --> 00:07:46,990
things in

137
00:07:46,990 --> 00:07:50,360
out how I'm going to be displaying
syntax you notice that I might have

138
00:07:50,360 --> 00:07:51,560
something like to simply

139
00:07:51,560 --> 00:07:55,330
slacked and that's where on specifying a
commander and

140
00:07:55,330 --> 00:07:59,210
option or a keyword or something like
that you'll also notice

141
00:07:59,210 --> 00:08:02,330
they all have different variable names
if you will

142
00:08:02,330 --> 00:08:05,479
placeholder names inside on angle
brackets

143
00:08:05,479 --> 00:08:08,849
so for example here I've got angle table
angle

144
00:08:08,849 --> 00:08:12,620
what that is is that a placeholder for a
table me

145
00:08:12,620 --> 00:08:15,669
and you're gonna notice that I've got
square brackets

146
00:08:15,669 --> 00:08:18,870
with maybe a couple options separated by
a pipe

147
00:08:18,870 --> 00:08:22,289
with that's gonna be indicating to you
is that does are optional

148
00:08:22,289 --> 00:08:25,810
she can provide one you can maybe
provide multiple all our

149
00:08:25,810 --> 00:08:30,009
you can ride nine contrast that with the
curly braces

150
00:08:30,009 --> 00:08:33,219
well I've got insert pipe update pipe to
lead

151
00:08:33,219 --> 00:08:36,969
inside have curly braces in that
scenario at least one

152
00:08:36,969 --> 00:08:40,079
and potentially more is required

153
00:08:40,078 --> 00:08:43,159
there is a little bit of an overview the

154
00:08:43,159 --> 00:08:45,279
entire course what he say we get started