Complete Css, Python And Microsoft Sql Course From Scratch

Web Design and Development Complete Course with CSS, Python Programming and Microsoft SQL Database

What you'll learn
Build coding for webapps
Get a job as a junior web developer
Create your own stunning, layouts for awesome websites
Start their own online business
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
Requirements
No programming experience needed. You will learn everything you need to know
No software is required in advance of the course (all software used in the course is free)
No pre-knowledge is required - you will learn from basic
Description
In this course, we will learn the basic tools that every Web developer needs to know. We will start from the scratch by learning how to implement modern web development with CSS, Python and Microsoft SQL.Learn to code CSS3, Python and Microsoft SQL is The first step to Coding you need to learn to succeed in web development, it is easy to learn and understand our online CSS, Python and Microsoft SQL Training course is designed for you with the complete steps to require learn Complete Developer topics. Mr. Sekhar Metla [MCP - Microsoft Certified Professional] will explain to you even complex topics to simplify and teach you even beginners can easily understand with real-time examples.At this Development course is without a doubt the most comprehensive web development course available online. Even if you have zero programming experience, this course will take you from beginner to mastery. Here's why:The course is taught by the lead instructor having 20+ years of professional experience.Become a Full-Stack Web Developer with just ONE course. Web Design and Development Complete Course with CSS, Python Programming and Microsoft SQL DatabaseThe course has been updated to be trending technology ready and you'll be learning the latest tools and technologies used at large companies such as Apple, Facebook, Google and Netflix.The curriculum was developed over a period of four years, with comprehensive student testing and feedback who are working and applying these coding examples.We've taught many students how to code and many have gone on to change their lives by becoming professional developers or starting their own tech startup.The course is constantly updated with new content, with new projects and modules determined by students - that's you!We'll take you step-by-step through engaging video tutorials and teach you everything you need to know to succeed as a web developer.The course includes HD video tutorials and builds your programming knowledge while making real-world websites and web apps.Throughout this comprehensive course, we cover a massive amount of tools and technologies, including:CSS3Front-End Web DevelopmentClient-side styleFont stylesBox modelAnimationsFormsShadowsCalculationand more..PythonVariablesData typesStatementsControl flow statementsCode DevelopmentSequencesWeb DesignFunctionsObject oriented programming [OOPs]ClassMethodsInheritancePolymorphismError Handlingand more..Microsoft SQLSQL installationDatabaseTablesSQL functionsSQL statementsSQL operatorsSQL joinsSQL advancedfiltering dataanalyzing datagrouping dataReportsand more..By the end of this course, you will be fluently programming and be ready to make any website you can dream of.Sign up today, and look forward to:HD Video LecturesCode Challenges and Coding ExercisesBeautiful Real-World dynamic ProjectsABOUT YOUR INSTRUCTORSekhar Metla is a software engineer with 20 years of professional experience. He is the author of several online-selling courses with more than 30,000+ students in many countries. He has a Master of Science in Computer Applications as Software Engineering. His students describe him as passionate, pragmatic, and motivational in his teaching.What are you waiting join now to start learning how to make your own Developer Career TODAY :)

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 How to ask great questions

Lecture 3 Introduction CSS

Lecture 4 Choosing Code Editor

Lecture 5 Installing Code Editor (Sublime Text)

Lecture 6 CSS Syntax

Lecture 7 Creating a first page with CSS Style

Section 2: CSS Basic

Lecture 8 Inline CSS

Lecture 9 Internal CSS

Lecture 10 External CSS

Lecture 11 CSS Classes

Lecture 12 CSS IDs

Lecture 13 Colors

Lecture 14 Backgrounds

Lecture 15 Floating

Lecture 16 PosiPositioning tioning

Lecture 17 Margins

Lecture 18 Padding

Lecture 19 Borders

Section 3: 3. CSS Intermediate

Lecture 20 Styling Text

Lecture 21 Aligning Text

Lecture 22 Styling Links

Lecture 23 Font Family

Lecture 24 Font Styles

Lecture 25 Applying Google Fonts

Lecture 26 Box Model

