What will I learn in this course?
Session 1: Getting Started with SQL Server Introduction to Database, Introduction to SQL Server, Installing SQL Server and Components, SQL Server Database and Tables, SQL Keys, SQL Commands, SQL Constraints, Types of Database Session 2: T-SQL Fundamentals with SQL Server Data Types, Variables and Operators, SQL Server Control Of Flow, SQL Query and Sub Query, SQL Clauses, SQL Predicates, SQL Joins, SQL Exceptions, Try..Catch Session 3: SQL Server Views and Indexes SQL Server Views, Types of Views, SQL Sever Indexes, Types of Indexes Session 4: SQL Server Stored Procedures and Functions Introduction to Stored Procedure, Types of Stored Procedure, Creating Stored Procedures For Insert, Update and Delete, Stored Procedures Parameters, SQL Server Functions, Scalar Functions, Table Valued Functions Session 5: SQL Server Triggers and Cursors SQL Server Triggers, Types of Triggers, SQL Server Cursors, Types of Cursors, Cursor Alternatives Session 6: Understanding and Managing Azure SQL Database Introduction to Azure SQL Database, Database Deployment Models, Azure SQL Database Server, Creating and Managing Single Database, Purchasing Models: DTU and vCore, Azure SQL Database Tools, Database Migration Using DMA, Creating and Managing Elastic Pool, Creating Managed Instance |
Recent Post
