Learn Python + JavaScript + Microsoft SQL for Data science

سرفصل های دوره

Learn Python and JavaScript how to use it to analyze, visualize and present data using Microsoft SQL queries

1 - Introduction

1 - Introduction

2 - How to ask great questions

3 - Installing Code Editor

4 - What is JavaScript

5 - Hello World Program

6 - Getting Output

7 - Internal JavaScript

8 - External JavaScript

9 - Inline JavaScript

10 - Async and defer

11 - What is Source code

12 - Learn What is Generative AI Gen AI

2 - JavaScript Basics

13 - Variables

14 - Data Types

15 - Numbers

16 - Strings

17 - String Formatting

3 - JavaScript Operators

18 - Arithmetic operators

19 - Assignment operators

20 - Comparison operators

21 - Logical operators

4 - JavaScript Conditional Statements

22 - Ifelse statement

23 - Ifelseif statement

5 - JavaScript Control Flow Statements

24 - While loop

25 - Dowhile loop

26 - For loop

27 - Coding Exercise

28 - Solution for Coding Exercise

6 - JavaScript Functions

29 - Creating a Function

30 - Function Call

31 - Function with parameters

7 - JavaScript Error Handling

32 - Trycatch

33 - Trycatchfinally

8 - JavaScript ClientSide Validations

34 - On Submit Validation

35 - Input Numeric Validation

9 - Python Introduction

36 - Introduction to Python

37 - Python vs Other Languages

38 - Why Its Popular

39 - Command Line Basics

40 - Python Installation Step By Step

41 - PyCharm IDE Installation

42 - Getting Start PyCharm IDE

43 - First Python Hello World Program

10 - Python Basic

44 - Variables

45 - Data Types

46 - Type Casting

47 - User Inputs

48 - Comments

11 - Python Strings

49 - Strings

50 - String Indexing

51 - String Slicing

52 - String Builtin Functions

53 - Formatting String Dynamic Data

12 - Python Operators

54 - Arithmetic Operators

55 - Assignment Operators

56 - Comparison Operators

57 - Logical Operators

58 - AND Operator

59 - OR Operator

60 - NOT Operator

61 - Booleans

13 - Python Data Structures

62 - Arrays in Earlier

63 - Lists

64 - Add List Items

65 - Remove List Items

66 - Sort Lists

67 - Join Lists

68 - Tuples

69 - Update tuples

70 - Join tuples

71 - Dictionaries

72 - Add Dictionary Items

73 - Remove Dictionary Items

74 - Nested Dictionaries

75 - Sets

76 - Add Set Items

77 - Remove Set Items

78 - Join Set Items

14 - Python Conditional Statements

79 - If Statement

80 - Ifelse Statement

81 - Ifelifelse Statement

82 - If Statement Coding Exercise

15 - Python control flow statements

83 - Flow Charts

84 - While Loops Statement

85 - For Loops Statement

86 - The range Function

87 - Nested Loops

88 - 2D List using Nested Loop

16 - Python core games

89 - Guessing Game

90 - Car Game

17 - Python functions

91 - Creating a Function

92 - Calling a Function

93 - Function with Arguments

18 - Python args KW args for Data Science

94 - args Arbitary Arguments

95 - kwargs Arbitary Keyword Arguments

19 - Python project

96 - Project Overview

97 - ATM Realtime Project

20 - Python Object oriented programming OOPs

98 - Introduction to Class

99 - Create a Class

100 - Calling a Class Object

101 - Class Parameters Objects

102 - Access Modifierstheory

21 - Python Methods

103 - Introduction to methods

104 - Create a method

105 - Method with parameters

106 - Method default parameter

107 - Multiple parameters

108 - Method return keyword

109 - Method Over loading

22 - Python Class and Objects

110 - Introduction to OOPs

111 - Classes and Objects

112 - Class Constructors

23 - Python Inheritance and Polymorphism

113 - Introduction

114 - Inheritance

115 - Polymorphism

116 - Assessment Test

117 - Solution for Assessment Test

24 - Python Encapsulation and Abstraction

118 - Introduction

119 - Access Modifiers public protected private

120 - Encapsulation

121 - Abstraction

25 - Python OOPs Games

122 - Dice Game

123 - Card and Deck Game Playing

26 - Python Modules and Packages

124 - PIP command installations

125 - Modules

126 - Builtin Modules

127 - Packages

128 - Reading CSV files

27 - Python Error Handling

129 - Errors Types of Errors

130 - Try Except Exceptions Handling

131 - TryExceptFinally Blocks

28 - Microsoft SQLMS Introduction

132 - Introduction

133 - Overview of Databases

134 - MSSQL Installation

135 - MSSQL SSMS Installation

136 - Connecting to MSSQL Windows Authentication

137 - Connecting to MSSQL SQL Server Authentication

29 - MS SQL Statements

138 - SQL statement basic

139 - SELECT Statement

140 - SELECT DISTINCT

141 - Column AS Statement

142 - COUNT

30 - MS SQL Filtering Data

143 - SELECT WHERE Clause One

144 - SELECT WHERE Clause Two

145 - ORDER BY

146 - TOP in MSSQL

147 - BETWEEN

148 - IN Operator Condition

149 - LIKE

31 - MS SQL Functions

150 - Overview of GROUP BY

151 - Aggregation Function SUM

152 - Aggregation Function MINMAX

153 - GROUP BY Onetheory

154 - GROUP BY Twopractical

155 - HAVING

32 - MS SQL Joins

156 - Overview of JOINS

157 - Introduction to JOINS

158 - AS Statement

159 - INNER Join

160 - Full Outer Join

161 - Left Outer Join

162 - Right Outer Join

163 - Union

33 - MS SQL Advanced commands

164 - Basic of Advanced SQL Commands

165 - Timestamp

166 - Extract from Timestamp

167 - Mathematical Scalar Functions

168 - String Functions

169 - SubQuery

34 - MS SQL Structure and Keys

170 - Basic of Database and Tables

171 - Data Types

172 - Select Datatype on SSMS

173 - How to set Primary Key

174 - How to set Foreign Key

175 - Create Table using SQL Script

35 - MS SQL Queries

176 - Insert query

177 - Update query

178 - Delete query

36 - MS SQL Structure queries

179 - Alter Table

180 - Drop Table

37 - MS SQL Constraints

181 - Check Constraint

182 - NOT NULL Constraint

183 - UNIQUE Constraint

38 - MS SQL Backup and Restore

184 - Overview of Database and Tables

185 - Creating a Database backup using SSMS

186 - Restoring a Database from backup using SSMS

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy