SQLite for Beginners

Focused View

Dermot Downey

34:33

91 View

1 - Introduction

1 - The Concept of Databases.mp4

01:13

2 - Introducing SQLite Databases.mp4

02:26

3 - Managing Databases.mp4

01:45

2 - SQL Structured Query Language

4 - Introducing SQL.mp4

01:45

4 - SQL-Commands.pdf

4 - sample-database.zip

5 - Creating and Dropping Tables.mp4

02:15

6 - SELECT Searching for Information.mp4

03:43

7 - DELETE Deleting information.mp4

01:46

8 - IN Running Subqueries.mp4

01:25

9 - ORDER BY Sorting the results of searches.mp4

01:37

10 - GROUP BY Grouping information from your database.mp4

01:13

11 - INSERT INTO Adding Data to the Database.mp4

02:03

12 - UPDATE Updating Records.mp4

01:21

13 - JOINS Combining Multiple Data Tables.mp4

04:24

3 - Working with Python

14 - Creating a new database and table.mp4

03:05

14 - Python-Handout.pdf

15 - Entering New Data.mp4

01:50

16 - Running Searches.mp4

02:42

Description

Improve your career by learning about SQL databases

What You'll Learn?

Learn to work with SQLite databases
Learn the fundamentals of writing SQL queries
Learn SQL commands such as SELECT, DELETE, CREATE, DROP, JOIN, and many more
Learn how to use SQL to improve your career
Learn how to use databases in your Python programs

Who is this for?

Beginner SQL Developers

Anyone interested in database design

Professionals looking to use simple databases in their work

More details

Description
Learn the SQL language and work with data using SQLite databases

Every year, SQL appears consistently as one of the most in-demand languages to learn. Knowing how to analyze data is one of the top tech skills companies look for, and it is one of the fastest ways for you to improve your career.

Whether you are a data scientist, business or financial analyst, or a programmer, being able to import data into a database and run advanced queries on it to solve complex problems will put you ahead of the crowd.

In this course you will learn to use SQLite databases, the worlds most popular database system. The commands you will learn are directly relevant to the workplace, and are used across multiple industries where data processing and business reporting is needed.

Using software which is 100% free, you will learn:
- What databases are and how they store information
- How to create new databases and tables
- How to import data into the database
- How to run very precise searches on your data, and pull out just the results you need
- How to run calculations on your data

SQLite works very well with all major programming languages, so in this course you will also learn how Python can be used to query your database. You will learn how to easily begin working with data in your scripts and programs.

All of the commands we cover are included in downloadable guides, making it easy for you to take and read them when writing your own queries.

If youâ€™ve ever felt that you want to know more about databases, SQL or SQLite, then this is the course for you. I look forward to helping you with improving your career!
Who this course is for:
Beginner SQL Developers
Anyone interested in database design
Professionals looking to use simple databases in their work

User Reviews

Rating

average 0

Total votes0

Focused display

SQLite

Dermot Downey

Instructor's Courses

Dermot has over 15 years experience in IT and network administration in the pharmaceutical and financial industries. He has also been an educator on topics such as IT security and Unix administration.He holds certifications in Cisco networking, network security and Linux administration, and has supported Red Hat, Debian and AIX systems in professional enterprises.He believes in having fun in your work and enjoying what you do. He is passionate about IT systems, and believes strongly in passing this passion and skillset on to the next generation of IT enthusiast.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.