Beginner Level
Diplôme en bases de données et T-SQL
38,351Learners already enrolled
6-10 Avg Hours
CPD Accredited
Diplôme en bases de données et T-SQL
Découvrez les concepts de base de la base de données, y compris sa structure, en suivant ce cours gratuit sur les bases de données et T-SQL.
Ce cours en ligne gratuit sur les bases de données et T-SQL vous enseignera les concepts de base des bases de données et leur structure. Il vous apprendra comment récupérer des données d'une base de donn... Ce cours en ligne gratuit sur les bases de données et T-SQL vous enseignera les concepts de base des bases de données et leur structure. Il vous apprendra comment récupérer des données d'une base de données à l'aide du langage SQL (Structured Query Language) et de la variante Transact-SQL (T-SQL) de Microsoft. Vous découvrirez les requêtes et les différentes contraintes et clauses que vous pouvez y inclure. Vous étudierez également les tâches administratives que vous pouvez effectuer sur une base de données.
COURSE PUBLISHER -
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
![]()
Knowledge & Skills You Will Learn
Knowledge & Skills You Will Learn No internet? No problem! Download any course on the Alison App and learn on the go. 📲 Download Courses & Learn Without Internet Coming soon to iOS
Explore Careers Related To This Course
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
$94,942
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
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 Diplôme en bases de données et T-SQL
Cherno J. ![]()
Alison Graduate
Alison Graduate 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,
Unathi M. ![]()
Alison Graduate
Alison Graduate Amazing program with great insights.
Mark Joseph B. ![]()
Alison Graduate
Alison Graduate Thanks for your Training program
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.
Not sure where to begin?
Discover the career most suitable for you and get started in the field with a step-by-step plan.
Get your Plan