Lecture 27 Icons

Lecture 28 Tables

Lecture 29 Navigation-Menu

Lecture 30 Dropdowns

Section 4: CSS Advanced

Lecture 31 Advanced Selectors

Lecture 32 Forms

Lecture 33 Website Layout

Lecture 34 Rounded Corners

Lecture 35 Color Keywords

Lecture 36 Animations

Lecture 37 Pseudo Classes

Lecture 38 Gradients

Lecture 39 Shadows

Lecture 40 Calculations

Lecture 41 Creating Responsive Page

Section 5: 5. CSS Expert

Lecture 42 Button Styles

Lecture 43 Pagination

Lecture 44 Multiple Columns

Lecture 45 Image Reflection

Lecture 46 UI - UX Design

Lecture 47 Social Media Icons

Lecture 48 External CSS style adding

Section 6: Python Introduction

Lecture 49 Introduction to Python

Lecture 50 Python vs. Other Languages

Lecture 51 Why Its Popular

Lecture 52 Command Line Basics

Lecture 53 Python Installation (Step By Step)

Lecture 54 PyCharm IDE Installation

Lecture 55 Getting Start PyCharm IDE

Lecture 56 First Python Hello World Program

Section 7: Python Basic

Lecture 57 Variables

Lecture 58 Data Types

Lecture 59 Type Casting

Lecture 60 User Inputs

Lecture 61 Comments

Section 8: Python Strings

Lecture 62 Strings

Lecture 63 String Indexing

Lecture 64 String Slicing

Lecture 65 String Built-in Functions

Lecture 66 Formatting String (Dynamic Data)

Section 9: Python Operators

Lecture 67 Arithmetic Operators

Lecture 68 Assignment Operators

Lecture 69 Comparison Operators

Lecture 70 Logical Operators

Lecture 71 AND Operator

Lecture 72 NOT Operator

Lecture 73 Booleans

Section 10: python Data Structures

Lecture 74 Arrays in Earlier

Lecture 75 Lists

Lecture 76 Add List Items

Lecture 77 Remove List Items

Lecture 78 Sort Lists

Lecture 79 Join Lists

Lecture 80 Tuples

Lecture 81 Update tuples

Lecture 82 Join tuples

Lecture 83 Dictionaries

Lecture 84 Add Dictionary Items

Lecture 85 Remove Dictionary Items

Lecture 86 Nested Dictionaries

Lecture 87 Sets

Lecture 88 Add Set Items

Lecture 89 Remove Set Items

Lecture 90 Join Set Items

Section 11: Python Conditional Statements

Lecture 91 If Statement

Lecture 92 If-else Statement

Lecture 93 If-elif-else Statement

Lecture 94 If Statement Coding Exercise

Section 12: Python control flow statements

Lecture 95 Flow Charts

Lecture 96 While Loops Statement

Lecture 97 For Loops Statement

Lecture 98 The range() Function

Lecture 99 Nested Loops

Lecture 100 2D List using Nested Loop

Section 13: Python core games

Lecture 101 Guessing Game

Lecture 102 Car Game

Section 14: Python functions

Lecture 103 Creating a Function

Lecture 104 Calling a Function

Lecture 105 Function with Arguments

Section 15: Python args, KW args for Data Science

Lecture 106 args, Arbitary Arguments

Lecture 107 kwargs, Arbitary Keyword Arguments

Section 16: Python project

Lecture 108 Project Overview

Lecture 109 ATM Realtime Project

Section 17: 17. Python Object oriented programming [OOPs]

Lecture 110 Introduction to Class

Lecture 111 Create a Class

Lecture 112 Calling a Class Object

Lecture 113 Class Parameters - Objects

Lecture 114 Access Modifiers(theory)

Section 18: Python Methods

Lecture 115 Introduction to methods

Lecture 116 Create a method

Lecture 117 Method with parameters

Lecture 118 Method default parameter

Lecture 119 Multiple parameters

Lecture 120 Method return keyword

Lecture 121 Method Over loading

Section 19: 19. Python Class and Objects

