Basic SQL CRUD
Basic SQL CRUD, available at $19.99, has an average rating of 4.67, with 14 lectures, 3 quizzes, based on 3 reviews, and has 10 subscribers.
You will learn about Creating and dropping tables and views in databases Inserting and deleting records into tables in databases Updating records in tables in databases Using transactions to minimize mistakes with database operations Basics of importing data into and exporting data out of databases This course is ideal for individuals who are Beginners with SQL (all platforms) or People newly bestowed with access to make changes to tables in a database or Anyone who has seen SQL statements beyond SELECT and wants to know what these do It is particularly useful for Beginners with SQL (all platforms) or People newly bestowed with access to make changes to tables in a database or Anyone who has seen SQL statements beyond SELECT and wants to know what these do.
Enroll now: Basic SQL CRUD
Summary
Title: Basic SQL CRUD
Price: $19.99
Average Rating: 4.67
Number of Lectures: 14
Number of Quizzes: 3
Number of Published Lectures: 14
Number of Published Quizzes: 3
Number of Curriculum Items: 17
Number of Published Curriculum Objects: 17
Original Price: $22.99
Quality Status: approved
Status: Live
What You Will Learn
- Creating and dropping tables and views in databases
- Inserting and deleting records into tables in databases
- Updating records in tables in databases
- Using transactions to minimize mistakes with database operations
- Basics of importing data into and exporting data out of databases
Who Should Attend
- Beginners with SQL (all platforms)
- People newly bestowed with access to make changes to tables in a database
- Anyone who has seen SQL statements beyond SELECT and wants to know what these do
Target Audiences
- Beginners with SQL (all platforms)
- People newly bestowed with access to make changes to tables in a database
- Anyone who has seen SQL statements beyond SELECT and wants to know what these do
The tools of business continue to change and grow. Long ago, paper and pencil replaced rote memory and more recently were themselves replaced by computers. Analysts used to work out calculations on calculators, then switched to spreadsheet applications, like Excel. Understanding SQL used to be a skill reserved for IT personnel; now, SQL is becoming an indispensable analytical tool in the modern workplace. Just like spreadsheets were once a tool known only to specialists but are now ubiquitous in the workplace, likewise SQL is beginning to become more accessible throughout organizations.
This course moves beyond the SELECT statement in SQL to basic constructions of creating and dropping database objects, importing into and exporting from the database, inserting into and deleting from the data tables, and updating the data. Many corporations require additional permissions in the database to allow someone to perform these operations, and as more and more analytics teams start working in databases, more businesspeople are being given these permissions.
I learned everything I know about SQL on the job, and so can you. After teaching for 10 years, I was pulled into IT at my first corporate position and have used SQL in every role since then. I know what it is like to learn a keyword for the first time, to start exploring its uses, to be shown tricks and techniques using it by others, and to eventually gain a deeper understanding of why it works the way it does. I have trained many others in SQL in companies large and small, including some Fortune 50 companies. I have compiled my experiences and curated from those lessons what I believe to be the important initial steps beyond simply selecting to share with you. I trust you will take this knowledge, and Spirit willing, share it with others.
If you have not yet reviewed Basic SQL SELECT in Udemy, look over that course first to make sure you are familiar with the material there. Understanding the SELECT statement and the various user interfaces in database systems will make this course that much easier to understand. When you are ready, please click on the first lecture in section 1, the starting point to work your way through this course.
Course Curriculum
Chapter 1: Introduction to SQL Statements and Objects
Lecture 1: What is CRUD?
Lecture 2: Brief Overview of SQL Statements
Lecture 3: Brief Overview of Database Objects
Chapter 2: Creating and Dropping
Lecture 1: Views
Lecture 2: Tables
Lecture 3: Transactions
Chapter 3: Populating Tables with Data
Lecture 1: Importing and Exporting Data
Lecture 2: Limiting Data Results
Lecture 3: Inserting and Deleting
Lecture 4: Updating
Lecture 5: More on Transactions
Lecture 6: Merging
Chapter 4: Conclusion
Lecture 1: Quick Summary
Lecture 2: Thank you and come again!
Instructors
-
Eric Manske
Collector and Curator of Knowledge
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 0 votes
- 3 stars: 0 votes
- 4 stars: 1 votes
- 5 stars: 2 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024