16 Hours SQL Server Training is being delivered from October 15, 2020 - November 10, 2020 US Pacific Time. About this Event This event has been UPDATED since it was first published. View the Complete, UPDATED & Detailed SQL Server Training Information here. 4 Weekends SQL Server Training is being delivered from October 15, 2020 - November 10, 2020 for 16 hours over 4 weekends, 8 sessions, 2 sessions per weekend, 2 hours per session. All Published Ticket Prices are in US Dollars The course will be taught in English language 16 Hours Microsoft SQL Server Training Schedule October 15, 2020 - November 10, 2020 US Pacific time 4 Weeks | 2 hours on Tuesdays, 2 hours on Thursdays every week US Pacific time 8:30 AM - 10:30 AM US Pacific time each of those days Please click here to add your location and check your local date and time for first session to be held on October 15, 2020 at 8:30 AM US Pacific Time. Features and Benefits 16 Hours, 8 sessions, 4 weekends of total Instructor-led and guided training Training material, instructor handouts and access to useful resources on the cloud provided Practical Hands-on Lab exercises provided Actual code and scripts provided Real-life Scenarios Prerequisites Anyone who is interested in learning SQL and SQL Server. Course Objectives To learn basic Database Concepts. To design a database using E-R Modelling. To learn the concept of Normalization. To understand different components of SQL Server and to learn how to use Management Studio. To learn different SQL Statements like DDL, DML, DQL, DCL, and TCL. To create Databases, tables, and views. To perform Insert, Update, Delete on database tables. To gain a complete understanding of writing the simple and complex queries using simple select statements, aggregate functions, and different types of join. To develop an ability to write scripts using T-SQL To gain a complete understanding of developing Stored Procedures, User Defined Functions, triggers, Index, and Cursor.