Introduction To Python Programming
A Quick and Easy Intro into Python Programming
Created by Avinash Jain - CEO of TheCodex.me - Teaching 500,000+ Students how to code
Students: 646318, Price: Free
Do you want to become a programmer?
Or is it that Python interests you?
If you need a quick brush-up, or learning Python for the first time, you've come to the right place!
Let's get started learning one of the most easiest coding languages out there right now. There's no need to fret if you haven't coded before. By the time you finish this course, you'll be a pro at Python!
Python is a great and friendly language to use and learn. It fun, and can be adapted to both small and large projects. Python will cut your development time greatly and overall, its much faster to write Python than other languages. This course will be a quick way to understand all the major concepts of Python programming. You'll be a whiz in no time.
This course is a one-stop-shop for everything you'll need to know to get started with Python, along with a few incentives. We'll begin with the basics of Python, learning about strings, variables, and getting to know the data types. We'll soon move on to the loops and conditions in Python. Afterwards, we'll discuss a bit of file manipulation and functions. By then, you'll know all the basics of Python.
I hope you're excited to dive into the World of Python with this course. Well, what are you waiting for? Let's get started!
Introduction to Databases and SQL Querying
A step by step introduction to the concept of Databases and Introduction to SQL Querying.
Created by Rakesh Gopalakrishnan - Over 260,000 Students
Students: 379414, Price: Free
This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.
Advanced Databases and SQL Querying
Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.
Created by Rakesh Gopalakrishnan - Over 260,000 Students
Students: 198265, Price: Free
This course is an advanced TSQL Querying course. The course expects that student are already aware of basic database concepts and are comfortable writing basic TSQL queries like SELECT, JOINS etc. Students are expected to have taken my previous course (Introduction to databases and Querying). This course cover advanced concepts like Views, Triggers, Dynamic Queries etc. The TSQL Scripts for all demos are uploaded. The course about 2+hours and has assignments at the end of each concept.
If you looking for your next database job or trying to improving your existing database knowledge and apply in your projects, this is the course for you.
Database Design and Management
Learn how to design and manage database with ERD, database generation and reversal with Visual Paradigm.
Created by Visual Paradigm - Design & Management Tool for Business IT System Development
Students: 74819, Price: Free
Database Design and Management is tailor-made for software development teams who need to develop application or software system that require data persistence. There are altogether 14 lectures with more than 2 hours of quality videos. All lectures come with clear voice-over as well as demonstrations to walk you through different tools step by step. We are sure you can master database design and management skills with ease and learn most key features in Visual Paradigm after attending the lectures.
The lectures cover a wide range of contents. Firstly, you will start by an introduction of database design, with description of ERD, entity and column. After gaining a better knowledge about ERD, you can then jump to keys, relationships, database view, triggers and stored procedures. This course also covers database management skills like the generation of database from ERD, database patching and reverse engineering of ERD. Developers may want to study the lecture about ORM for system development with database. Last but not least, the training introduces some best practices in database design and management, as well as the usage of data specification.
Once you have completed this online training, you will know how to design database productively and effectively.
Oracle SQL – A Complete Introduction
Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples.
Created by Ben Brumm - IT Software Consultant
Students: 68457, Price: Free
Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work.
This course will teach you the basics of the SQL language on an Oracle database.
It uses video lectures to teach you Oracle SQL, covering database topics such as:
- Setting up your Oracle environment
- Basic terminology
- Reading data using a SELECT statement
- What can be done using a SELECT statement
- Data types
- Joins, set operators, subqueries
- Inserting, updating and deleting data
- Creating tables
The course materials run for approximately 4 hours and are split into multiple sessions.
It's structured into various sessions and lectures, grouped by functional areas to make it easier to learn.
Why should you take this course?
There are many benefits of taking my Oracle SQL course:
- You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours
- Avoid paying thousands of dollars for training.
- You can also study in your own time!
- Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)!
If you want to learn Oracle SQL from someone who has experience, then take this course.
First Steps in Java
Get a good grasp on the basics of Java programming language: topics ranging from basic syntax to database operations
Created by Holczer Balazs - Software Engineer
Students: 35701, Price: Free
This course is designed for students or anyone else who want to start Java as a programming language. We will consider several topics ranging from installing Java itself to MySQL database operations. The first chapter will be about the basics: loops, decision making, variables and so on. The next chapters will be about exception handling as well as how to deal with input/output operations. Of course, we will consider the object orinted principles: inheritance, polymorphism and encapsulation as well. The last chapter will be about how to connect to a MySQL database and how to make the basic database-related operations: inserting new items, removing items or updating items in the database table.
Hope you will like it!
Building XQuery Apps with the MarkLogic NoSQL Database
A hands-on guide to building apps using the XQuery programming language and the MarkLogic NoSQL database.
Created by MarkLogic University - Free training on the MarkLogic NoSQL database platform.
Students: 15948, Price: Free
This hands-on course is designed to teach you how to quickly build apps using the MarkLogic NoSQL database and the XQuery programming language.
You will learn to use core features of the MarkLogic platform including:
- Architecture and scalability
- Managing data (XML, JSON, Binaries, text, RDF triples and document metadata)
- CRUD (Create, Read, Update, Delete)
- Performing ACID database transactions
- Search (including geospatial search, geoencoding, and map integration)
- Security (MarkLogic provides a Common Criteria certified security model)
To be successful in the course, students should have familiarity with databases, at least one programming language, and some web development background. Students should also complete the free prerequisite course on Udemy titled Fundamentals of the MarkLogic NoSQL Database.
The course is designed to be very hands-on. Each video discussion is followed with a hands-on lab. All the necessary software is free to download and comes with a free developer license.
Course materials including sample data, code examples, and step-by-step instructions for completing the hands-on labs are provided via a free download.
Learn C# Programming With Database from Scratch
Detailed C# Programming with Database
Created by Maxwell Taprah - Software Engineering Tutor
Students: 12400, Price: Free
Detailed and structure course for students to learn how to develop window application using CSharp(C#) Programming Language with SQL Server Database.Students will Learn Overview of IDE - Integrated Development Environment Visual Studio 2015. Then will Create their First Window Form Application,Design Login Form,Add Logic to open a new Form,Design Dashboard ,SQL Server Database Connectivity,Perform CRUD Functionalities,Bonus Video,Conclusion
Database programming for intermediates
From DBMS mechanism (Transaction, Rollback, Index, View) to Database design (Design process, Normalization)
Created by Shota Fukuda - Web programming, Robot programming
Students: 4763, Price: Free
This course’s target and goal is as follows
● IT engineer already have basic SQL skill related to data manipulation,
and want to get more knowledge on DBMS itself (such as transaction, DDL, performance, design)
● IT engineer want to know advanced function to enhance performance and safety
● Understand advanced DBMS knowledge, and how to use it
● Be able to design and develop simple Web app based on advanced DBMS knowledge
and design skill
This course’s table contents is as follows
1 Course Introduction
1.1 Self introduction
1.2 Target and goal
1.3 Contents overview
1.4 Contents detail
2.1 Issue overview – suspension and interruption –
2.2 Suspension issue detail and solution
2.2.1 Issue detail – suspension –
2.2.2 Solution overview – atomicity –
2.2.3 Solution detail – commit and rollback –
2.2.4 Supplementary explanation1 – how to use transaction –
2.2.5 Supplementary explanation2 – how to release auto commit mode –
2.3 Interruption issue detail and solution
2.3.1 Issue detail – interruption –
2.3.2 Solution overview – isolation –
2.3.3 Solution detail – lock –
2.3.4 Supplementary explanation1 – isolation level –
2.3.5 Supplementary explanation2 – dead lock –
2.4 Chapter summary
3 Create table
3.1 SQL statement
3.1.1 2 Roles to use database
3.1.2 3 types of command
3.1.3 What is DCL ?
3.2 Create table
3.2.1 Basics of table creation
3.2.2 Setting of default value
3.2.3 DROP TABLE statement
3.2.4 ALTER TABLE statement
3.3.1 Prepare for human error
3.3.2 3 basic constraints
3.3.3 Primary key constraint
3.4 Foreign key and referential integrity
3.5.1 Referential integrity break
3.5.2 Root cause of referential integrity break
3.5.3 Foreign key constraint
3.5 Chapter summary
4 Additional functions
4.1 Performance enhancement
4.1.1 Issue detail – Low performance –
4.1.2 Solution overview – Index –
4.1.3 Solution detail – How to use index –
4.2 Convenience enhancement
4.2.1 Issue detail – Complex SQL statement –
4.2.2 Solution overview – View –
4.2.3 Solution detail – How to use view –
4.2.4 View's demerit
4.3 Safety enhancement
4.3.1 Issue detail – Data elimination –
4.3.2 Solution overview – Back up –
4.3.3 Solution detail – Offline back up and Online back up –
4.3.4 Roll forward
5 Database design
5.1 Database design process
5.1.1 Database design process overview
5.1.2 Table design process
5.2 Requirement of household account management system
5.2.1 Hearing item of requirement phase
5.2.2 Concrete example of requirement
5.2.3 Important point of requirement
5.3 Conceptual design
5.3.1 Conceptual design process
5.3.2 Entity-Relationship diagram
5.3.3 Rule to make ER diagram
5.3.4 Process to list up all entities
5.4 Logical design
5.4.1 Logical design process
5.4.2 Break up many-to-many relationship into one-to-many
5.4.3 Arrange attribute of entity
5.5 Normalization process
5.5.1 Normalization level
5.5.2 Unnormalized form
5.5.3 Transform to first normalized form
5.5.4 Functional dependency
5.5.5 Transform to second normalized form
5.5.6 Transform to third normalized form
5.5.7 Tips to normalize table
5.6 Physical design
5.6.1 Physical design process
5.6.2 Household account management system's physical design
5.7 Make use of normalized data
5.7.1 Start using household account management system
5.7.2 Engineer's mission
5.8 Chapter summary
Finally, thank you for enrolling this course. Let's start learning database design fundamentals!
Python Interfacing with MySql
Python databses programming using MySQL
Created by Mayur Sonar - Professor in Engineering College
Students: 3075, Price: Free
MySQL is one of the most popular database management systems (DBMSs) on the market today. It ranked second only to the Oracle DBMS in this year’s DB-Engines Ranking. As most software applications need to interact with data in some form, programming languages like Python provide tools for storing and accessing these data sources.
Using the techniques discussed in this course, you’ll be able to efficiently integrate a MySQL database with a Python application. You’ll develop a small MySQL database for a movie rating system and learn how to query it directly from your Python code.
By the end of this course, you’ll be able to:
Identify unique features of MySQL
Connect your application to a MySQL database
Query the database to fetch required data
Handle exceptions that occur while accessing the database
Use best practices while building database applications
To get the most out of this course, you should have a working knowledge of Python concepts like for loops, functions, exception handling, and installing Python packages using pip. You should also have a basic understanding of relational database management systems and SQL queries like SELECT, DROP, CREATE, and JOIN.
SQL stands for Structured Query Language and is a widely used programming language for managing relational databases. You may have heard of the different flavors of SQL-based DBMSs. The most popular ones include MySQL, PostgreSQL, SQLite, and SQL Server. All of these databases are compliant with the SQL standards but with varying degrees of compliance.
Being open source since its inception in 1995, MySQL quickly became a market leader among SQL solutions. MySQL is also a part of the Oracle ecosystem. While its core functionality is completely free, there are some paid add-ons as well. Currently, MySQL is