SQL Masterclass For Data Science

SQL Masterclass – For Data Science, available at $19.99, with 138 lectures, and has 2 subscribers.

You will learn about To create, update and modify database To create, update and modify tables To write data retrieval queries and evaluate the result set To write data updation and modification queries To convert data to the best form using normalization techniques To establish relations and get desired output with multiple tables by using SQL JOINS & UNION Creating relationships in tables using foreign key and primary key This course is ideal for individuals who are Learners looking to launch their career in Data Science It is particularly useful for Learners looking to launch their career in Data Science.

Enroll now: SQL Masterclass – For Data Science

Summary

Title: SQL Masterclass – For Data Science

Price: $19.99

Number of Lectures: 138

Number of Published Lectures: 138

Number of Curriculum Items: 138

Number of Published Curriculum Objects: 138

Original Price: ?799

Quality Status: approved

Status: Live

What You Will Learn

To create, update and modify database

To create, update and modify tables

To write data retrieval queries and evaluate the result set

To write data updation and modification queries

To convert data to the best form using normalization techniques

To establish relations and get desired output with multiple tables by using SQL JOINS & UNION

Creating relationships in tables using foreign key and primary key

Who Should Attend

Learners looking to launch their career in Data Science

Target Audiences

Learners looking to launch their career in Data Science

SQL is the most in demand language for professionals working in data science or data analysis field. SQL help to communicate with database and organise raw data in the structured form. SQL also helps to run queries through the data to bring meaningful insights which contributes to decision making.

This course will start from basic concepts of SQL. After basics, concepts of SQL, we have covered different types of operators in SQL and their usage with practical sessions.

Then the course will move to constraints in SQL. Every constraint and SQL keys are covered with the practical example. Then the learners will get to learn the concept of relationships and normalisation in SQL.

In this course, you will get:

· 137 videos to master SQL for data science

· 13+ hours of recorded lectures

· Study materials covering the theory, syntax and practical examples

· Every session covers the theory and practical of each theory

In this course, you will learn:

· To create, update and modify database

· To create, update and modify tables

· To write data retrieval queries and evaluate the result set

· To write data updation and modification queries

· Normalization in SQL

· Creating joins in SQL

· Creating relationships in tables using foreign key and primary key

· AND a lot more concepts

Course Curriculum

Chapter 1: SQL Set Up

Lecture 1: SQL Set Up

Chapter 2: Introduction to SQL

Lecture 1: Introduction To SQL

Lecture 2: Introduction To Database

Lecture 3: Types Of Databases

Lecture 4: What Is A DBMS?

Lecture 5: What Is A Table, Record, Row, Column

Chapter 3: Data Types In SQL

Lecture 1: Data Types In SQL

Lecture 2: STRING Data Types

Lecture 3: NUMERIC Data Types

Lecture 4: DATE & TIME Data Types

Chapter 4: Working With Database

Lecture 1: Pulling list of database

Lecture 2: Creating A Database

Lecture 3: Using A Database

Chapter 5: Working With Tables

Lecture 1: Creating A Table

Lecture 2: Describing A Table

Lecture 3: Pulling The List Of Tables In A Database

Lecture 4: Inserting Records In A Table

Lecture 5: Inserting record without specifying column name

Lecture 6: Inserting Record With Changing Order Of Column

Lecture 7: Inserting Record In Specified Column

Lecture 8: Inserting Multiple Records At A Time

Chapter 6: Fetching Records From A Table

Lecture 1: Fetching Records From All Columns

Lecture 2: Fetching Records From Specific Columns

Lecture 3: Fetching Specific Number Of Records

Lecture 4: Fetching Specific Number Of Records From Specific Record

Chapter 7: Comparison Operators In SQL

Lecture 1: Comparison Operators In SQL

Lecture 2: WHERE Clause

Lecture 3: WHERE Clause With EQUAL TO Operator

Lecture 4: WHERE Clause With NOT EQUAL TO Operator

Lecture 5: WHERE Clause With GREATER THAN Operator

Lecture 6: WHERE Clause With LESS THAN Operator

Lecture 7: WHERE Clause With GREATER THAN or EQUAL TO Operator

Lecture 8: WHERE Clause With LESS THAN or EQUAL TO Operator

Chapter 8: Understanding NULL & NOT NULL Values

Lecture 1: NULL Values

Lecture 2: IS NOT NULL Values

Chapter 9: Logical Operators In SQL

Lecture 1: Logical Operators In SQL

Lecture 2: WHERE Clause With AND Operator

Lecture 3: WHERE Clause With OR Operator

Lecture 4: Combination of AND & OR Operator

Lecture 5: WHERE Clause With IN Operator

Lecture 6: WHERE Clause With NOT IN Operator

Lecture 7: WHERE Clause With BETWEEN Operator

Lecture 8: WHERE Clause With NOT BETWEEN Operator

Lecture 9: BETWEEN Operator With IN Operator

Lecture 10: NOT BETWEEN Operator With IN Operator

Lecture 11: LIKE Operator

Lecture 12: Wildcard Characters

Lecture 13: Using Wildcard Characters With LIKE Operator – Zero Or More Characters

Lecture 14: Using Wildcard Characters With LIKE Operator – Single Character

Lecture 15: NOT LIKE Operator

Lecture 16: Using Wildcard Characters With NOT LIKE Operator – Zero Or More Characters

Lecture 17: Using Wildcard Characters With NOT LIKE Operator – Single Character

Chapter 10: Data Sorting In SQL

Lecture 1: Sorting The Data In Ascending Order

Lecture 2: Sorting The Data In Descending Order

Chapter 11: Constraints in SQL

Lecture 1: Constraints in SQL

Lecture 2: NOT NULL Constraint

Lecture 3: UNIQUE Constraint

Lecture 4: PRIMARY Key

Lecture 5: AUTO_INCREMENT

Lecture 6: AUTO_INCREMENT From A Particular Number

Chapter 12: ALIASES In SQL

Lecture 1: Aliases

Chapter 13: Arithmetic Operators In SQL

Lecture 1: Arithmetic Operators In SQL

Lecture 2: Understanding Arithmetic Operator – ADD

Lecture 3: Understanding Arithmetic Operator – SUBTRACT

Lecture 4: Understanding Arithmetic Operator – MULTIPLY

Lecture 5: Understanding Arithmetic Operator – DIVIDE

Lecture 6: Understanding Arithmetic Operator – MODULUS

Chapter 14: Selecting Distinct Items

Lecture 1: SELECT DISTINCT Statement

Chapter 15: Altering Tables In SQL

Lecture 1: ALTER TABLE statement

Lecture 2: ALTER TABLE – Add One Column Without Constraints

Lecture 3: ALTER TABLE – Add More Than One Column Without Constraints

Lecture 4: ALTER TABLE – Add Column By Position Without Constraints

Lecture 5: ALTER TABLE – Add Column At The First Position

Lecture 6: ALTER TABLE – Add Column At The Last Position

Lecture 7: ALTER TABLE – Add Column At A Specific Position

Lecture 8: ALTER TABLE – Add Column With Constraints

Lecture 9: ALTER TABLE – Adding Column By Position With Constraint

Lecture 10: ALTER TABLE – Adding Constraints In Existing Column

Lecture 11: Changing Column Name & Data Type Without Constraints

Lecture 12: Changing Column Name & Data Type Of More Than One Column Without Constraints

Lecture 13: Changing Column Name & Data Type With Constraint

Lecture 14: Changing Column Name & Data Type Of More Than One Column With Constraint

Chapter 16: MODIFY & DROP

Lecture 1: MODIFY COLUMN

Lecture 2: DROP COLUMN

Instructors

Ammit Kumar Rai
Operations Manager | Product Manager | Instructor

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 0 votes

5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!