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
Sale!
-92%
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.
