 Saya menghubungkan software yang perlu, kerana nanti saya akan menghubungkan masa yang cukup banyak yang semua orang dapat menggunakan software yang saya masukkan di instruksi semalam Saya akan juga menghubungkan untuk membantu anda, wanita dan teman-teman di instalasi dan membaikkan... Ya! Baiklah, saya sanggup. Saya seharusnya pakai panggilan. Ya, dan perkara ini. Masa saya akan menghubungkannya dengan benda yang boleh. Ya, kerana... Bila tak boleh. Baiklah, baiklah Saya tetap bukan yang akan membaikkan sebuah penerbangan saya. Tapi, fram sejahtera, Prosesnya, hari pertama, terima kasih kerana membuat masa itu untuk kami. Ya, nama saya Jeffrey. Sebelum saya mulakan kerana, Saya ingin mengenai sesuatu kerana ini adalah perkara yang terakhir untuk saya. Saya cuma ingin memberikan atau merasakan sebuah sesi ini. Sebelum ini. Jadi, beberapa keterangan saya seperti sekarang, dibuat bersama dari beberapa perjalanan, dalam banyak masa yang panjang. Jadi, mereka mungkin tidak sepatutnya diperkenalkan untuk memperkenalkan. Jadi, saya hanya berharap, dan dengan itu, saya hanya berharap, sebuah sesi ini hari ini, akan menjadi sebuah sesi yang lebih berlaku. Saya ingin menjadi sebuah sesi. Tapi saya hanya bercakap selama 5 pagi, dan tiada jawapan daripada semua orang. Jadi, jika anda ada komen, ada pertanyaan, hanya berhati-hati untuk berhati-hati dengan saya pada masa yang panjang. Dan beritahu mereka. Saya akan cuba memberikan lebih banyak tangan. Ia sebabnya, saya telah mengeluarkan link untuk beberapa software yang saya boleh memperkenalkan. Dan... Sebelum saya memperkenalkan, anda mungkin tidak dapat mencuba sejauh-jauh. Ya, berharap semua orang boleh belajar beberapa-berapa orang di dalam sesi ini. Baiklah. Saya faham bahawa, keadaan atau keadaan adalah sesuatu yang perlu dilakukan dengan bahan-bahan data. Saya tidak mahu bercakap tentangnya hari ini, sebab bahan-bahan data adalah lebih seperti keadaan yang lebih berlaku dengan jalanan dengan sistem pengalaman data. Jadi, saya akan bercakap lebih tentang sistem pengalaman data, kerana saya rasa itu akan lebih berlebihan kepada semua orang di kerja hari ini. Tapi sebelum itu, boleh saya beritahu bahan-bahan yang telah dilakukan dengan sistem pengalaman data sebelum itu? 1, 2, 3. Baiklah. Baiklah. Baiklah. Saya akan bercakap lebih baik-baik. Jadi, mari kita lihat bagaimana. Ya. Baiklah. Sebelum ada yang berkaitan dengan ibu bapa, sebenarnya saya tidak ada ibu bapa. Sebelum sekarang saya tanya ibu bapa sekarang, dia kata ada seseorang di sisi ibu bapa. Puan sekarang banyak. Ibu bapa tidak pernah bercakap dengan ibu bapa. Tidak, tak. Saya tidak tahu bagaimana ibu bapa membuat ibu bapa. Jadi... Sebelum itu, siapa yang hanya membuat seseorang menghubungi sisi ibu bapa, yang hanya membuat sisi ibu bapa. Ibu mungkin perlu memutuskan sisi ibu bapa. Saya tidak tahu. Saya hanya cuba. Baiklah. Baiklah. Baiklah. Bagaimana dengan sisi ibu bapa? Saya tidak tahu. Baiklah. Bagaimana? Baiklah. SayaOS, y Tak, keranangnya ber administrasi- administrasi yang terlambat. Well, just to make things clear, the documents that are uploaded in the Google Shared Drive are actually notes and a couple of sample files, the necessary software, which is XAMPP, I'll tell you those what it all says for later, and my SKL will batch you all have to download it separately. But if the government prevents us from logging onto the Wi-Fi, I've got a lost thumb drive somewhere in the class, which contains the necessary software. I've got another spare thumb drive down here, but I think some non-MAC machines will not be able to use it. MAC software that prevent guys and girls can turn into lab, so... Copy the contents of the thumb drive to your computer and just pass it along, okay? So as you are going along, I think I'll just start off the session. So basically the outline as you can see down here is what I'm going to cover today. Well, the duration is just a rough estimate. When I was running through a drive-down list, I think I'll take much less time than that. So the very first session, which is, I say it's worth it one or what, I think of at least 15 minutes, is actually a quick introduction to the database management system. You know, just to give everyone a brief overview what all this management stuff is all around. And after that, the second session is actually to be setting up and the installation of my SPL, because subsequently there's going to be hands-on exercises which will require the use of the software. Ya, it will be good if everyone can at least have those software up and running on the computer. I put 30 minutes, but again, looking at the progress, it's going to take like 1.5 hours maybe. And then we're going to have another session 3, which is on the relational databases. And okay, you don't have to worry about what you understand by ER diagram, which is not emergency room, but I think it's just an acronym for something simple. And I'm just trying to make it simple, easy to understand my whole. After that, we break for lunch. Hopefully, I'll have student presentations. I mean, I'll make some couple of questions and some exercises for you to try again. I don't want to speak too much after lunch, because it'll be sticky. So maybe I'll just ask some students to just come and present their answers and put them as general discussion with class. That should take 1 hour. And last session of the afternoon will be on structure query language, which is how U.S. humans interact with database to perform all the querying and all the what-what. And after that, I'll just end of this session with hands-on exercises. So before I carry on any questions, comments. No, nothing. Good, awesome. Okay, so first session, quick introduction to database management system. Okay, ignore the comment. I just put it there for fun. Now, as you all know, I guess every one of us have already been exposed to the fact that we are actually generating tons and tons of data around us. I mean, data is basically pretty much everywhere. So, I mean, data are just like, you know, records, information, and somehow or rather, we will require systems to help us store it as well as to manage that. In fact, all the programs, everything in your everyday lives already has some form of database management, you know, managing them. I mean, a very good example is like, for instance, your, you know, mobile phones, all the address rules that was add, even the social applications, like, you know, Facebook, Weed, not WeChat. Let's just step-chat. You guys gonna step-chat, eh? Okay, awesome. Ya, I like the photograph taking function when it is stored in your face. But anyways, ya, so somehow all these kind of applications, and even, you know, I don't know who likes to do online shopping. Lawshrub. Okay, online shopping. So, oh, and online shopping. Ya, so basically all the applications that you somehow or rather, they all have a database system powering them, managing their data, and ensuring that your orders don't go to somebody else. They will also have features to help protect and create your personal data, like, you know, credit card numbers, kind of, things so and so forth. And interestingly, although I won't talk in detail about this one, but data security is also one of the important features of what a database management system will do, right? I mean, I don't know how often, did you guys read, did you girls read the news? You know, sometimes they're like, oh, okay, this bagaulah, like, you know, a whole type of credit card to ask the hackers. Now, these are instances whereby they do not protect that data well enough, okay? So, this kind of management is pretty important and they cannot be, you know, solve by just using a simple same Excel spreadsheet or normal text documents. Now, just to give you an idea of what I kind of thought was interesting, is that, I mean, the last decade we've been faced with unprecedented growth in terms of the amount of data that we're actually generating and creating. So, this is actually a very simple infogram. If you all have slides of anti-colon because it's very cluttered down here, but in every five, this infogram is actually made in 2012. We are already right now in 2016. So, you can expect the numbers to be exponentially much more than what is actually in this program. So, for instance, every five minutes, you can have things like, you know, 270 new users mobile web, 48-hour world of data, uploaded to YouTube, and all this, just multiply that by several times. That's the amount of data that the entire world needs to manage. So, okay, in that case, this is actually more like a good point slide because hopefully, you all can see that with this huge amount of data, we need systems to help capture and store the data. Okay, so the next one is instead of just capturing and storing the data for those doing businesses, I mean, I don't know, what's in the finance industry? I know what is in the finance industry, banking industry. Oh, okay, awesome. Yeah, also for finance. Anyways, basically, every sector, education, media, whatever, you will need to do some form of marketing as well. You will need to do some form of analysis for customers that you're having and to make to make strategic choices in the kinds of decisions that you make at work. So, database management systems not only allow us to squad match data, they will allow us to also query and perform fanciful analytics so that in your day-to-day work, we can make proper decisions. And it's not just proper shared applications. I mean, even in your own personal lives, I don't know, I mean, some people might, I don't know, some people who have blogs, they will like, you know, what is their blog sheets, this kind of stuff so it has to be so these are some of the analytics that they will finding useful even in their personal lives as well. I point to, you know, my Facebook likes and I feel that, okay, this picture doesn't have a lot but I think that a strange picture of both number of likes will well be something like that. Okay, so with all these things in mind, actually, if you think about it, there's a lot of software out there which can actually help us manage but I think I put this up for sure because I think most, I would believe most people would have been exposed to the use of Excel to store and manage your data so and I understand the last few of you have a session with Excel friends. Okay, who use data who use Excel so we don't store friends or something again. Really, so few. Wow. Okay. Okay, now my yeah, so if you take a look at it Excel is actually good as an example like a primitive database system but later I'll show to you why in terms of you know when you have more data and more so-called relationships between them Excel will start to break down. Okay. So, but for the most basic usage yeah, Excel is excellent as the name implies why because there's no complicated setup just open up a spreadsheet for touch enter your records and go you don't even specify what kind of records just type and do whatever stuff that you want to do simple functions like you know sorting, filtering analytical functions but today hopefully I can show you more fentiful ways of doing so in the proper database system whoever you can I mean for those builds you can take and go and impress for the employees you can take yeah, Excel has no gibberish working language sort of unless you want to use like DBA I think you all should have a session DBA so yeah that can be used as well but I think most of the general public won't have exposure to DBA as well you can plot simple graphs people tables that is actually usually appealing for small data sets okay so before we carry on I'll just like you everyone of you I'm trying because I'm used to saying you guys but these are coding girls so I've got to stop a little bit yeah anyways if you open up your Google Drive and if you put in an Excel spreadsheet uh inside this is just to let everyone will have a feel of what it's like trying to manage data using Excel and only then you can appreciate SQL itself so can you all just open up the spreadsheet it's been quiet yeah don't tell me your Excel spreadsheet install more also open up mine alright everybody okay I'm just going to assume that at one point of time you know all your files and you've been exposed to such kind of using Excel spreadsheets to manage your data okay over here these are free data set that I've got off the web but it's a I'm not going to explain what individual tech means but basically I will assume that when you open up as a data excel you'll be somewhat similar like you have actors in the spreadsheet and each column will represents yeah an attribute or something to record so you have like you know then you have a separate tab for address you know categories things whatever so and so forth and using this Excel spreadsheet you can actually answer simple questions already okay like for example program okay like for example you ask yourself this question how many NC 17 fields are narrowly database I mean you need Excel spreadsheet to be straight forward you just go to a NC 17 just go to um field and you can type you can add a filter down there I hope last week you all have noticed it's not out picture right now you're charged um yeah you can already do simple filtering okay and you can see I've already filtered I just need to count the number of records down here you'll give me NC 17 um you can also answer simple questions like um you know how many Excel and the last name right same thing and you just go to the column type in the filter and do whatever filtering that you want nothing like yeah so as you can see you can charge and stuff yeah all these are very simple operations you can do that I mean no big deal but it happens when you start to wrap it up okay so your boss let's say for instance if you are managing the let's say say the swimming that you are managing the rental store and they want to find you a water hey I want to know in each film category how many films are there so um I don't know can you girls spend like you know one minutes trying to find out from an Excel spreadsheet and answer that question for me yeah oh oh actually you know and for the more students who want to challenge themselves they can maybe try answering the last two questions which accent has appeared in most films for the store and how many customers out of Korea I don't see a lot 16 16 really okay awesome you have to do a lot of clicks I don't know I'm sorry just let's say alright okay ah later we'll revisit using SQL and see where you are if we don't have time for that yeah so okay um I hope that for those who try you can see that you are having a pretty difficult time trying to answer the questions for some of them um I mean they can be answered by Excel um it's just that depending on your level of expertise you know for some people you can answer some people you know you need to come and write but um hopefully by the end of the session you'll see that using a more mature or more sophisticated system you're actually able to answer all these questions in a relatively much shorter time and by the way Excel spreadsheet you have several times just for this college um the thumb drive that pass ground that's actually or it's not in Excel because Excel it's not able to open it it actually has millions of records so if you try to you know look through millions of records and Excel spreadsheet so that's where things start to get pretty funky okay um so when the number of records grows big and the next point is more important when there are different types of data sets that have relationship with one another okay so that Excel also starts like just now the personal periods that I showed you those are actually just periods within within the individual tab itself but when you need to cross reference data from different tabs okay so it becomes a little bit more difficult and okay in addition to that business is a little bit more in our pile up instead of when you need to have from current access to the same data source right now each and every one of you so it's pretty fine but let's say if you have one company you know where you have many sales person each one of them tries to update the same Excel spreadsheet with whatever transaction that they have made it becomes pretty much a nightmare alright so database system is supposed to handle that but there's one discriminatory exercise that you guys are making you guys are making you guys are making we are local so me to say only you have access to that but theoretically if we actually have an intro next work you can actually connect to the database right now running off running machine right now but that is no matter if you connect to the data right now you would have so it's just think it's the right to the point and also when you need to use data source for other finding applications like now you know and the websites and so on I mean many of us as machine is going to be just you guys will be quite messy okay so we've talked about database database management system so what exactly is it I mean if you do a Google search on the database management system Google I mean I think it's just going to return you a hands-off I mean aside from review this it's just going to return you a hands-off you know products of software out there okay and of course they are both commercial resource dbms but for this session in fact not just for this session we thought we were going to see that for most of even more mature operations they are actually using dbms database management system and out of many database management system which are going to use dbms to return to them from this point onward we can roughly classify them into S2L and no S2L so basically S2L is what we call relational models I'll explain what relational models by that reason in fact up to last few years pretty much everything is under this category we saw in the recent years the results we have this big data being tossed around so that's where the other kinds of database models that come in at those categories you all currently classify them under well obviously no S2L you know to say that it's not S2L but we're not going to do that today just to let you know so some of the popular products for S2L and no S2L by the way just one fact last time they used to pronounce S2L as SQL as those some say S2L is correct some say S2L is correct I have no opinion whatsoever so it doesn't matter so to S2L you have the more popular products like my S2L Postgres S2L Microsoft Oracle and for no S2L can be any type of database system like mobile sender release so on and so forth but for today I'm just going to focus a little bit more in fact I'm going to focus entirely on my S2L because that is the one that is we will use quite a lot of conversations down there so why do we need database management system well just like I mentioned about a lot of data being generated so and so forth and you need a system to to store and manage it but actually if you think about it it's actually much more than that because when you have data in itself it doesn't really hold any okay so I mean as humans we usually like to classify things categorize things so that's where the dbms starts coming in because they provide a natural means for us to give structure to the data okay meaning to say that it's like more like organizing I mean I'm sure that all you girls and guys out there when you are studying you will keep all your local actual proper folders in a different category so similarly dbms to all data sets okay and not only that it helps us draws a relationship between them okay that makes it like for one particular data point how is it going to another data point which later there will be some examples to show you it allows you to do simple operations create machine updates as well as to read the data okay you although I'm not much of this but in your future readings you're going to see a lot of this so that's pretty much a key way of saying that you can do manipulation to the data so as a front-line so the basic operations create machine updates and when you have multiple users dbms supposed to a lot of currency security as well as data integrity okay so that much for dbms not just going to do a side digression because after all I think all of you would have seen from the email that this session of data warehouse but surprisingly I didn't even touch similar term of data warehousing yeah because data warehouse is to me more like a generic term used for enterprises in your day-to-day world people when you're doing databases and this is not like an academic kind of discussion but an actual thing so but what just what it actually means is it's more like a collective of databases okay and sources that allow for important data warehousing so dbms if you can look at it this way is a little big like subsets of a data warehouse data warehouse is just like a fuzzy term to describe the whole collective databases that's being used in a cooperation so these are just some of the work clouds of the generic terms that you see like normal level important data it's kind of funny which of the record doesn't really make a lot of sense to me yeah so um yeah so even though they have a lot of people or experts in data warehousing but in actuality I mean if you were to look in the industry whenever they refer to the data warehouse they are pretty much referring to database and the database dbms that we are used to is other data warehousing terminology is more what they call the OLTP or online transaction processing whereas data warehouse is more for online analytical processing to be again after I count or it's actually recorded it's hot wash because the thing is that with the increasing power of computers as well as the increasing efficiency of all these dbms systems what you find is that the dbms can actually perform a lot of you know large scale data operations in the industry already without really referring to the concept of data warehousing so which is why this is the reason why a lot of people talk about data warehouse just to focus more on dbms you'll find that you have corporations large corporations that pretty much run entire operation of my SQL my SQL okay like for instance the most popular one through Facebook but first people they have a lot more stuff but even actually the entire data business can be my SQL wow right so if it didn't make it it's really like if it didn't make it don't want to work okay so hopefully by these views like I can let your head be quick overview of dbms why it is important and how pretty much it affects you basically affects your everyday lives even without you noticing it because I think all of you are exposed to it somehow just that y'all do not realise it so hopefully I can come here to give you more awareness of what you actually didn't bring so with that I went to get the session setting questions and comments what is my background okay okay yeah I am a computer science major for interest okay my career started off in research by my teacher research so which is why all the data comes in because in life science they also give you it's not just where I manage my knowledge now it's a lot more than that they have things that microarray machines programming to raise which basically provides millions and millions of data points so slowly data and managing and analyzing them is a what I do on a daily basis last time 4 years ago I jumped in the street so now I'm in the finance industry again I see numbers right now it's you know financial numbers but still database is still quite important and yes I do use my still the the sensor version okay awesome what else do I know living problem okay what million oh no no machines ah you see that super expert you know you really know take the first one okay right in that case since it's still early okay can I have can I know who hasn't installed the two software that I've asked to install can you all install it right now okay I can walk around happy you for those who are ready to install please try to run that ah there's just this yeah there's two software that I need to try to install one is the the my sql server which is available via this thing for xampp and the other one is a my sql patch okay by the way this can be grant you don't have to listen to me for those who already install can just go here you know do whatever but I'll just run off for a few more minutes just like I mentioned that my sql is the second most what we use on dbms on the world it is true if you look at it you can begin it's actually down there we had to do it yesterday but I highly suspect that it's popular because it's free and it's actually a kind of a client server mode of operation which is whereby we have a server running as back end managing operation and you have a front end to connect with and which is why anyone has problems on this by the way xampp is just an acronym for for I forgot it's yeah it's the A stands for Apache the M stands for my sql the P and the P stands for Pro-MPHP it's actually a host-type solution for on-line and but it comes with a lot a lot of other rubbish which okay so how it looks like once you if you have a tongue line you don't really need to connect with or you just have to find out what accident it is and so okay so for those who have installed you should be able to see a screen something like that just make sure that when you click on my sql database it's running okay yeah so you don't have to worry about that pasang, please yeah okay, just okay, y'all can get busy with your host-type I'll just walk around and help you once so yes, y'all just run y'all can you just recite this one is run this one no it came between issue okay, yeah so it's running so it's running at the moment and I use the pre-pensh yes but you can start everything if you want to but I'm only interested in my sql so just make sure that that one is free and that will be fine I need to check my own as well come on, make sure you know my third third okay, coming over one more match I just need to make sure that mine is already just probably just now you might even just switch out the connection for a while recognizing you know this is going to be a little bit embarrassing I checked my machine this morning it works but now it doesn't work just let me get mine only one start up this is small and run okay, this is the interface for this server just make sure that the entry that says my sql database if you have a start for Windows user there's a start button beside it for the bank user just make sure it's green color and it's running okay, this shows that my sql server is running in the background and for those who have successfully reached this stage can you please just watch your my sql mode bench for those who have downloaded the newest version you should learn something like that one thing which I want you all to take note of is that sorry default I believe most should have this small button guys I don't know what you all can see it's actually like a boom bump to the connection okay because this is the client software you will be able to connect to the server and follow the communication so for those who see an empty space down here okay just click on just show you the actual thing for those who do not have this thing just click on this plus button down here and I don't have the time I think as I did your connection name you want to give your fans just say my super awesome connection and click answer and before that if I want to test the connection first bing successfully made okay and just click okay and it should appear as the second as of now for those who are using an older version of sql mode bench she may look somewhat similar you may not have the plus button just try because without the clients or when you may not be able harness the power of the sql server right and now while you guys just say who said problem right now okay one, two so you can say yes yes yes yes my sql program sql sql sql sql you may look nothing technical but later on you'll try to yeah so first thing yeah sql tiba-tiba tiba-tiba tiba-tiba tiba-tiba it's a little bit like a more powerful version tiba-tiba tiba-tiba it's like a win system okay okay but you're right now yeah okay oh it's a sql sql sql sql sql sql sql sql sql sql sql sql sql sql sql sql sql sql okay okay okay Okay so so so so Sebenarnya, serva harus dipercayai. Kerana serva akan dipercayai. Apabila klien cuba menghubungkannya, dia akan menghubungkannya dengan tidak. Sebenarnya, saya tidak ada yang menghubungkannya. Saya rasa kita sudah mempunyai pengalaman. Jadi, tidak boleh mempunyai pengalaman. Siapa masih tidak mempunyai pengalaman? Ada apa lagi? Ada apa lagi? Saya hanya menghubungkannya dengan tidak. Untuk menghubungkannya dengan tidak, sementara beberapa klien masih cuba menghubungkannya. Mungkin anda akan faham beberapa minit. Anda menghubungkannya dengan tidak. Anda tidak akan melihat keadaan yang sangat teruk apabila anda menghubungkannya. Sebab itu, anda tidak mempunyai pengalaman. Sebenarnya, saya akan menghubungkannya. Anda dapat melihat keadaan yang di dalam kawasan, sebenarnya, untuk menghubungkannya dengan tidak. Untuk yang anda lihat, saya tidak mengapa apa yang anda nak. Jadi, anda dapat melihat keadaan ini, untuk anda mempunyai keadaan yang tidak dihubungkan. Kepada keadaan yang di-hubungkannya, saya sudah menghubungkannya, cakap saya dah omong-omong-omong Alfred G entrepreneurship. Tetapi anda harus menghubungkan sesuatu macam Ding-Di, yang adalah melepas sikaman dan menarik. Saya Merualchi keadaan ini. Anda harusbelievable insRC dengar. Tidak saja, s melodia yang berbeza bagi yang berpakaian dalam segalaände. handles.這個是 tempat lebih kedatangan yang anda akan hopeless untuk menghubungkan juga menjadi jahan academic dan kemudian di sini, ini sedikit seperti excel, terutamanya Kind of Star yang akan menunjukkan keputusan, dan ini saya hanya seperti pakaian, jadi saya tidak akan mempunyai banyak keputusan. Dan semoga pada akhir hari ini, anda dapat mulai memasukkan beberapa mesyuarat ke pekerjaan yang berlaku, untuk melakukan apa-apa yang anda fikirkan. Tapi setelah itu, saya akan menunggu anda. Saya tidak akan mempunyai semua ini, tetapi dua perkara yang anda fikirkan adalah keadaan panas di sini. Baiklah, ini sangat baik. Menurut saya, saya selalu memasukkan keputusan. Jadi, apabila anda memasukkan keadaan, anda hanya perlu memasukkan satu-satunya keadaan untuk memasukkan keadaan yang berlaku untuk memasukkan keadaan yang berlaku. Yang lainnya, anda tidak perlu risau, anda tidak perlu memasukkan keadaan yang berlaku. Yang lain yang saya akan memasukkan keadaan yang anda akan memasukkan dan melihat, adalah keadaan panas yang berlaku. Anda tidak perlu memasukkan keadaan yang berlaku. Ini akan menjadi sesuatu yang akan berlaku. Sebabnya, bagi yang anda menikmati, ini adalah sesuatu yang berlaku. Selain itu, keadaan panas yang berlaku adalah keadaan keadaan yang berlaku. Jika anda hanya memasukkan keadaan yang berlaku, sebelum anda menikmati, saya tidak berfikir saya sudah terima dalam ini. Banyak sebab saya memasukkan keadaan yang berlaku. Kita akan menggunakan keadaan yang berlaku untuk menghiasan perkaraan untuk mengenai... ..yangénya, saya akan memasukkan keadaan yang berlaku di negara yang berlaku. Saya akan membuat tempatная keadaan yang berlaku. Sebab itu, saya akan memasukkan keadaan yang berlaku. Sebab untuk memasukkan sebaru dan pada masa yang sama, ia menyebabkan perasaan grafis yang digunakan untuk membuat perasaan data yang terlalu menarik. Meskipun tidak terlalu banyak, tetapi kita akan melihat dengan baik. Jadi, anda akan melihat bahawa anda akan menggunakan perasaan yang terlalu banyak untuk menunjukkan cara yang ia ditempatkan. Jadi, tiada apa-apa yang anda lihat, perkara yang anda lihat di seluruh, ini sebenarnya tidak menghubungi satu sama lain. Baiklah. Jadi, kemampuan ini, dipercayakan beberapa perkara grafis yang anda lihat, apa yang anda lihat sebenarnya dipercayakan dengan hubungan dan hubungan ini. Okey, bermakna, kami akan menjawab lebih positif kepada gambar yang lain daripada yang anda tahu. Sebenarnya, jika anda melihat semuanya, anda akan menghubungi satu sama lain. Tapi, ia perlu menjadi cara yang anda tahu, mengembangkan keadaan yang anda tahu. Jangan risau tentang bahagian yang anda tahu, saya akan menyebabkan. Ada peluang di dalam... di dalam... di dalam... di dalam... Okey, anda lihat apa ini? Sakhila NWB, NWB itu atau sekarang, masalah masalah. Masalah ini hanya mengharapkan NWB. Ia... anda akan mencari masalah dan sebagainya. Anda baru melakukan ini, dan kemudian dalam NWB, anda hanya mengembangkan, mengembangkan, dan anda mencari. Saya rasa itu adalah penting. Dia hanya meminta saya untuk berharap mencari sesuatu yang anda lihat. Saya hanya mencari keadaan yang anda tahu. Saya tidak mengharapkan. Mungkin bagaimana anda beritahuan. Saya tidak mengharapkan. Saya juga berharapfood yang anda tahu342. Saya tidak mengharapkan. Saya sudah mengharapkan sebab bahania anda tahudot. Hebi,ises, ketika anda men permet alasan ini reflectsyer. Mencari alasan ini reflectserasana. Saya cannot factories, sabia ni tidak ada masalah digital. Kalau e-mail yang terbaru, Orang-orang yang berjalan-jalan, saya boleh beritahu beberapa orang di sini. Saya masih sedia. Yang terakhir-akhir, saya hanya berkongsi dengan kamu. Kerana perkembangan, sekurang-kurang-kurang-kurang yang pertama, akan lebih kecil daripada kerja. Dengan itu, boleh saya berjumpa pada sesi yang berikutnya? Bagus. Okey, jadi sesi yang berikutnya yang saya akan bercakap tentang adalah apa yang dipanggil perkembangan entiti. Di beberapa cara perkembangan entiti, saya percaya setiap orang yang sudah tahu apa itu, hanya dapat membuat percayaan. Kerana cara yang menurut orang-orang berfikir bahawa data sangat mempunyai perjalanan yang tidak terkenal. Sebenarnya, kita akan memikirkan sesi yang pertama yang kita lihat. Oh, okey. Ia adalah mengenai perkembangan, mengenai perkembangan dan mengenai perkembangan untuk orang-orang berfikir dan sebagainya. Jadi, sesi yang mengenai perkembangan entiti hanya adalah cara untuk menghalang seluruh apa yang terjadi supaya orang-orang berpikirkan apa yang anda tahu. Dan itu akan membuat perkembangan sebuah desain. Pasti anda boleh memikirkan sebuah dunia yang lebih mudah. Jadi, Pada masa pertama, ini adalah sebuah teori untuk membuat penggunaan dengan database yang digunakan di jalan yang tidak terlalu tinggi. Jadi, keadaan pertama adalah untuk mengorganiskan. Biar saya katakan bahawa anda sebenarnya ada banyak bahasa yang tidak terlalu tinggi dan saya sangat menyukai data yang tidak terlalu tinggi sekarang. Tapi jika anda ingin menggunakan apa yang anda ingin tahu, dan menggunakan semua bahasa yang tidak terlalu tinggi, pertama, anda perlu memikirkan bagaimana apa yang berlainan dengan bagaimana dan bagaimana yang berlainan dengan bagaimana yang lainnya. Jadi, ya, keadaan pertama adalah untuk menggunakan keadaan yang terlalu tinggi. Dan di bawah keadaan dbms, maksud saya, anda sebenarnya ada 3 perkara yang anda dapat mengikirkan, atau apa yang berlainan, yang sebenarnya berlainan dengan sebuah bahasa yang tidak terlalu tinggi, yang anda menginginkan dengan bahasa yang terlalu tinggi. Dan keadaan ini boleh menjadi keadaan yang terlalu tinggi, dan keadaan yang terlalu tinggi, dan keadaan yang terlalu tinggi. Dan biasanya, bagaimana anda? Mari kita berkata bahasa bahasa yang terlalu tinggi, oleh lelaki anda, atau apabila anda cuba mengenakkan banyak bahasa yang tidak terlalu tinggi. Kalau ada bahasa yang berlainan dengan bahasa yang terlalu tinggi, biasanya bahasa akan menjadi terkejut. Tetapi, ia berlainan dengan bahasa yang tidak terlalu tinggi. Ya, dan, ya, keadaan akan menjadi hubungan, dan keadaan akan menjadi sebuah bahasa yang terlalu tinggi, Tetapi, esok yang Ia buat ialah perniagaan grafik untuk perniagaan data. Jadi, tidak ada apa-apa yang masih diberikan di tempat yang baik. Tidak ada apa-apa yang diperkenalkan oleh perniagaan perniagaan di perniagaan. Baiklah, jika anda fikirkan tentang... Baiklah, ini saya boleh beritahu, kerana perniagaan perniagaan perniagaan, jika anda membuat perniagaan perniagaan, ini akan berkata, kita tidak menunjukkan mereka berjaya. Kita menunjukkan mereka perniagaan. Dan yang itu adalah kemungkinan yang perlu dibuat. Apabila anda beri masalah dengan mempunyai perjalanan atau memahami perjalanan. Jadi, iya, seperti yang saya katakan. Menjadikan perjalanan yang berlaku untuk menggunakan perjalanan yang berkongsi dan menjadikan perjalanan yang berlaku. Dan perjalanan yang berlaku adalah seorang orang, ia seperti seorang istimewa yang mempunyai perjalanan yang berlaku. Ia seperti kemungkinan seorang istimewa yang berlaku. Yang berlaku adalah seorang istimewa yang memperkenalkan perjalanan yang berlaku. Menjadikan perjalanan yang berlaku bukan iya seperti yang saya katakan. dan setiap orang yang menggunakan perjalanan atau mempunyai perjalanan. Jadi, seperti contoh, yang anda boleh menjadikan adalah seorang petunjuk yang panjang. Anda boleh buat seorang utama yang paling dikuatkan. Saya akan menjadikan. Okey. Biar saya beritahu apa yang dilakukan oleh antara menangani sisi yang berkumpul. Jangan perlu memasak. Maaf? Ya, Tuhan. Okey? Tuhan? Dibuat? Satu saja. Okey, division S2 dan yang lain. Jika anda menganggap itu, jika anda mengikuti perniagaan yang menawarkan perniagaan dan perniagaan, anda akan memasak itu. Jika anda mengukul perniagaan dan perniagaan dan perniagaan, anda boleh memasak itu. Dan saya juga dapat melihat sebuah 480 kategori untuk mengalami kawasan. Jadi jika anda ingin menggantikan, saya dapat melihat bagaimana anda melihat itu. Ya, saya berkata bahawa ini adalah 7 nama. Okey, ada beberapa cara yang anda dapat mengenai. Anda dapat mengenai seperti penyelamatan atau sesuatu. Jadi, ini tidak menarik sekarang dalam bahawa anda akan mendapat bahawa. Saya dapat melihat ini adalah hanya yang saya buat. Ia adalah sebuah istimewa seorang yang memperkenalkan keadaan yang particular untuk menjelaskan ini. Ya, kita boleh menyebabkan teman-teman. Sebenarnya, sekarang kita telah memilih perniagaan, perniagaan, perniagaan, perniagaan, dan setiap satu perniagaan ini akan segera selalu berlaku sebagai perniagaan dalam perniagaan data. Sebelum saya bergerak, saya harap semua orang akan faham sebab apa yang saya maksudkan dengan perniagaan dalam perniagaan data. Sebenarnya, saya akan memberitahu anda bahwa, saya akan melihat apa yang saya betul-betul jelas. Dalam perniagaan yang saya menunjukkan, anda akan melihat beberapa perniagaan di dalam perniagaan. Setiap perniagaan, dan ada apa yang akan digunakan untuk memerlukan perniagaan. Jadi, anda dapat menjelaskan setiap perniagaan sebagai perniagaan. Demi, perniagaan mengingatkan perniagaan dan kekulungan. Nah, kekulungan, dan kekulungan atau instansis peribadi peribadi Ia adalah termasuk Nibia Jadi... Ya... Jangan risau Okey, jadi Pertama-tama peribadi Bagaimanapun peribadi peribadi itu Bagus Pertama-tama peribadi Kami akan bercakap tentang bagaimana peribadi peribadi berlainan Untuk apa dan lain Inilah Saya akan meminta ini dan tiada masa untuk meminta animasi Jadi kita akan berhenti menghentikan Kami boleh menghentikan hubungan kita hubungan kita adalah hubungan antara antara dan ia lainnya dan ia biasanya menghentikan peribadi Jadi... walaupun saya tidak akan pergi Helo, 1, 2, 3, test Terima kasih Terima kasih Jangan risau, saya masih akan menghentikan Saya hanya perlu menghentikan peribadi saya lebih kuat Dan... untuk pelajar yang lebih senang mungkin nanti saya dapat melihat air di sini Saya hanya menghentikan, minta maaf Saya hanya menghentikan, saya boleh bercakap Jadi anda dapat melihat peribadi ini di sini Saya tidak benar-benar menghentikan tetapi ini adalah sebuah rupanya sebuah rupanya di kertas Kenapa saya tidak mahu menunjukkan kerana rupanya yang anda akan melihat di sebuah rupanya akan mempunyai perbezaan Tetapi saya hanya menghentikan di sini untuk biarkan anda melihat bagaimana kita sebenarnya mempunyai hubungan antara antara antara apabila anda ingin menghentikan peribadi anda Sebenarnya anda menyebabkan peribadi, perniagaan dan pekerjaan Jadi hubungan kita biasanya mempunyai hubungan antara antara antara untuk menghentikan peribadi dan pekerjaan dapat menghentikan peribadi sederhana sebuah rupanya yang dapat menghentikan peribadi juga sederhana Okey Sekarang kenapa kita menghentikan hubungan ini? Sebab kemudian kita perlu mempunyai atau menghentikan bagaimana untuk menghentikan peribadi yang berbeda di sebuah rupanya Dan salah satu perkara yang kita perlu menghentikan adalah kardinaliti Terima kasih Okey kardinaliti Sekarang perkara itu mungkin mempunyai sedikit tetapi sebenarnya ia hanya sesuatu yang kita cakap dan saya tidak tahu bagaimana untuk menghentikan ia hanya untuk berkata bagaimana banyak peribadi yang berhentikan bagaimana banyak peribadi yang lain dan kenapa ini penting? Kerana ini akan berlaku nanti apakah tidak peribadi akan juga dipercaya sebagai peribadi yang berbeda di rupanya Okey Jadi untuk kardinaliti kecuali Ya, saya menghentikan banyak peribadi yang berlaku Bukan itu ada apa yang terlalu banyak dan banyak-banyak Bagaimana anda dapat mengenai yang menurut saya? Bagaimana anda dapat mengenai anda mencari tangan, bukan? Tidak Ya Sangat baik Sangat baik ia berlaku di banyak kecuali Tetapi, ya, itu adalah kecuali yang baik Bagus Apa tentang apa yang terlalu banyak? Ya Puan boleh mempunyai banyak kerulik Sebenarnya Sebenarnya, di banyak kecuali dan itu adalah contoh yang baik ada kecuali seperti pada peribadi saya sendiri saya menghentikan 2 orang jadi saya dapat mempunyai 2 peribadi Tetapi, ya, saya membuat 80 peribadi betul? betul betul betul Jadi, ya, peribadi saya bermaksud nama itu sudah membebaskan sebuah hubungan yang kita dapat Jadi Ya, untuk kecuali saya akan mempunyai jadi saya dapat tahu bagaimana nama itu Ya, itu apa Saya akan menghentikannya Jadi, itu apa yang mereka katakan dalam kecuali kecuali anda akan mempunyai semua pelajaran anda atau semua kecuali anda seperti pakaian dan ya, itu yang saya lakukan Saya minta maaf Maaf Okey, jadi Ya Jadi, ini adalah hubungan kecuali yang anda boleh mempunyai antara kecuali yang berbeza Bolehkah anda? Mungkin saya akan menghentikannya Mungkin ia akan berfungsi apabila anda berada di sini Baiklah Sekarang, saya hanya menghentikannya Lepas itu, anda akan melihat bagaimana hubungan kecuali ini dan hubungan anda akan mempunyai dan anda akan mempunyai apa yang kita nampak kecuali kecuali kecuali kecuali yang saya menghentikannya dan saya akan menghentikannya kecuali kecuali kecuali yang berbeza Jadi, bagaimanapun, anda dapat melihat hubungan kecuali ini Jadi, satu-satunya adalah bahawa kecuali kecuali anda boleh mempunyai satu penjara dan satu penjara dan satu penjara dan satu penjara dan satu penjara Tentu lagi, anda mungkin menghentikannya tetapi sekarang, kami hanya menghentikannya Dan perkara yang sama, kecuali anda boleh mempunyai Jadi, kecuali kecuali terakhir adalah kecuali kecuali Jadi, kecuali kecuali anda adalah kecuali yang berbunyi dan kecuali anda boleh mempunyai saya akan menghentikannya sebab nanti anda boleh membuat kecuali kecuali kecuali anda tetapi, kecuali kecuali anda adalah nama yang seperti Gendarm dan kecuali kecuali anda tahu adalah perkara yang menggantikan dan kecuali kecuali anda boleh menggantikan ia boleh menggantikan hubungan hubungan seperti, pada istimewa kita akan menghentikan jika anda ingin menghentikan cara yang berbeza jika anda akan menghentikan pasang merekan HDMI Kemainfolda Jika hubungan ingin berubah masalah mel Snapchat traveling ...untuk membuat mereka sebagai pembentangan dalam database. Dan kita perlu memasangkan perjalanan. Jadi, di terbentuk yang anda berpikir, ...bukur database yang anda akan mencari dengan membuat perjalanan. Terima kasih, tidak ada sesiapa. Ya, saya tidak meminta. Jika anda mencari yang lain, ...mereka tidak akan berkata tentang masa untuk beri kejadian. Sebenarnya sekarang saya ingin tahu bahawa, di kawasan ke-4sql yang berkongsi untuk ke-4sql, sehingga dikongsi ke-4sql, pada kecuali ke-4sql, anda akan memperlukan ke-4sql dan kecuali ke-4sql untuk memilih. Ini lebih daripada komputer, kerana di belakang saya perlu beritahu apa yang kita nak kata dan kecuali ke-4sql Jadi anda ada perkara-kara yang berkongsi untuk ke-4sql dan kecuali ke-4sql dan kecuali ke-4sql dan kecuali ke-4sql Dan saya perlu beri ke-4sql untuk menghargainya, seperti kawasan ke-4sql yang berkongsi untuk ke-4sql untuk memilih dan kecuali ke-4sql kerana sekarang saya perlu beri ke-4sql untuk kecuali ke-4sql Untuk kecuali ke-4sql untuk ke-4sql untuk mengalami dan kecuali ke-4sql adalah hanya terma dikit atau maksudnya adalah sebuah kecuali dan kecuali ke-4sql dan kecuali ke-4sql dan kecuali ke-7sql dan kecuali ke-7sql Yang lain yang saya nak cakap adalah cara-cara jadi di SQL SQL VARC HDR stands for just say that you can have any length but of course for the more advanced one you really want to optimize the space usage then you can sometimes specify the length of the character that you want to represent I think if you want to create a table which stores people with their NRIS number you know that NRIS number will go like 300 characters at most 10 characters so if you want to specify the same character 10 so in SQL but if you do not want to care but all these things then move back and last but not least is a wooden distribution straw box confused some other terms all the things speaking last time I already know where to put this thing in because it's a little bit as you're specific but yet at the same time if you do not know these terms it's going to be a little bit challenging to try to control the direction but now just bear with me for a little bit and just try to so in addition to just having attributes in order to have some attributes sometimes play a specific role in a table the most important being the priority okay so primarily one of the best example is your NRIS number everyone has a big NRIS number and you must have NRIS number and I'm hoping to learn a bit about what I'll be doing in the future okay can anyone tell me whether a name can be a priority sorry because people will say name not necessarily like for instance your sometimes if you log in to the system you can provide username some systems employee number employee number it can be an example and sometimes if it's not necessarily it can be like NRIS NRIS it can be a combination as an example as long as it includes a material and identify a word it's not necessary that everyone must know but if you design a database most of the target I would recommend is one field to be used as a priority for ease of identification okay and actually it's constraint not now basically means that this variable cannot be now unique ya or any big funny thing that is the priority even if you log in to a second picture another stack can be used so it's not unique ya so i think it cannot be used as a combination ya i rule myself right auto increments you don't need to worry about that right now it's usually used for numerical ID it just means that if it's a one record it will also increase by itself so as to ensure it is and this thing is going to be a little bit for a key so let's see let's say for instance sales sales table will be made by a person and it will also be okay let's say it will be made by a person so obviously in sales table you need to have a reference to say which person make that sales so in the sales table you will have one copy employee ID it's actually not an idea of the sales but it's actually a printed idea because of making the sales and then the prime can wait for a T because it is a T that is reference to a different table for example now if all the boring is out of the way let's try a cycle diagram i'm going to sit down okay so how do you draw an SKL can you all see okay awesome so how do you all create an ER diagram using this SKL workbench it's pretty much quite simple you just need to click on add diagram and it will give you this nice okay it's not very nice it's just like an empty canvas okay so okay so the example is ya it's my fix obviously it's a robot of metrics it's a business entity that rents up to its members and its customers so the steps are as involved i think number one we just want the example first to identify the entities so it's giving them appropriate names so that they can easily understood three relationships we should connect entities and four each attributes should have a unique name so given this example okay some of the tables i won't click okay it will double click this thing will come out so it has members okay so i'm just going to i'm just going to go without mic hopefully y'all can hear me if not, just follow what is actually on the screen right now so right now what i'm doing is effectively i'm typing out the different entities okay hold on i'm just okay so pretty much you have members and movies okay members want to rent movie and just now i mention about cardinality where one member can rent out several movies and one movie can be rented by several members at different points of time so under the end to end kind of a scenario what usually happens is that the relationship itself will usually exist as a table too so that's where i create a separate table which currently i call it rental and you're going to have these 3 3 entries down here okay so i've got the entity, members and movies i've got the relationship which manifest itself as a table which i call it rental the next thing that i want it to do is i want it to give them attributes so what are some of the attributes for instance member you will have things like member id okay and member id let's say i want it to be because it's going to be uniquely identifying each member so you see down here at the column pk for those who play online games pk doesn't mean that you will be killed it stands for primary key primary key primary key but if you hold around you can do what it is so you can do whatever you want and okay so i'm just going to carry on typing i'm not denying but hopefully y'all can see what kind of thought process that goes into creating the entities you can see okay well actually if you refer to the slide the answer is just in the next slide but i just want you to see the actual process that means y'all never read the slide people coming here la hahahaha i want copy and paste let's try not to do that okay actually this is already shortening the thing because by right usually we will type sql statement but it's obviously more difficult to do that so we just do it this way but whether or not you can copy and paste depends on this world branch personally i never try using that so you can go here and try if it works let me know it works you have to tell the class how to do it awesome i'm very looting ah so this is what i want to see man come on let me see a few for one table to another table share be a face anyways i'm just too used to tell me um anyways so by the end of this if you get something like that just three tables two representative entity and one representative entity relationship now just now i'm going to go home and i'm going to give you a couple more minutes don't worry too much about the content ah okay except for the ids ids mixture and ids region i'm going to teach you how to create what we call the foreign keys constraints and the key obviously must be mentioned so things like member ids, movie ids the ids mixture and the ids region the rest just randomly excuse me the names can be dash in fact if you want to be try to even be space but based on your queries if you have space in column names that's what you should try to do like movie underscore id if you have space it will still work, no issues it's just a temporary it will still be otherwise the query will be so typically in practice when we have a few names that comprises of more than one so we will just either separate it by an underscore or you can combine it together as one word or you can sometimes really easy to see the year release and remove underscore and R so it will make it easy to see it's not really mean proof from computational point of view because to the STL server it's just characters but it's more for humans i mean if you have inside the database or somebody else to use and your column names are super super pretty long next thing you will find is that it doesn't matter tell me why i thought you can zoom in because you can't see at the back is that display mode there is a way to zoom in no 100% come on there you go just put this down so how we are still trying to just carry on if you want to declare a relationship between the different tables as an actual now we don't have a relationship like this now we need to let the server know that so there is a relationship to do this please in relationship using existing columns the rest and the capabilities as a yeah you just need to click environment same thing so you can see as it starts coming out see this so this is actually a declaration yeah let me just write this i need to just leave it down here see this you just need to highlight because you can connect take those the member ID and the movie ID will later on be designated as foreign key because member ID doesn't really belong to a writer it belongs to the idea of the member is something so we just start by click on the numbers and which are we give to the member ID of members and everyone yes particular yeah the first one that you press must be must be the rattle it's a different it's a different so the first one is child okay because the thing is that many to many relationship in database you will meet an intermediate table which will be relationship that will store the many to many relationship okay so how you read this thing of this triangle thing like here is actually the many and this is the one so one member can have several rentals one movies can also have several rentals and by transitivity one member can have seven movies and one movie can be rentable by seven members so that's how the end of the relationship can set up sorry, just to clarify first you click on the child first then click on the card yeah, which is why i really hasn't learn for a month it may have to then change but in actuality far right it's not really actually it's more like i'm so too wrong let me let me have time to give up there's a term that sit on here reference okay i guess i guess in a way you can view this time reference the columns as a clue okay, because member ID who does member ID okay, so the member ID cannot be the reference but rather the member ID in the rentals this is a reference so when you click first it's always click member ID i think there will be easy to visualise visualise sometimes it just to give an actuality yeah sorry no, actually the rental the column member ID is referencing the one in the member so it's referencing that this is a reference column yeah, correct so okay, the M to M is from here to here D7 okay it's one there are 1 to M 1 to M that's how purest thing is that M to M cannot be achieved in database without an existence of an intermediate relation so if you take the relation is M to M relation then that relation will manifest itself as an actuality and between that relation to the entity that we bring so it will be your 1 to 1 yeah, the first one oh, design? yes okay, actually that's a very interesting question honestly to tell the truth I don't actually use it but you can use it, you can use it I don't think you can use it on the one you don't use it on the database the one that you use will be the sonic line which essentially can make the 1 to 1 which is the idea so I'm not sure but hopefully later when we try out some examples and review the better, I appreciate this concept right now, if I were in your shoe and somebody tell me this kind of opportunity I was in that home but later when you see examples hopefully it will make a little bit of sense out of it let's see and I have a better example okay then later when we review some examples there will be some examples and I will try my best to refer them back to this kind of a sensual event and I'm very interested in what it is right now, if you just have to be aware of the relationship you don't have to be so only clear of the actual mechanics of making mistakes the member ID Rento's table is the reference to what yes, that's correct what symbol? well, this thing is only specific to you do the drawing of an actual library in the workplace you just need to do this and actually understand so in fact right now, I'm just saying one to one again please don't take this to be an example just now, if you break it down it will have to end even between these two villages there will be one to ten one to ten okay, that's what explain my previous example yeah, I should have brought that sorry there's multi-division structure multi-division multi-division but there's one to ten yeah, yeah okay multi-division, I want to clarify let's say for instance, one to ten contains do not necessarily need to be a table why? because contains will most likely appear as entirely department so department will have let's say division ID and that will be the reference column okay, and that column will respect department is easier to go back anyways okay, let's what is the question yeah, question first one I did 10 different relationship then the line for a relationship is the solid line if we use another one then place a relationship using 16 column so it will be in magic I just want to know the difference between these two weather is bad different yeah, yeah sorry if we use if we use this one that's fine okay okay, I think because currently yours why is the first as long as this is the first so first relationship yeah was bad, I think the parent child will be confused just make sure as long as the first column that you click belongs to ID that does not identify the entity so the first ID must be because otherwise it will specify okay okay, never mind let's move on because later on you have more than enough opportunities try this is just an example that I want to show you yeah, just that I mentioned as recently as many child actually this group is running off but now it has a lot more so you can see now here I actually grab all the nets this is the schema that has been used by Facebook it may look a little bit daunting but I think right now it's a lot more complicated than that and just something for your own interest now before we break off from lunch I've got three problems one is Music Database one is University Database and one is Database so let's see can I have everybody in the first this called tryouts problem number one in your individual groups that means one table will come up with one diagram one table will come up with one diagram one table will come up with one diagram one table will come up with one sensible these three tables and tryout exercise number three if you don't recommend for lunch I will keep you all learning this to discuss amongst yourself we need a please group yourself into the individual tables if you want to do that individually can but I want to keep it you know it's fine you all don't talk to me but at least talk amongst yourself after learning after lunch I will want a representative from each from each column to tell me to basically explain and explain so okay so with that the time now is 12.08 late by being released I guess lunchtime is 1.08 in the case of your reaction we'll come back at 9 4 we'll come back at 1.10 and I will give you all a few minutes it doesn't matter if you're wrong I just want you all have the experience of going through designing a program okay questions and comments very awesome so for the morning session 2, 3, 4, 5 35 6, 7 so more towards older than 35 and around like a few and one okay answer and lesson what can I make it don't worry how is it 39 I'm talking about this thing okay ya ya my problem can I start yes okay let's download the I don't think they can upload they can't upload some of them oh okay okay which which group has finished problem number 1 raise your hand to this ya okay can you all come up in front handle the mic more please present an answer for those who are not finished please compare the answers to what we have I won't have time to run through each and every team so hope you guys understand that and I'll be back and I'll be back okay okay ya ya ya ya ya ya ya ya okay okay it's so small can I just open the project ya download it so once I download it and I can zoom in so small okay okay do you kind want to see all the question ya ya so our group did the number 1 question which is the music database so if you have the notes with zero I think you can still look at the description of the problems so basically it's trying to say that there is a music store like some database stores which stores is known as music collection so what it means that there are in the collection there are album artist and there are tracks so it's describing like the relationship between this three three and the three items so and then so in the requirement he had describe what specifically is the relationship between them so it's saying that there are albums and one album is made like you want artist but an artist make one or more so then it's indicating it's one to many relationship so then it's per artist is the parent and our section is a child so and then if we look at if we look at number 4 and onwards so it's saying an album contains one or more tracks then it's indicating it's one to many relationship so album is the parent and the tracks as a child so the rise of that is saying all is having a name for each track so it's saying each track have a timeline which is action by seconds and when the track is played so when does this track begin this should be recorded so as well as the number of times music by artist okay so we still kind of recommend get to the work that we have done so so basically we create 3 entity types so one is the track and the album and the artist so as what we found in the artist we put in specifically an ID so that it will be more identifiable instead of using name which is sometimes having some problem so that's why we put the artist ID and we put the artist name and this album entity type so we put album ID album name specifically we put an artist name which is I think it's kind of optional but we put it there and then for the track so we also put an ID we put a name and because it's required by the requirement so that's why we put the timeline and also we have a start set as required and it's top so we put album name as well and I think we also consider putting the number of times that we're going to get played and I think it's also impossible to accept so basically that's our work so as I said just now so from artist to album it's one to many and from album to track it's our work any questions concerns disagreement so because we are so you want to know which has the column so we use the artist ID so we are okay right yeah right you're right so I think this presentation is for everyone to learn you're wrong probably I think it's better if under here there should be an album ID and artist ID and even I think there should be a track ID so yeah you're right so here should be a track ID and this one should be an album ID and then we can use this one I think the relationship between this two should be album ID two as the one that we showed last time yeah that's cool so I can't disagreement I think there is also data time we start time maybe it's not so it's more charged alright I think yeah yeah that's right actually that's right we should have changed the data time for me better anything else so I think the spots that should be changed or enhanced in other outcomes I have one question so the names what is the title yeah okay so actually actually here we put the wrong name that's why the variant should be the album ID so you think okay okay so invest that okay plus any other questions or comments if I can see that before that yeah minus stuff if I can see that the identification of the entities it might actually pretty well fall out but have just a couple of minus stuff like for instance instead of using the artist name should have used the artist ID and instead of the album name she used the album ID and a good spot on that about the start time which I also didn't notice but aside from that the attributes, the entities and the intention that she wants to relate to entities are actually correct so if you actually create a table for this to be used which can be used in actual database system okay okay so very good thank you yeah like what? collection of the albums oh yeah okay yes, that is correct you spotted something so there was a very good question well that's good observation okay in addition to just history and entities, there could also be an additional one which is called collection alright and collection can actually be well, back in general the parent child relationship it's like a paragraph of the album wide across and then across the street okay but what we can actually look out for is that the collection extension not really so much related to sleep with the artist so it doesn't necessarily have a relationship between collection and eyes so these two can be separate but yes, I agree, collection is our special relationship meaning to say the albums that could be one additional color to say collection might be something like that so very good what's that name? please introduce yourself okay, nice bad okay, awesome the second problem is universe database so from your side who has come to learn the answer yeah the problem is today it's okay, everything is working it never happens i don't know i don't know which is the one that I need which is the one that I'm supposed to download sorry what am I doing okay what happened? i don't know okay, this one okay okay, so can we invite the second someone or second person to come and scratch c'mon, let me try let me try he's glad ah, don't worry do you want to be featured online? yes it's fine okay, let me just recap the question for question 2 for the benefit of the other students question 2 is more like a university database whereby it stores details about university students it causes the semester that the student took a particular course in, he's smart and great and what degree program each student is and so it so, over to you hi, so over here, we start with logical breakdown, the university program first, so in the university program we have a program ID, we have the program name we have the total credits that's required to graduate and also the year comments so the university program is like like your course, for example, you take business or computing, this is a program then, from there under each program, there will be a course so, for example, if you take computing you actually have all the SGL course or whatever, our course or computer science so this is considered a course so course, they also have a mini identifier which is course ID then we have the course name with the credit point value so for example, how much is the the year comments and also the semester that is being offered i mean, there's one more that is offered and we link it back to program ID also, because each course it belongs into one program so, for example, you take SGL, SGL is under the computing program so that's why we have a program ID so, under the okay, then you also have another table so this table stores all the information of all the students, like the student ID and the name of the student the surname of the student and also the date of birth of the student and also the year and road as well as the program that the students enrolled in so, for example, each student in business or programming in computing or something then lastly, there's another table which causes completed so this table stores all the information of the student completed what course at what year and the semester that the student took then you also have the grade and the marks of the table so, the new thing about this table is actually that there is if you notice, there is no key there's no primary key actually for this table because you realize that for example, each student they will take for example, student A he will take causes 1, 2, 3, 4, 5 the grade of each causes also there will be 50, 20 or whatever so, for this table there will be the student ID to be repeated and nothing here is so unique so, that's the interesting part and questions okay, connect this to program so, what happened is that if you notice, so in terms of connection okay, let's see this one, first thing the course will be connected to the program ID by the program ID column so, the course needs to be slotted under a program then subsequently the student also needs to be slotted under a program because all students have to have a program so, the students will be slotted under a program because all students will need to have a program you cannot just go into school and you don't know which program you are then in terms of the causes completed you will be linked to the student ID because each course that is completed has a grade so, this causes completed will be linked to student ID then lastly, in terms of the course completed we want to link it back to the course so sorry, that is correct you know, very good I will change it to it was my yeah, she can change it for the DAR it means it's an alpha numeric corrector yeah, it's any kind of one just out of curious since the data type for program ID just now and program ID is not that cheap which is a cheap that actually weighs the linkage of it you know when the linkage is being formed the first prerequisite is that the foreign key must be of the same type or is it? otherwise, the program should be quite it will venture at that right now I want to do it you just can accept that yes it doesn't make the same right? it doesn't make the same right it's not in the same so which column you talking about? yeah, of course my comments for both the course and the university programs it's a column it doesn't make the same right for a course and university it doesn't really matter because the thing is that the column they belong to different tables so in essence, they are different scope the only problem we're writing a quote that's one and so it's different 2 columns in the same table in general, we're not allowed to do that oh, you're not? no way to put it on the same table okay because you were saying because each course can be offered in different semesters so for example, this course can be offered in semester year 2016 then semester 1 then 2017 semester 2 this one is actually for students so this table is about all the students information so for example, each student for example, a student completed so this student with becker did this course at year when and which semester this is the becker person to do a course and what's the grade and what's the mark so this is not linked to this because this is an overview of I mean, this information takes from here sorry? the information takes from there it takes from here because we are storing all the information all the results of all the students then for example, it cannot be that when becker takes this SQL class in year 2016 semester 1 but then this class doesn't exist here so like this SQL class in 2016 semester 1 it needs to be found inside here so if there's an SQL class but it's only in 2017 semester 1 then there's something wrong so like this student is not taking this class must exist in here sorry? not as a very clear good point then I will okay, actually burburi there's no right or wrong in fact, I'm kind of glad that she actually did that way if you want to think about this it actually goes different to the database design and what we call normalization because the thing is that the aim of the database, of course if you want to really be anal about it and you want to normalize say no data gets redundancy you can do that but if you want to perform queries sometimes when the database gets too large it becomes a bit unwell and you want to introduce a bit of redundancies this is a form of redundancy which currently it may seem like a reputation information but let's say for instance we are talking about a super-large university a global university dual where you have millions of records and you don't want to join which I will talk with later it's pretty expensive so that's when this kind of design will make sense so it's not right or it's not wrong but it goes to the kind of detail that you're expecting this is good for me sorry? for smallish database she will be right in the sense that just based on the cost she will be able to see the semester the day information but if you're talking about huge database sometimes you will eject redundancy this is to make it very faster it doesn't seem like putting like this yeah, yeah, correct this is a form of redundancy so it's good if you go in both ways it's known as a normalization so there's a first normal second normal form, third normal form any other comments? questions? put it as a primary key no, you don't really need to because as long as your cost competition as a cost ID which refers to the cost down there you'll be able to refer to the correct entry and get the necessary information so you don't really need to define it as a key or what can I just clarify that primary key needs to be a unique an environment or game what do you mean by game? for example if in this case it's an identifier but it's not it's not unique it has but what do you wish plus okay actually this is a very interesting design actually as you mentioned at the cost there's actually no ID that identifies the cost okay so even though I mentioned about primary key but one information which I kind of let out is that a key will not necessarily be a single combination okay it can be a combination of columns so for this case the cost competition as long as you have a student cost ID combination these two piece of information can already uniquely identify which background you're talking about and you can actually have a primary key to comprise the two of them together alright you can ask I have a question in terms of how the actual data and key looks like because in most schools there are never courses that can go more similar to different programs and so how would one course how would that data put it to say that it's for both computer science and humanities and something else how would I say that that would be we say that I don't know because we're always asking one at the end I don't understand Well for the current scenario if you start with a question which is why the way that you've been signing is one program to many courses but you didn't mention an end-to-end relationship which actually student cost student cost is an end-to-end relationship and by the way that she was now end-to-end relationship you cannot just have two tables and you can actually capture the difference and that's what the cost is for computer science alright So if I were to answer that question you would have to have a second table Yes, correct So that's one of the requirements so it wasn't written that way one thing which that's one thing which I just want to bring up is that it's also interesting to see the program and the students also to course by a separate table it does not necessarily mean that the student must take a course that belongs to the program currently currently this design has a kicker for that and the reality it also does not represent why? because let's say for instance I'm publicised by a student biologi courses before and that's what it is Distance Alright So very good and then for the questions it's not just people being on the pause Okay now last can I have let me just download the thing first so i wish I had your Question 3 Is that For this question it was Airplanes Okay Fine, that's one of more airplanes Airplanes is a world number a unique registration number and capacity and and the flight has a unique flight number and departures from an airport horizon airport then the state of time each flight is carried out by an airplane I think it will bring those districts Anyway, so we decided to go with a a flight centric thingy so like we imagine like if we had a table which you could look at it would be like a flight flight ID and this flight has what airplane so it goes out to the airplane ID and this flight belongs to what airline so it goes to the airline and this flight has quad passenger so we got the passenger ID and then the flight actual details so if we go out to the airplane then we can have the airplane's ID, registration number so the capacity we were thinking about the capacity whether the capacity is determined by the flight or the airplane but we imagine that like if the airplane has a capacity of 200 and this airplane is flying this flight so then thus the flight would have the capacity of the airplane so the capacity of the flight is derived from the airplane and then there is a flight ID this airplane will have the flight ID which is this flight and the passenger so boring the passenger ID comes from from then you got his name, surname, email blah blah blah I don't know so I don't know I think it makes sense so it's from the flight I don't know it's yeah i think left place any questions? should the relationship between airplane and the flight be the other way around because single airplane can go on many flights and in case of flight it will have multiple flights single airplane can go on multiple flights not really one like at least at this time Satu airplane boleh hanya berjalan ke satu desainasi. Selepas pilihan itu... Jadi dia mengambil pilihan yang baru? Ya, tapi bukan... Jadi bukan hanya pilihan untuk semua pilihan awak? Dan... Dan kemudian, awak mempunyai pilihan yang banyak. Jadi kita katakan pilihan yang baru untuk pilihan di Australia dan Singapura untuk pilihan yang baru. Ya. Jadi tiga pilihan yang digunakan dalam pilihan pilihan yang baru. Dan anda mengalami pilihan yang sama? Ya, mereka akan menerima seperti pilihan ini. Jadi jika anda memilih, saya rasa... Saya akan memasak ini. Saya akan memasak pilihan yang baru. Saya rasa jika anda memilih pilihan ini, anda akan mempunyai pilihan yang 1. Pilihan yang 1 adalah mempunyai pilihan yang ini. Dan... Pilihan yang 2 dapat mempunyai pilihan yang sama. Dan kemudian, perstengahannya. Dalam pilihan yang ini, Kami akan mempunyai satu airplane yang mempunyai airplane. Sebaiknya, airplane akan diberikan di airplane. Mereka akan dipercaya jika anda mempunyai airplane. Mereka akan mempunyai airplane di airplane. Tak. Kenapa kamu akan mempunyai airplane? Sebentar. Saya rasa ini salah. Baiklah, saya baru hari ini. Saya memang fikir, saya sangat teruja untuk membuat ini. Tidak mengapa. Jangan risau. Semua perpengaruhannya untuk melakukannya dan membantu. Janganlah. Janganlah. Janganlah. Airplane boleh mempunyai beberapa jalan. Setiap jalan hanya mempunyai satu airplane. Jadi anda tidak mahu hubungan terlalu banyak. Untuk pilihan airplane, airplane ini betul kerana airplane ID dan airplane ID. Tetapi airplane ada satu airplane ID yang mempunyai lebih banyak jalan. Kenapa? Kerana satu airplane ID boleh mempunyai beberapa jalan airplane. Ya. Jadi jika anda mempunyai satu jalan, bagaimana anda akan memikirkan jalan? Saya tidak tahu. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Janganlah. Adakah anda juga mempunyai perjalanan? Adakah anda berdua mempunyai perjalanan dan anda boleh melihat peluang di dalam perjalanan? Jadi anda tidak meminta perjalanan di dalam perjalanan? Selain perjalanan dan perjalanan, apa jenis perhatian yang anda boleh memperkenalkan? Saya tidak percaya dia dapat membuat perjalanan seperti itu. Kadang-kadang, jika kita membutuhkannya, kita akan membutuhkannya. Apabila kamu membutuhkan dua perjalanan, saya beritahu yang sama. Jadi, kita perlu berkata bahawa pembentangan yang berlainan. Atau apa yang berlainan? Atau bahawa pembentangan yang berlainan. Mereka berkata bahawa pembentangan yang berlainan. Memang membutuhkan bahawa pembentangan boleh membuat berdiri. Bermakna pembentangan dapat membuat peluk. Pembentangan yang sama? Kerana tepung pembentangan... Alah saya juga harus membuat keduanya namanya Puking. Pemandangan yang berlainan. Dan kemudian kemudian masuk keduanya. Selepas itu, kita perlu membuat pemandangan yang berlainan. Jadi kita perlu membuat pemandangan yang berlainan. Pertanyaan yang kedua yang saya ada untuk anda, adalah bahawa jika anda ada perjalanan, anda akan melihat perjalanan dengan alaik. Ia bukan keadaan yang keadaan, saya tidak kira ia akan berjaya, tetapi saya hanya... Ia nampak keadaan dari kota. Bagaimana anda lihat? Perjalanan ini adalah alaik saya. Tapi iya, tapi itu tidak, saya tidak kira ia akan keadaan yang keadaan. Kerana perjalanan pertama mungkin akan mengasukkan perjalanan yang saya melihat. Bagaimana anda lihat? Bagaimana anda melihat? Bagaimana anda melihat? Bagaimana anda melihat? Di perjalanan tersebut, saya akan beri alaik keadaan pada alaik yang tersebut. Bagaimana anda melihat? Ia hanya adalah penjelaskan. Bagaimana anda memasang alaik keadaan pada alaik yang anda melihat? Ia tidak kira, saya masih tidak faham. Jadi jika saya ingin berkata 1-1, saya akan melihat beberapa alaik yang anda boleh melihat. Kami mempunyai 2-7 aerobat. Jadi, ada yang berbunyi. Ada banyak aerobat, bukan? Mereka mempunyai 7 aerobat, ya. Oh, itu adalah persoalanan? Kenapa ada aerobat dan ada aerobat? Ya, kerana aerobat lebih baik. Jadi, perubahan berlainan adalah perubahan yang berlainan. Oh, ya. Yang ini berlainan yang berlainan. Ya. Oh, ya. Okey. Ada apa-apa masalah untuk mempunyai dan mempunyai aerobat? Tentu saja, tidak. Maaf. Dia sepatutnya mempunyai aerobat, minta jika ada masalah untuk beritahu Kami. Terima kasih. Airobat berlainan. Baiklah. Tapi, tak perlu risau. Ya. Ada apa-apa masalah? Tidak. Saya mahu beritahu... Maaf? Bagaimana jika kita mempunyai hubungan berlainan tanpa berlainan sebenarnya? Ya. Sebenarnya, jika kita mempunyai... Jangan... Jangan... Saya tidak guna Windows. Okey, ada masalah? Tidak. Baiklah. Terima kasih. Jadi, semoga semua anda dapat melihat bahawa hubungan berlainan ini ada... Bukan semua masa untuk menerimanya, ia berlainan di mana anda mahu menggunakan hubungan ini. Dan sebagainya, saya mahu beritahu 3 perempuan yang akan datang dan mempunyai hubungan berlainan dan sebagainya untuk menggunakan hubungan ini. Jadi, mari kita bergerak kepada sebuah sesi. Jika saya tahu bagaimana saya menggunakan hubungan ini, saya akan menggunakan hubungan ini. Jangan... Jangan... Jika anda menerima, ini bukan hubungan saya. Jadi, hubungan ini akan berlainan. Jangan... Ini berlainan, betul. Bagus. Bagaimana saya membuatkan hubungan saya? Maaf, saya... Saya tidak bersedia. Okey. Saya akan mempunyai masa yang susah. Baiklah. Mari kita bergerak kepada sesi yang terakhir dari 3 perempuan ini. Saya akan cuba beri sedikit lebih banyak tangan dan cuba beberapa contoh untuk menggunakan hubungan ini. Okey, pagi ini, kita bercakap tentang hubungan ini. Kita bercakap tentang sebuah konsep menggunakan hubungan ini untuk menggunakan hubungan ini untuk menggunakan hubungan ini. Jadi, sebelum sesi yang terakhir, kita akan memperkenalkan semua hubungan ini, yang kita gunakan untuk memperkenalkan hubungan ini. Okey. Ia tidak seperti seksi, you know, ia memperkenalkan kepadamannya yang menggunakan format untuk menggunakan hubungan ini. Jadi, bagi yang terakhir, dalam hubungan itu, kita boleh menggunakan hubungan itu, atau Sql, yang saya bercakap tentang, atau dikira pada akhirnya. Sebelum itu, semua orang-orang hanya menggunakkan hubungan ini Sekarang, bagaimana anda memasukannya? Sangat mudah. Okey, di bawah sini anda hanya perlu... Maaf. Ada buku ini yang dipakai untuk memulangkan skrips yang saya suka. Memulangkan skrips. Dan sebenarnya, ia adalah Akhila SQL di Google Drive. Jadi, jelaskan saja. Anda akan mencari segalanya. Jangan risaukan apa-apa. Dan saya akan mencari sebuah pakaian yang saya suka. Anda ada? Boleh semua orang memiliki masalah mengeluarkan database? Boleh saya mencari ini? Okey, maaf. Saya hanya untuk mencari kelebihan yang telah memasukkan... ...berapa kelebihan yang saya mahu mencari. Saya hanya memasukkan kelebihan yang sebenar. Kita memasukkan skrips ini bersama. Sekarang, bagaimana saya memasukkan kelebihan yang saya mahu memasukkan? Apa yang saya mahu memasukkan? Saya akan memasukkan kelebihan yang saya mahu memasukkan? Bagus. Dan saya hanya mencari kelebihan ini. Loh, saya memandu. Baik. Itu adalah kelebihan yang saya mahu memasukkan. Saya hanya memasukkan kelebihan yang saya mahu memasukkan. Bagaimana saya memasukkan kelebihan untuk memasukkan kelebihan sebenar... ...lebih episodes ke dalam database? Bagaimana jika semua orang memperkenalkan keadaan keadaan dan keadaan dengan keadaan keadaan? Okey, apa yang kita bincangkan? Pertama, saya rasa bahawa keadaan keadaan keadaan tersebut perlu diperkenalkan Jika tidak, mungkin kita perlu berusaha untuk menghidupkan keadaan keadaan keadaan keadaan Tetapi, saya ingatkan, mungkin, kita perlu mengusahkan keadaan keadaan sebagai keadaan keadaan yang tersebut Jika saya tidak salah, saya rasa bahawa keadaan keadaan tersebut perlu diperkenalkan dan keadaan tersebut Saya tidak bersenang dengan berusaha dan tidak menghargainya, tetapi jika anda mencuba melihat bagaimana keadaan tersebut Tetapi, sehingga keadaan tersebut sebenarnya tidak boleh berhasil, anda pasti akan mempunyai keadaan keadaan yang tersebut Dan ia akan membuat keadaan yang tersebut Jadi anda membuat keadaan keadaan yang tersebut? Ya, betul. Membuat keadaan tersebut? Ya Jadi, sebelum anda buka... Inilah, anda boleh beritahu kepadanya dengan sebuah kata-kata Pada keadaan keadaan yang tersebut, bagaimana sebenarnya akan berlumat dan memperkenalkan keadaan tersebut Semua keadaan berhasil, sebuah keadaan tersebut Kamu semua, mencuba pada boten perniagaan Baiklah, bagus. Jika anda dapat melihat di sini dengan keadaan Ya, jika anda berada di sini Terima kasih, Rizwan. Kami akan pergi ke pakaian ini. Kami akan pergi ke pakaian ini. Dan... Ia harus membuka kondisi ini. Okey? Dan... Satu perkara yang saya mahu kamu semua fikir adalah... Ya, ini adalah pelajaran yang lebih besar. Okey, bagus. Ya, kamu lihat ini di skimas. Untuk memasukkan skimas di bawah sana. Okey? Dan untuk beberapa kamu, kamu mahu memasukkan. Ini adalah perkara yang lebih besar di sini. Kamu patut dapat melihat perkara ini di bawah sini. Baiklah? Dan di bawah sini, kamu lihat pakaian. Kamu ada pakaian, pakaian, pakaian. Jadi, pakaian, pakaian. Pakaian, pakaian, pakaian, pakaian. Pakaian, pakaian, pakaian, pakaian, etc. Dan kamu boleh fikir tentangnya. Setiap pakaian separat ini... ...tidak menghargainya pada tab... ...pada pakaian yang sebenarnya ini pagi. Baiklah? Kamu telah memasukkan perkara ini... ...sehingga kamu dapat melihat perbezaan. Satu perkara yang boleh kamu lihat. Kamu memasukkan pakaian? Pakaian, pakaian, pakaian. Okey? Baiklah. Untuk memasukkan... Untuk memasukkan... ...pakaian, pakaian, pakaian, pakaian... ...pakaian, pakaian, pakaian... ...pakaian. Ya. Okey, jika pakaian yang memasukkan... ...pakaian, ia berarti... ...pakaian yang tersebar tidak terkongsi... ...untuk perbezaan TELAW. Maksudnya, kamu akan melihat... ...pakaian yang berasal di sana. Jadi, apa yang kamu boleh lakukan... ...dia boleh kembali ke dalam satu... ...pakaian yang pertama... ...dan kamu akan cuba itu... ...untuk keadaan kamu yang baru. Kamu melihat pakaian yang tersebar... ...dan kamu akan memasukkan... ...pakaian yang baru... ...atau yang baru. Okey? Dan apabila kamu memasukkan... ...pakaian yang seronok, kamu akan membuang isopografi... ...pakaian semasa kamu memasukkan... ...pakaian yang tersebar. J�도, pakaian yang seronok, flavored... ...pakaian yang berkembang ke k Sebenarnya, saya rasa ia sudah bergerak. Sebenarnya, ia sudah bergerak. Sebenarnya, ia sudah bergerak. Ya, ia sudah bergerak. Okey, apa yang saya beritahu tadi adalah program ini di sini. Adakah serva anda harus bergerak? Dan ia harus bergerak. PID bermaksud proses ID. Tidaknya, ia hanya bermaksud serva yang harus bergerak. Jika tidak, serva tidak bergerak. Apa yang tidak berlaku adalah bahawa Sebenarnya, ia hanya bergerak. Dan ia tidak dapat dibuat dengan apa-apa saja. Okey. Jadi, anda dapat memasukkan koneksi internet anda. Dan anda dapat memasukkan koneksi dunia seperti browser. Jika anda memasukkan koneksi internet di browser anda, anda hanya akan menghidupkan apa-apa yang berlaku. Okey, ia adalah perkara yang sama. Okey, jadi Sebelum beritahu bahawa saya hanya ingin menunjukkan beberapa perkara untuk anda. Okey. Jadi... Ya, anda dapat melihat bahawa Anda dapat memasukkan koneksi dan koneksi. Jika anda memasukkan koneksi, anda hanya mencari koneksi. Dan pilihan pertama adalah memasukkan koneksi. Okey. Dan secara esok, ia memasukkan koneksi untuk database. Dan anda hanya memasukkan koneksi. Okey, jadi ini, anda dapat melihat bahawa ia seperti koneksi yang anda memasukkan. Sudah. Okey. Dan perkara kedua yang anda perlu mengambil adalah apabila anda memasukkan koneksi. Okey, apa yang saya melakukan dengan SQL Batch adalah bagaimana anda memasukkan koneksi anda. Sekarang saya akan menunjukkan bagaimana anda memasukkan koneksi ke dalam syarikat koneksi. Jadi anda dapat melihat di sini, memasukkan semua dari Sakela, Kustomer, BOOM dan segala-galanya. Baiklah. Jadi itu sebenarnya bagaimana anda memasukkan database ini. Dan untuk kemudian, anda akan memasukkan syarikat dan beberapa koneksi yang lebih biasa dan memasukkan kepada anda memasukkan koneksi yang sebenar pada komputer ini juga. Jadi, sebelum saya memasukkan siapa yang belum dikoneksi database ini. Koneksi S. Okey, bagus. Untuk informasi anda, menurut koneksi yang dikatakan, saya percaya satu pertanyaan yang saya akan mendapat adalah bagaimana anda memasukkan atau bagaimana anda memasukkan informasi untuk memasukkan. Sekurang-kurangnya, bagaimanapun koneksi yang dikatakan dengan koneksi yang dikatakan dan memasukkan kemudian untuk database ini. Dan ia biasanya tidak dikatakan dengan tangan saya. Saya akan kata, saya juga tidak dapat melihat jika ada pertanyaan anda. Ada koneksi yang dikatakan tetapi saya tidak mencuba sehingga saya tidak tahu bagaimana anda boleh mencuba setiap kali. Saya boleh kata. Okey, boleh saya bergerak? Maaf. Untuk import. Okey, di bawah koneksi, dan anda dapat melihat koneksi yang dikatakan untuk import. Saya percaya anda harus memasukkan sesuatu yang dikatakan untuk memasukkan informasi anda. Tetapi sekarang, jika anda ingin memasukkan jika anda tidak memastikan anda boleh mencuba setiap kali. Tetapi saya akan memasukkan tanyakan sebenar dan bagaimana anda memakai tanyakan dan tanyakan tanyakan pasukan yang digunakan. Nanti, saya mengatakan bahawa semua tanyakan anda sudah digunakan. Bagaimana anda akan memasukkan tanyakan dan bagaimana anda akan memasukkan tanyakan dan bagaimana anda akan memasukkan tanyakan pasukan yang digunakan? Jadi, apa yang benar-benar sebuah koneksi yang digunakan? Sama sesuatu yang tidak menarik dan tanyakan tanyakan yang digunakan? Ya, sebuah koneksi yang digunakan untuk NBMS. Apa yang berlaku adalah untuk orang-orang yang memakai tanyakan pasukan yang digunakan seperti tanyakan pasukan yang digunakan dan tanyakan pasukan yang digunakan atau seperti yang mengambil tanyakan dengan tanyakan pasukan yang digunakan untuk memasukkan tanyakan pasukan yang digunakan. Jadi, anda tidak perlu risau di mana anda akan mendukung tanyakan. Jadi, apa yang menggunakan koneksi yang tersebut adalahlah bahawa koneksi yang digunakan untuk membuat tanyakan pasukan yang digunakan. Boleh digunakan tanyakan pasukan yang digunakan dan membuat Ia tidak terlalu penting. Ia juga digunakan sebagai DML atau TESA Kami terpaksa memperkenalkan keadaan kita. Ia tidak sangat penting. Ia tidak sangat penting. Ia perlu mengetahui bahagian ini. Okey. Kita akan bercakap banyak tentang TEDOS. Sekarang saya akan mengambil satu pasangan ke belakang dan bercakap sesuatu yang terlalu banyak. Jika kita boleh menyebabkan salah satu contoh tentang musik berkos yang sebenarnya adalah kekontohan dan album. Jadi, sebabnya, di bawah TEDOS, kita ada tabung dan di atas belakang dan skimas. Jadi, kita boleh mengambil skima sebagai kekontohan kekontohan. Ia hanya untuk membantu anda mengubahkan keadaan. Dan tentu saja, maaf. Sebenarnya, mempunyai skima ini juga menolakkan SQL Server untuk membuat beberapa kekontohan kekontohan. Seperti jika anda hanya menggunakan sebuah musik, anda boleh mengambil kekontohan dan tidak akan menggunakan kekontohan lain. Sebenarnya, itu terdapat sebuah sesuatu. Jadi, saya akan bercakap tentang itu. Apa yang saya akan bercakap adalah hanya idea bahawa skima adalah tabung dan kekontohan kekontohan. Jadi, untuk membuat kekontohan kekontohan, mari kita bercakap dulu. Mari kita bergabung sedikit. Adakah anda mempunyai kekontohan kekontohan yang digunakan? Ada sesiapa? Yang ini. Okey, mari saya berbuka kekontohan kekontohan. Mari kita berkata saya mahu memilih salah satu ini. Tak penting bila saya salah. Kembali ke ini. Okey. Kenapa saya mahu menggunakan kekontohan kekontohan ini? Saya rasa jika anda melihat kekontohan, dalam 5 minit, saya akan menyebabkan. Tetapi, tidak hanya kekontohan kekontohan yang digunakan, kerana ia sebenarnya mempunyai kekontohan kekontohan yang digunakan untuk menggantikan kekontohan kekontohan ini kekontohan kekontohan kekontohan SQL. Jadi, bagaimana anda membuat begitu? Sangat mudah. Anda hanya perlu pergi ke kawasan, menjelaskan dan kekontohan kekontohan kekontohan kekontohan SQL, untuk mencuba apa-apa lagi. Anda hanya perlu mencuba kekontohan yang digunakan. Jadi, apa yang akan berlaku? Baiklah, jelaskan kekontohan kekontohan dan mencuba kekontohan kekontohan yang digunakan. Oh, betul. Baiklah. Jadi, kekontohan kekontohan SQL yang dibuat dari diagram itu. Anda tidak perlu tahu apa-apa yang saya cakap. Tetapi, dua perkara yang penting yang anda boleh bawa kekontohan ini, ia sebenarnya mempunyai kata-kata untuk membuat kekontohan ini. Okey? Dan kekontohan ini yang anda bawa kekontohan saya. Saya rasa ia adalah perkara yang penting. Tapi jika anda membuat kekontohan yang berbeda dengan kekontohan yang berbeda, jadi itu adalah kekontohan yang membuat kekontohan. Jika tidak ada kekontohan untuk membuat kekontohan, anda tidak akan membuat kekontohan yang berbeza untuk membuat kekontohan yang berbeza. Okey? Jadi, dengan kekontohan, anda akan membuat kekontohan yang membuat kekontohan. Biar saya tunjukkan. Okey. Jadi, kekontohan ini yang anda boleh membuat kekontohan. Biar saya katakan bahawa saya mahu membuat kekontohan yang berbeza. Saya hanya menghantar sesuatu seperti ini. Dan saya akan memperkenalkan kekontohan yang berbeda dengan dua perkara yang penting. Satu perkara yang penting, dan yang lain adalah perkara yang penting. Satu perkara seperti karat di sini. Ini tidak hanya bermakna ia membuat kekontohan untuk saya. Biasanya saya memakannya. Kerana setiap hari saya membuat kekontohan, saya akan membuat kekontohan yang berbeza. Saya akan membuat kekontohan yang berbeza. Jadi, saya akan membuat kekontohan. Jadi, sebaiknya, anda membuat kekontohan, dan kekontohan yang berbeza. Dan anda akan melihat, bahawa anda tidak memakannya. Tapi, sekarang yang lebih penting, setiap perkara yang penting jika anda mahu membuat kekontohan, anda perlu memasuki kekontohan. Dan itu adalah perkara yang terbaik. Kami membuat kekontohan yang berbaik. Maksud saya, tidak ada dunia. Di sini, ia bukan saja sebuah awal. Jadi, hanya menggemastikan koodal untuk muda kesihatan baru. Jadi, baiklah. Ini seperti browser dengan tanda-tanda yang berbeda. Dia sedikit seperti itu. Jadi, untuk saya sebenarnya, Jangan berjumpa di sekitar skimah. Saya akan menggunakan pakaian untuk menggunakan pakaian untuk skimah. Dan apabila anda menggunakan pakaian untuk skimah, kemudian anda boleh melakukan pakaian. Saya sebenarnya menggunakan pakaian untuk sedikit. Jadi, jika anda tidak faham, tolong jangan berlaku. Kerana saya akan meletakannya nanti. Saya tidak akan memperkenalkannya. Saya akan menggunakan pakaian seperti itu. Ya Tuhan. Okey, saya akan menggunakan pakaian lagi. Saya akan meletakkan kerana di sini. Saya akan menggunakan pakaian ini. Anda akan melihat bahawa perkara yang akan berlaku di skimah ini adalah pakaian. Kenapa kerana saya tidak fisikkan pakaian? Dia berkata, pakaian pakaian adalah seperti ini. Kenapa kerana saya sebenarnya tidak memperkenalkan pakaian? Pakaian sebenarnya tidak memperkenalkannya Pakaian yang tidak memperkenalkan pakaian... ...tapi pakaian tidak sebut. Ia tidak memperkenalkan pakaian yang ditunjukkan. Jika saya mengandung pakaian yang saya berlaku di skimah saya, yang sama juga saya klik pada dembina yang dikain dengan pakaian di sini. Anda akan melihat bahawa pakaian yang itu berlaku dan jika saya mengeluarkan pakaian sama, ia akan tersikap���i keputusan. Jadi, ada sesuatu yang saya merupakan atau mengikut pakaian yang saya mula menglikakan pakaian. Jika anda menguruskan perkara yang sama, anda tidak perlu bekerja dengan keadaan, ia mungkin mempunyai perkara yang tidak baik. Tetapi itu hanya peluang tanggungjawab. Atau saja, bergerak ke depan. Jadi, kembali kembali Skima adalah sama seperti kembali kembali kembali kembali. Sebenarnya, ia hanya mempunyai kembali untuk anda. Oh, maksud anda? Bagus soalan. Untuk kembali kembali kembali dan kembali kembali kembali kembali kembali kembali kembali kembali kembali kembali kembali. Skima dan dikenalkan anda ingin tahu siapa yang dia buat? Just go to the farm and say boom I don't know farm Ya But hey, I'm here to teach you the concept of the shop So, too bad Anyways Moving on Okay, so We've talked about schema, let's go to the tables So Okay, if possible If possible Try to keep a screen on this thing on Because we don't want the queries that will make the backlist It won't be easy if you have the tables right in front of you to refer to So, let's say for instance if we had a four in four tables Customers sleep on the supplier And by the way This is the textual representation of the Entertainment But it's the same as the comic book So, it doesn't really matter Okay The first syntax that you need to know Of how to create statements Back in the days And we don't have a steel workbench We should type all these things Manuari of cells So, the syntax is I don't know whether you all can see If you all can see on here Please refer to those The syntax is create table Right? And name of the table After that, you need to specify all the columns that you want The thing that you need to know of is that For each of these columns There's gonna be a data type That you need to specify This is the one that I mentioned He actually types So, what I did Dijern, if I need to just Dijern, if they not a lot So, and then Of course, there are keywords For things like for instance, you need Keywords and foreign key Now, this is the one That actually Tells my SQL to draw an edge From one table to another table Okay Like for instance There's a foreign key called This is a foreign key You can record as The one that we mentioned this morning It references Another table Called customer Which is And this is the few The foreign key That actually relates to Okay So, this is the Can anybody tell me What is the continuity Between customer and order? Yeah, continuity Or, when you are sure There's a relationship Can anybody tell me What is the continuity Is it one to many? One to one? Many to many? Many to one? Okay, correct So, one customer, several orders Okay So, as you can see These are all things You actually are not seeing it Why do you ask The world branch is actually To Some sort of graphical thing For all this kind of syntax But If you're not too sure What's actually going on Okay, it'll be good Of course, if you know What is the text line Yeah Okay, the rest Like, update customer Please Don't be too concerned About that They are just additional Information or additional constraints Which I think it's not the time If you do not believe me No, but if you're interested You can talk me in the mail Or you can Google it yourself But I'm not confused Because So, let's just leave Other comments like customer house So, this is The actual syntax For a process of creating a tail Okay And just now When I ask you For an engineer Okay Y'all can realise that The statement that's created For each and every entity Bosses Is exactly the same Kind of syntax as this Right So, next time If you're was asked To come up With a database You don't have to rely on Just Just go Click Or actually tap Go Ya So What Y'all don't believe me Okay Okay So That's for creating tables I'm not going to share An example Because I think I really showed you syntax Next will be Once you've created the tables You will need To do things like Insertion of records You will need to do things like Updating Repair scene So For inserting The syntax Will be something like this It's called Inserts Statements Okay So the syntax Is very reasonable Inserts into Table Values And then You open and close the bracket And all the All the energies inside Each one of them Will correspond To the column In that particular table Okay So Let me Demonstrate A little bit I am not by the type I'm going to show you What it looks like Again That's what I can do This interface Okay As you can see Even though I type it like I would an Excel spreadsheet But when I click on apply Just now You will just Translate that action Into the SQL statement I'm going to copy it So you can see it clearer Okay So If I will type Something down here And I click on apply That statement That you see Is indeed an actual statement For Or Inserting A statement Into Into Into the SQL table Okay So insert it Into The table name One thing Which is I'm not sure Is that Instead of Specify To insert Only a few columns Because Not all columns Into the values You can specify The column names Okay But of course A lot of values Must be Okay And Let me just revert So that you don't see And Let me just run this Line Okay So when you run that You'll see that The log statement Obviously is One row after a meter One row has indeed Inserted And If you want to see What actually happens Same thing The resolution is small Can you all see The last section Okay What question It's How come I did not Specify after I did I did not specify How come You know It increases So if you can recall One of the front views Like Unfortunately right now I can't just put it back There's an auto increment Option For those that can refer To the actual views Like I've talked about Primerically Now So this column Down here Okay It's actually defined To be auto increment So Need to say that And Without Specifying the ID It will just be One plus Previous external number Okay And same thing Usually for last opportunity Time You will have a key word To say that You will just Put in the time That you are setting So you can specify that But Aside from that This Is the command Or Or For I So Okay I I I Sometimes I kemudian untuk modifikasi, bagaimanapun tidak dapat. Untuk mempunyai atau mempunyai rekod ini adalah update. Yang sama... Maaf, maafkan saya. Ini adalah update. Mereka mempunyai pakaian untuk apa-apa pun yang digunakan. Tetapi satu perkara yang perlu anda tahu, anda perlu mengenai rekod yang digunakan dalam update yang lain. Kerana jika anda tidak mengenai rekod yang digunakan, anda akan mahu memodifikasi. Oleh itu, di mana pakaian yang digunakan, ia adalah untuk memutuskan untuk beritahu. Saya mahu memodifikasi. Saya mahu membuat pelanggan, pelanggan yang digunakan, dan mengubahkan pakaian untuk apa-apa pun yang digunakan. Dan perkara yang sama, anda juga boleh membuat perkara yang sama di kabel. Saya akan memotifkan wajah yang baik. Ok, anda counts yang baik untuk saya. Bila-bila, jika anda ingin memilih perkara yang terbaik, anda akan memilih wajah yang baik untuk saya. Atau saya tidak memilih ini sebab anda ingin memilih perkara yang digunakan, anda akan mendapatkan perkara yang yang digunakan. Anda dapat melihat perkara yang sama. Updates, kabel set yang dulu, kamu menggunakan兩個 perkara yang digunakan. Dan apabila puan ini dimulai... Maaf, maafkan saya. Tidak buat yang ini dimulai, Ya, jadi keadaan adalah pilihan untuk memilih pilihan yang anda inginkan untuk dikatakan, yang adalah pilihan pilihan kedua ini. Okey, terima kasih. Apapun yang saya lihat di sini, saya tidak berkomunikasi ke dalam pilihan. Ya, apapun yang saya lihat di sini, tidak dikatakan ke dalam pilihan, hanya pilihan di dalam pilihan yang perlu dikatakan ke dalam pilihan untuk dikatakan. Jadi kita akan memilih pilihan ini. Dan ini adalah pilihan yang anda menggunakan. Jadi apabila anda memilih pilihan yang beruntung, Ya, betul. Kamu semua boleh cuba jemput yang sama seperti yang saya lakukannya, supaya anda dapat mempunyai lebih banyak perkara tentang perkara ini. Satu perkara yang saya ingin beritahu adalah, walaupun anda tidak melihat, kat sini, Saquila atau Maxon, kerana sekarang saya sudah melalui Saquila, saya sudah melalui Saquila, saya sebenarnya tidak perlu menjelaskan ini. Saya hanya mengusahkannya. Ya. Saya juga masih ingin mengikuti pada senang kita. Tapi perkembangan, saya hanya ingin mengikuti siapa saja. Saya ingin mengikuti siapa saja, dan juga mengikuti dia. Okay, oh, boleh saya katakan? Restoran itu, saya juga mencuba. Okay! Pilih. Bagus. Saya dapat melihat banyak pelajar yang mencuba. Mencuba dalam perjalanan. Dan mencuba dalam perjalanan. Boleh saya beri satu? Saya akan mencuba. Saya akan mencuba. Sudah tentu, saya akan mencuba. Ya, saya akan mencuba. Saya akan mencuba. Bila anda membuat perubahan? Pada masa yang tidak memperbaiki. Pada masa yang tidak memperbaiki. Pada masa yang tidak memperbaiki. Pada masa yang tidak memperbaiki. Pada masa yang mencuba, ini adalah... ini adalah lebih seperti kebanyakan. Okey? Kerana bahkan saya menggunakan setiap hari, tetapi anda akan mencuba dan mencuba. Dan saya akan mencuba. Jadi, saya akan mencuba. Saya akan mencuba dan mencuba. Dan saya akan mencuba. Saya akan mencuba. Bagus. Saya melihat beberapa pelajar yang memperbaiki. Ada juga perubahan antara ini. Bila anda dapat mencuba, saya tidak tahu apa yang anda panggil. Ini adalah... Yang penting untuk mencuba, hanya di sebelah satu atau dua. Okey, ini bermaksud... Yang penting untuk digunakan... apabila... Pada masa yang tidak memperbaiki, anda akan mempunyai pelajar yang mempunyai pelajar. Pada masa yang tidak memperbaiki, saya bercakap tentang pelajar yang memperbaiki. Tolong jangan mencuba. Dan salah satu perkara yang saya katakan, itu tidak mempunyai pelajar. Walaupun ia mempunyai pelajar. Jadi, apabila anda mempunyai pelajar, anda akan mempunyai pelajar. Baiklah. Apabila anda mempunyai pelajar yang mempunyai... Pada masa yang tidak memperbaiki... Atau apabila anda tidak mempunyai pelajar... yang memperbaiki pelajar, anda tidak akan mempunyai pelajar. Dan sebabnya, mungkin-perisekannya, anda akan membuat merata-tata. Tapi, sebuah pelajar yang memperbaiki... Itu adalah pelajar... termasuk pelajar. Anda tidak akan mempertahankan. Anda hanya bisa berjalan seperti... Jika seperti ini, ia akan bekerja dengan baik. Jika tidak, kamu tidak perlu memikirkan kedua-dua perkara sekarang. Sekarang ini juga berbeza daripada perkara yang anda lihat di sini. Ini hanya berlainan untuk dikatakan bahawa ini adalah kawasan kawasan kawasan kawasan kawasan. Jadi, kawasan kawasan kawasan kawasan kawasan kawasan kawasan kawasan kawasan kawasan kawasan kawasan kawasan kawasan kawasan kawasan. Kami jadi juga membeli kawasan kawasan kawasan kawasan kawasan dalam bahan komputer atau kawasan jejak. Jadi, tidak ada hal yang berbeza-beza daripada pojawasial hemos mah себе atau kawasan berdua harus plead sebagai hal yang sebut. Ini adalah sebabnya tidak mengucapkan bahawa ia adalah sebuah kaki. Ia melihat sama tetapi ia sebenarnya berbeza. Dan ia hanya membutuhkan apabila anda mempunyai nama kolon dengan spes di dalam. Tapi jika anda mempunyai nama kolon tanpa spes, ia sebenarnya mempunyai pilihan. Tetapi kenapa ia muncul di sini? Sangat mudah kerana saya menggunakan SQW-Batch untuk menggabungkan peringkatan untuk saya. Jadi apabila anda menggabungkan sesuatu, ia mahu dikembangkan. Jadi semuanya anda akan membutuhkan pilihan itu. Baiklah. Baiklah. Baiklah. Sehingga jauh-jauh-jauh ada pertanyaan dan peringkatan. Maaf? Atau bagaimana anda akan kembali? Ya. Pada saat anda menghubungi peringkatan, ia berada di bawah sana. Sehingga anda tidak perlu menghubungi peringkatan atau menghubungi peringkatan. Ya, tetapi anda menghubungi peringkatan yang sangat penting. Saya tidak baik menghubungi peringkatan. Tetapi jika anda tahu bahawa untuk SQW, ia adalah peringkatan tersebut. Jadi apabila anda menghubungi peringkatan, ia akan mengubungi peringkatan. Dan itu akan mengubungi peringkatan untuk anda. Baiklah. Jadi apa yang berlaku adalah lebih kerempuan. Dan jika anda menghubungi peringkatan tersebut dan tidak mengubungi peringkatan tersebut, peringkatan tidak sebenarnya terkini kepada peringkatan sebenarnya. Sementara anda mengubungi peringkatan, ia akan mengubungi peringkatan. Dan ia akan mengubungi peringkatan. Selepas itu, ia akan membuat peringkatan. Tetapi, ini sehingga ini yang saya rasa tersebut, ia mengubungi peringkatan. So, any combat that we issue in autopans, it gets updated to the database is something. Unfortunately, there is no controls in one. So, yeah, that would be nice. Next, rubi. Okay, now, before I carry on, any more questions pertaining to rubi next? Sorry? You mentioned that there are two different online transactions online. Yeah, at least, is there a greater transaction mode or more transaction mode? No, actually, I don't really recommend that mode. Whenever you're actually using an SQL database to production, what you're seeing is that you actually have tons of other users accessing the same database at the same time. And most of the time, it's more than transactional because we want every change that we make to the database to be disavowable to our users as well. Because otherwise, if you make changes by another comment and another user makes the same change to the same record in total comment, and other than something to comment and then something to communicate, your changes will override these changes and you'll be like, ah, okay. So, I guess my question is, when sometimes you're analyzing things when you're initiative in back-case, don't you have any type of data? That should be fine, because that is quite accurate. It's not really inserting. So you're never really... It depends on what you're doing sometimes. Most of the time, we'll talk about the database system. In fact, taking from personal experience, I use database specifically on a billing system and I never have to issue any insertion. I never have to issue any of the coins. Why? Because usually most of the time, these kinds of coins are really bad at the cost and nothing of the database. But what I would use it are more analytical than the process. So this is a select cost account. And select cost is essentially just clearing the database without making any changes of it. That's assumptions. And once you're playing, it's filled with data, it's filled with data to be cleaned and it's going to be formatted. When you say cleaned, and you refer to the battle system or the format. It's like the format or the value. Well, that will pretty much impact on the person who will speak specifically to their time. Yeah. So it is correct to a certain extent due to the constraints like for instance the quality that we specify just now. But that's pretty much the only kind of validation that SKL can do for you. Like for instance, if you specify this column as long now during the creation time, you can be assured that the column will never have an insertion. Why? Because if anybody tries to insert a record, it doesn't have a value in that particular column, it's still just true. You will have to clean it when you put it inside. SKL by itself, that's not enough for you. But what it does is that once you cannot put it inside, you can maintain the kind of constraint that you specify so that it doesn't become just the hope that it's emotional. And it's not, I wish it is, fortunately it's not a magical tool to do kind of validation. Because some of these things are literally what we call verification errors. Like for instance, my panelist might be very strong. No one else can say that it's what I said because I know it. Right? So no one else can say that it's not a magical tool even if we expect the SKL server to be magical. And so I assume that you'll lack a lot of energy. Okay. Moving on. The next one will be the key thing because most of the time the issue commands to the database will most likely be selected. Now, I don't know how many of you 1. Anybody else 2? Anybody else 3? Or you'll seem to be raising 1x1? Okay, never mind. So basically the generous impact looks a little bit like that. Select something from a table where a bunch of conditions something for you. So what it actually means is that the select will allow you to specify accounts that you want. That for instance is like made if you want to see the name. First name, last name, whatever. From will specify the table. It can more than what tables but will come with that answer. Where is you actually use conditions to filter the record that you want to see. For instance, you want to see let's say everybody who's under nature 70 you can specify that as a constraint in the where clause. Group By is more for like grouping records together and all this also. You won't be able to see much of it here but I'll try to run through the examples and at the same time I also want to try that out for encyclical database that you have decided. So first thing select I've done a lot of select things before. And but just one thing that you want to do is that at least it's like a raw card. So basically it's just a shortcut way to say I want to see all followers. So even just now the first few show you should have seen that quite clearly hopefully. Let's see. Select all from Hector. Okay. So it shows everything. No filtering, nothing whatsoever. Now if I want to see the first name same thing I just type in the column name and boom only the first name comes out. Okay. So be fancy and try to build more. I'm going to jump at your perspective a little bit. So let's say you want to find out which I entered and the first name called Jennifer. Okay. So that's where the where cross come in. See it comes out to me the record down here. But the where cross where column equals to value that is the most basic syntax that you need to know but of course there's actually a ton of other options that we can actually use. For instance I'm really jumping even. Okay. Right. Ya, I'll go back to those slides later I just want to talk a little bit about where cross where you can actually combine different columns. Okay. Like you can actually have more than one columns or more than one conditions that each one of them is joined together by an end operator. So we need to say that both conditions must be satisfied. Right. So Okay. Tengok of these things first I'm going to show you how each of them works long by one. Sorry. I'm just trying to find a suitable table. Okay. There's 1000 row down there. Right. You should be suitable enough. Okay. I actually I wanted to damage some stuff but okay doesn't matter. Let me just jump ahead a little bit. Let's say for instance I want to get the list of customers and for text comparison if you want to have wallcast you can actually use percentage command. And what's going to happen is that when I click all the last names down here they are going to start with the last name. Okay. Now let's say I want to be a little bit more adventurous and add two or more okay. Okay. And I say I want to have customers who start with A and customers where the first name starts with let's say D. Okay. Let's say I use the N command to join it together. See. So you will basically satisfy both conditions and return to me only the records and satisfy both conditions. But of course if I want not just N but I just want is either starting with the last start with letter A or the first I mean the definition of those records is normal English and is both must satisfy or is either one of them must satisfy and of course if you chain them all up together. Alright. So I'm sorry. In addition to I'm going to jump back to the standard later but now I just want to focus a little bit on the where because I think that's where we need you see equals like you see like more context comparison there is also a set comparison meaning you say you want you want to restrict that column that falls into a particular set set meaning it's just like on list of values so the comparator is actually in I am and it works something like this. Okay. What this means is that as long as the last name is Anderson or Walker it's going to give me the results and there you have it. Alright. So equality in for numerical values you also have you know the standard more than less than more than equal to less than equal to so I'm not going to demonstrate and I think that's pretty important. Range Ya Ya it means it's either one of these two Ya Correct. It's not if it's set meaning to say as long as it falls within one of the members within that set it will come up. You can do it like 10 10 you can do it like 100 Alright. So Ya and Ya so that's the set come in range is more on America between 1 to 10 or between like 40 Sorry Ya, I forgot the command. Ya, between between 1 and 10 and the store ID just between 1 and 10. In fact if you look at the slides each and every one of them sort of like copy an example and show you how it works relative to the initial table that I showed you so it will be good and you can go back to that. Ya so that is the different where I close. Yes. Yes, correct. But if you want to okay good question Ya, the range will be good but if you want to exclude it is actually very simple you can actually replace the range with a combination of two the numerical comparison operators for example instead of between 1 and 10 okay if I want to make 1 and 10 not inclusive I can do something like this where store ID is more than store ID is less than 10 it achieves exactly the same purpose okay so one thing about this language is that okay one thing about every language is that it's actually much faster if you do this it's actually more than one reason more way out of the things all the things like in if you want to be in or out of the universe you can even do something like this if you want to play power okay I don't have to but anyway you get the cheese last name who's the Jones or last name who's Jennifer it's essentially the same as last name in Jones common Jennifer close friend guy it's exactly the same okay I mean same in terms of results probably not same in the way that SQC does operations but ya we don't really care about that in front of time yes sorry can we get in the middle ya sure why not hold on let's say an example if you want to see whether or not a name has a number 5 again okay it will be something like this that means you and close it we use a like because it's going to be a text comparison and use a percentage in case at the left side and the right side number 5 so that wherever the part of 5 appears in the name that entry will satisfy this criteria and we'll get flag out ya so ya that is that this one is not really commonly used but it's very very powerful but I'm not going to do it today but just in case you're interested in it and because of this term called regular expression in short regular expression okay ya you can go in so regular expression is a way to as a way to specify parts and variety in all stream patterns like for instance the one that okay let's close this okay there's a limitation down here the limitation is that your main check will be made to 5 if that's the for instance you say you want to have a check for any numerical characters within a name that means it's going to come from 0, 1, 2, 4, 5, 6, 7, 8 like correct if you think this kind of syntax is a little difficult ya of course it changes a lot which is not what I would recommend but alternatively you can actually use regular expression okay I won't go into the syntax they want you guys to exercise but using regular expression you can actually you can actually specify that's going to find out whether the name has any numerical values inside or not okay it's going to go a little bit like this but I can't quite recall the syntax at this point in time so pardon me for that but it's going to be something like this okay actual syntax I will encourage you girls to go and check it out sorry sorry like if there's a chain of numbers for each number I think like the first lake of cities and yes we will turn it at 4 in my slides a site from the percentage sign let me see where I can find it okay a site from the percentage site which pretty much means 0 or something like that or anything also the underscore character okay underscore character means that there must be one thing down there so let's say for instance if you want to select let's say the name put it by the second enter character is 80 for instance it will be something like this say that there must be something in front of 80 that means A and T must be the second enter character and all the results boom boom boom it's all 80 okay and this is definitely I mean even just a symbol for yourself you can see that it's actually much more powerful than Excel you try to do it in Excel cannot I mean if you can eyeball it but if you have let's say 1 million records good luck to you so much better yeah I'll come to that later let's not jump jump the gun first show me what is your sorry la so for this one what's that like the the possession of anis only works together with the like like statements just yeah it only works together with the like statement okay so equals literally means it must equal like means that there's going to be another match and it goes on text based columns text based columns so for the where clause any questions whether okay if no question I'm going to jump back a little bit and just show it like that alright I've talked about I'm going to show more what you can do I just jump an A and go to where clause that means where all the conditions I'm going to take a little step back and look at select can you guys actually do something about most of the time you just select column alright but actually you can do a lot more than text okay you can actually actually have let's see what I have set down here aside from start you can also have certain interesting keywords like for instance distance distinct can be used to illuminate some yeah illuminate duplicates so what I mean by that let's take a look oh sorry shouldn't use this one use customer okay I'm not to show it is a very good example because if the entries don't have duplicates then there's really nothing much for me to show let's try okay so let's say for instance okay I know this is a very bad example so but I hope you see the points if you type select store id from customer it's just that all the store id is from all the customers and you can see that there's actually a lot of duplicates okay so if you use the word distinct it's just going to show you the distinct on the unique values from the table alright so I do what kind of scenario let's say for instance you have a database of customers from several countries okay and you don't have a master country data table you just have everything in the customer tables and you want to quickly know how many countries does the database cover so there's a kind of statement so let's say country from customer and a set of distinct you can also do a lot of funny stuff like let's see what we have here you can actually perform computations on the color itself and you can even rename it rename when I say rename rename it so something like this rental is not a good one by the way I'm selecting table so that you can demonstrate to me okay good one you can see there's this color amount alright so let's say your currency creation by 50% and you need to multiply all this amount 50% so you need to multiply 1.5 so you can do something like this and all the amount just multiply 1.5 and give you the results now just take notes these are just the results the underlying values in the database is not touched in any way alright so you don't have to worry about I wouldn't really call it a view it's more like after performing competition it presents to you the results and everything is just done at the front end so what's next time you're going to show the homes that you're going to ask you the underlying ones yes as long as you don't do any updates as long as you're learning the underlying data will always be the same it depends like for instance I type something like this select amount 1.5 as new amounts this is just like a temporary column on the result set that you see but if you want to see everything else it's the same thing it shows you everything and at the same time there's a new column new amounts which essentially is the alright, any questions? some more stuff just now I already show just now I already show just now I already show oh yeah just now I already show the operation that you can perform in addition to that you can also do other things like crap, I didn't really have to come here you can actually do things like counts okay this is one command which I use pretty often so let's say you'll see how many entries I have in my payment table here's what I do see counts will just count all the tables all the entries about 16,000 payments in that table payment itself okay so aside from counts you can do a lot of other stuff you can do things like main you can do things like max main set for minimum max set for maximum you can do things like get it in average but yeah so something like this okay hold on ah let me just explain to you what a statement is before running it okay great so under the set clause I can select the minimum amounts I can select the maximum amounts and the average amounts so this tells me the minimum price that a person has paid the maximum price that a person has paid and on average what is the average amount what is the average amount that is paid all the entries and here's what it gets when I run this statement so there's a free entry there is maximum amount paid is $11.99 and the average is $4.20 for all different records okay simple analytics just a couple of simple statements whom you have it yeah you didn't say you wanted any amount but the price did you add in did you do the calculation did you add that amount no it's just a result the database is not being touched anyway so how I guess my question is but I think that's capable first you need to alter the schema because one thing different about database as compared to Excel Excel if you want a new column just type whatever they want database remember we have create table and for each create table you actually have you actually have the attributes and the types so if you want to change it to database you need to alter the table so you can't do that I guess how much I've done you have to take it out and then no no no you can just there's a common goal out of the table which I'm just going to show to you off the top again I don't really remember all the syntax but it's what you can do so under alter it's like so consider screen okay you can actually add a new column down here and then later on you need to have a lot of update commands to make the change and then to populate out the entries in that column okay but there is an easier solution which actually it comes a couple of slides later which is called creation of not I've thought about tales we've talked about results which is results of your of your queries you can actually save those results into what we call views okay and views will be something like you can treat it like on the main table where you can do queries but it does not really change what about the life data so for instance again let me just jump the gun because I don't need a lot of stuff so I want to show you whatever question that you want so let's say for instance somebody select or if you want a new column as new or not and you want to make it like a new view in the table so that you can manipulate you can create an ordinary table you can do something like this yeah let me just double check the syntax as you know it won't just go to check blah blah blah okay so I run it if nothing goes wrong alright it's created now if you see by the side there is tables right let me just fold this but there's this additional thing called views okay and just now I actually type new payments so let me just refresh this you can see that the new view appears can you see that I'll call new payments and you can actually query this view as you would a normal table something like this see it's like it's a normal select query and it has the things that I want with the additional column of your column view amount see so this allows you to create tables which can perhaps be a combination of other tables and you don't necessarily make any changes to the underlying to the underlying data okay so there is called views I'm actually jumping like views size again but you get the idea so where was I okay select sorry this is down okay so select clause where clause any questions or any other specific scenarios that you want me to point out take note that it's actually a lot more than that but we cannot have any conversation sorry day and time good question but day and time is the same as if you would compare the stream okay that's it for instance something like that okay I want to find out all the entries that whereby payment date is after let's say 2005 June the 1st alright so that's my requirements and here will be the query it's a little bit like normal text nope nothing wrong hold on oh okay sorry sorry sorry 2016 right so you can see that it actually pattern for the resolution and the resolution not very good so you can't really see a lot of real estate screen ya you can see all the entries down here okay are actually later than 2005 June the 1st so the way in which I would compare day and time is almost the same as if I would compare the same numerical values or text that means you use the equal operator you use the greater that smaller that so and so forth you can even specify between that means using the range function okay all these things will work alright yes sorry ya I can I can use the range function as well hold on right so right now I'm specifying I only want payments in between the payment date of 2005 0601 and 2005 0701 so that's all my result start you see everything is all in June alright ya it's not a twist so ya you get the point actually there's a lot more but I don't think I'm going to cover them just like 0701 I'll just move on to the next part of the query which is alright as I mentioned now I'm going to cover the phone calls okay I sort of miss out the slides so let me just explain to you verbally 2 things that I would like to mention 1 is the group by clause so what does group by do as the name implies it groups results together so what do I mean by that so let's say for instance I open up a new table okay great so let's say I want to group by customer ID you see customer ID there's 1, 1, 1, 1 so and so forth there's a lot of see a lot of 1s a lot of 2s a lot of 3s 4s so and so forth so in my group by customer ID here's what happened you see now the customer ID becomes a little bit unique because there's no repetition I actually lump up the whole whole thing together and only display the first one now you might ask why in the world do I want to do that for usually group function I use it in conjunction with the operations or the functions in the select clause so let's say the question let's say for instance I would ask myself I want to see for each user how many rentals I have made okay so that way you can use the group by and another interesting thing is here I combine these 2 together select customer ID called count which is the function that I have made just now in the select clause from payment group by customer ID and if I want to trigger this of bam customer ID number 1 32 rentals customer ID number 2 27 customer ID number 3 blah blah blah so and so forth okay and same thing if I want to know which is the biggest circle that I have I can do this as well you see so just based on this statement select customer ID count that means I want to know how many rentals he has made the maximum amount that he has paid the minimum amount that he has made in fact I don't go once and for all and do some which I did not really mention just now so and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then and then dan bagaimanapun ia akan mempunyai pelanggan. Ya, kawan. Ya, jadi itu adalah perkembangan Kluar Wars. Okey? Ya. Jika kita membuat perkembangan Kluar Wars, itu sebabnya ia lebih seperti perkembangan untuk perkembangan data. Jadi jika perkembangan data berubah, Kluar Wars juga akan menjadi perkembangan data. Ya, kita perlu membuat perkembangan data. Kerana apabila anda membuat perkembangan data, ini hanya sebuah kata-kata perkembangan data. Jika anda membuat perkembangan data, yang awkward akan kerasiости. Sebenarnya ia tidak mencabar. Ya, ia tidak menı upgraded perkembangan data. Inilah perkembangan data jadi berubah. lotta ia adalah mengandalkan perkembangan data. Benar, anda tidak harus membuat perkembangan data begitu biasa. Kerana perkembangan data itu bukan Pour外 itself. Secara saat membuat perkembangan data itu adalah menyebabkan perkembangan data yang menghadapi perkembangan data yang dia exhaustion kongsi. Jadi jika anda memperkenalkan perubahan data, periksa diri anda sendiri, saya bermakna ia hanya di bawah, ia bukan apa yang sebenarnya. Anda juga melihat perubahan data, anda masih melihat perubahan data. Jadi anda tidak perlu risaukan apa-apa saja. Ya, jadi itu adalah kawasan group-bibe. Maksud saya anda dapat group-bibe dengan diri sendiri, bukan apa-apa saja yang berlaku, tetapi anda menggunakan perubahan dengan perkara yang berlaku, jika anda menggunakan perkara yang berlaku. Dan yang terakhir yang saya ingin beritahu, adalah perubahan atau perubahan. Saya hanya ingin beritahu anda tentang itu. Jadi perubahan adalah perubahan yang berlaku. Jadi saya boleh lakukan sesuatu yang penting. Perubahan dengan beberapa nama. D-E-S-C berlaku untuk perubahan. A-S-C berlaku untuk perubahan. Dan mereka melakukan apa yang mereka lakukan. Maksud saya, mereka menggunakan perubahan atau perubahan. Jadi saya akan menggunakan perkara yang berlaku. Jadi perubahan pertama yang berlaku adalah 599. Ia hanya untuk menghubungi. Ia sedikit menghubungi di sini. Kerana ini adalah perubahan yang berlaku. Anda dapat mengalami perkara yang berlaku. Tetapi untuk orang-orang yang menggunakan perubahan untuk menghasilkan perubahan mereka, mereka akan menggunakan perkara-perubahan menggunakan perkara yang berlaku. Kemudian mereka akan menggunakan perkara yang berlaku untuk menggunakan perubahan untuk mereka. coal�리aban yang maklum untuk itu. Baiklah, semua yang mula digo. Trus membantu dan menggunakan perkara yang berlaku. Juga jika anda mahuwie popi slike, anda mengokepannya pada kedai daran. kerana mereka mempunyai sebuah tabung yang, jika anda fikir tentangnya, ia bukan sebuah tabung yang paling sulit dalam dunia. Tetapi apabila anda mahu menggantikan tabung yang bersama untuk memberikan keputusan yang unik, itu adalah keputusan tersebut yang akan berlaku, betul? Jadi apabila anda bercakap tentang keputusan, sila cuba beritahu penyakit-penyakit dan sebuah tabung yang saya bercakap tentang sekarang. Kerana ia hanya bergantung pada keputusan yang berlaku. Jadi apa yang saya maksudkan? Mari beritahu contohnya. Selain keputusan, sama tabung yang berlaku. Maksudnya tabung yang berlaku. Baiklah, saya akan beritahu keputusan yang berlaku. Tapi saya tidak tahu apa yang saya akan beritahu keputusan yang berlaku. Kamu melihat John dan Mary? Saya tidak tahu. Tapi saya mahu melihat mereka di tempat yang sama. Jadi apa yang saya akan lakukan? Sangat sedap. Saya hanya perlu menikmati tabung yang berlaku dengan... ...dan apabila saya menikmati tabung yang berlaku, mereka mesti mempunyai sebuah kolon yang penting. Baiklah, itu bermakna untuk satu tabung yang akan menjadi keputusan dan untuk satu tabung yang lain akan menjadi keputusan yang berlaku. Mereka melihat semua keputusan tersebut yang berlaku bersama. Jadi mari saya menunjukkan apa yang saya mahu beritahu keputusan yang berlaku. Saya juga mahu melihat nama orang yang berlaku. Ini apa yang saya mahu beritahu keputusan yang berlaku. Pilih atau dari... ...pengalaman. Pembuah-pembuah. Pembuah. Baiklah, saya akan melakukannya segera. Baiklah, sebab saya tidak tahu semua kolon yang berlaku. Saya hanya melihat tabung yang berlaku semalam. Mari kita lihat apa yang ini berlaku. Baiklah, bagus. Baiklah, jika anda melihat... ...saya sebenarnya menggunakan beberapa bulan. Saya mahu... ...di sini, saya akan mempunyai jangkauan yang berlaku. Saya akan mempunyai pembunuh yang berlaku. Tapi apa yang saya mahu beritahu adalah, saya mahu menghubungi tabung yang berlaku dengan tabung yang berlaku. Dan pilih yang saya menghubungi mereka di antara itu adalah pilih pilih. Jadi saya menghubungi pilih ini. Pilih pilih pilih yang berlaku dengan pilih pilih. Pilih pilih pilih yang berlaku dengan pilih pilih yang berlaku. Dan anda dapat melihat bahawa... ...dengan pilih pilih pilih yang berlaku... ...yang berlaku di sini. Jika anda berlaku lebih jauh... ...saya dapat melihat semua pembunuh yang berlaku di sini. Lihat? Lihat itu? Baiklah. Jadi, kembali ke jalan yang sama... ...sebelum sekarang. Ini bagaimana ia berlaku. Sebelum ini. Jadi, bagaimana ia berlaku. Pada pertama dan akhirnya, saya adalah seorang pelanggan. Tapi pada masa ini, untuk pilih pilih pilih... ...sometimes saya meletakkan tabung yang berlaku di dalam penjara. Biasanya, jika pilih pilih yang berlaku... ...dan pilih pilih yang berlaku di dalam penjara... ...saya cuba mencari pilih ini. Kerana pilih pilih yang berlaku... ...dan pilih yang berlaku. Tapi pada masa ini, anda ada... ...berapa pilih pilih yang berlaku di dalam tabung yang berlaku. Jadi, bagaimana anda perlu memiliki nama tabung yang berlaku di depan itu di depan itu. Anda akan menarikkan pilih SGL 7 jumpsa di mana tabung yang berlaku... ...semasa anda sebenarnya, memalukan turun. Jadi, saya mahu pertama dan akhir tallah. Saya mahu pilih ID. Saya mahu pilih retiretah. Sementara berlaku pada sumbakan jenaka, ...saya sebenarnya telah melakukan pilihan untuk saya. Sebenarnya, jika saya mempunyai kakak, mungkin saya pasti saya akan memperkenalkan warna. Mereka akan melihat cara itu. Ya. Macam ini akan lebih mudah untuk melihat warna. Ya, satu perkara yang saya tanya adalah, anda tidak perlu mempunyai semua warna yang sama. Setiap warna perlu memperkenalkan warna yang sama. Jadi, saya akan memperkenalkan warna yang sama. Jadi, anda memperkenalkan warna yang sama. Walaupun ia mempunyai 5 warna sebagai satu warna. Jadi, beberapa perkara yang anda lihat kan memperkenalkan warna untuk memperkenalkan warna. Mereka tidak akan memperkenalkan warna. Jadi, saya akan memperkenalkan semua warna yang sudah digunakan. Jadi, kakak ini adalah perkara terdapat akan mengetahui. Mereka mungkin mengetahui teman-teman dan kelas yang saya akan mengetahui. Dan kelas yang saya akan mengecewakan. Dan kelas yang saya mengecewakan oleh kakak yang mengetahui, saya sudah memberikan. Dan ini adalah perkara yang mengetahui. Ia sama seperti tadi. Sebenarnya, saya mempunyai pakaian yang terbaik dan bukan pakaian yang terbaik untuk pelanggan saya. Ia dipanggil Carl Siu. Jadi, Carl Siu adalah pakaian yang terbaik untuk pelanggan saya. Ia membuat pakaian yang terbaik untuk pelanggan saya. Oleh itu, bagaimana kita gunakan pakaian yang terbaik? Sudah tentu, ia berkata bahawa ia hanya membuat pakaian yang terbaik untuk membuat pakaian yang terbaik. Sebenarnya, jika anda ingin menjadi lebih terbaik, anda boleh membuat pakaian yang terbaik untuk bersama-sama. Okey? Jadi, ya. Baiklah. Baiklah. Saya juga ingin mengenai pakaian yang terbaik. Baiklah. Saya akan membuat pakaian yang terbaik. Ada sesiapa yang tahu pasukan sebuah pakaian? Baiklah. Ada sesiapa yang mengambil pakaian yang terbaik untuk melalui pakaian? Baiklah. Okey. Jadi, pakaian yang membuat pakaian yang terbaik Pastikan tujuan yang telah mempunyai peringkat dalam peringkat dalam kedua-dua kabel Sebelum anda menjawab jawapan Jadi apa maksudnya? Ini bermaksud bahawa Sekarang saya mempunyai peringkat kabel kastimah Sebelumnya saya mempunyai peringkat kabel kastimah Jika kita katakan kastimah tidak membuat randos Tidak membuat peringkat kastimah Dalam keadaan saya yang telah digunakan Namanya tidak berubah Kenapa? Berbentu Ker tussen Namun untuk berkata bahawa anda yang menarik flat açıl dalam peringkat kabel He rerata tidak dapat digital palmsaw6 Jika seperti penang matas kabel jika anda meledih設a Jadi cesanya daripada tidak memiliki peringkat kabel Mereka masih terlihat Tetapi hanya kerana mereka tidak mempunyai pembentangan, pembentangan yang tidak berlainan hanya akan berlainan. Saya tidak pasti jika ada pembentangan seperti ini. Okey, terima kasih. Saya akan mempunyai pembentangan seperti ini. Semua pelanggan mempunyai pembentangan. Jadi ia sangat susah untuk menunjukkan. Tapi semoga anda dapat idea. Jadi, pembentangan. Inilah tiga potong kita. Kita boleh lepaskan второй potong yang sudah dimulai dan cukup. Jadi Jadi saya mahu bahagian ini untuk menjadi tempat yang terbaik dan itu sebabnya ia di sisi yang terbaik Tetapi anda tidak menghargai bagaimanapun anda hanya berada di sisi yang terbaik? Ya, anda hanya berada di sisi yang terbaik dan anda hanya berada di sisi yang terbaik Dan sebagainya, jika anda mahu mencari mana pengalaman tidak mempunyai apa-apa yang berlaku Mungkin ia adalah pengalaman yang terbaik atau sesuatu yang ada di sisi yang terbaik Kemudian, anda akan menjadi pengalaman di sisi yang terbaik Dan jika anda mahu berada di sisi yang terbaik, ia adalah pengalaman yang terbaik Tetapi bagaimanapun anda tidak mahu berada di sisi yang terbaik? Baiklah, mari kita lihat Boleh anda melihat sedikit lagi? Saya hanya berada di sisi yang terbaik Baiklah, anda berada di sisi yang terbaik atau sesuatu yang terbaik Dan tidak digunakan sebahagian ini untuk pemasaran Bisa memberi ke Defense yang melawan wilayah Jika saya mahu mempunyai sisi yang terbaik, Sebelum itu saya tidak akan membuat halangan, hanya untuk hubungan Baiklah, anda tahu bagaimanapun anda adalah Sekarang keputusan antara ini, 3! Tidak ada banyak antara antara. Jika ada kedua, suatu adil yang akan berubah. Tapi jika ada suatu adil yang lebih teruk, suatu adil itu akan berubah. Dan sehingga ada suatu adil yang akan berubah. Sekarang, J, Satu yang terkenal. Itu berarti, dalam pakaian yang terhadap pelajar, 3 akan terjadi. Pertama yang berlaku dalam pakaian yang berlaku dengan tidak. Pada pelajar, saya tidak dapat mencari pakaian. Jadi, anda hanya mempunyai S, N, U, L, M. Ini tidak akan berlaku. Saya akan mencari pakaian yang terhadap. Okey, jadi, kita akan mencari pakaian yang terhadap. Sekarang, anda akan mencari pakaian yang terhadap. Pakaian yang terhadap, anda dapat melihat pakaian yang terhadap di sini. Pakaian yang terhadap akan berlaku dalam pakaian yang terhadap di sini. Dan akan menjadi pakaian yang terhadap pada pelajar. Jadi pakaian yang terhadap akan berlaku dengan tidak. Anda akan mendapat pakaian yang terhadap. Dan別i yang tidak berlaku sehingga anda dapat 2 dolar yang terhadap. Okey, jadi kita akan mencari pakaian yang terhadap. Dan anda akan mempunyai pakaian yang terhadap. Tidak mengapa. Kami tidak boleh memikirkan mereka, tetapi kami boleh memikirkan mereka dan sesuatu yang berlainan. Untuk contoh, ia bermakna berlainan seperti yang kami lihat. Untuk perubahan yang mempunyai perubahan yang berlainan, dengan perubahan yang berlainan, anda akan menemukan dua panggilan. Satu adalah perubahan yang berlainan untuk perubahan yang berlainan. Mereka pasti akan berlainan. Jika anda ingin menetapkan 90% untuk mem practik panggilan berlainan atau berlainan untuk memd 있었. Dengan memberikan dengan hullaw bob obl overtime, atau coklat para hav다가 berlainan, juga plunga saya servers Untuk sikap pipa-pikas orang-orang yang kuat datang ke ini Iner joint is getting from here Left outer joint is getting from here Right outer joint is getting from here And full outer joint is cochang If you want to wind this off Then you need the web port to wind it off Besides the normal pad And all kind of operation design Right So that's the inner joint for you Pada pertanyaan, apa yang berikutnya? Saya sudah berjalan lalu, jadi tiada apa-apa untuk bercakap tentangnya Setiap hari, saya sudah berada di dalam perjalanan Jadi saya harap anda semua tidak mahu lakukannya Ada beberapa perkara yang digunakan Ada beberapa... Pada keadaan keadaan yang penting Pada perjalanan keadaan Ada juga perkara lain seperti Sekarang Pada perjalanan atau dalam perjalanan yang anda boleh menggunakan Bukan kedua perjalanan, bukan kedua perjalanan Tetapi siapa-siapa pun Jadi mari kita tanya apakah saya mahu mencari kue Dengan perjalanan yang pertama, saya tidak mahu berada dengan ketiga saluran Ini bukan pementyabat paling rendah Saya hanya mahu menikmati pementyabat Oleh itu anda boleh menggunakan sub-stream Di mana keranabot yang lebih muda Pada perjalanan keadaan yang mempunyai Ini merupakan keadaan yang anda pilih atau yang anda pakai. Apa yang anda lakukan adalah itu. Apa yang ini adalah adalah ia membuat keadaan yang pertama, keadaan yang pertama, yang saya pakai adalah satu. Jadi keadaan yang pertama. Lihat semua keadaan yang terakhir, ia bermula dengan keadaan yang lebih awal. Jadi ia membuat keadaan yang lebih awal. Ya, ini adalah sebuah contoh yang penting. Tapi jika anda dapat menggunakan cara yang penting, lagi, ia boleh menjadi sangat kuat. Baiklah. Untuk keadaan yang terakhir, anda boleh menggunakan seperti ini. Sekarang, keadaan ini dan keadaan yang sekarang, keadaan yang sekarang dan keadaan yang sekarang, ia berguna apabila anda mahu memiliki keadaan yang terakhir, apabila anda mahu memiliki keadaan yang tidak terakhir, ia bermaksud ia berguna apabila anda mahu memiliki keadaan yang sekarang dan memiliki keadaan yang sekarang dan keadaan yang sekarang, keadaan yang sudah diberi, tapi anda boleh menggunakan keadaan yang dah berlaku untuk melihat keadaan yang belum dikepahar atau tidak diperhatikan apa yang anda mahu. Jadi, keadaan yang sekarang adalah sebuah keadaan yang terakhir. Sebenarnya, anda boleh menggunakan fungsi seperti ini. Kerana tidak perlu membutuhkan tabung. Selepas itu, anda akan mencubanya. Dan anda akan terus menggunakan tabung untuk perhatian di mana yang lain. Okey, keadaan ini tidak akan digunakan di sini. Tetapi saya hanya ingin menunjukkan bagaimana anda boleh menggunakan... Saya hanya ingin menunjukkan bagaimana anda boleh menggantikan keadaan keadaan keadaan keadaan keadaan. Jadi, kita akan membangkalkannya. Jika anda nak melihat yang mana yang telah dibayar... ...atau penasaran penat. Jadi, anda boleh membuat sesuatu yang anda memilih... ...kalau anda memilih satu yang lebih memilih... ...serta sekarang, dengan pengurusan... ...dia akan disulangkan pada masa sekarang. Baiklah. Jadi, ini menjuali maklumat yang benar... ...atau ia akan mencubanya. Tetapi, ia mencubanya dengan jauh. Sebenarnya, saya belajar... ...awak menunjukkan bagaimana anda boleh menggunakan. Terima kasih. Semoga MIMA TABER yang menunjukkan ini. Ini sangat bagus. Jadi... Baiklah. Sekarang. Selepas ini, keadaan keadaan, keadaan keadaan keadaan, keadaan keadaan keadaan, keadaan keadaan keadaan, keadaan keadaan keadaan, keadaan keadaan, keadaan keadaan, Ya. Maaf. Ini adalah sama, bukan? Keadaan keadaan. Ya. Ya. Ia bukan operator. Jadi, ia tidak sama. Ya. Terima kasih. Baiklah. Okey. Jadi... Selepas ini, saya hanya ingin beritahu. Dengar. Jangan fikir pada akhir hari, kamu semua akan beritahu kerana ia tidak mungkin membuat semua orang beritahu. Apa yang saya beritahu, ia hanya sebuah tepung sebuah keadaan sebuah sebuah sebuah sebuah sebuah sebuah sebuah. Saya tidak akan berharap untuk mencari keadaan, mencari keadaan dan mungkin memcari keadaan keadaan keadaan supaya kamu tahu yang dapat mencari keadaan dan dapat belajar keadaan keadaan. Jadi, saya hanya ingin beritahu keadaan keadaan keadaan keadaan. Okey. Jadi, apa yang keadaan keadaan keadaan sebagai sebuah keadaan, ia bermakna adalah keadaan keadaan dalam keadaan. Jadi, sebuah sebuah sebuah keadaan adalah sebuah keadaan. Mereka akan mencari keadaan keadaan keadaan keadaan keadaan keadaan dalam keadaan saya. Saya tidak mempunyai masa. Ya. Jadi, anda dapat melihat daripada saya di sini. Mencari keadaan keadaan keadaan dengan nama tidak Sebenarnya, kami tidak memikirkan keadaan keadaan. Tetapi, saya hanya memikirkan keadaan akan berani dengan diri dengan diri keadaan keadaan sebuah keadaan. Okey. Saya hanya memikirkan keadaan dari pelanggan. Jadi, keadaan keadaan dari pelanggan akan menerima keadaan keadaan tersebut sebagai keadaan keadaan. Untuk salah suatu ke pork kuda kita dapat dapat melihat caranya yang terlalu seronok. Kita akan lihat contohnya. Ya, anxious. Dan keadaan yang unik adalah perkara yang sama. Bagus. Ini adalah keadaan yang berkongsi. Ini adalah soalan yang saya sentiasa ingin beritahu orang tentang SQL. Saya sentiasa ingin beritahu, beritahu bahawa kita ada selera. Ini adalah penggunaan yang terbaik dari penggunaan yang terbaik. Ini berkongsi untuk saya. Maksud saya, soalan SQL adalah cara yang berkongsi. Saya akan menunjukkan bagaimana. Saya ingin menemukan sebuah penggunaan yang terbaik. Soalan yang saya sentiasa ingin beri adalah pertama, penggunaan yang terbaik dari penggunaan yang terbaik. Dan itu adalah keadaan yang berkongsi. Saya akan menggunakan penggunaan ini sebagai peringkatan ke penggunaan lain seperti ini. Jadi, apa yang saya maksudkan? Jadi, saya menyebabkan pakaian yang paling tinggi. yang paling tinggi di atas. Dan di atas saya, kerana saya berada di tempat yang berada di atas, bukan di tempat yang terbaik. Jadi perkara pertama yang akan kita lakukan adalah ia akan mempunyai semuanya yang paling tinggi di atas. Dan salah satu yang tersebut, ia memberikan saya tempat yang terbaik di atas. Jadi, apa ini? Maksudnya, ia memberikan saya tempat yang terbaik. Ia adalah pertanyaan yang terbaik. Ia adalah pertanyaan yang terbaik. Dan di tempat yang terbaik, ia akan membuatkan perjalanan yang terbaik. Baiklah. Ya, ini adalah perjalanan yang terbaik. Saya selalu memperkenalkan perjalanan yang terbaik di atas. Ya, ini adalah perjalanan yang terbaik. Sebenarnya, saya tidak menunjukkan perjalanan yang terbaik di atas. Saya tidak perlu menggunakan perjalanan. Ia akan terjadi. Tapi, saya ingatkan satu-satunya konsep yang keadaan yang dapat diperlukan dalam satu-satunya keadaan yang akan memperkenalkan lebih banyak keadaan dan lebih banyak keadaan yang anda ingin memperkenalkan. Baiklah. Dan perjalanan yang anda sudah menarik, saya akan mencuba. Dan itu saja. Itu akhirnya. Untuk memperkenalkan keadaan yang berlaku dalam setiap kedai syarikat. Dapat keadaan yang berlaku adalah perjalanan yang terbaik di atas. Jadi, anda tidak berat di atas kawasan web. Saya hanya andaain semula kejadian yang kedua. You glass. Boleh anda melihat kawasan ini? Sebenarnya, di sini, kami membongkannya di atas. Tapi, kerana kedai web ini Seperti yang kita lihat di mana-mana yang kita lihat di selesai. Ini boleh menjadi segala-galanya. Ia boleh menjadi seperti yang kita mahu. Jadi, kita akan berkata, saya mahu mengenai semua pelanggan yang terlebih dahulu, untuk mengenai sebuah nama yang... Saya akan jumpa lagi. Tunggu. Biar saya menunjukkan kepada anda. Okey, jadi... Okey, ini bukan penerbangan sebenar. Ini mungkin penerbangan sebenar. Tapi semoga anda dapat melihat perkara itu. Anda boleh sebenarnya menjelaskannya ke sesuatu yang anda tahu, menjelaskan perkara yang tidak sesuai. Anda boleh menggunakan ini untuk mengenai penerbangan sebenar. Dan anda boleh menggunakan hal yang digunakan atau yang anda lakukan. Jadi, apa yang berlaku adalah, anda akan mengubah semua pelanggan yang terlebih dahulu untuk mengenai penerbangan sebenar. Saya menunggu. Sekarang, saya benar-benar mengenai penerbangan sebenar. Dan... Pertama, anda akan melihat bahawa tidak ada lagi A. Ia bermula dari B. Dan kemudian, anda akan melihat bahawa ia akan menjadi banyak orang penerbangan sebenar. Ya, orang penerbangan sebenar. Anda lihat di sini? Jadi, ini bukan penerbangan sebenar. Dan... Anda boleh menggunakan perkara ini untuk membantu anda mengerikan penerbangan sebenar. Tetapi, satu perkara yang saya ingin memikirkan adalah bahawa... anda lebih baik mengenai penerbangan sebenar dan anda lebih baik mengenai penerbangan sebenar. Sebab itulah anda membuat kesilapan, dan anda menyebabkan sesetengah perkara lain. Ia akan menjadi sebuah penerbangan sebenar. Ia adalah sebabnya, sebabnya, bahawa dalam kerja-kerja saya, saya tidak mengenai penerbangan sebenar. Okey, kerana... Bukan apa yang saya katakan? Kerana perkara ini adalah sedikit bahagian yang teruk. Kalau sesuatu yang anda mengenai atau sesuatu yang anda lupa dan anda mengenai penerbangan sebenar, dan anda akan menjadi sebuah penerbangan sebenar. Jadi, ini dari hidup yang sebenar yang saya katakan. Saya whereas... Okey.... Selalu merupakan... There is this part known as take time and timestamp. Actually, in the underlying database, it doesn't really store that as strings. It has a so internal representation of take time. So you can actually choose to display, whether it be year, year, year per Monday day or you can choose to display it in a month, year day, or you can choose to return it in extreme representation. It's just a matter of formatting what you're querying. As long as it's underlined, it still requires representation. Okay. Off the top of my head, I don't know whether to recall the comment. Let me see. Okay, awesome. Okay. Okay, honestly speaking, I don't know whether this is correct, but let's see how it works. Can you see that? See, this is a format, first year, mid-year, small wine doesn't look good. Let's change it to a big wine. So there's additional formatting function, which is called date format, which takes in your fuel, which underline representation is a date. It doesn't really matter how it shows. And this string is a format string. Percentage wine means it's the year it falls in date format. Percentage M means the month, and the D means the date. Okay. And there's a lot of other formats which have come in a lot of time. And the interesting thing is that nothing underline database can change. It shows the way that it is present as a year. All right? So, yeah. Okay. Great. Okay, so far for all the for all the basic syntax, do I have any questions? I mean, do we have any questions of queries? Curies for queries? Okay. If not, you know, actually I've prepared some hands-on exercises because I kind of thought that I would finish that session in like one hour, but it took me like two hours, so I don't think we'll have time for exercises. But what I highly encourage you all to do, and I think the date is to is to when you go back and try out on a circular database, try to answer all these questions using SQL queries. Okay. If you do not know the answers, feel free to email me. You can get my email form. Sorry? I'm done. Okay, sorry. You can get my email form ever. But please try first and just share away after this session. It was like, can you tell me what answers now you like? No. Okay. And I actually have some challenges. These are the more challenging questions to enforce, a lot of joys, a lot of ambitions. We're going to try that one as well. So I think it will be for you all. And please share your questions. Ya. And the question. Rest at the end of the course for today. When I mention that now, I know that this is just a brief crash course. So you all will be able to understand the whole thing. I will highly encourage you to keep on trying, keep on asking. And hopefully today's session serves as a meaningful primary to database management systems. Okay. So if you just Ya, I'm going to try to answer what you've been waiting for. My age. And I'm actually 37 this year. So Okay. So right about the course. Thank you all for paying attention today. Ya, and I'm kind of bad and don't have this year. Apologies for the slides because it's just so it's a little loose but hope you'll understand what I'm saying. Thanks. Each of the team had to expect a team leader and said the name is to be five of the end of the course actually five at night. So we totally had potential people will attend the serious course. So there will be 236 people and that group will be five members. So you have to send these five nights and then I will send to you the final year I'm sorry. The final preliminary it can start now. Remember tonight otherwise I will email you. By the way who's for you to my turn right? Come on, move on out. And some of you haven't checked the planters. So so the first one is Foo Chien-Pien Chien-Pien it's here, it's here but not here. Okay. So this Gangga Ji Ji something. No, it's not. It's here. Oh Ji, it's not here. Okay. So next one will be Inang. Okay. Hello. And that one is Jennifer Lee and Jill Wong not here. Okay. So next one is Rui Wei Rui Wei Rui Wei not here. This one is Lara It's Lara here. No. The EZ Okay. Alright. And Lea Kalo Okay. Okay. And Martin Martin. Okay. Okay, that's fine. Okay, okay, okay. Go, go, go. Just another one. And this one is a very long name. A very long name. Oh, no, no, no. It should not here today. Okay. So Nicholas not here. No Ha Dan not here. Sarah is not here. Okay. So Susanna Susanna, Susanna. Victoria Victoria. Thank you, Victoria. Okay, not here. So Xiao Jing of Xiao Jing. Okay. Okay. Okay. Thank you. Thank you so much. You can go now. Okay.