Learn Basic SQL with SQL Server 2019 Express

Learn Basic SQL with SQL Server 2019 Express, available at $59.99, has an average rating of 4.05, with 24 lectures, based on 71 reviews, and has 222 subscribers.

You will learn about 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 This course is ideal for individuals who are This is a course for those who are interested in SQL Server and basic queries It is particularly useful for This is a course for those who are interested in SQL Server and basic queries.

Enroll now: Learn Basic SQL with SQL Server 2019 Express

Summary

Title: Learn Basic SQL with SQL Server 2019 Express

Price: $59.99

Average Rating: 4.05

Number of Lectures: 24

Number of Published Lectures: 24

Number of Curriculum Items: 24

Number of Published Curriculum Objects: 24

Original Price: $19.99

Quality Status: approved

Status: Live

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

Who Should Attend

This is a course for those who are interested in SQL Server and basic queries

Target Audiences

This is a course for those who are interested in SQL Server and basic queries

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. I cannot control this.
Any closed captions are automatically generated. I cannot control what they say.
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.
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 SQL Server Express 2019.
If you try to use a lower version of SQL Server 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 I am only one person, so while I strive to be detailed, I cannot 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 SQL Server 2019 Express.
Thank you for reading, and enroll today!

Course Curriculum

Chapter 1: Coding fundamentals

Lecture 1: Find, download and install SQL Server Express and SSMS

Lecture 2: Configure the environment font and understand the details of the query window

Lecture 3: Create the structure of a basic table

Lecture 4: Fill table with values

Lecture 5: Run first query with full and restricted column names list

Lecture 6: Run a simple query with a where

Lecture 7: Run a where clause with a where and a restricted list of field names

Lecture 8: Import text file and attach to employees table

Lecture 9: Where with like

Lecture 10: Where with a variety of options like IN, Between, <, > and <>

Lecture 11: Aliasing with functions

Lecture 12: Order by

Lecture 13: Statement vs clause

Lecture 14: Order by with multiple fields

Lecture 15: Add a department column to the table

Lecture 16: Simple group by

Lecture 17: Group by with having

Lecture 18: Group by with having and order by

Lecture 19: Over, part 1

Lecture 20: Over, part 2

Lecture 21: Over, part 3

Lecture 22: Force a particular order of execution using parenthesis

Lecture 23: Clustered indexes sort the table

Lecture 24: End

Instructors

T O
Spreader of Knowledge

Rating Distribution

1 stars: 1 votes
2 stars: 1 votes
3 stars: 12 votes
4 stars: 19 votes
5 stars: 38 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu