Diploma in Databases and T-SQL
- Created by Jay Academy
- English
- English [Auto]
This program is ISO/IEC 17025 certified by the US Accreditation Council, and also holds IHEAC, CPD, and Qualiopi accreditation.
4.9 (25633 ratings)
☆☆☆☆☆ 4.9/5
This course includes:
- 6-10 Hours of Learning
- Unlimited access to webinars
- Full lifetime access
- Access on mobile and computer
- Diploma / Certificate of Completion
Enter Coupon
Description
This program is ISO/IEC 17025 certified by the US Accreditation Council, and also holds IHEAC, CPD, and Qualiopi accreditation.
This Databases and T-SQL program by Jay Academy 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.
What you'll learn
- Describe a database and give an example of real life uses
- List common database terms and explain their part in a database
- Explain three forms of normalization and referential integrity
- Describe different data types
- Discuss how to create a basic database and how to backup and restore it
- Discuss how to Use the SELECT statement, including aggregate functions, to retrieve data from your database
- Describe how to modify your database using INSERT, UPDATE AND DELETE commands
- Outline how to Add users and set their permission levels
- Summarize how to set up an Azure SQL Database environment
- Describe the different data types and their uses
- Explain NULL functions, removal of duplicates and how they work with SQL queries
- Select how to sort SQL query results
Requirements
Access to a computer or mobile with an internet connection.
Explore related topics
Certificate of completion
Related Course's
Related products
-
Diploma in Nursing and Patient Care
£16.00 – £39.00 -
Diploma in Hospitality Management
£16.00 – £39.00
