1
00:00:00,900 --> 00:00:10,890
Hello we are going to create a crowd based database driven application crowd stands for create read

2
00:00:10,990 --> 00:00:20,940
or date and delete what that means is that the application will create will be able to create new objects

3
00:00:21,000 --> 00:00:23,090
or new records for that application.

4
00:00:23,340 --> 00:00:27,080
We'd be able to read the data that's inside there.

5
00:00:27,240 --> 00:00:36,320
We'd be also able to update and also delete records from that application.

6
00:00:36,540 --> 00:00:39,630
So I'm going to use my workspace area.

7
00:00:39,690 --> 00:00:49,760
So this is my application express workspace sue to begin I am going to use the sequel workshop or secure

8
00:00:49,770 --> 00:00:51,140
workshop.

9
00:00:51,360 --> 00:00:56,650
Click on drop I am going to select this object browser here.

10
00:00:57,000 --> 00:00:59,310
What this is it for.

11
00:00:59,310 --> 00:01:03,940
Allow me to view the objects inside the schema.

12
00:01:04,080 --> 00:01:09,120
No it is he has got a table listed so it would give me a list of all the tables.

13
00:01:09,120 --> 00:01:15,790
Here is where you create this lot from there to create a table saw.

14
00:01:15,810 --> 00:01:26,330
I have got a list of tables here and this table if you if you are creating a new table this is the option

15
00:01:26,340 --> 00:01:28,680
you're going to use to create a new table.

16
00:01:28,690 --> 00:01:36,670
If you index and SORN sassy option to create I've already got one so I am not going to create another

17
00:01:36,690 --> 00:01:41,680
I'm just going to select mine so this is what I'm going to use.

18
00:01:41,850 --> 00:01:50,980
So I've clicked on it once to show me what's inside a table for one to look at a date and a table.

19
00:01:50,970 --> 00:01:55,780
I click on Data and that will show me all the data in the table.

20
00:01:55,980 --> 00:02:00,900
So let's go back to the actual table structure so this is a table structure.

21
00:02:01,110 --> 00:02:06,840
This is what it looks like he's got a primary key which is the employee idae.

22
00:02:07,080 --> 00:02:10,930
So now that I've seen the table structure.

23
00:02:12,880 --> 00:02:13,960
I am happy with it.

24
00:02:13,960 --> 00:02:15,120
Table structure.

25
00:02:15,370 --> 00:02:19,030
I need to go here way says application builder.

26
00:02:19,030 --> 00:02:25,390
I'll click on that and click on database applications.

27
00:02:26,220 --> 00:02:26,990
Right.

28
00:02:27,210 --> 00:02:29,370
So we've got database applications.

29
00:02:29,370 --> 00:02:36,660
Highlight it are click on Create and you've got three options.

30
00:02:36,660 --> 00:02:42,670
Make sure you've got one database redo bodying checked go next.

31
00:02:42,900 --> 00:02:44,880
Make sure you cook from scratch.

32
00:02:44,910 --> 00:02:48,370
Select it go next.

33
00:02:48,370 --> 00:02:52,190
And this is where you give the name application a name.

34
00:02:52,380 --> 00:02:55,520
So I'm going to call it.

35
00:02:56,790 --> 00:03:01,430
Okay I'll call it employee.

36
00:03:05,430 --> 00:03:06,120
Employees.

37
00:03:06,120 --> 00:03:08,710
Details.

38
00:03:13,560 --> 00:03:17,260
So you can call your application whatever you like it doesn't really matter.

39
00:03:17,340 --> 00:03:19,520
I've just called my employee details.

40
00:03:19,920 --> 00:03:23,790
Every application normally within the workspace will have a name.

41
00:03:23,940 --> 00:03:27,440
And they also will have an application I.D..

42
00:03:27,650 --> 00:03:33,770
Okay so you've got the Air France crash selected and you've got the scheme and this is important what

43
00:03:33,840 --> 00:03:40,720
the right came up my scheme has a chart I'm happy with that I go next.

44
00:03:40,930 --> 00:03:44,310
Okay so I've got this option here.

45
00:03:44,690 --> 00:03:47,150
This this to add a page.

