If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE ⏱ TIMESTAMPS ⏱ --------------------------------- 00:00 intro 00:40 Download & Install SQL Server 02:59 Download & Install SSMS 05:24 Download 3x Databases 10:45 Tour into the Interface Enjoy ☕
Nice video..I'm following this course..I hope by the end of this course you will do a project that is very close to practical life or in a work place..Thank you for all the effort & time you give for us ..
Thank you so much for such a wonderful content. I am just curious when are you planning to upload the next video in the series? I want to plan my study session around your upload time.
@gauravbharti9676@@FirangizMuslumzada it is very simple...just go to connection properties or if your in the latest version before connecting just look below and youll see a small option called trust connection cerificate..check the box and its solved.. Good Luck
for people who use linux, the backup path is should you make first, the guide mkdir -p /backup/sql_servers sudo chown mssql /backup/sql_servers and you can put the file into that folders, linux doesn't provide auto backup folder
Hi Baraa, first of all im so thankful for the structure bof your 4 hour course. It made my learning so much easier . I wanted to ask if this plalist would also be made into a full course ? Thank you in advance! Again thank you , danke! Merci beaucoup!
Thanks a lot again ! Also I'd like to ask , when working with a specific company. Are you always provided with a database to use by the company if let's say there's a business problem? .... I noticed that the syntax for MS Server and MySql is slightly different ...As a data analyst do you always have to write the sql statements? 🥲meaning I have to know how all syntax works? ...I'm a bit confused about that . How do you get a database from a company? With a problem. A cited example would be highly appreciated! 🤗
Baraa, when learning about SQL don't we need to understand how these relationships were built or it's the warehouse data responsibility? Like if i would become a data analyst Is all I need is mastering the sql program? Also, how about the interface of the program and the many tools within it ?
Hi baraa, first of all thank you for your efforts, you used MySQL in the 4-hour sql course and I think you will use MSSQL here, is there a specific reason or is it just a matter of preference?
Tried everything Baraa, I just can't see the files when i connect to the database and go through the restore databases. I have them in downloads in my PC , but i can't find them in database when i connect.
Hi, sorry to hear that! You have to place all database files (bak) in following folder C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Backup
@@DataWithBaraa Just one little problem, the two adventure files have been backed up, But I get an Error message Restore of database " 'SalesDB' failed. "
I've fought with a Contosa github project and can't get it to work. I'll just try to restore the contosa DB in this free version because I'm a data hoarder.
does this software will help to import the real life datasets if you have the time will you make the video on how to impport the dataset from any sources such as kaggle,UCG and etc..
If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE
⏱ TIMESTAMPS ⏱
---------------------------------
00:00 intro
00:40 Download & Install SQL Server
02:59 Download & Install SSMS
05:24 Download 3x Databases
10:45 Tour into the Interface
Enjoy ☕
I am from india brother.. i will promote your videos to my friends as much as possible.. you are the best trainer
You are the best
Looking forward to learning new approaches towards the advanced SQL functions. Waiting for the upcoming videos.
Nice video..I'm following this course..I hope by the end of this course you will do a project that is very close to practical life or in a work place..Thank you for all the effort & time you give for us ..
As always, everything explained step by step. Thank you Baraa❤
Great work bara ! waiting for every video you upload
Thanks 🙏 and sorry if I take time make videos but I try to make good quality for everyone ❤️
You are doing a great job man by bringing these courses to us thank you so much 😊
very effective starting for Advance topics.. thank you..
Great quality as per usual!
Thank you so much for such a wonderful content. I am just curious when are you planning to upload the next video in the series? I want to plan my study session around your upload time.
I am doing weekly upload A, cant Promise a plan. Glad you like my videos
Not able to connect ssms.. it says the certificate chain was issued by an authority that is not trusted.
I have the same problem, can you please help Baraa?
@@FirangizMuslumzada search for the error solution on youtube. there are a lot of videos for this. I was able to fix it after watching the videos.
@gauravbharti9676@@FirangizMuslumzada it is very simple...just go to connection properties or if your in the latest version before connecting just look below and youll see a small option called trust connection cerificate..check the box and its solved..
Good Luck
Click on the small dialog box that says trust certificate server then connect it Wil work
Thanks baraa for good content like this, may God multiply and increase your work.
for people who use linux, the backup path is should you make first, the guide
mkdir -p /backup/sql_servers
sudo chown mssql /backup/sql_servers
and you can put the file into that folders, linux doesn't provide auto backup folder
Thank you so much for this Baraa, you did a great job here, I just sent a connection request on linkedin
You are welcome 🙏 thanks 😊
Hi Baraa, first of all im so thankful for the structure bof your 4 hour course. It made my learning so much easier . I wanted to ask if this plalist would also be made into a full course ? Thank you in advance! Again thank you , danke! Merci beaucoup!
I really appreciate your nice words. Yes it will be complete course 👍
Thanks a lot again ! Also I'd like to ask , when working with a specific company. Are you always provided with a database to use by the company if let's say there's a business problem? .... I noticed that the syntax for MS Server and MySql is slightly different ...As a data analyst do you always have to write the sql statements? 🥲meaning I have to know how all syntax works? ...I'm a bit confused about that . How do you get a database from a company? With a problem.
A cited example would be highly appreciated! 🤗
Baraa u and Ur content both are awesome. Keep up the good content
Thanks Sir, looking forward for more experience 🙏 🤲
Baraa, when learning about SQL don't we need to understand how these relationships were built or it's the warehouse data responsibility?
Like if i would become a data analyst
Is all I need is mastering the sql program?
Also, how about the interface of the program and the many tools within it ?
Hi bara,
Waiting for continuation video. Release ASAP.
Is there sql server for Mac users
you are great Thanks baraa for good content like this
Hi.. Will you be posting more advanced sql topics in this Playlist?
Yes :)
This is superb!
Hi baraa, first of all thank you for your efforts, you used MySQL in the 4-hour sql course and I think you will use MSSQL here, is there a specific reason or is it just a matter of preference?
Thanks Sir, to make this kind video series.
@DataWithBaraa Could you please help me how to download MS server in MAC OS. Bcoz I am unable to open the downloaded Express file.
This is helpful, Thanks for the amazing and easy to understand content!
Thanks for the support
Simply awesome ❤
Thank you! Cheers!
Tried everything Baraa, I just can't see the files when i connect to the database and go through the restore databases. I have them in downloads in my PC , but i can't find them in database when i connect.
Hi, sorry to hear that! You have to place all database files (bak) in following folder C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Backup
@@joeyng9754 nice! Glad it is solved 👍
@@DataWithBaraa Just one little problem, the two adventure files have been backed up, But I get an Error message Restore of database " 'SalesDB' failed. "
Im getting that the SalesDB. bak is corrupt , im stuck here .help pls
I've fought with a Contosa github project and can't get it to work. I'll just try to restore the contosa DB in this free version because I'm a data hoarder.
I haven’t try it but good luck with that :)
Thank you so much, Baraa. You're amazing 😍😍
Thank you so much! You're amazing too!
does this software will help to import the real life datasets
if you have the time will you make the video on how to impport the dataset from any sources such as kaggle,UCG and etc..
Sehr interessant für mich 😅
please start a SQL server intergration service course
ETL
Please how can I download the SalesDB database file?
the same doubt.
Why aren't we using MySQL like the previous course?
dear sir, i'm not find salesdb data base
how can i do this in mac os??? this data import thing
@DataWithBaraa
u are the best thanks a lot !
Where to download the 3 DB files
I am getting "path not found" error
💪💪
❤❤❤❤❤