Alison's New App is now available on iOS and Android! Download Now

Diploma in Databases and T-SQL
Beginner Level

Diploma in Databases and T-SQL

37,704Learners already enrolled
89
Not Interested
  • 6-10 Avg Hours
  • CPD Accredited
Start Course Now

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 ... 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 PUBLISHER Channel 9Computer science written by MS tutors

What You Will Learn In This Free Course

  • Describe a database and give an exa...
  • List common database terms and expl...
  • Explain three forms of normalizatio...
  • Describe different data types...
  • 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
View All Learning Outcomes View Less
Course Modules
Course Description
Alison Certificates

Explore Careers Related To This Course

Database Administrator Database Administrator
Database Administrators (DBAs) use specialized software to store and organize data that includes financial information and customer shipping records. They are the guardians of this treasure trove of i

  • Average Salary Flag$94,942
  • Traits realistic investigative
Learn More
Data Warehousing Specialist Data Warehousing Specialist
Every day, a remarkable quantity of data is created on diverse platforms, from the digital devices we use to the huge computer networks run by international organisations. Data does not take up physic

  • Average Salary Flag$127,174
  • Traits realistic investigative
Learn More

Complete This CPD Accredited Course & Get Your diploma!

  • Certify Your Skills
    A CPD accredited Alison Diploma/Certificate certifies the skills you’ve learned
  • Stand Out From The Crowd
    Add your Alison Certification to your resumé and stay ahead of the competition
  • Advance in Your Career
    Share your Alison Certification with potential employers to show off your skills and capabilities

Learner Reviews & Feedback For Diploma in Databases and T-SQL

89
Cherno J. Alison Graduate
loved this course
Databases and T-SQL course has been instrumental in helping me grasp the core concepts of databases and their structure. Learning how to retrieve data using SQL and T-SQL is a valuable skill,
Was This Review Helpful?
Report
Unathi M. Alison Graduate
loved this course
Amazing program with great insights.
Was This Review Helpful?
Report
Mark Joseph B. Alison Graduate
loved this course
Thanks for your Training program
Was This Review Helpful?
Report
View -2 More Reviews
Back to course information

Want to create a customised learning path for your team?

Our dedicated Learning Advisors are here to help you curate a customised learning path tailored to your organisation's needs and goals.

Activate your Free LMS now Speak to Learning Advisor

Not sure where to begin? Or even what you want to do?

Discover the career most suitable for you and get started in the field with a step-by-step plan.

Get your Plan

About Your Alison Course Publisher

Channel 9's Alison Stats

Channel 9's Alison Stats

2,248,585 Learners142 Courses11,056 Learners Benefited From Their Courses
Channel 9 is a Microsoft community site created in 2004. Originally launched as the company's blog, it is run by MS developers and tech enthusias...Read More

Explore Subjects Related To This Course