Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Basic SQL with SQL Server 2019 Express
Rating: 4.5 out of 5(75 ratings)
233 students

Learn Basic SQL with SQL Server 2019 Express

Get a Feel For Writing Queries Using SQL Server Express 2019
Created byT O
Last updated 7/2021
English
English [Auto],

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

Course content

1 section • 24 lectures • 2h 11m total length

  • Find, download and install SQL Server Express and SSMS7:43

    Learn how to locate, download, and install SQL Server Express 2019 and its management studio, then connect to the database engine using Windows authentication.

  • Configure the environment font and understand the details of the query window2:43

    Demonstrates configuring fonts and font sizes in SQL Server 2019 Express, improving readability in the query window, and reviewing connection details like computer name, instance, user, and database.

  • Create the structure of a basic table6:56
  • Fill table with values6:30
  • Run first query with full and restricted column names list3:37
  • Run a simple query with a where1:52

    Apply a where clause to the employees table to filter records, illustrating the from, where, and select order and returning the single row with id equals 2.

  • Run a where clause with a where and a restricted list of field names2:34

    Explore extending the where clause with an or condition to filter employees, then select a restricted list of fields like id and last name to control the grid display.

  • Import text file and attach to employees table5:21

    Import a flat file into the employees table using sql server management studio’s import data wizard, map first name, last name, salary, and append new rows to the table.

  • Where with like8:33

    select * from Employees where [Last Name] like 'a%'

    select * from Employees where [Last Name] like '%a%'

    select * from Employees where [Last Name] like 'Am%' --find last names where Am****

    select * from Employees where [Last Name] like '%nan%'

    select * from Employees where [Last Name] like 'c_r%'

    select * from Employees where [First Name] like 'Am[iy]'

  • Where with a variety of options like IN, Between, <, > and <>8:13

    Learn to use the where clause with in, between, and comparison operators. Use not like, not between, and in lists to filter salary and names and observe execution.

  • Aliasing with functions10:32

    Explore aliasing in SQL Server by creating aliases for fields and deriving a full name from first and last names, and format salaries as currency with the format function.

  • Order by11:52

    Sort the salary column with order by, observe ascending and descending results, and understand how where, aliases, and currency formatting affect sorting.

  • Statement vs clause0:43

    Identify how clauses like select, from, where, and order by form a query, and show that assembling them into a complete set yields a statement.

  • Order by with multiple fields6:34

    Learn to sort by multiple fields using order by, sorting by last name then first name, and by salary with alias US salary, with descending and ascending options.

  • Add a department column to the table3:07

    final video on adding a column to an existing table

  • Simple group by4:35

    final version of video on simple group by

  • Group by with having8:12

    final version of video on group by with having

  • Group by with having and order by3:16

    final version of video on group by with having and order by

  • Over, part 15:32

    final version of video on over clause, part 1

  • Over, part 28:05

    final video for lesson 20 on over clause with calculations

  • Over, part 35:33

    Learn to apply the over clause with partition by to compute department-wise salary averages and format results as currency and percent of average, enabling easy salary comparisons.

  • Force a particular order of execution using parenthesis6:40
  • Clustered indexes sort the table2:20
  • End0:02

Requirements

  • Make sure you are using SQL Server 2019 Express
  • Versions below SQL Server 2019 Express might not work

Description

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!

Who this course is for:

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

Report abuse