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
Get App
Explore Diplomas & Certificados
Descobrir Carreiras
Mais
LMS
Diploma em bancos de dados e T-SQL
Beginner Level

Diploma em bancos de dados e T-SQL

38,364Learners already enrolled
97
Not Interested
  • 6-10 Avg Hours
  • CPD Accredited
Start Learning
  1. Negócios
  2. STEM
  3. Diploma em bancos de dados e T-SQL

Diploma em bancos de dados e T-SQL

Aprenda sobre os principais conceitos de banco de dados, incluindo a estrutura, estudando este curso gratuito de bancos de dados e T-SQL.
Este curso on-line gratuito de bancos de dados e T-SQL ensinará os principais conceitos de bancos de dados e sua estrutura. Ele ensinará como recuperar dados de um banco de dados usando a Linguagem de Consu... Este curso on-line gratuito de bancos de dados e T-SQL ensinará os principais conceitos de bancos de dados e sua estrutura. Ele ensinará como recuperar dados de um banco de dados usando a Linguagem de Consulta Estruturada (SQL) e a variante Transact-SQL (T-SQL) da Microsoft. Você aprenderá sobre consultas e as diferentes restrições e cláusulas que podem ser incluídas nelas. Você também estudará as tarefas administrativas que podem ser executadas em um banco de dados.
COURSE PUBLISHER Channel 9Computer science written by MS tutors
Start Learning

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
Module

Core Database Concepts

Learn more about the fundamental concepts of database. You will be introduced to databases, SQL, DBMS and RDMS. You will also learn about SSQL Server Management Studio and how GUI ... Read More Learn more about the fundamental concepts of database. You will be introduced to databases, SQL, DBMS and RDMS. You will also learn about SSQL Server Management Studio and how GUI can be used to manage an SQL Server, its databases, and the content contained within the databases. Read Less
Start Learning
Module

Relational Concepts

In this module, you will study the relational concepts of database. You will begin by studying Normalization and you will see how the various normal forms impact upon the organizat... Read More In this module, you will study the relational concepts of database. You will begin by studying Normalization and you will see how the various normal forms impact upon the organization of data in a database. You will also study referential integrity and constraints. Read Less
Start Learning
Module

Creating Databases and Database Objects

Learn about what a datatype is and then learn about some of the categories of datatypes. You will also learn about unicode, implicit and explicit datatypes before moving onto datab... Read More Learn about what a datatype is and then learn about some of the categories of datatypes. You will also learn about unicode, implicit and explicit datatypes before moving onto database objects and DDL statements. Read Less
Start Learning
Module

Using DML Statements

In this module, you will be learning about Data Manipulation Language and you will be introduced to the SELECT statement. You will learn the significance of this statement and its ... Read More In this module, you will be learning about Data Manipulation Language and you will be introduced to the SELECT statement. You will learn the significance of this statement and its applications in database. The INSERT, UPDATE and DELETE statements will also be discussed. Read Less
Start Learning
Module

Sql Server Administration Fundamentals

Study the fundamentals of Sql Server Administration Fundamentals and learn about Securables, Principals and Permissions. You will learn about the three-tiered approach to accessing... Read More Study the fundamentals of Sql Server Administration Fundamentals and learn about Securables, Principals and Permissions. You will learn about the three-tiered approach to accessing content and about how Databases and Objects are secured. Read Less
Start Learning
Module

Diploma in Databases and T-SQL - First Assessment

You must score 80% or more to pass this assessment.
Start Learning
Module

Introducing Transact-SQL

In this module, you will be introduced to Transact-SQL and you will learn about Structured Query Language, Data Manipulation Language, Data Definition Language and Data Control Lan... Read More In this module, you will be introduced to Transact-SQL and you will learn about Structured Query Language, Data Manipulation Language, Data Definition Language and Data Control Language. Read Less
Start Learning
Module

Querying Tables with Select

In this module, you will learn how to query tables with select. You will look at removing duplicates and sorting as well as filtering and using predicates.
Start Learning
Module

Querying Multiple Tables with Joins and Using Set Operators

This module will introduce you to Joins and Queries, you will learn about how to use a join and the various types of joins that are used.
Start Learning
Module

Using Functions and Aggregating Data

This module will introduce you to various functions such as Scalar Functions and Logical Functions. You will also gain a greater understanding of GROUP BY and Filtering with HAVING... Read More This module will introduce you to various functions such as Scalar Functions and Logical Functions. You will also gain a greater understanding of GROUP BY and Filtering with HAVING. Read Less
Start Learning
Module

Working with Subqueries, Table Expressions and Data

This module will introduce you to Subqueries as well as showing you how certain table expressions work. You will also learn more about Grouping Sets and Pivoting Data.
Start Learning
Module

Modifying Data and Using T-SQL in Programming

In this module, you will learn more about the practicalities of working with data. You will learn about how to input data and also about how to update and delete data in a table. Y... Read More In this module, you will learn more about the practicalities of working with data. You will learn about how to input data and also about how to update and delete data in a table. You will also study Batches, Comments and Variables and take a look at Conditional Branching and Looping. Read Less
Start Learning
Module

T-SQL - Error Handling and Transactions

In this module, you will learn about Error Messages and Raising Errors. Following on from this, you will study how errors are caught and handled and you will learn about Transactio... Read More In this module, you will learn about Error Messages and Raising Errors. Following on from this, you will study how errors are caught and handled and you will learn about Transactions. Read Less
Start Learning
Module

Diploma in Databases and T-SQL - Second Assessment

You must score 80% or more to pass this assessment.
Start Learning
Module

Course assessment

 Start Learning

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
Get App

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
Start Learning

Learner Reviews & Feedback For Diploma em bancos de dados e T-SQL

97
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,280,957 Learners142 Courses11,741 Learners Benefited From Their Courses

More Free Online Courses by This Publisher

    Learners Who Took This Course Also Enrolled In

    Explore Subjects Related To This Course