COURSE OVERVIEW

This course will introduce you to relational databases (RDBMSs), and SQL (Structured Query Language) - the language used to create, modify, manage and query them. Using real world examples, you will create tables, set permissions, insert, update and delete data, and retrieve your data using standard SQL. You will also learn about the most common features of the proprietary extensions to the standard language supported by the most common databases .

SQL SERVER

Databases and SQL, Types of databases, Tables, what is a table, The INSERT Statement, Primary keys and foreign keys, Foreign Keys, making table columns mandatory, The NOT NULL constraint, The SELECT statement, Case sensitivity, Creating a table from a query result, Sorting results with ORDER BY, Joins, Linking multiple tables, Mathematical operators, Character functions, Date functions, converting datatypes, Updating and deleting, The UPDATE statement, The DELETE statement, Views, Data access.

Workshops

  • MS SQL Administrator
  • Database Administrator

Skill

  • Microsoft SQL Server
  • SQL Queries
  • BOOTSTRAP
  • SQL Database Design
  • SQL ERD Design

Course Features

DURATION

3 Months - M/W/F or T/T/S

CERTIFICATE

SQL Database Administrator

JOB PROFILE

SQL Database Administrator