Practical T-SQL: 300+ quizzes;165 hands-on, useful exercises

This is the second edition and a complete overhaul of my first SQL Server Querying course based on SQL Server 2016 and 2019. This course shows you how to code the SQL statements that you need for your application if you are already in the industry. If you are a student preparing to enter a competitive world, this course will give you the advantage you need to succeed. We teach you how to code SQL scripts so they run efficiently. The course shows you how to take advantage of the most useful advanced features that SQL Server has to offer. This SQL Server course is based on SQL Server 2016 and 2019. In this course we teach you all that you need to use SQL Server effectively and to write good SQL scripts. We cover the following topics: Get started fastThe concepts and terms you need for working with relational database and SQLHow to use the Management Studio to work with a SQL Server databaseExplore the common Data Manipulation Language (DML) and Data Definition Language (DDL)Learn to design your data to the 3rd Normal FormMaster the SQL that you will use everydayHow to write SQL statements that retrieve and update data in a databaseHow to work with inner and outer joins, summary queries, and subqueries. it’s all here for youWrite sophisticated stored procedures and functions with required and optional parameters with return values to calling programsWrite Triggers (INSERT, UPDATE, DELETE, INSTREADOF) to handle all scenarios including data and referential integrityLearn to use snippets to provide templates for creating objects (stored procs, tables, functions, triggers etc.) .and moreLearn how to create databasesLearn to create a database and its tables using SQL statements or the Management Studio. valuable skills, whether you are on the DBA track or notLearn to code the Data Manipulation Language (DML)including all the action queries. Interactive, hands-on exercises controlled by a (innovative) custom user-defined interface. Execute all your SQL scripts within custom interface (no SSMS). Move between problem and solution at the click of a button. Experience a unique learning experience