DIPLOMA
Diploma in Databases and T-SQL
byIT
Diploma in Databases and T-SQL
time6-10hrs
levelbeginner level
This free online Databases and T-SQL course will teach you the core concepts of databases and their structure. It will teach you how to retrieve data from a database using Structured Query Language (SQL) and Microsoft's variant Transact-SQL (T-SQL). You will learn about queries and the different constraints and clauses you can include in them. You will also study administrative tasks you can perform on a database.
Diploma in Databases and T-SQL
Learn about the core concepts of database including the structure by studying this free Databases and T-SQL course.
This free online Databases and T-SQL course will teach you the core concepts of databases and their structure. It will teach you how to retrieve data from a database using Structured Query Language (SQL) and Microsoft's variant Transact-SQL (T-SQL). You will learn about queries and the different constraints and clauses you can include in them. You will also study administrative tasks you can perform on a database.
Core Database Concepts
Learn more about the fundamental concepts of database. You will be introduced to databases, SQL, DBMS and RDMS. You will also learn about SSQL Server Management Studio and how GUI can be used to manage an SQL Server, its databases, and the content contained within the databases.
Relational Concepts
Creating Databases and Database Objects
Using DML Statements
Sql Server Administration Fundamentals
Diploma in Databases and T-SQL - First Assessment
Introducing Transact-SQL
Querying Tables with Select
Querying Multiple Tables with Joins and Using Set Operators
Using Functions and Aggregating Data
Working with Subqueries, Table Expressions and Data
Modifying Data and Using T-SQL in Programming
T-SQL - Error Handling and Transactions
Diploma in Databases and T-SQL - Second Assessment
Course assessment

AD

Related
Articles
Recommended Related
Courses