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.
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?
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! 🤗
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
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 ?
Hey Brother, I followed your steps but I am facing an error. My installation is failing and it goes like this. "Exit code (Decimal): -2068052377Error Invalid command line argument." I have tried Deleting all the SQL-related programs from the Control Panel, Removing Sql related files from the registry, Removing them from Program Files & Program Files(x86), and also turning off my firewall and rebooting the device, and then reinstalling but It is still the same. If anyone has faced a similar problem or has any different solution I am all ears. Thanks.
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..
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.
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. "
@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
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 ☕
This was an amazing and simple class to get started. I want to take all of your courses now. Great work!!!
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
I am from INDIA too. He is the best teacher I came across @sarang-g9w
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❤
@@AgataAnio thanks 🙏
Thanks baraa for good content like this, may God multiply and increase your work.
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
You are doing a great job man by bringing these courses to us thank you so much 😊
@@lokeshm9102 you are welcome 🙏
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 ❤️
very effective starting for Advance topics.. thank you..
Great quality as per usual!
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 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?
Baraa u and Ur content both are awesome. Keep up the good content
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! 🤗
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
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 ?
Thanks Sir, looking forward for more experience 🙏 🤲
This is helpful, Thanks for the amazing and easy to understand content!
Thanks for the support
Hi.. Will you be posting more advanced sql topics in this Playlist?
Yes :)
Thank you so much, Baraa. You're amazing 😍😍
Thank you so much! You're amazing too!
Thanks Sir, to make this kind video series.
you are great Thanks baraa for good content like this
Hi bara,
Waiting for continuation video. Release ASAP.
Hey Brother,
I followed your steps but I am facing an error.
My installation is failing and it goes like this.
"Exit code (Decimal): -2068052377Error Invalid command line argument."
I have tried Deleting all the SQL-related programs from the Control Panel, Removing Sql related files from the registry, Removing them from Program Files & Program Files(x86), and also turning off my firewall and rebooting the device, and then reinstalling but It is still the same.
If anyone has faced a similar problem or has any different solution I am all ears.
Thanks.
I can't download sql files and presentation slides of each chapter.
Is this happening only with me or everyone is facing same issue??
Wow Boss! Thanks a lot.
@DataWithBaraa Could you please help me how to download MS server in MAC OS. Bcoz I am unable to open the downloaded Express file.
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..
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 :)
This is superb!
Is there sql server for Mac users
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
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
Sehr interessant für mich 😅
Why aren't we using MySQL like the previous course?
Please how can I download the SalesDB database file?
the same doubt.
u are the best thanks a lot !
dear sir, i'm not find salesdb data base
Where to download the 3 DB files
how can i do this in mac os??? this data import thing
@DataWithBaraa
I am getting "path not found" error
please start a SQL server intergration service course
ETL
💪💪
❤❤❤❤❤