𝗙𝗿𝗲𝗲 𝗟𝗶𝘃𝗲 𝗦𝗤𝗟 𝗰𝗹𝗮𝘀𝘀𝗲𝘀 -𝗦𝗲𝘀𝘀𝗶𝗼𝗻 1

Summary

The first session of Azurelib Academy's free live SQL classes, led by Deepa Goyel, provided an introductory overview of SQL basics and importance. Deepa, with 14 years of IT industry experience, emphasized the evolution and significance of data management and databases, particularly SQL and relational databases. The session was interactive, covering key concepts such as data, tables, rows, and schema, while also touching on practical installation of SQL Server and management studios. Although primarily for beginners, the session hinted at advanced topics like data science and engineering, encouraging further learning beyond just SQL certification, with a focus on real-world applications.

Highlights

• Introduction to SQL for absolute beginners. Perfect start for those who are new to SQL 📚.
• Deepa's passion for teaching: Making complex topics simple and relatable for everyone 🌟.
• Understanding the importance of data and its management in today's digital world 🌐.
• Practical session on installing SQL Server and creating your first database table 🛠️.
• The interactive session encouraged questions and engagement from participants 🤝.

Key Takeaways

• Data is everywhere! From your contacts to online shopping, data plays a crucial role 📈.
• SQL is essential for managing data efficiently; it structures data into tables and relates them 🚀.
• Relational databases like SQL Server organize data in rows and columns, ensuring structured storage 💾.
• SQL skills are not just for IT professionals; they're crucial for data careers like data science and engineering 🤖.
• Practical learning: Install SQL Server and start creating your own databases! 💻

Overview

Welcome to the exciting world of SQL! Azurelib Academy kicks off its free SQL classes with Deepa Goyel, a seasoned IT professional eager to share her knowledge. Day one was about breaking down what SQL is and why it's crucial for managing data in today’s tech-driven world. From understanding basic concepts to setting up SQL Server, attendees got a well-rounded introduction to begin their SQL journey.

Deepa, with her extensive background in data solutions and her initiative Azurelib.com, engaged the participants with insights on data's growing significance. The session emphasized SQL’s role in organizing and retrieving vast amounts of data efficiently. Deepa shared examples of real-world applications where SQL plays an integral role, setting the stage for deeper dives into SQL functionalities in upcoming classes.

Practical hands-on activities were a highlight, with live installations of SQL Server, ensuring no participant was left behind. Deepa encouraged a fun and interactive environment, inviting questions and celebrating the curiosity of her learners. This session was not just about learning SQL but about embracing a mindset of continuous learning and discovery, vital for anyone aiming for a career in data engineering or data science.

𝗙𝗿𝗲𝗲 𝗟𝗶𝘃𝗲 𝗦𝗤𝗟 𝗰𝗹𝗮𝘀𝘀𝗲𝘀 -𝗦𝗲𝘀𝘀𝗶𝗼𝗻 1 Transcription

