
About Course
You will learn to read and write complex database queries using one of the most popular programming languages – SQL and the super popular DBMS (database management system) – SQL Server. All the knowledge that you will gain in the course is easily applicable to other DBMSs, such as MySQL, PostgreSQL, Oracle. Learning SQL is one of the fastest ways to climb the career ladder and start earning even more. During the course, you will study and receive assignments to test yourself and improve your understanding of the material.
Course Content
Introduction to SQL
-
Basic Concepts
-
Relational model
-
Briefly about SQL Server
-
Installing SQL Server 2019
-
Data types
-
Creating a database
-
One to one relationship”
-
Many-to-many relationship”
-
Creating Northwind
Simple queries with SELECT
Joins – JOINs
Subqueries
DDL – managing database and tables
Database design
Representation
Logic with CASE, COALESCE and NULLIF
Procedures and functions
Transactions
Errors and their handling
Indexes
Common Table Expressions – CTE
Window functions
Student Ratings & Reviews
No Review Yet