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.
4.10 (21 reviews)
169
students
18 hours
content
Sep 2021
last update
$64.99
regular price
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
Screenshots
Related Topics
3696976
udemy ID
12/11/2020
course created date
1/21/2021
course indexed date
Bot
course submited by