• 00:00 - 00:30 and I'm really really sorry for being so messy with the our online uh live streaming so nevertheless it's fine it happens always when you go for a demo the things won't work all and it generally works well when you do normal uh on your own so we did one uh trial yesterday and it was all fine but somehow it didn't work out today but anyways
• 00:30 - 01:00 so welcome all of you guys I am Deepa goyel and in this free live sessions of the SQL we will going to cover the SQL from very start from a very very uh beginner level the one I mean for whoever is a very new who does not understand the SQL at all all of them can start learning from here okay so I without wasting any time because we already wasted some of our time uh in
• 01:00 - 01:30 this technical glitch so let's start quickly so moving on uh the first thing is like um let's talk about myself a very short brief introduction I know many of you already following me on the Linkin and many of you already know about me but still there are a lot of folks who might not know about me so let me just tell you in a very short about myself so I am having 14 years of
• 01:30 - 02:00 experience in IT industry I started my career somewhere around in 2008 and since then I am working in it I I am a Microsoft certified trainer I am a certified solution architect so basically I mostly work in the data side I am a data architect actually I work um as a cloud data solution architect so majorly my work is involved is to create the uh data strategy over over the cloud
• 02:00 - 02:30 so that's my current work is I'm a founder of azure.com this is one of the popular website in the Microsoft Azure Cloud world uh so almost every month almost around like more than uh one lakh people visit this website so it's a quite popular one I a LinkedIn uh influencer with having over 59,000 followers thanks to all of you guys who are following me and I help many of organization to build their data
• 02:30 - 03:00 platform so I'll cut it out my introduction let's quickly dive to our agenda okay so what our agenda is all about we are talking about the SQL SQL database and all so before that the first thing which comes in what is Data before I start this I'll tell you this probably this will be only uh the
• 03:00 - 03:30 session in this entire Series where I'll go and talk from the PPT otherwise I mean in my rest of the courses I don't use PPT at all I'm the guy who hates PP I feel like PP can be read by anyone so if you want to share something on the pp you just give them and they will do it on your own so I am the one who generally loves to share my knowledge practically so maybe from towards the
• 03:30 - 04:00 end of this session or maybe towards the U from tomorrow or next session onwards we will just I'll share my screen and I'll talk I mean I'll show you how to write queries and Etc so it will be a completely practical sessions and as we promised there will be like 8 to 10 sessions where we'll teach you from very start to the very end okay so along in this journey the S will be along with me as well so today probably I am taking on
• 04:00 - 04:30 maybe few sessions s will also take so he is also very senior folk okay thank you s for joining in uh here for uh sharing your knowledge at free of cost to all of these guys okay coming back to our agenda what is data so I mean we all talk about data data data Big Data database all these data so what exactly this data is all about so this
• 04:30 - 05:00 data I mean data could be anything any piece of information whatever piece of information you see around yourself could be a data so maybe your phone number your email ID your name your address uh the product name or maybe the item name maybe website name all this could be in itself a data so data is nothing but it is generally a piece of
• 05:00 - 05:30 information so now you can imagine how this data could be important because in this real world you represent everything in terms of some name some parameter some values so you need something to represent anything right even if you see any any object you see that it has some color it has some size it has some weight Okay so this data is involved
• 05:30 - 06:00 with each and every aspect of our life okay now this data is getting more and more important now because earlier I mean if we talk about 50 years back 50 years back there was no digitization right there was not much computers or I think a very small places where it could be a computer is there so everything people talks in terms of normally uh a plain language right they don't have to
• 06:00 - 06:30 store or get those information but now with this advancement and this entire digitization and this era of it Industries everything is now coming into the your machines coming into your laptop coming into your system whether it is your own information your photos your audios your videos everything is coming some somehow your entire life is
• 06:30 - 07:00 coming in form of a data into your machine or into the computers hence this data the importance of this data has been increased a lot okay so that's the one I mean one of the reason why data is popular because we are in the sea of a data right we are in the sea of data everywhere around us is data only so we need something to manage to hold to
• 07:00 - 07:30 understand this data in a well form so so far how you are storing the information maybe let's say for example if I talk you how you store your password you store probably in your mind maybe in your pen paper maybe somewhere in the computers or maybe in some notepad right this could be a find right because if this is a password it's a very small information you can keep it you talk about mobile number of your family
• 07:30 - 08:00 members so mostly you remember your family members phone numbers right again with this coming up so so many numbers and all nowadays those days are gone when you remember all the phone numbers right now you generally whenever now you have to remember or find any number you generally go to your contact list and you just type in your name and then you get the phone number right so long back when there was a small piece of
• 08:00 - 08:30 information people used to keep this information on pen paper in the mind all this could be fine maybe for example you are going for a a weekend shopping right for grocery shopping you generally used to keep everything into your pen paper you make a list okay or you maybe open up your phone number and you type in those numbers and those list items and then you go for the shopping and you you do this shopping so that is also one of
• 08:30 - 09:00 the way of storing this information but take a one one step ahead now okay one step ahead is like talk about the customers okay maybe you are owning a e-commerce website like amazon.com maybe flipcart.com so these websites has a millions of users okay there are millions of people who is every day logging into this website and and buying something so for all these people you
• 09:00 - 09:30 have to store what you have to remember their user ID you have to remember their passwords and Etc so all this information cannot be stored in plain notepad right it this information cannot be stored somewhere into the mind of the computer right you need to store this information in some logical and a proper manner so that you can manage it properly okay so these were the old days
• 09:30 - 10:00 where you keep the information in computers or something or maybe you open a notepad and you type in and store all this information but typing or keeping all this information in the your Microsoft Word or those notepad would be sufficient because retrieving would be a problem right imagine you have a notepad file which has a 10,000 lines written then finding a one number or one value in
• 10:00 - 10:30 that would be very difficult automatically right so you need some other solution every problem should have some solution right so this is one of the problem that you have a huge data you have these information needed to be stored but our traditional approaches long back approaches which people follow is not sufficient is not good to store all these information so these were the
• 10:30 - 11:00 like some of the problems which I talked about like you have a volumous papers you have documents and all so how you could solve all these problems so basically you can solve all your problems through nothing but a database so databases is one of the way to solve all your data related problem up to certain extent okay so now the question come in what the is this databases so I
• 11:00 - 11:30 I can understand many of you already have a some glams or some basic understanding about the database but still in the interest of each and everyone of the participant of this session I just try to keep the things at very low level in the start and then we slowly slowly move to the increase our level and move forward so what is this database so this database is basically
• 11:30 - 12:00 nothing but a collection of information okay when I say collection of information it means this if you remember at the start what we said at the start we said the data is nothing but a piece of an information right so indirectly this database is nothing but it is a collection of this data itself so in the databases generally what you try to do is you try to keep all your relevant information okay few example of
• 12:00 - 12:30 databases could be I say that I have a database on employees it means that probably I'm storing all the employee information their IDs their name address email ID emergency contact number all those information about employees it could be when they are coming their attendance their salary Etc it could be a database could be an example could be of the sales order right and you are
• 12:30 - 13:00 having an e-commerce website so how many sales you are generating how many orders has been generated throughout a day you are maintaining all them who has generated this order who is the user of this order how much amount he is paid so Etc so all these information generally you try to keep in some logical Manner and this is nothing but a entirely collectively all these piece of information you store and you call it as
• 13:00 - 13:30 a database okay so these are some of the basic examples of the database like employee sales product or your transactions okay now we understand database is fine okay now but there are basically two types of a data that is a very uh popular nowadays earlier long back if I talk about um almost 15 years ago okay
• 13:30 - 14:00 almost 15 years ago somewhere around 2 2005 okay up to that there was majorly only one type of database was available that was the relational SQL relational or SQL databases we'll come back to this like why is this relation and all and another one was non- relational and no SQL databases okay but after this 2005
• 14:00 - 14:30 there has been another database start coming into the picture and lot of people and lot of company has started working on this no SQL databases as well okay so we'll come back to all these two discussion so let's go down in each of them and then let's understand what is this SQL database and what is this no SQL database so SQL database is also called as relation database so what is this
• 14:30 - 15:00 relational database I mean why we call it as a relational okay first of all majority of you I still assume that understand at a very high level that database is nothing but database is the collection of your tables okay you have some table which you stored in the database even if you don't know if you have not seen database anytime in your life it's completely completely fine
• 15:00 - 15:30 okay so database is collection of tables so you say I have a 10 tables or 20 tables or a 100 tables now what this table is table in itself is nothing but table is a combination of your rows and columns so let's say for example if I say this if you have probably most of you have seen this Excel this Excel is a kind of look like you are kind of a
• 15:30 - 16:00 table where you have rows and every row will have a same number of column you see like this okay so let's say for example if I click say this employee okay if I say I have an employee table what does it means is when somebody says I have an table called employee it means that this table could have some employee ID it could have some employee name could have some
• 16:00 - 16:30 address it could have some phone number okay now to me this could be an example of a table okay now in my system or in my organization I have employee one whose name is deep whose address is India and phone number is something similarly I have another employee who has some another name who has again some address then
• 16:30 - 17:00 something then I have another employee who is from us and here has some number and then I have another employee I call as Mike and then I say Ny and some number so you can see that this in itself is nothing but an example of a table so basically I have this number of columns 1 2 3 4 so I will say that I I have these four columns okay and these
• 17:00 - 17:30 four columns is basically this is my column names and then I'll say that in this table I have four rows okay so this is basically a one table so in your database generally you have a multiple tables okay so and every table probably could look like this where every table will have some table name then every table could have
• 17:30 - 18:00 some attributes which you call it you call it column names you call it columns you call it attributes you call it properties whatever you want to call so basically all those information related related to that table is here in terms of the column names okay and when you create a row so basically this row is nothing but a a row which contains the information for all these properties so you can see that first row is
• 18:00 - 18:30 representing some employee ID some name some address some fold number so this is a called as a table in the relational World okay so this is a example of a table in your relational database similarly now I say okay now I'll say table two okay now table two is nothing but a employee salary table okay employee
• 18:30 - 19:00 salary okay now if I have another table which I call it as an employee salary table again what I do what I do here is designation some employee ID it has some designation it has and it say that I have some salary
• 19:00 - 19:30 and let's say this one so it has just three columns okay one sec so this employee salary T table name called employee salary has an another three columns employee ID designation and it has some salary so it I should write the designation as as PA
• 19:30 - 20:00 as fresher as I could say module lead and I will say manager okay and then salary could be some some numbers okay like this so now you see we have a as I said in the start in the database you could have a multiple tables okay or database is a collection of multiple tables so you have one table you have another table and now somehow
• 20:00 - 20:30 somehow if you think the table number one and table number two here both are related to each other right you should not do like you in database if you are creating a database for employee you are not going to in the employee you are going not going to store the cricket match information right you you keep the data which is relevant okay and which is something related to each other and that's what it called a relational
• 20:30 - 21:00 database okay because it has some relation among the multiple tables and each other okay so here if you see this this first table is talking about the employee information the second table is talking about the employee salary so these two tables indirectly is connected to each other because here if this is the salary we are talking about the salary of Deep if this is the salary we are talking about the salary of the
• 21:00 - 21:30 Rohit kind of right so they are interconnected with each other using this employee ID again this interconnection we will talk in very deep when we start our the SQL so I'm not going into this connectivity but just logically if you understand these two tables are connected and related so again in the uh database world uh we have this relational databases it means like this a normal database where you
• 21:30 - 22:00 have a multiple tables and these multiple tables are basically connected to each other in one or another way okay second most important thing about the relational database or the SQL database or a normal database is that it has a fixed schema okay when I say fixed schema okay now the fixed schema means
• 22:00 - 22:30 that every row every Row in this table specifically if you talk about the table one every row will have the same number of columns okay so first row will also have four columns second row will also have four column third row also have four column fourth row also have four columns similarly if you talk about the second table it also has a fixed schema it means every row will have the same number of column that is three columns not just same number of
• 22:30 - 23:00 columns but also the same type of columns when I say same type of columns it means if if for my first table for my first row if this phone number is a numeric then for my second row also the phone number should be numeric it should not be like that I could go and I store like this right so it has same number of
• 23:00 - 23:30 column also in the same type as well type in the sense data type we'll talk about data type in detail but imagine if it is a number or whether it is a character or how this data is defined or it is a time stamp which is where you are storing the date time so for every row your number of column is same for every Row the the type of column is also same okay so that's why this is called as a fixed schema so generally schema is
• 23:30 - 24:00 nothing but you called it as this structure of any uh table so schema here is structure of the table it means that in the schema you just say that this is table name and that could be this four uh type of four column and each column will be name would be this and their type would be this so this is like a template so every row will follow follow a fixed template that every row will
• 24:00 - 24:30 have these four columns every column name would be this only and data type also this only so that's how you define a tables in the uh your relational database or your sequels database where you have the fixed schema and secondly you keep the information in the SQL databases in terms of rows and columns inside the tables okay coming back to our discussion so we have in relation
• 24:30 - 25:00 database we have fixed schema we have rows columns and we have tables now what could be the example of these databases the example of these databases could be is like you must have heard of Oracle MySQL my SQL Server post Grace db2 so there are many many databases so what what happened is exactly this database data was a problem okay
• 25:00 - 25:30 data was a big problem to solve this problem they understand that database is needed now when database is needed so this big companies what this big company has done is they started creating their own product okay so all this is nothing but a database softwares okay Oracle is a database dbms software people also call it as a uh dbms software okay dbms that is nothing but a
• 25:30 - 26:00 database management system okay so these are dbms softwares in then you manage the data I mean basically when you store the data all good all looks good okay we create a table we'll store all this information our problem is solved no it does not happen like this when you create need a database you need few other things as well right
• 26:00 - 26:30 later on you might need okay in my company there are 100 employees okay in if 100 employees there I don't want to give an access to each and everyone right if I give an access to this database to everyone then people will go and change the database everyone can change the database everyone can go and um get the sensitive information out of this database right what they can do is they can fatch uh the password from this database or
• 26:30 - 27:00 maybe someone's salary and then they can distribute it somewhere uh this information outside so there could be a crucial information might be residing in your database which you don't want to um share with anyone so you need the security okay so you need later on when your sizes grows you need lot of performance optimization that okay I my table is there and now in this table I have stored the 1 million rows okay
• 27:00 - 27:30 because my website got hit it is one of the most popular website in on the planet so now what happens your database will start responding very very slow so you need something which will manage it so there are so many other aspects which is needed for managing this entire uh entire this data so you need some software which do all this and those software is called as dbms softare or database Management Systems okay and all
• 27:30 - 28:00 these Oracle MySQL MySQL server are kind of an example of all these dbms softwares okay so basically these are the actual softwares and in this software you create your database so inside this you probably create your employee database or your order database like that okay so now why we have these so many of them
• 28:00 - 28:30 so it's a world right it's a world where everybody want to earn so what happened is like initially someone somebody started this is the concept so let's say for example Oracle started so Oracle developed one software they call it as Oracle database management system okay so Oracle DB they started now looking at the Oracle success what somebody else has done is they have created their own software so they they call it as let's say my SQL or postgress or or Microsoft
• 28:30 - 29:00 also got jump into this uh stream and they created their own software which they called it as SQL Server okay so different organization just for earning created their own product okay and that's why you see that there are multiple database you see but still there are not 1020 more than that I I as far as I am aware of so these are the basic popular one all this is basically an individual in
• 29:00 - 29:30 itself and it is owned by someone okay so it is a licensed product of some company okay initially I mean like my SQL was free this was long back was free okay now recently this has been uh uh taken over by the Oracle so now probably this will also go into the uh the licensing mode where people has to pay something to use this soft Ware so there are some licensing version as well so
• 29:30 - 30:00 but for you it's fine for our practice perpose or for non-commercial purpose there are a lot of databases which is come free you can go learn it and then when somebody is using these for some production or some commercial purpose then only they have to take or buy the license and use it it is just like your um Windows license like if you are genuine window user probably you have to take a license similarly if you want to be a genuine dbms U um developer or DMS
• 30:00 - 30:30 user if you so probably you need to have the licensing so these are the licensing but it's fine for us learning the concept is important because costing and Licensing part will be automatically taken care by your clients or your uh organization or your company okay so these are the one and in this entire series we will concent conate on this Ms SQL Server so we will see all our
• 30:30 - 31:00 practice and we do all our practice on this Microsoft SQL Server I hopefully going forward I mean in today's session itself I'll go and install the SQL Server so we will see all this installation in all and then from Tomorrow onwards we'll start writing our SQL queries on this SQL Server okay now why I have chosen the SQL Server first for your practice it is freely available second this is one of the most popularly
• 31:00 - 31:30 used database as far as uh your ETL on all those data data engineering and all those involveed there it is one of the most commonly used server now again there also one aspect that all these databases which you see here are generally called as an on Prem database now what does it mean by on Prem DB which is also called as on
• 31:30 - 32:00 premises so on premises means you have your own company or you have your own U uh some startup something and for that startup you probably bought one server okay you have one laptop or one server or a one machine and there what you have done is you have go and manually install all this so you are the one who is taking care of this entirely so that is nothing but an on Prem database but now as we are into the world of the
• 32:00 - 32:30 cloud so people have started using the database on the cloud as well so all those Cloud providers so Cloud providers are like Microsoft Azure AWS or gcp that is Google Cloud platform so these are the three most popular cloud provider so these cloud provider what they do is they provide all these databases functionality in the cloud as well so when you get it into the cloud it
• 32:30 - 33:00 means that you don't have to go and uh take care of your database on your own like you don't need to go and uh put your updates you don't have to update your database you don't have to install the patches you don't have to check that whether it is um networking is connected properly or not whether it is up and running or not so all this will now all this basic responsibility will go into the hands of the cloud provider or or your azzure or your AWS or your Google
• 33:00 - 33:30 cloud and you just go there and you get the database in to the cloud and all your data probably now you can store into the cloud using this Cloud databases so that is also one of the option that you can have all this data get stored into the cloud database okay but whether you work in the normal database whether you work in the cloud database there is not much difference okay it is not something that uh you
• 33:30 - 34:00 have to explicitly learn there are few aspect of the cloud anyways we'll try to cover it towards the end of this entire Journey but again all the way you write the query in your normal on print database or the way you have to write the query in your uh Cloud database exactly same there is no difference in writing the SQL for your cloud or whether for your on Prem in majority of your cases 95% of the times it is almost same okay so you don't have to worry
• 34:00 - 34:30 about it okay but again the intent of taking this entire SQL session was that this SQL is very very important if you are planning to make your career into Data engineering and data science world so if you want to become a data engineer or you want to become a data scientist then SQL is very important because or even if you want to data analyst or business analy like that as well then also this SQL is very important why
• 34:30 - 35:00 because end of the day you have to play with data right and if you have to play with data then this SQL is the one of the best way through which you can play with this data you can manage this data you can analyze this data so SQL is very important for this perspec even even SQL is also important not for this whether you are a Android developer whether you are a iPhone developer whether you are
• 35:00 - 35:30 a web developer or whether you are a front end developer whatever you do still database involved because end of the day if you see you go to the you just check this I mean like this is your website right you are a web developer you created this website in this website somebody enter the username somebody enter the password and he is signing up what you have to do you have to go to database and you have to store this information right into the DB or maybe when somebody tried to log
• 35:30 - 36:00 in in and he enter his username and his password then you have to go to database you have to check whether this user username password is correct or not and then you have to take it to the home screen or the again login page Etc So eventually whatever the role you have to play somehow you have to touch to database and you need to understand like how you can talk to this database okay so how you can talk to this database the way to talk to this database is nothing
• 36:00 - 36:30 but is the way to touch or to talk to this database so in this entire course we will talk about how you can talk to database and how you can work with this database using this SQL okay now this was all about the relational database now let's quickly cover the our no SQL database what this nosql database is all about so no SQL database um okay now first why the hell
• 36:30 - 37:00 we need the no SQL when we talk so good about the SQL database so far then why somebody will go and use a no SQL databases so basically SQL database also has its own problem okay although this solve majority of the problem but the speed with which we are generating the data and the speed with which there is innovation is happening around you need to upgrade okay and you
• 37:00 - 37:30 need something which is not already there which could solve a new problem okay so I'll tell you what are the new problems first as everything is going going digitalized so the the amount of a data generating is so huge okay and when amount of a data which is generating is so huge so after a certain point of time your database which is your relational database whether it is your Oracle
• 37:30 - 38:00 whether it is db2 whether it is your SQL Server whatever database you say after a certain point of time this database start responding very slow okay if your data size is too large let's say for example if you are storing millions of rows if you are storing billions of rows in your tables then whatever performance optimization you do whatever still it will respond very slow so to handling a huge amount of a data in
• 38:00 - 38:30 general whenever you have a huge amount of a data and you need a very good speed then your database does not perform well okay then the answer to them would be the no SQL so the biggest reason of this uh the no SQL arrival was nothing but the huge amount of a data so when you have a huge amount of a data which you want to store and you want to search and get it back so there the no SQL database is the one which go
• 38:30 - 39:00 you can go and use it now what is the difference why we call it as no SQL the reason of calling this is a no SQL is that here data size is huge and we are not generally storing the data in this plain format of row and column where we say that it has a fixed schema every row will have a same number of rows uh every row will have a same number of column and data type Etc so no SQL
• 39:00 - 39:30 database does not have in general a fixed schema in general okay it could be key value so it store the data like this U it stores simply data is equal to name is equal to Deepa okay address is equal to India like that so some some databases which store the data in terms of a key value example
• 39:30 - 40:00 let's say could be is your hbas so hbas is also one of the no SQL database example some databases no no SQL databases used to store the data not in terms of a rows and column but in terms of a Json format XML format so Json format how the Json format is if you probably have seen any Json format Json format look like this where you have C Braes then you have some property and then property
• 40:00 - 40:30 value okay like this then you have some address again you store like this then you put some address and this so this is like a normal a Json format where you use a cly braces and in that you put on your properties so there are databases which directly store this information as it is into the as it is the Json object into the the database rather than putting it into the rows columns Etc so mongodb is
• 40:30 - 41:00 one of the database this database which is a no SQL database and it store the information in terms of the Json format entire Json object okay so now you might be thinking why the hell only the Json format because Json format is one of the most popular format it is um it is also used in all your iot applications I mean in general
• 41:00 - 41:30 all your iot devices in general generate your Json format data so this and all uh sorry to interrupt you just one thing I want to mention uh those if you have any kind of query in the audience side any kind of confusion question or doubt they can just put it in the comment box so that we can take up at the end of the session yeah and we will definitely have a 15 20 minutes of this session for this Q&A and as s has pointed
• 41:30 - 42:00 out probably we are not going to do this on the streaming so like when we started this session um I mean when we posted about this we got so many entries we got almost like 2,000 or 2,500 people got registered for this so we got no option we were like forced to use the um streaming option where everybody can join but we know that over a period of time people get reduced down and and only the people who is really interested
• 42:00 - 42:30 and they have they don't have any other commitments so they will be a part of it so hopefully I mean um as I I'm not sure I'm not looking at the number how many people who has joined this session today but I assume if it is lesser than 500 people so we can accommodate all those 500 people into a Google meet so hopefully for the next session onwards we'll share a Google meet link and so that the advantage of going on the Google meet is that you all can come
• 42:30 - 43:00 forward and ask and talk so here it is just like a monologue a oneway communication where I am only speaking and you are all just listening so the idea would be is like if you go to the Google meet then all of you can come forward and you can ask discuss all your doubts okay so hopefully I'm probably s is looking at the numbers I I don't have the numbers in my hand yeah we have around 425 plus people who is on the live yeah oh my God so it's still I think we
• 43:00 - 43:30 are still in a good shape of 500 people so if it is less than 500 people towards till the end we will definitely go into the Google meet mode or maybe like we'll do it this for one more day so let's all other people who didn't able to join today also get com in and then we go to the private mode so that all of you can speak that whole intention is this that you all can speak and trust me guys this is completely free okay we will not going to charge anything as we promised
• 43:30 - 44:00 for this entire 10th session all you will going to learn free okay so thank you let's coming back to this so another SQL database uh as we said so no SQL one was this Json as well now the third way of using nowadays is the graph database so another database it's a graph graph is basically it's more of a useful for uh social uh social media kind of stuff so
• 44:00 - 44:30 what happens in these graph databases like you know you all you are a LinkedIn user right so on LinkedIn what happens whenever you connect to someone you see that you have a first level of connection Okay then if you see someone else you see this is the second level of connection so what is this connection so you have some friend and this one this is the your friend's friend so this is second connection second level and sometimes you could have a third level as well right your friends friends
• 44:30 - 45:00 friends connection so in this connection mechanism as well so this is the graph kind of database so in some of the uh good use case for this graph database is basically a kind of a social media kind of a websites or social networking websites or who is managing all this connection followers all these things so probably this kind of a database is also good for them here it it is easy to find easy to and all this is very fast so
• 45:00 - 45:30 another stream of database is coming which is called as a graph database okay so all the databases which is not a relational or a SQL database comes into a common list which we call it as a no SQL database so no SQL database could be in the form of graphs like this it could be in the form of a Json object like this it could be into the key value like this or it could be some other document form format so any database which is not
• 45:30 - 46:00 following the fixed schema row column format then that database is called as in general a no SQL database okay still no SQL database manages all those huge amount of a data but whenever you have to manage the transactional information Etc the best choice is still the your SQL database and that's why the SQL database is still very very relevant okay even I would say majority of the
• 46:00 - 46:30 application is using the SQL database only because everybody is not running a a website like Amazon or not running a website like LinkedIn or Facebook who is a huge amount of for data to maintain okay so mostly applications are using the SQL database and that's why learning the SQL is very important okay so these entire sessions will be around the SQL databases and we'll talk about the SQL one okay now this could be okay so now let's
• 46:30 - 47:00 we quickly we almost towards the end of our timing so what I'll do is now I'm quickly taking you to the database uh on my machine where we go and install the database so that for the next session onwards we are ready for our practical part so let's quickly go down and see how you can install the database on your system okay so I coming to my machine okay so
• 47:00 - 47:30 we are going to use the SQL Server okay for this entire course so what you have to do is you have to go and install the SQL Server I already have search it for you so but anyways you can always do Google okay or you go to the Google you search for SQL Server Express download so this is a SQL Server Express Edition which we go and download go to this Microsoft website it is
• 47:30 - 48:00 completely free so you don't have to worry about just check this option SQL server on premises here you see this Express download so we just go down and download this this download setup is take little while but again the good thing okay so good thing with the Microsoft is that in the micro Microsoft everything is Click Click next so that's the best
• 48:00 - 48:30 part of any Microsoft product so like this also you don't have to do anything once you install this exe you have to just go ahead and click next next next it will take a while it's a little heavy software so I am doing this on a a very highs speeded connection so probably this why that's why it's downloaded very fast otherwise it will take you some time on your machine if your connection is not that fast okay so in any
• 48:30 - 49:00 databases generally two things comes one is the your database software and second thing comes is a a UI which you call a GUI graphical user interface through which you interact with this database so database once you install the database server so we are trying to installing a database server or a SQL Server okay so once you install the server you can write the command just
• 49:00 - 49:30 like your command go to command Pro like the command and you can manage your database by writing this commands kind of thing or using this command way to write your SQL queries another good way is you can use the UI or GUI which you call graphical user interface which helps you to manage this database in a more easier manner or a more developer friendly manner so what we're going to do is once we install this SQL Server there is a software called as
• 49:30 - 50:00 ssms so I'll repeat that is called as uh ssms so SS SMS so SS SMS is nothing but a SQL Server management studio so what do SQL Server management Studio do is this SQL Server management studio is connect to this SQL Server which we are installing and using this SS SMS software you can easily manage your tables your rows
• 50:00 - 50:30 columns Etc whatever you want to do you will love to do it because this is a very userfriendly software okay so first we install a server and then we will install this uh a way or um you call it a GUI to manage this so you can see that our SQL Server is installing it will take a while so I think while it takes some time meanwhile s if somebody's posting on us some questions and if you are seeing that please uh uh let's start
• 50:30 - 51:00 taking few questions so guys meanwhile it is starting let it get installed it take U three four more minutes and then probably uh another SS SMS will take two three more minutes so we have almost 5 seven minutes so meanwhile uh we'll take up a question so if you have any questions please come forward and ask all your doubts so S I hope you have a watch on the chat because yes so any question which you want to take
• 51:00 - 51:30 please yeah so few people few people asked about the what database we are going to use and you already mentioned about Microsoft SQL Server so you can just throw some light onto it as well yeah so SQL Server is one of the database uh as I said at the start that we have a multiple databases uh software available it could be my SQL it could be Oracle it could be SQL server or it
• 51:30 - 52:00 could be someone else so anyways we have to pick any one of them okay second thing almost 95% of the times the query which you write whether in the SQL Server whether in the db2 whether in the uh your MySQL almost same small thing here and there is a difference okay so but as I said we are building you for the next level which is a data engineering or a data science level so there generally in
• 52:00 - 52:30 majority of the applications uh where we talk about the production based application their SQL Server is one of the most used U database so we want to prepare you over the SQL Server directly rather than we start with the MySQL which is not that popular in terms of the uh the production based application so we started with the SQL Server only okay and yeah just uh one thing guys we got our
• 52:30 - 53:00 SQL got installed and then here you see option install ssms so SS SMS as I said is for managing your database so let's quickly and download it so you got click on that you get download SM SMS so this will take you to download I click on this download it is just like a 700 MB software so it got downloaded quickly now and then uh almost we are done with the download and
• 53:00 - 53:30 as soon as it get downloaded let me quickly install this and then we'll come back to the question again so this is again available now so we open it up so okay so this is our ssms and I'm just clicking on install so this will get installed yeah so so coming back to the question of SQL Server so when you write
• 53:30 - 54:00 the query into the SQL Server it is called as tsql okay so that is transact SQL so generally that is called as tsql okay so we'll learn the SQL and tsql both okay so that is the intention of this using the SQL Server that because when you probably go and move to the cloud like Azure and most of the organization who is moving from their existing ATL to the cloud Etc probably SQL Server would be one of their data
• 54:00 - 54:30 sources so if you know the SQL Server it will be a best to know I mean so that's why we picked and we zero down on this using the SQL server for this uh entire Series so hope I have answered this question s yeah adding to the what de has mentioned so it's like you know uh when you know how to drive a vehicle you can drive any kind of vehicle right you don't need no you you don't worry about
• 54:30 - 55:00 which vehicle you are driving the same is the case with the SQL so if you know SQL uh what is SQL or how how you run queries you can run it on any database software be it orle my SQL or the db2 or any other database software we talk about uh coming in addition to the same context uh people have people are asking about what is my SQL or Oracle or db2
• 55:00 - 55:30 they talking about the Hardo as well okay so I I think s you can answer on this my SQL and all everything I hope okay so you want to take it or should I uh you can take it so so the as I said this MySQL and this db2 or this Oracle all this are again the same software or data software or dbms system my SQL is owned by someone else
• 55:30 - 56:00 Oracle is owned by someone else db2 is owned by IBM Etc so every company like they want to push their own product end of the day I am giving only the database solution right so for example let's say there's a bike so bike would be prepared by a Hondas bike will be by the someone else or maybe you talk about a car like maruti Toyota or some different brands so every brand go forward and devop their product right but end of the day they are giving you what so they so all
• 56:00 - 56:30 this whether you use a MySQL Oracle db2 Etc all this is nothing but a still dbms softwares which will help you to give you the database management system okay so end of the day all this is giving you almost some Serv same service some uh software could have something extra on its own but end of the day you will use any one of them for man managing your data which one you pick based on their prices other cost and other uh
• 56:30 - 57:00 flexibility you will pick it based on your choice but you will get the same thing if you talk about the Hadoop Hadoop is not the database management system I repeat Hadoop is not the dbms software okay Hado is something uh a framework which runs on a distributed computing for managing or for analytical purpose okay it is not for a database management system so Hado is not a part of this category even spark and all this is not a database at all
• 57:00 - 57:30 okay so our SS SMS is installed I've not done any magical thing here I just downloaded and say quick quick next and it done so now you just type in SS SMS and there you see that Microsoft SQL Server management Studio got installed I just click on open and that will open up the SQL Server management studio for me where I'll manage all my databases okay so let let it get just
• 57:30 - 58:00 open up and then we create for today we just create one small table and in it and see so any other question meanwhile so the next question is in in our presentation we mentioned the collection of transaction as a as a basic Bally a database right so yes
• 58:00 - 58:30 somebody's asking about the same like how the transaction or collection of transaction is a databas so so collection of transaction when our intent of putting that is was like when you do transaction I mean let's say for example we talk about the banking so you you transferred some amount to someone so that is one transaction right somebody again transfer some to someone else so that is another transaction so so lot of transactions happens okay so sometimes you want to keep all those
• 58:30 - 59:00 transactions so that is also a kind of a database for transaction don't don't get it confused with the transaction of a database I mean I I got why this question is coming in there are transaction in database as well and might be people are uh thinking this transaction with that transaction so here transaction we are talking about the money transactions okay so it is not dat is it is like a transaction attribute so when you do transaction
• 59:00 - 59:30 like sending payment from one account to another account you need a payment ID you need a receivers account you need a senders account at what time the payment or the transaction happen and the amount uh for which you are transacting so all these attributes comes are the attributes of the transaction and when you have number of such transaction or such payments we call it a transaction data right okay great so uh I I think we should
• 59:30 - 60:00 have used the word collection of money transaction instead of just a transaction to avoid this confusion right a good learning okay so again coming back to this SQL Server uh so our SQL Server is ready and I am opening up SS SMS and it is asking me of authen authentication I'm just doing it for locally so without getting into any kind of complexity just see this option Windows authentication just click
• 60:00 - 60:30 connect and this will connect you to your database that's it so here on the on the left hand side you see this object Explorer in this and this is your databases so when you just uh expand this databases you see the system databases so you see these are a four databases which is already there okay so this is a default database which comes in so it is possible that I
• 60:30 - 61:00 mean you create a multiple databases okay so this probably let's say for example you have a one project okay that project is selling the product like e-commerce website so you could have a multiple databases for it in one database you are managing customer information in another database you're managing the order information another database you are maintaining your marketing or sales information like that so you could have a multiple databases as well and this database basically
• 61:00 - 61:30 contains the tables so every database will contain some tables okay so by default uh this is a coming automatically so it has some system tables you can see okay so these are some system tables so what you can do is you can go ahead and we create our first table so without going anything you just do right click new so either you can go ahead and you can write the queries so that is the one another Advantage you can go down and you can go and create a right queries or
• 61:30 - 62:00 you can come down on this database go to this tables or you can write click on it and you say table so there are two ways in which you can create the table one is writing a query another one is using this graphical user interface so for this just now we went talked about the uh queries at all so I'm not touching it I'm just creating a simple table using this UI so you get this table you give the table name so let's say I give employee
• 62:00 - 62:30 ID employee ID you give the type how this employ look like so this employed look like nothing but a generally an integer one right so I just go down and check some integer okay I'll pick it as small end then I I give let's say name employee name and this is nothing but a we talk about this all this data type which is coming in just for a by default just assume Nar okay and this is done so our
• 62:30 - 63:00 table we give the two column names here and we say table is let's say employee and I say okay and this will create our table so if you just click on this refresh here so now you start seeing the table this is DB employee you right click it so far there is nothing in the table so you click add it so you will see window like this where you start putting your
• 63:00 - 63:30 information then I go to the second row there I'll type two then I say RIT all done you say save okay so you have entered the two row now just you go to the table and just say select and you will probably see those two rows which we have inserted I think second one I have not saved it so I got my row insert so that's how we can create the table and we can insert some
• 63:30 - 64:00 rows a basic setup I don't want to get into this create table now because tomorrow when we'll start again then uh we will see through queries only how you can go create tables how you can use different data types Etc so we'll see all those deep down and trust me guys we try to cover all those things which is important for being as a SQL Developer or being as a someone who knows a SQL practi or being a SQL practitioner so
• 64:00 - 64:30 today session was only the session I feel was of a PP one most of rest of the session probably will focus on this screen where we come here we type all those queries and we'll teach you from here only okay so that's all I have for today's session guys I'm still here for next 15 minutes so all whatever the queries questions you have you can go and ask and one more thing for the
• 64:30 - 65:00 second day also uh I mean for the second session link uh again guys you are getting an email okay there are two ways so I just quickly show you what are the two different ways to go down one way is you can go to this portal uh which is uh nothing but my portal I think you all of have been registered to if not please go ahead and register it so this was the one this starting uh one azure.com so
• 65:00 - 65:30 there you can see the recording as well okay so this was the starting URL if you have not already registered go down and register so let me just quickly show you how you can go register so you can just put in your name and email ID whatever is your email ID just put down and you will register it once you registered you get in one email okay that email will take you to the account of this fresh learn account okay so let's say for example
• 65:30 - 66:00 uh I'll see this account I'll just log to this account and show you okay so there you go you see once you log into this account you see this SQL class I'm I'm unrolled to one another product here which is my data
• 66:00 - 66:30 engineering class so you will see the SQL class when and once you go down here itself you see the live link so you can directly click on this live here and this will take you to the live link or you go down okay you see the just refresh it okay so you can go down and see the live
• 66:30 - 67:00 streaming from here and here itself I'll put down the recording as well secondly now you are just seeing the one link because this is session one maybe uh in next after a few hours you will see here the second link as well available for the second session so you can come down here and from here itself you can go and check out the session two link okay and when even we go for the Google meet or something like that so there also you will see all the recording here so your One Stop solution for getting all this will be here so we are going to give you
• 67:00 - 67:30 the recordings as well so recording will be there for you guys uh up to certain uh period of time so you can come down if you miss the class by any chance you can come down here and you can go to this course and you can see all those recordings as well okay so that will also be available to you okay again all this will be free there will be no cost for this okay but as I said if if when you start giving the things free people start not uh giving respect to it so
• 67:30 - 68:00 please respect this guys we are putting lot of lot of effort on doing all this we are taking out our own time preparing all this and sharing all this information for almost zero cost so please guys please uh do respect it and use it in a well manner I mean try to join if you're liking all this sessions please go ahead and uh recommend us uh onto the LinkedIn on various of the platforms and share it with lot of other
• 68:00 - 68:30 folks in your group so that everyone can get benefited our intent is to benefit all right so it is not just so you just don't benefit yourself benefit your colleagues as well and one last thing uh I have is like guys if you think that uh we are doing good and you're liking all our work and in case you want to donate something uh for this good cause you we are open for donations as well there is no uh uh no restriction that you have to
• 68:30 - 69:00 donate or you have to pay something but if you feel that if you're liking all our work and if you want to donate something this are all our details you can directly Google pay on this number if you are doing somewhere from outside the country outside the India you can do the PayPal on this number or else if you not comfortable in doing in Google pay what you can do is you can use this uh net banking or all these detail you can ask us you can just email down this and
• 69:00 - 69:30 we will share you our account details so where you can go and donate it whatever amount there is no restriction even from a $1 to like $100 or ,000 whatever you like or a one rupee to th000 rupees whatever whatever you want to feel like you are getting something we are open for donation and everything is uh like welcome so up to you guys I mean this way you can donate as well so you got the links um and second another thing is you also getting an email so the email
• 69:30 - 70:00 ID probably is azure live blog gmail.com or maybe sorry deep. gooy at teer anytime.com so just keep an eye on the email as well so you should get an email as well uh I'll just show you the email also that you can give it if it is coming to your spam folder or your promotional folder please mark it as an important so that you can get the meeting invites via email as well how you can do that so probably I
• 70:00 - 70:30 think this one so here you you get the meeting uh uh link as well on the email you will something like SQL live class join now this is like Session One similarly you might have got an uh email for the session two as well okay so what you have to do is this email is probably coming from uh our email system system this you will see address like admin a.com so you can mark this down email as
• 70:30 - 71:00 a non-spam or imported one so that all this email will start Landing up on your uh the main folders okay and there you get a link and you can just go down and you directly get the get to the meeting as well so there are multiple ways you get an email as well if you want to see the recording go to the Azure lib account where you see all the recordings and session links and I mean you can join because soon I mean if we have a a less than 500 people number probably we
• 71:00 - 71:30 tomorrow or I mean not tomorrow maybe day after tomorrow we'll be move to the Google meet so that we all can talk as well because on chatting we lose a lot of questions so I want you people also talk and share uh your questions and queries so up to you guys uh I'm open for questions now so please ask all your questions and under the chat and we try to answer all of them as much as weekend so S I hope you are reading all those question please and
• 71:30 - 72:00 start okay so somebody asked about so let's go for the technical questions first and then we will move to the questions related to this whole uh sessions or the Journey of this course yeah okay so first question is like uh somebody asked about the schema in high level what is schema Okay so uh s you want to answer this okay let me this so uh you all know
• 72:00 - 72:30 that you know whenever we ask about the data let's say as deep mentioned about the employees data okay so when we have an employee data you have a employee name you have a employee salary you have employee performance you have employee Department okay and if I ask you what are the details of the employee what you will do you may write in one line you may write in table format or somebody will post it in different different
• 72:30 - 73:00 forms so to collect all this information you need some sort of a structure right so that structure is basically a schema so if we talk about the structure of the employee database or the information related to the employee there must be some column that is employee ID or your employee code that employee code has some sort of a data type let's say it's in integer similarly you have employee name that employee name is in string format or let's say it's in the Vare
• 73:00 - 73:30 format okay in the same way you have a salary it could be float right or a double in mssql server so in the same way you need a structure it's a meta data to your database right so I hope this yeah so just to add I mean like your schema is nothing but your template okay so it's just like a template where you define the uh name of your columns types of your columns Etc so you could call it as a schema of this table okay
• 73:30 - 74:00 yeah how this and sort of any other questions please take those questions where people have some uh challenges on finding the recording or links or anything that they should not miss the second session that's the intention okay so yeah coming to that as the already mentioned where you will get the link of the next session so so I repeat you get an email as well just check your email if you registered
• 74:00 - 74:30 with the correct email second you already have an Azure lib account where you have registered and even if you have not registered it so far go to the website which is like nothing but uh I'll just type in here again s you can also put on the chat as well yeah SQL class. azure.com so this is the website you go down to this website register yourself you get an email log to the
• 74:30 - 75:00 account that is a you get an email after that from some fresh learn something or fresh LMS something you log to that account and there you see all the recordings and the link for the next session as well so check directly either a mail or check this account where you can get the link okay so these are the two ways through which you can get the link for the next session so don't miss that I mean if you uh committed to learn something please follow because we are
• 75:00 - 75:30 also putting lot of lot of effort in doing all this okay so yeah so I think tomorrow I am not available due to some personal reasons so probably s can we have a quick poll should we do it day after tomorrow or if tomorrow is there then s has to take up the session so s we need to take a call like are we doing you will be able to manage your time for tomorrow because I'm not
• 75:30 - 76:00 available okay so so the thing is uh lot of people are having trouble with the SQL Server installation or ssmis installation or lot of questions related to they are not able to install it on Mac or is Mac support the mssql or ssmis so these are the uh the installation part and the basic uh create query or what is SQL that I can cover as we plan in our whole course so that we can take
• 76:00 - 76:30 sure sure so that that will be completely fine SAR so yeah so next question related to the course is what is the duration of this course so as I mentioned as the at the start we have mentioned around it it's almost uh 8 to 10 sessions which we are planning based on our speed so and based on all your understanding if you guys are smart enough and you understand quickly probably we'll be end
• 76:30 - 77:00 up in eight sessions if in case we feel that we have to go slow and probably then we extend it up to 10 session see idea is to cover all the concept whether all this concept get covered in the E session or a 10 session or a 12 session we are fine our whole goal is to make you the SQL ready that is the whole intent number of session is it's fine even putting two extra session for us is
• 77:00 - 77:30 not a big deal I mean if you are doing eight session making 10 is not a problem or if you're doing 10 making 12 is not a problem if you are on a journey or if you are on a goal to teach you then we are fully committed to do this so don't worry about it I think on the SQL the website that SQL class. aure li.com already uh the entire curriculum is out there what we are trying to cover in this entire Series so we will cover that
• 77:30 - 78:00 perfectly so whether it will take 10 or 12 or 15 session don't worry about it worry about what are the things get covered so that course you go down and you will find here on this link so just check out this link and you will be able to check it okay yes and whatever the the topics that we are going to cover in this 10 or whatever the time it take so in this session that will be more aligned to the realtime projects or real world project so every topic is has some
• 78:00 - 78:30 importance in the project right so it is completely aligned with the real world project next question de is about timings so uh timing is again the same like today's timing 8:15 I 8:15 a.m. IST Indian Standard Time so it's like morning for all the Indian folks and correspondingly who to all our audience who is uh watching is this from outside the uh India so just align to this time
• 78:30 - 79:00 zone of 8:15 a.m. okay that will be our start time 8:15 a.m. ISD so that is the time we will go every day uh our plan is going for uh all those four days probably Tuesday Wednesday Thursday and Friday and hopefully if everybody agree on that then probably Saturday as well okay so then five
• 79:00 - 79:30 session this week five session next week probably you will be ready for SQL by next week and so that's the idea we cover the five session this week five session next week and we should be done with all this again I repeat you might be thinking why repeating but in today's world it's difficult to trust all these five 10 session would be free and we will doing completely it is not just a master class or a workshop to just
• 79:30 - 80:00 showing you one Glimpse and then we'll say buy something or do something nothing completely end to endend free sequel sessions guys so that's why I say if you like this Mission you we are open for donations here you can go and donate any amount is fine I mean we respect and it's for us even a getting a one rupee or a $1 is an appreciation that somebody is respecting and uh acknowledging our
• 80:00 - 80:30 effort towards the community so please do that even one rupe even if you do one rupe it's good guys do it I mean it shows that you are also commited we and you respecting our commitment so do it guys I mean even a one rupee it will not make any change in your life it not make change any anything monetarily in our life but it is just a token of respect guys okay and the next question is are
• 80:30 - 81:00 we going to cover SQL St procedures so I will answer onto it yes we are going to cover SQL St procedures plsql we are going to have few session on it and there are people who have want to go through the whole whole course they can just go to SQL life. a.com I I I'm sorry to to conct SQL class. azure.com so that is the website
• 81:00 - 81:30 I repeat sqlcl class. azure.com s will also put this under the chat so everybody can look it and even uh we will put this link under the description as well uh this video description as well so you will get that from the video description as well sqlcl class. azure.com yeah goad next about question is about the recordings so this is one of the famous
• 81:30 - 82:00 question like a lot of people ask us that whether they are going to get the recordings or not uh recordings so recording will definitely be there uh as I said we you have to go to the account that uh you can create on the SQL class. a.com there you get an account and there you can store all that and people are so kind to us s i mean i it's my privilege to say that we started getting some donations
• 82:00 - 82:30 so I think Pradip has donated something then Rakesh has donated so people are acknowledging thank you so much guys thank you thank you so much I mean it's not about the money see we could have put on the uh say $100 or 100 rupees or 500 rupees course and then we can easily sell it right it's not we are doing free and even if you give something it looks like you're acknowledging I mean it's important I mean that you you
• 82:30 - 83:00 acknowledging that we are doing something great and it feels end of the day good to us that okay somebody is I mean we are doing this putting so much effort doing all this free and people are at least recognizing it thank you so much guys thank you yeah and the next question is are we going to cover CTS and subqueries yes s we are going to cover this these are important topics in SQL we are going to cover yeah uh next question is about
• 83:00 - 83:30 certification deer I believe you hate it but yes people asking about certifications so uh I think in the SQL certification is fine I mean guys SQL certification probably you should not I mean I am against the certifications so probably you should not go and Target the certification at least on the SQL side because I don't want you guys to be just a SQL Developer trust me I want you
• 83:30 - 84:00 guys to take up a new technology which is coming in like data science data engineering devops so build if you are on a journey to upskilling yourself and if you have committed to do something good in your life with your career don't just stop at the SQL please I request don't just stop at the SQL learn one level about SQL is good SQL is the your stepping stone for your next step which
• 84:00 - 84:30 is like your data engineering or data science scientist so please guys learn this and Target some certification on the data engineering on the or on the data science side not just on this side make your profile a good enough or a a one which is most of the recruiters are looking for so if you come into that range your package would be very high I mean you will be in a in a in a zone of a people who is having a latest
• 84:30 - 85:00 knowledge you might be become a feature ready and then there will be a lot of demand for you guys so please please please don't stop at SQL please upgrade yourself from SQL to data engineering or data scientist and make a exciting and a very rewarding career guys so please again whoever is asking for the certification I would recommend certification for this uh data engineering or data science level not just only at the SQL level okay that's
• 85:00 - 85:30 my suggestion I mean I want to see you guys to grow to a big uh Heights that's my whole intention is so next question is why are we using on Prem SQL Server rather than Azure SQL Cloud so yes yeah so see uh again uh I answer this question s the problem with the Azure SQL server or the cloud SQL Server is that for that you need to make a one cloud account and that cloud
• 85:30 - 86:00 account is uh having a free trial for just a one month so maybe after a month or so you want to go ahead and you want to try uh everything on your own then you have to start paying it if you install everything on your machine it will be completely free okay so that's the intention but um whoever ask this question please I would request add this uh into our syllabus that we will going to cover the cloud database as well so
• 86:00 - 86:30 towards the end of the sessions uh end of this series what we'll do is we'll have a one session around where I will go and install all this databases and whatever tables we create we probably take it to the cloud as well and to all our audience we'll show that how this Cloud database works so we'll have a one session around it as well so again our whole goal is for your interest somebody has rightly pointed out we should include the cloud database as well so s
• 86:30 - 87:00 please uh so how how a non Tech background person can learn SQL or can make a career in data engineering or data science uh see non-tech background it's not that difficult um you start with the SQL okay and once you learn the SQL probably uh I think I to be to be honest this is
• 87:00 - 87:30 like when somebody's a non Tech I'm not sure how exactly his understanding level at this point of time but he if he has a basic computer understanding he learns SQL and then probably uh he would be ready to learn the data engineering so I and if somebody wanted to get into the data science I would say he has to know SQL plus python okay so the idea is pretty clear so if you know SQL plus
• 87:30 - 88:00 python you are almost ready for the data science okay if you are SQL ready if python then you can also do data science data engineering and even if you are only a SQL ready then also you are ready for to go with the data engineering okay so so yes it's not it's not like that it
• 88:00 - 88:30 impossible to move from non Tech to Tech or or data science or data engineering you can easily move but yes uh to be honest you need to put lot of efforts uh to you know basically do the migration uh next question is related to no SQL are we going to cover mod mongodb or no SQL in our this sessions guys uh for the no SQL databases uh Our intention is not to use it
• 88:30 - 89:00 because uh majority of the work comes around the SQL and uh even if we just touch base upon a nosql one it won't be sufficient enough and that requires a lot of time maybe like another 10 15 sessions so then this entire course will become a very big okay so in this first journey we'll cover a SQL and if you have a interest from showing other folks also show interest from the SQL probably
• 89:00 - 89:30 we can plan for no SQL uh series as well so that can be done but again no SQL is not something which we can cover in a one session or two session so it need some dedicated time so that's the problem we have so I assume let's first understand SQL get acquainted with it do some implementation around it then it makes sense to go and start with the no [Applause] SQL okay uh some off track questions
• 89:30 - 90:00 like uh tell me if powerbi is needed for data science let me answer this uh it is not a prerequisite or something for data science it is just a tool that you can utilize to do more data analytics but it is not something that is needed uh to become a data scientist and certificates already covered by the and you want to Learn Python you can
• 90:00 - 90:30 learn python by your own we also have our python course some light onto it okay so uh s it's almost 105 now so yeah let's just quickly take two more three question and then uh we can wrap
• 90:30 - 91:00 it up because it's a working day for you and for me as well and all of other participants as well so guys all your questions I mean uh somehow uh I mean I think we are not ready s probably can put down a one sheet uh s is it possible for you quickly share one uh Google sheet where people can put down their question or so that we can even answer them later on is it possible sure okay yeah take few
• 91:00 - 91:30 question and side by side you can put that list so that others can learn I mean uh allow everyone to enter the question there and then we probably will answer them there sure sure
• 91:30 - 92:00 [Music] s uh your voice is I'm not audible I mean you're not audible can yeah I can hear you can you share any question like I'm not seeing that uh chat now so okay so I just shared the the spr sheet link and in which they can raise any kind of question great great guys
• 92:00 - 92:30 great so any more question which you want me to answer s uh I think that's it from like other questions are related to few are from the powerbi site uh powerbi is a kind of coding language of visualization is enough so uh S I think the good thing would be here would be is like uh maybe day after tomorrow when I come back so we'll we'll talk we'll park some 15 20 minutes and there we'll talk about how
• 92:30 - 93:00 someone can become a data engineer and data scientist so that all this all will resolve everyone's problem and we will uh share what should be the good road map what should be the technology need to be covered Etc so that will help all our audience to clear all this doubt I think this is a very common doubt right as I said about data engineering and data science yes so yes rightly taken deep so a lot of people are confused
• 93:00 - 93:30 like what after SQL what after SQL so in that don't don't get confused after SQL The Next Step would be data engineering or data science based on your experience okay or based on your interest so don't worry we will talk about it like uh how you can shape up your career so we'll talk from the career perspective as well like how should you do it okay so don't don't worry about it we'll try to share all our expertise with you guys okay we will
• 93:30 - 94:00 not do any partiality okay don't worry and probably from the next session they all will get an opportunity to speak as well because we maybe yeah I think s if we I don't know how much maximum number of participants we had at some point of time during the day so if it is lesser than 500 we probably start moving to the Google meet so we can do that as well okay
• 94:00 - 94:30 okay so people can come forward and ask the questions like I know and we are really apologize guys if we missed your question I know there will be a handful of questions which we have not taken up because of this time constraint so and we are really sorry for that guys okay some are few question questions like individuals problem that some of them are facing problem in SQL Server
• 94:30 - 95:00 installation and all so probably you know in the next session we'll cover the installation in detail and the common errors that the people get while sure definitely guys so even guys I mean uh you can put down all your problems on the LinkedIn tag sorab and me and try to share your problems we we get it from the LinkedIn and we try to answer there or or at least we can amplify so that a lot of people around us can help us to
• 95:00 - 95:30 solve I mean because only the problem is time constant so time is the biggest problem as we all are working so sometime that becomes a difficult but put it on our LinkedIn and then share uh and tag us so that we get to know that and share the screenshot that this is the problem you are getting in and tag us so that we'll be uh looking at it and answering it okay so that will be one way and please do share all this uh the session links
• 95:30 - 96:00 and Etc in your group on LinkedIn and if you're liking our work please send us the recommendations as well or your feedback so we always love to hear your feedback like how we are doing how we can improve it if you're doing good and what is the good what is the bad so that will motivate us like people are talking to us so that's the motivation so s shall we close it for today now if
• 96:00 - 96:30 yeah yeah de we can conclude this session as of now and you I like just just you know inform people about the next session yeah so immediately uh we'll do two things uh we'll put the in this description of this uh the today's video itself we will put this link we also put the link uh I will we also send the email to them and and if they are already registered on this website so I repeat you put down this website there
• 96:30 - 97:00 yes okay and SQL class. azure.com you register here and once you register uh I'll just repeat uh let me just I'll just go down again and I'll show you you go to this Azure lib portal uh you you go to this portal okay Azure lab.com you got an email from this you do down you put down your once you
• 97:00 - 97:30 register basically you come here put your email [Music] password and once you log in here you will see your SQL class link and there you see session one so we are on the session one that's why you are just seeing session Session One in next few hours you will see a session two link as well which will be pointing the link for the next session and you just click on
• 97:30 - 98:00 here and you will see the entirely the session okay so that is one of the easiest way to go and see and what you can do is I mean when we go with the Google meet or something you can see all the recordings here as well so I'll just show you how it looks like let's say this is my another product and like here you see all those sessions links and Etc right so here my session one link so here that's how you see all of them okay so okay so I think this will solve
• 98:00 - 98:30 all your recording and all those problem the website if you are already registered on this website which is SQL class. azure.com once you register here you get a login ID and you put that login on this portal azure.com academy. azure.com and here you see your class okay so that will be the easiest way to see the recordings and your live links and Etc
• 98:30 - 99:00 otherwise you check an email as well and you get an email uh you check your spam folder your promotional folder there also you might have got it email for the today's link as well just go down and check it because I have mailed to almost 2,500 people today for this session okay so you should have got it that email and that email somehow is look like this SQL class join something so if this message comes to you this is nothing but a link
• 99:00 - 99:30 for our class okay so that's all from my side s yeah I think uh we have covered most of the things and we try to answer the the doubts and the questions that came into people's mind and uh also you shared information about the next session and I think that is pretty much uh for today and let's let's begin the class
• 99:30 - 100:00 from from the next session okay okay so thank you everyone uh thank you for joining in and hopefully you will see you tomorrow as well when s comes and talk about all this the second day and then from third day onwards I will be also back again and so till then and goodbye thank you good bye everyone thank you should be