SQL Server Tutorial for Beginners | SQL Tutorial for Beginners

SQL Server Tutorial for Beginners

If you can, let's support Kud Venkat to gift education to those who cannot afford
https://www.pragimtech.com/support-us/

The image version of the slides are free. The images may appear blurred, but if you click on one of the images they get enlarged and will be crystal clear. You can then use left and right arrows on the keyboard to navigate from one slide to another. Use Google chrome browser for best experience.

If you want to download all the PPTs, you can order them from the following link.
https://www.pragimtech.com/downloadcourses/download-all-slides/

Click here to watch the complete SQL course on YouTube

Subscribe to receive an email, when new videos are uploaded

Part 1 - Connecting to SQL Server | Text | Slides

In this video we will discuss what is a database and sql server management studio. How to connect to SQL server using sql server management studio.

Part 2 - Creating, altering and dropping a database | Text | Slides

A database can be created, altered and dropped in two ways. Either graphically using SQL Server Management Studio (SSMS) or using an sql query. In this video, we will learn creating, altering and dropping a database using both these approaches.

Part 3 - Creating and working with tables | Text | Slides

Database tables allow us to store data. In this video we will learn how to create tables, columns and establish primary key and foreign key constraints between the tables.

Part 4 - Default Constraint | Text | Slides

A default value for a table column can be specified using Default constraint. The specified default value is automatically used if a specific value is not provided. In this video, we will learn Default Constraint in SQL Server with examples.

Part 5 - Cascading referential integrity | Text | Slides

Cascading referential integrity constraint allows to define the actions Microsoft SQL Server should take when a user attempts to delete or update a key to which an existing foreign keys points.

Part 6 - Check Constraint | Text | Slides

CHECK constraint is used to limit the range of the values, that can be entered for a column. In this video we will discuss CHECK constraint in SQL Server with an example.

Part 7 - Identity column | Text | Slides

If a column of a table is marked as an identity column, then the values for this column are automatically generated by the database engine, when a new row is inserted into the table. In this video we will learn Identity column in SQL Server.

Part 8 - Get last generated id in sql server | Text | Slides

In SQL Server, identity column values are auto generated. We will discuss the different ways to retrieve the last generated identity value.

Part 8 - Get last generated id in sql server | Text | Slides

In SQL Server, identity column values are auto generated. We will discuss the different ways to retrieve the last generated identity value.

Part 9 - Unique key constraint in SQL Server | Text | Slides

UNIQUE constraint in SQL Server is used to enforce uniqueness of a column i.e the column shouldn't allow any duplicate values. We can add an Unique constraint through the designer or an sql query.

Part 10 - SQL Select statement | Text | Slides

As the name implies, Select statement allows us to retrieve data from a SQL server database table. If you want to select all the columns, you can use *, but for better performance use the column list, instead of using *.

Part 11 - Group By in SQL Server | Text | Slides

Group by clause is used to group a selected set of rows into a set of summary rows by the values of one or more columns or expressions. It is always used in conjunction with one or more aggregate functions.

About Instructor

KudVenkat

Software Architect, Trainer, Author and Speaker in Pragim Technologies.

Reviews

SQL Server Tutorial for Beginners | SQL Tutorial for Beginners

Average Rating

5

6 ratings

5 1

Details

5 Stars
6
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0
  • Hossam Alaaeldein
    2 months ago★★★★★
    5 5 1

    Excellence

    I'd really like to thank Mr. Venkat and Mr. Mohammad Arafa for their great effort to explain SQL for people who want to start a career in the data business, even if you think you're good at SQL, you would still have new things to learn here

  • Justin A
    3 months ago★★★★★
    5 5 1

    Venkat is an amazing teacher!

    What an amazing teacher! Thank you so much for breaking down these concepts for us! :)

  • Anonymous
    4 months ago★★★★★
    5 5 1
  • Rupesh kumar
    6 months ago★★★★★
    5 5 1

    SQL

    Your explanation is really good and would like to see more videos

  • Luigi Zambetti
    7 months ago★★★★★
    5 5 1

    Invaluable

    My primary source of learning on SQL Server, also for preparing the exam 70-761. Great course Venkat.

  • Lesley Whitehouse
    12 months ago★★★★★
    5 5 1

    SQL Courses

    I am bowled over and constantly referring to Pragim YouTube videos as they are so clear and amazingly perfect in the way they are produced at a perfect pace and with clear and definitive examples on SSMS and accompanying integrated notes. Don't know how I would manage without this source of learning and its FREE!, which is great and so endearingly modest.

ADD A REVIEW

Name
Email
Review Title
Rating
Review Content

Subscribe Email Alerts

If you wish to receive email alerts when new articles, videos or interview questions are posted on PragimTech.com, you can subscribe by providing your valid email.