SQL Server 2014: T-SQL Fundamentals
Learn about the history of SQL, data manipulation and data definition languages, and key concepts such as batches, scripts, concurrency and Cartesian product.
This free online course has been specifically prepared for beginners in T-SQL and will help you understand the various aspects of SQL Server 2014. Study the differences between a data manipulation language (DLL) and data definition language (DDL), and explore concepts of normalization and concurrency. The course material also covers the operations of WHERE, ORDERBY and GROUPBY clauses, as well as the functions of the Cartesian product.
What You Will Learn In This Free Course
Introduction to T-SQL
To start, this module will introduce you to the two broad statement types of T-SQLwhich include Data Definition Language (DLL) and Data Manipulation Language (DML). You will also be introduced to the different categories of operators in T-SQL.
Functions, Flow, Results
To start, this module will introduce you to the functions and operations of IF, ELSE, WHEN, WAITFOR, and UPDATE statements. You will also be introduced to the four ranking functions in Transact-SQL.; Module
Select, Where, Clauses, Tables
To start, you will be introduced to the functions of the WHERE clause, as well as the symbol-based comparison operators supported by the WHERE clause. You will also be introduced to the operations and functions of the Cartesian product.
Working with Data
To start, this module will introduce you to how to modify data using T-SQL, as well as how to insert data using tables. You will also be introduced to the four basic isolation levels in the SQL server.; Module
Course assessment
