SQL for Beginner-For Data Analytics & Business Intelligence
Have a detailed knowledge and understanding of using Microsoft SQL, one of the most widely used databases in the world.
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..
Course Content
- Introduction –> 28 lectures • 1hr 16min.
Requirements
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
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. Become skilled as a database developer generally needs you to learn SQL, a database, and then database design. Often this will require multiple courses. However you learn all those topics, and data analysis in this one course.
Essentially, you are learning from someone who has all the professional training, skills, and experience needed to teach you how to become proficient with SQL and Database design as quickly as possible.
After completing this course, you will have the necessary skills to be able to use SQL confidently, have a solid understanding of SQL and be skilled in database design.