When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Practical T-SQL: 300+ quizzes;165 hands-on, useful exercises
Interactive T-SQL Scripting: Learn Transact-SQL (T-SQL) the hands-on way: 390+ quizzes, 165 + hands-on exercises.
This Course Includes
udemy
4.5 (21 reviews )
17h 53m 
english
Online - Self Paced
professional certificate
Udemy
About 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: 1.
Get started fast
1. The concepts and terms you need for working with relational database and SQL 2. How to use the Management Studio to work with a SQL Server database 3. Explore the common Data Manipulation Language (DML) and Data Definition Language (DDL) 4. Learn to design your data to the 3rd Normal Form 2.
Master the SQL that you will use everyday
1. How to write SQL statements that retrieve and update data in a database 2. How to work with inner and outer joins, summary queries, and subqueries...it's all here for you 3. Write sophisticated stored procedures and functions with required and optional parameters with return values to calling programs 4. Write Triggers (INSERT, UPDATE, DELETE, INSTREAD OF) to handle all scenarios including data and referential integrity 5. Learn to use snippets to provide templates for creating objects (stored procs, tables, functions, triggers etc.) ...and more 3.
Learn how to create databases
1. Learn to create a database and its tables using SQL statements or the Management Studio...valuable skills, whether you are on the DBA track or not 4. Learn to code the
Data Manipulation Language
(DML)including all the action queries. 5. 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
What You Will Learn?
- Get started fast: The concepts an terms you need for working with relational database and SQL. How to use the SQL Server Management Studio to work with SQL .
- Master the SQL that you will use every day. Learn to write SQL statements that retrieve and update the data in a database .
- Learn to work with inner and outer joins, summary queries, and subqueries...it's all here .
- How to use data types and built-in functions to handle everyday challenges like manipulating character data, rounding numbers, and working with date/time values .
- Design databases from first principle. Normalize your data: Go through the first three normal forms .
- Create a database and its tables using SQL statements or Management Studio. Learn to use the snippets to create the initial templates of codes for modification .
- Use sequence to generate to generate a complex series of integers that you can assign to a column .
- Master advanced SQL features: Work with views, stored procedures and its parameters, functions, table-valued parameters, triggers, and cursors .
- Innovative hands-on and interactive exercises not found in any course. Write and execute your SQL code within a custom interface outside of SSMS .
- Click button to switch between problem statement and its solution. Navigate back and forth between exercises. Drag & Drop exercises same as in Microsoft exams .
- About 390 quizzes, over 300 hands on exercises to be coded within your SSMS, and over75 interactive exercises that can be performed in a custom interface Show moreShow less.