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.
| Course Category | Business |
| Course Type | Online Learning |
| Course Qualification | CPD Diploma |
| Course Duration | 6-10 hours |
| Course Fee | Free |
| Entry Requirements | Like all courses on the Alison Free Learning platform this is a free, CPD-accredited course. A Graduate can choose to buy a certificate or diploma upon successful completion of a course, but this is not required or necessary. At Alison we believe that free education, more than anything, has the power to break through boundaries and transform lives. Alison is the world’s largest free online empowerment platform for education and skills training, offering over 5000 CPD accredited courses and a range of impactful career development tools. It is a for-profit social enterprise dedicated to making it possible for anyone, to study anything, anywhere, at any time, for free online, at any subject level. Through our mission, we are a catalyst for positive social change, creating opportunity, prosperity, and equality for everyone. |
| Career Path | In This Free Course, You Will Learn How To • 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 |
| Course Code | 1055 |
Enrol with Alison today! This free online certificate course teaches you how to use CPR, AED, and first aid to save lives.
Enrol with Alison today! Learn how to give good care to the elderly with the nursing procedures and practices in this free online nursing course.
Enrol with Alison today! Learn the important functions and practices of human resource professionals in this free online diploma course.
Enrol with Alison today! In this free online course, learn how to implement the HACCP Food Safety System in your catering establishment.