46
00:03:47,160 --> 00:03:49,710
It gives you the various types.

47
00:03:49,710 --> 00:03:50,940
So what we're going to do.

48
00:03:50,940 --> 00:03:54,330
I'm going to say let it report and inform.

49
00:03:54,330 --> 00:03:59,190
So these are deeply type of forms you can add to your page for the application.

50
00:03:59,200 --> 00:04:08,850
So I'm going to check that one report and fall in here is is seeing at a report with an edited form

51
00:04:09,000 --> 00:04:10,560
on a second page.

52
00:04:10,560 --> 00:04:13,850
So what do you do to add a report.

53
00:04:13,960 --> 00:04:21,270
And also you'll create two pages one page will be for it form where you can make some edits so you need

54
00:04:21,270 --> 00:04:28,690
to select the table is coming from so quick on that and select the employees table.

55
00:04:29,220 --> 00:04:29,670
All right.

56
00:04:29,700 --> 00:04:34,220
So it's come in from the Employee table implementation.

57
00:04:34,280 --> 00:04:35,430
You've got options here.

58
00:04:35,430 --> 00:04:38,070
I will leave my interactive.

59
00:04:38,280 --> 00:04:40,400
I want it to be interactive.

60
00:04:40,980 --> 00:04:41,850
Okay.

61
00:04:41,850 --> 00:04:49,370
So all right so what's go that don't click on Had page.

62
00:04:49,410 --> 00:04:52,790
All right sir notice here is great.

63
00:04:52,800 --> 00:04:54,530
Two pages here.

64
00:04:54,630 --> 00:05:06,480
One is a report and one is the form the report page and the form P the form P physically is used to

65
00:05:06,510 --> 00:05:08,140
update entries.

66
00:05:08,540 --> 00:05:09,060
Okay.

67
00:05:09,060 --> 00:05:11,370
In the employee table.

68
00:05:11,440 --> 00:05:18,550
Why the report pay issues to display the data from the employee's table.

69
00:05:18,840 --> 00:05:25,590
So we've also got another here to add additional page to your application.

70
00:05:25,950 --> 00:05:30,320
Okay so we can old school ways.

71
00:05:30,320 --> 00:05:33,990
Got an additional page to your application.

72
00:05:34,050 --> 00:05:42,270
You can however change the name of the print side the more men book pages for the application is called

73
00:05:42,300 --> 00:05:45,080
employees and employees.

74
00:05:45,110 --> 00:05:47,390
Or you can change them if you wish.

75
00:05:47,760 --> 00:05:55,920
So by just clicking on it so you can click on it and just change you can change the name if you wish.

76
00:05:55,950 --> 00:06:02,570
For simplicity I am going to leave my online that are live.

77
00:06:02,570 --> 00:06:07,680
That and if you click on the second one here give you the same.

78
00:06:07,680 --> 00:06:14,140
It shows you the same details so you can change if you want so you can distinguish the pages.

79
00:06:14,490 --> 00:06:18,450
I will leave mine as it is of course is just a demo.

80
00:06:18,810 --> 00:06:27,060
So once you are happy with all the information you click on the create button okay there's some more

81
00:06:27,060 --> 00:06:29,280
information here if you want or read through that.

82
00:06:29,280 --> 00:06:31,550
Feel free to do so.

83
00:06:31,560 --> 00:06:38,980
Click create and when you click on Create it gives you this screen here.

84
00:06:39,070 --> 00:06:40,050
You saw what you do.

85
00:06:40,080 --> 00:06:44,090
Just check out for the final time before you hit the button.

86
00:06:44,220 --> 00:06:49,120
It tells you who requested to create an application with a polin attributes.

87
00:06:49,140 --> 00:06:50,360
This is application.

88
00:06:50,370 --> 00:06:52,710
I see this as a name.

89
00:06:52,720 --> 00:06:54,100
This is a scheme.

90
00:06:54,300 --> 00:07:02,280
English is a default tabs or level of tab and default authentication screen.

91
00:07:02,350 --> 00:07:12,240
Anytime you create an application in a quick breath it all sort of magically adds a logging form to