Lecture 122 Introduction to OOPs

Lecture 123 Classes and Objects

Lecture 124 Class Constructors

Section 20: Python Inheritance and Polymorphism

Lecture 125 Introduction

Lecture 126 Inheritance

Lecture 127 Polymorphism

Lecture 128 Assessment Test

Lecture 129 Solution for Assessment Test

Section 21: Python Encapsulation and Abstraction

Lecture 130 Introduction

Lecture 131 Access Modifiers (public, protected, private)

Lecture 132 Encapsulation

Lecture 133 Abstraction

Section 22: Python OOPs Games

Lecture 134 Dice Game

Lecture 135 Card and Deck Game Playing

Section 23: Python Modules and Packages

Lecture 136 PIP command installations

Lecture 137 Modules

Lecture 138 Built-in Modules

Lecture 139 Packages

Lecture 140 Reading CSV files

Section 24: Python Error Handling

Lecture 141 Errors – Types of Errors

Lecture 142 Try - Except Exceptions Handling

Lecture 143 Try-Except-Finally Blocks

Section 25: Microsoft SQL Introduction

Lecture 144 Introduction

Lecture 145 Overview of Databases

Lecture 146 MSSQL Installation

Lecture 147 MSSQL SSMS Installation

Lecture 148 Connecting to MS-SQL (Windows Authentication)

Lecture 149 Connecting to MS-SQL (SQL Server Authentication)

Section 26: MS SQL Statements

Lecture 150 SQL statement basic

Lecture 151 SELECT Statement

Lecture 152 SELECT DISTINCT

Lecture 153 Column AS Statement

Lecture 154 COUNT

Section 27: MS SQL Filtering Data

Lecture 155 SELECT WHERE Clause – One

Lecture 156 SELECT WHERE Clause – Two

Lecture 157 ORDER BY

Lecture 158 TOP in MSSQL

Lecture 159 BETWEEN

Lecture 160 IN Operator - Condition

Lecture 161 LIKE

Section 28: MS SQL Functions

Lecture 162 Overview of GROUP BY

Lecture 163 Aggregation Function – SUM()

Lecture 164 Aggregation Function – MIN()-MAX()

Lecture 165 GROUP BY – One(theory)

Lecture 166 GROUP BY – Two(practical)

Lecture 167 HAVING

Section 29: MS SQL Joins

Lecture 168 Overview of JOINS

Lecture 169 Introduction to JOINS

Lecture 170 AS Statement

Lecture 171 INNER Join

Lecture 172 Full Outer Join

Lecture 173 Left Outer Join

Lecture 174 Right Outer Join

Lecture 175 Union

Section 30: MS SQL Advanced commands

Lecture 176 Basic of Advanced SQL Commands

Lecture 177 Timestamp

Lecture 178 Extract from Timestamp

Lecture 179 Mathematical Scalar Functions

Lecture 180 String Functions

Lecture 181 SubQuery

Section 31: MS SQL Structure and Keys

Lecture 182 Basic of Database and Tables

Lecture 183 Data Types

Lecture 184 Select Datatype on SSMS

Lecture 185 How to set Primary Key

Lecture 186 How to set Foreign Key

Lecture 187 Create Table using SQL Script

Section 32: MS SQL Queries

Lecture 188 Insert query

Lecture 189 Update query

Lecture 190 Delete query

Section 33: MS SQL Structure queries

Lecture 191 Alter Table

Lecture 192 Drop Table

Section 34: MS SQL Constraints

Lecture 193 Check Constraint

Lecture 194 NOT NULL Constraint

Lecture 195 UNIQUE Constraint

Section 35: MS SQL Backup and Restore

Lecture 196 Overview of Database and Tables

Lecture 197 Creating a Database backup using SSMS

Lecture 198 Restoring a Database from backup using SSMS

Beginner CSS, Python coding and Microsoft SQL developers curious about data science development,Anyone who wants to generate new income streams,Anyone who wants to build websites,Anyone who wants to become financially independent,Anyone who wants to start their own business or become freelance,Anyone who wants to become a Full stack web developer