[Last updated 4/2024] Full Stack Data Science Developer Course from scratch (Udemy – Engsub)
About Course
Views
Step into the dynamic world of data science with the “
Full Stack Data Science Developer Course from Scratch
“
What you’ll learn:
Learn to write python coding for Data Science applications
Get a job as a junior web developer
Create your own stunning, layouts for awesome websites
Preparing Python coding for Data Science projects and Libraries
Master client-end design using CSS, back-end development Python coding with Microsoft SQL
Apply CSS, Python for data science and Microsoft SQL database queries on real-world tasks
Create fully function web apps using Python, CSS and Microsoft SQL
Write master code on machine learning and analytical programs
learn what is Generative AI for future learning
Description:
Unlock your potential in the world of data science with the “
Full Stack Data Science Developer Course from Scratch
“. This all-inclusive course covers everything you need to become a proficient
data scientist
and developer, from the basics of programming and data manipulation to advanced machine learning and deployment techniques. Designed for both beginners and those looking to upskill, this course offers a step-by-step approach to mastering data science tools and technologies.
Link gốc:
https://www.udemy.com/course/complete-css-python-and-microsoft-sql-course-from-scratch/
Time Course:
24 hours (200 Lectures)
Instructor
: Metla Sudha Sekhar
Total Weight:
9.43 GB
** Note
:
Chú ý:
Course Content
28 – MS SQL Functions
-
001 Overview of GROUP BY.mp4
08:12 -
002 Aggregation Function – SUM().mp4
11:51 -
003 Aggregation Function – MIN()-MAX().mp4
08:21 -
004 GROUP BY – One(theory).mp4
10:54 -
005 GROUP BY – Two(practical).mp4
13:54 -
006 HAVING.mp4
14:45
19 – Python Class and Objects
-
001 Introduction to OOPs.mp4
04:42 -
002 Classes and Objects.mp4
07:55 -
003 Class Constructors.mp4
06:51
21 – Python Encapsulation and Abstraction
-
001 Introduction.mp4
02:52 -
002 Access Modifiers (public, protected, private).mp4
20:29 -
003 Encapsulation.mp4
06:43 -
004 Abstraction.mp4
07:07
22 – Python OOPs Games
-
001 Dice Game.mp4
06:24 -
002 Card and Deck Game Playing.mp4
06:51
23 – Python Modules and Packages
-
001 PIP command installations.mp4
11:32 -
002 Modules.mp4
12:22 -
003 Built-in Modules.mp4
03:13 -
004 Packages.mp4
07:30 -
005 Reading CSV files.mp4
10:33
24 – Python Error Handling
-
001 Errors – Types of Errors.mp4
07:44 -
002 Try – Except Exceptions Handling.mp4
07:15 -
003 Try-Except-Finally Blocks.mp4
06:34
25 – Microsoft SQL Introduction
-
001 Introduction.mp4
03:54 -
002 Overview of Databases.mp4
08:56 -
003 MSSQL Installation.mp4
27:19 -
004 MSSQL SSMS Installation.mp4
07:50 -
005 Connecting to MS-SQL (Windows Authentication).mp4
04:40 -
006 Connecting to MS-SQL (SQL Server Authentication).mp4
05:34
26 – MicroSoft SQL Statements
-
001 SQL statement basic.mp4
12:53 -
002 SELECT Statement.mp4
16:28 -
003 SELECT DISTINCT.mp4
16:53 -
004 Column AS Statement.mp4
09:12 -
005 COUNT.mp4
09:41
27 – MS SQL Filtering Data
-
001 SELECT WHERE Clause – One.mp4
04:58 -
002 SELECT WHERE Clause – Two.mp4
11:37 -
003 ORDER BY.mp4
09:33 -
004 TOP in MSSQL.mp4
05:38 -
005 BETWEEN.mp4
13:12 -
006 IN Operator – Condition.mp4
08:12 -
007 LIKE.mp4
12:53
18 – Python Methods
-
001 Introduction to methods.mp4
05:49 -
002 Create a method.mp4
07:13 -
003 Method with parameters.mp4
11:41 -
004 Method default parameter.mp4
06:20 -
005 Multiple parameters.mp4
05:19 -
006 Method return keyword.mp4
04:23 -
007 Method Over loading.mp4
05:05
29 – MS SQL Joins
-
001 Overview of JOINS.mp4
06:39 -
002 Introduction to JOINS.mp4
07:07 -
003 AS Statement.mp4
03:44 -
004 INNER Join.mp4
12:20 -
005 Full Outer Join.mp4
07:23 -
006 Left Outer Join.mp4
05:58 -
007 Right Outer Join.mp4
07:51 -
008 Union.mp4
07:24
30 – MS SQL Advanced commands
-
001 Basic of Advanced SQL Commands.mp4
04:20 -
002 Timestamp.mp4
11:39 -
003 Extract from Timestamp.mp4
06:21 -
004 Mathematical Scalar Functions.mp4
11:07 -
005 String Functions.mp4
16:39 -
006 SubQuery.mp4
07:08
31 – MS SQL Structure and Keys
-
001 Basic of Database and Tables.mp4
09:41 -
002 Data Types.mp4
10:54 -
003 Select Datatype on SSMS.mp4
05:05 -
004 How to set Primary Key.mp4
05:36 -
005 How to set Foreign Key.mp4
12:11 -
006 Create Table using SQL Script.mp4
07:12
32 – MS SQL Queries
-
001 Insert query.mp4
06:28 -
002 Update query.mp4
08:01 -
003 Delete query.mp4
06:34
33 – MS SQL Structure queries
-
001 Alter Table.mp4
04:19 -
002 Drop Table.mp4
02:55
34 – MS SQL Constraints
-
001 Check Constraint.mp4
14:06 -
002 NOT NULL Constraint.mp4
11:46 -
003 UNIQUE Constraint.mp4
11:15
35 – MS SQL Backup and Restore
-
001 Overview of Database and Tables.mp4
03:31 -
002 Creating a Database backup using SSMS.mp4
10:50 -
003 Restoring a Database from backup using SSMS.mp4
07:35
10 – python Data Structures
-
009 Join tuples.mp4
01:50 -
017 Join Set Items.mp4
03:55 -
016 Remove Set Items.mp4
01:27 -
015 Add Set Items.mp4
03:07 -
014 Sets.mp4
03:39 -
013 Nested Dictionaries.mp4
04:00 -
012 Remove Dictionary Items.mp4
02:41 -
011 Add Dictionary Items.mp4
04:26 -
010 Dictionaries.mp4
06:02 -
001 Arrays in Earlier.mp4
01:45 -
008 Update tuples.mp4
06:58 -
007 Tuples.mp4
07:43 -
006 Join Lists.mp4
07:35 -
005 Sort Lists.mp4
02:46 -
004 Remove List Items.mp4
01:16 -
003 Add List Items.mp4
02:54 -
002 Lists.mp4
05:37
02 – CSS Basic
-
001 Inline CSS.mp4
05:56 -
002 Internal CSS.mp4
05:23 -
003 External CSS.mp4
09:55 -
004 CSS Classes.mp4
09:24 -
005 CSS IDs.mp4
06:14 -
006 Colors.mp4
08:00 -
007 Backgrounds.mp4
03:34 -
008 Floating.mp4
08:38 -
009 PosiPositioning tioning.mp4
05:53 -
010 Margins.mp4
07:03 -
011 Padding.mp4
03:52 -
012 Borders.mp4
03:16
03 – CSS Intermediate
-
001 Styling Text.mp4
06:34 -
002 Aligning Text.mp4
03:58 -
003 Styling Links.mp4
10:02 -
004 Font Family.mp4
07:05 -
005 Font Styles.mp4
03:14 -
006 Applying Google Fonts.mp4
07:05 -
007 Box Model.mp4
08:49 -
008 Icons.mp4
08:42 -
009 Tables.mp4
15:53 -
010 Navigation-Menu.mp4
11:11 -
011 Dropdowns.mp4
15:21
04 – CSS Advanced
-
001 Advanced Selectors.mp4
05:00 -
002 Forms.mp4
16:33 -
003 Website Layout.mp4
20:53 -
004 Rounded Corners.mp4
08:00 -
005 Color Keywords.mp4
05:45 -
006 Animations.mp4
07:33 -
007 Pseudo Classes.mp4
03:00 -
008 Gradients.mp4
02:51 -
009 Shadows.mp4
03:28 -
010 Calculations.mp4
05:13 -
011 Creating Responsive Page.mp4
06:11
05 – CSS Expert
-
001 Button Styles.mp4
06:04 -
002 Pagination.mp4
06:55 -
003 Multiple Columns.mp4
05:43 -
004 Image Reflection.mp4
02:40 -
005 UI – UX Design.mp4
09:11 -
006 Social Media Icons.mp4
07:55 -
007 External CSS style adding.mp4
05:50
06 – Python Introduction
-
001 Introduction to Python.mp4
02:16 -
002 Python vs. Other Languages.mp4
03:48 -
003 Why Its Popular.mp4
03:33 -
004 Command Line Basics.mp4
06:43 -
005 Python Installation (Step By Step).mp4
05:47 -
006 PyCharm IDE Installation.mp4
07:56 -
007 Getting Start PyCharm IDE.mp4
04:44 -
008 First Python Hello World Program.mp4
07:22
07 – Python Basic
-
001 Variables.mp4
16:18 -
002 Data Types.mp4
13:09 -
003 Type Casting.mp4
07:04 -
004 User Inputs.mp4
07:54 -
005 Comments.mp4
03:53
08 – Python Strings
-
001 Strings.mp4
04:58 -
002 String Indexing.mp4
05:21 -
003 String Slicing.mp4
03:52 -
004 String Built-in Functions.mp4
08:36 -
005 Formatting String (Dynamic Data).mp4
04:35
09 – Python Operators
-
001 Arithmetic Operators.mp4
07:48 -
002 Assignment Operators.mp4
04:40 -
003 Comparison Operators.mp4
05:20 -
004 Logical Operators.mp4
02:01 -
005 AND Operator.mp4
04:09 -
006 NOT Operator.mp4
02:51 -
007 Booleans.mp4
02:05
01 – Introduction
-
02:43
-
01:21
-
003 Introduction CSS.mp4
06:01 -
004 Choosing Code Editor.mp4
03:28 -
005 Installing Code Editor (Sublime Text).mp4
03:48 -
006 CSS Syntax.mp4
04:59 -
007 Creating a first page with CSS Style.mp4
12:30 -
008 What is Source code.mp4
08:47 -
009 Learn What is Generative AI Gen AI.mp4
14:06
11 – Python Conditional Statements
-
001 If Statement.mp4
03:20 -
002 If-else Statement.mp4
04:08 -
003 If-elif-else Statement.mp4
03:58 -
004 If Statement Coding Exercise.mp4
04:40
12 – Python control flow statements
-
001 Flow Charts.mp4
06:25 -
002 While Loops Statement.mp4
09:42 -
003 For Loops Statement.mp4
06:18 -
004 The range() Function.mp4
03:37 -
005 Nested Loops.mp4
03:29 -
006 2D List using Nested Loop.mp4
03:30
13 – Python core games
-
001 Guessing Game.mp4
07:14 -
002 Car Game.mp4
09:40
14 – Python functions
-
001 Creating a Function.mp4
03:09 -
002 Calling a Function.mp4
06:03 -
003 Function with Arguments.mp4
04:58
15 – Python args, KW args for Data Science
-
001 args, Arbitary Arguments.mp4
04:05 -
002 kwargs, Arbitary Keyword Arguments.mp4
06:01
16 – Python project
-
001 Project Overview.mp4
03:29 -
002 ATM Realtime Project.mp4
13:22
17 – Python Object oriented programming [OOPs]
-
001 Introduction to Class.mp4
06:45 -
002 Create a Class.mp4
09:28 -
003 Calling a Class Object.mp4
07:51 -
004 Class Parameters – Objects.mp4
05:14 -
005 Access Modifiers(theory).mp4
10:03