Learn Basic SQL with SQL Server 2019 Express

Rating 4.15 out of 5 (56 ratings in Udemy)

What you'll learn

Find , download and install SQL Server Express 2019 and the Management Studio
Understand how to configure the SQL Server Management Studio
Understand how to work with select, where, like
Understand how to configure different options in the SSMS
Understand how to import records from text files
Understand how to use >, <=, between, not between, in , not like
Understand the logical order of the execution of queries
Understand how to use order by with where and field …

Rating 4.15 out of 5 (56 ratings in Udemy)

What you'll learn

Find , download and install SQL Server Express 2019 and the Management Studio
Understand how to configure the SQL Server Management Studio
Understand how to work with select, where, like
Understand how to configure different options in the SSMS
Understand how to import records from text files
Understand how to use >, <=, between, not between, in , not like
Understand the logical order of the execution of queries
Understand how to use order by with where and field aliasing
Understand the difference between statements and clauses
Understand how to use group by with having and order by
Understand how to use over to window results
Learn how to restore databases from back up

Description

Features of this course:

All the audio is done with a studio microphone.
All the videos are filmed in 1080p.
Udemy might not show them at 1080p, though. Icannot control this.
Any closed captions are automatically generated. Icannot control what they say.
This course uses the "talking head" feature, but it's small and Imove around the screen to bring attention to different concepts under study. If you feel this might be a distraction for you, please do not enroll in this course. Thank you.
This is a course for beginners.
If you are at the intermediate or advanced level, this is not the course for you.
This course uses SQLServer Express 2019.
If you try to use a lower version of SQLServer Express, you might have compatibility issues.
The code is always created in real time, and explained line by line as it's typed.
There are some exercises placed throughout the videos. Please pause and try to answer them.
When code is written,it's saved under lesson resources. The first lesson with saved code is 7.
There are some preview videos available so you can get a feel for the course. Please watch those.
Please remember that Iam only one person, so while Istrive to be detailed, Icannot always think of every small point you might need covered.
If it's too slow or fast, please change the speed on the player to 0.75x or 1.25x .
The average video length is 4 minutes and 45 seconds.
Please note this whole course is only about 1.5 hours. It's just brief introduction to SQL with SQLServer 2019 Express.
Thank you for reading, and enroll today!

Duration 2 Hours 58 Minutes

Paid

Self paced

Beginner Level

English (US)

169

Rating 4.15 out of 5 (56 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.