When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Udemy logo

Learn Basic SQL with SQL Server 2019 Express

Get a Feel For Writing Queries Using SQL Server Express 2019

     
  • 3.5
  •  |
  • Reviews ( 75 )
₹519

This Course Includes

  • iconudemy
  • icon3.5 (75 reviews )
  • icon2h 11m
  • iconenglish
  • iconOnline - Self Paced
  • iconprofessional certificate
  • iconUdemy

About Learn Basic SQL with SQL Server 2019 Express

Features of this course:

1.

All the audio is done with a studio microphone.

2.

All the videos are filmed in 1080p.

3.

Udemy might not show them at 1080p, though. I cannot control this.

4.

Any closed captions are automatically generated. I cannot control what they say.

5.

This course uses the "talking head" feature, but it's small and I move 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.

6.

This is a course for beginners.

7.

If you are at the intermediate or advanced level, this is not the course for you.

8.

This course uses SQL Server Express 2019.

9.

If you try to use a lower version of SQL Server Express, you might have compatibility issues.

10.

The code is always created in real time, and explained line by line as it's typed.

11.

There are some exercises placed throughout the videos. Please pause and try to answer them.

12.

When code is written,it's saved under lesson resources. The first lesson with saved code is 7.

13.

There are some preview videos available so you can get a feel for the course. Please watch those.

14.

Please remember that I am only one person, so while I strive to be detailed, I cannot always think of every small point you might need covered.

15.

If it's too slow or fast, please change the speed on the player to 0.75x or 1.25x .

16.

The average video length is 4 minutes and 45 seconds.

17.

Please note this whole course is only about 1.5 hours. It's just brief introduction to SQL with SQL Server 2019 Express.

18.

Thank you for reading, and enroll today!

What You Will 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 Show moreShow less.