Practical Front & Backend Application Development
☑ Install and setup Microsoft SQL Server
☑ Setup Python Development Environment
☑ Build database-driven apps with SQL Server and C#
☑ Build database-driven apps with SQL Server and Python
☑ Create database and table
☑ Design form with dataset
Nearly all of the dynamic websites you use today are database-driven applications. Every website or application that persists data about you in a database to tailor the user experience to you is a database-driven app.
Here are just a few of the thousands out there:
Quora saves your history and interests in a database so it can remember the questions and answers you’ve posted. When I click submit on this answer, it will go into a database. When you asked this question, it went into a database.
Facebook saves your data so it knows who your friends are, the posts you have made and liked.
Twitter saves all of your tweets in a database, much like Facebook.
Uber uses databases to keep track of who needs to be picked up, who just got picked up, who needs to be charged how much, and how much to pay each driver, etc.
When you submit the login form, the web server looks up your account in a database and if it finds a matching username and password, then you are authenticated and logged in. While you are using the applications, almost all of your actions are recorded in the application’s database. This is how the application knows what to present to you on the screen, what to recommend to you next, or otherwise present the features that the application was developed to deliver.
The SQL Server is a relational database management system from Microsoft. The system is designed and built is to manage and store information. The system supports various business intelligence operations, analytics operations, and transaction processing.
C# is a programming language. C# can be used to create a number of different programs and applications: mobile apps, desktop apps, cloud-based services, websites, enterprise software and games. Lots and lots of games.
Python is a widely-used, interpreted, object-oriented, and high-level programming language with dynamic semantics, used for general-purpose programming.
English
Language
Visual Studio Setup
Course Introduction
What is Visual Studio
Visual Studio Installation Requirements
Installing Visual Studio
SQL Server Setup
What is SQL Server
SQL Server Installation requirements
SQL Server Editions
Download SQL server
install SQL Server
Installing SQL Server Management Studio
Connecting SSMS to SQL Server
Build a Login Form
Project Introduction
Create a project with a form
Customize form and controls
Add a logged – in -form
Create a database and table
Populate table
Add database to visual studio project
Writing C# Code logic: Part 1
Writing C# Code logic: Part 2
Download Project Code
Build an Image Upload App
Project Introduction
Create a database and table
Create a new project and add a database
Design form with dataset
Writing C# Code logic
Download Project Code
Building Database App with Python and SQL Server
What is Python
Installing Python on Macs
Installing Python on Windows
Installing Python on Linux
What we will create
What is CRUD
Application design sketch
Installing Text Editor
Creating a project directory and Python file
Creating application interface: Part 1
Creating application interface: Part 2
Creating application interface: Part 3
Creating application interface: Part 4
Creating application interface: Part 5
Adding comments to code
Create a new database and table
Create database configuration file
Create a virtual environment
Connect Python file to database
Create a class and methods
Add more methods to class
Create more functions
Activate button widgets
Interact with database from app: Part 1
Interact with database from app: Part 2
Project Source Code