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.
- Text | Slides | Basic Joins
- Text | Slides | Advanced Joins
- Text | Slides | Self join
- Text | Slides | Different ways to replace NULL
- Text | Slides | Coalesce function
- Text | Slides | Union and Union All
- Text | Slides | Stored Procedures
- Text | Slides | Stored Procedures with output parameters
- Text | Slides | Difference between output parameters and return values
- Text | Slides | Advantages of stored procedures
- Text | Slides | Built in string functions
- Text | Slides | Left, Reight, Charindex and Substring functions
- Text | Slides | Replicate, Space, Patindex, Replace and Stuff functions
- Text | Slides | DateTime functions
- Text | Slides | IsDate, Day, Month, Year and DateName functions
- Text | Slides | DatePart, DateAdd and DateDiff functions
- Text | Slides | Convert and Cast functions
- Text | Slides | Mathematical functions
- Text | Slides | Scalar User Defined functions
- Text | Slides | Inline Table Valued functions
- Text | Slides | Multi-Statement Table Valued functions
- Text | Slides | Important concepts related to functions in sql server
- Text | Slides | Temporary tables
- Text | Slides | Indexes
- Text | Slides | Clustered and NonClustered Indexes
- Text | Slides | Unique and Non-Unique Indexes
- Text | Slides | Advantages and disadvantages of indexes
- Text | Slides | Views
- Text | Slides | Updateable Views
- Text | Slides | Indexed Views
- Text | Slides | View Limitations
- Text | Slides | DML Triggers
- Text | Slides | DML After Update Trigger
- Text | Slides | Instead of insert trigger
- Text | Slides | Instead of update trigger
- Text | Slides | Instead of delete trigger
- Text | Slides | Derived table and CTE's
- Text | Slides | Common Table Expressions
- Text | Slides | Updatable CTE
- Text | Slides | Recursive CTE
- Text | Slides | Normalization & First Normal Form
- Text | Slides | 2NF and 3NF
- Text | Slides | Pivot Operator
- Text | Slides | Error handling in SQL Server 2000
- Text | Slides | Error handling in SQL Server 2005 and later versions
- Text | Slides | Transactions in SQL Server
- Text | Slides | Transaction ACID Tests
- Text | Slides | Subqueries in sql
- Text | Slides | Correlated subquery
- Text | Slides | Creating a large table with random data for performance testing
- Text | Slides | What to choose for performance - SubQuery or Joins
- Text | Slides | Cursors in sql server
- Text | Slides | Replacing cursors using joins
- Text | Slides | List all tables in a sql server database using a query
- Text | Slides | Writing re-runnable sql server scripts
- Text | Slides | Alter database table columns without dropping table
- Text | Slides | Optional parameters in sql server stored procedures
- Text | Slides | Merge in SQL Server
- Text | Slides | SQL Server concurrent transactions
- Text | Slides | SQL Server dirty read example
- Text | Slides | SQL Server lost update problem
- Text | Slides | Non repeatable read example in sql server
- Text | Slides | Phantom reads example in sql server
- Text | Slides | Snapshot isolation level in sql server
- Text | Slides | Read committed snapshot isolation level in sql server
- Text | Slides | Difference between snapshot isolation and read committed snapshot
- Text | Slides | SQL Server deadlock example
- Text | Slides | SQL Server deadlock victim selection
- Text | Slides | Logging deadlocks in sql server
- Text | Slides | SQL Server deadlock analysis and prevention
- Text | Slides | Capturing deadlocks in sql profiler
- Text | Slides | SQL Server deadlock error handling
- Text | Slides | Handling deadlocks in ado.net
- Text | Slides | Retry logic for deadlock exceptions
- Text | Slides | How to find blocking queries in sql server
- Text | Slides | SQL Server except operator
- Text | Slides | Difference between except and not in sql server
- Text | Slides | Intersect operator in sql server
- Text | Slides | Difference between union intersect and except in sql server
- Text | Slides | Cross apply and outer apply in sql server
- Text | Slides | DDL Triggers in sql server
- Text | Slides | Server-scoped ddl triggers
- Text | Slides | SQL Server trigger execution order
- Text | Slides | Audit table changes in sql server
- Text | Slides | Logon triggers in sql server
- Text | Slides | Select into in sql server
- Text | Slides | Difference between where and having in sql server
- Text | Slides | Table valued parameters in SQL Server
- Text | Slides | Send datatable as parameter to stored procedure
- Text | Slides | Grouping Sets in SQL Server
- Text | Slides | Rollup in SQL Server
- Text | Slides | Cube in SQL Server
- Text | Slides | Difference between cube and rollup in SQL Server
- Text | Slides | Grouping function in SQL Server
- Text | Slides | GROUPING_ID function in SQL Server
- Text | Slides | Debugging sql server stored procedures
- Text | Slides | Over clause in SQL Server
- Text | Slides | Row_Number function in SQL Server
- Text | Slides | Rank and Dense_Rank in SQL Server
- Text | Slides | Difference between rank dense_rank and row_number in SQL
- Text | Slides | Calculate running total in SQL Server 2012
- Text | Slides | NTILE function in SQL Server
- Text | Slides | Lead and Lag functions in SQL Server 2012
- Text | Slides | FIRST_VALUE function in SQL Server
- Text | Slides | Window functions in SQL Server
- Text | Slides | Difference between rows and range
- Text | Slides | LAST_VALUE function in SQL Server
- Text | Slides | UNPIVOT in SQL Server
- Text | Slides | Reverse PIVOT table in SQL Server
- Text | Slides | Choose function in SQL Server
- Text | Slides | IIF function in SQL Server
- Text | Slides | TRY_PARSE function in SQL Server 2012
- Text | Slides | TRY_CONVERT function in SQL Server 2012
- Text | Slides | EOMONTH function in SQL Server 2012
- Text | Slides | DATEFROMPARTS function
- Text | Slides | Difference between DateTime and SmallDateTime in SQL Server
- Text | Slides | DateTime2FromParts function in SQL Server 2012
- Text | Slides | Difference between DateTime and DateTime2 in SQL Server
- Text | Slides | Offset fetch next in SQL Server 2012
- Text | Slides | Identifying object dependencies in SQL Server
- Text | Slides | sys.dm_sql_referencing_entities in SQL Server
- Text | Slides | sp_depends in SQL Server
- Text | Slides | Sequence object in SQL Server 2012
- Text | Slides | Difference between sequence and identity in SQL Server
- Text | Slides | Guid in SQL Server
- Text | Slides | How to check GUID is null or empty in SQL Server
- Text | Slides | Dynamic SQL in SQL Server
- Text | Slides | Implement search web page using ASP.NET and Stored Procedure
- Text | Slides | Implement search web page using ASP.NET and Dynamic SQL
- Text | Slides | Prevent sql injection with dynamic sql
- Text | Slides | Dynamic SQL in Stored Procedure
- Text | Slides | Sql server query plan cache
- Text | Slides | exec vs sp_executesql in sql server
- Text | Slides | Dynamic sql table name variable
- Text | Slides | Quotename function in SQL Server
- Text | Slides | Dynamic SQL vs Stored Procedure
- Text | Slides | Dynamic sql output parameter
- Text | Slides | Temp tables in dynamic sql
About Instructor
Reviews
Details
-
Anonymous1 month ago
-
Rupesh kumar3 months ago
SQL
Your explanation is really good and would like to see more videos
-
Luigi Zambetti4 months ago
Invaluable
My primary source of learning on SQL Server, also for preparing the exam 70-761. Great course Venkat.
-
Lesley Whitehouse9 months ago
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.
