What you’ll learn:
Key concepts you will learn and work with in this course. SQL (Structured Query Language – very much an in-demand technology). Database Design Data Analysis
Creating, Modifying and Deleting Tables in a Database (DDL), Inserting, Updating and Deleting Data from Tables (DML)
Select Queries, Joins Aggregate Functions Subqueries Database Design Creating Databases. Constraints, Case when, Clauses, Operators
Not only does the course teach you SQL, but there are multiple exercises for you to try with video solutions to further help you understand the material.
Requirements:
Microsoft SQL Server Management Studio.
Description:
Have a detailed knowledge and understanding of using Microsoft SQL, one of the most widely used databases in the world.
Obtained a knowledge of SQL, allows students to apply for jobs in the IT sector.
In-depth knowledge of database design will give students an edge over other applicants.
Key concepts you will learn and work with in this course.
SQL (Structured Query Language – very much an in-demand technology).
Database Design
Data Analysis
Through out the course you will go through creating an example database for Movie.
Creating, Modifying and Deleting Tables in a Database (DDL)
Inserting, Updating and Deleting Data from Tables (DML)
Select Queries
Joins
Aggregate Functions
Sub queries
Database Design
Creating Databases.
Constraints,
Case when,
Clauses,
Operators