92
00:07:12,240 --> 00:07:12,910
it.

93
00:07:12,940 --> 00:07:16,570
All right so this is the default scheme theme.

94
00:07:16,590 --> 00:07:19,780
If you want to change the theme you can click on previous.

95
00:07:20,360 --> 00:07:27,800
And if you scroll down these are different teams so you can select any teams you like.

96
00:07:28,200 --> 00:07:35,030
I just looked through see there's one that catches my eye team level.

97
00:07:36,740 --> 00:07:39,260
Team 17.

98
00:07:39,920 --> 00:07:44,410
I'm trying to look for one that catches my eye.

99
00:07:44,960 --> 00:07:47,140
Let's have a look again.

100
00:07:48,470 --> 00:07:52,090
But I once had big dark to watch.

101
00:07:52,120 --> 00:07:55,050
I saw something like bluish colour.

102
00:07:56,140 --> 00:07:57,190
Asked the green one.

103
00:07:57,190 --> 00:08:00,910
I tell you what I'll go for the green just for simplicity.

104
00:08:00,910 --> 00:08:02,500
So I'll select that team

105
00:08:05,430 --> 00:08:07,540
and go next.

106
00:08:08,910 --> 00:08:11,420
So this is a team now displaced.

107
00:08:11,550 --> 00:08:19,100
It gives you the option to save if you want So once you don't just click on create issues create the

108
00:08:19,110 --> 00:08:20,450
application.

109
00:08:20,580 --> 00:08:24,690
So basically that's done it tells you here.

110
00:08:24,690 --> 00:08:26,980
Application creators successfully.

111
00:08:27,300 --> 00:08:36,120
So we have now successfully created a database driven application so these this is what the application

112
00:08:36,120 --> 00:08:39,770
consists of it consists of two pages.

113
00:08:39,810 --> 00:08:44,520
This is the first page Sushi's employees and this is the actual form.

114
00:08:44,520 --> 00:08:51,240
This this this year will display the report and this is the actual form where you can edit.

115
00:08:51,330 --> 00:08:53,710
This is the logging alright.

116
00:08:54,130 --> 00:08:59,490
Logging is added by default to any application you create mound.

117
00:08:59,570 --> 00:09:09,160
If we're to the application we can run the application by using this icon here.

118
00:09:09,630 --> 00:09:11,670
So you click run.

119
00:09:12,790 --> 00:09:21,850
Or you right click angle or pull a link in new window sill are quick on that and he now gives me the

120
00:09:21,850 --> 00:09:28,410
option to pull my password did me.

121
00:09:28,420 --> 00:09:32,970
Password is asking for is the char one.

122
00:09:33,010 --> 00:09:34,640
So type in hey char.

123
00:09:39,800 --> 00:09:42,680
There are so many log in as a password.

124
00:09:42,960 --> 00:09:45,560
Okay it does sound like that to a king.

125
00:09:45,580 --> 00:09:49,670
So as typing had min.

126
00:09:58,830 --> 00:10:00,640
K.

127
00:10:06,970 --> 00:10:08,510
Sorry my error.

128
00:10:08,620 --> 00:10:14,590
The user name should have been blue line which is what I registered for the workspace so the user name

129
00:10:14,590 --> 00:10:19,800
it will be the name for the workspace okays which was blue line.

130
00:10:19,860 --> 00:10:23,330
Got so many passwords and user names.

131
00:10:23,410 --> 00:10:26,130
So now this is our troll application.

132
00:10:26,320 --> 00:10:28,600
So we are successfully.

133
00:10:28,600 --> 00:10:36,030
This is the application running at the moment so we have created a database driven application.

134
00:10:36,210 --> 00:10:43,660
So I'm just going to log out of this one now and that will end this lecture for now because it's gone

135
00:10:43,660 --> 00:10:45,130
on a bit long.

136
00:10:45,670 --> 00:10:47,410
So that's it for this lecture.

137
00:10:47,440 --> 00:10:49,210
Thank you so much for watching.

138
00:10:49,330 --> 00:10:50,280
Take care.

139
00:10:50,290 --> 00:10:51,240
Bye for now.
