hi there my name is Christopher Harrison and this
is going to be querying Siebel Server 2012
as a ten-second background myself I've been doing single server since 2001
done a development at the same time and SharePoint
for a good handle on I've years now
all I want to do in this lesson is talk a little bit about the intended audience
for this course
to also talk a bit out how to best use this course
to get the most out of it
to the first big question task is well
who are you who is the intended audience for this
and who can pick up the most from it this course
well the first couple people they're gonna be able to pick up
quite a bit are gonna be report writers now under the earned huge umbrella
I report writers I'm including people who might be creating reports in 10
Reporting Services
or for Crystal Reports may be using performance point with SharePoint
or maybe just simply creating charts inside
I have excelled and may need to Paul their information from
a database now I would mention that the vast majority were going to talk about
but actually work with
almost any database doesn't necessarily have to be Siebel Server
so even if you're going to be pulling information from say MySQL
a lot only be learning a query reading section would apply to
that database product as well
the next to the people iOS developers that are going to be using Siebel Server
basically every application you create these days is nothing but a friend
and for a database and so developers need to be able to query in work with
data inside other a database
this can also be very helpful for developers that are going to be using
sequel
as a stepping stone is a first step into deeper knowledge
a sequel a lot of girls are shops one of the things that you'll notice
is that the developers are also responsible for creating and
potentially even maintaining the the database the latter being a bit more
rare
but the former definitely being very common so developers these days do you
need a pretty solid understanding
a sequel server in this conservative as those first steps
into getting into Siebel Server last but not least
is anybody looking to becoming a database administrator
and you're going to be a database administrator your job is to support you
users
as they go often find the data that they need well in order to best support our
users
we need to figure out how it is there going to be grabbing their data
and we need a starting point this
is that perfect starting point this is going to be that perfect spot where we
eat
and take a look at how to query
and work with their data and all other basics on how to work with objects
as well
as far as the course itself goatse you can
absolutely what's this thing from my last start to finish
or you didn't bounce around as needed the one thing that I want to highlight
is that really this course breaks down into three
main sections working with Siebel data
working with XML data and then working with sequel objects
let's talk a little bit about who each section is going to be targeted at
the first section will be on writing queries now you'll notice if you take a
look at the outline
that in upper section where to spend the vast majority of our time
focusing in on the SELECT statement that's by design
because you're gonna notice that the vast majority of your time in working
with Siebel
is going to be focused on the SELECT statement
neither will the section on actually work which means actions
might find it out the main focus their is gonna be on retrieving data
as a result the target audience here is going to be people that are new to
Siebel Server
that maybe you had a a database thrust upon you
awesome somebody came up to you and said hey I needed to start creating reports
and you're not quite sure exactly where to start
and here's a concern but or maybe
what you decided to do easy to send are you know I'm gonna go
headlong into this on a figure all this out and there's something going you know
I feel like this more I feel like
you know my life to be easy I need to learn some different tips tricks another
what's
so those 12 mean target audiences here's people in need a sequel
and people there may be looking to fill in gaps
now the one thing that I do a highlight about a lesson
is that this is prerequisite knowledge for every single person
it's going to be working in it a database
so even if you may be saying well i'm only ever gonna be a DNA
I'm only ever gonna be you know backing up my data base things like that
being able to rank SELECT statements being able right UPDATE statement is
really still required knowledge
4db aces while so this is gonna be required knowledge for
everyone
the second section is XML and we're gonna take a look
at a relatively high level overview on how XML works
inside a sequel server now
XML in my experience is something that people use quite extensively
or not at all and there doesn't seem to be a whole lot
middle-ground and I would also say that the people are not using XML inside a
sequel far outnumber
the people that are using XML inside a sequel server
so as a result for our real-world application
the actual section quite frankly is probably going to have a relatively
limited
target audience that being said however
if you are a developer and you're gonna be passing XML to and from sequel
this is obviously going to be very important for you all our
if you are looking to take the 7461 the sequels are requiring exam
you will need to understand how to retrieve
and how to parse XML inside a sequel server
the last section
is going to be on creating an altering single server objects
now there's quite a bit of time that could be spent
on all in this that we could do an entire course on
our database design naked last you know weeks and weeks and weeks
I there's still quite a bit and it could be covered on creating
all the individual objects inside of their mine all
in this lesson is really do focus in on a high-level overview
love working with sequel objects to my target audience
is for people who need to get a little more in single server
developers who may be needed to create basic programming objects
people that are looking to take that 7461 exam
all art people that maybe just one own little bit more information about this
view that they're using about the stored procedure that they're using exactly
what is this what goes on
behind the scenes in side effects
now before we get started I do highlight
that when I goes through this course I saw kiss a lot
on syntax in fact you're gonna known as that I spend very little time
if any at all using the true designer that
everything going to be doing is inside I SELECT statement
and I do that on purpose because I find that people who can
right the queries pan a very easy time
going in using a tool in Iran the reverse isn't always true
site always focus in on how to do it inside
I the query you'll also notice by the white
when you gonna take the exam that's also going to be their focus
as a result we've got a lotta syntax and I want to highlight a couple real quick
things in
out how I'm going to be displaying syntax you notice that I might have
something like to simply
slacked and that's where on specifying a commander and
option or a keyword or something like that you'll also notice
they all have different variable names if you will
placeholder names inside on angle brackets
so for example here I've got angle table angle
what that is is that a placeholder for a table me
and you're gonna notice that I've got square brackets
with maybe a couple options separated by a pipe
with that's gonna be indicating to you is that does are optional
she can provide one you can maybe provide multiple all our
you can ride nine contrast that with the curly braces
well I've got insert pipe update pipe to lead
inside have curly braces in that scenario at least one
and potentially more is required
there is a little bit of an overview the
entire course what he say we get started